These cases are included in the Campus.2148 release pack.
Feedback Requested
As a user of this schema change document, would you find would you find this type of information helpful if it was provided for Rx releases such as Rx Pack - Campus.2132? (Schema changes in Rx cases are rare, on average one in thirty cases.)
Please respond in the comments field at the end of this article. Thanks!
Data Definition Language Scripts (DDL)
This section lists data structures that were created, altered, or dropped, based on the vocabulary used to define data structures in SQL Server.
New Tables
There were no new tables added with this release.
Modified Tables
Added
| Case Number |
Table |
Column |
Data Type |
Description |
|---|---|---|---|---|
| SIS-147605 | EvalState | residentSchool | varchar 100 | The Enrollment resident school. |
| SIS-147605 | EvalStudent | varChar1 | varchar 8000 | Generic varchar field to be used however states need it. |
| SIS-147605 | EvalStudent | varChar2 | varchar 8000 | Generic varchar field to be used however states need it. |
| SIS-147605 | EvalStudent | anticipatedGradYear | int | Anticipated Graduation Year |
| SIS-147605 | SEETeamMeetingAttendanceAlt | varChar1 | varchar 8000 | Generic text field to be used how each state sees fit. |
| SIS-147605 | SEEvaluationResults | disability6 | varchar 5 | N/A |
| SIS-147605 | SEEvaluationResults | disability7 | varchar 5 | N/A |
| SIS-147605 | SEEvaluationResults | disability8 | varchar 5 | N/A |
| SIS-147605 | SEEvaluationResults | disability9 | varchar 5 | N/A |
| SIS-147605 | SEEvaluationResults | disability10 | varchar 5 | N/A |
| SIS-147605 | SEEvaluationResults | disability6Name | varchar 100 | Data stored in this editor stores the name value of the associated disability code for historical purposes. |
| SIS-147605 | SEEvaluationResults | disability7Name | varchar 100 | Data stored in this editor stores the name value of the associated disability code for historical purposes. |
| SIS-147605 | SEEvaluationResults | disability8Name | varchar 100 | Data stored in this editor stores the name value of the associated disability code for historical purposes. |
| SIS-147605 | SEEvaluationResults | disability9Name | varchar 100 | Data stored in this editor stores the name value of the associated disability code for historical purposes. |
| SIS-147605 | SEEvaluationResults | disability10Name | varchar 100 | Data stored in this editor stores the name value of the associated disability code for historical purposes. |
|
SIS-148437 |
EnrollmentIL |
detentionCenter |
bit |
Indicates student is in a detention center |
|
SIS-149826 |
PlanProgressReport |
progressReportNum2 |
tinyint |
Generic field to be used as states need. |
|
SIS-149826 |
PlanProgressReport |
progressReportNum1 |
tintyint |
Generic field to be used as states need. |
|
SIS-150405 |
RecordsTransfer |
section504XML |
varchar max |
Xml representation of the releasedstudent's historical section 504information from the program participation > section 504 tab. |
|
SIS-150405 |
RecordsTransfer |
section504FOP |
varchar 100 |
The section504 renderingobject intended to be used inconjunction with the associated xmldata. |
| SIS-150902 | EarlyLearning | gatewayRegistryMemberID | varchar 15 | Gateway Registry Member ID |
| SIS-150902 | EarlyLearning | providerHasGatewayCredential | bit | Has gateway Registry Member ID |
| SIS-151251 | MIEarlyChildhood | licenseNumber | varchar 20 | License number to the location child receives EC services. |
Altered
| Case Number |
Table |
Column |
Data Type |
Notes |
Description |
|---|---|---|---|---|---|
| SIS-135949 |
School |
providerNumber |
varchar |
varchar 11 to varchar 20 |
License number to the location child receives EC services. Used in MI. |
Data Manipulation Language Scripts (DML)
This section lists scripts to add, modify, query, or remove data from a SQL Server database.
| Case Number | State | Description |
|---|---|---|
|
SIS-148927 |
|
Fixed issue with already created new look preferences |
|
SIS-151125 |
|
Activity Registration Notification Link |
|
SIS-150237 |
|
Reindexed Person2 |
|
SIS-149825 |
KY |
Removed Safe schools warning 5 stored procedure |
|
SIS-151015 |
|
Removed Section Instructional Setting Code CN |
|
SIS-148927 |
|
Added Preference For Showing District New UI Preference Selection |
|
SIS-150405 |
|
Added Section504 DISObject |
|
SIS-150405 |
MT |
Section504 data conversion |
|
SIS-150657 |
WY |
SIF ISO Home Primary Language Updates |
|
SIS-151033 |
|
Reverted Program SQL changes |
|
SIS-150548 |
ME |
Immunization Rule Update |
|
SIS-150084 |
MN |
Added Ada Borup 2910-01 to Districts Table |
|
SIS-150922 |
|
Updated EdFiIDs for parents to include the district number |
|
SIS-150803 |
KS |
Immunization Rule Update |
|
SIS-150237 |
|
Reindexed Person |
