ALEX_OCCUPATION (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_OCCUPATION.NAME The display name
CODE VARCHAR (255) No No ALCO_OCCUPATION.CODE A code to identify the occupation
ACTIVE_STATUS SMALLINT Yes* No ALCO_OCCUPATION.ACTIVE_STATUS The active status