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_ACTIVE_DUTY_SEPR_DATE	TBD	REPORTING VIEW	PERSON_VETERAN PERSON PERSON_DETAIL	MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE
SPBPERS_BIRTH_DATE	TBD	REPORTING VIEW REPORTING VIEW	GOVERNMENT_ADMISSIONS PERSON_DETAIL RELATIONSHIP PERSON GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE PERSON_VETERAN CONSTITUENT_ENTITY GOVERNMENT_STUDENT GOVERNMENT_ADMISSIONS PERSON_DETAIL RELATIONSHIP PERSON GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE PERSON_VETERAN CONSTITUENT_ENTITY GOVERNMENT_STUDENT	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 RELATED_BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE
SPBPERS_CITZ_CODE	TBD	REPORTING VIEW REPORTING VIEW	GOVERNMENT_STUDENT PERSON PERSON_INTERNATIONAL PERSON_DETAIL GOVERNMENT_STUDENT PERSON PERSON_INTERNATIONAL PERSON_DETAIL	CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE
SPBPERS_CITZ_IND	STVCITZ	REPORTING VIEW	GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT	CITIZENSHIP_IND CITIZENSHIP_IND	NA
SPBPERS_CONFID_IND	SPAPERS	REPORTING VIEW	PERSON_DETAIL PERSON_VETERAN CONSTITUENT PERSON	CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND	NA
SPBPERS_CONFIRMED_RE_CDE	SPAPERS	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID GOVERNMENT_STUDENT PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_ADMISSIONS GOVERNMENT_ACADEMIC_OUTCOME 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
SPBPERS_CONFIRMED_RE_DATE	SPAPERS	REPORTING VIEW	GOVERNMENT_STUDENT PERSON GOVERNMENT_ACADEMIC_OUTCOME PERSON_DETAIL GOVERNMENT_ADMISSIONS GOVERNMENT_FINANCIAL_AID 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	TBD	REPORTING VIEW REPORTING VIEW	PERSON_VETERAN RELATIONSHIP PERSON_DETAIL GIFT PLEDGE PERSON PERSON_INTERNATIONAL PERSON_VETERAN RELATIONSHIP PERSON_DETAIL GIFT PLEDGE PERSON PERSON_INTERNATIONAL	DECEASED_DATE RELATED_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
SPBPERS_DEAD_IND	SPAPERS	REPORTING VIEW	GIFT PLEDGE PERSON_DETAIL PERSON_VETERAN RELATIONSHIP PERSON PERSON_INTERNATIONAL CONSTITUENT CONSTITUENT_ENTITY	DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS RELATED_DECEASED_IND DECEASED_STATUS DECEASED_STATUS DECEASED_IND DECEASED_IND	NA
SPBPERS_ETHN_CDE	SPAPERS	REPORTING VIEW	PERSON_DETAIL GOVERNMENT_STUDENT PERSON PERSON_SENSITIVE GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS	HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND
SPBPERS_ETHN_CODE	SPAPERS	REPORTING VIEW REPORTING VIEW	GOVERNMENT_FINANCIAL_AID GOVERNMENT_STUDENT PERSON GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_DETAIL GOVERNMENT_FINANCIAL_AID GOVERNMENT_STUDENT PERSON GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_DETAIL	PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY PRIMARY_ETHNICITY	NA
SPBPERS_LEGAL_NAME	SPAPERS	REPORTING VIEW REPORTING VIEW	PERSON_DETAIL PERSON PERSON_DETAIL PERSON	LEGAL_NAME LEGAL_NAME LEGAL_NAME LEGAL_NAME	NA
SPBPERS_LGCY_CODE	SPAPERS	REPORTING VIEW REPORTING VIEW	PERSON_SENSITIVE PERSON_DETAIL PERSON PERSON_SENSITIVE PERSON_DETAIL PERSON	LEGACY LEGACY LEGACY LEGACY LEGACY LEGACY	NA
SPBPERS_MRTL_CODE	SPAPERS	REPORTING VIEW REPORTING VIEW	PERSON_INTERNATIONAL RELATIONSHIP PERSON PERSON_SENSITIVE CONSTITUENT PERSON_DETAIL PERSON_INTERNATIONAL RELATIONSHIP PERSON PERSON_SENSITIVE CONSTITUENT 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	NA
SPBPERS_NAME_PREFIX	TBD	REPORTING VIEW REPORTING VIEW	RELATIONSHIP CONSTITUENT_ENTITY ORGANIZATION_CONTACT PERSON RECEIVABLE_ACCOUNT PERSON_DETAIL RELATIONSHIP CONSTITUENT_ENTITY ORGANIZATION_CONTACT PERSON RECEIVABLE_ACCOUNT PERSON_DETAIL	RELATED_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX RELATED_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX
SPBPERS_NAME_SUFFIX	TBD	REPORTING VIEW REPORTING VIEW	CONSTITUENT_ENTITY ORGANIZATION_CONTACT RECEIVABLE_ACCOUNT RELATIONSHIP CONSTITUENT PERSON_DETAIL PERSON CONSTITUENT_ENTITY ORGANIZATION_CONTACT RECEIVABLE_ACCOUNT RELATIONSHIP CONSTITUENT PERSON_DETAIL PERSON	NAME_SUFFIX CONTACT_NAME_SUFFIX NAME_SUFFIX RELATED_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX NAME_SUFFIX RELATED_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX
SPBPERS_PIDM	NA	REPORTING VIEW	PERSON PERSON_VETERAN PERSON_INTERNATIONAL PERSON_SENSITIVE ORGANIZATION_ENTITY_ADDRESS MEDICAL_INFORMATION_SLOT PERSON_ADDRESS	PERSON_UID PERSON_UID PERSON_UID PERSON_UID ENTITY_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	TBD	REPORTING VIEW REPORTING VIEW	PERSON PERSON_SENSITIVE PERSON_DETAIL PERSON PERSON_SENSITIVE PERSON_DETAIL	RELIGION RELIGION RELIGION RELIGION RELIGION RELIGION
SPBPERS_SDVET_IND	SPAPERS	REPORTING VIEW	PERSON STUDENT_EXTENDED PERSON_VETERAN STUDENT PERSON_DETAIL 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
SPBPERS_SEX	SPAPERS	REPORTING VIEW REPORTING VIEW	GOVERNMENT_STUDENT PERSON RELATIONSHIP PERSON_DETAIL CONSTITUENT GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON RELATIONSHIP PERSON_DETAIL CONSTITUENT GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ADMISSIONS	GENDER GENDER RELATED_GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER RELATED_GENDER GENDER GENDER GENDER GENDER GENDER GENDER	NA
SPBPERS_SSN	SPAPERS	REPORTING VIEW	CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT RELATIONSHIP PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON_VETERAN CROSS_REFERENCE_SLOT RECEIVABLE_ACCOUNT PERSON_DETAIL GOVERNMENT_FINANCIAL_AID CROSS_REFERENCE_SLOT PERSON ORGANIZATION_ENTITY	RELATED_TAX_ID1 RELATED_TAX_ID2 RELATED_TAX_ID5 RELATED_CHILD_TAX_ID TAX_ID TAX_ID TAX_ID RELATED_TAX_ID3 TAX_ID TAX_ID TAX_ID RELATED_TAX_ID4 TAX_ID TAX_ID	NA
SPBPERS_VERA_IND	TBD	REPORTING VIEW REPORTING VIEW	PERSON STUDENT_EXTENDED PERSON_VETERAN VETERAN_CERTIFICATION STUDENT PERSON_DETAIL PERSON STUDENT_EXTENDED PERSON_VETERAN VETERAN_CERTIFICATION STUDENT PERSON_DETAIL	VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY
SPBPERS_VETC_FILE_NUMBER	SPAPERS	REPORTING VIEW	PERSON STUDENT VETERAN_CERTIFICATION PERSON_DETAIL PERSON_VETERAN STUDENT_EXTENDED	VETERAN_FILE_NUMBER VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NO	NA

Ver: 8.4.1