...
College Adaptor Payload Name* | Banner DB Staging Table | Banner Field Name | Explanation | |
---|---|---|---|---|
SZRPLMT | SZRPLMT_SEQ_NO | An auto assigned incremental sequence | ||
SZRPLMT | SZRPLMT_PIDM | A foreign key for the student (e.g. from | ||
placementStatus | SZRPLMT | SZRPLMT_VPDI_STATUS | See here | |
cccid | SZRPLMT | SZRPLMT_CCCIDSee here | ||
ssid | SZRPLMT | SZRPLMT_STATEWIDE_STUDENT_IDSee here | ||
collegeMISCode | SZRPLMT | SZRPLMT_MIS_CODESee here | ||
dataSource | SZRPLMT | SZRPLMT_DATA_SOURCESee here | ||
english | SZRPLMT | SZRPLMT_ENGLISHSee here | ||
slam | SZRPLMT | SZRPLMT_SLAM_SUPPORTSee here | ||
stem | SZRPLMT | SZRPLMT_STEM_SUPPORTSee here | ||
isAlgI | SZRPLMT | SZRPLMT_IS_ALG_ISee here | ||
isAlgII | SZRPLMT | SZRPLMT_IS_ALG_IISee here | ||
trigonometry | SZRPLMT | SZRPLMT_TRIGONOMETRY | See here | |
preCalculus | SZRPLMT | SZRPLMT_PRE_CALCULUSSee here | ||
calculus | SZRPLMT | SZRPLMT_CALCULUSSee here | ||
completedEleventhGrade | SZRPLMT | SZRPLMT_COMPLETED_11TH_GRADE | See here (deprecated in favor of highestGradeCompleted) | |
cumulativeGradePointAverage | SZRPLMT | SZRPLMT_CUMULATIVE_GPASee here | ||
englishCompletedCourseId | SZRPLMT | SZRPLMT_ENG_COMP_COURSE_IDSee here | ||
englishCompletedCourseGrade | SZRPLMT | SZRPLMT_ENG_COMP_COURSE_GRADESee here | ||
mathematicsCompletedCourseId | SZRPLMT | SZRPLMT_MATH_COMP_COURSE_ID | See here | |
mathematicsCompletedCourseGrade | SZRPLMT | SZRPLMT_MATH_COMP_COURSE_GRADESee here | ||
mathematicsPassedCourseId | SZRPLMT | SZRPLMT_MATH_PASS_COURSE_ID | See here | |
mathematicsPassedCourseGrade | SZRPLMT | SZRPLMT_MATH_PASS_COURSE_GRADESee here | ||
tstmpERPTransmit | SZRPLMT | SZRPLMT_TSTMP_ERP_TRANSMITSee here | ||
appId | SZRPLMT | SZRPLMT_APP_ID | See here The CCCApply Application Id associated with this generated placement | |
highestGradeCompleted | SZRPLMT | SZRPLMT_HIGST_GRADE_COMPLETED | See here | |
SZRPLMT | SZRPLMT_ACTIVITY_DATE | The date the row is inserted | ||
SZRPLMT | SZRPLMT_USER_ID | The | ||
SZRPLMT | SZRPLMT_VPDI_CODE | Unused, but reserved for multi-tenant Banner installations |
...