MMPS SuperGlue Data Mappings for Colleague
Multiple Measures ERP Placement Data Fields Table Mappings - Colleague
This table maps the data fields in the College Adaptor to the fields within Colleague:
College Adaptor Payload Name | Colleague DB Staging Table | Colleague Field Name | Explanation |
|---|---|---|---|
acbc | XCTC.PLMT.PLACEMENT | XCTC.PLMT.ACBC.SUPPORT | A 1-3 numeric rating to indicate if a student is recommended for Applied Calculus/Business Calculus: 1 = Support Not Recommended For more details, see the SuperGlue 5.2 Release Notes. |
appId | XCTC.PLMT.PLACEMENT | The CCCApply Application Id associated with this generated placement. | |
calculus | XCTC.PLMT.PLACEMENT | XCTC.PLMT.CALCULUS | Calculus Recommendation |
cccid | XCTC.PLMT.PLACEMENT | XCTC.PLMT.CCCID | cccid of student completing CCCApply application. |
collegeMISCode | XCTC.PLMT.PLACEMENT | XCTC.PLMT.MIS.CODE | College MIS code of college student completed application. |
completedEleventhGrade | XCTC.PLMT.PLACEMENT | XCTC.PLMT.COMPLETED.11TH.GRD | deprecated in favor of highestGradeCompleted |
cumulativeGradePointAverage | XCTC.PLMT.PLACEMENT | XCTC.PLMT.CUMULATIVE.GPA | Cumulative Grade Point Average. |
english | XCTC.PLMT.PLACEMENT | XCTC.PLMT.ENGLISH | A 1-3 numeric rating to indicate if a student is recommended for English: 1 = Support Not Recommended or required |
englishCompletedCourseGrade | XCTC.PLMT.PLACEMENT | XCTC.PLMT.ENG.COMP.CRS.GRD | Grade of highest English course completed. |
englishCompletedCourseId | XCTC.PLMT.PLACEMENT | Highest English course completed. | |
highestGradeCompleted | XCTC.PLMT.PLACEMENT | XCTC.PLMT.HIGHEST.GRADE.COMP | Highest grade completed in high school at the time the CCCApply application is being submitted. Replaces completedEleventhGrade and serves as the new trigger to display the MMPS questions (GPA, highest English and highest Math questions in CCCApply). |
isAlgI | XCTC.PLMT.PLACEMENT | XCTC.PLMT.IS.ALG.I | Successfully Completed Algebra I. |
isAlgII | XCTC.PLMT.PLACEMENT | XCTC.PLMT.IS.ALG.II | True = Passed Algebra 2 (or equivalent, including IM3) with a grade of “C” or better. |
mathematicsCompletedCourseGrade | XCTC.PLMT.PLACEMENT | XCTC.PLMT.MATH.COMP.CRS.GRD | Grade of highest mathematics course completed. |
mathematicsCompletedCourseId | XCTC.PLMT.PLACEMENT | Highest mathematics course passed. | |
mathematicsPassedCourseGrade | XCTC.PLMT.PLACEMENT | XCTC.PLMT.MATH.PASS.CRS.GRD | Grade of highest mathematics course passed. |
mathematicsPassedCourseId | XCTC.PLMT.PLACEMENT | Highest mathematics course passed. | |
placementStatus | XCTC.PLMT.PLACEMENT | XCTC.PLMT.PLACEMENT.STATUS | The status of the placement. This field is not currently part of an ERP. It is only defined within Conductor and provided as input to the College Adaptor. |
preCalculus | XCTC.PLMT.PLACEMENT | XCTC.PLMT.PRE.CALCULUS | PreCalculus Recommendation |
slam | XCTC.PLMT.PLACEMENT | XCTC.PLMT.SLAM.SUPPORT | A 1-3 numeric rating to indicate if a student is recommended for SLAM: 1 = Support Not Recommended or required |
ssid | XCTC.PLMT.PLACEMENT | XCTC.PLMT.SSID | ssid of student completing CCCApply application. |
stem | XCTC.PLMT.PLACEMENT | XCTC.PLMT.STEM.SUPPORT | A 1-3 numeric rating to indicate if a student is recommended for STEM: 1 = Support Not Recommended or required |
trigonometry | XCTC.PLMT.PLACEMENT | XCTC.PLMT.TRIGONOMETRY | Trigonometry Recommendation |
tstmpERPTransmit | XCTC.PLMT.PLACEMENT | XCTC.PLMT.ERP.DATE | Date placement was approved by ERP |
tstmpSISTransmit | XCTC.PLMT.PLACEMENT | XCTC.PLMT.ACTIVITY.DATE | Date placement was added to the SIS |
| XCTC.PLMT.PLACEMENT | The incremental ID of the placement in Colleague | |
| XCTC.PLMT.PLACEMENT | XCTC.PLMT.ACTIVITY.TIME | Time placement was added to the SIS |
| XCTC.PLMT.PLACEMENT | XCTC.PLMT.ERP.TIME | Time placement was approved by ERP |
datasource | XCTC.PLMT.PLACEMENT | XCTC.PLMT.DATA.SOURCE | Source Of Placement Data 4 = Datasource 4 represents a commingling of data from CalPASS+ and self-reported data from CCCApply, when the use of the CCCApply data (in combination with some of the verified data from CalPASS+) would result in higher math placements (or different levels of support for transfer level. 0 = Used with NO_PLACEMENT, placement generated as part of conductor workflow |
| XCTC.PLMT.PLACEMENT | The |