MI MSDS Setup Validation
Introduction
This will create the MI MSDS Setup Validation report. Use this to validate MSDS setup data for non-student tables. The report will list the records failing validation along with their associated error messages.
The following list of tables are validated:
- Courses
- CC
- GradeScaleItem
- PGFinalGrades
- Sections
- Schools
- SchoolStaff
- StoredGrades
- Students
- Terms
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.
Record Selection
The report selects records based on the following criteria:
- Setup elements are invalid or need verification.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Reporting District's State Assigned 5-digit District Number | Enter the reporting district's state assigned 5-digit district number. |
First Day of School | Enter the date of the first day of school. |
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 |
|---|---|---|---|
1 | Table | This contains the table name where the record exists. | N/A |
2 | C1 | This contains identifying information for the record. | [Courses] [CC] [GradeScaleItem] [PGFinalGrades] [Sections] [Schools] [SchoolStaff] [StoredGrades] [Students] [Terms] |
3 | C2 | This contains identifying information for the record. | [Courses] [CC] [GradeScaleItem] [PGFinalGrades] [Sections] [Schools] [SchoolStaff] [StoredGrades] [Students] [Terms] |
4 | Date | This contains the date of the record, if applicable. | [Courses] [CC] [GradeScaleItem] [PGFinalGrades] [Sections] [Schools] [SchoolStaff] [StoredGrades] [Students] [Terms] |
5 | C3 | This contains identifying information for the record. | [Courses] [CC] [GradeScaleItem] [PGFinalGrades] [Sections] [Schools] [SchoolStaff] [StoredGrades] [Students] [Terms] |
6 | Message | This contains the error or verification message for the record. | N/A |