These cases are included in the Campus.2048 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-141422 | ActivitySectionRosterOption | Holds what forms have been filled out for the student. |
SIS-141176 | BilingualEducationProgram | Records representing bilingual education outside of EL. |
SIS-141176 | CustomBilingualEducationProgram | A place for users to store additional BEP information |
SIS-140227 | MealDistribution | For tracking the meals handed at schools |
SIS-140227 | MealDistributionLocation | For tracking the location meals were picked up from |
Modified Tables
Added
| Case Number | Table | Column | Data Type | Description |
SIS-141422 | ActivitySectionRoster | initialSignupComplete | bit | True/false if the student has signed up or has been added to the activity, and shows up on the roster. |
SIS-141422 | ActivitySectionRoster | registrationConfirmed | bit | True/false if the admin has confirmed the proper registration steps have been completed. |
SIS-141356 | DigitalEquity | learningPreference | varchar(15) | The student's learning preference. |
SIS-141356 | DigitalEquity | paperLearningPackets | varchar(15) | If the student is using learning packets are they mail in or pick up. |
SIS-141356 | DigitalEquity | requestedTimeFrame | varchar(15) | The time frame in which the data is collected. |
SIS-142235 | EmploymentAssignment | override1 | varchar(15) | Staff override field. |
SIS-142235 | EmploymentAssignment | override2 | varchar(15) | Staff override field. |
SIS-141672 | EnrollmentID | disadvantaged | bit | Indicates the student is economically disadvantaged by a qualified measure that is not NSLP related. |
SIS-138876 | GoalMonitoringConfiguration | enableAim | bit | Enables the recording of an aim line for reporting. |
SIS-138876 | GoalMonitoringConfiguration | baselineValue | int | Value of aim baseline. |
SIS-138876 | GoalMonitoringConfiguration | aimDate | datetime2 | Date of aim goal. |
SIS-138876 | GoalMonitoringConfiguration | reportObjectiveName | varchar(8000) | Localized objective name generated for the report. |
SIS-138876 | GoalMonitoringConfiguration | baselineDate | datetime2 | Date of aim baseline. |
SIS-138876 | GoalMonitoringConfiguration | reportGoalName | varchar(8000) | Localized goal name generated for the report. |
SIS-138876 | GoalMonitoringConfiguration | aimValue | int | Value of aim goal. |
SIS-140687 | GradingTaskCredit | edfiExclude | bit | Used to exclude select grading tasks from being reported via Ed-Fi. |
SIS-140236 | Lep | fifthYearMonitoring | smalldatetime | Computed column that contains the date five years after exitDate |
SIS-141764 | SchoolStoreSettings | categoryLandingEnabled | bit | Boolean indicating category landing page for store. |
SIS-142403 | Test | testAdministration | varchar(15) | An indication of the state assessment administration period. |
SIS-142403 | TestAccommodations | mathAssessment | bit | Indicates whether this is the first mathematics assessment student has registered for as a high school student. |
SIS-142403 | TestAccommodations | learningModel | varchar(15) | Used to identify students who are learning in a nontraditional environment due to covid-19. |
SIS-142403 | TestAccommodations | readAndWrite | bit | Indicates whether a student needs to log into co:writer and read and write software (separate license required) for use with testnav. |
SIS-142037 | UserAccount | passwordUpdatedDate | date | The date the password was last changed. |
Deprecated
| Case Number | Table | Column | Data Type | Description |
SIS-140384 | EnrollmentNV | attendingSchool | varchar(7) | Deprecated 2020 |
SIS-140384 | EnrollmentNV | foreignExchange | bit | Deprecated 2020 |
SIS-140384 | EnrollmentNV | stateEquivalentGrade | varchar(5) | Deprecated 2020 |
SIS-140384 | EnrollmentNV | optOut | varchar(2) | Deprecated 2020 |
SIS-141176 | LepService | bilingualEdHours | varchar(2) | Number of instructional hours per day that a student qualifies for at the time of their LEP services determination. |
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-142699 | UT | Immunization Rule Update |
SIS-142578 | MA | Added value to EmploymentAssignment Title |
SIS-142175 | OH | Immunization Rule Update |
SIS-128549 | Added Breached Password Detection Notification Event | |
SIS-135791 | CO | Converted Enrollment Section504 to Section 504 Tab |
SIS-142215 | KY | Deleted Previously posted virtual attendance in nonInstructional periods |
SIS-141356 | New Digital Equity fields | |
SIS-142323 | NY | Updated KG nces grades |
SIS-140236 | Preference for EL monitoring 5th year | |
SIS-141738 | MN | Added two new districts |
SIS-141470 | Dropped out of date AZ att procs | |
SIS-140315 | Added Quartz Jobs for MA SIF | |
SIS-141176 | NM | BEP data conversion |
SIS-141706 | Populated passback pref | |
SIS-137346 | Created new hideNoShow pref | |
SIS-141936 | MA | Added VD to unlocked Day EventType |
SIS-140384 | NV | Removed 20-21 EnrollmentNV Data |
