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	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
SPBPERS_ACTIVE_DUTY_SEPR_DATE	TBD	NO
SPBPERS_BIRTH_DATE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	BIRTH_DATE	NO	NA
SPBPERS_CITZ_CODE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	CITIZENSHIP_TYPE	NO	NA
SPBPERS_CITZ_IND	STVCITZ	NO					NA
SPBPERS_CONFID_IND	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	CONFIDENTIALITY_IND	NO	NA
SPBPERS_CONFIRMED_RE_CDE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	RACE_ETHNICITY_CONFIRM_IND	NO	NA
SPBPERS_CONFIRMED_RE_DATE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	RACE_ETHNICITY_CONFIRM_DATE	NO	NA
SPBPERS_DEAD_DATE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	DECEASED_DATE	NO	NA
SPBPERS_DEAD_IND	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON AA_ORGANIZATION_CONTACT	DECEASED_STATUS CONTACT_DECEASED_IND	NO NO	NA
SPBPERS_ETHN_CDE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	HISPANIC_LATINO_ETHNICITY_IND	NO
SPBPERS_ETHN_CODE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	PRIMARY_ETHNICITY	NO	NA
SPBPERS_GNDR_CODE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	GENDER_DESIGNATION	NO	NA
SPBPERS_LEGAL_NAME	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	LEGAL_NAME	NO	NA
SPBPERS_LGCY_CODE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	LEGACY	NO	NA
SPBPERS_MRTL_CODE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	MARITAL_STATUS	NO	NA
SPBPERS_NAME_PREFIX	SPAPERS	NO	COMPOSITE VIEW	AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT	NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX	NO NO NO	NA
SPBPERS_NAME_SUFFIX	SPAPERS	NO	COMPOSITE VIEW	AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT	NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX	NO NO NO	NA
SPBPERS_PIDM	NA	NO					NA
SPBPERS_PPRN_CODE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	PERSONAL_PRONOUN	NO	NA
SPBPERS_PREF_FIRST_NAME	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	PREFERRED_FIRST_NAME	NO	NA
SPBPERS_RELG_CODE	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	RELIGION	NO	NA
SPBPERS_SDVET_IND	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	VETERAN_SPECIAL_DISABLED_IND	NO	NA
SPBPERS_SEX	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	GENDER	NO	NA
SPBPERS_SSN	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON AA_RELATIONSHIP AT_ACCOUNT	TAX_ID RELATED_CHILD_TAX_ID SSN	NO NO NO	NA
SPBPERS_VERA_IND	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	VETERAN_CATEGORY	NO	NA
SPBPERS_VETC_FILE_NUMBER	SPAPERS	NO	COMPOSITE VIEW	AS_PERSON	VETERAN_FILE_NO	NO	NA

Ver: