Skip to main content
Skip table of contents

In-Field Out-Of Field Data Collection

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 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.

  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 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.

[S_NC_TEACHER_LICENSE_CROSSWALK]License_Code

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.

[S_NC_TEACHER_LICENSE_CROSSWALK]License_Code

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.

[S_NC_TEACHER_LICENSE_CROSSWALK]License_Code

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



JavaScript errors detected

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

If this problem persists, please contact our support.