FCLT BUILDING ADDRESS Table
View exposing facilities building address detail including street-address components, city, state, postal code, and related building identifiers.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_CITY_ID |
Address city id associated with the record. |
VARCHAR2 |
16 |
ADDRESS_PURPOSE |
Address purpose associated with the record. |
VARCHAR2 |
8 |
BUILDING_NUMBER |
Building number associated with the record. |
VARCHAR2 |
8 |
CITY |
City associated with the record. |
VARCHAR2 |
16 |
FCLT_BUILDING_ADDRESS_KEY |
Fclt building address key associated with the record. |
VARCHAR2 |
16 |
FCLT_BUILDING_KEY |
Surrogate key identifying the fclt building. |
VARCHAR2 |
8 |
IS_E911_ADDRESS |
Is e911 address associated with the record. |
VARCHAR2 |
1 |
POSTAL_CODE |
Postal code associated with the record. |
VARCHAR2 |
10 |
POST_DIRECTIONAL |
Post directional associated with the record. |
VARCHAR2 |
16 |
PRE_DIRECTIONAL |
Pre directional associated with the record. |
VARCHAR2 |
16 |
STATE |
State associated with the record. |
VARCHAR2 |
4 |
STREET_NAME |
Street name associated with the record. |
VARCHAR2 |
32 |
STREET_NUMBER |
Street number associated with the record. |
VARCHAR2 |
16 |
STREET_NUMBER_SUFFIX |
Street number suffix associated with the record. |
VARCHAR2 |
16 |
STREET_SUFFIX |
Street suffix associated with the record. |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |