ALEX_DEPARTMENT (Staging table)

Column name Data type Required Default update able Data target Comments
EXTERNAL_KEY** VARCHAR (255) Yes* No ALCO_EXTERNAL_KEY.EXTERNAL_KEY External key – primary key
DEPARTMENT_CODE VARCHAR (60) Yes* Yes ALCO_DEPARTMENT.DEPARTMENT_CODE Department code
DEPARTMENT_NAME VARCHAR (255) Yes* Yes ALCO_DEPARTMENT.DEPARTMENT_NAME Name of department
DIVISION_EKEY VARCHAR (255) Yes* Yes ALCO_DEPARTMENT.DIVISION_ID External key of division to assign the department
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_DEPARTMENT.ACTIVE_STATUS Determines whether department is active.
  • 1 = Active
  • 0 = Inactive

*System required field

** Value must be unique