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

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
APVCSPS_BIRTH_DATE APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_BIRTH_DATE

NO

NA
APVCSPS_DEAD_DATE APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_DECEASED_DATE

NO

NA
APVCSPS_DEAD_IND APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_DECEASED_IND

NO

NA
APVCSPS_FIRST_NAME APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_FIRST_NAME

NO

NA
APVCSPS_LAST_NAME APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_LAST_NAME

NO

NA
APVCSPS_MAIDEN_NAME APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_MAIDEN_NAME

NO

NA
APVCSPS_MI APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_MIDDLE_INITIAL

NO

NA
APVCSPS_MRTL_CODE APACONS NO COMPOSITE VIEW

AA_RELATIONSHIP

MARITAL_STATUS

NO

NA
APVCSPS_MRTL_END_DATE APACONS NO COMPOSITE VIEW

AA_RELATIONSHIP

MARRIAGE_END_DATE

NO

NA
APVCSPS_MRTL_START_DATE APACONS NO COMPOSITE VIEW

AA_RELATIONSHIP

MARRIAGE_START_DATE

NO

NA
APVCSPS_NAME_PREFIX APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_PREFIX

NO

NA
APVCSPS_NAME_SUFFIX APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_SUFFIX

NO

NA
APVCSPS_PIDM NA NO COMPOSITE VIEW

AA_RELATIONSHIP

ENTITY_UID

NO

NA
APVCSPS_SEX APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_GENDER

NO

NA
APVCSPS_SPOUSE_NAME APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_COMBINED_NAME

NO

NA
APVCSPS_SPS_COMMENT APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_COMMENT

NO

NA
APVCSPS_SPS_PIDM NA NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_UID

NO

NA
APVCSPS_XREF_CODE APACSPS NO COMPOSITE VIEW

AA_RELATIONSHIP

RELATED_CROSS_REFERENCE

NO

NA


Ver: