This article collects the changes made to the database schema as part of the Campus.2443 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
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 |
Column |
Data Type |
|---|---|---|---|
SIS-175986 |
POSCoreImport |
importID |
int |
filename |
varchar(100) | ||
uploadByID |
int | ||
uploadTimestamp |
datetime2(0) | ||
importByID |
int | ||
importTimestamp |
datetime2(0) | ||
exportedJSON |
varchar(max) |
Modified Tables
Added
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-182329 |
ALPSS |
location |
varchar(15) |
SIS-182329 |
ALPSS |
locationType |
varchar(15) |
SIS-182329 |
ALPSS |
servingDistrict |
varchar(15) |
SIS-182921 |
CrisisEvent |
createdDate |
date |
SIS-181957 |
Dropout |
verifiedDropout |
bit |
SIS-181957 |
Dropout |
schoolNumber |
varchar(12) |
SIS-181957 |
Dropout |
grade |
varchar(15) |
SIS-181957 |
Dropout |
dropoutYear |
smallint |
SIS-181957 |
Dropout |
exemptionCode |
varchar(15) |
SIS-179877 |
EnrollmentTX |
lastDayAsOfStatus |
varchar(15) |
SIS-181448 |
Graduation |
postSecondarySignedPlanDate |
datetime2(0) |
SIS-173752 |
IMLearningObjectFile |
wysiwygFile |
bit |
SIS-173752 |
LessonPlanAttachment |
wysiwygFile |
bit |
SIS-182558 |
MigrantService |
provider |
varchar(15) |
SIS-182558 |
MigrantService |
serviceFrequency |
varchar(15) |
SIS-182921 |
RecordsTransfer |
crisisEventXML |
varchar(max) |
SIS-182921 |
RecordsTransfer |
crisisEventFOP |
varchar(100) |
SIS-173349 |
SectionGroup |
teacherEdited |
bit |
SIS-173010 |
SEPlan |
originalMeetingDate |
date |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-182371 |
Enrollment |
endStatus |
varchar(5) |
SIS-182371 |
Enrollment |
startStatus |
varchar(5) |
SIS-182371 |
EnrollmentEndStatusType |
code |
varchar(5) |
SIS-182371 |
EnrollmentStartStatusType |
code |
varchar(5) |
Deleted Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-179585 |
CrossSiteConstraintSchoolOffer |
offerToDistrictGUID |
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-171924 |
Added scheduled import export cleanup job | |
SIS-173010 |
Copied Meeting Date to Original Meeting Date | |
SIS-178378 |
MT |
Updated StateGradeLevelDefinition |
SIS-179585 |
Removed CrossSiteIntraDistricSectionDetail view | |
SIS-179945 |
Deleted deprecated programs from EdFiIdentityMapping and convert programStatus | |
SIS-180073 |
Updated campus attributes for careerreadiness | |
SIS-180149 |
NC |
Removed inactive languages |
SIS-180396 |
NJ |
EnrollmentNJ inDistrictPlacement converted ELL to ML |
SIS-180396 |
NJ |
District record updates |
SIS-180413 |
NC |
PMR Validations Update |
SIS-180413 |
NC |
PMR Validations Creation |
SIS-180829 |
Enabled CSE Intra-District Functionality for additional states | |
SIS-181728 |
Splay CDRUpdateStudentcountJob | |
SIS-181760 |
WY |
Immunization Rule Update |
SIS-181804 |
BIE |
Updated NASIS tribalCode |
SIS-181834 |
DE |
Added MedicaidEligibility DISObject |
SIS-181999 |
WI |
Immunization Rule Update |
SIS-182017 |
Added confidentiality preference | |
SIS-182028 |
OK |
Updated SIF Mapping for endStatus |
SIS-182047 |
WI |
Converted checkboxes 4 and 5 to 2 and 1 |
SIS-182055 |
CO |
Immunization Rule Update |
SIS-182175 |
OR |
Immunization Rule Update |
SIS-182178 |
KY |
Converted Roster to SSDV in Batches |
SIS-182178 |
KY |
Converted Roster to SSD records in batches |
SIS-182178 |
KY |
Converted Roster values to Section Student Detail records |
SIS-182179 |
OK |
Converted SPED fields from Enrollment to new Tab |
SIS-182209 |
NC |
Hid Official Transcript from portal and fixed typo |
SIS-182460 |
NC |
PMR Validations Fix |
SIS-182608 |
NC |
Immunization Rule Update |
SIS-182734 |
OR |
Immunization Rule Update |
SIS-182921 |
Added crisis event DIS object |
