RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: APRCSPS Advancement Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: APRCSPS

Source Column Source Form Target Type Target Target Column Calculation Formula
APRCSPS_DEAD_DATE APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_DECEASED_DATE

NA
APRCSPS_DEAD_IND APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_DECEASED_IND

NA
APRCSPS_FIRST_NAME APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_FIRST_NAME

NA
APRCSPS_LAST_NAME APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_LAST_NAME

NA
APRCSPS_MAIDEN_NAME APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_MAIDEN_NAME

NA
APRCSPS_MARS_IND APACONS

REPORTING VIEW

RELATIONSHIP

SPOUSE_STATUS

NA
APRCSPS_MI APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_MIDDLE_INITIAL

NA
APRCSPS_MRTL_END_DATE APACONS

REPORTING VIEW

RELATIONSHIP

MARRIAGE_END_DATE

NA
APRCSPS_MRTL_START_DATE APACONS

REPORTING VIEW

RELATIONSHIP

MARRIAGE_START_DATE

NA
APRCSPS_NAME_PREFIX APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_PREFIX

NA
APRCSPS_NAME_SUFFIX APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_SUFFIX

NA
APRCSPS_PIDM NA

REPORTING VIEW

RELATIONSHIP

CROSS_REFERENCE_SLOT

ENTITY_UID

ENTITY_UID

NA
APRCSPS_SPS_COMMENT APACONS

REPORTING VIEW

RELATIONSHIP

RELATED_COMMENT

NA
APRCSPS_SPS_PIDM NA

REPORTING VIEW

RELATIONSHIP

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATED_UID

RELATED_UID1

RELATED_UID2

RELATED_UID4

RELATED_UID5

RELATED_UID3

NA
APRCSPS_XREF_CODE APACONS

REPORTING VIEW

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATIONSHIP

CROSS_REFERENCE_SLOT

RELATED_CROSS_REFERENCE1

RELATED_CROSS_REFERENCE5

RELATED_CROSS_REFERENCE2

RELATED_CROSS_REFERENCE4

RELATED_CROSS_REFERENCE

RELATED_CROSS_REFERENCE3

NA


Ver: 3.1