Composite View Source: APVXREF

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
APVXREF_CM_PRI_IND	APACONS				NA
APVXREF_EMPLOYER_IND	APVXREF	COMPOSITE VIEW	AA_RELATIONSHIP	EMPLOYER_IND	NA
APVXREF_MATCH_GIFT_IND	APACONS	COMPOSITE VIEW	AA_RELATIONSHIP	MATCHING_GIFT_IND	NA
APVXREF_PIDM	NA	COMPOSITE VIEW	AA_RELATIONSHIP	ENTITY_UID	NA
APVXREF_REVERSE_XREF	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	REVERSE_CROSS_REFERENCE	NA
APVXREF_SPOUSE_IND	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	SPOUSE_IND	NA
APVXREF_XREF_ATYP_CODE_PREF	APAXREF				NA
APVXREF_XREF_BIRTH_DATE	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_BIRTH_DATE	NA
APVXREF_XREF_CODE	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_CROSS_REFERENCE	NA
APVXREF_XREF_DEAD_DATE	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_DECEASED_DATE	NA
APVXREF_XREF_DEAD_IND	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_DECEASED_IND	NA
APVXREF_XREF_FIRST_NAME	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_FIRST_NAME	NA
APVXREF_XREF_FULL_NAME	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_COMBINED_NAME	NA
APVXREF_XREF_LAST_NAME	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_LAST_NAME	NA
APVXREF_XREF_MAIDEN_LAST_NAME	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_MAIDEN_NAME	NA
APVXREF_XREF_MI	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_MIDDLE_INITIAL	NA
APVXREF_XREF_MRTL_CODE	APACONS	COMPOSITE VIEW	AA_RELATIONSHIP	MARITAL_STATUS	NA
APVXREF_XREF_NAME_PREFIX	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_PREFIX	NA
APVXREF_XREF_NAME_SUFFIX	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_SUFFIX	NA
APVXREF_XREF_PIDM	NA	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_UID	NA
APVXREF_XREF_SEX	APAXREF	COMPOSITE VIEW	AA_RELATIONSHIP	RELATED_GENDER	NA
APVXREF_XREF_SSN	APAXREF				NA

Ver: 8.1