Section - Staff Report
Contents
Introduction
Use the Section - Course report to collect the course portion of the Teacher Course Student Data Collection.
Selection Criteria – Section - Staff
Selection criteria determines which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
The report selects records based on the following criteria:
- All Teachers and associated Contributing Educators of Sections whose start date is greater than or equal to the Start Date specified by user and whose end date is less than or equal to the End Date specified by the user will be will be selected.
- The Course cannot be set to be excluded from state reporting.
- The school cannot be excluded from state reporting.
Report Input – Section - Staff
For help with navigation and running the report, see How to Find and Generate a Report.
Data to be Filled | |
Start Date | Enter the beginning date in the range of dates you want to use to determine the records to include on the report. |
End Date | Enter the last date in the range of dates you want to use to determine the records to include on the report. |
Scheduling Options | Description |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Submit | Click Submit to run the report now. |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run. |
Please Select Schedule Settings | Enter the Start Date and Start time. Click the Repeat button. |
Please select repeat cycle options. | Choose the applicable option. |
Please select end date range option | Enter the appropriate information. |
Submit | Click Submit to schedule the report |
Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.
Report Output - Section-Staff
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.
Column | Data Element | Description | [Table]FieldName | Field Type | Field Length |
A | DISTCODE | This field contains the reporting district code. | [Prefs]District_Number | Text | 2 |
B | SCHCODE | Local School Id. | [S_RI_SCH_X]Ride_ID | Text | 5 |
C | LOCALSECTIONID | This field contains the reported local section id. It is the ‘SectionID – Teacher Number’. For example, ‘1000-100’. If the Course Classification ID = 23002 for a preschool course, the local section ID will be the Service Delivery Module + School Code + Preschool Section ID + Section Number | [Sections]ID +[SchoolStaff]ID OR [S_RI_CRS_X]Service_Delivery_Model + [Schools]School_Number OR [S_RI_CRS_X]Private_SpecialEd_School + [S_RI_SEC_X]PreSchool_Section_ID + [Sections]Section_Number | Text | 20 |
D | CERTID | This field contains the unique number or alphanumeric code assigned to staff member by the state. | [S_RI_USR_X]USID | Text | 10 |
E | STAFFLASTNAME | The full legal name borne in common by members of a family. | [Users]Last_Name | Text | 50 |
F | STAFFFIRSTNAME | The full legal first name given to and individual at birth, baptism, or through legal change. | [Users]First_Name | Text | 50 |
G | STAFFMIDDLENAME | A full legal secondary name given to an individual at birth, baptism, or through legal change. | [Users]Middle_Name | Text | 50 |
H | SECTIONSTARTDATE | The month, day, and year in which staff started teaching a course section. | [S_RI_SEC_X]Contrib_Educator1_Start_Date [S_RI_SEC_X]Contrib_Educator2_Start_Date [S_RI_SEC_X]Contrib_Educator3_Start_Date [S_RI_SEC_X]Contrib_Educator4_Start_Date [S_RI_SEC_X]Contrib_Educator5_Start_Date AND [S_RI_SEC_ContributingTeacher_C]EntryDate | Date | |
I | SECTIONENDDATE | The month, day, and year in which staff ended teaching a course section. | [S_RI_SEC_X]Contrib_Educator1_End_Date [S_RI_SEC_X]Contrib_Educator2_End_Date [S_RI_SEC_X]Contrib_Educator3_End_Date [S_RI_SEC_X]Contrib_Educator4_End_Date [S_RI_SEC_X]Contrib_Educator5_End_Date AND [S_RI_STU_ContributingTeacher_C]ExitDate | Date | |
J | STAFFROLEID | This field contains the code for job class or staff role. Click herefor a complete set of acceptable values. | [S_RI_USR_X]Staff_Role_ID | Text | 10 |
K | TEACHEROFRECORD | An indicator that signifies if this is the educator responsible for content instruction and determining student grades. | [S_RI_SEC_X]Contrib_Educator1_Tchr_of_Rec [S_RI_SEC_X]Contrib_Educator1_Tchr_of_Rec [S_RI_SEC_X]Contrib_Educator1_Tchr_of_Rec [S_RI_SEC_X]Contrib_Educator1_Tchr_of_Rec [S_RI_SEC_X]Contrib_Educator1_Tchr_of_Rec | Text | 1 |
L | ELACONTRIBUTOR | An indicator that signifies that the educator provides English Language Arts/Literacy development through this course. | [S_RI_SEC_X]Contrib_Educator1_ELA [S_RI_SEC_X][Sections]S_RI_SEC_X.Contrib_Educator2_ELA [S_RI_SEC_X]Contrib_Educator3_ELA [S_RI_SEC_X]Contrib_Educator4_ELA [S_RI_SEC_X]Contrib_Educator5_ELA | Text | 1 |
M | MATHCONTRIBUTOR | An indicator that signifies that the educator provides Math development through this course. | [S_RI_SEC_X]Contrib_Educator1_Math [S_RI_SEC_X]Contrib_Educator2_Math [S_RI_SEC_X]Contrib_Educator3_Math [S_RI_SEC_X]Contrib_Educator4_Math [S_RI_SEC_X]Contrib_Educator5_Math | Text | 1 |