Manual Entry Stored Grades Verification Report - PEIMS

Introduction

The Manual Entry Stored Grades verification report supports the verification of records for the PEIMS Summer and Extended Year Submissions.

The logic for this report is based on the requirements for manual entry of stored grade records for the PEIMS collections only. A separate version of the report to support the verification of records for AAR and TREx will be provided in another release. The prior Manual Entry Stored Grades Verification Report has been removed from the state reports page.

Selection Criteria

Global Criteria
- The year in record is the year selected in the runtime parameter
  - Summer PEIMS: The current year
  - Extended Year PEIMS: The prior school year
- Section ID = 0 (Associated Section = None)
- Service ID does not start with SA, SE, SR, SS, or 8
- Exclude from PEIMS/TSDS does not = 1
- Special Explanation Code does not = 3 or L
- The Alternate CDC field is blank or is populated with a school number that belongs to the district.
- Store Code is mapped fo a Final Grade Type in Texas Store Mapping
Additional Criteria for Summer
- Eligible for HS Credit = true in S_TX_SERVICE_ID_S table
  OR
- Non-Campus Based Instruction Code = 04 or 05. Note that all records for Houston ISD Texas Connections Academy (School ID 101912100) are automatically included and output with a Non-Campus Based Instruction Code of 04 - TxVSN Online School Program.
Additional Criteria for Extended Year
- Special Explanation Code = R
- Dual Credit Indicator = 1
  OR
- Alternate Course Number = CP110100 or CP111200 (College Prep ELA or Math)
  OR
- Service ID is flagged as a high school CTE Course in the TEA C022 Service ID table

Report Input

For help with navigation and running the report, see Generate Reports.

Field

Description

Select Schools*

Choose which school(s) to include in the report by selecting one of the following options:

At the school level:

The currently selected school is the default.

At the district level:

Select Multiple Schools – Use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract.
All Schools (default) – The report includes all student records on the PowerSchool server that meet the selection criteria.

School Year

Choose the school year for which to run this report.

(If you are running the report for Extended Year, select the previous school year)*

Collection Code

Choose Summer or Extended Year codes:

SUMR
EXYR

Report Output

Data Element	Description
Last Name	Student First Name
First Name	Student Last Name
Student Number	Student Number
UID	Student Unique ID (State Student Number)
Grade Level	Student Current Grade Level
Hist Grade Level	From Stored Grades
School Year	From Stored Grades
School Name	From Stored Grades
School Number	From Stored Grades
Course Number	Override from Stored Grades; else from Courses
Course Name	Override from Stored Grades; else from Courses
Alternate Crs Number	Override from Stored Grades; else from Courses
CTE	Y or N based on lookup to C022 table (Y if "CTE Course" = H)
Store Code	From Stored Grades
Final Grade Type	S1, S2 or AV
Grade	"Missing" if blank and Percent = 0
Percent	"Missing" if 0 and Grade is also blank
Earned Credit	From Stored Grades
Potential Credit	From Stored Grades
Pass/Fail Ind	Override from Stored Grades; else calculated based on grade earned
Course Sequence	Override from Stored Grades; else calculated from Courses
Explanation Code	Override from Stored Grades; else from Courses
Begin Date	"Missing" if blank
End Date	"Missing" if blank
Class ID	"Missing" if blank
Non-Campus Based Instr	Override from Stored Grades; else from Courses; auto-populated as “04” for CDC 101912100
Dual Credit	Override from Stored Grades; else from Courses
College Credit	Override from Stored Grades; else calculated from Courses & Grade Earned
ATC	Override from Stored Grades; else from Courses