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