ORGANIZATIONAL_CONSTITUENT - 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. |
|
AOBORGN |
AOBORGN_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 |
| FEDERAL_IDENTIFICATION |
CFDA NUMBER. |
|
AOBORGN |
AOBORGN_EIN |
UNKNOWN |
| BUSINESS |
|
|
AOBORGN |
AOBORGN_BUSINESS |
UNKNOWN |
| STANDARD_INDUSTRY_CODE |
|
|
AOBORGN |
AOBORGN_SICC_CODE |
UNKNOWN |
| STANDARD_INDUSTRY_CODE_DESC |
|
|
ATVSICC |
ATVSICC_DESC |
UNKNOWN |
| MATCHING_GIFT_PERCENT |
|
|
AOBORGN |
AOBORGN_MATCH_PCT |
UNKNOWN |
| MAX_YEAR_DONATE_AMOUNT |
|
|
AOBORGN |
AOBORGN_MATCH_ORG_MAX |
UNKNOWN |
| MAX_PERSON_MATCH_AMOUNT |
|
|
AOBORGN |
AOBORGN_MATCH_PERSON_MAX |
UNKNOWN |
| PREF_ADDRESS_TYPE |
|
|
AOBORGN |
AOBORGN_ATYP_CODE |
UNKNOWN |
| PREF_ADDRESS_TYPE_DESC |
|
|
STVATYP |
STVATYP_DESC |
UNKNOWN |
| JOB_CATEGORY |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| JOB_CATEGORY_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| MATCHING_GIFT_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
AOBORGN |
AOBORGN_MG_PIDM |
UNKNOWN |
| MATCH_MINIMUM |
|
|
AOBORGN |
AOBORGN_MATCH_MINIMUM |
UNKNOWN |
| MATCH_MAXIMUM |
|
|
AOBORGN |
AOBORGN_MATCH_MAXIMUM |
UNKNOWN |
| MAX_MATCH_ORG_EMPL_YEAR |
|
|
AOBORGN |
AOBORGN_MATCH_ORG_EMPL_YR |
UNKNOWN |
| MULTIPLE_RATIOS_IND |
|
|
FUNCTION |
F_MULTIPLE_RATIOS |
UNKNOWN |
| PRIMARY_DONOR_CATEGORY |
|
|
APRCATG |
APRCATG_DONR_CODE |
UNKNOWN |
| PRIMARY_DONOR_CATEGORY_DESC |
|
|
ATVDONR |
ATVDONR_DESC |
UNKNOWN |
| DONOR_CATEGORY_COUNT |
NUMBER OF DONOR CATEGORIES RECORDED FOR THE PERSON. |
|
FUNCTION |
? |
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 |
| FUND_COUNT |
|
|
FUNCTION |
? |
UNKNOWN |
| CONTACT_COUNT |
|
|
MAKFUNC |
F_COUNT_ORGN_CONTACT |
UNKNOWN |
| LIFE_TOTAL_GIVING |
|
|
FUNCTION |
F_LIFE_TOTAL_GIVING |
UNKNOWN |
| MOST_RECENT_GIFT_NUMBER |
|
|
FUNCTION |
? |
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_NUMBER |
|
|
FUNCTION |
? |
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 |