FAC BUILDING ADDRESS Table
View exposing facilities building address detail including purpose, E911 indicator, street-address components, city, state, postal code, and related building keys.
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 |
CITY |
City associated with the record. |
VARCHAR2 |
16 |
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 |