This article collects the changes made to the database schema as part of the Campus.2515 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-183812 |
SIFObjectRights |
sifObjectRightsID |
int |
no |
|
zoneName |
varchar(20) |
no | ||
|
objectName |
varchar(40) |
no | ||
|
respondsToRequests |
bit |
no | ||
|
publishEvents |
bit |
no | ||
|
SIS-183812 |
SIFResponseHistory |
sifResponseHistoryID |
int |
no |
|
sifResponseHistoryGUID |
uniqueidentifier |
no | ||
|
zoneName |
varchar(20) |
yes | ||
|
object |
varchar(50) |
yes | ||
|
status |
varchar(25) |
yes | ||
|
startTimestamp |
datetime2(3) |
no | ||
|
endTimestamp |
datetime2(3) |
yes | ||
|
recordsSent |
int |
yes | ||
|
recordsProcessed |
int |
yes | ||
|
recordsErrorCount |
int |
yes | ||
|
requestType |
varchar(25) |
yes | ||
|
SIS-183950 |
ActivityClearedRosterUpload |
activityClearedRosterUploadID |
int |
no |
|
personID |
int |
no | ||
|
activityUploadID |
int |
no | ||
|
activitySectionID |
int |
no | ||
|
createdDate |
datetime2(0) |
no | ||
|
modifiedByID |
int |
no | ||
|
modifiedTimestamp |
datetime2(0) |
no | ||
|
deletedByID |
int |
yes | ||
|
SIS-183950 |
ActivitySectionRosterUpload |
activitySectionRosterUploadID |
int |
no |
|
activitySectionRosterID |
int |
no | ||
|
activityUploadID |
int |
no | ||
|
cloudFileID |
int |
yes | ||
|
uploadedByID |
int |
yes | ||
|
uploadedDate |
datetime2(0) |
yes | ||
|
approved |
bit |
no | ||
|
approvedByID |
int |
yes | ||
|
approvedDate |
datetime2(0) |
yes | ||
|
declined |
bit |
no | ||
|
declinedByID |
int |
yes | ||
|
declinedDate |
datetime2(0) |
yes | ||
|
declinedInstructions |
varchar(250) |
yes | ||
|
deleted |
bit |
no | ||
|
deletedByID |
int |
yes | ||
|
deletedDate |
datetime2(0) |
yes | ||
|
SIS-183950 |
ActivityUpload |
activityUploadID |
int |
no |
|
activityID |
int |
no | ||
|
documentName |
varchar(30) |
no | ||
|
code |
varchar(30) |
no | ||
|
required |
varchar(8) |
no | ||
|
uploadInstructions |
varchar(250) |
yes | ||
|
toolID |
int |
no | ||
|
SIS-185327 |
FormDocumentGroup |
groupID |
int |
no |
|
originalDocumentID |
int |
yes | ||
|
name |
varchar(800) |
yes | ||
|
formDocumentGroupGUID |
uniqueidentifier |
no | ||
|
SIS-185327 |
FormDocumentVersion |
versionID |
int |
no |
|
documentID |
int |
no | ||
|
version |
int |
no | ||
|
groupID |
int |
no | ||
|
formDocumentVersionGUID |
uniqueidentifier |
no | ||
|
activeVersion |
int |
no | ||
|
versionComments |
varchar(500) |
yes |
Modified Tables
Added Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-183950 |
Activity |
upload |
bit |
no |
|
SIS-183950 |
ActivitySectionRoster |
uploadsComplete |
bit |
no |
|
SIS-183950 |
ActivitySectionRosterPendingPayment |
uploadsComplete |
bit |
no |
|
SIS-187462 |
AtRisk |
proficientAtReadingCamp |
bit |
yes |
|
SIS-187462 |
AtRisk |
retainedNotReturning |
bit |
yes |
|
SIS-182549 |
EarlyEducationMN |
stateExclude |
bit |
no |
|
SIS-185327 |
FormDocument |
parentDocumentID |
int |
yes |
|
SIS-185327 |
FormElement |
oldDocDBLimit |
varchar(100) |
yes |
|
SIS-185327 |
FormElement |
oldAdhocName |
varchar(100) |
yes |
|
SIS-185327 |
FormElement |
newField |
bit |
no |
|
SIS-187710 |
LockdownUserLaunch |
returnPage |
varchar(1000) |
yes |
|
SIS-183813 |
OAuth2OutboundClient |
productName |
varchar(255) |
no |
|
SIS-185011 |
PreSchoolKY |
otherAssessmentInstrumentUsed |
varchar(50) |
yes |
|
SIS-182549 |
PreschoolScreener |
stateExclude |
bit |
no |
|
SIS-187064 |
RelatedPair |
legalDesignee |
bit |
no |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea10 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea11 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea12 |
varchar(8000) |
yes |
|
SIS-186411 |
SpecialEDState |
effectiveDate |
date |
yes |
|
SIS-186411 |
SpecialEDState |
disability6 |
varchar(15) |
yes |
|
SIS-186411 |
SpecialEDState |
physicalHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
recreationalHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
audiologicalHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
occupationalHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
speechHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
healthHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
psychologicalHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
orientationHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
counselingHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
socialWorkHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
transportation |
varchar(15) |
yes |
|
SIS-186411 |
SpecialEDState |
assistTech |
varchar(15) |
yes |
|
SIS-186411 |
SpecialEDState |
otherHours |
decimal(5,2) |
yes |
|
SIS-186411 |
SpecialEDState |
alternateAssessment |
bit |
no |
|
SIS-187728 |
Truancy |
preventionMeasureEffectiveDate |
date |
yes |
|
SIS-187728 |
Truancy |
complaintFiledEffectiveDate |
date |
yes |
|
SIS-187728 |
Truancy |
excessiveAbsenceEffectiveDate |
date |
yes |
Altered Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea1 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea2 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea3 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea4 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea5 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea6 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea7 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea8 |
varchar(8000) |
yes |
|
SIS-186411 |
SEPTestAccommodationsZZ |
subjectArea9 |
varchar(8000) |
yes |
|
SIS-183813 |
SIFRaceEthnicity |
code |
varchar(36) |
no |
|
SIS-183813 |
SIFSentRecord |
agentName |
varchar(75) |
yes |
|
SIS-183813 |
SIFSentRecord |
xmlForDelete |
varchar(max) |
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-177252 |
|
FRAM Income Guide 25-26 |
|
SIS-181853 |
TX |
Added Accelerated Education Plan to Programs |
|
SIS-183814 |
OK |
Updated StateGradeLevelDefinition |
|
SIS-183814 |
VA |
Converted client name to zone name |
|
SIS-183814 |
|
Updated DIS Quartz jobs for sif 3.0 |
|
SIS-183950 |
|
Activities Cloud File Location |
|
SIS-184331 |
IL |
Immunization Rule Update |
|
SIS-184913 |
WI |
Conversion of dualCredit fields for new code |
|
SIS-184989 |
HI |
lepAccommodation updates |
|
SIS-185327 |
|
Inserted form document versioning records |
|
SIS-186530 |
WY |
Immunization Rule Update |
|
SIS-186540 |
MO |
Added New Attending School The Pediatric Place |
|
SIS-186839 |
NC |
Populated stateIDs |
|
SIS-187150 |
TN |
Deleted old EdFiIdentityMapping records for SSAE |
|
SIS-187304 |
NC |
Removed Feature Toggle Preference for LCS Extract |
|
SIS-187380 |
|
Updated TranscriptCourse stateCodeName based on stateCode |
|
SIS-187435 |
NC |
Renamed one district |
|
SIS-187912 |
|
Populated legal names and gender from personal names and gender |
|
SIS-187934 |
VA |
New Work Based Learning Codes Convert Dual Enrollment Value |
|
SIS-187936 |
MO |
Immunization Rule Update |
|
SIS-187959 |
|
Populated termType field for intradistrict mappings |
|
SIS-188127 |
TN |
Immunization Rule Update |
|
SIS-188179 |
|
Vendor Status no longer nullable |
|
SIS-188312 |
NC |
Undid updates to enrollmentLocations |
