RETURN TO ADVANCEMENT META DATA REPORTS

GIFT - Report
Data Element Business Definition Data Type Source Name Source Data Element Form Name
ENTITY_UID SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. AGRGDES AGRGDES_PIDM UNKNOWN
ENTITY_UID SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. AGRGMLT AGRGMLT_XREF_PIDM UNKNOWN
ENTITY_IND ENTITY INDICATOR IS SET TO 'P' IF IT IS FOR A CONSTITUENT RECORD AND SET TO 'O' IF IT IS AN ORGANIZATION_CONSTITUENT RECORD. DECODE WITHIN ODS UNKNOWN
DECEASED_STATUS IDENTIFIES IF THE PERSON IS DECEASED OR NOT. SPBPERS SPBPERS_DEAD_IND UNKNOWN
DECEASED_DATE DATE THE PERSON DIED. SPBPERS SPBPERS_DEAD_DATE UNKNOWN
GIFT_NUMBER AGRGDES AGRGDES_GIFT_NO UNKNOWN
GIFT_NUMBER AGRGMLT AGRGMLT_GIFT_NO UNKNOWN
PLEDGE_NUMBER AGRGDES/AGRGMLT AGRGDES_PLEDGE_NO UNKNOWN
CAMPAIGN AGRGDES/AGRGMLT AGRGDES_CAMPAIGN UNKNOWN
CAMPAIGN_NAME AFBCAMP AFBCAMP_NAME UNKNOWN
DESIGNATION AGRGDES AGRGDES_DESG UNKNOWN
DESIGNATION AGRGMLT AGRGMLT_DESG UNKNOWN
DESIGNATION_NAME ADBDESG ADBDESG_NAME UNKNOWN
RESTRICTED_IND ADBDESG ADBDESG_RESTR_IND UNKNOWN
GIFT_AMOUNT AGRGDES AGRGDES_AMT UNKNOWN
GIFT_CREDIT_AMOUNT FUNCTION NOT AVAILABLE UNKNOWN
GIFT_DATE AGBGIFT AGBGIFT_GIFT_DATE UNKNOWN
FISCAL_YEAR A UNIQUE NUMERIC IDENTIFIER CODE FOR THE FISCAL YEAR BEING DEFINED. FUNCTION RETURNS A FOUR-DIGIT YEAR WHEN SUPPLIED A TWO-DIGIT YEAR. AGBGIFT AGBGIFT_FISC_CODE UNKNOWN
FISCAL_YEAR_DESC ATVFISC ATVFISC_DESC UNKNOWN
GIFT_TYPE AGBGIFT AGBGIFT_GIFT_CODE UNKNOWN
GIFT_TYPE_DESC ATVGIFT ATVGIFT_DESC UNKNOWN
GIFT_CLASS AGBGIFT AGBGIFT_GCLS_CODE UNKNOWN
GIFT_CLASS_DESC ATVGCLS ATVGCLS_DESC UNKNOWN
GIFT_VEHICLE AGBGIFT AGBGIFT_PGVE_CODE UNKNOWN
GIFT_VEHICLE_DESC ATVPGVE ATVPGVE_DESC UNKNOWN
MATCHING_GIFT FUNCTION F_MATCHING_GIFT UNKNOWN
MATCHING_GIFT_RECEIVED AGBGIFT AGBGIFT_MATCH_RECEIVED UNKNOWN
POSTING_DATE DATE TRANSACTION WAS PROCESSED AND POSTED IN FINANCE. AGBGIFT AGBGIFT_FEED_DATE UNKNOWN
POST_BATCH_ID AGBGIFT AGBGIFT_FEED_DOC_CODE UNKNOWN
POST_CASHIER UNIQUE USER ID OF THE CASHIER WHO ENTERED THE TRANSACTION. AGBGIFT AGBGIFT_USER UNKNOWN
ENTRY_DATE DATE THE TRANSACTION WAS ENTERED ON THE ACCOUNT. AGBGIFT AGBGIFT_ENTRY_DATE UNKNOWN
GIFT_DEBIT_ACCOUNT_NUMBER ATVGIFT ATVGIFT_DB_GL_ACCT UNKNOWN
GIFT_RULE_CLASS ATVGIFT ATVGIFT_RUCL_CODE UNKNOWN
GIFT_RULE_CLASS_DESC FTVRUCL FTVRUCL_CLASS_TITLE UNKNOWN
GIFT_VSE ATVGIFT ATVGIFT_CFAE_GIFT_CATG UNKNOWN
GIFT_VSE_DESC ATVCFAE ATVCFAE_DESC UNKNOWN
GIFT_COMMENT AGBGIFT AGBGIFT_COMMENT UNKNOWN
CAMPAIGN_TYPE AFBCAMP AFBCAMP_CMTP_CODE UNKNOWN
CAMPAIGN_TYPE_DESC ATVCMTP ATVCMTP_DESC UNKNOWN
DESG_TYPE ADBDESG ADBDESG_DSTP_CODE UNKNOWN
DESG_TYPE_DESC ATVDSTP ATVDSTP_DESC UNKNOWN
DESG_COLLEGE FIRST LAYER OF THE INSTITUTION ORGANIZATION. ADBDESG ADBDESG_COLL_CODE UNKNOWN
DESG_COLLEGE_DESC NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. STVCOLL STVCOLL_DESC UNKNOWN
DESG_VSE ADBDESG ADBDESG_CFAE_CODE UNKNOWN
DESG_VSE_DESC ATVCFAE ATVCFAE_DESC UNKNOWN
SOLICITATION_TYPE AGRGSOL AGRGSOL_SOLC_CODE UNKNOWN
SOLICITATION_TYPE_DESC ATVSOLC ATVSOLC_DESC UNKNOWN
SOLICITATION_METHOD NA NOT AVAILABLE UNKNOWN
SOLICITATION_METHOD_DESC NA NOT AVAILABLE UNKNOWN
SOLICITOR_UID SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. NA NOT AVAILABLE UNKNOWN
SOLICITOR_ID PERSON'S ID NUMBER USED TO ACCESS THE RECORDS ASSOCIATED WITH THE PERSON SPRIDEN SPRIDEN_ID UNKNOWN
SOLICITOR_LAST_NAME PERSON'S LAST NAME OR SURNAME. SPRIDEN SPRIDEN_LAST_NAME UNKNOWN
SOLICITOR_FIRST_NAME PERSON'S FIRST OR GIVEN NAME. SPRIDEN SPRIDEN_FIRST_NAME UNKNOWN
SOLICITOR_ORG AGRGSOL AGRGSOL_SOL_ORG UNKNOWN
SOLICITATION_AMOUNT AGRGSOL AGRGSOL_AMT UNKNOWN
SOLICITOR_COUNT NUMBER OF SOLICITORS ASSOCIATED WITH THE PERSON. FUNCTION ? UNKNOWN
RECOGNITION_YEAR NA NOT AVAILABLE UNKNOWN
RECOGNITION_YEAR_DESC NA NOT AVAILABLE UNKNOWN
PRIMARY_DONOR_CATEGORY FUNCTION NOT AVAILABLE UNKNOWN
PRIMARY_DONOR_CATEGORY_DESC NA NOT AVAILABLE UNKNOWN
PREFER_CLASS_YEAR APBCONS APBCONS_PREF_CLAS UNKNOWN
PREFER_CLASS_YEAR_DESC STVCLAS STVCLAS_DESC UNKNOWN
PREFER_COLLEGE FIRST LAYER OF THE INSTITUTION ORGANIZATION. APBCONS APBCONS_COLL_CODE_PREF UNKNOWN
PREFER_COLLEGE_DESC NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. STVCOLL STVCOLL_DESC UNKNOWN
MATCHING_GIFT_COUNT NUMBER OF MATCHING GIFTS RECORDED FOR A GIFT FROM A PERSON. FUNCTION ? UNKNOWN
GIFT_AUXILIARY_COUNT NUMBER OF THE AUXILIARY GIFTS RECORDED FOR THE PERSON. FUNCTION ? UNKNOWN
DESG_GENERAL_LEDGER_NUMBER ADBDESG ADBDESG_GL_NO_CREDIT UNKNOWN
DESG_CHART_OF_ACCOUNT ADBDESG ADBDESG_COAS_CODE UNKNOWN
DESG_CHART_OF_ACCOUNT_DESC FTVCOAS FTVCOAS_TITLE UNKNOWN
DESG_ACCOUNT_INDEX ADBDESG ADBDESG_ACCI_CODE UNKNOWN
DESG_ACCOUNT_INDEX_DESC FTVACCI FTVACCI_TITLE UNKNOWN
DESG_FUND ADBDESG ADBDESG_FUND_CODE UNKNOWN
DESG_FUND_DESC FTVFUND FTVFUND_TITLE UNKNOWN
DESG_ORGANIZATION ADBDESG ADBDESG_ORGN_CODE UNKNOWN
DESG_ORGANIZATION_DESC FTVORGN FTVORGN_TITLE UNKNOWN
DESG_ACCOUNT ADBDESG ADBDESG_ACCT_CODE UNKNOWN
DESG_ACCOUNT_DESC FTVACCT FTVACCT_TITLE UNKNOWN
DESG_PROGRAM ADBDESG ADBDESG_PROG_CODE UNKNOWN
DESG_PROGRAM_DESC FTVPROG FTVPROG_TITLE UNKNOWN
DESG_ACTIVITY ADBDESG ADBDESG_ACTV_CODE UNKNOWN
DESG_ACTIVITY_DESC FTVACTV FTVACTV_TITLE UNKNOWN
DESG_LOCATION ADBDESG ADBDESG_LOCN_CODE UNKNOWN
DESG_LOCATION_DESC FTVLOCN FTVLOCN_TITLE UNKNOWN