PLEDGE - 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. |
|
AGRPDES |
AGRPDES_PIDM |
UNKNOWN |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
AGRPMLT |
AGRPMLT_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_? |
UNKNOWN |
| DECEASED_DATE |
DATE THE PERSON DIED. |
|
SPBPERS |
SPBPERS_? |
UNKNOWN |
| PLEDGE_NUMBER |
|
|
AGRPDES/AGRPMLT |
AGRPDES_PLEDGE_NO |
UNKNOWN |
| CAMPAIGN |
|
|
AGRPDES/AGRPMLT |
AGRPDES_CAMPAIGN |
UNKNOWN |
| CAMPAIGN_NAME |
|
|
AFBCAMP |
AFBCAMP_NAME |
UNKNOWN |
| DESIGNATION |
|
|
AGRPDES/AGRPMLT |
AGRPDES_DESG/AGRPMLT_DESG |
UNKNOWN |
| DESIGNATION_NAME |
|
|
ADBDESG |
ADBDESG_NAME |
UNKNOWN |
| PLEDGE_PARTIAL_PAID_IND |
|
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
| PLEDGE_FULLY_PAID_IND |
|
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
| PLEDGE_AMOUNT |
|
|
AGRPDES |
AGRPDES_AMT |
UNKNOWN |
| PLEDGE_CREDIT |
|
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
| PLEDGE_AMOUNT_PAID |
|
|
AGRPDES |
AGRPDES_AMT_PAID |
UNKNOWN |
| PLEDGE_BALANCE |
|
|
FUNCTION |
? |
UNKNOWN |
| PLEDGE_DATE |
|
|
AGBPLDG |
AGBPLDG_PLEDGE_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. |
|
AGBPLDG |
AGBPLDG_FISC_CODE |
UNKNOWN |
| FISCAL_YEAR_DESC |
|
|
ATVFISC |
ATVFISC_DESC |
UNKNOWN |
| PLEDGE_TYPE |
|
|
AGBPLDG |
AGBPLDG_PLDG_CODE |
UNKNOWN |
| PLEDGE_TYPE_DESC |
|
|
ATVPLDG |
ATVPLDG_DESC |
UNKNOWN |
| PLEDGE_CLASS |
|
|
AGBPLDG |
AGBPLDG_PCLS_CODE |
UNKNOWN |
| PLEDGE_CLASS_DESC |
|
|
ATVPCLS |
ATVPCLS_DESC |
UNKNOWN |
| PLEDGE_ANONYMOUS_IND |
|
|
ATVPCLS |
ATVPCLS_ANONYMOUS_IND |
UNKNOWN |
| PLEDGE_STATUS |
|
|
AGBPLDG |
AGBPLDG_PSTA_CODE |
UNKNOWN |
| PLEDGE_STATUS_DESC |
|
|
ATVPSTA |
ATVPSTA_DESC |
UNKNOWN |
| PLEDGE_ACTIVE_IND |
|
|
ATVPSTA |
ATVPSTA_ACTIVE_IND |
UNKNOWN |
| PLEDGE_VEHICLE |
|
|
AGBPLDG |
AGBPLDG_PGVE_CODE |
UNKNOWN |
| PLEDGE_VEHICLE_DESC |
|
|
ATVPGVE |
ATVPGVE_DESC |
UNKNOWN |
| SOLICITATION_TYPE |
|
|
AGRPSOL |
AGRPSOL_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 |
|
|
AGRPSOL |
AGRPSOL_SOL_ORG |
UNKNOWN |
| SOLICITATION_AMOUNT |
|
|
AGRPSOL |
AGRPSOL_AMT |
UNKNOWN |
| SOLICITOR_COUNT |
NUMBER OF SOLICITORS ASSOCIATED WITH THE PERSON. |
|
FUNCTION |
? |
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 |
| 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 |
| MATCHING_PLEDGE_COUNT |
|
|
FUNCTION |
? |
UNKNOWN |
| PLEDGE_INSTALLMENT_IND |
|
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |