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**
Banner Source Column	Source Form	ODS Target	ODS Target Column
SPBPERS_ACTIVE_DUTY_SEPR_DATE	TBD	PERSON_VETERAN PERSON PERSON_DETAIL	MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE
SPBPERS_BIRTH_DATE	SPAPERS	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
SPBPERS_CITZ_CODE	SPAPERS	GOVERNMENT_STUDENT PERSON PERSON_INTERNATIONAL PERSON_DETAIL	CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE
SPBPERS_CITZ_IND	STVCITZ	GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT	CITIZENSHIP_IND CITIZENSHIP_IND
SPBPERS_CONFID_IND	SPAPERS	PERSON_DETAIL PERSON_VETERAN CONSTITUENT PERSON	CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND
SPBPERS_CONFIRMED_RE_CDE	SPAPERS	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
SPBPERS_CONFIRMED_RE_DATE	SPAPERS	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
SPBPERS_DEAD_DATE	SPAPERS	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
SPBPERS_DEAD_IND	SPAPERS	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
SPBPERS_ETHN_CDE	SPAPERS
SPBPERS_ETHN_CODE	SPAPERS	PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_STUDENT PERSON GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS PERSON_DETAIL GOVERNMENT_STUDENT	HISPANIC_LATINO_ETHNICITY_IND PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY 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
SPBPERS_LEGAL_NAME	SPAPERS	PERSON_DETAIL PERSON	LEGAL_NAME LEGAL_NAME
SPBPERS_LGCY_CODE	SPAPERS	PERSON_SENSITIVE PERSON_DETAIL PERSON	LEGACY LEGACY LEGACY
SPBPERS_MRTL_CODE	SPAPERS	PERSON_INTERNATIONAL RELATIONSHIP PERSON PERSON_SENSITIVE CONSTITUENT PERSON_DETAIL	MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS
SPBPERS_NAME_PREFIX	SPAPERS	RELATIONSHIP CONSTITUENT_ENTITY ORGANIZATION_CONTACT PERSON RECEIVABLE_ACCOUNT PERSON_DETAIL	RELATED_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX
SPBPERS_NAME_SUFFIX	SPAPERS	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
SPBPERS_PIDM	NA	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
SPBPERS_PREF_FIRST_NAME	SPAPERS	PERSON PERSON_DETAIL	PREFERRED_FIRST_NAME PREFERRED_FIRST_NAME
SPBPERS_RELG_CODE	SPAPERS	PERSON PERSON_SENSITIVE PERSON_DETAIL	RELIGION RELIGION RELIGION
SPBPERS_SDVET_IND	SPAPERS	STUDENT_EXTENDED PERSON PERSON_VETERAN STUDENT PERSON_DETAIL	VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND
SPBPERS_SEX	SPAPERS	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
SPBPERS_SSN	SPAPERS	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
SPBPERS_VERA_IND	SPAPERS	PERSON STUDENT_EXTENDED PERSON_VETERAN STUDENT PERSON_DETAIL	VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY
SPBPERS_VETC_FILE_NUMBER	SPAPERS	PERSON STUDENT PERSON_DETAIL PERSON_VETERAN STUDENT_EXTENDED	VETERAN_FILE_NUMBER VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NO

Ver: 8.3