This article collects the changes made to the database schema as part of the Campus.2511 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-171039 |
POSPurchasablePriceHistory |
priceID |
int |
no |
purchasableID |
int |
no | ||
startTimeStamp |
datetime2(0) |
no | ||
regularPrice |
decimal(5,2) |
yes | ||
fundedPrice |
decimal(5,2) |
yes | ||
reducedPrice |
decimal(5,2) |
yes | ||
freeOption |
bit |
no | ||
hasTxn |
bit |
no | ||
SIS-182402 |
PaymentsCart |
paymentsCartID |
int |
no |
ownerUserID |
int |
yes | ||
adminUserID |
int |
yes | ||
paymentDeviceID |
int |
yes | ||
lastUpdated |
datetime |
no | ||
paymentTransactionID |
int |
yes | ||
varchar(100) |
yes | |||
paymentSource |
varchar(40) |
yes | ||
SIS-182402 |
PaymentsCartItem |
paymentsCartItemID |
int |
no |
productID |
int |
no | ||
productType |
varchar(100) |
no | ||
paymentsCartID |
int |
no | ||
amount |
decimal(19,4) |
no | ||
quantity |
int |
no | ||
personID |
int |
yes | ||
productSaleID |
int |
yes | ||
schoolID |
int |
yes | ||
override |
bit |
yes | ||
SIS-182840 |
OneRosterDynamicSeqCriteria |
critID |
int |
no |
description |
varchar(100) |
no | ||
parentCritID |
int |
yes | ||
isTemplate |
bit |
no | ||
isEnabled |
bit |
no | ||
isDataGenerated |
bit |
no | ||
isGeneratingData |
bit |
no | ||
lastGeneratedDate |
datetime2(3) |
yes | ||
lastUsedDate |
datetime2(0) |
yes | ||
objectType |
varchar(20) |
no | ||
orVersion |
varchar(5) |
no | ||
isBySchool |
bit |
no | ||
schoolScopeHashCode |
varchar(15) |
yes | ||
createdDate |
datetime2(0) |
no | ||
crit1Field |
varchar(20) |
yes | ||
crit1Operator |
varchar(2) |
yes | ||
crit1Value |
varchar(50) |
yes | ||
crit2LogicalOperator |
varchar(3) |
yes | ||
crit2Field |
varchar(20) |
yes | ||
crit2Operator |
varchar(2) |
yes | ||
crit2Value |
varchar(50) |
yes | ||
crit3LogicalOperator |
varchar(3) |
yes | ||
crit3Field |
varchar(20) |
yes | ||
crit3Operator |
varchar(2) |
yes | ||
crit3Value |
varchar(50) |
yes | ||
SIS-182840 |
OneRosterDynamicSeqUser |
critID |
int |
no |
seq |
int |
no | ||
personID |
int |
no | ||
prefix |
char(1) |
yes | ||
isStudent |
bit |
no | ||
isRelated |
bit |
no | ||
isTeacher |
bit |
no | ||
isAide |
bit |
no | ||
isAdmin |
bit |
no | ||
SIS-183893 |
CFItemSubject |
cfSubjectID |
int |
no |
cfItemID |
int |
no | ||
SIS-186566 |
MessengerImageFile |
fileID |
int |
no |
userID |
int |
no | ||
lastAccessedTimestamp |
datetime2(0) |
no | ||
hidden |
bit |
no | ||
SIS-186566 |
MessengerTemplateImage |
templateID |
int |
no |
fileID |
int |
no |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-185554 |
AltProgram |
entryReason |
varchar(15) |
yes |
SIS-186531 |
AtRisk |
alternativeAssessment |
varchar(15) |
yes |
SIS-183893 |
CFAssociation |
notes |
varchar(max) |
yes |
SIS-183893 |
CFAssociation |
originTargetType |
varchar(50) |
yes |
SIS-183893 |
CFAssociation |
destinationTargetType |
varchar(50) |
yes |
SIS-183893 |
CFDocument |
cfLicenseID |
int |
yes |
SIS-183893 |
CFDocument |
frameworkType |
varchar(100) |
yes |
SIS-183893 |
CFDocument |
caseVersion |
varchar(5) |
yes |
SIS-183893 |
CFItem |
cfLicenseID |
int |
yes |
SIS-183893 |
CFLink |
targetType |
varchar(50) |
yes |
SIS-185614 |
DCTExcludeColumn |
excludeTriggering |
bit |
no |
SIS-185614 |
DCTExcludeColumn |
excludeLogging |
bit |
no |
SIS-182840 |
DigitalLearningVendorOAuth2ClientCredentials |
schoolScopeHashCode |
varchar(15) |
yes |
SIS-185298 |
DistrictResidency |
reportingSchool |
varchar(15) |
yes |
SIS-182402 |
MobilePaymentsDevice |
inOfficePaymentMode |
bit |
no |
SIS-182402 |
MobilePaymentsDevice |
eventMode |
bit |
no |
SIS-182402 |
PaymentDepositAccount |
paymentVendorAccountID |
int |
yes |
SIS-182402 |
PaymentFundAccount |
financeBankAccountID |
int |
no |
SIS-182402 |
PaymentMethodReference |
vendorStatus |
varchar(16) |
yes |
SIS-182402 |
PaymentUserAccount |
paymentVendorAccountID |
int |
yes |
SIS-182402 |
PaymentVendorAccount |
migrationPending |
bit |
no |
SIS-171042 |
POSAccountAccess |
alaCarteLimit |
decimal(10,2) |
yes |
SIS-185380 |
SecurityAccess |
authenticationType |
varchar(10) |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-183893 |
CFDocument |
language |
varchar(30) |
yes |
SIS-183893 |
CFItem |
language |
varchar(30) |
yes |
SIS-183893 |
CFLicense |
licenseText |
varchar(8000) |
yes |
SIS-184650 |
EnrollmentEndStatusType |
stateCode |
varchar(5) |
yes |
SIS-184650 |
EnrollmentStartStatusType |
stateCode |
varchar(5) |
yes |
SIS-185145 |
Message |
createdTime |
datetime2(0) |
yes |
SIS-185145 |
Message |
sentTime |
datetime2(0) |
yes |
SIS-185145 |
Message |
attendanceEffectiveDate |
datetime2(0) |
yes |
SIS-185145 |
Message |
dialStartTime |
datetime2(0) |
yes |
SIS-185145 |
Message |
dialEndTime |
datetime2(0) |
yes |
SIS-185145 |
Message |
createdTimeStamp |
datetime2(0) |
no |
SIS-185145 |
Message |
deliveryTimeStamp |
datetime2(0) |
yes |
SIS-185145 |
Message |
effectiveDate |
datetime2(0) |
yes |
SIS-185145 |
MessagePreview |
attendanceEffectiveDate |
datetime2(0) |
yes |
SIS-185145 |
MessagePreview |
dialStartTime |
datetime2(0) |
yes |
SIS-185145 |
MessagePreview |
dialEndTime |
datetime2(0) |
yes |
SIS-185145 |
MessagePreview |
deliveryTimeStamp |
datetime2(0) |
yes |
SIS-185145 |
MessagePreview |
effectiveDate |
datetime2(0) |
yes |
SIS-182402 |
PaymentFundAccount |
paymentDepositAccountID |
int |
yes |
SIS-182402 |
PaymentMethodReference |
paymentMethodRef |
varchar(36) |
yes |
SIS-182402 |
PaymentMethodReference |
accountType |
varchar(30) |
yes |
SIS-182402 |
PaymentMethodReference |
accountNumber |
varchar(30) |
yes |
SIS-182402 |
PaymentUserAccount |
customerRef |
varchar(32) |
yes |
SIS-171042 |
POSAccountAccess |
blockAlaCarte |
tinyint |
no |
Deprecated Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-182798 |
FreeReducedVerificationStatus |
processDate |
SIS-182402 |
PaymentFundAccount |
paymentDepositAccountID |
SIS-182402 |
PaymentUserAccount |
customerID |
SIS-182402 |
PaymentUserAccount |
paymentClientAccountID |
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-171039 |
Initialized POSPurchasablePriceHistory Table | |
SIS-171039 |
Created POSEffectiveDatePrice table | |
SIS-171042 |
Added alaCarteLimit column to POSAccountAccess | |
SIS-174139 |
CA |
SINF0453 Data Validation Using Outdated Logic |
SIS-182402 |
Converted Fund Account Links | |
SIS-182402 |
Assigned missing payrix transaction vendor IDs | |
SIS-182402 |
Nonprod and Dev Vendors | |
SIS-182402 |
Vendor Event Cloud Registration Job | |
SIS-182402 |
Device Mode Default | |
SIS-182402 |
Temporary Bank Conversion Job | |
SIS-182840 |
OR |
Dynamic Index Criteria Templates |
SIS-184562 |
Added Section Feed Notifications | |
SIS-184615 |
FERPA program record cleanup | |
SIS-184650 |
OK |
EndStatus Conversion |
SIS-185106 |
Exec ActiveTrialTriggerGenerate to remove DIS code | |
SIS-185106 |
Removed SchoolMonth from DISDataObject for some states | |
SIS-185106 |
Removed view from AuditTable | |
SIS-185216 |
KY |
Disabled school exclude |
SIS-185320 |
KY |
Disabled DIS on ESSKY |
SIS-185339 |
Added giftedService to dis | |
SIS-185359 |
Populated legal names and gender from personal names and gender | |
SIS-185554 |
NC |
ALPSS to altProgram data conversion |
SIS-185554 |
NC |
Converted ALPSS to AltProgram records |
SIS-185614 |
Added password to DCTExcludeColumn | |
SIS-186457 |
Relocked support accounts | |
SIS-186478 |
Restored Character Labs Thriving Index Survey Default | |
SIS-186478 |
Removed Survey Migration Job | |
SIS-186500 |
NC |
Added FosterCare to DISDataObject |
SIS-186562 |
Converted Indian (0690) to North American Indian languages (1025) | |
SIS-186659 |
NC |
Removed SSN from identity |
SIS-186691 |
WY |
Percent Hathaway Course Requirement Follow Up Script |
SIS-186747 |
Created SSEPA resync in Task Scheduler | |
SIS-186945 |
Disabled district import preference by default | |
SIS-186991 |
NC |
Cleaning up Gifted Records |
