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