ALEX_OFFICE (Staging table)
| Column name | Data type | Required | Default updateable | Data target | Comments |
|---|---|---|---|---|---|
| EXTERNAL_KEY** | VARCHAR (255) | Yes* | No | ALCO_EXTERNAL_KEY.EXTERNAL_KEY | External key – primary key |
| OFFICE_CODE | VARCHAR (40) | Yes* | Yes | ALCO_OFFICE.OFFICE_CODE | Office code |
| OFFICE_NAME | VARCHAR (255) | Yes* | Yes | ALCO_OFFICE.OFFICE_NAME | Office name |
| LOCATION_EKEY | VARCHAR (255) | No | Yes | ALCO_OFFICE.LOCATION_ID | Office location external key |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_OFFICE.ACTIVE_STATUS | Determines whether office is active
|
*System required field
** Value must be unique