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

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_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

NA
SPBPERS_CITZ_CODE SPAPERS

REPORTING VIEW

GOVERNMENT_STUDENT

PERSON

PERSON_INTERNATIONAL

PERSON_DETAIL

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

PERSON_DETAIL

PERSON_VETERAN

CONSTITUENT

PERSON

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

NA
SPBPERS_CONFIRMED_RE_CDE SPAPERS

REPORTING VIEW

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

NA
SPBPERS_CONFIRMED_RE_DATE SPAPERS

REPORTING VIEW

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

NA
SPBPERS_DEAD_DATE SPAPERS

REPORTING VIEW

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

NA
SPBPERS_DEAD_IND SPAPERS

REPORTING VIEW

GIFT

PLEDGE

ORGANIZATION_CONTACT

PERSON_DETAIL

PERSON_VETERAN

RELATIONSHIP

PERSON

PERSON_INTERNATIONAL

CONSTITUENT

CONSTITUENT_ENTITY

DECEASED_STATUS

DECEASED_STATUS

CONTACT_DECEASED_IND

DECEASED_STATUS

DECEASED_STATUS

RELATED_DECEASED_IND

DECEASED_STATUS

DECEASED_STATUS

DECEASED_IND

DECEASED_IND

NA
SPBPERS_ETHN_CDE SPAPERS

REPORTING VIEW

GOVERNMENT_STUDENT

PERSON

PERSON_DETAIL

GOVERNMENT_FINANCIAL_AID

PERSON_SENSITIVE

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

HISPANIC_LATINO_ETHNICITY_IND

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

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_ADMISSIONS

PERSON_SENSITIVE

GOVERNMENT_ACADEMIC_OUTCOME

PERSON_DETAIL

PRIM_ETHNICITY_CATEGORY

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

NA
SPBPERS_LEGAL_NAME SPAPERS

REPORTING VIEW

PERSON_DETAIL

PERSON

LEGAL_NAME

LEGAL_NAME

NA
SPBPERS_LGCY_CODE SPAPERS

REPORTING VIEW

PERSON_SENSITIVE

PERSON_DETAIL

PERSON

LEGACY

LEGACY

LEGACY

NA
SPBPERS_MRTL_CODE SPAPERS

REPORTING VIEW

PERSON_INTERNATIONAL

RELATIONSHIP

PERSON

PERSON_SENSITIVE

CONSTITUENT

PERSON_DETAIL

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

NA
SPBPERS_NAME_PREFIX SPAPERS

REPORTING VIEW

RELATIONSHIP

CONSTITUENT_ENTITY

ORGANIZATION_CONTACT

PERSON

RECEIVABLE_ACCOUNT

PERSON_DETAIL

RELATED_PREFIX

NAME_PREFIX

CONTACT_NAME_PREFIX

NAME_PREFIX

NAME_PREFIX

NAME_PREFIX

NA
SPBPERS_NAME_SUFFIX SPAPERS

REPORTING VIEW

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

NA
SPBPERS_PIDM NA

REPORTING VIEW

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

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

PERSON_SENSITIVE

PERSON_DETAIL

RELIGION

RELIGION

RELIGION

NA
SPBPERS_SDVET_IND SPAPERS

REPORTING VIEW

STUDENT_EXTENDED

PERSON

PERSON_VETERAN

STUDENT

VETERAN_CERTIFICATION

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

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

NA
SPBPERS_SSN SPAPERS

REPORTING VIEW

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

NA
SPBPERS_VERA_IND SPAPERS

REPORTING VIEW

PERSON

STUDENT_EXTENDED

VETERAN_CERTIFICATION

PERSON_VETERAN

STUDENT

PERSON_DETAIL

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

NA
SPBPERS_VETC_FILE_NUMBER SPAPERS

REPORTING VIEW

PERSON

STUDENT

VETERAN_CERTIFICATION

PERSON_DETAIL

PERSON_VETERAN

STUDENT_EXTENDED

VETERAN_FILE_NUMBER

VETERAN_FILE_NO

VETERAN_FILE_NO

VETERAN_FILE_NO

VETERAN_FILE_NUMBER

VETERAN_FILE_NO

NA


Ver: 9.0