ALEX_LOCATION (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 |
| COUNTRY_EKEY | VARCHAR (255) | Yes* | Yes | ALCO_LOCATION.COUNTRY_ID | Country external key |
| STATE_EKEY | VARCHAR (255) | No | Yes | ALCO_LOCATION.STATE_ID | State external key |
| COUNTY_EKEY | VARCHAR (255) | No | Yes | ALCO_LOCATION.COUNTY_ID | County external key |
| CITY_NAME | VARCHAR (255) | No | Yes | ALCO_LOCATION.CITY_NAME | City name |
| SUBURB_NAME | VARCHAR (255) | No | Yes | ALCO_LOCATION.SUBURB_NAME | Suburb name |
| STREET_NAME | VARCHAR (255) | No | Yes | ALCO_LOCATION.STREET_NAME | Street name |
| EST_CAR_TAX | FLOAT | No | Yes | ALCO_LOCATION_TAX.EST_CAR_TAX | Car rental tax |
| EST_HOTEL_TAX | FLOAT | No | Yes | ALCO_LOCATION_TAX.EST_HOTEL_TAX | Hotel tax |
| TAX_PERCENTAGE | FLOAT | No | Yes | ALCO_LOCATION_TAX.TAX_PERCENTAGE | Tax percentage |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_LOCATION.ACTIVE_STATUS | Determines whether location is active.
|
| POSTAL_CODE | VARCHAR (50) | No | Yes | ALCO_LOCATION.POSTAL_CODE | Postal code |
*System required field
** Value must be unique