| Data element |
Definition |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Unique identifier for individual (non-org) records. |
CAMPUS_ID
Indexed - No
Format - VARCHAR2
Nullable - Yes | Id that appears on PennCard; not available for all records. |
SORT_NAME
Indexed - No
Format - VARCHAR2
Nullable - Yes | Name field formatted with the last name first for sorting purposes. |
SALUTATION
Indexed - No
Format - VARCHAR2
Nullable - Yes | Primary salutation from PS_UP_SALUTATIONS. |
NAME
Indexed - No
Format - VARCHAR2
Nullable - Yes | Name field (format ex. Mr. John Smith) |
FIRST_NAME
Indexed - No
Format - VARCHAR2
Nullable - Yes | First name from the primary name row in PS_NAMES_MV |
LAST_NAME
Indexed - No
Format - VARCHAR2
Nullable - Yes | Last name from the primary name row in PS_NAMES_MV |
BUSINESS_TITLE
Indexed - No
Format - VARCHAR2
Nullable - Yes | Most recent valid business title (ex. CEO) |
EMPLOYER
Indexed - No
Format - VARCHAR2
Nullable - Yes | Most recent valid employer name (ex. IBM) |
COUNTRY
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Three digit country abbreviation (ex. 'USA') |
COUNTRY_LONG
Indexed - No
Format - VARCHAR2
Nullable - Yes | Description of Country field (ex. Canada) |
ADDRESS1
Indexed - No
Format - VARCHAR2
Nullable - Yes | Address line 1. In a business address row, this field will often house the business name. |
ADDRESS2
Indexed - No
Format - VARCHAR2
Nullable - Yes | Address line 2. In a business address row, this field occasionally house the business name. |
ADDRESS3
Indexed - No
Format - VARCHAR2
Nullable - Yes | Address line 3 |
ADDRESS4
Indexed - No
Format - VARCHAR2
Nullable - Yes | Address line 4 |
CITY
Indexed - No
Format - VARCHAR2
Nullable - Yes | City description |
STATE
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Two digit state code (ex. PA) |
POSTAL
Indexed - No
Format - VARCHAR2
Nullable - Yes | Zip code - formatted (if domestic nine-digits, then xxxxx-xxxx). |
PHONE_TYPE
Indexed - No
Format - VARCHAR2
Nullable - Yes | Preferred phone number type (ex. 'HOM1' for first home phone). |
PHONE_COUNTRY_CODE
Indexed - No
Format - VARCHAR2
Nullable - Yes | |
PHONE_NUMBER
Indexed - No
Format - VARCHAR2
Nullable - Yes | Preferred phone number |
GENDER
Indexed - No
Format - VARCHAR2
Nullable - Yes | One digit gender code: M = Male, F = Female, U = Unknown |
ETHNIC_GROUP
Indexed - No
Format - VARCHAR2
Nullable - Yes | One digit ethnic group code (ex. '1' = White). |
MAR_STATUS
Indexed - No
Format - VARCHAR2
Nullable - Yes | One digit marital status code (ex. 'D' = Divorced). |
SPOUSE_EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Emplid of living, partnered spouse. This field shouldn't be populated if the spouse has died,"
|
SPOUSE_NAME
Indexed - No
Format - VARCHAR2
Nullable - Yes | Preferred name of living, partnered spouse. This field shouldn't be populated if the spouse has died,"
|
BIRTHDATE
Indexed - No
Format - DATE
Nullable - Yes | Date of birth |
DT_OF_DEATH
Indexed - No
Format - DATE
Nullable - Yes | Date of death |
DECEASED_FLAG
Indexed - No
Format - CHAR
Nullable - Yes | If the individual is deceased, this field will equal 'Y'. |
AFFILIATION
Indexed - No
Format - VARCHAR2
Nullable - Yes | Concatenated text string of all Penn schools attended along with the graduation year (ex. 'ENG02 WG05'"
|
REGION_CD
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Four digit geographic region code defined by Penn Development (ex. HY02 = New York City), corresponding wit"
|
STATE_REGION_CD
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | State region, derived from preferred address. |
PM_REGION_CD
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Prospect Manager Region code, defined by Penn Development (ex. 'PPH' = Philadelphia region - inclu"
|
DONOR_SRC
Indexed - Yes
Format - CHAR
Nullable - Yes | Old system equivalent of "Constituent Type": no longer being updated in ATLAS. |
DONOR_ID
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | SSN - when combined with donor_src, used in old system as unique id. |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | unique identifier for org (non-individual) records |
ID_TYPE
Indexed - No
Format - VARCHAR2
Nullable - Yes | P' for individual records, 'O' for organization records. |
EXT_ORG_TYPE
Indexed - No
Format - VARCHAR2
Nullable - Yes | Type of organization (not populated in individual records). Ex. 'CORP' = Corporation. |
NO_MAIL_FLAG
Indexed - Yes
Format - CHAR
Nullable - Yes | Set = 'Y' when person has mail / contact keepoff exclusion. Note: Not everyone with a 'UNI 1000' all"
|
PREFERRED_ADDRESS_TYPE
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Flags the preferred address type (home, business, seasonal, etc.) A"
|
EMAIL_ADDRESS
Indexed - No
Format - VARCHAR2
Nullable - Yes | Primary email address |
ADDRESS_STATUS
Indexed - No
Format - VARCHAR2
Nullable - Yes | Status of preferred address ('A' = Active, 'I' = Inactive) |
ABILITY_RATING
Indexed - No
Format - VARCHAR2
Nullable - Yes | Current giving ability rating, as defined by Development (ex. 'ABIL-B'). |
UNIT_ASSIGNED
Indexed - No
Format - VARCHAR2
Nullable - Yes | Unit to which the prospect has been assigned (one unit per individual). Former 'paac' area. | SPOUSE_AFFILIATION
Indexed - No
Format - VARCHAR2
Nullable - Yes | Affiliation string of living, partnered spouse. This field shouldn't be populate"
|
JC_ID
Indexed - No
Format - NUMBER
Nullable - Yes | Joint communications unique identifier (one per couple) |
JC_NAME
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications name (name of both partners) |
JC_ADDRESS1
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications address line 1(the couple's assigned joint mailing address) |
JC_ADDRESS2
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications address line 2 (the couple's assigned joint mailing address) |
JC_ADDRESS3
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications address line 3 (the couple's assigned joint mailing address) |
JC_ADDRESS4
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications address line 4(the couple's assigned joint mailing address) |
JC_CITY
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications city (the couple's assigned joint mailing address) |
JC_STATE
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications state (the couple's assigned joint mailing address) |
JC_POSTAL
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications postal code / zip code (the couple's assigned joint mailing address) |
JC_COUNTRY
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications country code (the couple's assigned joint mailing address) |
JC_COUNTRY_LONG
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications country description (the couple's assigned joint mailing address) |
JC_SALUTATION
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications salutation (ex. Mr. and Mrs. Thompson) |
COMMON_ID
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Created by Penn for data warehouse reporting, this is the unique identifier for both individuals and organi"
|
PRI_CNST_TYPE
Indexed - No
Format - NUMBER
Nullable - Yes | Primary constituent type code (ex. '1') |
PRI_CNST_DESCR
Indexed - No
Format - VARCHAR2
Nullable - Yes | Primary constituent type description (ex. 'Alumni') |
"
JC_SALUTATION
Indexed - No
Format - VARCHAR2
Nullable - Yes | Joint communications salutation (ex. Mr. and Mrs. Thompson) |
COMMON_ID
Indexed - Yes
Format - VARCHAR2
Nullable - Yes | Created by Penn for data warehouse reporting, this is the unique identifier for both individuals and organi"
|
PRI_CNST_TYPE
Indexed - No
Format - NUMBER
Nullable - Yes | Primary constituent type code (ex. '1') |
PRI_CNST_DESCR
Indexed - No
Format - VARCHAR2
Nullable - Yes | Primary constituent type description (ex. 'Alumni') |
