FAC BUILDING ADDRESS Table
Facilities Building/Address Info
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_CITY_ID |
XXX |
VARCHAR2 |
16 |
ADDRESS_PURPOSE |
XXX |
VARCHAR2 |
8 |
BUILDING |
XXX |
VARCHAR2 |
40 |
CITY |
City. |
VARCHAR2 |
35 |
IS_E911_ADDRESS |
XXX |
VARCHAR2 |
2 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
15 |
POST_DIRECTIONAL |
XXX |
VARCHAR2 |
16 |
PRE_DIRECTIONAL |
XXX |
VARCHAR2 |
16 |
STATE |
State. |
VARCHAR2 |
30 |
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 |
8 |