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