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.
  • 1 = Active
  • 0 = Inactive
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