FCLT BUILDING ADDRESS HIST Table
View exposing historical facilities building address records used for facilities reporting and historical analysis.
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_HIST_KEY |
Fclt building address hist key associated with the record. |
VARCHAR2 |
117 |
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 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
100 |
IS_E911_ADDRESS |
Is e911 address associated with the record. |
VARCHAR2 |
2 |
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 |