Technical Information - Release Pack Campus.2148

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-147605EvalStateresidentSchoolvarchar 100The Enrollment resident school.
SIS-147605EvalStudentvarChar1varchar 8000Generic varchar field to be used however states need it.
SIS-147605EvalStudentvarChar2varchar 8000Generic varchar field to be used however states need it.
SIS-147605EvalStudentanticipatedGradYearintAnticipated Graduation Year
SIS-147605SEETeamMeetingAttendanceAltvarChar1varchar 8000Generic text field to be used how each state sees fit.
SIS-147605SEEvaluationResultsdisability6varchar 5N/A
SIS-147605SEEvaluationResultsdisability7varchar 5N/A
SIS-147605SEEvaluationResultsdisability8varchar 5N/A
SIS-147605SEEvaluationResultsdisability9varchar 5N/A
SIS-147605SEEvaluationResultsdisability10varchar 5N/A
SIS-147605SEEvaluationResultsdisability6Namevarchar 100Data stored in this editor stores the name value of the associated disability code for historical purposes.
SIS-147605SEEvaluationResultsdisability7Namevarchar 100Data stored in this editor stores the name value of the associated disability code for historical purposes.
SIS-147605SEEvaluationResultsdisability8Namevarchar 100Data stored in this editor stores the name value of the associated disability code for historical purposes.
SIS-147605SEEvaluationResultsdisability9Namevarchar 100Data stored in this editor stores the name value of the associated disability code for historical purposes.
SIS-147605SEEvaluationResultsdisability10Namevarchar 100Data 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-150902EarlyLearninggatewayRegistryMemberIDvarchar 15Gateway Registry Member ID
SIS-150902EarlyLearningproviderHasGatewayCredentialbitHas gateway Registry Member ID
SIS-151251MIEarlyChildhoodlicenseNumbervarchar 20License 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 NumberStateDescription

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