Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


SuperGlue
Release		Minimum
College
Adaptor
Version		FileNotesColleague
Resources
SGv4.0.0CAv4.0.0B93_XCTC.MMI_001.zip

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
SGv3.9.0CAv3.7.0B93_XCTC.MMI.V1_010.zip

Per CADAPTER-422, set specified Internal Size of 255 for User Fields on Placement


AKA: Colleague_MMPS_v3.9.0.zip, Colleague_MMPS_3.9.0.zip

Note: Colleges have reported that the B93_XCTC.MMI.V1_010.zip package is corrupt: missing an expected XCTC.PLMT.PLACEMENT table. The package is generated by Butte Staff per a request that a CCCTC developer (not pointing fingers, PAUL W!) submitted. Apparently, something in that request or the fulfillment of it went awry. Installing the previous package (B93_XCTC.MMI.V1_009.zip) should provide the missing table and then 010 can be applied on top of it. Or just skip to the next package.

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
SGv3.7.0CAv3.7.0B93_XCTC.MMI.V1_009.zip

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
SGv3.0.0CAv2.9.0B93_XCTC.MMI.V1_008.zip

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
Package
Version		Prior to the above versions, packages were tracked independent of Superglue versions. This created yet another version number to track and created confusion.
1.4

SGv2.9.0
CAv2.8.0

B93_XCTC.MMI_V1_007.zip

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


AKA: Colleague_Patch_MMI_v1.4.zip


1.3SGv2.7.0
CAv2.6.0		B93_XCTC.MMI.V1_006.zip

Per CADAPTER-130, Added Processed Date and Time stamps for studentPlacements


1.2SGv2.5.8
CAv2.5.0		B93_XCTC.MMI.V1_005.zip

Per CADAPTER-27, Set-up and staging tables for Multiple Measures studentPlacements




004?

1.1
B93_XCTC.MMI.V1_003.zipCCC Assessments


002?

1.0
B93_XCTC.MMI.V1_001.zipCCC Assessments


ERP Placement / Colleague Table Mappings

More details can be found in the MMPS Data Dictionary page. This table maps the data fields in the College Adaptor to the fields within Colleague:

College Adaptor Payload Name*Colleague DB Staging TableColleague Field NameExplanation

XCTC_PLMT_PLACEMENTXCTC_PLMT_PLACEMENT_IDThe incremental ID of the placement in Colleague
tstmpSISTransmitXCTC_PLMT_PLACEMENT

XCTC_PLMT_ACTIVITY_DATE

XCTC_PLMT_ACTIVITY_TIME

Date and time placement was added to the SIS
tstmpERPTransmitXCTC_PLMT_PLACEMENTXCTC_PLMT_ERP_DATE
XCTC_PLMT_ERP_TIME		Date and time placement was approved by ERP
placementStatusXCTC_PLMT_PLACEMENTXCTC_PLMT_PLACEMENT_STATUS
cccidXCTC_PLMT_PLACEMENTXCTC_PLMT_CCCID
ssidXCTC_PLMT_PLACEMENT

XCTC_PLMT_SSID


collegeMISCode

XCTC_PLMT_PLACEMENT

XCTC_PLMT_MIS_CODE



XCTC_PLMT_PLACEMENTXCTC_PLMT_DATA_SOURCE
englishXCTC_PLMT_PLACEMENTXCTC_PLMT_ENGLISH
slamXCTC_PLMT_PLACEMENTXCTC_PLMT_SLAM_SUPPORT
stemXCTC_PLMT_PLACEMENTXCTC_PLMT_STEM_SUPPORT
isAlgIXCTC_PLMT_PLACEMENTXCTC_PLMT_IS_ALG_I
isAlgIIXCTC_PLMT_PLACEMENTXCTC_PLMT_IS_ALG_II
trigonometryXCTC_PLMT_PLACEMENTXCTC_PLMT_TRIGONOMETRY
preCalculusXCTC_PLMT_PLACEMENTXCTC_PLMT_PRE_CALCULUS
calculusXCTC_PLMT_PLACEMENTXCTC_PLMT_CALCULUS
completedEleventhGradeXCTC_PLMT_PLACEMENTXCTC_PLMT_COMPLETED_11TH_GRDdeprecated in favor of highestGradeCompleted
cumulativeGradePointAverageXCTC_PLMT_PLACEMENTXCTC_PLMT_CUMULATIVE_GPA
englishCompletedCourseIdXCTC_PLMT_PLACEMENTXCTC_PLMT_ENG_COMP_CRS_ID
englishCompletedCourseGradeXCTC_PLMT_PLACEMENTXCTC_PLMT_ENG_COMP_CRS_GRD
mathematicsCompletedCourseIdXCTC_PLMT_PLACEMENT

MATH_COMP_CRS_ID


mathematicsCompletedCourseGradeXCTC_PLMT_PLACEMENTXCTC_PLMT_MATH_COMP_CRS_GRD 
mathematicsPassedCourseIdXCTC_PLMT_PLACEMENTXCTC_PLMT_MATH_PASS_CRS_ID
mathematicsPassedCourseGradeXCTC_PLMT_PLACEMENTXCTC_PLMT_MATH_PASS_CRS_GRD
appIdXCTC_PLMT_PLACEMENTXCTC_PLMT_APP_ID

The CCCApply Application Id associated with this generated placement

highestGradeCompletedXCTC_PLMT_PLACEMENTXCTC_PLMT_HIGHEST_GRADE_COMP

XCTC_PLMT_PLACEMENTXCTC_PLMT_USER_IDThe sisuser ID (the College Adaptor)
  • No labels