Reporting View Source: APRCSPS

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: APRCSPS Advancement Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
APRCSPS_DEAD_DATE	APACONS	RELATIONSHIP	RELATED_DECEASED_DATE
APRCSPS_DEAD_IND	APACONS	RELATIONSHIP	RELATED_DECEASED_IND
APRCSPS_FIRST_NAME	APACONS	RELATIONSHIP	RELATED_FIRST_NAME
APRCSPS_LAST_NAME	APACONS	RELATIONSHIP	RELATED_LAST_NAME
APRCSPS_MAIDEN_NAME	APACONS	RELATIONSHIP	RELATED_MAIDEN_NAME
APRCSPS_MARS_IND	APACONS	RELATIONSHIP	SPOUSE_STATUS
APRCSPS_MI	APACONS	RELATIONSHIP	RELATED_MIDDLE_INITIAL
APRCSPS_MRTL_END_DATE	APACONS	RELATIONSHIP	MARRIAGE_END_DATE
APRCSPS_MRTL_START_DATE	APACONS	RELATIONSHIP	MARRIAGE_START_DATE
APRCSPS_NAME_PREFIX	APACONS	RELATIONSHIP	RELATED_PREFIX
APRCSPS_NAME_SUFFIX	APACONS	RELATIONSHIP	RELATED_SUFFIX
APRCSPS_PIDM	NA	RELATIONSHIP CROSS_REFERENCE_SLOT	ENTITY_UID ENTITY_UID
APRCSPS_SPS_COMMENT	APACONS	RELATIONSHIP	RELATED_COMMENT
APRCSPS_SPS_PIDM	NA	CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT RELATIONSHIP CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT	RELATED_UID2 RELATED_UID5 RELATED_UID RELATED_UID1 RELATED_UID3 RELATED_UID4
APRCSPS_XREF_CODE	APACONS	RELATIONSHIP CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT	RELATED_CROSS_REFERENCE RELATED_CROSS_REFERENCE1 RELATED_CROSS_REFERENCE3 RELATED_CROSS_REFERENCE4 RELATED_CROSS_REFERENCE2 RELATED_CROSS_REFERENCE5

Ver: 8.3