These cases are included in the Campus.2144 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
Case Number | Table | Description |
SIS-149088 |
| Birth to 3 program related data. |
SIS-149088 |
| Birth to 3 program district elements. |
SIS-138349 |
| Queue for records to be processed for dis from database triggers. |
SIS-138349 |
| Contains data on what triggers should insert into the DISEventQueue in sp_dcttriggergenerate. |
SIS-144974 |
| Definition of a dataset within a snapshot. |
SIS-144974 |
| Unique identifier for snapshot definition schema version corresponding to cache db table name. |
SIS-144974 |
| Record of a report snapshot. |
SIS-131349 |
| Calendar/schedule structure options for portal display. |
SIS-131349 |
| Custom modules enabled to display in campus portal. |
SIS-131349 |
| Indicates the tools/data that displays in campus portal. |
SIS-131349 |
| Template information for portal display options. |
SIS-131349 |
| Terms enabled to display in campus portal. |
SIS-148854 |
| A group of students receiving RTI. |
SIS-148854 |
| This table links RTIBatch to person and plans tables. |
SIS-138349 |
| Stores the XML that is needed to later delete a SIFf record that has been sent. Only saved for objects that can send events. |
Modified Tables
Added
Case Number | Table | Column | Data Type | Description |
SIS-138349 | DISZone | excludeStateExcludeDistrictAssignments | bit | |
SIS-143456 | DigitalLearningVendor OAuth2ClientCredentials | forLTI | bit | Indicates whether the OAuth client is for that vendor's LTI configuration. |
SIS-149280 | GiftedStatusKY | artsAnecdotalRecords | bit | Evidence indicator when a visual and performing arts code is selected in the gifted category field. |
SIS-149280 | GiftedStatusKY | artsContinuousProgress | bit | Evidence indicator when a visual and performing arts code is selected in the gifted category field. |
SIS-149280 | GiftedStatusKY | artsPrimaryReviewCommittee | bit | Evidence indicator when a visual and performing arts code is selected in the gifted category field. |
SIS-149280 | GiftedStatusKY | artsFormalTesting | bit | Evidence indicator when a visual and performing arts code is selected in the gifted category field. |
SIS-143456 | LTILaunch | ltiProviderID | int | LTI 1.3 only, LTIProviderID for launch. |
SIS-143456 | LTILaunch | ltiVersion | varchar(20) | Indicates what LTI version was used in the launch, 1.1 or 1.3. |
SIS-143456 | LTILaunch | personGUID | uniqueidentifier | LTI 1.3 only, PersonGUID for launch. |
SIS-143456 | LTIProvider | v1p3Enabled | bit | Indicates this provider should be configured to use LTI 1.3 specification. |
SIS-143456 | LTIProvider | targetLinkURI | varchar(100) | Target link URI for a given provider. |
SIS-143456 | LTIProvider | oauth2ClientID | int | Indicates the oauth2 client for the LTI provider. |
SIS-143456 | LTIProvider | deploymentID | uniqueidentifier | Deployment id used in LTI 1.3 specification, all records will have a value by default. |
SIS-143456 | LTIProvider | loginInitiationURL | varchar(100) | Login initiation URL for a given provider. |
SIS-143456 | OAuth2ClientCredentials | publicKeysetURL | varchar(100) | Public keyset URL for a given provider. |
SIS-150260, SIS-149553 | PaymentTransactionProduct | transactionFeeRefund | bit | Indicates if this record is a refund to a transaction fee. |
SIS-150260, SIS-149553 | PaymentTransactionProduct | modifiedTimestamp | datetime2 | When this record was last synchronized with the payment vendor. |
SIS-150260, SIS-149553 | PaymentTransactionProduct | depositRequired | bit | Indicates if the product can be deposited or not. |
SIS-146975 | PlanGuardian | languageAlt | varchar(100) | Stores an alternate language value. |
SIS-146975 | PlanGuardian | surrogateParentCheck | bit | Indicates if the guardian is the students surrogate parent. |
SIS-146975 | PlanState | varCharMSStr2 | varchar(8000) | Generic field to hold multiselect name data. |
SIS-146975 | PlanState | varCharMS1 | varchar(8000) | Generic field to hold multiselect name data. |
SIS-146975 | PlanState | varCharMSStr1 | varchar(8000) | Generic field to hold multiselect name data. |
SIS-146975 | PlanState | varCharMS2 | varchar(8000) | Generic field to hold multiselect name data. |
SIS-148021 | Product | enabledPortal | bit | Boolean indicating if product is available on campus parent and student. |
SIS-148021 | Product | enabledEss | bit | Boolean indicating if category is active on ESS. |
SIS-148021 | ProductCategory | enabledPortal | bit | Boolean indicating if product is active on campus parent and student. |
SIS-148021 | ProductCategory | enabledEss | bit | Boolean indicating if category is active on ESS. |
SIS-148344 | Roster | provider | varchar(15) | CTE institution identification number for the rostered student. |
SIS-146975 | SEPDetermineEligibility | recordDate1 | date | A field for a date. |
SIS-146975 | SEPGenericSubForm | varchar5 | varchar(8000) | A field for text. |
SIS-146975 | SEPGenericSubForm | varchar4 | varchar(8000) | A field for text. |
SIS-146975 | SEPGenericSubForm | recordDate1 | datetime2 | A field for a date. |
SIS-146975 | SEPGenericSubForm | varchar6 | varchar(8000) | A field for text. |
SIS-146975 | SEPOutcomeMeasures | exitAssessmentToolName | varchar(100) | This table is used in special education IEPs. |
SIS-146975 | SEPOutcomeMeasures | exitAssessmentTool | varchar(15) | This table is used in special education IEPs. |
SIS-146975 | SEPTransportationPlan | varCharMS1 | varchar(8000) | Generic multi select codes field to be used as states see fit. |
SIS-146975 | SEPTransportationPlan | varChar3 | varchar(100) | Generic varchar field to be used as states see fit. |
SIS-146975 | SEPTransportationPlan | varCharMSStr1 | varchar(8000) | Generic multi select names field to be used as states see fit. |
SIS-146975 | SEPTransportationPlan | varChar1 | varchar(100) | Generic varchar field to be used as states see fit. |
SIS-146975 | SEPTransportationPlan | varChar2 | varchar(100) | Generic varchar field to be used as states see fit. |
SIS-148021 | SchoolStoreSettings | enabledEss | bit | Boolean indicating if store is active on ESS. |
SIS-150368 | SurveyRespondent | fromStudentFilter | bit | Is the respondent from the student filter. |
Altered
Case Number | Table | Column | Data Type | Note | Description |
|---|---|---|---|---|---|
SIS-150175 | TestScore | responsibleEntityID | varchar(12) | Changed data type from varchar(6) to varchar(12). | Internal database identifier |
SIS-150153 | TwentyFirstCCLC | programProvider | varchar(15) | Changed data type from int to varchar(15). | Indicates program provider. |
Deprecated
| Case Number | Table | Column | Data Type | Description |
SIS-143456 | LTIProvider | iconURL | varchar(2000) | Deprecated: icon image source URL. |
SIS-131349 | MobileDevice | deviceToken | varchar(256) | |
SIS-131349 | MobileDevice | notifyAssignments | tinyint | |
SIS-131349 | MobileDevice | notifyLunchBalance | tinyint | |
SIS-131349 | MobileDevice | systemVersion | varchar(100) | |
SIS-131349 | MobileDevice | notifyGrades | tinyint | |
SIS-131349 | MobileDevice | createdDate | smalldatetime | |
SIS-131349 | MobileDevice | assignmentThreshold | varchar(50) | |
SIS-131349 | MobileDevice | deviceModel | varchar(50) | |
SIS-131349 | MobileDevice | personID | int | |
SIS-131349 | MobileDevice | notifyBehavior | tinyint | |
SIS-131349 | MobileDevice | gradesThreshold | varchar(50) | |
SIS-131349 | MobileDevice | deviceType | varchar(50) | |
SIS-131349 | MobileDevice | lunchBalanceThreshold | varchar(50) | |
SIS-131349 | MobileDevice | notifyAttendance | tinyint | |
SIS-131349 | MobileDevice | modifiedDate | smalldatetime | |
SIS-131349 | PortalDocumentOptions | portalID | int | Foreign key to PortalOptions. |
SIS-131349 | PortalDocumentOptions | form | bit | Stores the flag that indicates if custom forms from the module should be displayed on campus student/parent. |
SIS-131349 | PortalDocumentOptions | moduleID | int | Foreign key to CustomModule. |
SIS-131349 | PortalDocumentOptions | optionID | int | Internal identifier. |
Data Manipulation Language Scripts
DML: Statements to create, alter, or drop data structures in an instance of SQL Server.
| Case Number | State | Description |
SIS-150365 | NV | Enabled Homeless Tab |
SIS-149268 | Reindexed Household | |
SIS-143456 | Fixed oneRoster autoTestProvider for cat tests | |
SIS-146975 | MI | Enrollment Attribute |
SIS-150492 | NM | Converted gender data to birthGender |
SIS-149707 | HI | Immunization Rule Update |
SIS-150146 | Set editorType for messenger sms | |
SIS-138349 | Dropped EdFi trial trigger and add replacement | |
SIS-150389 | MP | Added State Grade Levels |
SIS-150175 | AZ | Updated responsibleEntityID length |
SIS-150219 | IL | Immunization Rule Update |
SIS-150113 | MN | Immunization Rule Update |
SIS-144974 | Snapshot Report Preference | |
SIS-138349 | Added DIS quartz jobs | |
SIS-150148 | GA | Updated dummy districts to inactive |
SIS-148551 | Added subRight for RecordsTransfer | |
SIS-149930 | Updated OneRoster Hourly Quartz Job to run at 30th minute of hour | |
SIS-150017 | AZ | Immunization Rule Update |
SIS-148321 | Reindexed Person | |
SIS-145827 | Added POS tables to DCT | |
SIS-149775 | NE | Ed-Fi Update School Entity ID |
SIS-96207 | Deleted and updated entries for previously combined persons | |
SIS-131349 | Portal Options conversion to new schema | |
SIS-140395 | Added workspaceUrls to existing notifications | |
SIS-96207 | Deleted and updated entries for combined persons |
