/*ORDER 502275*/
/*old EnlargedLegacyDepartmentCode_order502275.sql*/

      /*
      CHANGE REPORT for Table DEPARTMENT
          - change datatype from VARCHAR2(6) to VARCHAR2(12) of column LEGACYDEPARTMENTCODE
      ACTION is ALTER or modify Table DEPARTMENT
      */

ALTER TABLE DEPARTMENT MODIFY (LEGACYDEPARTMENTCODE VARCHAR2(12));

      /*
      CHANGE REPORT for Table DEPARTMENT_LINK
          - change datatype from VARCHAR2(6) to VARCHAR2(12), change unknown attribute from 2 to (empty), change unknown attribute from 18 to (empty) of column LEGACYDEPARTMENTCODE
      ACTION is ALTER or modify Table DEPARTMENT_LINK
      */

ALTER TABLE DEPARTMENT_LINK MODIFY (LEGACYDEPARTMENTCODE VARCHAR2(12));
