Main table for constituents (note does not include groups, committees or households)
Note: Atlas pics from the Personal Info tab have been added to the BBDW. See BBDW.DIM_CONSTITUENT_EXT table for fields PICTURE and PICTURETHUMBNAIL. These can be pulled into SSRS reports just confirm that the properties for the field match those below.
| Column | Comments |
|---|---|
| CONSTITUENTDIMID | |
| PARTNERSID | |
| CONSTITUENTSYSTEMID | |
| LOOKUPID | |
| HOUSEHOLDDIMID | |
| ISPRIMARYHOUSEHOLDMEMBER | |
| SPOUSECONSTITUENTDIMID | |
| KEYINDICATOR | |
| CLASSIFICATION | |
| PRIMARYCONSTITUENTCODE | |
| TITLE | |
| FIRSTNAME | |
| MIDDLENAME | |
| LASTNAME | |
| SUFFIX | |
| MAIDENNAME | |
| NICKNAME | |
| SORTNAME | |
| INDIVIDUALFORMALADDRESSEE | |
| INDIVIDUALFORMALSALUTATION | |
| INDIVIDUALINFORMALADDRESSEE | |
| INDIVIDUALINFORMALSALUTATION | |
| SPOUSEINDIVIDUALFORMALADDRESSEE | |
| SPOUSEINDIVIDUALFORMALSALUTATION | |
| SPOUSEINDIVIDUALINFORMALADDRESSEE | |
| SPOUSEINDIVIDUALINFORMALSALUTATION | |
| SPOUSESORTNAME | |
| HOUSEHOLDFORMALADDRESSEE | |
| HOUSEHOLDFORMALSALUTATION | |
| HOUSEHOLDINFORMALADDRESSEE | |
| HOUSEHOLDINFORMALSALUTATION | |
| PRIMARYCONTACTDIMID | |
| PRIMARYCONTACTNAME | |
| PRIMARYCONTACTPOSITION | Pulls from ph_v_constituentrelationship - if position is blank then uses jobtitle |
| PRIMARYEMPLOYMENTPOSITION | |
| PRIMARYEMPLOYMENTEMPLOYER | |
| PRIMARYADDRESS | The address data here is the primary address - even if this address is coded as do not mail or is marked confidential. See ph_v_constituentaddress for details on each address |
| PRIMARYADDRESS1 | |
| PRIMARYADDRESS2 | |
| PRIMARYADDRESS3 | |
| PRIMARYADDRESS4 | |
| PRIMARYADDRESS5 | |
| PRIMARYCITY | |
| PRIMARYSTATE | |
| PRIMARYSTATEABBREVIATION | |
| PRIMARYPOSTCODE | |
| PRIMARYCOUNTRY | |
| PRIMARYCSZ | |
| PRIMARYEMAIL | Primary email - even if this email is coded as do not email |
| PRIMARYPHONE | Primary phone even if this phone is coded as do not use |
| GENDER | |
| MARITALSTATUS | |
| BIRTHDATE | |
| AGE | |
| ISANONYMOUS | |
| ISINACTIVE | |
| ISFUNDRAISER | |
| HASMRN | |
| ISMATCHINGCOMPANY | |
| ISDECEASED | |
| DECEASEDDATE | |
| PROSPECTSTATUS | |
| ISASSIGNED | |
| NOVALIDADDRESS | |
| HASUNSUBSCRIBED | |
| NOVALIDEMAIL | |
| PMGRCONSTITUENTDIMID | |
| PMGRSORTNAME | |
| PMGRINFORMALNAME | |
| APMGRCONSTITUENTDIMID | |
| APMGRSORTNAME | |
| APMGRINFORMALNAME | |
| PRIMARYRATING | |
| SHORTESTDISTANCETOMAINCAMPUS | |
| LASTEVENTATTENDEDDATE | |
| INVITEDEVENTCOUNT | |
| ATTENDEDEVENTCOUNT | |
| DATEADDED | |
| DATEADDEDDIMID | |
| DATECHANGED | |
| DATECHANGEDDIMID | |
| MRN | |
| FULLNAME | |
| PRIMARYCONTACTEMAIL | |
| SORTKEY |