S_CRDC_CLASSES_S (ver 24.11.1.0)

Column Name

Version

Data Type

Description

DCID

24.11.1.0

NUMERIC (10,0)

The primary key that relates the extended table to the table.

SECCOMPSCI

24.11.1.0

BOOLEAN

Does this section qualify as a Computer Science course?

CRSDISTANCELEARNING

24.11.1.0

BOOLEAN

Is this a distance education course?

CRSCALCULUS

24.11.1.0

BOOLEAN

Does this course qualify as a Calculus course?

SECSUBJECTCAT

24.11.1.0

VARCHAR2 (10)

Which subject category does this section fall under?

CRSCHEMISTRY

24.11.1.0

BOOLEAN

Does this course qualify as a Chemistry course?

SECBLOCKSCHEDULEDCLASS

24.11.1.0

BOOLEAN

Is this a Block Scheduled Class?

CRSDUALENROLLMENT

24.11.1.0

BOOLEAN

Is this a Dual Enrollment or Dual Credit course?

SECLASTDAY

24.11.1.0

DATE

Section Last Day

SECTION_NUMBER

24.11.1.0

VARCHAR2 (20)

Section Number

COURSE_NUMBER

24.11.1.0

VARCHAR2 (20)

Course Number

COURSE_NAME

24.11.1.0

VARCHAR2 (100)

Course Name

SECDATASCI

24.11.1.0

BOOLEAN

Does this section qualify as a Data Science course?

CRSDCID

24.11.1.0

NUMERIC

Course DCID 

TEACHERNUMBER

24.11.1.0

VARCHAR2 (20)

Section Teacher Number

SCHOOLNAME

24.11.1.0

VARCHAR2 (100)

CRDC School Name

SECALGEBRAI

24.11.1.0

BOOLEAN

Does this section qualify as an Algebra I course?

APSECTION

24.11.1.0

BOOLEAN

Does this section fall under a specific Advanced Placement (AP) subject area?

SECTIONTEACHER

24.11.1.0

VARCHAR2 (40)

Section Teacher Name

CRSGEOMETRY

24.11.1.0

BOOLEAN

Does this course qualify as a Geometry course?

SECCHEMISTRY

24.11.1.0

BOOLEAN

Does this section qualify as a Chemistry course?

SECDCID

24.11.1.0

NUMERIC

Section DCID

APCOURSE

24.11.1.0

BOOLEAN

Does this course fall under a specific Advanced Placement (AP) subject area?

ETHNICITY

24.11.1.0

VARCHAR2 (10)

Teacher Ethnicity

PREVIOUSYRSCHTCHR

24.11.1.0

BOOLEAN

Is the teacher a Previous Year Teacher?

CRSDATASCI

24.11.1.0

BOOLEAN

Does this course qualify as a Data Science course?

SECTERMID

24.11.1.0

VARCHAR2 (10)

Section Term ID

CRSADVMATH

24.11.1.0

BOOLEAN

Does this course qualify as an Advance Math course?

GRDLEVELHIGHSCH

24.11.1.0

BOOLEAN

Grade Level High School

SECFIRSTDAY

24.11.1.0

DATE

Section First Day

CRSSUBJECTCAT

24.11.1.0

VARCHAR2 (10)

Which subject category does this course fall under?

SECDUALENROLLMENT

24.11.1.0

BOOLEAN

Is this a Dual Enrollment or Dual Credit section?

SECALGEBRAII

24.11.1.0

BOOLEAN

Does this section qualify as an Algebra II course?

CURRENTYRSCHTCHR

24.11.1.0

BOOLEAN

Is the teacher a Current Year Teacher?

CRSCOMPSCI

24.11.1.0

BOOLEAN

Does this course qualify as a Computer Science course?

SECCALCULUS

24.11.1.0

BOOLEAN

Does this section qualify as a Calculus course?

GRDLEVELMIDDLESCH

24.11.1.0

BOOLEAN

Grade Level Middle School

CRSALGEBRAII

24.11.1.0

BOOLEAN

Does this course qualify as an Algebra II course?

SECADVMATH

24.11.1.0

BOOLEAN

Does this section qualify as an Advance Math course?

CRSALGEBRAI

24.11.1.0

BOOLEAN

Does this course qualify as an Algebra I course?

SECPHYSICS

24.11.1.0

BOOLEAN

Does this section qualify as a Physics course?

SINGLESEX

24.11.1.0

VARCHAR2 (10)

Is this section restricted to a single gender?

SECDISTANCELEARNING

24.11.1.0

BOOLEAN

Is this a distance education section?

SCHOOLID

24.11.1.0

VARCHAR2 (15)

CRDC School ID

SECGEOMETRY

24.11.1.0

BOOLEAN

Does this section qualify as a Geometry course?

CRSPHYSICS

24.11.1.0

BOOLEAN

Does this course qualify as a Physics course?

CRSBIOLOGY

24.11.1.0

BOOLEAN

Does this course qualify as a Biology course?

SECBIOLOGY

24.11.1.0

BOOLEAN

Does this section qualify as a Biology course?

STUDENTSCOUNT

24.11.1.0

NUMERIC

Students Count

selectedCRDCSchoolId

24.12.3.0

VARCHAR2 (10)

Selected CRDC School ID