Courses By Year Migration Validation
Contents
Report Description
Reports non-compliant data in CoursesByYear that was unable to be properly migrated into S_VA_CBY_X.
Note: Recommended to run after EOY archiving of Courses data has been completed.
Selection Criteria
This report has no selection criteria.
Report Input
This report has no report parameters.
Report Output
Use the output to determine if any further data entry needs to be done to correct migration failures.
Important Note: This report does NOT change any data.
| Item # | Data Element | Description | [Table]FieldName |
|---|---|---|---|
| 1 | SchoolId | The school's ID number | [Schools]School_Number |
| 2 | YearId | The school year ID (e.g. 27=2017) | [Schools]YearID |
| 3 | COURSESBYYEAR.fieldname | Identifies the source field name in the CoursesByYear clob custom field | [COURSESBYYEAR]fieldname |
| 4 | S_VA_CBY_X.fieldname | Identifies the destination field name in the S_VA_CBY_X table. | [S_VA_CBY_X]fieldname |
| 5 | CoursesByYearId | The ID column corresponding to Courses By Year ID and S_VA_CBY_X's Courses By Year ID. | [COURSESBYYEAR]ID and [S_VA_CBY_X]COURSESBYYEARID |
| 6 | Course_Number | The course number in the CourseByYear table. | [COURSESBYYEAR]Course_Number |
| 7 | Course_Name | The course name in the CourseByYear table. | [COURSESBYYEAR]Course_Name |
| 8 | COURSESBYYEAR.data (old) | This clob data from CoursesByYear is non-compliant in some way (e.g. too long to fit in the S_VA_CBY_X field). | [COURSESBYYEAR]data |
| 9 | Truncated data (by migration script) | The data placed into S_VA_CBY_X by the successful execution of the repoSchemaupdate process. | [S_VA_CBY_X]data |
| 10 | Current S_VA_CBY_X.data | The data currently stored in S_VA_CBY_X. It may be different from the truncated migrated data if you have manually changed the record. | [S_VA_CBY_X]data |