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 PERSON_VETERAN |
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 CONSTITUENT_ENTITY GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT RELATIONSHIP PERSON PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_VETERAN PERSON_DETAIL WDT_ENTITY CONSTITUENT_ENTITY GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT RELATIONSHIP PERSON PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_VETERAN PERSON_DETAIL |
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 BIRTH_DATE BIRTH_DATE BIRTH_DATE 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 GOVERNMENT_STUDENT PERSON PERSON_DETAIL WDT_DEMOGRAPHIC PERSON_INTERNATIONAL GOVERNMENT_STUDENT PERSON PERSON_DETAIL |
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 |
PERSON PERSON_VETERAN CONSTITUENT 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_ADMISSIONS PERSON_DETAIL GOVERNMENT_STUDENT GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID PERSON |
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_STUDENT PERSON_DETAIL PERSON GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_ACADEMIC_OUTCOME |
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_DETAIL RELATIONSHIP PERSON_VETERAN PERSON GIFT PLEDGE PERSON_INTERNATIONAL WDT_ENTITY PERSON_DETAIL RELATIONSHIP PERSON_VETERAN PERSON GIFT PLEDGE PERSON_INTERNATIONAL |
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 DECEASED_DATE DECEASED_DATE 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 |
PERSON_DETAIL RELATIONSHIP PERSON CONSTITUENT_ENTITY GIFT ORGANIZATION_CONTACT CONSTITUENT PERSON_INTERNATIONAL PERSON_VETERAN PLEDGE |
DECEASED_STATUS RELATED_DECEASED_IND DECEASED_STATUS DECEASED_IND DECEASED_STATUS CONTACT_DECEASED_IND DECEASED_IND DECEASED_STATUS DECEASED_STATUS 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_ADMISSIONS GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_SENSITIVE |
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_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON GOVERNMENT_FINANCIAL_AID WDT_DEMOGRAPHIC GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON GOVERNMENT_FINANCIAL_AID |
ETHNICITY PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY ETHNICITY PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND 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_GNDR_CODE |
NO |
REPORTING VIEW |
CONSTITUENT GOVERNMENT_ADMISSIONS GOVERNMENT_FINANCIAL_AID PERSON_DETAIL GOVERNMENT_STUDENT PERSON_SENSITIVE PERSON GOVERNMENT_ACADEMIC_OUTCOME |
GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION |
NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO |
| SPBPERS_LEGAL_NAME |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_ENTITY PERSON_DETAIL PERSON WDT_ENTITY PERSON_DETAIL PERSON |
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_SENSITIVE PERSON_DETAIL PERSON WDT_DEMOGRAPHIC PERSON_SENSITIVE PERSON_DETAIL PERSON |
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 RELATIONSHIP CONSTITUENT PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON PERSON_DETAIL WDT_DEMOGRAPHIC RELATIONSHIP CONSTITUENT PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON PERSON_DETAIL |
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 RELATIONSHIP RECEIVABLE_ACCOUNT PERSON_DETAIL CONSTITUENT_ENTITY PERSON ORGANIZATION_CONTACT WDT_ENTITY RELATIONSHIP RECEIVABLE_ACCOUNT PERSON_DETAIL CONSTITUENT_ENTITY PERSON ORGANIZATION_CONTACT |
NAME_PREFIX RELATED_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX RELATED_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_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 PERSON RELATIONSHIP PERSON_DETAIL CONSTITUENT ORGANIZATION_CONTACT CONSTITUENT_ENTITY RECEIVABLE_ACCOUNT WDT_ENTITY PERSON RELATIONSHIP PERSON_DETAIL CONSTITUENT ORGANIZATION_CONTACT CONSTITUENT_ENTITY RECEIVABLE_ACCOUNT |
NAME_SUFFIX NAME_SUFFIX RELATED_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX RELATED_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_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_SENSITIVE MEDICAL_INFORMATION_SLOT ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_VETERAN PERSON_ADDRESS PERSON_INTERNATIONAL |
PERSON_UID PERSON_UID ENTITY_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID |
NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO |
| SPBPERS_PPRN_CODE |
NO |
REPORTING VIEW |
CONSTITUENT GOVERNMENT_FINANCIAL_AID PERSON PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON_SENSITIVE |
PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN |
NA NA NA NA NA NA NA NA |
NO 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 |
VETERAN_CERTIFICATION PERSON_DETAIL PERSON_VETERAN STUDENT_EXTENDED PERSON STUDENT |
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_STUDENT PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME RELATIONSHIP GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS PERSON_SENSITIVE CONSTITUENT PERSON WDT_DEMOGRAPHIC GOVERNMENT_STUDENT PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME RELATIONSHIP GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS PERSON_SENSITIVE CONSTITUENT PERSON |
GENDER GENDER GENDER GENDER RELATED_GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER RELATED_GENDER GENDER GENDER GENDER 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_DETAIL PERSON_VETERAN RECEIVABLE_ACCOUNT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT PERSON_SENSITIVE RELATIONSHIP CROSS_REFERENCE_SLOT ORGANIZATION_ENTITY PERSON GOVERNMENT_FINANCIAL_AID PERSON_INTERNATIONAL |
RELATED_TAX_ID1 RELATED_TAX_ID3 TAX_ID TAX_ID TAX_ID RELATED_TAX_ID5 RELATED_TAX_ID2 TAX_ID RELATED_CHILD_TAX_ID RELATED_TAX_ID4 TAX_ID TAX_ID TAX_ID TAX_ID |
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_EXTENDED VETERAN_CERTIFICATION PERSON_DETAIL PERSON_VETERAN STUDENT PERSON WDT_DEMOGRAPHIC STUDENT_EXTENDED VETERAN_CERTIFICATION PERSON_DETAIL PERSON_VETERAN STUDENT PERSON |
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 |
PERSON_VETERAN STUDENT_EXTENDED VETERAN_CERTIFICATION PERSON PERSON_DETAIL STUDENT |
VETERAN_FILE_NUMBER VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NO VETERAN_FILE_NO |
NA NA NA NA NA NA |
NO NO NO NO NO NO |