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:
|
Current Selection Students | Choose one of the following:
|
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. |
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. |
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
| [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.
| [Students]FedEthnicity |
12 | RaceAmericanIndian | Student's Federal Ethnicity and Race.
| Derived from StudentsRace table. If RaceCode is I then 1 else 0. |
13 | RaceAsian | Student's Federal Ethnicity and Race.
| Derived from StudentsRace table. If RaceCode is A then 1 else 0. |
14 | RaceBlack | Student's Federal Ethnicity and Race.
| Derived from StudentsRace table. If RaceCode is B then 1 else 0. |
15 | RacePacificIslander | Student's Federal Ethnicity and Race.
| Derived from StudentsRace table. If RaceCode is P then 1 else 0. |
16 | RaceWhite | Student's Federal Ethnicity and Race.
| Derived from StudentsRace table. If RaceCode is W then 1 else 0. |
17 | RaceUnknown | Student's Federal Ethnicity and Race.
| 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. |