...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Per CADAPTER-440, refactored College Adaptor to use the Core DataWriter transaction (X.CCCTC.WRITE.RECORD) instead of custom transactions.
Removed the deprecated CCC Assess/MMI objects.
AKA: Colleague_MMPS_v4.0.0.zip
...
Entities
- XCTC.PLMT.PLACEMENT
...
Per CADAPTER-422, set specified Internal Size of 255 for User Fields on Placement
...
Colleague Transactions
- X.CCCTC.IMPORT.PLACEMENT
- X.CCCTC.POST.PLACEMENT
Entities
- XCTC.PLACEMENT.SETUP
- XCTC.PLC.COMPNT.CCCASSESS
- XCTC.PLC.COMPNT.MMAP
- XCTC.PLC.PLACEMENT
- XCTC.PLC.SUBJECT.AREA
- XCTC.PLC.TRANSACTION
- XCTC.PLMT.PLACEMENT
- XCTC.PLMT.TRX.TRANSCATION
Processes
- XS.CCCTC.EVALUATE.PLACEMENT
- XS.CCCTC.PLACEMENT.SUBR.TMPL
- XCTCS001
Validation Tables
- XCTC.PLACEMENT.IMPORT.METHODS
- XCTC.PLACEMENT.IMPORT.TIMING
- XCTC.PLACEMENT.STATUSES
...
Per MMPS-37, adding the HighestGradeCompleted field to studentPlacement table
AKA: Colleague_Patch_MMI_v3.7.0.zip
...
Colleague Transactions
- X.CCCTC.IMPORT.PLACEMENT
- X.CCCTC.POST.PLACEMENT
Entities
- XCTC.PLACEMENT.SETUP
- XCTC.PLC.COMPNT.CCCASSESS
- XCTC.PLC.COMPNT.MMAP
- XCTC.PLC.PLACEMENT
- XCTC.PLC.SUBJECT.AREA
- XCTC.PLC.TRANSACTION
- XCTC.PLMT.PLACEMENT
- XCTC.PLMT.TRX.TRANSCATION
Processes
- XS.CCCTC.EVALUATE.PLACEMENT
- XS.CCCTC.PLACEMENT.SUBR.TMPL
- XCTCS001
Validation Tables
- XCTC.PLACEMENT.IMPORT.METHODS
- XCTC.PLACEMENT.IMPORT.TIMING
- XCTC.PLACEMENT.STATUSES
...
Per PLATFORM-275, adding AppId to studentPlacement table
AKA: Colleague_Patch_MMI_v3.0.0.zip
...
Colleague Transactions
- X.CCCTC.IMPORT.PLACEMENT
- X.CCCTC.POST.PLACEMENT
Entities
- XCTC.PLACEMENT.SETUP
- XCTC.PLC.COMPNT.CCCASSESS
- XCTC.PLC.COMPNT.MMAP
- XCTC.PLC.PLACEMENT
- XCTC.PLC.SUBJECT.AREA
- XCTC.PLC.TRANSACTION
- XCTC.PLMT.PLACEMENT
- XCTC.PLMT.TRX.TRANSCATION
Processes
- XS.CCCTC.EVALUATE.PLACEMENT
- XS.CCCTC.PLACEMENT.SUBR.TMPL
- XCTCS001
Validation Tables
- XCTC.PLACEMENT.IMPORT.METHODS
- XCTC.PLACEMENT.IMPORT.TIMING
- XCTC.PLACEMENT.STATUSES
...
SGv2.9.0
CAv2.8.0
...
Per CADAPTER-205 and CADAPTER-146, Fix for: DMI Transaction resulted in an error: WARNING, UNKNOWN, Warning!
Per PLATFORM-221, fixed populating the Processed Date and Time stamps and User fields
...
Per CADAPTER-130, Added Processed Date and Time stamps for studentPlacements
...
Per CADAPTER-27, Set-up and staging tables for Multiple Measures studentPlacements
...
ERP Placement / Colleague Table Mappings
...
| Info |
|---|
For more details on the MMPS data elements, see the CCCApply Standard & Noncredit Application data dictionary. |
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 |
|---|---|---|---|
XCTC_PLMT_PLACEMENT | XCTC_PLMT_PLACEMENT_ID | The incremental ID of the placement in Colleague | |
tstmpSISTransmit | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ACTIVITY_DATE XCTC_PLMT_ACTIVITY_TIME | Date and time placement was added to the SIS |
tstmpERPTransmit | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ERP_DATE | Date and time placement was approved by ERP |
placementStatus | XCTC_PLMT_PLACEMENT | XCTC_PLMT_PLACEMENT_STATUS | |
cccid | XCTC_PLMT_PLACEMENT | XCTC_PLMT_CCCID | |
ssid | XCTC_PLMT_PLACEMENT | XCTC_PLMT_SSID | |
collegeMISCode | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MIS_CODE | |
XCTC_PLMT_PLACEMENT | XCTC_PLMT_DATA_SOURCE | ||
english | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ENGLISH | |
slam | XCTC_PLMT_PLACEMENT | XCTC_PLMT_SLAM_SUPPORT | |
stem | XCTC_PLMT_PLACEMENT | XCTC_PLMT_STEM_SUPPORT | |
isAlgI | XCTC_PLMT_PLACEMENT | XCTC_PLMT_IS_ALG_I | |
isAlgII | XCTC_PLMT_PLACEMENT | XCTC_PLMT_IS_ALG_II | |
trigonometry | XCTC_PLMT_PLACEMENT | XCTC_PLMT_TRIGONOMETRY | |
preCalculus | XCTC_PLMT_PLACEMENT | XCTC_PLMT_PRE_CALCULUS | |
calculus | XCTC_PLMT_PLACEMENT | XCTC_PLMT_CALCULUS | |
completedEleventhGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_COMPLETED_11TH_GRD | deprecated in favor of highestGradeCompleted |
cumulativeGradePointAverage | XCTC_PLMT_PLACEMENT | XCTC_PLMT_CUMULATIVE_GPA | |
englishCompletedCourseId | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ENG_COMP_CRS_ID | |
englishCompletedCourseGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_ENG_COMP_CRS_GRD | |
mathematicsCompletedCourseId | XCTC_PLMT_PLACEMENT | MATH_COMP_CRS_ID | |
mathematicsCompletedCourseGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MATH_COMP_CRS_GRD | |
mathematicsPassedCourseId | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MATH_PASS_CRS_ID | |
mathematicsPassedCourseGrade | XCTC_PLMT_PLACEMENT | XCTC_PLMT_MATH_PASS_CRS_GRD | |
appId | XCTC_PLMT_PLACEMENT | XCTC_PLMT_APP_ID | The CCCApply Application Id associated with this generated placement |
highestGradeCompleted | XCTC_PLMT_PLACEMENT | XCTC_PLMT_HIGHEST_GRADE_COMP | |
XCTC_PLMT_PLACEMENT | XCTC_PLMT_USER_ID | The |