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_DETAIL PERSON_VETERAN PERSON	MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE
SPBPERS_BIRTH_DATE	SPAPERS	REPORTING VIEW	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 RELATED_BIRTH_DATE BIRTH_DATE	NA
SPBPERS_CITZ_CODE	SPAPERS	REPORTING VIEW	PERSON_INTERNATIONAL PERSON PERSON_DETAIL GOVERNMENT_STUDENT	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_VETERAN PERSON_DETAIL	CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND	NA
SPBPERS_CONFIRMED_RE_CDE	SPAPERS	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
SPBPERS_CONFIRMED_RE_DATE	SPAPERS	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
SPBPERS_DEAD_DATE	SPAPERS	REPORTING VIEW	PERSON_INTERNATIONAL PERSON PLEDGE GIFT PERSON_DETAIL RELATIONSHIP PERSON_VETERAN	DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE RELATED_DECEASED_DATE DECEASED_DATE	NA
SPBPERS_DEAD_IND	SPAPERS	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
SPBPERS_ETHN_CDE	SPAPERS	REPORTING VIEW	GOVERNMENT_STUDENT PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS PERSON 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
SPBPERS_ETHN_CODE	SPAPERS	REPORTING VIEW	GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_FINANCIAL_AID PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT GOVERNMENT_FINANCIAL_AID PERSON	PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY	NA
SPBPERS_LEGAL_NAME	SPAPERS	REPORTING VIEW	PERSON PERSON_DETAIL	LEGAL_NAME LEGAL_NAME	NA
SPBPERS_LGCY_CODE	SPAPERS	REPORTING VIEW	PERSON_DETAIL PERSON PERSON_SENSITIVE	LEGACY LEGACY LEGACY	NA
SPBPERS_MRTL_CODE	SPAPERS	REPORTING VIEW	CONSTITUENT PERSON PERSON_INTERNATIONAL PERSON_DETAIL RELATIONSHIP PERSON_SENSITIVE	MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS	NA
SPBPERS_NAME_PREFIX	SPAPERS	REPORTING VIEW	RECEIVABLE_ACCOUNT PERSON_DETAIL CONSTITUENT_ENTITY PERSON ORGANIZATION_CONTACT RELATIONSHIP	NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX RELATED_PREFIX	NA
SPBPERS_NAME_SUFFIX	SPAPERS	REPORTING VIEW	CONSTITUENT RECEIVABLE_ACCOUNT PERSON PERSON_DETAIL CONSTITUENT_ENTITY ORGANIZATION_CONTACT RELATIONSHIP	NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX RELATED_SUFFIX	NA
SPBPERS_PIDM	NA	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
SPBPERS_PREF_FIRST_NAME	SPAPERS	REPORTING VIEW	PERSON PERSON_DETAIL	PREFERRED_FIRST_NAME PREFERRED_FIRST_NAME	NA
SPBPERS_RELG_CODE	SPAPERS	REPORTING VIEW	PERSON_SENSITIVE PERSON PERSON_DETAIL	RELIGION RELIGION RELIGION	NA
SPBPERS_SDVET_IND	SPAPERS	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
SPBPERS_SEX	SPAPERS	REPORTING VIEW	GOVERNMENT_ADMISSIONS PERSON PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT RELATIONSHIP CONSTITUENT	GENDER GENDER GENDER GENDER GENDER GENDER GENDER RELATED_GENDER GENDER	NA
SPBPERS_SSN	SPAPERS	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
SPBPERS_VERA_IND	SPAPERS	REPORTING VIEW	STUDENT PERSON_VETERAN VETERAN_CERTIFICATION PERSON STUDENT_EXTENDED PERSON_DETAIL	VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY	NA
SPBPERS_VETC_FILE_NUMBER	SPAPERS	REPORTING VIEW	STUDENT PERSON_DETAIL STUDENT_EXTENDED VETERAN_CERTIFICATION PERSON_VETERAN PERSON	VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NUMBER	NA

Ver: 8.5