User Tools

Site Tools


powerschool:powerschool:customreports:validation

Validation Custom Reports

Bad Enrollment Dates - Find enrollment records where Exit Date is before Entry Date. Provides data entry to correct invalid records.

Bad Entry Dates - Find active enrollment records where the student's Entry Date falls outside the current school year. Provides data entry to correct invalid records

Delete List - Select student(s) you'd like to delete and run this report to see how many records this student has in several tables.

Federal Ethnicity Report - Show Federal Ethnicity records and search for students with missing Race/Ethnicity info to fix it.

Orphaned Database Record Lookup - Checks various PowerSchool tables for invalid data links and values.

Roll Over Errors - Roll Over Errors shows which records are likely to cause a roll over problem. It tries to help you find the problem before it becomes a problem.

Sync Error SQL Script - CC Report - Validates CC records for: Valid StudentIDs, Duplicate Recrods, Valid SectionIDs, Valid Terms, Data is synced to Sync table

Sync Error SQL Script - Courses Report - Validates Course records for: Unique Course Numbers, Data is synced to Sync table

Sync Error SQL Script - GradeScales Report - Validates Grade Scale records for: Unique Grade Scale Name, Valid Grade Scale Parent ID, Data is synced to Sync table

Sync Error SQL Script - Grade Scales Items Report - Validates Grade Scale Item records for: Unique Grade Identifiers, Valid Grade Scale IDs, Data is synced to Sync table

Sync Error SQL Script - Schools Report - Validates School records for: Unique School Numbers, Data is synced to Sync table

Sync Error SQL Script - Sections Report - Validates Section records for: Valid Teacher ID, Valid Term ID, Valid Course, Valid Store Codes for Final Grades, Unique Records, Data is synced to Sync table

Sync Error SQL Script - Students Report - Validates Student records for: Unique Student Numbers, Data is synced to Sync table

Sync Error SQL Script - Teachers Report - Validates Teacher records for: Data is synced to Sync table

Sync Error SQL Script - TermBins Report - Validates Term Bin records for: Unique Codes for a given term, Valid School Numbers, Valid Term IDs, Data is synced to Sync table

Sync Error SQL Script - Terms Report - Validates Term records for: Unique Abbreviations, Valid School Number, Data is synced to Sync table

powerschool/powerschool/customreports/validation.txt · Last modified: 2018/09/18 16:32 by lokes