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_ACTIVE_DUTY_SEPR_DATE	TBD
SPBPERS_BIRTH_DATE	TBD	COMPOSITE VIEW	AS_PERSON AS_PERSON	BIRTH_DATE BIRTH_DATE
SPBPERS_CITZ_CODE	TBD	COMPOSITE VIEW	AS_PERSON AS_PERSON	CITIZENSHIP_TYPE CITIZENSHIP_TYPE
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	TBD	COMPOSITE VIEW	AS_PERSON AS_PERSON	DECEASED_DATE DECEASED_DATE
SPBPERS_DEAD_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON	DECEASED_STATUS	NA
SPBPERS_ETHN_CDE	SPAPERS	COMPOSITE VIEW	AS_PERSON	HISPANIC_LATINO_ETHNICITY_IND
SPBPERS_ETHN_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	PRIMARY_ETHNICITY PRIMARY_ETHNICITY	NA
SPBPERS_LEGAL_NAME	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	LEGAL_NAME LEGAL_NAME	NA
SPBPERS_LGCY_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	LEGACY LEGACY	NA
SPBPERS_MRTL_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	MARITAL_STATUS MARITAL_STATUS	NA
SPBPERS_NAME_PREFIX	TBD	COMPOSITE VIEW	AS_PERSON AT_ACCOUNT AA_ORGANIZATION_CONTACT AS_PERSON AT_ACCOUNT AA_ORGANIZATION_CONTACT	NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX
SPBPERS_NAME_SUFFIX	TBD	COMPOSITE VIEW	AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT	NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX
SPBPERS_PIDM	NA				NA
SPBPERS_PREF_FIRST_NAME	SPAPERS	COMPOSITE VIEW	AS_PERSON	PREFERRED_FIRST_NAME	NA
SPBPERS_RELG_CODE	TBD	COMPOSITE VIEW	AS_PERSON AS_PERSON	RELIGION RELIGION
SPBPERS_SDVET_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON	VETERAN_SPECIAL_DISABLED_IND	NA
SPBPERS_SEX	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	GENDER GENDER	NA
SPBPERS_SSN	SPAPERS	COMPOSITE VIEW	AA_RELATIONSHIP AT_ACCOUNT AS_PERSON	RELATED_CHILD_TAX_ID SSN TAX_ID	NA
SPBPERS_VERA_IND	TBD	COMPOSITE VIEW	AS_PERSON AS_PERSON	VETERAN_CATEGORY VETERAN_CATEGORY
SPBPERS_VETC_FILE_NUMBER	SPAPERS	COMPOSITE VIEW	AS_PERSON	VETERAN_FILE_NO	NA

Ver: