ALEX_GUESTLIST (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* Yes ALCO_GUESTLIST.NAME Name of the guestlist
DESCRIPTION VARCHAR (255) No Yes ALCO_GUESTLIST.DESCRIPTION Guestlist description
ACTIVE_STATUS SMALLINT Yes Yes ALCO_GUESTLIST.ACTIVE_STATUS Determines whether this is active.
  • 1 = Active
  • 0 = Inactive