Student Validation Report - RE
Contents
Introduction
Use this report to validate select student information for PIMS. Run this report prior to running the PIMS Student Template to verify that there is no missing student information. This report prints in PDF format.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the Students table based on the following criteria:
- The student must be enrolled in a school included in the selection process.
- The student and student enrollment must be included in state reporting (Exclude from State Reporting is set to No).
- The student must have a school enrollment during the reporting period.
Report Input
For help with report generation and navigation, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
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. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM: 05. |
Report Start Date | Enter the start date for the reporting period. |
Report End Date | Enter the end date for the reporting period. |
Report Output
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.
Item # | Data Element | Description | [Table]FieldName |
N/A | Student Number | The student’s locally assigned identifier. This field is extracted from Start Page > Student > Demographics. | [Students]Student_Number |
N/A | Student Name | The student’s name in Last, First Middle format. This field is extracted from Start Page > Student > Demographics. | [Students]Last_Name [Students]First_Name [Students]Middle_Name |
N/A | Grade | The student’s grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level |
Error Message The following fields are verified during the Student Validation Report process. The related error message is included when the field is missing a value. | |||
10 | Grade | Current Grade Level contains either a space or is blank. This field is calculated; current grade levels are converted to the three-digit state codes. The value displayed for Kindergarten, preschool, and ungraded students is extracted from the Grade Code field on the Edit Enrollment page, Start Page > Student > Transfer Info > Edit Enrollment. | [Students]Grade_Level [ReEnrollments]Grade_Level [S_PA_STU_X]State_Grade_Code [S_PA_REN_X]State_Grade_Code |
14 | Birth Date | Birth Date is blank. This field is stored on the Demographics page, Start Page > Student > Demographics. | [Students]DOB |
15 | Gender Code | Gender Code contains either a space or is blank. This field is stored on the Demographics page, Start Page > Student > Demographics. | [Students]Gender |
16 | Address 1 | Address 1 contains either a space or is blank. This field is stored on the Demographics page, Start Page > Student > Demographics. | [Students]Mailing_Street |
18 | City | City contains either a space or is blank. This field is stored on the Demographics page, Start Page > Student > Demographics. | [Students]Mailing_City |
19 | State | State contains either a space or is blank. This field is stored on the Demographics page, Start Page > Student > Demographics. | [Students]Mailing_State |
20 | Full Zip Code | Full Zip Code contains either a space or is blank. This field is stored on the Demographics page, Start Page > Student > Demographics. | [Students]Mailing_Zip |
27 | Ethnic Code Short | Ethnicity is blank. This message displays if the Ethnicity and/or Race fields are not populated. If the Race fields are populated but the Ethnicity field is blank, no error is generated. This field is stored on the Demographics page, Start Page > Student > Demographics. | [Students]FedEthnicity And [StudentRace]RaceCd |
38 | Special Education | Invalid Student Status for Special Ed Student This message displays if the Special Education field is set to Yes, and the Challenge Type and/or the Student Status fields are blank. This field is stored on the Edit Current Enrollment page, Start Page > Student > Transfer Info > Edit Current Enrollment. | [S_PA_STU_X]IS_SPED_Student_YN or [S_PA_STU_X]Special_Education_IEP_Code
|
41 | LEP Participation | LEP Participant with blank First Date in an ELL/Bilingual Ed Program, if LEP Participation is set to 01 and the Date First Enrolled in an ELL/Bilingual Ed Program field is blank. LEP Participant with blank First date Enrolled in US School, if LEP Participation is set to 01 and the Date First Enrolled in US School field is blank. LEP Participant with blank Home Language Fields, if LEP Participation is set to 01 and the Home Language Code field is blank. LEP Participant with blank Num of Years, if LEP Participation is set to 01 and the Years in US Schools field is blank. This field is stored on the PIMS Student Template Data Fields page, Start Page > Student > State/Province – PA > Student Info. | [S_PA_STU_X]LEP_ELL_Status_Code |
66 | Graduation Status Code | Expected Post Graduate Activity contains either a space or is blank, if any of the following conditions are met: The Graduation Status Code is set to G and the Expected Post Graduate Activity is not one of the following values: 10, 20, 30, 40, 50, 60, 70, 80, 90, 100, 110, 120, 130, 140, 150, 160, 170, 180, or 997. The Graduation Status Code is set to G and the Diploma Type field is blank. The Graduation Status Code is set to Dropout (A, B, D, C, W, R, or O) and the Expected Post Graduate Activity is not one of the following values: 110, 120, 130, 140, 150, 160, 170, 180, 997, or 998. The Graduation Status Code is set to Dropout (A, B, D, C, W, R, or O) and the Diploma Type field is blank. This field is stored on the PIMS Student Template Data Fields page, Start Page > Student > State/Province – PA > Student Info. | [S_PA_STU_X]Graduation_Status_Code |
98 | District Entry Date | District Entry Date is blank. This field is stored on the Modify Information page, Start Page > Student > Modify Information. | [Students]DistrictEntryDate |
99 | School Entry Date | School Entry Date is blank. This field is stored on the Modify Information page, Start Page > Student > Modify Information. | [Students]SchoolEntryDate |
100 | State Entry Date | State Entry Date contains either a space or is blank. This field is stored on the PIMS Student Template Data Fields page, Start Page > Student > State/Province – PA > Student Info. | [S_PA_STU_X]State_Entry_Date |
N/A | PASecureID | PA Secure ID contains either a space or is blank. This field is stored on the PIMS Student Template Data Fields page, Start Page > Student > State/Province – PA > Student Info. | [Students]State_StudentNumber |
N/A | Entry Code | Entry Code contains either a space or is blank. This field is stored on the Edit Enrollment page, Start Page > Student > Transfer Info > Edit Enrollment. | [Students]Entry_Code [Reenrollments]Entry_Code |
N/A | Track | Track contains either a space or is blank. This field is stored on the Edit Enrollment page, Start Page > Student > Transfer Info > Edit Enrollment. | [Students]Track [Reenrollments]Track |
N/A | FTE | Full-time equivalency is blank. This field is stored on the Edit Enrollment page, Start Page > Student > Transfer Info > Edit Enrollment. | [Students]FTEID [ReEnrollments]FTEID |