RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SPBPERS Student Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: SPBPERS

Source Column Source Form Target Type Target Target Column Calculation Formula
SPBPERS_BIRTH_DATE SPAPERS

REPORTING VIEW

PERSON

PERSON_SENSITIVE

PERSON_VETERAN

CONSTITUENT_ENTITY

GOVERNMENT_STUDENT

GOVERNMENT_ADMISSIONS

RELATIONSHIP

GOVERNMENT_FINANCIAL_AID

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

PERSON

PERSON_INTERNATIONAL

PERSON_DETAIL

GOVERNMENT_STUDENT

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

PERSON_DETAIL

PERSON_VETERAN

PERSON

CONSTITUENT

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

CONFIDENTIALITY_IND

NA
SPBPERS_CONFIRMED_RE_CDE SPAPERS

REPORTING VIEW

GOVERNMENT_ACADEMIC_OUTCOME

PERSON_DETAIL

PERSON_SENSITIVE

PERSON

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_ADMISSIONS

GOVERNMENT_STUDENT

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_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

PERSON_SENSITIVE

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_STUDENT

PERSON_DETAIL

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

PLEDGE

PERSON_VETERAN

PERSON_DETAIL

RELATIONSHIP

PERSON_INTERNATIONAL

GIFT

DECEASED_DATE

DECEASED_DATE

DECEASED_DATE

DECEASED_DATE

RELATED_DECEASED_DATE

DECEASED_DATE

DECEASED_DATE

NA
SPBPERS_DEAD_IND SPAPERS

REPORTING VIEW

CONSTITUENT

PERSON

PLEDGE

PERSON_DETAIL

PERSON_INTERNATIONAL

GIFT

CONSTITUENT_ENTITY

RELATIONSHIP

PERSON_VETERAN

DECEASED_IND

DECEASED_STATUS

DECEASED_STATUS

DECEASED_STATUS

DECEASED_STATUS

DECEASED_STATUS

DECEASED_IND

RELATED_DECEASED_IND

DECEASED_STATUS

NA
SPBPERS_ETHN_CDE SPAPERS       NA
SPBPERS_ETHN_CODE SPAPERS

REPORTING VIEW

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_STUDENT

PERSON_DETAIL

PERSON_DETAIL

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_FINANCIAL_AID

PERSON_SENSITIVE

GOVERNMENT_STUDENT

PERSON

PERSON

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

PERSON_SENSITIVE

HISPANIC_LATINO_ETHNICITY_IND

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

PRIMARY_ETHNICITY

HISPANIC_LATINO_ETHNICITY_IND

HISPANIC_LATINO_ETHNICITY_IND

PRIMARY_ETHNICITY

PRIM_ETHNICITY_CATEGORY

HISPANIC_LATINO_ETHNICITY_IND

HISPANIC_LATINO_ETHNICITY_IND

HISPANIC_LATINO_ETHNICITY_IND

PRIMARY_ETHNICITY

HISPANIC_LATINO_ETHNICITY_IND

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_SENSITIVE

PERSON

PERSON_DETAIL

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

RELATIONSHIP

RECEIVABLE_ACCOUNT

ORGANIZATION_CONTACT

RELATED_PREFIX

NAME_PREFIX

CONTACT_NAME_PREFIX

NA
SPBPERS_NAME_SUFFIX SPAPERS

REPORTING VIEW

ORGANIZATION_CONTACT

CONSTITUENT

PERSON

PERSON_DETAIL

RECEIVABLE_ACCOUNT

RELATIONSHIP

CONTACT_NAME_SUFFIX

NAME_SUFFIX

NAME_SUFFIX

NAME_SUFFIX

NAME_SUFFIX

RELATED_SUFFIX

NA
SPBPERS_PIDM NA

REPORTING VIEW

PERSON_SENSITIVE

ORGANIZATION_ENTITY_ADDRESS

MEDICAL_INFORMATION_SLOT

PERSON

PERSON_INTERNATIONAL

PERSON_ADDRESS

PERSON_VETERAN

PERSON_UID

ENTITY_UID

PERSON_UID

PERSON_UID

PERSON_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_DETAIL

PERSON_SENSITIVE

RELIGION

RELIGION

RELIGION

NA
SPBPERS_SDVET_IND SPAPERS

REPORTING VIEW

STUDENT

PERSON_DETAIL

PERSON_VETERAN

PERSON

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_DETAIL

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_ADMISSIONS

PERSON_SENSITIVE

RELATIONSHIP

PERSON

CONSTITUENT

GOVERNMENT_ACADEMIC_OUTCOME

GENDER

GENDER

GENDER

GENDER

GENDER

RELATED_GENDER

GENDER

GENDER

GENDER

NA
SPBPERS_SSN SPAPERS

REPORTING VIEW

ORGANIZATION_ENTITY

PERSON_VETERAN

CROSS_REFERENCE_SLOT

PERSON_SENSITIVE

RECEIVABLE_ACCOUNT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

PERSON_DETAIL

PERSON

GOVERNMENT_FINANCIAL_AID

RELATIONSHIP

PERSON_INTERNATIONAL

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

TAX_ID

TAX_ID

RELATED_TAX_ID3

TAX_ID

TAX_ID

RELATED_TAX_ID1

RELATED_TAX_ID2

TAX_ID

TAX_ID

TAX_ID

RELATED_CHILD_TAX_ID

TAX_ID

RELATED_TAX_ID4

RELATED_TAX_ID5

NA
SPBPERS_VERA_IND SPAPERS

REPORTING VIEW

STUDENT

PERSON

PERSON_DETAIL

PERSON_VETERAN

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

VETERAN_CATEGORY

NA
SPBPERS_VETC_FILE_NUMBER SPAPERS

REPORTING VIEW

PERSON_DETAIL

PERSON

STUDENT

PERSON_VETERAN

VETERAN_FILE_NO

VETERAN_FILE_NUMBER

VETERAN_FILE_NO

VETERAN_FILE_NUMBER

NA


Ver: 3.1