MMPS SuperGlue Data Mappings - PeopleSoft

The tables below pertain to the MMPS data fields collected in the CCCApply Standard application.

MMPS Data Fields Table Mapping - PeopleSoft

For more details, see the CCCApply Standard Application data dictionary.

College Adaptor Payload Name*	PeopleSoft DB Staging Table	PeopleSoft Field Name	Explanation

College Adaptor Payload Name*	PeopleSoft DB Staging Table	PeopleSoft Field Name	Explanation
cccid	PS_CCTC_PLCMT_STG	CCTC_CCCID	See here
ssid	PS_CCTC_PLCMT_STG	CCTC_SSID	See here
collegeMISCode	PS_CCTC_PLCMT_STG	CCTC_MIS_CD	See here
	PS_CCTC_PLCMT_STG	CCTC_PLCMT_SEQ_NBR	auto-incremented sequence number to support multiple placement recommendations for a given applicant to a given college
placementStatus	PS_CCTC_PLCMT_STG	CCTC_PLCMT_STATUS	See here
dataSource	PS_CCTC_PLCMT_STG	CCTC_PLCMT_DS	See here
english	PS_CCTC_PLCMT_STG	CCTC_PLCMT_ENG_SR	See here
slam	PS_CCTC_PLCMT_STG	CCTC_PLCMT_SLAM_SR	See here
stem	PS_CCTC_PLCMT_STG	CCTC_PLCMT_STEM_SR	See here
isAlgI	PS_CCTC_PLCMT_STG	CCTC_PLCMT_ALG1	See here
isAlgII	PS_CCTC_PLCMT_STG	CCTC_PLCMT_ALG2	See here
trigonometry	PS_CCTC_PLCMT_STG	CCTC_PLCMT_TRIG	See here
preCalculus	PS_CCTC_PLCMT_STG	CCTC_PLCMT_PREC	See here
calculus	PS_CCTC_PLCMT_STG	CCTC_PLCMT_CALC	See here
completedEleventhGrade	PS_CCTC_PLCMT_STG	CCTC_PLCMT_11G	See here (deprecated in favor of highestGradeCompleted)
cumulativeGradePointAverage	PS_CCTC_PLCMT_STG	CCTC_PLCMT_HS_GPA	See here
englishCompletedCourseId	PS_CCTC_PLCMT_STG	CCTC_PLCMT_ENG_HCC	See here
englishCompletedCourseGrade	PS_CCTC_PLCMT_STG	CCTC_PLCMT_ENG_GRD	See here
mathematicsCompletedCourseId	PS_CCTC_PLCMT_STG	CCTC_PLCMT_MTH_HCC	See here
mathematicsCompletedCourseGrade	PS_CCTC_PLCMT_STG	CCTC_PLCMT_MTHCGRD	See here
mathematicsPassedCourseId	PS_CCTC_PLCMT_STG	CCTC_PLCMT_MTH_HCP	See here
mathematicsPassedCourseGrade	PS_CCTC_PLCMT_STG	CCTC_PLCMT_MTHPGRD	See here
appId	PS_CCTC_PLCMT_STG	CCTC_APPL_ID	See here The CCCApply Application Id associated with this generated placement
highestGradeCompleted	PS_CCTC_PLCMT_STG	CCTC_PLCMT_HGC	See here
tstmpERPTransmit	PS_CCTC_PLCMT_STG	CCTC_PLCMT_GEN_TS	Holds the tstmpERPTransmit field
	PS_CCTC_PLCMT_STG	CCTC_PLCMT_RCV_TS	Holds the tstmpSISTransmit field
	PS_CCTC_PLCMT_STG	STATUS_FLAG	A single character blank value whenever a new row is created. May be optionally used by the college to track processing
	PS_CCTC_PLCMT_STG	STATUS_DTTM	Used for tracking/processing; defaults to the current date/time when a row is created. should be updated if/when the STATUS_FLAG field is changed
	PS_CCTC_PLCMT_STG	DESCRLONG_NOTES	A blank value whenever a new row is created. May be optionally used by the college to track processing
	PS_CCTC_PLCMT_STG	LASTUPDOPRID	The default value is "CCTC” when a row is created, but this value should be updated to whichever operatorID the college's IT department changes it to, if desired
	PS_CCTC_PLCMT_STG	LASTUPDDTTM	Last updated date/time