Skip to main content
Skip table of contents

Grade Earned


Selection Criteria

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 Student class enrollment records whose date enrolled is greater than or equal to the Start Date specified by user and 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.
  • If electing to submit a final letter grade earned, the store code of the final grade to submit must be defined from Start Page > School >Grading > Final Grade/Reporting Term Setup > Edit Final Grade.
  • Associate all Grades used with the code set for Grade Earned from the District Office > District > Grade Scales > Select a Grade Scale > Edit > Select a Grade > Edit Grade: Default.
  • The Submit Final Grade Option if selected will pull only students with an Historical Grade - Start Page > Select a Student > Historical Grades.

Back to Top

Report Input 

For help with navigation and running the report, see How to Find and Generate a Report.

Data to be filled

Select Schools

If run at the district level, choose one of the following:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
  • All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Select Students

The default option is All students.
Use The xxx Selected Students to extract by a user-defined filtered student selection.

Start Date

Enter the Start Date for this report

End Date

Enter the End Date for this report

Submit Final Grade

Specify Yes to submit the final grade earned for students.

Specify No if you will not submit the final grade earned for students.

Scheduling OptionsDescription

Scheduling – Run Now

Leave Run Now selected to run the report now.


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.


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 

ColumnData ElementDescription[Table]FieldNameField TypeField Length



This field contains the reporting district code.






Local School Id.






The identifier for the course assigned by the local education agency (LEA).

If the Course RI Course Classification ID = 23002 is reported as a preschool course and so the local course id will be the Service Delivery Module + School Code + Section ID

[Courses]Course_Number OR


+ [S_RI_SCH_X]Ride_ID OR


+ [S_RI_SEC_X]PreSchool_Section_ID




Code used to identify the term (School > Final Grade/Reporting Term Setup > New > Term Code for Grade Earned).

[S_RI_TRB_X]TCS_StoreCode if not Null

[TERMBINS]storecode if not null (matches to TermBins first on [STOREDGRADES]storecode if null then [STOREDGRADES]termbinsname)

[TERMS]isYearRec= then Y1

If none of the above is true then [TERMS]Abbreviation




A 10-digit unique numeric ID assigned to each student in R.I. by the State.






This field contains the locally assigned student number.






A final indicator of student performance in a class as submitted by the instructor.

Extracted as Null





The final letter Grade Earned for a student in the class. A final indicator of student performance in a class as submitted by the instructor. This field is required for grades 6-12 and will be blank in the extract for all other grade levels. The user must specify to submit the final grade at run time. If the user does submit the final grade it must exist as a Stored Grade (Start page > select a student > Historical Grades) see the selection criteria section for this report for the other setup components to submit a final letter grade earned.

Extracted as Null OR

[StoredGrades]Grade AND


The Grade submitted is determined by the Store Code specified for the TCS Section Student Submission. Start Page > School > Grading > Final Grade/Reporting Term Setup > Edit Final Grade.

The Grades in the Grade Scale for the course should be associated with their TCS Grade Equivalent from District Office > District > Grade Scales



ICREDITSRECEIVEDThe number of credits a student earned for completing a given course. The student must be in grade 9 or above and the Term Code for Grade Earned must be set as 'Final' to report credits received.[StoredGrades]EarnedCrHrsText5
JavaScript errors detected

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

If this problem persists, please contact our support.