Reporting View Source: SPBPERS

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

**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	SPAPERS	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID PERSON_SENSITIVE PERSON_VETERAN CONSTITUENT_ENTITY GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT RELATIONSHIP PERSON GOVERNMENT_ACADEMIC_OUTCOME PERSON_DETAIL	BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE RELATED_BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE	NA
SPBPERS_CITZ_CODE	SPAPERS	REPORTING VIEW	GOVERNMENT_STUDENT PERSON_INTERNATIONAL PERSON_DETAIL PERSON	CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE	NA
SPBPERS_CITZ_IND	STVCITZ	REPORTING VIEW	GOVERNMENT_STUDENT GOVERNMENT_ADMISSIONS	CITIZENSHIP_IND CITIZENSHIP_IND	NA
SPBPERS_CONFID_IND	SPAPERS	REPORTING VIEW	CONSTITUENT PERSON_DETAIL PERSON_VETERAN PERSON	CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND	NA
SPBPERS_CONFIRMED_RE_CDE	SPAPERS	REPORTING VIEW	PERSON GOVERNMENT_FINANCIAL_AID PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT PERSON_SENSITIVE GOVERNMENT_ADMISSIONS	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	PLEDGE PERSON_DETAIL PERSON_INTERNATIONAL GIFT RELATIONSHIP PERSON PERSON_VETERAN	DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE RELATED_DECEASED_DATE DECEASED_DATE DECEASED_DATE	NA
SPBPERS_DEAD_IND	SPAPERS	REPORTING VIEW	CONSTITUENT RELATIONSHIP PLEDGE PERSON_INTERNATIONAL ORGANIZATION_CONTACT GIFT CONSTITUENT_ENTITY PERSON_DETAIL PERSON PERSON_VETERAN	DECEASED_IND RELATED_DECEASED_IND DECEASED_STATUS DECEASED_STATUS CONTACT_DECEASED_IND DECEASED_STATUS DECEASED_IND DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS	NA
SPBPERS_ETHN_CDE	SPAPERS	REPORTING VIEW	GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_STUDENT PERSON PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME	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_FINANCIAL_AID GOVERNMENT_STUDENT PERSON PERSON_SENSITIVE GOVERNMENT_ADMISSIONS GOVERNMENT_FINANCIAL_AID 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	NA
SPBPERS_GNDR_CODE	SPAPERS	REPORTING VIEW	PERSON_SENSITIVE GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_FINANCIAL_AID PERSON_DETAIL CONSTITUENT	GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION	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	PERSON CONSTITUENT PERSON_SENSITIVE PERSON_DETAIL RELATIONSHIP PERSON_INTERNATIONAL	MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS	NA
SPBPERS_NAME_PREFIX	SPAPERS	REPORTING VIEW	CONSTITUENT_ENTITY RECEIVABLE_ACCOUNT PERSON_DETAIL ORGANIZATION_CONTACT RELATIONSHIP PERSON	NAME_PREFIX NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX RELATED_PREFIX NAME_PREFIX	NA
SPBPERS_NAME_SUFFIX	SPAPERS	REPORTING VIEW	ORGANIZATION_CONTACT PERSON_DETAIL CONSTITUENT PERSON RELATIONSHIP RECEIVABLE_ACCOUNT CONSTITUENT_ENTITY	CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX RELATED_SUFFIX NAME_SUFFIX NAME_SUFFIX	NA
SPBPERS_PIDM	NA	REPORTING VIEW	PERSON PERSON_VETERAN PERSON_SENSITIVE MEDICAL_INFORMATION_SLOT ORGANIZATION_ENTITY_ADDRESS PERSON_ADDRESS PERSON_INTERNATIONAL	PERSON_UID PERSON_UID PERSON_UID PERSON_UID ENTITY_UID PERSON_UID PERSON_UID	NA
SPBPERS_PPRN_CODE	SPAPERS	REPORTING VIEW	PERSON_SENSITIVE GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT PERSON_DETAIL GOVERNMENT_ADMISSIONS GOVERNMENT_FINANCIAL_AID PERSON CONSTITUENT	PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN	NA
SPBPERS_PREF_FIRST_NAME	SPAPERS	REPORTING VIEW	PERSON_DETAIL PERSON	PREFERRED_FIRST_NAME PREFERRED_FIRST_NAME	NA
SPBPERS_RELG_CODE	SPAPERS	REPORTING VIEW	PERSON_DETAIL PERSON_SENSITIVE PERSON	RELIGION RELIGION RELIGION	NA
SPBPERS_SDVET_IND	SPAPERS	REPORTING VIEW	PERSON STUDENT STUDENT_EXTENDED VETERAN_CERTIFICATION PERSON_VETERAN PERSON_DETAIL	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	RELATIONSHIP CONSTITUENT GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON_SENSITIVE PERSON PERSON_DETAIL	RELATED_GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER GENDER	NA
SPBPERS_SSN	SPAPERS	REPORTING VIEW	PERSON_SENSITIVE PERSON_INTERNATIONAL CROSS_REFERENCE_SLOT PERSON_VETERAN CROSS_REFERENCE_SLOT PERSON PERSON_DETAIL RECEIVABLE_ACCOUNT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT RELATIONSHIP GOVERNMENT_FINANCIAL_AID ORGANIZATION_ENTITY	TAX_ID TAX_ID RELATED_TAX_ID1 TAX_ID RELATED_TAX_ID3 TAX_ID TAX_ID TAX_ID RELATED_TAX_ID4 RELATED_TAX_ID2 RELATED_TAX_ID5 RELATED_CHILD_TAX_ID TAX_ID TAX_ID	NA
SPBPERS_VERA_IND	SPAPERS	REPORTING VIEW	VETERAN_CERTIFICATION STUDENT_EXTENDED PERSON STUDENT PERSON_DETAIL PERSON_VETERAN	VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY	NA
SPBPERS_VETC_FILE_NUMBER	SPAPERS	REPORTING VIEW	VETERAN_CERTIFICATION STUDENT_EXTENDED PERSON PERSON_DETAIL PERSON_VETERAN STUDENT	VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NO	NA

Ver: 9.2