RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: APVCSPS Advancement Composite View Reports
SGHE Operational Data Store Composite View Source: APVCSPS

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: 3.1