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.
|