ALEX_ADC_FLEX_2 (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 |
| NAME | VARCHAR (255) | Yes | No | ALCO_ADC_FLEX_2.NAME | The display name |
| CODE | VARCHAR (255) | No | No | ALCO_ADC_FLEX_2.CODE | A code to identify the data |
| ACTIVE_STATUS | SMALLINT | Yes | Yes | ALCO_ADC_FLEX_2.ACTIVE | The active status |