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