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