This article collects the changes made to the database schema as part of the Campus.2527 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-177907 |
DependentCareCreditInvoice |
dependentCareCreditInvoiceID |
int |
no |
dependentCareInvoiceID |
int |
no | ||
dependentCareMemberCreditID |
int |
no | ||
SIS-177907 |
DependentCareInvoice |
dependentCareInvoiceID |
int |
no |
personID |
int |
no | ||
dependentCareInvoiceDateID |
int |
no | ||
totalAmount |
decimal(7,2) |
no | ||
rollForwardAmount |
decimal(7,2) |
no | ||
paidInFullDate |
datetime2(0) |
yes | ||
SIS-177907 |
DependentCareInvoiceDate |
dependentCareInvoiceDateID |
int |
no |
generationDate |
date |
no | ||
taxYear |
int |
no | ||
firstScheduleBillDate |
date |
no | ||
lastScheduleBillDate |
date |
no | ||
dueDate |
date |
no | ||
lastRun |
bit |
no | ||
billedOverdue |
bit |
no | ||
SIS-177907 |
DependentCareSessionChargeInvoice |
dependentCareSessionChargeInvoiceID |
int |
no |
dependentCareSessionInvoiceID |
int |
no | ||
dependentCareSessionMemberChargeID |
int |
no | ||
SIS-177907 |
DependentCareSessionDiscountInvoice |
dependentCareSessionDiscountInvoiceID |
int |
no |
dependentCareSessionInvoiceID |
int |
no | ||
dependentCareSessionMemberDiscountID |
int |
no | ||
amount |
decimal(7,2) |
no | ||
SIS-177907 |
DependentCareSessionDropInInvoice |
dependentCareSessionDropInInvoiceID |
int |
no |
dependentCareSessionInvoiceID |
int |
no | ||
dependentCareSectionAttendanceID |
int |
no | ||
amount |
decimal(7,2) |
no | ||
SIS-177907 |
DependentCareSessionInvoice |
dependentCareSessionInvoiceID |
int |
no |
dependentCareInvoiceID |
int |
no | ||
dependentCareSessionID |
int |
no | ||
SIS-177907 |
DependentCareSessionSectionInvoice |
dependentCareSessionSectionInvoiceID |
int |
no |
dependentCareSessionInvoiceID |
int |
no | ||
dependentCareSessionMemberScheduleID |
int |
no | ||
amount |
decimal(7,2) |
no | ||
SIS-183357 |
POSTransactionHistoryItemVoid |
itemVoidID |
int |
no |
transactionID |
int |
no | ||
reverseTransactionID |
int |
no | ||
accountID |
int |
no | ||
purchasableID |
int |
yes | ||
quantity |
int |
no | ||
amount |
decimal(10,2) |
yes | ||
debit |
bit |
no | ||
cash |
bit |
no | ||
SIS-183357 |
POSTransactionItemVoid |
itemVoidID |
int |
no |
transactionID |
int |
no | ||
reverseTransactionID |
int |
no | ||
accountID |
int |
no | ||
purchasableID |
int |
yes | ||
quantity |
int |
no | ||
amount |
decimal(10,2) |
yes | ||
debit |
bit |
no | ||
cash |
bit |
no | ||
SIS-185609 |
DataCertificationDistrictAssignment |
dataCertificationDistrictAssignmentID |
int |
no |
dataCertificationObjectID |
int |
no | ||
districtID |
int |
no | ||
certificationStatus |
varchar(15) |
yes | ||
currentSnapshotID |
int |
yes | ||
snapshotExists |
bit |
no | ||
startDateOverride |
date |
yes | ||
endDateOverride |
date |
yes | ||
effectiveDateOverride |
date |
yes | ||
modifiedById |
int |
yes | ||
modifiedTimestamp |
datetime2(0) |
yes | ||
SIS-185609 |
DataCertificationSchoolAssignment |
dataCertificationSchoolAssignmentID |
int |
no |
dataCertificationDistrictAssignmentID |
int |
no | ||
schoolID |
int |
no | ||
SIS-188452 |
AltProgramValue |
altProgramValueID |
int |
no |
altProgramID |
int |
no | ||
attributeID |
int |
no | ||
value |
varchar(256) |
yes | ||
SIS-189081 |
SAMLLogs |
logID |
int |
no |
logChainGUID |
uniqueidentifier |
no | ||
attribute |
varchar(100) |
yes | ||
username |
varchar(100) |
yes | ||
message |
varchar(500) |
yes | ||
samlConfigurationID |
int |
yes | ||
messageLevel |
varchar(10) |
yes | ||
timestamp |
datetime2(2) |
no | ||
SIS-189382 |
CustomAttendanceRecovery |
customID |
int |
no |
attributeID |
int |
no | ||
attendanceRecoveryID |
int |
no | ||
value |
varchar(256) |
yes | ||
date |
date |
yes |
Deprecated Tables
Case Number |
Table |
|---|---|
SIS-185609 |
DataCertificationObjectAdmin |
SIS-185609 |
DataCertificationObjectType |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-185609 |
DataCertificationObject |
dataCertificationTypeID |
int |
no |
SIS-185609 |
DataCertificationObject |
snapshotStrategy |
varchar(15) |
no |
SIS-185609 |
DataCertificationObject |
snapshotLevel |
varchar(15) |
no |
SIS-185609 |
DataCertificationObjectMember |
districtComment |
varchar(400) |
yes |
SIS-185609 |
DataCertificationSnapshotDetail |
schoolID |
int |
yes |
SIS-177907 |
DependentCareMemberCredit |
lock |
bit |
no |
SIS-177907 |
DependentCareSectionAttendance |
isDropIn |
bit |
no |
SIS-177907 |
DependentCareSessionMemberCharge |
lock |
bit |
no |
SIS-177907 |
DependentCareSetting |
programName |
varchar(50) |
no |
SIS-177907 |
DependentCareSetting |
address |
varchar(200) |
no |
SIS-177907 |
DependentCareSetting |
city |
varchar(50) |
no |
SIS-177907 |
DependentCareSetting |
state |
varchar(2) |
no |
SIS-177907 |
DependentCareSetting |
zip |
varchar(9) |
no |
SIS-177907 |
DependentCareSetting |
invoiceInformation |
varchar(1000) |
yes |
SIS-186550 |
DISZone |
excludePrivateEmail |
bit |
no |
SIS-189040 |
EarlyInterventions |
contactPhoneNumber |
varchar(25) |
yes |
SIS-189040 |
EarlyInterventions |
contactEmail |
varchar(150) |
yes |
SIS-189040 |
EarlyInterventions |
contactName |
varchar(100) |
yes |
SIS-188857 |
IMResponseItemScore |
manuallyScored |
bit |
no |
SIS-189379 |
InstructionMode |
educationProvider |
varchar(15) |
yes |
SIS-189441 |
LepService |
evidenceReview |
bit |
no |
SIS-188928 |
PlanServiceProvided |
instructionType |
varchar(15) |
yes |
SIS-189069 |
Program |
intendedDiplomaType |
varchar(15) |
yes |
SIS-189069 |
ProgramParticipation |
primary |
bit |
no |
SIS-189382 |
RecordsTransfer |
attendanceRecoveryXML |
varchar(max) |
yes |
RecordsTransfer |
attendanceRecoveryFOP |
varchar(100) |
yes | |
SIS-189382 |
RecordsTransfer |
attendanceRecoveryServiceXML |
varchar(max) |
yes |
RecordsTransfer |
attendanceRecoveryServiceFOP |
varchar(100) |
yes | |
SIS-188928 |
SEPTransferRights |
expirationDate |
date |
yes |
SIS-188397 |
SpecialEDState |
asdSeverityBehaviors |
varchar(15) |
yes |
SIS-188397 |
SpecialEDState |
asdSeverityCommunication |
varchar(15) |
yes |
SIS-189239 |
TransportationRoute |
importedID |
varchar(50) |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-189382 |
AttendanceRecoveryService |
schoolNumber |
varchar(12) |
yes |
SIS-177907 |
DependentCareSessionMemberCharge |
modifiedBy |
int |
yes |
SIS-183327 |
Migrant |
fromCity |
varchar(100) |
yes |
SIS-183327 |
Migrant |
toCity |
varchar(100) |
yes |
SIS-183327 |
Migrant |
immunizationRecord |
varchar(15) |
yes |
SIS-183327 |
Migrant |
outOfStateTranscript |
varchar(15) |
yes |
SIS-183327 |
Migrant |
alg1OrEquivalent |
varchar(15) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
physicalHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
recreationalHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
audiologicalHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
occupationalHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
speechHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
healthHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
psychologicalHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
orientationHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
counselingHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
socialWorkHours |
decimal(7,3) |
yes |
SIS-188397, SIS-189783 |
SpecialEDState |
otherHours |
decimal(7,3) |
yes |
SIS-188452 |
AltProgram |
programMeetingTime |
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-133027 |
IL |
Added Beach Park to District table |
SIS-133027 |
IL |
Updated District List |
SIS-167618 |
Removed user tool option and system preference for new look | |
SIS-177907 |
Removed Dependent Care toggle | |
SIS-177907 |
Quartz Job | |
SIS-183327 |
NM |
Migrant Conversions |
SIS-183630 |
KY |
Set live vaccines |
SIS-183630 |
KY |
Immunization Rule Update |
SIS-183630 |
KY |
Overnight Immunization Job |
SIS-184734 |
Removed RRS preferences | |
SIS-184734 |
Removed RefreshRRSPreferencesJob | |
SIS-185121 |
SD |
Sped Data Conversion |
SIS-185581 |
SD |
Created feature toggle for Dakota Writing and NCLB reports |
SIS-185609 |
Data certification data updates | |
SIS-186445 |
TN |
Added CampusAttributes and convert Roster localized field data to SecStudDetVal table |
SIS-186445 |
TN |
Converted Roster localized field data to SecStudDetVal table |
SIS-186550 |
Added field to DISZone | |
SIS-186623 |
DE |
Ed-Fi remove studentEducationOrganizationResponsibilityAssociations resource |
SIS-186628 |
DE |
Ed-Fi update descriptor |
SIS-186631 |
DE |
Ed-Fi dictionary updates 2nd try |
SIS-186631 |
DE |
Ed-Fi dictionary updates |
SIS-187017 |
OH |
Immunization Rule Update |
SIS-187230 |
NM |
Removed old object keys from SSFSPA |
SIS-187619 |
NC |
Updated EL Accommodation types |
SIS-187817 |
MT |
Immunization Rule Update |
SIS-187931 |
MD |
Immunization Rule Update |
SIS-187932 |
Updated teachingMethod dictionary for Course and Section correction | |
SIS-187932 |
Updated teachingMethod dictionary for Course and Section | |
SIS-187950 |
NC |
Uppdated dictionary |
SIS-187956 |
SD |
Immunization Rule Update |
SIS-187958 |
NC |
Updated virtualInstruction dictionary for Course and Section correction |
SIS-187958 |
NC |
Updated virtualInstruction dictionary for Course and Section |
SIS-188354 |
MN |
Resident district updates |
SIS-188452 |
Migrated tool rights from altProgram to the new tool | |
SIS-188452 |
IN |
Moved AltProgram programMeetingTime to new table |
SIS-188685 |
NC |
PSU Schools Missing in North Carolina State Edition Site |
SIS-188827 |
MO |
Updated scedCourseId and scedSubjectArea |
SIS-188913 |
CDR AutoMigrate | |
SIS-188995 |
DE |
Ed-Fi dictionary updates |
SIS-189069 |
IN |
Changed default value for AcademicProgram programType and programCategory to DiplomaIntent |
SIS-189081 |
Added SAMLLogs Cleanup Quartz Job | |
SIS-189187 |
ND |
Immunization Rule Update 2 |
SIS-189187 |
ND |
Added to overnight job |
SIS-189187 |
ND |
Immunization Rule Update |
SIS-189249 |
TN |
Deleted EdFiIdentityMapping records with obsolete objectKeys |
SIS-189283 |
OneRoster Automatic Refresh Job | |
SIS-189635 |
NC |
Updated CTE ProgramParticipation |
SIS-189776 |
Added Quartz Job for compass |
