ALEX_COST_CENTER_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_SEGMENT.SEGMENT_NAME Segment name
SEGMENT_CODE VARCHAR(60) Yes* Yes ALCO_COST_CENTER_SEGMENT.SEGMENT_CODE Segment code
SEGMENT_INDEX INTEGER Yes* Yes ALCO_COST_CENTER_SEGMENT.SEGMENT_INDEX Segment index
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_COST_CENTER_SEGMENT.ACTIVE_STATUS
  • 1 = active
  • 0 = inactive