Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: APRCHLD Advancement Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: APRCHLD - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
APRCHLD_ATYP_CODE APACHLD

REPORTING VIEW

RELATIONSHIP

RELATED_CHILD_ADDR_TYPE

NA
APRCHLD_CHLD_PIDM NA

REPORTING VIEW

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATIONSHIP

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATED_UID2

RELATED_UID1

RELATED_UID5

RELATED_UID

RELATED_UID4

RELATED_UID3

NA
APRCHLD_COMMENT APACHLD

REPORTING VIEW

RELATIONSHIP

RELATED_COMMENT

NA
APRCHLD_DECEASED_DATE APACHLD

REPORTING VIEW

RELATIONSHIP

RELATED_DECEASED_DATE

NA
APRCHLD_DECEASED_IND APACHLD

REPORTING VIEW

RELATIONSHIP

RELATED_DECEASED_IND

NA
APRCHLD_FIRST_NAME APACHLD

REPORTING VIEW

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATIONSHIP

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATED_FIRST_NAME5

RELATED_FIRST_NAME1

RELATED_FIRST_NAME3

RELATED_FIRST_NAME

RELATED_FIRST_NAME2

RELATED_FIRST_NAME4

NA
APRCHLD_LAST_NAME APACHLD

REPORTING VIEW

RELATIONSHIP

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATED_LAST_NAME

RELATED_LAST_NAME1

RELATED_LAST_NAME2

RELATED_LAST_NAME5

RELATED_LAST_NAME3

RELATED_LAST_NAME4

NA
APRCHLD_MI APACHLD

REPORTING VIEW

CROSS_REFERENCE_SLOT

RELATIONSHIP

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATED_MIDDLE_INITIAL3

RELATED_MIDDLE_INITIAL

RELATED_MIDDLE_INITIAL5

RELATED_MIDDLE_INITIAL2

RELATED_MIDDLE_INITIAL4

RELATED_MIDDLE_INITIAL1

NA
APRCHLD_PIDM NA

REPORTING VIEW

CROSS_REFERENCE_SLOT

RELATIONSHIP

ENTITY_UID

ENTITY_UID

NA
APRCHLD_SEQ_NO APACHLD

REPORTING VIEW

RELATIONSHIP

CHILD_ORDER_NUMBER

NA
APRCHLD_SSN APACHLD

REPORTING VIEW

RELATIONSHIP

RELATED_CHILD_TAX_ID

NA
APRCHLD_XREF_CODE APACHLD

REPORTING VIEW

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATIONSHIP

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

CROSS_REFERENCE_SLOT

RELATED_CROSS_REFERENCE2

RELATED_CROSS_REFERENCE4

RELATED_CROSS_REFERENCE

RELATED_CROSS_REFERENCE1

RELATED_CROSS_REFERENCE3

RELATED_CROSS_REFERENCE5

NA


Ver: 9.0