Composite View Source: APVCSPS

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

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

Ver: 8.1