vMIS_CB view
- Jordan Lamb
This view gives the California MIS CB file data. It is pulled from the StudentNet.dbo.Course table and is presented in the same order as the CA MIS CB file (Course Data Record).
Oracle source: ReportsNet.Course view
Oracle objects: SPRIDEN, STVDEPT, STVDIVS, SCBCRSE, SSBSECT, SSRMEET
Updated: nightly
DW Course field | DW vMIS_CB Field | Description |
| TERM | Â |
| CB00 | Permanent Course Identifier |
| CB01 | 4-char subject code from |
| CB02 | Title of Course |
| CB03 | Taxonomy of Program Code. 6-digit code. See |
| CB04 | C: Credit - Not Deg App (300-399) D: Credit - Degree App (1-299) N: Noncredit (400 Courses) Â -- Used in FTES Comparison Report Note: this used to be sourced from |
| CB05 | Course Transfer Status |
| CB06 | Max credit hours |
| CB07 | Min credit hours |
| CB08 | Basic Skills Status |
| CB09 | SAM – Chancellor's Vocational Course Indicator: A: Apprenticeship B: Advanced Occupational C: Clearly Occupational D: Possibly Occupational E: Non-Occupational |
| CB10 | Cooperative Education Indicator. Y/N |
| CB11 | Classification Code: A: Liberal Arts and Sciences B: Developmental Preparatory C: Adult and Secondary Basic Ed D: Personal Devel - Non Handicap E: For Substantially Handicapped F: Parenting and Family Support G: Community and Civic Develop H: General and Cultural I: Occupational Education |
| CB12 | Â |
| CB13 | N: Not a special class A: Approved Special Class Disabled |
| CB14 | California Articulation Number |
| CB15 | CAN Sequence |
| CB16 | Â |
| CB17 | Â |
| CB18 | Â |
| CB19 | Course Crosswalk Course Department Name |
| CB20 | Course Crosswalk Course Number |
| CB21 | A: 1 level below college B: 2 levels below college C: 3 levels below college Y: Not Applicable  |
CASE
WHEN
F_GET_SVVCCST_CREDIT_COURSE (ssbsect_term_code, Ssbsect_Subj_Code,
ssbsect_Crse_Numb) = 'Y' THEN 'Y'
WHEN SCBSUPP_CNCC_CODE IS NOT NULL THEN
COURSE_SUPP.SCBSUPP_CNCC_CODE
ELSE NULL
END | CB22 | Non Credit Category  |
| CB23 | Funding Agency Category |
| CB24 | Course Program Status |