--order 502687     
      /*
      CHANGE REPORT for Table CONTACTPERSON
          - Adding column ACTIVE
      ACTION is ALTER or modify Table CONTACTPERSON
      */

ALTER TABLE CONTACTPERSON ADD (ACTIVE               VARCHAR2(1) DEFAULT 'Y' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew194
                                          CHECK (ACTIVE IN ('Y', 'N')));

