ALEX_COST_CENTER_REV_SEGMENT (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 |
| SEGMENT_NAME | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_REV_SEGMENT.SEGMENT_NAME | Segment name |
| SEGMENT_CODE | VARCHAR (60) | Yes* | Yes | ALCO_COST_CENTER_REV_SEGMENT.SEGMENT_CODE | Segment code |
| COST_CENTER_DESC | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_REV_SEGMENT.DESCRIPTION | Segment description |
| DEFAULT_REVIEWER_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_REV_SEGMENT.DEFAULT_REVIEWER_ID | Default reviewer ekey |
| ALTERNATE_REVIEWER_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_REV_SEGMENT.ALTERNATE_REVIEWER_ID | Alternate reviewer ekey |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_COST_CENTER_REV_SEGMENT.ACTIVE_STATUS | 1 = active, 0 = inactive |
*System required field
** Value must be unique