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.
|
*System required field
** Value must be unique