      
ALTER TABLE REASONCODE ADD (REASONGROUP          VARCHAR2(20) NULL);

CREATE INDEX XIE1REASONCODE ON REASONCODE
(
       REASONGROUP                    
);

    
      /*
      CHANGE REPORT for Table GDTRANSACTION
          - Changing column definition of GDTRANSCTIONTYPE
          - Adding column OLD_ADMINNUMBER
          - Adding column OLD_GDCODE
      ACTION is ALTER or modify Table GDTRANSACTION
      */


ALTER TABLE GDTRANSACTION ADD (OLD_ADMINNUMBER      VARCHAR2(10) NULL);


ALTER TABLE GDTRANSACTION ADD (OLD_GDCODE           VARCHAR2(6) NULL);


      
      /*
      CHANGE REPORT for Table CONTACT
          - Adding a new relationship CONTACT_STOP_ID
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK CONTACT_STOP_ID of table CONTACT, which references table STOP).
          - Adding column STOP_ID
          - Adding index XIF8CONTACT
      ACTION is ALTER or modify Table CONTACT
      */

ALTER TABLE CONTACT ADD (STOP_ID              NUMBER NULL);

CREATE INDEX XIF9CONTACT ON CONTACT
(
       STOP_ID                        ASC
);

      
      /*
      CHANGE REPORT for Table PROOFOFVISITHISTORY
          - Adding a new relationship PROOFOFVISITHISTORY_STOP_ID
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK PROOFOFVISITHISTORY_STOP_ID of table PROOFOFVISITHISTORY, which references table STOP).
          - Adding column STOP_ID
          - Adding index XIF2PROOFOFVISITHISTORY
      ACTION is ALTER or modify Table PROOFOFVISITHISTORY
      */

ALTER TABLE PROOFOFVISITHISTORY ADD (STOP_ID              NUMBER NULL);

CREATE INDEX XIF2PROOFOFVISITHISTORY ON PROOFOFVISITHISTORY
(
       STOP_ID                        ASC
);


ALTER TABLE CONTACT
       ADD  ( CONSTRAINT CONTACT_STOP_ID
              FOREIGN KEY (STOP_ID)
                             REFERENCES STOP ) ;


ALTER TABLE PROOFOFVISITHISTORY
       ADD  ( CONSTRAINT PROOFOFVISITHISTORY_STOP_ID
              FOREIGN KEY (STOP_ID)
                             REFERENCES STOP ) ;