Skip to main content
Skip table of contents

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.

  1. On the Start Page, click State Reports. The State Reporting Dashboard page appears and displays a list of data collections for the school.
  2. Next to the In-Field Out-Of Field Data Collection, click Run.
  3. The system validates the data against the business rules set up for the collection and completes the process.
  4. 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

  1. Next to the In-Field Out-Of Field Data Collection, click Review.
  2. 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 ViewDescription
Course In-FieldThis 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 FieldThis 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 CrosswalkList of all Course Code Crosswalk records.
EC Course Code CrosswalkList of all EC Course Code Crosswalk records.
Teachers Assignment AuditThis report shows all lead teacher and co-teacher assignments to sections.
Teachers License AuditThis 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 AuditThis 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.

  1. From the Dashboard, click Review. The Review page appears.
  2. Select Exceptions from the Reviews drop-down menu. Exceptions associated with a data collection display.
  3. 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.
  4. To narrow your search, select one or more filters, if available.
  5. 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 ElementDescription[Table]FieldName
SchoolThe name of the school where the teacher works.[Schools]Name
Lead TeacherThe lead teacher's name.[Users]LastFirst
UIDThe teacher's unique ID number.[Users]SIF_StatePrid
Course NumberThe course number for the course the instructor teaches.[Sections]Course_Number
SectionThe section number for the section the instructor teaches.[Sections]Section_Number
Number of StudentsThe number of students enrolled in the section.[S_NC_StaffDuty]Number_Of_Students
TermThe term ID.[Terms]ID
YearThe year the course was taught.Calculated
Qualified for Subject

Qualified for Exceptionalities

Course Out-of Field

Report Output Format: Excel spreadsheet, CSV

Data ElementDescription[Table]FieldName
SchoolThe name of the school where the teacher works.[Schools]Name
Lead TeacherThe lead teacher's name.[Users]LastFirst
UIDThe teacher's unique ID number.[Users]SIF_StatePrid
Course NumberThe course number for the course the instructor teaches.[Sections]Course_Number
SectionThe section number for the section the instructor teaches.[Sections]Section_Number
Number of StudentsThe number of students enrolled in the section.[S_NC_StaffDuty]Number_Of_Students
TermThe term ID.[Terms]ID
YearThe year the course was taught.Calculated
Qualified for Subject

Qualified for Exceptionalities

Course Code Crosswalk

Report Output Format: Excel spreadsheet, CSV

Data ElementDescription[Table]FieldName
Subject CodeThe subject code for the course.[S_NC_TEACHER_LICENSE_CROSSWALK]Subject_Code
Subject NameThe name of the subject of the course.[S_NC_TEACHER_LICENSE_CROSSWALK]Subject_Name
License AreaThe license area of the course.

[S_NC_TEACHER_LICENSE_CROSSWALK]License_Code

License DescriptionThe description of the license.[S_NC_TEACHER_LICENSE_CROSSWALK]License_Name
PKIndicates if the license and course are applicable to grade level PK.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

KIndicates if the license and course are applicable to grade level K.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

1Indicates if the license and course are applicable to grade level 1.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

2Indicates if the license and course are applicable to grade level 2.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

3Indicates if the license and course are applicable to grade level 3.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

4Indicates if the license and course are applicable to grade level 4.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

5Indicates if the license and course are applicable to grade level 5.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

6Indicates if the license and course are applicable to grade level 6.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

7Indicates if the license and course are applicable to grade level 7.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

8Indicates if the license and course are applicable to grade level 8.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

9Indicates if the license and course are applicable to grade level 9.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

10Indicates if the license and course are applicable to grade level 10.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

11Indicates if the license and course are applicable to grade level 11.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

12Indicates if the license and course are applicable to grade level 12.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

13Indicates 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 ElementDescription[Table]FieldName
EC CodeThe EC Code for the course.[S_NC_EC]EC_Service_Code
Exceptionality DescriptionThe description of the exceptionality serviced through this EC course.[S_NC_EC]EC_ProgramType
License AreaThe license area of the course.

[S_NC_TEACHER_LICENSE_CROSSWALK]License_Code

License DescriptionThe description of the license.[S_NC_TEACHER_LICENSE_CROSSWALK]License_Name
PKIndicates if the license and course are applicable to grade level PK.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

KIndicates if the license and course are applicable to grade level K.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

1Indicates if the license and course are applicable to grade level 1.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

2Indicates if the license and course are applicable to grade level 2.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

3Indicates if the license and course are applicable to grade level 3.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

4Indicates if the license and course are applicable to grade level 4.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

5Indicates if the license and course are applicable to grade level 5.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

6Indicates if the license and course are applicable to grade level 6.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

7Indicates if the license and course are applicable to grade level 7.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

8Indicates if the license and course are applicable to grade level 8.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

9Indicates if the license and course are applicable to grade level 9.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

10Indicates if the license and course are applicable to grade level 10.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

11Indicates if the license and course are applicable to grade level 11.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

12Indicates if the license and course are applicable to grade level 12.

[S_NC_TEACHER_LICENSE_CROSSWALK]Valid_Grade_Level

13Indicates 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 ElementDescription[Table]FieldName
SchoolThe name of the school where the teacher works.[Schools]Name
TeacherThe teacher's name.[Users]LastFirst
UIDThe teacher's unique ID number.[Users]SIF_StatePrid
License AreaThe license that the teacher has.

[S_NC_TEACHER_LICENSE_CROSSWALK]License_Code

License DescriptionThe description of the license.[S_NC_TEACHER_LICENSE_CROSSWALK]License_Name
License ExpirationThe date the teacher's license expires.[S_NC_TEACHER_LICENSE]License_Expire_Date
CourseThe course number for the course the instructor teaches.[Sections]Course_Number
SectionThe section number for the section the instructor teaches.[Sections]Section_Number
Course DescriptionThe license required for the course.[S_NC_COURSE_LICENSE]License_Area_Code
Number of StudentsThe number of students enrolled in the section.[S_NC_StaffDuty]Number_Of_Students
TermThe term ID.[Terms]ID
YearThe year the course was taught.Calculated

Teachers License Audit

Report Output Format: Excel spreadsheet, CSV

Data ElementDescription[Table]FieldName
SchoolThe name of the school where the teacher works.[Schools]Name
TeacherThe teacher's name.[Users]LastFirst
CourseThe course number for the course the instructor teaches.[Sections]Course_Number
SectionThe section number for the section the instructor teaches.[Sections]Section_Number
Number of StudentsThe number of students enrolled in the section.[S_NC_StaffDuty]Number_Of_Students
TermThe term ID.[Terms]ID
YearThe year the course was taught.Calculated
Qualified for Subject

Qualified for Exceptionalities

Course Assignment Audit

Report Output Format: Excel spreadsheet, CSV

Data ElementDescription[Table]FieldName
SchoolThe name of the school.[Schools]Name
Course NumberThe course number.[Sections]Course_Number
TeacherThe Teacher's name.[Users]LastFirst
License Area CodeThe 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 ElementDescription[Table]FieldName
Subject CodeThe subject code for the course.[s_nc_rpt_IOF_course]SUBJ_AREA
Subject NameThe name of the subject of the course.[s_nc_rpt_IOF_course]COURSE_NAME



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.