RETURN TO ADVANCEMENT META DATA REPORTS

CONSTITUENT - Report
Data Element Business Definition Data Type Source Name Source Data Element Form Name
PERSON_UID SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. APBCONS APBCONS_PIDM UNKNOWN
DONOR_IND FUNCTION F_DONOR_IND UNKNOWN
PROSPECT_IND INDICATES THIS PERSON IS A PROSPECT TO THIS INSTITUTION. FUNCTION F_PROSPECT_IND UNKNOWN
LOST_ALUMNUS_IND FUNCTION F_LOST_AL_IND UNKNOWN
PREF_LAST_NAME APBCONS APBCONS_PREF_LAST_NAME UNKNOWN
PREF_FIRST_NAME APBCONS APBCONS_PREF_FIRST_NAME UNKNOWN
PREF_MIDDLE_INITIAL APBCONS APBCONS_PREF_MI UNKNOWN
NICKNAME NAME TO BE USED FOR INFORMAL COMMUNICATION AND CORRESPONDENCE WITH THE PERSON. THIS IS EITHER THE PREFERRED FIRST NAME EITHER FROM THE ADVANCEMENT SECTION OR THE PERSON SEGMENTS OF THE SOFTWARE. APBCONS APBCONS_NICKNAME UNKNOWN
GRADUATION_NAME OFFICIAL_DOCUMENT_NAME APBCONS APBCONS_GRAD_NAME UNKNOWN
PARENTS_NAME APBCONS APBCONS_PARENTS_NAME UNKNOWN
MAIDEN_LAST_NAME APBCONS APBCONS_MAIDEN_LAST_NAME UNKNOWN
MARITAL_STATUS MARITAL STATUS CODE OF THE PERSON. NA NOT AVAILABLE UNKNOWN
CONFIDENTIALITY_IND SPECIFIES WHETHER OR NOT THE PERSON HAS REQUESTED THAT INFORMATION ABOUT THEM BE KEPT CONFIDENTIAL. NA NOT AVAILABLE UNKNOWN
DECEASED_IND NA NOT AVAILABLE UNKNOWN
SPOUSE_NAME SPECIFIES THE REVERSE OF THE INITIAL REFERENCE FUNCTION NOT AVAILABLE UNKNOWN
NAME_PREFIX PREFIX OF THE PERSON'S NAME. NA NOT AVAILABLE UNKNOWN
NAME_SUFFIX SUFFIX OF THE PERSON'S NAME. NA NOT AVAILABLE UNKNOWN
PREF_CLASS APBCONS APBCONS_PREF_CLAS UNKNOWN
PREF_CLASS_DESC STVCLAS STVCLAS_DESC UNKNOWN
PREF_COLLEGE FIRST LAYER OF THE INSTITUTION ORGANIZATION. APBCONS APBCONS_COLL_CODE_PREF UNKNOWN
PREF_COLLEGE_DESC NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. STVCOLL STVCOLL_DESC UNKNOWN
PREF_DONOR_CATEGORY APRCATG APRCATG_DONR_CODE UNKNOWN
PREF_DONOR_CATEGORY_DESC ATVDONR ATVDONR_DESC UNKNOWN
DONOR_CATEGORY_COUNT NUMBER OF DONOR CATEGORIES RECORDED FOR THE PERSON. FUNCTION ? UNKNOWN
HOMETOWN APBCONS APBCONS_HOME_CITY UNKNOWN
HOMETOWN_STATE APBCONS APBCONS_STAT_CODE_HOME UNKNOWN
HOMETOWN_STATE_DESC NAME OF THE STATE/PROVINCE FOR THIS RECORD. STVSTAT STVSTAT_DESC UNKNOWN
HOMETOWN_NATION APBCONS APBCONS_NATN_CODE_HOME UNKNOWN
HOMETOWN_NATION_DESC DESCRIPTION FOR THE NATION/COUNTRY ASSOCIATED WITH THE ADDRESS. STVNATN STVNATN_NATION UNKNOWN
OCCUPATIONAL_TITLE APBCONS APBCONS_DOTT_CODE UNKNOWN
OCCUPATIONAL_TITLE_DESC ATVDOTT ATVDOTT_DESC UNKNOWN
INCOME_LEVEL APBCONS APBCONS_INCM_CODE UNKNOWN
INCOME_LEVEL_DESC ATVINCM ATVINCM_DESC UNKNOWN
SOCIETY_NAME APBCONS APBCONS_SOCIETY_NAME UNKNOWN
COMBINED_MAILING_NAME APBCONS APBCONS_CM_NAME UNKNOWN
COMB_MAILING_ADDR_TYPE APBCONS APBCONS_ATYP_CODE_CM UNKNOWN
COMB_MAILING_ADDR_TYPE_DESC STVATYP STVATYP_DESC UNKNOWN
ADDRESS_NAME SEQUENCE OF THE ADDRESSES STORED FOR THIS TYPE OF ADDRESS. APBCONS APBCONS_ADDR_NAME UNKNOWN
PREF_ADDR_TYPE APBCONS APBCONS_ATYP_CODE_PREF UNKNOWN
PREF_ADDR_TYPE_DESC STVATYP STVATYP_DESC UNKNOWN
PREF_ADDR_TYPE_GEOR APBCONS APBCONS_ATYP_CODE_GEOR UNKNOWN
PREF_ADDR_TYPE_GEOR_DESC STVATYP STVATYP_DESC UNKNOWN
ADDRESS_COUNT NUMBER OF ADDRESSES RECORDS FOR THIS PERSON OR ENTITY. FUNCTION F_COUNT_ADDRESSES UNKNOWN
PHONE_COUNT COUNT OF TELEPHONE NUMBER RECORDS FOR THIS PERSON OR ENTITY. FUNCTION F_COUNT_TELEPHONES UNKNOWN
SPOUSE_IND SPECIFIES THE REVERSE OF THE INITIAL REFERENCE FUNCTION NOT AVAILABLE UNKNOWN
DEGREE_COUNT NUMBER OF AWARD OR DEGREE RECORDS FOR THE PERSON. FUNCTION ? UNKNOWN
EMPLOYMENT_COUNT NUMBER OF EMPLOYEE HISTORY RECORDS FOR THE PERSON. FUNCTION ? UNKNOWN
CHILD_COUNT NUMBER OF CHILD CROSS REFERENCE RECORDS FOR THE PERSON. USE (C.PERSON_UID, 'C'). MAKFUNC F_COUNT_RELATION UNKNOWN
SPECIAL_PURPOSE_GROUP_COUNT NUMBER OF SPECIAL PURPOSE GROUPS TO WHICH THE PERSON IS ASSIGNED. FUNCTION ? UNKNOWN
MAIL_COUNT NUMBER OF CORRESPONDENCE OR MAIL SENT TO THE PERSON. FUNCTION ? UNKNOWN
EXCLUSION_COUNT NUMBER OF TYPES OF CONTACTS FROM WHICH THE PERSON IS TO BE EXCLUDED. FUNCTION ? UNKNOWN
SPECIAL_ACTIVITY_COUNT NUMBER OF SPECIAL ACTIVITIES THE PERSON HAS PARTICIPATED. FUNCTION ? UNKNOWN
CROSS_REFERENCE_COUNT NUMBER OF CROSS REFERENCE PERSON OR ORGANIZATION_ENTITY RECORDS FOR THE PERSON OR ORGANIZATION_ENTITY. FUNCTION ? UNKNOWN
EXTERNAL_SOURCE_COUNT NUMBER OF EXTERNAL SOURCE RECORDS FOR THE PERSON. FUNCTION ? UNKNOWN
LIFE_TOTAL_GIVING FUNCTION F_LIFE_TOTAL_GIVING UNKNOWN
MOST_RECENT_GIFT_DATE FUNCTION F_MOST_RECENT_GIFT_AMOUNT UNKNOWN
MOST_RECENT_GIFT_AMT FUNCTION F_MOST_RECENT_GIFT_AMOUNT UNKNOWN
LIFE_TOTAL_PLEDGE_AMT FUNCTION F_LIFE_TOTAL_PLEDGED_AMOUNT UNKNOWN
MOST_RECENT_PLEDGE_DATE FUNCTION F_MOST_RECENT_PLEDGE_AMOUNT UNKNOWN
MOST_RECENT_PLEDGE_AMT FUNCTION F_MOST_RECENT_PLEDGE_AMOUNT UNKNOWN
LIFE_TOTAL_PLEDGE_PAY FUNCTION F_LIFE_TOTAL_PLEDGE_PAYMENT UNKNOWN
LIFE_GIFT_SOCIETY_TYPE FUNCTION F_LIFE_GIFT_SOCIETY UNKNOWN
LIFE_GIFT_SOCIETY_TYPE_DESC ATVDCST ATVDCST_DESC UNKNOWN
LIFE_GIFT_SOCIETY FUNCTION F_LIFE_GIFT_SOCIETY UNKNOWN
LIFE_GIFT_SOCIETY_DESC ATVDCNP ATVDCNP_DESC UNKNOWN
LIFE_TOTAL_COMMITMENT FUNCTION F_LIFE_TOTAL_COMMITMENT UNKNOWN
HIGHEST_GIFT_NUMBER NA NOT AVAILABLE UNKNOWN
HIGHEST_GIFT_AMOUNT AGBGHIS APBGHIS_HIGH_GIFT_AMT UNKNOWN
HIGHEST_GIFT_DATE AGBGHIS APBGHIS_HIGH_GIFT_DATE UNKNOWN
HIGHEST_GIFT_FISCAL_YEAR AGBGHIS APBGHIS_FISC_CODE_HIGH_GIFT UNKNOWN
HIGHEST_GIFT_FISCAL_YEAR_DESC NA NOT AVAILABLE UNKNOWN