Page Comparison

...

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_CCCIDSee here
ssid	SZRPLMT	SZRPLMT_STATEWIDE_STUDENT_IDSee here
collegeMISCode	SZRPLMT	SZRPLMT_MIS_CODESee here
dataSource	SZRPLMT	SZRPLMT_DATA_SOURCESee here
english	SZRPLMT	SZRPLMT_ENGLISHSee here
slam	SZRPLMT	SZRPLMT_SLAM_SUPPORTSee here
stem	SZRPLMT	SZRPLMT_STEM_SUPPORTSee here
isAlgI	SZRPLMT	SZRPLMT_IS_ALG_ISee here
isAlgII	SZRPLMT	SZRPLMT_IS_ALG_IISee here
trigonometry	SZRPLMT	SZRPLMT_TRIGONOMETRY	See here
preCalculus	SZRPLMT	SZRPLMT_PRE_CALCULUSSee here
calculus	SZRPLMT	SZRPLMT_CALCULUSSee here
completedEleventhGrade	SZRPLMT	SZRPLMT_COMPLETED_11TH_GRADE	See here (deprecated in favor of highestGradeCompleted)
cumulativeGradePointAverage	SZRPLMT	SZRPLMT_CUMULATIVE_GPASee here
englishCompletedCourseId	SZRPLMT	SZRPLMT_ENG_COMP_COURSE_IDSee here
englishCompletedCourseGrade	SZRPLMT	SZRPLMT_ENG_COMP_COURSE_GRADESee here
mathematicsCompletedCourseId	SZRPLMT	SZRPLMT_MATH_COMP_COURSE_ID	See here
mathematicsCompletedCourseGrade	SZRPLMT	SZRPLMT_MATH_COMP_COURSE_GRADESee here
mathematicsPassedCourseId	SZRPLMT	SZRPLMT_MATH_PASS_COURSE_ID	See here
mathematicsPassedCourseGrade	SZRPLMT	SZRPLMT_MATH_PASS_COURSE_GRADESee here
tstmpERPTransmit	SZRPLMT	SZRPLMT_TSTMP_ERP_TRANSMITSee 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

...

Versions Compared

Old Version 2

New Version Current

Key