plmtLookup table
- Jordan Lamb
This table is generated from the Student Ed Plan oracle table that defines the COS placement test codes, test description, placement level, and course.
Oracle source: STUEDPLAN.SEP_PLMT table
Oracle Field/Calc | DW Field | Description or Sample | Date Added |
SEP_PLMT_TESC_CODE | SEP_PLMT_TESC_CODE | A unique test code id for the placement test | Ryanwh – 2.25.2015 |
SEP_PLMT_TESC_DESC | SEP_PLMT_TESC_DESC | Description of the placement test | Ryanwh – 2.25.2015 |
SEP_PLMT_LVL | SEP_PLMT_LVL | Placement level score | Ryanwh – 2.25.2015 |
SEP_PLMT_CRSE | SEP_PLMT_CRSE | Placement course according to the placement level | Ryanwh – 2.25.2015 |
SEP_PLMT_MPLMT | SEP_PLMT_MPLMT | This field is used for the Student Ed Plan | Ryanwh – 2.25.2015 |
SEP_SOURCE | SEP_SOURCE | This field is used for the Student Ed Plan | Ryanwh – 2.25.2015 |