Composite View Source: SPBPERS

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

**Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SPBPERS_ACTIVE_DUTY_SEPR_DATE	TBD
SPBPERS_BIRTH_DATE	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	BIRTH_DATE BIRTH_DATE	NA
SPBPERS_CITZ_CODE		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	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	DECEASED_DATE DECEASED_DATE	NA
SPBPERS_DEAD_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON AA_ORGANIZATION_CONTACT	DECEASED_STATUS CONTACT_DECEASED_IND	NA
SPBPERS_ETHN_CDE	SPAPERS	COMPOSITE VIEW	AS_PERSON	HISPANIC_LATINO_ETHNICITY_IND
SPBPERS_ETHN_CODE		COMPOSITE VIEW	AS_PERSON AS_PERSON	PRIMARY_ETHNICITY PRIMARY_ETHNICITY
SPBPERS_GNDR_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON	GENDER_DESIGNATION	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		COMPOSITE VIEW	AS_PERSON AS_PERSON	MARITAL_STATUS MARITAL_STATUS
SPBPERS_NAME_PREFIX		COMPOSITE VIEW	AS_PERSON AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT AT_ACCOUNT	NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX NAME_PREFIX
SPBPERS_NAME_SUFFIX		COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON	CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX
SPBPERS_PIDM	NA				NA
SPBPERS_PPRN_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON	PERSONAL_PRONOUN	NA
SPBPERS_PREF_FIRST_NAME	SPAPERS	COMPOSITE VIEW	AS_PERSON	PREFERRED_FIRST_NAME	NA
SPBPERS_RELG_CODE	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	RELIGION RELIGION	NA
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	AS_PERSON AA_RELATIONSHIP AT_ACCOUNT	TAX_ID RELATED_CHILD_TAX_ID SSN	NA
SPBPERS_VERA_IND	SPAPERS	COMPOSITE VIEW	AS_PERSON AS_PERSON	VETERAN_CATEGORY VETERAN_CATEGORY	NA
SPBPERS_VETC_FILE_NUMBER	SPAPERS	COMPOSITE VIEW	AS_PERSON	VETERAN_FILE_NO	NA

Ver: