Composite View Source: SPBPERS

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

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

Ver: 8.3