PS_ADDRESSES_MV Table - Data Element Index   Tables and Data Elements   Advancement Home   Data Warehouse Home

PS_ADDRESSES_MV Table

Explanation
For individuals only, this table contains the most recent effective dated address (not necessarily active) by type.

Common Uses

Finding a constituent's home or business address.

EMPLID
ADDRESS_TYPE

      

ADDRESS_TYPE
CITY
COUNTRY
EFFDT
EMPLID
GEO_CODE
POSTAL
STATE

WHSE_CONSTITUENTS

• .The most recent address of a particular type may not be active. Be sure to check the status before using an address.

PS_ADDRESSES_MV Table - Data Element Index   Tables and Data Elements   Advancement Home   Data Warehouse Home