Open Enrollment Report
Introduction
Generates the Idaho Open Enrollment Extract. This extract contains open enrollment data by school, grade level, and program type by reporting period.
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.
Students Selection
Note: This version of the Student Course Enrollment report is a newer version that was created to be more forgiving towards "bad" data. The report will not check course enrollment dates against a student's school enrollment dates which should result in fewer missed due to course/school date discrepancies.
The report selects records from the [Students] table based on the following criteria:
The student is included if the course enrollment start date occurs before the report end date.
The student is included if the course enrollment end date occurs after the report start date.
The staff for each section must have an Idaho Staff ID.
The student must not be excluded from state reporting.
The student enrollment must not be excluded from state reporting.
School, Course, and Section Selection
The school, course, and section must not be excluded from state reporting.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | Choose one of the following:
The Current School Only option is for troubleshooting purposes only for this report.
The All Schools option is only available when running the report from the District Office. |
Include all submission periods | Choose the applicable submission period:
|
Report 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.
Data Element | Description | [Table]FieldName | Field Name | Field Type | Field Length |
IDStuId | The Idaho student number. For the student number to display in the report, the report input fields, Display Audit Field and Validate Data must be Yes. | [Students]State_StudentNumber | Varchar | 9 | |
schoolId | The school ID. The alternate school number is reported, if populated, otherwise the school number is reported. | [Schools]Alternate_School_Number [Schools]School_Number | Option Set | 4 | |
courseCode | The state course code. The report extracts the first populated value from the following:
| [S_ID_SEC_X]CourseCode [S_ID_SEC_X]AssignmentCode [S_ID_CRS_X]CourseCode [Courses]Alt_Course_Number [Courses]Course_Number | State Course Code Override Assignment Code State Course Code | Option Set | 6 |
period | The period number. | Derived from [Sections]Expression | Varchar | 15 | |
sectionId | The section ID. | [Sections]ID | Varchar | 15 | |
sectionAlias | The district section name associated with the section ID number for the specific section of a course. If the course name and section number is greater than 50 characters, the report will truncate the necessary characters from the end of the course name. | [Courses]Course_Name [Sections]Section_Number | Varchar | 50 | |
entryDate | The entry date for the course. | [CC]DateEnrolled | Date | 10 | |
exitDate | The exit date for the course. This is the last in-session date, or blank if the student has not left the course. | [CC]DateLeft | Date | 10 | |
exitReason | The exit reason for the course. For the exitReason to be reported, a grade must be extracted
| [S_ID_CC_X]CourseExitReason Embedded Course Exit Reason Logic If the “Apply Course Exit Reason Overrides” parameter is selected: [S_ID_CRS_X]Default_ExitReason [S_ID_SCH_X]Default_ExitReason [Prefs]value where [Prefs]Name = ID_CourseExitReason The 3 override fields that are governed by the “Apply Course Exit Reason Overrides” parameter only apply to student course enrollments where a grade was stored, but no potential credit exists. | Course Exit Reason Default Course Exit Reason Default Course Exit Reason | Option Set | 2 |
creditsOffered | The credits offered for a course. Reported to the hundredths place. | [StoredGrades]PotentialCrHrs [Courses]Credit_Hours | Numeric | 4 | |
creditsEarned | The credits earned or awarded for a course.Reported to the hundredths place. | [StoredGrades]EarnedCrHrs | Numeric | 4 | |
creditRecov | Indicates whether the credits earned for this course are recovery credits. | [S_ID_CC_X]creditRecovery [S_ID_CRS_X]creditRecovery [S_ID_SEC_X]creditRecovery | Credit Recovery | Varchar | 5 |
grade | The final grade at course exit.
| [StoredGrades]Grade [StoredGrade]StoreCode When determining what grade to pull: [S_ID_SCH_FinalGradeMapping]StoreCode Else, [Prefs]Name = ID_FinalGradeCode If the above are not populated: [StoredGrades]DateStored [StoredGrades]DCID | Varchar | 4 | |
dualCredit | The course’s dual credit status. If the student’s courseExitReason is LS or SC, the report returns a blank, regardless of whether the section is set to dual credit. | [S_ID_CC_X]DualCredit [S_ID_SEC_X]DualCredit [S_ID_CRS_X]DualCredit | Dual Credit | Option Set | 1 |
CCissued | Indicates whether the student received college credit for successfully completing the course. If dual credit is set to Y and the Course Exit Reason code is CF, the report extracts a Y for this field. If dual credit is set to Y and Course Exit Reason code is CN, LS, SC, TE or TH, the report extracts an N. Other code combinations extract as blank. | Derived from [S_ID_CC_X]CourseExitReason [S_ID_CRS_X]DualCredit [S_ID_SEC_X]DualCredit | Course Exit Reason Dual Credit | Option Set | 1 |
collegeCredits | The credits to be awarded by the college to early completers. | [S_ID_CRS_X]CollegeCredits | College Credits Offered | Integer | 1 |
CollegeID | If the student received credit for a college course, indicates which college/university issued the credit. | [S_ID_CC_X]CollegeID | College Issuing Credit | Option Set | 3 |
LegalFirst* Audit mode only | The student's legal first name. | [StudentCoreFields]PSCore_Legal_First_Name | N/A | N/A | |
LegalLast* Audit mode only | The student's legal last name. | [StudentCoreFields]PSCore_Legal_Last_Name | N/A | N/A | |
StudentName* Audit mode only | The student’s preferred name. | [Students]LastFirst | N/A | N/A | |
TeacherName* Audit mode only | The teacher’s name. | [Users]LastFirst | N/A | N/A | |
CourseSection* Audit mode only | A concatenation of the school abbreviation, the course number and the section number. | [Schools]Abbreviation [Sections]Course_Number [Sections]Section_Number | N/A | N/A | |
Expression* Audit mode only | The section expression. | [CC]Expression | N/A | N/A | |
CourseName* Audit mode only | The course name. | [Courses]Course_Name | N/A | N/A | |
TermID* Audit mode only | The term ID. | [Terms]ID | N/A | N/A | |
SectionID* Audit mode only | The section ID. | [Sections]ID | N/A | N/A |