Skip to main content
Skip table of contents

BIS Class and Student Enrollment Report

Contents

Introduction

The Business Industry Standard (BIS) Class and Student Enrollment Report is a group of two reports:

  • BIS Class Size – contains details of all classes, teachers, and the class size of students.
  • BIS Student Enrollment – contains the details of all the students enrolled in each of the classes above.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

  • Report classes as they are advertised to the individual or to the organization served.
  • The class/enrollment files for should include only classes that were completed during the reporting period.
  • If a student never attended a class or dropped prior to attending at least 50% of the class, do not include them in the enrollment file.
  • Contract Number must be filled out so that the course is included on the extract.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Use

Choose one of the following:

  • District Wide
  • Current School Only

Current Selection Students

Choose one of the following:

  • Selected number of Students Only
  • All Students

Contract Number (From)

Starting range of the Contract Number of the BIS Class

Contract Number (To)

Ending date of the Contract Number of the BIS Class

Student Number Prefix

The prefix used to concatenate with Student Number.

Back to Top

Report Output

Click Completed to download the result. The output is generated as a zipped file. Output File Name: OK_BIS_Class_Enrollment_[Timestamp].zip. This zipped file contains two files in the Comma Separated Values (CSV) format. These are described below in detail.

BIS Class Extract Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Output File Name: OK_BIS_ClassSize_[Timestamp].csv.

Item #

Field Header

Description

[Table]FieldName

1

ContractNumber

This field is the alpha/numeric code assigned to each class.

[S_OK_SEC_X]ContractNumber

2

SocSecNum

9-digit social security number of the teacher/class instructor. If the social security number cannot be obtained, this field should be left blank.

[Users]SSN

3

FirstName

Teacher’s first name. Left justified with 10 characters limit. Do not include hyphens, apostrophes, commas or other special characters.

[Users]FirstName

4

LastName

Teacher’s last name. Left justified with 10 characters limit. Do not include hyphens, apostrophes, commas or other special characters.

[Users]LastName

5

ClassName

Provide the name of the class being reported. Left justified.

[Courses]Course_Name

6

ProgramType

Two digit code that defines the type of class.

[S_OK_SEC_X]ProgramType

7

BeginDate

Provide the beginning date of the class.

[S_OK_SEC_XStartDate

or

Term's Start Date of the Section

8

EndDate

Provide the ending date of the class.

[S_OK_SEC_XEndDate

or

Term's End Date of the Section

9

ClassClockHours

Provide the number of clock hours for the class. Pad with leading zeros.

[S_OK_SEC_XClockHours

10

MISCode

Provide the MIS Code that best describes the occupational area of instruction for the class.

[S_OK_SEC_XMISCode

11

ClassStudentsCount

Provide the total number of students that attended the class. Pad with leading zeroes. Do not include anyone that enrolled but did not attend the class or any student that did not attend at least 50% of the class.

Derived from all the students enrolled in the section.

Back to Top

BIS Student Enrollment Extract Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Output File Name: OK_BIS_Enrollment_[Timestamp].csv.

Item #

Field Header

Description

[Table]FieldName

1

ContractNumber

This field is the alpha/numeric code assigned to each class.

[S_OK_SEC_X]ContractNumber

2

SchoolCode

9-digit school code to identify the technology school site for which enrollment is being submitted.

[Schools]SIF_StatePrId

If blank then extract the School_Number

3

FirstName

Student’s first name. Do not include hyphens, apostrophes, commas or other special characters.

[Students]FirstName

4

LastName

Student’s last name. Do not include hyphens, apostrophes, commas or other special characters.

[Students]LastName

5

Suffix

Student’s name suffix, if applicable. (e.g., Jr, Sr, III). Do not include periods.

[S_OK_STU_X]NameSuffix

6

SocSecNum

Student’s entire 9-digit social security number. If not available, leave blank.

[Students]SSN

7

StudentTestingNumber

For secondary students, provide the 10-digit numeric Student Testing Number (STN).

[Students]State_StudentNumber

8

SchoolID

Unique alpha/numeric ID assigned to each student by your school.

[S_OK_STU_X]StudentNumber.

If StudentNumber is blank then extract Student_Number with Student Number Prefix if entered on the report parameter.

9

Gender

Student's Gender

  • M=Male,
  • F=Female,
  • U=Unknown

[Students]Gender

If blank, then extract U=Unknown

10

DateofBirth

Student's date of birth. If not available, leave blank.

[Students]DOB

11

RaceHispanic

Student's Federal Ethnicity and Race.

  • 0 = Not Hispanic
  • 1 = Hispanic

[Students]FedEthnicity

12

RaceAmericanIndian

Student's Federal Ethnicity and Race.

  • 0 = Not American Indian
  • 1 = American Indian

Derived from StudentsRace table.

If RaceCode is I then 1 else 0.

13

RaceAsian

Student's Federal Ethnicity and Race.

  • 0 = Not Asian
  • 1 = Asian

Derived from StudentsRace table.

If RaceCode is A then 1 else 0.

14

RaceBlack

Student's Federal Ethnicity and Race.

  • 0 = Not Black
  • 1 = Black

Derived from StudentsRace table.

If RaceCode is B then 1 else 0.

15

RacePacificIslander

Student's Federal Ethnicity and Race.

  • 0 = Not Hawaiian/Pacific Islander
  • 1 = Hawaiian/Pacific Islander

Derived from StudentsRace table.

If RaceCode is P then 1 else 0.

16

RaceWhite

Student's Federal Ethnicity and Race.

  • 0 = Not White
  • 1 = White

Derived from StudentsRace table.

If RaceCode is W then 1 else 0.

17

RaceUnknown

Student's Federal Ethnicity and Race.

  • 0 = Not Unknown
  • 1 = Unknown

Derived from StudentsRace table.

If no RaceCode then 1 else 0.

18

EducationLevel

The education level of the student.

[Students]Grade (for Secondary)

[S_OK_STU_X]EducationLevel (for Adult)

19

ClockHours

The number of clock hours for the class. Pad with leading zeros.

[S_OK_SEC_X]ClockHours

20

BusinessCode

The name of the company/employer if the student is “sponsored” by the industry or place of employment.

[S_OK_STU_X]BusinessCode

If blank, then extract 99999.

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.