ALEX_GUEST_ADDRESS_WRAP (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
GUESTLIST_EKEY VARCHAR (255) Yes* Yes ALCO_GUEST.GUEST_ID External key of guest
ADDRESS_EKEY VARCHAR (255) Yes* Yes ALCO_ADDRESS.ADDRESS_ID Externalkey of address
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_ADDRESS.ACTIVE_STATUS

Determines whether the address is active.

  • 1 = Active
  • 0 = Inactive