FCLT BUILDING ADDRESS HIST Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_CITY_ID |
XXX |
VARCHAR2 |
16 |
ADDRESS_PURPOSE |
XXX |
VARCHAR2 |
8 |
BUILDING_NUMBER |
The official MIT number given to a building. For example: N42, E19, W89 |
VARCHAR2 |
8 |
CITY |
City. |
VARCHAR2 |
16 |
FCLT_BUILDING_ADDRESS_HIST_KEY |
XXX |
VARCHAR2 |
117 |
FCLT_BUILDING_ADDRESS_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_BUILDING_KEY |
XXX |
VARCHAR2 |
8 |
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
100 |
IS_E911_ADDRESS |
XXX |
VARCHAR2 |
2 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
10 |
POST_DIRECTIONAL |
XXX |
VARCHAR2 |
16 |
PRE_DIRECTIONAL |
XXX |
VARCHAR2 |
16 |
STATE |
State. |
VARCHAR2 |
4 |
STREET_NAME |
XXX |
VARCHAR2 |
32 |
STREET_NUMBER |
XXX |
VARCHAR2 |
16 |
STREET_NUMBER_SUFFIX |
XXX |
VARCHAR2 |
16 |
STREET_SUFFIX |
XXX |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |