Page Comparison

DW Course field

DW vMIS_CB Field

Description

TERM

TERM

PERM_DIST_IND

CB00

Permanent Course Identifier

SUBJECT + COURSE_NUMBER

CB01

4-char subject code from STVSUBJ

COURSE

CB02

Title of Course

TOPS_CODE

CB03

Taxonomy of Program Code. 6-digit code. See STVTOPS table in Oracle.

CREDIT

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 SCBCRSE_APRV_CODE

MIS_CB_TRANS_STATUS

CB05

Course Transfer Status

CREDITHRS (portion before -)

CB06

Max credit hours

CREDITHRS (portion after -)

CB07

Min credit hours

BASIC_SKILLS_CODE

CB08

Basic Skills Status

OCCS_CODE

CB09

SAM – Chancellor's Vocational Course Indicator:

A: Apprenticeship

B: Advanced Occupational

C: Clearly Occupational

D: Possibly Occupational

E: Non-Occupational

COOP_ED_IND

CB10

Cooperative Education Indicator. Y/N

CCSL_CODE

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

[FILLER]

CB12

SPECIAL_CLASS_STATUS

CB13

N: Not a special class

A: Approved Special Class Disabled

CAN_CODE

CB14

California Articulation Number

CAN_SEQ_CODE

CB15

CAN Sequence

[FILLER]

CB16

[FILLER]

CB17

[FILLER]

CB18

SCBSUPP.SCBSUPP_CUDD_CODE

CB19

Course Crosswalk Course Department Name

SCBSUPP.SCBSUPP_CUDE_CODE

CB20

Course Crosswalk Course Number

LEVEL_BELOW_COLLEGE_CODE

CB21

A: 1 level below college

B: 2 levels below college

C: 3 levels below college

Y: Not Applicable

CASE

WHEN

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

SCBSUPP.SCBSUPP_FUNC_CODE

CB23

Funding Agency Category

SCBSUPP.SCBSUPP_CPSC_CODE

CB24

Course Program Status