Entity Registry and PDL Transactions

The entities for all core data records within the constituent and prospect/admissions data areas needed for PDL transactions are delivered with the system within the Entity Registry component.

Delivered Entities Related to Prospect/Admissions Data

At the time of delivering this document, the following entities are delivered for the prospect/admissions staging records and matching production records:

Entity Name	Staging Record Names	Production Record Names
Prospect/Admissions Data Load	SAD_PDL_HDR_STG	**SAD_PDL_HDR_WRK
Prospect Career	SAD_PRS_CAR_STG	ADM_PRSPCT_CAR
Prospect Program	SAD_PRS_PRG_STG	ADM_PRSPCT_PROG
Prospect Plan	SAD_PRS_PLN_STG	ADM_PRSPCT_PLAN
Prospect Sub-Plan	SAD_PRS_SBP_STG	ADM_PRSPCT_SBPL
Prospect Recruiting Category	SAD_PRS_RCR_STG	PRSPCT_RCR_CAT
Prospect Recruiter	SAD_PRS_REC_STG	PRSPCT_RECRTER
Prospect CAF	SAD_STG_PRS_CAF	SAD_PRSPCT_CAF
*Test Score	SCC_STG_TEST	STDNT_TEST
*Test Score Component	SCC_STG_TESTCMP	STDNT_TEST_COMP
*Test Date	SCC_STG_TESTDT	SAD_TESTDT
*Test CAF	SAD_STG_TST_CAF	SAD_TESTDT_CAF
*Academic History	SCC_STG_ACADHST	ACAD_HISTORY
*External Academic Data	SCC_STG_EXACDDT	EXT_ACAD_DATA
*External Education Comment	SCC_STG_EXEDCOM	SAD_EXT_ED_COM
*External Academic Summary	SCC_STG_EXACDSM	EXT_ACAD_SUM
*External Academic Subject	SCC_STG_EXACDSB	EXT_ACAD_SUBJ
*External Academic Data (CAN)	SCC_STG_CANEXAC	CAN_EXT_ACAD_DA
*External Course	SCC_STG_EXTCRS	EXT_COURSE
*External Course Communication	SCC_STG_CRSCOM	SAD_EXT_CRS_COM
*External Course Grade	SCC_STG_CRSGRD	SAD_EXT_CRS_GRD
*External Degree	SCC_STG_EXTDEGR	EXT_DEGREE
*Academic Interests Header	SCC_STG_ADMIHD	ADM_INTRST_HDR
*Academic Interests	SCC_STG_ADMINT	ADM_INTERESTS
*General Materials	SAD_STG_GEN_MAT	GENL_MATERIALS
*General Materials Attachment	SAD_STG_GNMTATT	GENL_MAT_ATTACH

*Considered Constituent Data but appears on Prospect/Admissions Staging

**Work record has no significance other than to act as a production record placeholder within the Entity Registry

A query group, named PROS ADM DATA LOAD, has been added for PDL. This new query group is added to QUERY_TREE_ADM. Use the Query Access Manager page to view this query group.