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