MMPS SuperGlue Data Mappings - PeopleSoft
- Patricia Donohue
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 |
|
ssid | PS_CCTC_PLCMT_STG | CCTC_SSID |
|
collegeMISCode | PS_CCTC_PLCMT_STG | CCTC_MIS_CD |
|
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 |
|
dataSource | PS_CCTC_PLCMT_STG | CCTC_PLCMT_DS |
|
english | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ENG_SR |
|
slam | PS_CCTC_PLCMT_STG | CCTC_PLCMT_SLAM_SR |
|
stem | PS_CCTC_PLCMT_STG | CCTC_PLCMT_STEM_SR |
|
isAlgI | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ALG1 |
|
isAlgII | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ALG2 |
|
trigonometry | PS_CCTC_PLCMT_STG | CCTC_PLCMT_TRIG |
|
preCalculus | PS_CCTC_PLCMT_STG | CCTC_PLCMT_PREC |
|
calculus | PS_CCTC_PLCMT_STG | CCTC_PLCMT_CALC |
|
completedEleventhGrade | PS_CCTC_PLCMT_STG | CCTC_PLCMT_11G | Deprecated in favor of highestGradeCompleted) |
cumulativeGradePointAverage | PS_CCTC_PLCMT_STG | CCTC_PLCMT_HS_GPA |
|
englishCompletedCourseId | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ENG_HCC |
|
englishCompletedCourseGrade | PS_CCTC_PLCMT_STG | CCTC_PLCMT_ENG_GRD |
|
mathematicsCompletedCourseId | PS_CCTC_PLCMT_STG | CCTC_PLCMT_MTH_HCC |
|
mathematicsCompletedCourseGrade | PS_CCTC_PLCMT_STG | CCTC_PLCMT_MTHCGRD |
|
mathematicsPassedCourseId | PS_CCTC_PLCMT_STG | CCTC_PLCMT_MTH_HCP |
|
mathematicsPassedCourseGrade | PS_CCTC_PLCMT_STG | CCTC_PLCMT_MTHPGRD |
|
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 |
|
tstmpERPTransmit | PS_CCTC_PLCMT_STG | CCTC_PLCMT_GEN_TS | Holds the tstmpERPTransmit field |
| 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 |