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

WHSE_CONSTITUENTS Table

Explanation
This is the primary reporting table for all constituents, combining both individuals and organizations into a single structure. It includes a constituent's preferred address, preferred name, salutation, ability rating, spouse info, etc. One row per COMMON_ID.

Common Uses

This table will be used in almost every report that reveals constituent specific data.

COMMON_ID

COMMON_ID
COUNTRY
DONOR_ID
DONOR_SRC
EMPLID
EXT_ORG_ID
NO_MAIL_FLAG
PM_REGION_CD
PREFERRED_ADDRESS_TYPE
REGION_CD
SPOUSE_EMPLID
STATE
STATE_REGION_CD

 

All Tables

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