Composite View Source: SPBPERS

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SPBPERS Student

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SPBPERS_BIRTH_DATE	SPAPERS	COMPOSITE VIEW	AS_PERSON	BIRTH_DATE	NA
SPBPERS_CITZ_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON	CITIZENSHIP_TYPE	NA
SPBPERS_CITZ_IND	STVCITZ				NA
SPBPERS_CONFID_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON	CONFIDENTIALITY_IND	NA
SPBPERS_CONFIRMED_RE_CDE	SPAPERS	COMPOSITE VIEW	AS_PERSON	RACE_ETHNICITY_CONFIRM_IND	NA
SPBPERS_CONFIRMED_RE_DATE	SPAPERS	COMPOSITE VIEW	AS_PERSON	RACE_ETHNICITY_CONFIRM_DATE	NA
SPBPERS_DEAD_DATE	SPAPERS	COMPOSITE VIEW	AS_PERSON	DECEASED_DATE	NA
SPBPERS_DEAD_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON	DECEASED_STATUS	NA
SPBPERS_ETHN_CDE	SPAPERS				NA
SPBPERS_ETHN_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	HISPANIC_LATINO_ETHNICITY_IND PRIMARY_ETHNICITY	NA
SPBPERS_LEGAL_NAME	SPAPERS	COMPOSITE VIEW	AS_PERSON	LEGAL_NAME	NA
SPBPERS_LGCY_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON	LEGACY	NA
SPBPERS_MRTL_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON	MARITAL_STATUS	NA
SPBPERS_NAME_PREFIX	SPAPERS	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON	CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX	NA
SPBPERS_NAME_SUFFIX	SPAPERS	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON	CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX	NA
SPBPERS_PIDM	NA				NA
SPBPERS_PREF_FIRST_NAME	SPAPERS	COMPOSITE VIEW	AS_PERSON	PREFERRED_FIRST_NAME	NA
SPBPERS_RELG_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON	RELIGION	NA
SPBPERS_SDVET_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON	VETERAN_SPECIAL_DISABLED_IND	NA
SPBPERS_SEX	SPAPERS	COMPOSITE VIEW	AS_PERSON	GENDER	NA
SPBPERS_SSN	SPAPERS	COMPOSITE VIEW	AT_ACCOUNT AA_RELATIONSHIP AS_PERSON	SSN RELATED_CHILD_TAX_ID TAX_ID	NA
SPBPERS_VERA_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON	VETERAN_CATEGORY	NA
SPBPERS_VETC_FILE_NUMBER	SPAPERS	COMPOSITE VIEW	AS_PERSON	VETERAN_FILE_NO	NA

Ver: 8.1