ALEX_JOB_CLASSIFICATION (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 |
| NAME** | VARCHAR (100) | Yes* | Yes | ALCO_JOB_CLASSIFICATION.NAME | The name of the job classification |
| DESCRIPTION | VARCHAR (255) | No | Yes | ALCO_JOB_CLASSIFICATION.DESCRIPTION | Description of the job classification |
| CODE* | VARCHAR (50) | Yes* | Yes | ALCO_JOB_CLASSIFICATION.CODE | Internal use |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_JOB_CLASSIFICATION.ACTIVE_STATUS | Determines whether the job classification is active
|
*System required field
** Value must be unique