ALEX_IMPORT_FLEX_DDLB_15 (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
FLEX_DDLB_CODE VARCHAR(255) No No ALER_FLEX_DDLB_10.FLEX_DDLB_CODE Flex field code
FLEX_DDLB_VALUE VARCHAR(255) No No ALER_FLEX_DDLB_10.FLEX_DDLB_VALUE Flex field value
USER_ID INT No No ALER_FLEX_DDLB_10.USER_ID Flex field user
ACTIVE_STATUS SMALLINT Yes Yes ALER_FLEX_DDLB_10.ACTIVE_STATUS

* System required field

** Value must be unique