Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: APVXREF Advancement
SGHE Banner Operational Data Store Composite View Source: APVXREF - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
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_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


Ver: