This article collects the changes made to the database schema as part of the Campus.2435 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-173649 |
PhoneEventStatus |
phoneEventStatusID |
int |
messageRecipientID |
int | ||
vendorAssignedID |
varchar(40) | ||
phoneNumber |
varchar(25) | ||
type |
varchar(10) | ||
timestamp |
datetime2(0) | ||
redialCount |
int | ||
status |
varchar(25) | ||
SIS-173971 |
DependentCareMember |
dependentCareMemberID |
int |
personID |
int | ||
DependentCareMemberSchedule |
dependentCareMemberScheduleID |
int | |
dependentCareSectionMemberID |
int | ||
monday |
bit | ||
tuesday |
bit | ||
wednesday |
bit | ||
thursday |
bit | ||
friday |
bit | ||
scheduleCode |
varchar(2) | ||
scheduleStartDate |
date | ||
scheduleEndDate |
date | ||
modifiedDateTime |
datetime2(0) | ||
DependentCareSectionMember |
dependentCareSectionMemberID |
int | |
personID |
int | ||
dependentCareApplicationID |
int | ||
dependentCareSessionSectionID |
int | ||
DependentCareSessionMember |
dependentCareSessionMemberID |
int | |
personID |
int | ||
dependentCareApplicationID |
int | ||
dependentCareSessionID |
int | ||
acceptedDateTime |
datetime2(0) | ||
startDate |
date | ||
endDate |
date | ||
DependentCareSetting |
dependentCareSettingID |
int | |
runInvoices |
varchar(10) | ||
invoiceDueBuffer |
int | ||
waitingPeriod |
int | ||
programInformation |
varchar(max) | ||
applyRegistrationCharge |
varchar(10) | ||
SIS-174522 |
CrossSiteConstraintSchoolAccept |
csConstraintSchoolAcceptID |
int |
schoolID |
int | ||
acceptFromSchoolID |
int | ||
acceptFromDistrictGUID |
uniqueidentifier | ||
CrossSiteConstraintSchoolOffer |
csConstraintSchoolOfferID |
int | |
schoolID |
int | ||
offerToSchoolID |
int | ||
offerToDistrictGUID |
uniqueidentifier | ||
maxSeatsPerSection |
int | ||
SIS-176505 |
ActivitySectionRosterTransferOption |
activitySectionRosterTransferOptionID |
int |
activitySectionRosterID |
int | ||
documentID |
int | ||
formID |
int | ||
ActivityTransfer |
activityTransferID |
int | |
transferAction |
varchar(12) | ||
transferAmount |
decimal(12,2) | ||
additionalAmount |
decimal(12,2) | ||
refundAmount |
decimal(12,2) | ||
comments |
varchar(500) | ||
personID |
int | ||
originActivitySectionID |
int | ||
originProductItemID |
int | ||
originReversalProductSaleID |
int | ||
destinationActivitySectionID |
int | ||
destinationProductItemID |
int | ||
destinationProductSaleID |
int | ||
transferProcessorPersonID |
int | ||
transferTimestamp |
datetime2(0) | ||
SIS-177034 |
CustomDistrictResidency |
customID |
int |
attributeID |
int | ||
districtResidencyID |
int | ||
value |
varchar(256) | ||
date |
date | ||
DistrictResidency |
districtResidencyID |
int | |
personID |
int | ||
districtID |
int | ||
districtResidencyGUID |
uniqueidentifier | ||
createdDate |
date | ||
modifiedByID |
int | ||
modifiedDate |
date | ||
residentDistrict |
varchar(15) | ||
servingDistrict |
varchar(15) | ||
startDate |
date | ||
endDate |
date | ||
comments |
varchar(255) | ||
SIS-179933 |
SSRSDistrictReportPublishHistory |
historyID |
int |
districtID |
int | ||
reportID |
int | ||
reportGUID |
uniqueidentifier | ||
reportStatus |
int | ||
reportTimestamp |
datetime2(0) | ||
SIS-180290 |
PaymentDispute |
disputeID |
int |
disputeRef |
varchar(32) | ||
paymentTransactionID |
int | ||
createdTimestamp |
datetime2(0) | ||
modifiedTimestamp |
datetime2(0) | ||
amount |
decimal(12,5) | ||
status |
varchar(17) | ||
SIS-180668 |
CustomEarlyEducationMN |
customID |
int |
attributeID |
int | ||
earlyEducationID |
int | ||
value |
varchar(256) | ||
date |
date | ||
SIS-180846 |
GiftedService |
giftedServiceID |
int |
giftedID |
int | ||
personID |
int | ||
districtID |
int | ||
giftedServiceGUID |
uniqueidentifier | ||
startDate |
date | ||
endDate |
date | ||
serviceType |
varchar(15) | ||
comments |
varchar(255) | ||
modifiedByID |
int | ||
modifiedDate |
date | ||
createdByID |
int | ||
createdDate |
date |
Modified Tables
Added
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-176505 |
ActivityClearedRoster |
activityTransferID |
int |
SIS-176505 |
ActivitySectionRoster |
activityTransferID |
int |
SIS-181355 |
BehaviorResponse |
trainedInTechnique |
bit |
SIS-177921 |
Course |
altInstruction |
varchar(15) |
SIS-177921 |
CourseCatalog |
lockAltInstruction |
bit |
SIS-177921 |
CourseMaster |
altInstruction |
varchar(15) |
SIS-179707 |
CourseRequirement |
pathwayLevel |
varchar(15) |
SIS-173971 |
DependentCareApplication |
modifiedBy |
int |
SIS-173971 |
DependentCareApplication |
modifiedTimeStamp |
datetime2(0) |
SIS-173971 |
DependentCareSessionCharge |
chargeType |
varchar(12) |
SIS-173971 |
DependentCareSessionProgram |
maximumStudents |
int |
SIS-178701 |
FinanceBankAccount |
lastFour |
CALCULATED |
SIS-179668 |
ImmCertificate |
guardianSignatureOnFile |
bit |
SIS-173649 |
MessengerRecordedSpeechFile |
cloudFileID |
int |
SIS-179957 |
Migrant |
multiLanguage |
varchar(15) |
SIS-179957 |
Migrant |
pkHours |
int |
SIS-178701 |
PaymentMethodReference |
fullName |
varchar(101) |
SIS-178701 |
PaymentTransactionProduct |
recipientName |
varchar(102) |
SIS-177034 |
RecordsTransfer |
districtResidencyXML |
varchar(max) |
SIS-177034 |
RecordsTransfer |
districtResidencyFOP |
varchar(100) |
SIS-181258 |
School |
schoolFocus |
varchar(15) |
SIS-180769 |
Section |
fractionYearOffered |
decimal(6,3) |
SIS-180769 |
Section |
exceptionSchoolEdFiID |
varchar(15) |
SIS-177921 |
Section |
altInstruction |
varchar(15) |
SIS-179885 |
SessionTracker |
hybridDeviceID |
int |
SIS-179933 |
SSRSConfiguration |
stateOwned |
bit |
SIS-179933 |
SSRSDistrictReport |
reportGUID |
uniqueidentifier |
SIS-179933 |
SSRSDistrictReport |
stateOwned |
bit |
SIS-179933 |
SSRSDistrictReport |
syncStatus |
varchar(1) |
SIS-177175 |
SSRSDistrictReport |
contextType |
varchar(30) |
SIS-177103 |
Truancy |
excessiveAbsence |
bit |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-181109 |
ConfigProfile |
value |
varchar(128) |
SIS-181304 |
DependentCareApplication |
submittedBy |
int |
SIS-180796 |
NCSnapshotGRSSummary |
endYear |
int |
SIS-180796 |
NCSnapshotPMRSummary |
endyear |
int |
SIS-18125 |
Section |
instructionalSetting |
varchar(15) |
SIS-180769 |
Section |
avgMinutesWeek |
decimal(6,3) |
SIS-180769 |
Section |
avgPassTimeMinutesWeek |
decimal(6,3) |
SIS-180805 |
SectionStaffHistory |
role |
varchar(15) |
Deprecated Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-180769 |
School |
exceptionSchoolEdFiID |
SIS-180143 |
Trial |
gridDisplay |
SIS-180143 |
Trial |
conflictTeacher |
SIS-180143 |
Trial |
conflictRoom |
SIS-180143 |
Trial |
conflictRoster |
SIS-180143 |
Trial |
conflictSingleton |
SIS-180143 |
Trial |
conflictStudentToStudent |
SIS-180143 |
Trial |
missingTeacher |
SIS-180143 |
Trial |
missingRoom |
SIS-180143 |
Trial |
missingGroup |
SIS-180143 |
Trial |
highlightSeats |
SIS-180143 |
Trial |
highlightFull |
SIS-180143 |
Trial |
highlightEmpty |
SIS-180143 |
Trial |
highlightSingleton |
SIS-180143 |
Trial |
highlightLocked |
SIS-180143 |
Trial |
yAxis |
SIS-180143 |
Trial |
periodDisplay |
SIS-180143 |
Trial |
orangeMultiple |
SIS-180143 |
Trial |
missingBuild |
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-173649 |
Created Preference Toggle for Messenger Cloud | |
SIS-173649 |
Added Messenger Preference for Cloud Dispatch | |
SIS-173649 |
Updated auditToolCode for Messenger CloudFileLocations | |
SIS-173649 |
Null empty message bodies | |
SIS-173971 |
Added Dependent Care Notification Type | |
SIS-174300 |
Updated historical EL records to be Exited EL | |
SIS-177034 |
Added DistrictResidency to Records Transfer | |
SIS-177034 |
Added DistrictResidency to DIS | |
SIS-177034 |
Added DistrictResidency to DCT | |
SIS-177103 |
Removed Learning Standards from resource preferences | |
SIS-177175 |
Added contextType to SSRSDistrictReport table | |
SIS-178156 |
Cleaned Up Start and End Dates on CSE rosters | |
SIS-178230 |
Enabled edfiShowPreference for DE State Edition | |
SIS-178600 |
NC |
Populated County Table |
SIS-178701 |
Migrated Payments Reporter Data For Denormalization v2 | |
SIS-178701 |
Migrated Payments Reporter Data For Denormalization | |
SIS-178701 |
Migrated Payments Reporter Data | |
SIS-179148 |
NC |
Academic Program Assessment Pre-Populating - Assign Assessments |
SIS-179148 |
NC |
Academic Program Assessment Pre-Populating - Assessment Population |
SIS-179148 |
NC |
Academic Program Assessment Pre-Populating - Graduation Program |
SIS-179148 |
NC |
Academic Program Assessment Pre-Populating - Academic Programs |
SIS-179442 |
NJ |
Added value to District |
SIS-179482 |
NY |
Immunization Rule Update |
SIS-179775 |
NC |
CTE Report Logic (2 of 2) update cte pathways |
SIS-179885 |
Added auto account link notification type | |
SIS-179885 |
Added hybridDeviceID to SessionTracker entity | |
SIS-179885 |
Added Account-Linking Preference | |
SIS-180013 |
Renamed data validation rule | |
SIS-180115 |
MN |
Immunization Rule Update |
SIS-180165 |
VT |
Converted staff assignment codes updated |
SIS-180165 |
VT |
Converted staff assignment codes |
SIS-180195 |
Fixed Ed-Fi trigger capitalization for TranscriptCourse unweightedGPAValue | |
SIS-180227 |
VT |
EdFi tool preference script |
SIS-180366 |
Updated State Race Ethnicity based on federal designation | |
SIS-180384 |
ID |
v15 ISEE Option Sets state changes for the 2425 school year - district updates |
SIS-180392 |
MN |
2024 MN Direct Admissions Survey Updates updated to not use redirect |
SIS-180392 |
MN |
2024 MN Direct Admissions Survey Updates |
SIS-180409 |
(OneOff) Add AltProgram to Data Change Tracker | |
SIS-180409 |
Added alternative education to records transfer | |
SIS-180444 |
WI |
Immunization Rule Update |
SIS-180615 |
AZ |
Immunization Rule Update |
SIS-180616 |
NC |
Auto-populated Verified Home Primary Language |
SIS-180717 |
MO |
Immunization Rule Update |
SIS-180740 |
Added Absence Request to locations via CloudFileLocation | |
SIS-180805 |
OK |
Updated Teacher Role Campus Attribute hide and required flags |
SIS-180937 |
Populated TranscriptCourse stateCodeName from CourseCode name | |
SIS-180967 |
NC |
Unlocked Attributes |
SIS-180977 |
TN |
Updated language codes |
SIS-181256 |
OK |
Course type and Section mediumOfInstruction conversions |
