MMPS SuperGlue Data Mappings - Banner

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

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

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	See here
cccid	SZRPLMT	SZRPLMT_CCCID	See here
ssid	SZRPLMT	SZRPLMT_STATEWIDE_STUDENT_ID	See here
collegeMISCode	SZRPLMT	SZRPLMT_MIS_CODE	See here
dataSource	SZRPLMT	SZRPLMT_DATA_SOURCE	See here
english	SZRPLMT	SZRPLMT_ENGLISH	See here
slam	SZRPLMT	SZRPLMT_SLAM_SUPPORT	See here
stem	SZRPLMT	SZRPLMT_STEM_SUPPORT	See here
isAlgI	SZRPLMT	SZRPLMT_IS_ALG_I	See here
isAlgII	SZRPLMT	SZRPLMT_IS_ALG_II	See here
trigonometry	SZRPLMT	SZRPLMT_TRIGONOMETRY	See here
preCalculus	SZRPLMT	SZRPLMT_PRE_CALCULUS	See here
calculus	SZRPLMT	SZRPLMT_CALCULUS	See here
completedEleventhGrade	SZRPLMT	SZRPLMT_COMPLETED_11TH_GRADE	See here (deprecated in favor of highestGradeCompleted)
cumulativeGradePointAverage	SZRPLMT	SZRPLMT_CUMULATIVE_GPA	See here
englishCompletedCourseId	SZRPLMT	SZRPLMT_ENG_COMP_COURSE_ID	See here
englishCompletedCourseGrade	SZRPLMT	SZRPLMT_ENG_COMP_COURSE_GRADE	See here
mathematicsCompletedCourseId	SZRPLMT	SZRPLMT_MATH_COMP_COURSE_ID	See here
mathematicsCompletedCourseGrade	SZRPLMT	SZRPLMT_MATH_COMP_COURSE_GRADE	See here
mathematicsPassedCourseId	SZRPLMT	SZRPLMT_MATH_PASS_COURSE_ID	See here
mathematicsPassedCourseGrade	SZRPLMT	SZRPLMT_MATH_PASS_COURSE_GRADE	See here
tstmpERPTransmit	SZRPLMT	SZRPLMT_TSTMP_ERP_TRANSMIT	See here
appId	SZRPLMT	SZRPLMT_APP_ID	See here The CCCApply Application Id associated with this generated placement
highestGradeCompleted	SZRPLMT	SZRPLMT_HIGST_GRADE_COMPLETED	See here
	SZRPLMT	SZRPLMT_ACTIVITY_DATE	The date the row is inserted
	SZRPLMT	SZRPLMT_USER_ID	The `sisuser` ID (the College Adaptor)
	SZRPLMT	SZRPLMT_VPDI_CODE	Unused, but reserved for multi-tenant Banner installations

MMPS SuperGlue Data Mappings - Banner

MMPS Data Fields Table Mapping - Banner