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

Ver: 9.1