MMPS SuperGlue Data Mappings for PeopleSoft

cccid

PS_CCTC_PLCMT_STG

CCTC_CCCID

cccid of student completing CCCApply application.

ssid

PS_CCTC_PLCMT_STG

CCTC_SSID

ssid of student completing CCCApply application.

collegeMISCode

PS_CCTC_PLCMT_STG

CCTC_MIS_CD

College MIS code of college student completed application.

PS_CCTC_PLCMT_STG

CCTC_PLCMT_SEQ_NBR

auto-incremented sequence number to support multiple placement recommendations for a given applicant to a given college

placementStatus

PS_CCTC_PLCMT_STG

CCTC_PLCMT_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.

dataSource

PS_CCTC_PLCMT_STG

CCTC_PLCMT_DS

Source Of Placement Data
1 = California College Guidance Initiative (CCGI)
2 = Cal-PASS Plus (CPP)
3 = CCC Apply

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

english

PS_CCTC_PLCMT_STG

CCTC_PLCMT_ENG_SR

acbc

PS_CCTC_PLCMT_STG

CCTC_PLCMT_ACBC_SR

A 1-3 numeric rating to indicate if a student is recommended for Applied Calculus/Business Calculus:

1 = Support Not Recommended
2 = Support Recommended
3 = Support Strongly Recommended

For more details, see the SuperGlue 5.2 Release Notes.

slam

PS_CCTC_PLCMT_STG

CCTC_PLCMT_SLAM_SR

A 1-3 numeric rating to indicate if a student is recommended for English:

1 = Support Not Recommended or required
2 = Support Recommended but cannot be required
3 = Support Strongly Recommended and can be required

stem

PS_CCTC_PLCMT_STG

CCTC_PLCMT_STEM_SR

A 1-3 numeric rating to indicate if a student is recommended for STEM:

1 = Support Not Recommended or required
2 = Support Recommended but cannot be required
3 = Support Strongly Recommended and can be required

isAlgI

PS_CCTC_PLCMT_STG

CCTC_PLCMT_ALG1

Successfully Completed Algebra I.

isAlgII

PS_CCTC_PLCMT_STG

CCTC_PLCMT_ALG2

True = Passed Algebra 2 (or equivalent, including IM3) with a grade of “C” or better.
False = Did not pass Algebra 2 (or equivalent, including IM3) with a grade of “C” or better.

trigonometry

PS_CCTC_PLCMT_STG

CCTC_PLCMT_TRIG

Trigonometry Recommendation
True = Recommended
False = Not Recommended

preCalculus

PS_CCTC_PLCMT_STG

CCTC_PLCMT_PREC

PreCalculus Recommendation
True = Recommended
False = Not Recommended

calculus

PS_CCTC_PLCMT_STG

CCTC_PLCMT_CALC

Calculus Recommendation
True = Recommended
False = Not Recommended

completedEleventhGrade

PS_CCTC_PLCMT_STG

CCTC_PLCMT_11G

Deprecated in favor of highestGradeCompleted.

cumulativeGradePointAverage

PS_CCTC_PLCMT_STG

CCTC_PLCMT_HS_GPA

Cumulative Grade Point Average.

englishCompletedCourseId

PS_CCTC_PLCMT_STG

CCTC_PLCMT_ENG_HCC

Highest English course completed.

englishCompletedCourseGrade

PS_CCTC_PLCMT_STG

CCTC_PLCMT_ENG_GRD

Grade of highest English course completed.

mathematicsCompletedCourseId

PS_CCTC_PLCMT_STG

CCTC_PLCMT_MTH_HCC

Highest mathematics course completed.

mathematicsCompletedCourseGrade

PS_CCTC_PLCMT_STG

CCTC_PLCMT_MTHCGRD

Grade of highest mathematics course completed.

mathematicsPassedCourseId

PS_CCTC_PLCMT_STG

CCTC_PLCMT_MTH_HCP

Highest mathematics course passed.

mathematicsPassedCourseGrade

PS_CCTC_PLCMT_STG

CCTC_PLCMT_MTHPGRD

Grade of highest mathematics course passed.

appId

PS_CCTC_PLCMT_STG

CCTC_APPL_ID

The CCCApply Application Id associated with this generated placement.

highestGradeCompleted

PS_CCTC_PLCMT_STG

CCTC_PLCMT_HGC

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).

This field value defaults to null for students who are not presented the "What was the highest grade you completed in high school" question (based on their CCCApply "High School Education" response).

tstmpERPTransmit

PS_CCTC_PLCMT_STG

CCTC_PLCMT_GEN_TS

Time stamp when placement was received from ERP timestamp.

PS_CCTC_PLCMT_STG

CCTC_PLCMT_RCV_TS

Holds the tstmpSISTransmit field

PS_CCTC_PLCMT_STG

STATUS_FLAG

A single character blank value whenever a new row is created. May be optionally used by the college to track processing

PS_CCTC_PLCMT_STG

STATUS_DTTM

Used for tracking/processing; defaults to the current date/time when a row is created. should be updated if/when the STATUS_FLAG field is changed

PS_CCTC_PLCMT_STG

DESCRLONG_NOTES

A blank value whenever a new row is created. May be optionally used by the college to track processing

PS_CCTC_PLCMT_STG

LASTUPDOPRID

The default value is "CCTC” when a row is created, but this value should be updated to whichever operatorID the college's IT department changes it to, if desired

PS_CCTC_PLCMT_STG

LASTUPDDTTM

Last updated date/time