Reporting View Source: SPBPERS

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: SPBPERS Student Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SPBPERS_BIRTH_DATE	SPAPERS	REPORTING VIEW	CONSTITUENT_ENTITY GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_SENSITIVE PERSON_VETERAN RELATIONSHIP	BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE RELATED_BIRTH_DATE	NA
SPBPERS_CITZ_CODE	SPAPERS	REPORTING VIEW	GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_INTERNATIONAL	CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE	NA
SPBPERS_CITZ_IND	STVCITZ	REPORTING VIEW	GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT	CITIZENSHIP_IND CITIZENSHIP_IND	NA
SPBPERS_CONFID_IND	SPAPERS	REPORTING VIEW	CONSTITUENT PERSON PERSON_DETAIL PERSON_VETERAN	CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND	NA
SPBPERS_CONFIRMED_RE_CDE	SPAPERS	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_SENSITIVE	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
SPBPERS_CONFIRMED_RE_DATE	SPAPERS	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_SENSITIVE	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
SPBPERS_DEAD_DATE	SPAPERS	REPORTING VIEW	GIFT PLEDGE PERSON PERSON_DETAIL PERSON_INTERNATIONAL PERSON_VETERAN RELATIONSHIP	DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE RELATED_DECEASED_DATE	NA
SPBPERS_DEAD_IND	SPAPERS	REPORTING VIEW	CONSTITUENT CONSTITUENT_ENTITY GIFT PLEDGE PERSON PERSON_DETAIL PERSON_INTERNATIONAL PERSON_VETERAN RELATIONSHIP	DECEASED_IND DECEASED_IND DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS RELATED_DECEASED_IND	NA
SPBPERS_ETHN_CDE	SPAPERS				NA
SPBPERS_ETHN_CODE	SPAPERS	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID GOVERNMENT_FINANCIAL_AID GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT GOVERNMENT_STUDENT PERSON PERSON PERSON_DETAIL PERSON_DETAIL PERSON_SENSITIVE PERSON_SENSITIVE	HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY PRIM_ETHNICITY_CATEGORY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY	NA
SPBPERS_LEGAL_NAME	SPAPERS	REPORTING VIEW	PERSON PERSON_DETAIL	LEGAL_NAME LEGAL_NAME	NA
SPBPERS_LGCY_CODE	SPAPERS	REPORTING VIEW	PERSON PERSON_DETAIL PERSON_SENSITIVE	LEGACY LEGACY LEGACY	NA
SPBPERS_MRTL_CODE	SPAPERS	REPORTING VIEW	CONSTITUENT PERSON PERSON_DETAIL PERSON_INTERNATIONAL PERSON_SENSITIVE RELATIONSHIP	MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS	NA
SPBPERS_NAME_PREFIX	SPAPERS	REPORTING VIEW	CONSTITUENT_ENTITY ORGANIZATION_CONTACT RECEIVABLE_ACCOUNT PERSON PERSON_DETAIL RELATIONSHIP	NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX RELATED_PREFIX	NA
SPBPERS_NAME_SUFFIX	SPAPERS	REPORTING VIEW	CONSTITUENT CONSTITUENT_ENTITY ORGANIZATION_CONTACT RECEIVABLE_ACCOUNT PERSON PERSON_DETAIL RELATIONSHIP	NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX RELATED_SUFFIX	NA
SPBPERS_PIDM	NA	REPORTING VIEW	MEDICAL_INFORMATION_SLOT ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON_VETERAN	PERSON_UID ENTITY_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID	NA
SPBPERS_PREF_FIRST_NAME	SPAPERS	REPORTING VIEW	PERSON PERSON_DETAIL	PREFERRED_FIRST_NAME PREFERRED_FIRST_NAME	NA
SPBPERS_RELG_CODE	SPAPERS	REPORTING VIEW	PERSON PERSON_DETAIL PERSON_SENSITIVE	RELIGION RELIGION RELIGION	NA
SPBPERS_SDVET_IND	SPAPERS	REPORTING VIEW	STUDENT STUDENT_EXTENDED PERSON PERSON_DETAIL PERSON_VETERAN	VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND	NA
SPBPERS_SEX	SPAPERS	REPORTING VIEW	CONSTITUENT GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_SENSITIVE RELATIONSHIP	GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER RELATED_GENDER	NA
SPBPERS_SSN	SPAPERS	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID RECEIVABLE_ACCOUNT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT ORGANIZATION_ENTITY PERSON PERSON_DETAIL PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON_VETERAN RELATIONSHIP	TAX_ID TAX_ID RELATED_TAX_ID1 RELATED_TAX_ID2 RELATED_TAX_ID3 RELATED_TAX_ID4 RELATED_TAX_ID5 TAX_ID TAX_ID TAX_ID TAX_ID TAX_ID TAX_ID RELATED_CHILD_TAX_ID	NA
SPBPERS_VERA_IND	SPAPERS	REPORTING VIEW	STUDENT STUDENT_EXTENDED PERSON PERSON_DETAIL PERSON_VETERAN	VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY	NA
SPBPERS_VETC_FILE_NUMBER	SPAPERS	REPORTING VIEW	STUDENT STUDENT_EXTENDED PERSON PERSON_DETAIL PERSON_VETERAN	VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NO VETERAN_FILE_NUMBER	NA

Ver: 8.1