ALEX_LICENSE (Staging table)

Column name Data type Required Default update able Data target Comments
EXTERNAL_KEY** VARCHAR (255) Yes* No ALCO_EXTERNAL_KEY.EXTERNAL_KEY External key - primary key
NAME VARCHAR (255) Yes* No ALCO_LICENSE_TYPE.NAME The display name
CODE VARCHAR (255) No No ALCO_LICENSE_TYPE.CODE A code to identify the license type
ACTIVE_STATUS SMALLINT Yes* No ALCO_LICENSE_TYPE.ACTIVE_STATUS The active status