MMPS SuperGlue Data Mappings for Banner

The table below pertains to MMPS data.

This document is intended to map the data fields in Banner with the fields in the College Adaptor for MMPS data.

Note that the "College Adaptor Payload Name" in the table below is the field name in the College Adaptor that receives data from CCC Tech Center. Conductor is the”SuperGlue” bridge between the Tech Center systems and any/all third-party systems.

For example, for the Multiple Measures Placement Service:

Conductor first passes CCCApply data fields (the submitted application data) to the MMPS service.
Then it generates a placement using the application data along with Cal-PASS Plus (California Department of Education) or CCGI data.
Conductor then requests the placement data from the MMPS service.
Once Conductor gets the placement object, it then maps each of the placement’s output fields to a College Adaptor input field.

Note: Currently, the output field names match the input field names for the College Adaptor. This fact/implementation detail is by design, but purely by happenstance that we coordinate with each other; since there is a mapping process, the field names do not have to match.

For the MMPS mappings (and any other third-party system mappings), we ONLY document the mappings to the “payload” names (College Adaptor input field names) that College Adaptor uses. Conductor is responsible for then mapping College Adaptor fields to/from the other system’s names. Most of the time, Conductor does very simplistic mappings, attempting to keep the fields names the same.

MMPS Data Fields Table Mapping - Banner

College Adaptor Payload Name	Banner DB Staging Table	Banner Field Name	Explanation
	SZRPLMT	SZRPLMT_SEQ_NO	An auto assigned incremental sequence
	SZRPLMT	SZRPLMT_PIDM	A foreign key for the student (e.g. from `goradid`)
placementStatus	SZRPLMT	SZRPLMT_VPDI_STATUS	The status of the placement.
cccid	SZRPLMT	SZRPLMT_CCCID	cccid of student completing CCCApply application.
ssid	SZRPLMT	SZRPLMT_STATEWIDE_STUDENT_ID	ssid of student completing CCCApply application.
collegeMISCode	SZRPLMT	SZRPLMT_MIS_CODE	College MIS code of college student completed application.
dataSource	SZRPLMT	SZRPLMT_DATA_SOURCE	Source Of Placement Data
english	SZRPLMT	SZRPLMT_ENGLISH	English Support Recommendation
acbc	SZRPLMT	SZRPLMT_ACBC_SUPPORT	Applied Calculus/Business Calculus Support Recommendation
slam	SZRPLMT	SZRPLMT_SLAM_SUPPORT	SLAM Support Recommendation
stem	SZRPLMT	SZRPLMT_STEM_SUPPORT	STEM Support Recommendation
isAlgI	SZRPLMT	SZRPLMT_IS_ALG_I	Successfully Completed Algebra I?
isAlgII	SZRPLMT	SZRPLMT_IS_ALG_II	Successfully Completed Algebra II?
trigonometry	SZRPLMT	SZRPLMT_TRIGONOMETRY	Trigonometry Recommendation
preCalculus	SZRPLMT	SZRPLMT_PRE_CALCULUS	PreCalculus Recommendation
calculus	SZRPLMT	SZRPLMT_CALCULUS	Calculus Recommendation
completedEleventhGrade	SZRPLMT	SZRPLMT_COMPLETED_11TH_GRADE	Deprecated in favor of highestGradeCompleted.
cumulativeGradePointAverage	SZRPLMT	SZRPLMT_CUMULATIVE_GPA	Cumulative Grade Point Average.
englishCompletedCourseId	SZRPLMT	SZRPLMT_ENG_COMP_COURSE_ID	Highest English course completed.
englishCompletedCourseGrade	SZRPLMT	SZRPLMT_ENG_COMP_COURSE_GRADE	Grade of highest English course completed.
mathematicsCompletedCourseId	SZRPLMT	SZRPLMT_MATH_COMP_COURSE_ID	Highest mathematics course completed.
mathematicsCompletedCourseGrade	SZRPLMT	SZRPLMT_MATH_COMP_COURSE_GRADE	Grade of highest mathematics course completed.
mathematicsPassedCourseId	SZRPLMT	SZRPLMT_MATH_PASS_COURSE_ID	Highest mathematics course passed.
mathematicsPassedCourseGrade	SZRPLMT	SZRPLMT_MATH_PASS_COURSE_GRADE	Grade of highest mathematics course passed.
tstmpERPTransmit	SZRPLMT	SZRPLMT_TSTMP_ERP_TRANSMIT	Time stamp when placement was generated and/or received from ERP.
appId	SZRPLMT	SZRPLMT_APP_ID	The CCCApply Application Id associated with this generated placement.
highestGradeCompleted	SZRPLMT	SZRPLMT_HIGST_GRADE_COMPLETED	Highest grade completed in high school at the time the CCCApply application is being submitted. Replaces completedEleventhGrade
	SZRPLMT	SZRPLMT_ACTIVITY_DATE	The date the row is inserted into the sis staging table
	SZRPLMT	SZRPLMT_USER_ID	The `sisuser` ID (the College Adaptor)
	SZRPLMT	SZRPLMT_VPDI_CODE	Unused, but reserved for multi-tenant Banner installations