These cases are included in the Campus.2136 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-146926 | CustomSpecialEDTransition | A place for users to store additional specialEdTransition information. |
SIS-147395 | CustomTherapeuticProgramReferral | State reporting table for custom defined attribute values of the therapeutic program referral. |
SIS-144704 | RecurringPaymentTransaction | Links a payment transaction to the recurring payment that created it. |
SIS-146926 | SpecialEDTransition | Used for special education transition information. |
SIS-147395 | TherapeuticProgramReferral | State reporting table for therapeutic program referrals. |
Modified Tables
Added
Case Number | Table | Column | Data Type | Description |
SIS-144852 | CustomNavigationLink | sortKey | varchar(100) | Optional value of alternative name for entry used in sorting |
SIS-147395, SIS-149059 | EmploymentAssignment | bit | Indicates if the staff member has access to idea data system | |
SIS-147395, SIS-149059 | EmploymentAssignment | mentorID | varchar(15) | Id of the mentor for an educator |
SIS-147395 | EnrollmentIA | therapeuticProgramClassroom | bit | Is the student in a therapeutic program classroom? |
SIS-149059 | EnrollmentMA | enrollmentOfferDate | date | Charter school enrollment offer date field |
SIS-149059 | EnrollmentMA | charterSchoolSibling | varchar(15) | Charter school sibling preference. |
SIS-148740 | InstructionMode | school | varchar(4) | Indicates the state school number where the student is receiving instruction. |
SIS-147579 | archiveDate | datetime2 | Indicates the date the print format was archived. | |
SIS-148638 | ProductItem | initialQuantity | int | Initial quantity on hand set for the item |
SIS-148740 | RecordsTransfer | instructionModeFOP | varchar(100) | The instructionMode rendering object intended to be used in conjunction with the associated XML data. |
SIS-148740 | RecordsTransfer | instructionModeXML | varchar(MAX) | XML representation of the released student's instructionMode. |
SIS-144704 | RecurringFeePayment | createdDate | datetime | The timestamp the payment entry was initially created. |
SIS-144704 | RecurringFeePayment | deletedDate | datetime | The timestamp the payment entry was deleted. |
SIS-144704 | RecurringFeePayment | modifiedDate | datetime | The timestamp the payment entry was modified. |
SIS-144704 | RecurringPOSPayment | createdDate | datetime | The timestamp the payment entry was initially created. |
SIS-144704 | RecurringPOSPayment | deletedDate | datetime | The timestamp the payment entry was deleted. |
SIS-144704 | RecurringPOSPayment | modifiedDate | datetime | The timestamp the payment entry was modified. |
SIS-147874 | Survey | createdByCampus | bit | Is the survey created and pushed by campus |
SIS-147874 | Survey | campusSurveyMetadata | nvarchar |
Altered
Case Number | Table | Column | Data Type | Note | Description |
SIS-147395 | BehaviorEvent | propertyIncident | char | Used in IA. indicates that the behavior event related to property. | |
SIS-147955 | SchoolAttribute | locale | varchar(15) | Changed data type from varchar(1) to varchar(15). | Indicates school virtual status. |
Data Definition Language Scripts
DDL: Statements to create, alter, or drop data structures in an instance of SQL Server.
| Case Number | State | Description |
SIS-146981 | Early Warning State Sync | |
SIS-145333 | MN | Immunization Rule Update |
SIS-148934 | NY | Immunization Rule Update |
SIS-148785 | Set editorType for messenger | |
SIS-148980 | MD | Immunization Rule Update |
SIS-149067 | Activity product date sync | |
SIS-147573 | MI | Converted physical checkBox for HouseholdLocations |
SIS-142281 | MA | EndStatus Codes |
SIS-144319 | NE | Updated NE device mappings for 21 22 |
SIS-148740 | MT | Added InstructionMode DIS Object |
SIS-147874 | Created Character Lab's Thriving Index Survey in Survey Tool | |
SIS-147874 | Created Character Lab's Thriving Index in Survey Tool | |
SIS-144911 | MN | Added day eventTypes to unlocked dictionary |
SIS-148403 | Triggered Reindex Address | |
SIS-147955 | SchoolAttribute.locale field conversion |
