These cases are included in the Campus.2040 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-140701 | ALPSSSources | Saves multiselect droplist for ALPSS table. |
SIS-140833 | CustomInstructionMode | Instruction mode district elements. |
SIS-137452 | CustomNavigationLink | Table that holds information about custom navigation tool mappings in the three tiered navigation. |
SIS-136650 | CustomSafeSchools | |
SIS-140833 | InstructionMode | Identifies student instruction modes. |
SIS-139004 | PersonPicture | Table to hold person picture info. |
SIS-136650 | SafeSchools | Safe schools related data. |
Modified Tables
Added
| Case Number | Table | Column | Data Type | Description |
SIS-140701 | ALPSS | otherSource | varchar(500) | Additional comments to explain why other fields are filled in. tied to a multiselect in HI. |
SIS-138465 | BehaviorEvent | retaliationRelated | bit | Indicates whether the behavior event was retaliation related. |
SIS-140000 | BlendedLearningGroup | instructionType | varchar(30) | Type of instruction for the group. |
SIS-140863 | BlendedLearningPreference | savePastAttendanceCounts | bit | Flag to allow teacher to update attendanceCode records on prior days. |
SIS-138465 | Course | cteIndicator | bit | CTE indicator |
SIS-138465 | CourseCatalog | lockCteIndicator | bit | Indicates CTE is locked on a course. |
SIS-138465 | CourseMaster | cteIndicator | bit | CTE indicator |
SIS-139197 | EdFiIdentityMappingAttendance | eventDuration | decimal | Duration of attendance event |
SIS-139508 | EnrollmentIN | distanceLearning | bit | This field is to determine if the student is distance or virtual as a result of covid-19 or not. |
SIS-138465 | EnrollmentMA | civicsProjGrade912 | bit | Indicates the student has completed the grade 9-12 civics project. |
SIS-138465 | EnrollmentMA | civicsProjGrade8 | bit | Indicates the student has completed the grade 8 civics project. |
SIS-140099 | EnrollmentMO | pkReplacementId | varchar(10) | Pk replacement ID. |
SIS-139660 | ExtendedLearningOpportunity | programCode | varchar(15) | Identifies the extended learning program in which the student participating. |
SIS-139660 | ExtendedLearningOpportunity | serviceProvider | varchar(100) | Identifies provider of the expanded and enriched learning time opportunities program. |
SIS-139660 | ExtendedLearningOpportunity | serviceProviderType | varchar(15) | Identifies service provider type. |
SIS-140863 | PortalOptions | blendedLearningGroup | bit | Flag to display blended learning group in campus student and campus parent. |
SIS-139945 | Product | partialRefundsAllowed | bit | Indicates if product can be partially refunded. |
SIS-140429 | ProductCategory | schoolStore | bit | True if this category is allowed to be used in the general product screen. |
SIS-140429 | ProductCategory | activityRegistration | bit | True if this category is allowed to be used in the activity monitor screen. |
SIS-133754 | RecordsTransfer | elDocumentFOP | varchar(100) | The EL document rendering object intended to be used in conjunction with the associated XML data. |
SIS-133754 | RecordsTransfer | elDocumentXML | varchar(MAX) | XML representation of the released student's EL documents. |
SIS-140647 | Roster | createdDate | smalldatetime | Indicates the date the campus user created the record. |
SIS-137797 | Survey | surveyJSON | nvarchar | |
SIS-137797 | SurveyRespondent | regardingPersonID | int | Reference to the person table. |
SIS-137797 | SurveyRespondent | respondentGUID | uniqueidentifier | Internal database identifier. |
SIS-137797 | SurveyResponse | responseJSON | nvarchar | |
SIS-137797 | SurveyResponse | respondentID | int | Reference to the survey respondent table. |
Altered
Case Number | Table | Column | Data Type | Note | Description |
SIS-140476 | BorderStudent | borderDistrictNumber | varchar(12) | Changed data type from | State assigned id for the other district involved in the exchange of this border student. |
Deprecated
Case Number | Table | Column | Data Type | Description |
SIS-140519 | EnrollmentTX | crisisCode | varchar(2) | Crisis-code indicates a state health or weather related event that impacts a group of students, and may require additional funding, educational, or social services. the event may or may not cause the student to leave the district or campus of residence. a crisis event is designated by the commissioner of education. |
SIS-133543 | NASIS | nllNonLanguage | varchar(1) | Student is receiving instruction in other subject areas in the native language |
SIS-133543 | NASIS | nllInstruction | varchar(1) | Student is taking courses on the grammar or speaking of their native language; teachers use both native language and english while instructing the students |
SIS-133543 | NASIS | nllMaintResto | varchar(1) | Student is receiving maintenance or restoration instruction in reading or speaking the native language |
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-140671 | Addition of Tribal Foster Youth | |
SIS-140010 | NY | Immunization Rule Update |
SIS-140309 | MO | PlanAccommodation Additions Updated |
SIS-140501 | MA | Immunization Rule Updated |
SIS-137452 | Inserted default custom tabs | |
SIS-140557 | Converted thumbnails to https | |
SIS-140810 | MT | Limited Edition SpecialEDState Cleanup |
SIS-140519 | Converted crisis codes into crisis events | |
SIS-140552 | ME | Immunization Rule Updated |
SIS-140000 | Filled instructionType for TX districts | |
SIS-140670 | MN | Added new Rock Ridge disctrict |
SIS-124095 | OneRoster OAuth expiration message | |
SIS-140165 | SD | Immunization Rule Updated |
SIS-140568 | Migrated Tool Rights for Category screen | |
SIS-139914 | Removed LTI launch type parameters from db | |
SIS-140529 | PA | Immunization Rule Updated |
SIS-140474 | CA | Converted EL and Programs to EL Services |
SIS-140339 | NE | Converted SchoolID Data |
SIS-140476 | ID | Corrected data conversion to BorderStudent |
SIS-140064 | IN | Updated Districts |
SIS-139744 | IL | Modification to EL Services Type Name |
SIS-133754 | KY | Added custom module EL Documents |
SIS-137452 | Created navigation links for custom tabs | |
SIS-138747 | Updated Behavior State Resolution Codes | |
SIS-138747 | Updated Behavior State Event Codes | |
SIS-133543 | Added parent rights for moved tool |
