MMPS SuperGlue Data Mappings for PeopleSoft
The tables below pertain to the MMPS data fields.
MMPS Data Fields Table Mapping - PeopleSoft
College Adaptor Payload Name | PeopleSoft DB Staging Table | PeopleSoft Field Name | Explanation |
|---|---|---|---|
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. |
dataSource | PS_CCTC_PLCMT_STG | CCTC_PLCMT_DS | Source Of Placement Data |
english | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ENG_SR | English Support Recommendation |
acbc | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ACBC_SR | Applied Calculus/Business Calculus Support Recommendation |
slam | PS_CCTC_PLCMT_STG | CCTC_PLCMT_SLAM_SR | SLAM Support Recommendation |
stem | PS_CCTC_PLCMT_STG | CCTC_PLCMT_STEM_SR | STEM Support Recommendation |
isAlgI | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ALG1 | Successfully Completed Algebra I? |
isAlgII | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ALG2 | Successfully Completed Algebra II? |
trigonometry | PS_CCTC_PLCMT_STG | CCTC_PLCMT_TRIG | Trigonometry Recommendation |
preCalculus | PS_CCTC_PLCMT_STG | CCTC_PLCMT_PREC | PreCalculus Recommendation |
calculus | PS_CCTC_PLCMT_STG | CCTC_PLCMT_CALC | Calculus Recommendation |
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. |
tstmpERPTransmit | PS_CCTC_PLCMT_STG | CCTC_PLCMT_GEN_TS | Time stamp when placement was generated or received from ERP. |
| PS_CCTC_PLCMT_STG | CCTC_PLCMT_RCV_TS | timestamp when record was given to college adaptor |
| 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 |