These cases are included in the Campus.2044 release pack.
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-140017 | ProgramParticipationCTE | Contains participation-related information for a given program. |
SIS-126186 | Section504BIE | Student's BIE section 504 related data. |
Modified Tables
Added
| Case Number | Table | Column | Data Type | Description |
SIS-140248 | DigitalEquity | comments | varchar(256) | Placeholder for comments |
SIS-141511 | ESignature | intentToSign | bit | Indicates that the form had the signature applied when progress is being saved. |
SIS-141511 | ESignature | intentToDecline | bit | Indicates that the form had the declined wording applied when progress is being saved. |
SIS-140586 | Employment | override1 | varchar(15) | Employment status override field. |
SIS-140586 | Employment | exclude | bit | Exclude staff member from reporting as a whole. |
SIS-140586 | Employment | override2 | varchar(15) | Employment status override field. |
SIS-135118 | ExtendedLearningOpportunity | performanceEvaluationCode | varchar(20) | A coded value representing the student's performance in the internship as evaluated by their employment supervisor. |
SIS-135118 | ExtendedLearningOpportunity | certificatedSupervisedInd | bit | An indication of whether the internship was part of a program supervised by a certificated staff member of the school, district, or county. |
SIS-135118 | ExtendedLearningOpportunity | learningType | varchar(20) | A coded value representing the work-based learning that the student completed. |
SIS-135118 | ExtendedLearningOpportunity | stateCode | varchar(20) | School or out-of-district location where student is receiving services. |
SIS-135118 | ExtendedLearningOpportunity | leaSponsoredInd | bit | An indication of whether the school, district, or county played a direct role in securing the internship for the student. |
SIS-138373 | Form | guardianFill | bit | This is copied from formdocument at the time of linking this form to a student. |
SIS-138373 | Form | studentFill | bit | This is copied from formdocument at the time of linking this form to a student. |
SIS-138373 | FormDocument | guardianFill | bit | Does this form require guardians to fill part of the form? it must be requireguardianes. |
SIS-138373 | FormDocument | studentFill | bit | Does this form require student to fill part of the form? it must to be requirestudentes. |
SIS-138373 | FormElement | portalFill | bit | This field can be filled by portal users – guardians and students. |
SIS-138373 | FormElement | teacherFill | bit | This field can be filled by teachers |
SIS-140597 | HREmploymentAssignment | starGradeLevelOverride | varchar(2) | Grade level override for MN HR districts. |
SIS-140597 | HREmploymentAssignmentHistory | starGradeLevelOverride | varchar(2) | Grade level override for MN HR districts. |
SIS-139308 | ProductSale | purchasePersonID | int | Reference to person that purchased the item. |
SIS-133701 | SSRSReport | group | varchar(32) | Group corresponding to the app group in campus.xml, e.g BIE in BIE districts. |
SIS-137979 | SectionStaffHistory | certificationLevel | varchar(45) | Used to track teacher certification level. |
SIS-141078 | StudentParticipation | participationType | varchar(15) | Stores campusdictionary code, by default it will be async or sync if campus attribute is not hidden. |
Altered
| Case Number | Table | Column | Data Type | Notes | Description |
SIS-141071 | PlanServiceLog | settingString | varchar(120) | Changed data type from varchar(100) to varchar(120). | The string value of the plan setting. |
SIS-133701 | SSRSReport | state | varchar(3) | Changed data type from varchar(2) to varchar(3). | The state that the report should be ran for. |
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-141278 | Removed duplicate try-new-look preferences again. | |
SIS-141839 | IA | Removed unused SIF mappings. |
SIS-140174 | Daily Health Log Survey Events and Actions. | |
SIS-131063 | ME | Added new district Limestone. |
SIS-140850 | KS | Immunization Rule Update MCV4. |
SIS-141681 | NJ | Added 2 Districts. |
SIS-141468 | OH | Immunization Rule Update. |
SIS-140850 | KS | Immunization Rule Update. |
SIS-141000 | NV | Updated District List. |
SIS-141690 | UT | Added values to SIFRaceEthnicity. |
SIS-126186 | Added Section504BIE DISObject. | |
SIS-126186 | Converted EnrollmentBIE.section504BIE to Section504BIE. | |
SIS-126186 | Added Section504BIE to DCT. | |
SIS-140586 | MA | SIF exclude options. |
SIS-141225 | AZ | Immunization Rule Update. |
SIS-141524 | Gave qualified users rights to free form Transcript entry. | |
SIS-141151 | IL | Immunization Rule Update. |
SIS-140562 | AZ | Update District List. |
SIS-139601 | Reindexed Trigger CourseMaster and CourseSection. | |
SIS-139601 | Reindexed Trigger CourseSection and CourseMaster. | |
SIS-141456 | Added crisis events and check for campus attribute and dictionary. | |
SIS-126053 | TX | Conversion from CTEStatusTX to ProgramParticipationCTE. |
SIS-141344 | WI | Added digital equity mappings. |
SIS-140686 | Added Annual entry to payFrequency. | |
SIS-141018 | NJ | Added district. |
SIS-139601 | Reindexed CourseSection and CourseMaster. | |
SIS-141334 | Set custom.path.pivot prefence to false. | |
SIS-140901 | Added Job for blended learning group back date process. | |
SIS-140839 | KY | Deleted All Virtual Attendance. |
SIS-140483 | NY | Activated end status 430 in 2019. |
SIS-140991 | Added 99 to unlocked Day EventType. | |
SIS-140699 | IN | Immunization Rule Update. |
SIS-133223 | OneOff Script updated link to new app finance. | |
SIS-140017 | ProgramPerson fields to new ProgramParticipationCTE table. |
