SPACT ADDRESS Table
View exposing address detail for sponsored-access people keyed by source GUID including address lines, city, state, and postal code.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS1 |
Address1 associated with the record. |
VARCHAR2 |
765 |
ADDRESS2 |
Address2 associated with the record. |
VARCHAR2 |
765 |
CITY |
City associated with the record. |
VARCHAR2 |
150 |
POSTAL_CODE |
Postal code associated with the record. |
VARCHAR2 |
15 |
STATE |
State associated with the record. |
VARCHAR2 |
150 |
VCS_GUID |
Vcs guid associated with the record. |
VARCHAR2 |
150 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |