Course table

Oracle Field/Calc

DW Field

Description or Sample

ssbsect_term_code

TERM

200710 (Fall = 10, Spring = 20, Summer = 30)

ssbsect_ptrm_code

PTRM_CODE

Part of Term Code:

1: Full Term

C: Combined Sessions

E: No Excluded Holidays

O: Other Than Full Term

S1: Summer Session 1

S2: Summer Session 2

S3: Summer Session 3

S4: Summer Session 4

Scbcrse_Divs_Code

DIVISIONID

Division Code:

AG: Agriculture

BUS: Business

CFS: Consumer/Family Studies

ARTF: Fine Arts

IT: Industry and Technology

LANG: Language Arts and Commun

LIBR: Library

MATH: Math and Engineering

PE: Physical Education

SCI: Science

SOCS: Social Sciences

STSV: Student Services

SPLP: Special Programs

NURS: Nursing

WEXP: Work Experience

STVDIVS_DESC

DIVISION

Description of DivisionId code

Scbcrse_Dept_Code

DEPARTMENTID

From STVDEPT Oracle table. 4-char department code.

STVDEPT_DESC

DEPARTMENT

Description of DepartmentId code

ssbsect_ssts_code

STATUSCODE

Section status code:

A: Active

C: Cancelled / Low Enrollment

I: Inactive for Registration

N: Cancelled / No Instructor

R: Cancelled / Rescheduled

Ssbsect_Crn

CRN

Course Identifier / Number

rowidtochar(ssrmeet.rowid)

SCHEDULEID

Internal id of the record ( AAABJrAAKAAAZm6AAu)

Ssbsect_Subj_Code

SUBJECT

4-char subject code from STVSUBJ

CA MIS file: first part of field CB01 (see vMIS_CB view for a view of just the MIS fields)

STVSUBJ_DESC

SUBJECT_DESC

Subject Code description

Ssbsect_Crse_Numb

COURSENUMBER

Alphanumeric course number, such as 031 or 13L

CA MIS file: second part of field CB01

Scbcrse.SCBCRSE_TITLE

COURSE

Title of Course

CA MIS file: field CB02

SUBSTR(DECODE(ssbsect_credit_hrs, null,(DECODE(scbcrse_credit_hr_high, NULL, scbcrse_credit_hr_low||

DECODE(scbcrse_credit_hr_low,1,' UNIT',' UNITS'),

DECODE(scbcrse_credit_hr_ind, 'OR', scbcrse_credit_hr_low||' OR '||scbcrse_credit_hr_high||' UNITS',

scbcrse_credit_hr_low||' - '|| scbcrse_credit_hr_high||' UNITS'))),

DECODE(ssbsect_credit_hrs,1, ssbsect_credit_hrs||' UNIT', ssbsect_credit_hrs||' UNITS')),1,17)

CREDITHRS

Number of credit hours for the section in the format of ‘9.9 UNITS’. When variable unit section, this shows a the min and max units for the course as ‘9 – 9 UNITS’

CA MIS file: fields CB06 and CB07 – When this field does not contain a dash, both CB06 and CB07 would be the value of this field. When there is a dash, CB06 would be the left part and CB07 is the right part.

decode(ssbsect_credit_hrs, null, scbcrse_credit_hr_low, ssbsect_credit_hrs)

COURSE_CREDIT_HOURS

Number of credit hours for section. When variable unit section, the low units for the course.

Spriden_pidm

PIDM

Up to 10-digit unique Banner id for instructor

ssbsect.SSBSECT_CAMP_CODE

CAMPUS

BAK: Bakersfield

COR: Corcoran

COS: COS Main Campus

DIN: Dinuba

EXE: Exeter

FAR: Farmersville

FRM: COS Farm

HAC: Hanford Center

HAN: Hanford

IVA: Ivanhoe

LEM: Lemoore

LIN: Lindsay

ORC: Orosi Community Center

ORO: Orosi

POR: Porterville

STR: Strathmoore

TBA: To be Announced

THR: Three Rivers

TUC: Tulare Center

TUL: Tulare

VIS: Visalia

WOO: Woodlake

nvl(ssrmeet.SSRMEET_BLDG_CODE, 'N/A')

BUILDING

Code form STVBLDG (typically 6-char)

nvl(ssrmeet.ssrmeet_room_code, 'N/A')

ROOM

nvl(SSBSECT_LAB_HR, SCBCRSE_LAB_HR_LOW)

LAB_HOURS

Number of hours in lab

nvl(SSBSECT_LEC_HR, SCBCRSE_LEC_HR_LOW)

LEC_HOURS

Number of hours in lecture

nvl(SSBSECT_OTH_HR, SCBCRSE_OTH_HR_LOW)

OTH_HOURS

Number of other hours

SSRMEET.SSRMEET_HRS_WEEK

HOURS_WEEK

Number of hours per week

SSBSECT.SSBSECT_PTRM_WEEKS

PTRM_WEEKS

Number of weeks class runs

SSBSECT.SSBSECT_CENSUS_ENRL

CENSUS_ENROLL

Enrollment count before and on Census date (resident and non-resident). Not used in 320 FTES reporting calculation (see ENROLL_CEN_RES)

SSBSECT.SSBSECT_CENSUS_2_ENRL

CENSUS_2_ENROLL

Enrollment count at second Census date

SSBSECT.SSBSECT_ENRL

ACTUAL_ENROLL

Current enrollment

ssbsect.SSBSECT_MAX_ENRL

MAX_ENROLL

The maximum enrollment possible

ssbsect.SSBSECT_SEATS_AVAIL

SEATS_AVAIL

Current remaining number of seats available

SSBSECT.SSBSECT_ACCT_CODE

ACCT_CODE

Accounting Method Code:

D: Daily Census

E: Pos Attend (Open Entry, Exit)

I: Independent Study and Work Exp

O: Other Classes

P: Positive Attendance

W: Weekly Census

WE: Work Experience

SSBSECT.SSBSECT_SCHD_CODE

SCHD_CODE_SSBSECT

Schedule Code:

02: Lecture and/or Discussion

04: Laboratory/Studio

06: Lecture/Lab Combination

07: Lecture/Activity Combination

08: Lecture/Activity/Lab Combined

09: Laboratory/Activity

11: Noncredit Tutoring

20: Work Experience

40: Directed study

50: Distance Education, Delayed In

51: Interactive TV (Synchronous)

52: 1way inter video/2way inter au

53: 2way inter audio only

54: Other simult interact

61: Correspondence

62: Passive, Audio 1way

63: Video/Telecourse

64: Passive, Other

71: Internet-based simultan inter

72: Online/Hybrid

90: Field Experience

98: Independent Study

A: All Classes except labs

BB: Topic Course Repeat 2

AA: Topic Course Repeat 1

OH: Hybrid

ON: Online

XX: Other Instruction (Activity)

SSRMEET.SSRMEET_SCHD_CODE

SCHD_CODE_SSRMEET

Instructional Method: same possible code as SCHD_CODE_SSBSECT

SSBSECT.SSBSECT_SESS_CODE

SESS_CODE

Session Code:

B: Day/Evening

C: Community Service

D: Day

E: Evening

T: Contract Education

W: Weekend

SSBSECT.SSBSECT_GMOD_CODE

GMOD_CODE

Grading Mode Code:

3: 300 Courses - A,B,C, No Credit

C: Credit/No credit

E: Credit by Exam - A - F, NC

G: GPAs for Transfer work

N: Course Not Graded

O: Orientation – Credit

S: Standard Letter

Z: Obsolete Grades

SSBSECT_GRADABLE_IND

GRADABLE

Can a student earn a grade in the course -- Y/N

SSBSECT_START_DATE

STARTDATE

Date the course begins (datetime)

SSBSECT_END_DATE

ENDDATE

Date the course ends (datetime)

nvl(nvl(ssrmeet.ssrmeet_mon_day, '') || nvl(ssrmeet.ssrmeet_tue_day, '') || nvl(ssrmeet.ssrmeet_wed_day, '') ||

nvl(ssrmeet.ssrmeet_thu_day, '') || nvl(ssrmeet.ssrmeet_fri_day, '') || nvl(ssrmeet.ssrmeet_sat_day, '') ||

nvl(ssrmeet.ssrmeet_sun_day, ''), 'XX')

DAYS

Days the course meets: M, T, W, R, F, S, U

nvl(ssrmeet.SSRMEET_BEGIN_TIME

STARTTIME

Time when the course starts (4-char), in 24-hour time

nvl(ssrmeet.SSRMEET_END_TIME

ENDTIME

Time when the course ends (4-char), in 24-hour time

Spriden_ID

FACULTYID

Banner Id of the instructor

DECODE(SPRIDEN_LAST_NAME, null, 'Staff', SPRIDEN_LAST_NAME, NVL(SPRIDEN_LAST_NAME, '') || ', ' || NVL(SPRIDEN_FIRST_NAME, '') || ' ' || NVL(SPRIDEN_MI, ' '))

FACULTYNAME

Name of instructor

NVL(cos_f_resident_census(ssrmeet_term_code,ssrmeet_crn),0)

CEN_RES_ENRL

Resident enrollment at census. NOT used in FTES calculation (see ENROLL_CEN_RES)

SIRASGN_FCNT_CODE

FCNT_CODE

Faculty type:

A: Administrator Only

AE: Educational Administrator

FT: Full-Time Faculty

JP: Adjunct Faculty

OV: Overload Full-Time Faculty

TE: Temporary, Contract Faculty

SIRASGN_PRIMARY_IND

SIRASGN_PRIMARY_IND

Faculty is primary instructor (Y or Null)

case when sirasgn.SIRASGN_WORKLOAD_ADJUST is

not null then

(sirasgn.SIRASGN_WORKLOAD_ADJUST *

sirasgn.SIRASGN_PERCENT_RESPONSE / 100)

else

(scrschd.SCRSCHD_WORKLOAD *

sirasgn.SIRASGN_PERCENT_RESPONSE / 100)

end

LEC_HR_EQUIV

Lecture Hour Equivalent (LHE) for the faculty member on this record (primary faculty).

scbcrse.SCBCRSE_CREDIT_STATUS_CODE

CREDIT

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

CA MIS file: field CB04

SIRASGN_ACTIVITY_DATE

SIRASGN_ACTIVITY_DATE

Activity date of the SIRASGN record

GREATEST(Scbcrse.SCBCRSE_ACTIVITY_DATE, ssrmeet.SSRMEET_ACTIVITY_DATE, Ssbsect.SSBSECT_ACTIVITY_DATE)

ACTIVITY_DATE

Last activity date of this course in the Banner database.

COURSESN

COMPUTED: (SUBJECT+' '+COURSENUMBER)

WCH_LUIS

COMPUTED: Old field, not in use. This was Luis Leal’s computation for WCH, which has been determined to be wrong.

USEDCAPACITY

COMPUTED: ratio of enrollment at census to maximum enrollment for course.

(case [Max_Enroll] when NULL then (0)

when (0) then (0)

else isnull([CEN_RES_ENRL],(0))/[Max_Enroll] end)

trunc(case when SSBSECT.SSBSECT_ACCT_CODE = 'P' then SSRMEET.SSRMEET_HRS_WEEK*SSBSECT_PTRM_WEEKS/17.5

else SSRMEET_HRS_WEEK end, 2)

WCH

Weekly Contact Hours

trunc(case when SSBSECT.SSBSECT_SSTS_CODE In ('N','C') then 0 else NVL(baninst1.cos_f_resident_1_week_prior(ssrmeet_term_code,ssrmeet_crn),0) end, 2)

ENROLL_1WK_BF_RES

Resident Enrollment count at 1 week before start of course

trunc(case when SSBSECT.SSBSECT_SSTS_CODE In ('N','C') then 0 else NVL(baninst1.cos_f_resident_first_day(ssrmeet_term_code,ssrmeet_crn),0) end, 2)

ENROLL_FIRST_DAY_RES

Resident Enrollment at first day of course

trunc(case when SSBSECT.SSBSECT_SSTS_CODE In ('N','C') then 0 else NVL(cos_f_resident_census(ssrmeet_term_code,ssrmeet_crn),0) end, 2)

ENROLL_CEN_RES

Resident Enrollment at Census date -- same as CEN_RES_ENRL field above except the status of the section is taken into account – if canceled section (‘N’ or ‘C’), this is 0 – used in FTES calculation

trunc(case when SSBSECT.SSBSECT_SSTS_CODE In ('N','C') then 0 else NVL(baninst1.cos_f_resident_last_day(ssrmeet_term_code,ssrmeet_crn),0) end, 2)

ENROLL_LAST_DAY_RES

Resident Enrollment at last day of course

trunc(NVL(cos_f_calc_dch(ssrmeet_term_code,ssrmeet_crn, SSRMEET.ROWID),0),2)

F_CALC_DCH

Daily Contact Hours from cos_f_calc_dch function (not in use)

ssrmeet_hrs_day

DCH

Daily Contact Hours from ssrmeet_hrs_day. This value is calculated by BANNER and can be overridden by the user.

NVL(to_number(f_split_fields(substr(

cos_fw_att_acctg_calc(ssbsect.SSBSECT_TERM_CODE, ssbsect.SSBSECT_CRN, ssbsect.SSBSECT_SUBJ_CODE, ssbsect.SSBSECT_CRSE_NUMB, ssbsect.SSBSECT_ACCT_CODE, ssbsect.SSBSECT_PTRM_CODE,

ssbsect.SSBSECT_CENSUS_ENRL_DATE)

,1,100),6),'99999D99'),0)

POS_HRS

Positive Hours

SELECT ROUND(SUM(NVL(c.sfrstcr_attend_hr, 0)), 2)

FROM sfrstcr c

WHERE c.SFRSTCR_CRN = SSBSECT_CRN

AND c.SFRSTCR_TERM_CODE = SSBSECT_TERM_CODE

AND REPORTSNET.F_GET_STUDENT_IS_RESIDENT(C.SFRSTCR_PIDM, c.SFRSTCR_TERM_CODE) = 'Y'

POS_HRS_RESIDENT

Positive hours resident

BANINST1.COS_FW_CALC_NO_MEETS(SSRMEET_TERM_CODE, SSRMEET_CRN, SSBSECT_PTRM_CODE, SSRMEET.ROWID)

MEET_NO

Total number of times the class meets during the term. This may be 0 for Acct_Code ‘ID’. For computing DSCH for that possibility, see the field SSRMEET_HRS_TOTAL near the end of this table.

WSCH_1WK_BF_RES

COMPUTED: WSCH (Weekly Student Contact Hours) of resident enrollment at 1 week before start of course.

(case [ACCT_CODE]

when 'P' then [POS_HRS]/(17.5)

when 'D' then ([DCH]*[MEET_NO]*[ENROLL_1WK_BF_RES])/17.5 else [WCH]*[ENROLL_1WK_BF_RES] end)

WSCH_FIRST_DAY_RES

COMPUTED: WSCH of resident enrollment at 1^st day of course.

(case [ACCT_CODE]

when 'P' then [POS_HRS]/(17.5)

when 'D' then

([DCH]*[MEET_NO]*

[ENROLL_FIRST_DAY_RES])/17.5

else [WCH]*[ ENROLL_FIRST_DAY_RES] end)

WSCH_CEN_RES

COMPUTED: WSCH of resident enrollment at census day.

(case [ACCT_CODE]

when 'P' then [POS_HRS]/(17.5)

when 'D' then

([DCH]*[MEET_NO]*

[ENROLL_CEN_RES])/17.5

else [WCH]*[ ENROLL_CEN_RES] end)

WSCH_LAST_DAY_RES

COMPUTED: WSCH of resident enrollment at last day of course.

(case [ACCT_CODE]

when 'P' then [POS_HRS]/(17.5)

when 'D' then

([DCH]*[MEET_NO]*

[ENROLL_LAST_DAY_RES])/17.5

else [WCH]*[ ENROLL_LAST_DAY_RES] end)

DSCH_1WK_BF_RES

COMPUTED: DSCH (Daily Student Contact Hours) of resident enrollment at 1 week before start of course.

(case when [ACCT_CODE]='D' then [DCH]*[MEET_NO]*[ENROLL_1WK_BF_RES]

else (0) end)

DSCH_FIRST_DAY_RES

COMPUTED: DSCH of resident enrollment at 1^st day of course.

(case when [ACCT_CODE]='D' then [DCH]*[MEET_NO]*[ENROLL_FIRST_DAY_RES] else (0) end)

DSCH_CEN_RES

COMPUTED: DSCH of resident enrollment at census day.

(case when [ACCT_CODE]='D' then [DCH]*[MEET_NO]*[ENROLL_CEN_RES]

else (0) end)

DSCH_LAST_DAY_RES

COMPUTED: DSCH of resident enrollment at last day of course.

(case when [ACCT_CODE]='D' then [DCH]*[MEET_NO]*[ENROLL_LAST_DAY_RES] else (0) end)

F_SCHED_TEXT(ssbsect_crn, ssbsect_term_code)

SECTION_TEXT

Additional information for a class section

SSRMEET_START_DATE

MEET_STARTDATE

The date that this section starts

SSRMEET_END_DATE

MEET_ENDDATE

The date that this section ends

SCBSUPP.SCBSUPP_TOPS_CODE

TOPS_CODE

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

CA MIS file: field CB03

Scbcrse.Scbcrse_cipc_code

CIPS_CODE

CIPS code

SCBSUPP.SCBSUPP_OCCS_CODE

OCCS_CODE

SAM – Chancellor's Vocational Course Indicator:

A: Apprenticeship

B: Advanced Occupational

C: Clearly Occupational

D: Possibly Occupational

E: Non-Occupational

CA MIS file: field CB09

SCBSUPP.SCBSUPP_CCSL_CODE

CCSL_CODE

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

CA MIS file: field CB11

SCBSUPP.SCBSUPP_COOP_ED_IND

COOP_ED_IND

Cooperative Education Indicator. Y/N

CA MIS file: field CB10

SCBSUPP.SCBSUPP_PERM_DIST_IND

PERM_DIST_IND

Permanent Course Identifier

CA MIS file: field CB00

SCBSUPP.SCBSUPP_CUDA_CODE

SPECIAL_CLASS_STATUS

N: Not a special class

A: Approved Special Class Disabled

CA MIS file: field CB13

SCBSUPP.SCBSUPP_CUDB_CODE

CAN_CODE

California Articulation Number

CA MIS file: field CB14

SCBSUPP.SCBSUPP_CUDC_CODE

CAN_SEQ_CODE

CAN Sequence

CA MIS file: field CB15

SCBSUPP.SCBSUPP_CUDE_CODE

TERM_COURSE_UPDATE

The term tha the Course was updated for the catalog

SCBSUPP.SCBSUPP_CUDF_CODE

LEVEL_BELOW_COLLEGE_CODE

A: 1 level below college

B: 2 levels below colege

C: 3 levels below college

Y: Not Applicable

CA MIS file: CB21

SCBSUPP.SCBSUPP_CREDIT_CATEGORY_IND

CREDIT_CAT_IND

Credit Category

This is an old field. Needs more investigation. May not be valid for some terms.

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

NON_CREDIT_CATEGORY

Non Credit Category

CA MIS file: field CB22

SCBSUPP.SCBSUPP_CUDD_CODE

CSU_XWALK_DEPT

Course Crosswalk Course Department Name

CA MIS file: field CB19

SCBSUPP.SCBSUPP_CUDE_CODE

CSU_XWALK_COURSE_NUM

Course Crosswalk Course Number

CA MIS file: field CB20

SCBSUPP.SCBSUPP_FUNC_CODE

FUNDING_AGENCY_CAT

Funding Agency Category

CA MIS file: field CB23

SCBSUPP.SCBSUPP_CPSC_CODE

COURSE_PROG_STATUS

Course Program Status

CA MIS file: field CB24

SSBSECT.SSBSECT_INSM_CODE

INSTR_METHOD_SSBSECT

Main Istructional Method of the course (from GTVINSM):

00: Hybrid (51% Lect/49% online)

02: Lecture and/or Discussion

04: Laboratory/Studio

06: Lecture/Lab Combination

07: Lecture/Activity Combination

08: Lecture/Activity/Lab Combined

09: Laboratory/Activity

11: Noncredit Tutoring

20: Work Experience

40: Directed study

50: Distance Education, Delayed In

51: Two-way interactiv video/audio

52: 1way inter video/2way inter au13

53: 2way inter audio only

54: Other simult interact

61: Passive, Text one-way

62: Passive, Audio 1way

63: Passive, Video one-way

64: Passive, Other

71: Internet-based simultan inter

72: Internet Based, Delayed Intera

90: Field Experience

98: Independent Study

OH: Hybrid/Online

ON: Online

OO: Online with Orientation

VH: Hybrid/Video

XX: Other Instruction (Activity)

SSBSECT.SSBSECT_LINK_IDENT

LINK_ID

Unique code aplied to this course to link it to a lab. The convention is a lecture link id has a 9A format whereas the lab has an A9 format. Records with no value in this field have no lab associated with them.

SSRXLST.SSRXLST_XLST_GROUP

XLST_GROUP

Cross list group:

Unique code given to this and one other course to cross link them.

SELECT SSBXLST.SSBXLST_MAX_ENRL FROM SSBXLST

WHERE SSBXLST.SSBXLST_TERM_CODE = SSBSECT.SSBSECT_TERM_CODE

AND SSBXLST.SSBXLST_XLST_GROUP = SSRXLST.SSRXLST_XLST_GROUP

XLST_MAX_ENRL

The maximum enrollment possinle for the corss-listed courses (the max for ALL courses cross-listed to this course – may not necessarily be the total of all MAX_ENROLL values for all of the courses)

SELECT SSBXLST.SSBXLST_ENRL FROM SSBXLST

WHERE SSBXLST.SSBXLST_TERM_CODE = SSBSECT.SSBSECT_TERM_CODE

AND SSBXLST.SSBXLST_XLST_GROUP = SSRXLST.SSRXLST_XLST_GROUP

XLST_ENRL

Actual enrollment in the corss-listed courses (the total current enrollment for all courses cross-listed with this course)

SELECT SSBXLST.SSBXLST_DESC FROM SSBXLST

WHERE SSBXLST.SSBXLST_TERM_CODE = SSBSECT.SSBSECT_TERM_CODE

AND SSBXLST.SSBXLST_XLST_GROUP = SSRXLST.SSRXLST_XLST_GROUP

XLST_DESC

Description of the cross-list group code. Not currently being used by Banner.

CAST(NVL(baninst1.cos_sf_course_res_credit_hrs(ssrmeet.SSRMEET_CRN, ssrmeet_term_code), 0) AS DECIMAL(7, 2))

VARIABLE_CR_HRS

Variable Credit Hours

ssbsect.SSBSECT_WAIT_CAPACITY

WAIT_CAPACITY

Waitlist capacity for the CRN

ssbsect.SSBSECT_WAIT_COUNT

WAIT_COUNT

Waitlist count (number on the waitlist)

ssbsect.SSBSECT_WAIT_AVAIL

WAIT_AVAIL

Waitlist availability (how many spots are open)

f_get_scrsgbi_codes(Ssbsect_Subj_Code, Ssbsect_Crse_Numb, ssbsect_term_code)

UC_CSU_TRANS_CODE

Course Transfer Code:

A: Course is transferrable to UC and CSU

B: Course is transferrable only to CSU

REPORTSNET.F_GET_MIS_CB_TRANSFER_STAT (ssbsect_term_code, Ssbsect_Subj_Code,

Ssbsect_Crse_Numb)

MIS_CB_TRANS_STATUS

Course Transfer Status for MIS CB file

CA MIS file: CB05

f_get_scrattr_codes(Ssbsect_Subj_Code, Ssbsect_Crse_Numb, ssbsect_term_code)

BASIC_SKILLS_CODE

CA MIS file: CB08

decode(ssbsect.SSBSECT_CREDIT_HRS, NULL,DECODE(SCBCRSE.SCBCRSE_CREDIT_HR_HIGH,NULL,'N','Y'),'N')

VARIABLE_IND

Y if the course has variable credits

ssbsect.SSBSECT_SEQ_NUMB

SSBSECT_SEQ_NUMB

Ssrmeet.SSRMEET_HRS_TOTAL

SSRMEET_HRS_TOTAL

Total meeting hours for the course for the term. This value is used in the calculation of DSCH when the Acct_Code is ‘ID’ and (Meet_No = 0 or DCH = 0).

DSCH = value in this field * ENROLL_CEN_RES

Scrlevl_levl_code

LEVEL_CODE

00: Undeclared

UG: Undergraduate

CE: Community Ed / Contract Ed

NC: Non Credit

HS: High School

ssrmeet_schs_code

AUTO_SCHEDULER

Schedule Status Code:

NSM: Needs a room assignment

1SM: Requests a particular room

ASM: Preassigned class

AXM: Preassigned time conflict

5SM: Scheduler assigned room

HSM: Home preassigned (x-listed)

VSM: Visitor preassigned (x-listed)

RSM: Related class use with NSM

TBA: To be Arranged/Individual Base

WSM: Visitor needs assignment

RXM: Related conflicting classes

NXM: Related Xlist Double Book

1XM: Preferred Room Double Book

REPORTSNET.F_GET_BLDG_SITE(SSRMEET_BLDG_CODE)

BLDG_SITE

Site of a Building.

560: COS District

561: COS Visalia Campus

562: Tulare Center

REPORTSNET.F_GET_BLDG_CENTER(SSRMEET_BLDG_CODE)

BLDG_CENTER

Center of a Bulidng:

TULC: Tulare Center

SUBSTR(cos_f_get_email(SPRIDEN_PIDM), 1, 90)

FACULTY_EMAIL

Faculty email address.

SUBSTR(baninst1.cos_general_restr.f_cte_course_ind(ssbsect_term_code, Ssbsect_Subj_Code, Ssbsect_Crse_Numb)

,1

,1) CTE_IND

CTE_IND

Y/N - If a coures is a CTE Course

SUBSTR(sv_mis_cb_bp.f_get_basic_skill_stat(Ssbsect_Subj_Code, Ssbsect_Crse_Numb, ssbsect_term_code), 1, 1)

BASIC_SKILL_STAT

BASIC_SKILL_STAT

BASIC_SKILL_STAT IS SAME AS Special_Class_Status exception that view has a bug with how the term is selected.

SUBSTR(cos_general.f_get_cb22_value(ssbsect_term_code, Ssbsect_Subj_Code, Ssbsect_Crse_Numb), 1, 1)

CRSE_NON_CREDIT_CAT

NON_CREDIT_CATEGORY gets it from SVVCCST and SCBCRSE - WHERE f_get_cb22_value gets from SCBSUPP table we need to keep this also for MIS usage CB22.

SUBSTR(sv_mis_cb_bp.f_get_clasf_cde(Ssbsect_Subj_Code, Ssbsect_Crse_Numb, ssbsect_term_code), 1, 1)

CRSE_CLASS_STAT

CRSE_CLASS_STAT IS SAME AS CCSL_CODE exception that view has a bug with how the term is being selected