Composite View Source: APVCSPS

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: APVCSPS Advancement

**SGHE Banner Operational Data Store**
Banner Source Name	Banner Source Column	Banner Business Name	Source Form	Banner Business Definition	Banner Business Acronym	ODS Target	ODS Target Column
	APVCSPS_ATYP_CODE_PREF		APACSPS
	APVCSPS_BIRTH_DATE		APACSPS			AA_RELATIONSHIP	RELATED_BIRTH_DATE
	APVCSPS_DEAD_DATE		APACSPS			AA_RELATIONSHIP	RELATED_DECEASED_DATE
	APVCSPS_DEAD_IND		APACSPS			AA_RELATIONSHIP	RELATED_DECEASED_IND
	APVCSPS_FIRST_NAME		APACSPS			AA_RELATIONSHIP	RELATED_FIRST_NAME
	APVCSPS_LAST_NAME		APACSPS			AA_RELATIONSHIP	RELATED_LAST_NAME
	APVCSPS_MAIDEN_NAME		APACSPS			AA_RELATIONSHIP	RELATED_MAIDEN_NAME
	APVCSPS_MARS_IND		APACONS
	APVCSPS_MI		APACSPS			AA_RELATIONSHIP	RELATED_MIDDLE_INITIAL
	APVCSPS_MRTL_CODE		APACONS			AA_RELATIONSHIP	MARITAL_STATUS
	APVCSPS_MRTL_END_DATE		APACONS			AA_RELATIONSHIP	MARRIAGE_END_DATE
	APVCSPS_MRTL_START_DATE		APACONS			AA_RELATIONSHIP	MARRIAGE_START_DATE
	APVCSPS_NAME_PREFIX		APACSPS			AA_RELATIONSHIP	RELATED_PREFIX
	APVCSPS_NAME_SUFFIX		APACSPS			AA_RELATIONSHIP	RELATED_SUFFIX
	APVCSPS_PIDM		NA			AA_RELATIONSHIP	ENTITY_UID
	APVCSPS_SEX		APACSPS			AA_RELATIONSHIP	RELATED_GENDER
	APVCSPS_SPOUSE_NAME		APACSPS			AA_RELATIONSHIP	RELATED_COMBINED_NAME
	APVCSPS_SPS_COMMENT		APACSPS			AA_RELATIONSHIP	RELATED_COMMENT
	APVCSPS_SPS_PIDM		NA			AA_RELATIONSHIP	RELATED_UID
	APVCSPS_SSN		APACSPS
	APVCSPS_XREF_CODE		APACSPS			AA_RELATIONSHIP	RELATED_CROSS_REFERENCE

Ver: 8.3