Miscellaneous Reports: CourseSection Values Audit
Report Description
This report pulls the course level or section level characteristics appropriately for accurate reporting to the state. The report will search for values for the following fields at the section level, if the section level values are not entered, the report will look for the course level values to populate the data. This helps you audit or verify the section/course values.
Course Level
Course Level Characteristic
Course Setting
Course Term
To audit, create a report with the following three options:
- Read-only: Print all course/section values for comparison/auditing
- Read-only: Print only course/sections where there is a discrepancy, i.e. sections don't all match, so users can make the sections uniform if desired
- Update Option: The course values, wherever Not set, will be updated from section values if all sections have the same value(excluding the nulls).
This helps you view the data before any update is done. It also serves as an audit check after you create all sections for a new school year.
Selection Criteria
Selection criteria determine which database records are used in the report.
Course Selection
The report selects active Course records from the [Courses] table based on the following criteria:
- The course must not be excluded from state reporting.
- The course must be active at the school
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Navigation: System Reports > State > Miscellaneous Reports
Select School and Term
Click School Setup
Select Sections and select a section, click on the active Section number
Scroll down to the Edit Section
Note the State Information fields
Run the report.
Field | Description |
Select School and Term | Choose one of the following:
Note: The All Schools option is only available when running the report from the District Office. |
School Setup | Navigate to School Setup |
Select Sections |
|
Select Students | Choose one of the following:
|
File Path | Enter the file path. If applicable, select the associated checkbox to save as the default value. |
Data Collection Name | Choose the applicable Data Collection from the pop-up menu.
|
SFTP Connections | Choose a selection from the pop-up menu. The default value is Disable. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table
A new report, Course/Section Values Audit, created on the State Reporting tab, under Miscellaneous Reports.
Section values will be copied to Course if the same value is stored in all sections for a Course and Course value is Not set.
Section values will NOT be copied to Course if different values are stored in all sections for a Course and Course value is Not set..
Null values at the Section level are ignored in these restrictions.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
1 | ADMINID | The district's SU/SD ID. | [S_VT_District_S]AdminID | String | 6 |
2 | POSID | The staff member's employing org ID. | [S_VT_Schools_X]PosID | String | 6 |
3 | LOCALCOURSEID | The locally assigned course ID. | [Sections]Course_Number | String | 55 |
4 | COURSESECTION | Unique Course section ID. | [Sections]Section_Number | String | 30 |
5 | COURSETERM | Code set to identify course term. | [S_VT_SEC_X]CourseTerm | String | 6 |
6 | COURSELEVEL | Code set for course rigor level. | [S_VT_SEC_X]CourseLevel | String | 1 |
7 | COURSELEVELCHARACTERISTIC | Code set for course character. | [S_VT_SEC_X]CourseLevelCharacteristic | String | 5 |
8 | COURSECREDITAVAIL | The number of available course credits. | [Courses]Credit_Hours | Number | 2,2 |
9 | COURSESETTING | Code set to identify course setting. | [S_VT_SEC_X]CourseSetting | String | 2 |
10 | SY | The school year. | [S_VT_District_S]SY | Number | 4 |
11 | FLEXIBLE_PATHWAYS | Flexible pathways | [S_VT_SEC_X]COURSEFLEXIBLEPATHWAYS | String | 100 |