In-Field Out-Of Field Data Collection
Contents
Report Input
Run Data Collection
This data collection is run at the LEA and School level. Use the following steps to generate the Teacher Verification of Course Certification collection.
- On the Start Page, click State Reports. The State Reporting Dashboard page appears and displays a list of data collections for the school.
- Next to the In-Field Out-Of Field Data Collection, click Run.
- The system validates the data against the business rules set up for the collection and completes the process.
- Users have 24 hours to approve their data collection. If approval is not done within the 24 hours, the users must re-run the collection.
Review Data Collection
- Next to the In-Field Out-Of Field Data Collection, click Review.
- Select one of the following In-Field Out-Of Field Data Collection views from the Data View drop-down menu. The Results section displays the data collection results specific for the selected data view.
- Click Export to export the data collection results to an Excel spreadsheet
- The In-Field Out-Of Field Data Collection can be run for students who transfer between LEAs.
Data Collection View | Description |
---|---|
Course In-Field | This is a report that shows all sections that are In-Field. The report includes the school name, lead teacher name, course number, section number, term, school year, In-Field designation. The collection can be filtered by Course Code, Teacher Name, and In-Field status. The filtered results are exported as a delimited file. |
Course Out-of Field | This report displays all sections that are Out-of Field. The report includes the School Name, Lead Teacher Name, Course Number, Section Number, Term, School Year, and Out-of Field designation. It can be filtered by Course Code, Teacher Name, or Out-of Field status. The filtered results are exported as a delimited file. |
Course Code Crosswalk | List of all Course Code Crosswalk records. |
EC Course Code Crosswalk | List of all EC Course Code Crosswalk records. |
Teachers Assignment Audit | This report shows all lead teacher and co-teacher assignments to sections. |
Teachers License Audit | This is a report that shows all lead teacher and co-teacher assignments to sections. The report shall include the school name, teacher name, course number, section number, term, school year, In-Field/Out-of-Field designation and the timestamp of the assignment action. The user shall be able to filter by Course Code, Teacher Name, and In-Field/Out-of-Field status. The filtered results shall be exported as a delimited file. |
Course Assignment Audit | This is a report that shows all Course Numbers scheduled and all Qualified lead teacher and co-teacher License Area and Description. The report shall include the school name, teacher name, License Area, Description License Effective Date, and In-Field/Out-of-Field designation and Grade level. The user shall be able to filter by License Area, Teacher Name, and In-Field/Out-of-Field status. The filtered results shall be exported as a delimited file. |
Course Code Not In Crosswalk | This report lists of all Course Codes that are not in the Crosswalk. |
Review Exceptions
Use the following steps to review exceptions for a data collection.
- From the Dashboard, click Review. The Review page appears.
- Select Exceptions from the Reviews drop-down menu. Exceptions associated with a data collection display.
- Select the exception type from the Choose exception drop-down menu. The Business Rule and Steps to Correct for the selected exception type appear on the page.
The Results section displays detailed information associated with the selected exception. - To narrow your search, select one or more filters, if available.
- Click Refresh. The Results section displays the filtered exception results specific for the selected data view.
Note: Click Export to export the data collection results to an Excel spreadsheet.
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.
Note: This data review is available aggregated for all schools at the LEA level.
Course In-Field
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
School | The name of the school where the teacher works. | [Schools]Name |
Lead Teacher | The lead teacher's name. | [Users]LastFirst |
UID | The teacher's unique ID number. | [Users]SIF_StatePrid |
Course Number | The course number for the course the instructor teaches. | [Sections]Course_Number |
Section | The section number for the section the instructor teaches. | [Sections]Section_Number |
Number of Students | The number of students enrolled in the section. | [S_NC_StaffDuty]Number_Of_Students |
Term | The term ID. | [Terms]ID |
Year | The year the course was taught. | Calculated |
Qualified for Subject | ||
Qualified for Exceptionalities |
Course Out-of Field
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
School | The name of the school where the teacher works. | [Schools]Name |
Lead Teacher | The lead teacher's name. | [Users]LastFirst |
UID | The teacher's unique ID number. | [Users]SIF_StatePrid |
Course Number | The course number for the course the instructor teaches. | [Sections]Course_Number |
Section | The section number for the section the instructor teaches. | [Sections]Section_Number |
Number of Students | The number of students enrolled in the section. | [S_NC_StaffDuty]Number_Of_Students |
Term | The term ID. | [Terms]ID |
Year | The year the course was taught. | Calculated |
Qualified for Subject | ||
Qualified for Exceptionalities |
Course Code Crosswalk
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
Subject Code | The subject code for the course. | [S_NC_TEACHER_LICENSE_CROSSWALK]Subject_Code |
Subject Name | The name of the subject of the course. | [S_NC_TEACHER_LICENSE_CROSSWALK]Subject_Name |
License Area | The license area of the course. | |
License Description | The description of the license. | [S_NC_TEACHER_LICENSE_CROSSWALK]License_Name |
PK | Indicates if the license and course are applicable to grade level PK. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
K | Indicates if the license and course are applicable to grade level K. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
1 | Indicates if the license and course are applicable to grade level 1. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
2 | Indicates if the license and course are applicable to grade level 2. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
3 | Indicates if the license and course are applicable to grade level 3. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
4 | Indicates if the license and course are applicable to grade level 4. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
5 | Indicates if the license and course are applicable to grade level 5. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
6 | Indicates if the license and course are applicable to grade level 6. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
7 | Indicates if the license and course are applicable to grade level 7. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
8 | Indicates if the license and course are applicable to grade level 8. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
9 | Indicates if the license and course are applicable to grade level 9. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
10 | Indicates if the license and course are applicable to grade level 10. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
11 | Indicates if the license and course are applicable to grade level 11. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
12 | Indicates if the license and course are applicable to grade level 12. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
13 | Indicates if the license and course are applicable to grade level 13. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
EC Course Code Crosswalk
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
EC Code | The EC Code for the course. | [S_NC_EC]EC_Service_Code |
Exceptionality Description | The description of the exceptionality serviced through this EC course. | [S_NC_EC]EC_ProgramType |
License Area | The license area of the course. | |
License Description | The description of the license. | [S_NC_TEACHER_LICENSE_CROSSWALK]License_Name |
PK | Indicates if the license and course are applicable to grade level PK. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
K | Indicates if the license and course are applicable to grade level K. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
1 | Indicates if the license and course are applicable to grade level 1. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
2 | Indicates if the license and course are applicable to grade level 2. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
3 | Indicates if the license and course are applicable to grade level 3. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
4 | Indicates if the license and course are applicable to grade level 4. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
5 | Indicates if the license and course are applicable to grade level 5. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
6 | Indicates if the license and course are applicable to grade level 6. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
7 | Indicates if the license and course are applicable to grade level 7. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
8 | Indicates if the license and course are applicable to grade level 8. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
9 | Indicates if the license and course are applicable to grade level 9. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
10 | Indicates if the license and course are applicable to grade level 10. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
11 | Indicates if the license and course are applicable to grade level 11. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
12 | Indicates if the license and course are applicable to grade level 12. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
13 | Indicates if the license and course are applicable to grade level 13. | [S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level |
Teachers Assignment Audit
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
School | The name of the school where the teacher works. | [Schools]Name |
Teacher | The teacher's name. | [Users]LastFirst |
UID | The teacher's unique ID number. | [Users]SIF_StatePrid |
License Area | The license that the teacher has. | |
License Description | The description of the license. | [S_NC_TEACHER_LICENSE_CROSSWALK]License_Name |
License Expiration | The date the teacher's license expires. | [S_NC_TEACHER_LICENSE]License_Expire_Date |
Course | The course number for the course the instructor teaches. | [Sections]Course_Number |
Section | The section number for the section the instructor teaches. | [Sections]Section_Number |
Course Description | The license required for the course. | [S_NC_COURSE_LICENSE]License_Area_Code |
Number of Students | The number of students enrolled in the section. | [S_NC_StaffDuty]Number_Of_Students |
Term | The term ID. | [Terms]ID |
Year | The year the course was taught. | Calculated |
Teachers License Audit
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
School | The name of the school where the teacher works. | [Schools]Name |
Teacher | The teacher's name. | [Users]LastFirst |
Course | The course number for the course the instructor teaches. | [Sections]Course_Number |
Section | The section number for the section the instructor teaches. | [Sections]Section_Number |
Number of Students | The number of students enrolled in the section. | [S_NC_StaffDuty]Number_Of_Students |
Term | The term ID. | [Terms]ID |
Year | The year the course was taught. | Calculated |
Qualified for Subject | ||
Qualified for Exceptionalities |
Course Assignment Audit
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
School | The name of the school. | [Schools]Name |
Course Number | The course number. | [Sections]Course_Number |
Teacher | The Teacher's name. | [Users]LastFirst |
License Area Code | The area code of the teacher's license. | |
License Description | ||
Valid Grade Levels for State Subject Code / License Area Combination | ||
Qualified for Subject | ||
Qualified for Exceptionalities |
Course Code Not In Crosswalk
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
---|---|---|
Subject Code | The subject code for the course. | [s_nc_rpt_IOF_course]SUBJ_AREA |
Subject Name | The name of the subject of the course. | [s_nc_rpt_IOF_course]COURSE_NAME |