MMPS SuperGlue Data Mappings for Colleague
- Patricia Donohue
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 |
|---|---|---|---|
appId | XCTC_PLMT_PLACEMENT | XCTC_PLMT_APP_ID | The CCCApply Application Id associated with this generated placement |
calculus | XCTC_PLMT_PLACEMENT | XCTC_PLMT_CALCULUS |
|
cccid | XCTC_PLMT_PLACEMENT | XCTC_PLMT_CCCID |
|
collegeMISCode | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MIS_CODE |
|
completedEleventhGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_COMPLETED_11TH_GRD | deprecated in favor of highestGradeCompleted |
cumulativeGradePointAverage | XCTC_PLMT_PLACEMENT | XCTC_PLMT_CUMULATIVE_GPA |
|
english | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ENGLISH |
|
englishCompletedCourseGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ENG_COMP_CRS_GRD |
|
englishCompletedCourseId | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ENG_COMP_CRS_ID |
|
highestGradeCompleted | XCTC_PLMT_PLACEMENT | XCTC_PLMT_HIGHEST_GRADE_COMP |
|
isAlgI | XCTC_PLMT_PLACEMENT | XCTC_PLMT_IS_ALG_I |
|
isAlgII | XCTC_PLMT_PLACEMENT | XCTC_PLMT_IS_ALG_II |
|
mathematicsCompletedCourseGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MATH_COMP_CRS_GRD |
|
mathematicsCompletedCourseId | XCTC_PLMT_PLACEMENT | MATH_COMP_CRS_ID |
|
mathematicsPassedCourseGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MATH_PASS_CRS_GRD |
|
mathematicsPassedCourseId | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MATH_PASS_CRS_ID |
|
placementStatus | XCTC_PLMT_PLACEMENT | XCTC_PLMT_PLACEMENT_STATUS |
|
preCalculus | XCTC_PLMT_PLACEMENT | XCTC_PLMT_PRE_CALCULUS |
|
slam | XCTC_PLMT_PLACEMENT | XCTC_PLMT_SLAM_SUPPORT |
|
ssid | XCTC_PLMT_PLACEMENT | XCTC_PLMT_SSID |
|
stem | XCTC_PLMT_PLACEMENT | XCTC_PLMT_STEM_SUPPORT |
|
trigonometry | XCTC_PLMT_PLACEMENT | XCTC_PLMT_TRIGONOMETRY |
|
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 | XCTC_PLMT_PLACEMENT_ID | 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 |
| XCTC_PLMT_PLACEMENT | XCTC_PLMT_DATA_SOURCE |
|
| XCTC_PLMT_PLACEMENT | XCTC_PLMT_USER_ID | The |