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
GUEST_EKEY VARCHAR (255)T No No ALCO_LICENSE.GUEST_ID The guest for which the license was issued.
LICENSE_TYPE_EKEY_EKEY VARCHAR (255) No No ALCO_LICENSE.LICENSE_TYPE_ID The type of license
ADDRESS_EKEY VARCHAR (255) No No ALCO_LICENSE.ADDRESS_ID The address of agency that issued the license.
LICENSE_NUMBER VARCHAR (255) Yes* No ALCO_LICENSE.LICENSE_NUMBER The license number
DETAIL VARCHAR (255) No No ALCO_LICENSE.DETAIL Additional details of the license
START_DATE DATETIME No No ALCO_LICENSE.START_DATE The start date for which the license is valid.
END_DATE DATETIME No No ALCO_LICENSE.END_DATE The end date for which the license is valid.
ACTIVE_STATUS SMALLINT Yes No ALCO_LICENSE.ACTIVE_STATUS The active status