CAST_Lookup table

Owned by Jordan Lamb
Last updated: May 14, 2021
1 min read

The Combined Academic Standing Code. In the Data Warehouse, this is currently only applied to a Puente student. Records were copied from Oracle. Does not need to be updated unless the Oracle STVCAST table is updated, which is unlikely.

Oracle source: SATURN.STVCAST table

Updated: no

Oracle Field/Calc

DW Field

Description or Sample

STVCAST.STVCAST_Code

CAST_Code

00: Good Standing

03: Progress Probation

04: Academic Probation

05: Both Prog & Acad Probation

06: Progress Dismissal

07: Academic Dismissal

08: Both Acad & Prog Dismiss

STVCAST.STVCAST_Desc

CAST_Desc

(see CAST_Code)