Info |
---|
The tables below pertain to the MMPS data fields collected in the CCCApply Standard application. |
Expand | ||
---|---|---|
| ||
This document is intended to map the data fields in Banner with the fields in the College Adaptor for MMPS data.
For example, for the Multiple Measures Placement Service:
Note: Currently, the output field names (from ERP) 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 instance, the placementStatus field is not currently part of ERP—it’s solely defined within Conductor and provided as input to College Adaptor. 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 | |
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 | |
SZRPLMT | SZRPLMT_VPDI_CODE | Unused, but reserved for multi-tenant Banner installations |
...