ALEX_DIVISION (Staging table)
| Column name | Data type | Required | Default updateable | Data target table | Comments |
|---|---|---|---|---|---|
| EXTERNAL_KEY** | VARCHAR (255) | Yes* | No | ALCO_EXTERNAL_KEY.EXTERNAL_KEY | External key – primary key |
| DIVISION_CODE | VARCHAR (60) | Yes* | Yes | ALCO_DIVISION.DIVISION_CODE | Division code |
| DIVISION_NAME | VARCHAR (255) | Yes* | Yes | ALCO_DIVISION.DIVISION_NAME | Name of division |
| COMPANY_EKEY | VARCHAR (255) | Yes* | Yes | ALCO_DIVISION.COMPANY_ID | External key of company to assign division to |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_DIVISION.ACTIVE_STATUS | Determines whether division is active.
1 = Active 0 = Inactive |
*System required field
** Value must be unique