Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SPBPERS Student Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: SPBPERS - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
SPBPERS_ACTIVE_DUTY_SEPR_DATE TBD NO

REPORTING VIEW

PERSON_DETAIL

PERSON_VETERAN

PERSON

MILITARY_SEPARATION_DATE

MILITARY_SEPARATION_DATE

MILITARY_SEPARATION_DATE

NO

NO

NO

 
SPBPERS_BIRTH_DATE SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_CITZ_CODE SPAPERS NO

REPORTING VIEW

PERSON_INTERNATIONAL

PERSON

PERSON_DETAIL

GOVERNMENT_STUDENT

CITIZENSHIP_TYPE

CITIZENSHIP_TYPE

CITIZENSHIP_TYPE

CITIZENSHIP_TYPE

NO

NO

NO

NO

NA
SPBPERS_CITZ_IND STVCITZ NO

REPORTING VIEW

GOVERNMENT_ADMISSIONS

GOVERNMENT_STUDENT

CITIZENSHIP_IND

CITIZENSHIP_IND

NO

NO

NA
SPBPERS_CONFID_IND SPAPERS NO

REPORTING VIEW

CONSTITUENT

PERSON

PERSON_VETERAN

PERSON_DETAIL

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

NO

NO

NO

NO

NA
SPBPERS_CONFIRMED_RE_CDE SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_CONFIRMED_RE_DATE SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_DEAD_DATE SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_DEAD_IND SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_ETHN_CDE SPAPERS NO

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

NO

NO

NO

NO

NO

NO

 
SPBPERS_ETHN_CODE SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_GNDR_CODE SPAPERS NO

REPORTING VIEW

GOVERNMENT_ADMISSIONS

PERSON_DETAIL

PERSON

GOVERNMENT_STUDENT

CONSTITUENT

PERSON_SENSITIVE

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_FINANCIAL_AID

GENDER_DESIGNATION

GENDER_DESIGNATION

GENDER_DESIGNATION

GENDER_DESIGNATION

GENDER_DESIGNATION

GENDER_DESIGNATION

GENDER_DESIGNATION

GENDER_DESIGNATION

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_LEGAL_NAME SPAPERS NO

REPORTING VIEW

PERSON

PERSON_DETAIL

LEGAL_NAME

LEGAL_NAME

NO

NO

NA
SPBPERS_LGCY_CODE SPAPERS NO

REPORTING VIEW

PERSON_DETAIL

PERSON

PERSON_SENSITIVE

LEGACY

LEGACY

LEGACY

NO

NO

NO

NA
SPBPERS_MRTL_CODE SPAPERS NO

REPORTING VIEW

CONSTITUENT

PERSON

PERSON_INTERNATIONAL

PERSON_DETAIL

RELATIONSHIP

PERSON_SENSITIVE

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

NO

NO

NO

NO

NO

NO

NA
SPBPERS_NAME_PREFIX SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NA
SPBPERS_NAME_SUFFIX SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_PIDM NA NO

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

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_PPRN_CODE SPAPERS NO

REPORTING VIEW

CONSTITUENT

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_STUDENT

GOVERNMENT_ADMISSIONS

PERSON

PERSON_DETAIL

GOVERNMENT_FINANCIAL_AID

PERSON_SENSITIVE

PERSONAL_PRONOUN

PERSONAL_PRONOUN

PERSONAL_PRONOUN

PERSONAL_PRONOUN

PERSONAL_PRONOUN

PERSONAL_PRONOUN

PERSONAL_PRONOUN

PERSONAL_PRONOUN

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_PREF_FIRST_NAME SPAPERS NO

REPORTING VIEW

PERSON

PERSON_DETAIL

PREFERRED_FIRST_NAME

PREFERRED_FIRST_NAME

NO

NO

NA
SPBPERS_RELG_CODE SPAPERS NO

REPORTING VIEW

PERSON_SENSITIVE

PERSON

PERSON_DETAIL

RELIGION

RELIGION

RELIGION

NO

NO

NO

NA
SPBPERS_SDVET_IND SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NA
SPBPERS_SEX SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_SSN SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPBPERS_VERA_IND SPAPERS NO

REPORTING VIEW

STUDENT

PERSON_VETERAN

VETERAN_CERTIFICATION

PERSON

STUDENT_EXTENDED

PERSON_DETAIL

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

NO

NO

NO

NO

NO

NO

NA
SPBPERS_VETC_FILE_NUMBER SPAPERS NO

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

NO

NO

NO

NO

NO

NO

NA


Ver: 9.2