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_DETAIL

PERSON_VETERAN

PERSON

MILITARY_SEPARATION_DATE

MILITARY_SEPARATION_DATE

MILITARY_SEPARATION_DATE

 
SPBPERS_BIRTH_DATE SPAPERS

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

NA
SPBPERS_CITZ_CODE SPAPERS

REPORTING VIEW

PERSON_INTERNATIONAL

PERSON

PERSON_DETAIL

GOVERNMENT_STUDENT

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

CONSTITUENT

PERSON

PERSON_VETERAN

PERSON_DETAIL

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

NA
SPBPERS_CONFIRMED_RE_CDE SPAPERS

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

NA
SPBPERS_CONFIRMED_RE_DATE SPAPERS

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

NA
SPBPERS_DEAD_DATE SPAPERS

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

NA
SPBPERS_DEAD_IND SPAPERS

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

NA
SPBPERS_ETHN_CDE SPAPERS

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

 
SPBPERS_ETHN_CODE SPAPERS

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

NA
SPBPERS_LEGAL_NAME SPAPERS

REPORTING VIEW

PERSON

PERSON_DETAIL

LEGAL_NAME

LEGAL_NAME

NA
SPBPERS_LGCY_CODE SPAPERS

REPORTING VIEW

PERSON_DETAIL

PERSON

PERSON_SENSITIVE

LEGACY

LEGACY

LEGACY

NA
SPBPERS_MRTL_CODE SPAPERS

REPORTING VIEW

CONSTITUENT

PERSON

PERSON_INTERNATIONAL

PERSON_DETAIL

RELATIONSHIP

PERSON_SENSITIVE

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

MARITAL_STATUS

NA
SPBPERS_NAME_PREFIX SPAPERS

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

NA
SPBPERS_NAME_SUFFIX SPAPERS

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

NA
SPBPERS_PIDM NA

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

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_SENSITIVE

PERSON

PERSON_DETAIL

RELIGION

RELIGION

RELIGION

NA
SPBPERS_SDVET_IND SPAPERS

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

NA
SPBPERS_SEX SPAPERS

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

NA
SPBPERS_SSN SPAPERS

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

NA
SPBPERS_VERA_IND SPAPERS

REPORTING VIEW

STUDENT

PERSON_VETERAN

VETERAN_CERTIFICATION

PERSON

STUDENT_EXTENDED

PERSON_DETAIL

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

NA
SPBPERS_VETC_FILE_NUMBER SPAPERS

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

NA


Ver: 8.5