This article collects the changes made to the database schema as part of the Campus.2447 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-179751 |
InterdistrictDataSyncLog |
interdistrictDataSyncLogID |
int |
|
date |
date | ||
|
action |
varchar(30) | ||
|
studentNumber |
varchar(15) | ||
|
studentName |
varchar(101) | ||
|
courseNumber |
varchar(13) | ||
|
courseName |
varchar(30) | ||
|
sectionNumber |
smallint | ||
|
oldValue |
varchar(250) | ||
|
newValue |
varchar(250) | ||
|
servingDistrictName |
varchar(50) | ||
|
servingSchoolName |
varchar(50) | ||
|
homeSchoolID |
int | ||
|
SIS-179751 |
InterdistrictDataSyncNotification |
interdistrictDataSyncNotificationID |
int |
|
date |
date | ||
|
schoolID |
int | ||
|
calScheduleOrRosterChanged |
bit | ||
|
SIS-182848 |
TestAccommodationsValue |
testAccommodationsValueID |
int |
|
testAccommodationsID |
int | ||
|
attributeID |
int | ||
|
value |
varchar(50) | ||
|
testAccommodationsValueGUID |
uniqueidentifier |
Modified Tables
Added
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
|
SIS-183684 |
Calendar |
daysPerWeek |
varchar(15) |
|
SIS-182660 |
Contact |
contactID |
int |
|
SIS-182660 |
Contact |
districtID |
int |
|
SIS-174573 |
EmploymentCredential |
staffTraining |
varchar(15) |
|
SIS-183698 |
EnrollmentMA |
icpsParticipation |
varchar(15) |
|
SIS-183467 |
EnrollmentMT |
fallEarlyLiteracy |
bit |
|
SIS-183467 |
EnrollmentMT |
springEarlyLiteracy |
bit |
|
SIS-183396 |
EnrollmentNH |
assessmentSchool |
varchar(15) |
|
SIS-182792 |
ExtendedLearningOpportunity |
createdDate |
date |
|
SIS-182792 |
ExtendedLearningOpportunity |
comments |
varchar(255) |
|
SIS-183454 |
ExtendedLearningOpportunity |
exitReason |
varchar(15) |
|
SIS-182814 |
OnTrack |
postSecondaryAsset |
varchar(15) |
|
SIS-179355 |
OwlHistory |
appServer |
varchar(50) |
|
SIS-155218 |
POSService |
sortOrder |
int |
|
SIS-178285 |
POSTransaction |
purchaseProductID |
int |
|
SIS-178285 |
POSTransactionHistory |
purchaseProductID |
int |
|
SIS-183433 |
RecordsTransfer |
onTrackXML |
varchar(max) |
|
SIS-183433 |
RecordsTransfer |
onTrackFOP |
varchar(100) |
|
SIS-182882 |
SectionStudentDetailValue |
valueGUID |
uniqueidentifier |
|
SIS-182985 |
SpecialEDState |
spedProgramTime |
decimal(5,2) |
|
SIS-182985 |
SpecialEDState |
nonPublic |
varchar(15) |
|
SIS-182985 |
SpecialEDState |
areasOfSLD |
varchar(1000) |
|
SIS-182985 |
SpecialEDState |
disability4 |
varchar(15) |
|
SIS-182985 |
SpecialEDState |
disability5 |
varchar(15) |
Altered Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
|
SIS-180742 |
CTEStatusNJ |
techSkillsAssessment |
varchar(15) |
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-179514 |
TN |
District Assignment to District Employment conversion |
|
SIS-179668 |
OR |
Resequenced vaccines |
|
SIS-179751 |
|
Added job for CDE Sync change notifications |
|
SIS-179837 |
MA |
Added new state grade level definitions |
|
SIS-181195 |
KY |
New state linked district added to district list |
|
SIS-181275 |
MN |
Updated district name for district 4073 |
|
SIS-181412 |
WI |
Updated name in District table |
|
SIS-181970 |
|
Fix DCT entries added with error flag |
|
SIS-182607 |
VA |
Immunization Rule Update 2nd time |
|
SIS-182607 |
VA |
Immunization Rule Update |
|
SIS-182699 |
NY |
Immunization Rule Update.backup1 |
|
SIS-182699 |
NY |
Immunization Rule Update |
|
SIS-182835 |
AZ |
Deleted Mappings with Depricated objectKey |
|
SIS-182848 |
|
Migrated custom test accommodations to test accommodations value |
|
SIS-182882 |
|
Added ssd to DIS |
|
SIS-182948 |
VT |
Added edfiMappings |
|
SIS-182948 |
VT |
Created Programs and convert to ProgramParticipations from Enrollment fields |
|
SIS-182986 |
MO |
Immunization Rule Update |
|
SIS-182995 |
NJ |
Program Participation Conversion - Title1 |
|
SIS-182995 |
NJ |
Program Participation Conversion - Section504 |
|
SIS-182995 |
NJ |
Program Participation Conversion - Migrant |
|
SIS-182995 |
NJ |
Program Participation Conversion - Gifted and Talented |
|
SIS-182995 |
NJ |
Program Participation Conversion - Alternative Program |
|
SIS-183008 |
KY |
Created Section Student Detail Value records for affirmative values only |
|
SIS-183246 |
DE |
Ed-Fi update immunizationCodeDescriptors saved values |
|
SIS-183275 |
MA |
Immunization Rule Update |
|
SIS-183398 |
AZ |
Immunization Rule Update |
|
SIS-183600 |
KS |
Converted vocationalCode from checkbox to droplist |
|
SIS-183684 |
MT |
Moved daysPerWeek data |
