This article collects the changes made to the database schema as part of the Campus.2543 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
By request, we've added a new column to the New Tables and Modified Tables that indicates whether a field can be null.
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 |
Can Be NULL? |
|---|---|---|---|---|
SIS-187207 |
OneRosterDynamicSeqStudent |
critID |
int |
no |
seq |
int |
no | ||
personID |
int |
no | ||
SIS-187207 |
OneRosterDynamicSeqStudentSchool |
critID |
int |
no |
schoolID |
int |
no | ||
seq |
int |
no | ||
personID |
int |
no | ||
SIS-188720 |
OrganizationGroupAction |
orgGroupActionID |
int |
no |
personID |
int |
no | ||
action |
varchar(30) |
no | ||
generatedByPersonID |
int |
no | ||
generatedTimestamp |
datetime2(0) |
no | ||
automated |
bit |
no | ||
orgGroupID |
int |
yes | ||
SIS-188720 |
OrganizationGroupUserAgreement |
personID |
int |
no |
accepted |
bit |
no | ||
SIS-189774 |
SnapshotDeleteQueue |
snapshotDeleteQueueID |
int |
no |
deletionObject |
varchar(50) |
no | ||
deletionKey |
varchar(256) |
yes | ||
requestTimestamp |
datetime2(0) |
no | ||
responseTimestamp |
datetime2(0) |
yes | ||
status |
varchar(25) |
yes | ||
endYear |
int |
yes | ||
schoolID |
int |
yes | ||
districtID |
int |
yes | ||
requestPersonID |
int |
yes | ||
responsePersonID |
int |
yes | ||
comments |
varchar(256) |
yes | ||
archived |
bit |
no | ||
snapshotDeleteQueueGUID |
uniqueidentifier |
no | ||
SIS-190439 |
StateIDPConfig |
stateIDPConfigID |
int |
no |
idpEntityID |
varchar(255) |
no | ||
certificateAlias |
varchar(255) |
yes | ||
alternativeCertificateAlias |
varchar(255) |
yes | ||
SIS-192716 |
CustomHomeSchool |
customID |
int |
no |
attributeID |
int |
no | ||
homeSchoolID |
int |
no | ||
value |
varchar(256) |
yes | ||
date |
date |
yes |
Renamed Tables
Case Number |
Table Name |
Previous Table Name |
|---|---|---|
SIS-193161 |
DependentCareSessionCreditInvoice |
DependentCareCreditInvoice |
DependentCareSessionMemberCredit |
DependentCareMemberCredit | |
DependentCareSessionMemberCreditAdjustment |
DependentCareMemberCreditAdjustment |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-191800 |
DistrictAttribute |
orgPlan |
varchar(15) |
yes |
SIS-193827 |
DistrictResidency |
servingDistrictPhone |
varchar(25) |
yes |
SIS-193257 |
EnrollmentND |
fte |
varchar(15) |
yes |
SIS-188720 |
ForumPost |
createdTimestamp |
datetime2(0) |
no |
SIS-188720 |
ForumPostFlag |
resolvedTimestamp |
datetime2(0) |
yes |
SIS-188720 |
ForumPostFlag |
resolvedByDelete |
bit |
no |
SIS-188536 |
ForumThread |
allowReplies |
bit |
no |
SIS-193553 |
Lep |
ilpDate |
date |
yes |
SIS-188536 |
OrganizationGroup |
createdTimestamp |
datetime2(0) |
no |
SIS-188536 |
OrganizationGroup |
createdByID |
int |
no |
SIS-188536 |
OrganizationGroup |
modifiedTimestamp |
datetime2(0) |
no |
SIS-188536 |
OrganizationGroup |
modifiedByID |
int |
no |
SIS-188536 |
OrganizationMemberSettings |
blocked |
bit |
no |
SIS-192716 |
RecordsTransfer |
homeSchoolXML |
varchar(max) |
yes |
SIS-192716 |
RecordsTransfer |
homeSchoolFOP |
varchar(100) |
yes |
SIS-186735 |
ResponsiveOffering |
teacherDisplay |
varchar(102) |
yes |
SIS-186735 |
ResponsiveOffering |
nonPrimaryTeachers |
varchar(255) |
yes |
SIS-193814 |
SEEGenericForm |
tinyint21 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint22 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint23 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint24 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint25 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint26 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint27 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint28 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint29 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint30 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint31 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint32 |
tinyint |
yes |
SIS-193814 |
SEEGenericForm |
tinyint33 |
tinyint |
yes |
SIS-192817 |
SpecialEDState |
purposeOfEvaluation |
varchar(15) |
yes |
SIS-192817 |
SpecialEDState |
preschoolSpecialEdSetting |
varchar(10) |
yes |
SIS-192817 |
SpecialEDState |
lastComprehensiveAssessment |
date |
yes |
SIS-192817 |
SpecialEDState |
anticipatedGradDate |
date |
yes |
SIS-192817 |
SpecialEDState |
initialIEPDate |
date |
yes |
SIS-192817 |
SpecialEDState |
createdIEPDate |
date |
yes |
SIS-192817 |
SpecialEDState |
annualReviewIEPDate |
date |
yes |
SIS-192817 |
SpecialEDState |
initialEvalDate |
date |
yes |
SIS-192817 |
SpecialEDState |
threeEvalDate |
date |
yes |
SIS-190439 |
UserGroup |
userGroupGUID |
uniqueidentifier |
no |
SIS-190439 |
UserGroup |
owner |
varchar(50) |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-190940 |
AssessmentScoreImport |
name |
varchar(255) |
no |
SIS-193490 |
CourseMaster |
programType |
varchar(70) |
yes |
SIS-193818 |
EvalGuardian |
languageAlt2 |
varchar(40) |
yes |
SIS-193818 |
EvalStudent |
languageAlt2 |
varchar(40) |
yes |
SIS-193818 |
PlanGuardian |
languageAlt2 |
varchar(40) |
yes |
SIS-193818 |
PlanStudent |
languageAlt2 |
varchar(40) |
yes |
SIS-193814 |
SEPlan |
additionalInfo |
varchar(8000) |
yes |
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-187207 |
OneRoster Dynamic Index Student Criteria | |
SIS-188978 |
MI |
Programs to AtRisk and Section504 conversion |
SIS-189774 |
DIS object SnapshotDeleteQueue | |
SIS-189943 |
Added preference for ELOP Days | |
SIS-189943 |
Added quartz job for ELOP Days | |
SIS-191445 |
DE |
Updated certCredentialDegree |
SIS-192223 |
Converted IRC Credentials from Enrollment to Academic Program | |
SIS-192417 |
Added failover Messenger Preferences | |
SIS-192470 |
Updated PMR validation | |
SIS-192607 |
ND |
Added Home School DIS Object |
SIS-192731 |
NE |
Updates to District attribute dictionaries |
SIS-192794 |
MO |
Immunization Rule Update |
SIS-192849 |
NC |
Created Shared Branch to Store Validations |
SIS-192862 |
NY |
Immunization Rule Update |
SIS-192969 |
ND |
Disabled Early Learning Opportunities (ELO) Program |
SIS-193061 |
TN |
Ed-Fi Turn off Programs resource |
SIS-193162 |
Inserted serviceID and name for records missing this data | |
SIS-193205 |
KS |
Ed-Fi student school attendace event object key update |
SIS-193209 |
CA |
Regenerated Attendance Recovery Records |
SIS-193247 |
OK |
Enabled FormPdfJs |
SIS-193257 |
ND |
Added FTE column to EnrollmentND |
SIS-193314 |
OK |
Added DIS quartz job |
SIS-193475 |
WI |
Updated LEP field name |
SIS-193523 |
NV |
Updated DE District table |
SIS-193717 |
Populated Helper IDP SAMLSPConfig for csm | |
SIS-193727 |
Enabled Account Linking Phase 3 | |
SIS-193796 |
DE |
Added Complex Medical Condition to the list of conditions |
SIS-193838 |
KY |
Gifted Talented Documents regeneration for districts with docs |
SIS-193838 |
KY |
Gifted and Talented DocumentFile regeneration |
SIS-193993 |
IA |
Updated District List |
