SGHE Enterprise Data Warehouse
Banner EDW Source: SPBPERS - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| SPBPERS_ACTIVE_DUTY_SEPR_DATE |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_VETERAN PERSON |
MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE |
NA NA NA |
NO NO NO |
| SPBPERS_BIRTH_DATE |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_ENTITY GOVERNMENT_FINANCIAL_AID CONSTITUENT_ENTITY PERSON_DETAIL GOVERNMENT_STUDENT PERSON_SENSITIVE PERSON_VETERAN GOVERNMENT_ADMISSIONS PERSON RELATIONSHIP GOVERNMENT_ACADEMIC_OUTCOME WDT_ENTITY GOVERNMENT_FINANCIAL_AID CONSTITUENT_ENTITY PERSON_DETAIL GOVERNMENT_STUDENT PERSON_SENSITIVE PERSON_VETERAN GOVERNMENT_ADMISSIONS PERSON RELATIONSHIP GOVERNMENT_ACADEMIC_OUTCOME |
BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE RELATED_BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE RELATED_BIRTH_DATE BIRTH_DATE |
ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA NA NA NA NA ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_CITZ_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC PERSON_INTERNATIONAL PERSON PERSON_DETAIL GOVERNMENT_STUDENT WDT_DEMOGRAPHIC PERSON_INTERNATIONAL PERSON PERSON_DETAIL GOVERNMENT_STUDENT |
CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_CITZ_IND |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT |
CITIZENSHIP_IND CITIZENSHIP_IND |
NA NA |
NO NO |
| SPBPERS_CONFID_IND |
NO |
REPORTING VIEW |
CONSTITUENT PERSON PERSON_VETERAN PERSON_DETAIL |
CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND |
NA NA NA NA |
NO NO NO NO |
| SPBPERS_CONFIRMED_RE_CDE |
NO |
REPORTING VIEW |
GOVERNMENT_STUDENT PERSON PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID |
RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND |
NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO |
| SPBPERS_CONFIRMED_RE_DATE |
NO |
REPORTING VIEW |
GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE GOVERNMENT_STUDENT PERSON_DETAIL GOVERNMENT_ADMISSIONS PERSON |
RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE |
NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO |
| SPBPERS_DEAD_DATE |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_ENTITY PERSON_INTERNATIONAL PERSON PLEDGE GIFT PERSON_DETAIL RELATIONSHIP PERSON_VETERAN WDT_ENTITY PERSON_INTERNATIONAL PERSON PLEDGE GIFT PERSON_DETAIL RELATIONSHIP PERSON_VETERAN |
DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE RELATED_DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE RELATED_DECEASED_DATE DECEASED_DATE |
ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA NA ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_DEAD_IND |
NO |
REPORTING VIEW |
ORGANIZATION_CONTACT CONSTITUENT PERSON_VETERAN GIFT PERSON CONSTITUENT_ENTITY PERSON_DETAIL PERSON_INTERNATIONAL RELATIONSHIP PLEDGE |
CONTACT_DECEASED_IND DECEASED_IND DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS DECEASED_IND DECEASED_STATUS DECEASED_STATUS RELATED_DECEASED_IND DECEASED_STATUS |
NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_ETHN_CDE |
NO |
REPORTING VIEW |
GOVERNMENT_STUDENT PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS PERSON_SENSITIVE PERSON |
HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND |
NA NA NA NA NA NA |
NO NO NO NO NO NO |
| SPBPERS_ETHN_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_FINANCIAL_AID PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT GOVERNMENT_FINANCIAL_AID PERSON WDT_DEMOGRAPHIC GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_FINANCIAL_AID PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT GOVERNMENT_FINANCIAL_AID PERSON |
ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_LEGAL_NAME |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_ENTITY PERSON PERSON_DETAIL WDT_ENTITY PERSON PERSON_DETAIL |
LEGAL_NAME LEGAL_NAME LEGAL_NAME LEGAL_NAME LEGAL_NAME LEGAL_NAME |
ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA |
NO NO NO NO NO NO |
| SPBPERS_LGCY_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC PERSON_DETAIL PERSON PERSON_SENSITIVE WDT_DEMOGRAPHIC PERSON_DETAIL PERSON PERSON_SENSITIVE |
LEGACY LEGACY LEGACY LEGACY LEGACY LEGACY LEGACY LEGACY |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA |
NO NO NO NO NO NO NO NO |
| SPBPERS_MRTL_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC CONSTITUENT PERSON PERSON_INTERNATIONAL PERSON_DETAIL RELATIONSHIP PERSON_SENSITIVE WDT_DEMOGRAPHIC CONSTITUENT PERSON PERSON_INTERNATIONAL PERSON_DETAIL RELATIONSHIP PERSON_SENSITIVE |
MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_NAME_PREFIX |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_ENTITY RECEIVABLE_ACCOUNT PERSON_DETAIL CONSTITUENT_ENTITY PERSON RELATIONSHIP ORGANIZATION_CONTACT WDT_ENTITY RECEIVABLE_ACCOUNT PERSON_DETAIL CONSTITUENT_ENTITY PERSON RELATIONSHIP ORGANIZATION_CONTACT |
NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX RELATED_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX RELATED_PREFIX CONTACT_NAME_PREFIX |
ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_NAME_SUFFIX |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_ENTITY CONSTITUENT RECEIVABLE_ACCOUNT PERSON PERSON_DETAIL CONSTITUENT_ENTITY ORGANIZATION_CONTACT RELATIONSHIP WDT_ENTITY CONSTITUENT RECEIVABLE_ACCOUNT PERSON PERSON_DETAIL CONSTITUENT_ENTITY ORGANIZATION_CONTACT RELATIONSHIP |
NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX RELATED_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX RELATED_SUFFIX |
ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA NA ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_PIDM |
NO |
REPORTING VIEW |
PERSON MEDICAL_INFORMATION_SLOT PERSON_ADDRESS PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON_VETERAN ORGANIZATION_ENTITY_ADDRESS |
PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID ENTITY_UID |
NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO |
| SPBPERS_PREF_FIRST_NAME |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL |
PREFERRED_FIRST_NAME PREFERRED_FIRST_NAME |
NA NA |
NO NO |
| SPBPERS_RELG_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC PERSON_SENSITIVE PERSON PERSON_DETAIL WDT_DEMOGRAPHIC PERSON_SENSITIVE PERSON PERSON_DETAIL |
RELIGION RELIGION RELIGION RELIGION RELIGION RELIGION RELIGION RELIGION |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA |
NO NO NO NO NO NO NO NO |
| SPBPERS_SDVET_IND |
NO |
REPORTING VIEW |
STUDENT_EXTENDED PERSON PERSON_DETAIL PERSON_VETERAN STUDENT VETERAN_CERTIFICATION |
VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND |
NA NA NA NA NA NA |
NO NO NO NO NO NO |
| SPBPERS_SEX |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC GOVERNMENT_ADMISSIONS PERSON PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT RELATIONSHIP CONSTITUENT WDT_DEMOGRAPHIC GOVERNMENT_ADMISSIONS PERSON PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT RELATIONSHIP CONSTITUENT |
GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER RELATED_GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER RELATED_GENDER GENDER |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_SSN |
NO |
REPORTING VIEW |
CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT PERSON_INTERNATIONAL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT PERSON PERSON_VETERAN ORGANIZATION_ENTITY PERSON_DETAIL RELATIONSHIP RECEIVABLE_ACCOUNT CROSS_REFERENCE_SLOT |
RELATED_TAX_ID1 RELATED_TAX_ID2 TAX_ID TAX_ID TAX_ID RELATED_TAX_ID3 RELATED_TAX_ID5 TAX_ID TAX_ID TAX_ID TAX_ID RELATED_CHILD_TAX_ID TAX_ID RELATED_TAX_ID4 |
NA NA NA NA NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_VERA_IND |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC STUDENT PERSON_VETERAN PERSON VETERAN_CERTIFICATION PERSON_DETAIL STUDENT_EXTENDED WDT_DEMOGRAPHIC STUDENT PERSON_VETERAN PERSON VETERAN_CERTIFICATION PERSON_DETAIL STUDENT_EXTENDED |
VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| SPBPERS_VETC_FILE_NUMBER |
NO |
REPORTING VIEW |
STUDENT PERSON_DETAIL PERSON_VETERAN STUDENT_EXTENDED VETERAN_CERTIFICATION PERSON |
VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER |
NA NA NA NA NA NA |
NO NO NO NO NO NO |