ALEX_COST_CENTER (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 |
| COST_CENTER_CODE | VARCHAR (60) | Yes | Yes | ALCO_COST_CENTER.COST_CENTER_CODE | Cost center code |
| DEPARTMENT_EKEY | VARCHAR (255) | Yes | Yes | ALCO_COST_CENTER.DEPARTMENT_ID | External key of department to assign cost center to |
| COST_CENTER_NAME | VARCHAR (255) | Yes | Yes | ALCO_COST_CENTER.COST_CENTER_NAME | Name of cost center |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_COST_CENTER.ACTIVE_STATUS | Determines if this code segment is active.
|
| COST_CENTER_DESC | VARCHAR (255) | No | Yes | ALCO_COST_CENTER.COST_CENTER_DESCRIPTION | Description of cost center |
| DEFAULT_REVIEWER_USER_EKEY | VARCHAR (255) | Yes | Yes | ALCO_COST_CENTER.DEFAULT_REVIEWER_ID | External key of default cost center reviewer user |
| ALT_DEFAULT_REVIEWER_USER_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER.ALTERNATE_REVIEWER_ID | External key of alternate cost center reviewer user |
| REVIEW_SEGMENT_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_REV_SEGMENT.REVIEW_SEGMENT_ID | External key of cost center review segment |
| SEGMENT1_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT2_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT3_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT4_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT5_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT6_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT7_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT8_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
| SEGMENT9_EKEY | VARCHAR (255) | No | Yes | ALCO_COST_CENTER_SEGMENT.SEGMENT_ID | External key of cost center segment |
* System required field
** Value must be unique