This article collects the changes made to the database schema as part of the Campus.2611 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 |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-188331 |
StateCreditGroupStructure |
stateCreditGroupStructureID |
int |
no |
|
stateCreditGroupStructureGUID |
uniqueidentifier |
no | ||
|
parentID |
int |
yes | ||
|
name |
nvarchar(2000) |
yes | ||
|
comments |
varchar(250) |
yes | ||
|
modifiedDate |
datetime2(0) |
yes | ||
|
modifiedByID |
int |
yes | ||
|
lastPublishedTimestamp |
datetime2(0) |
yes | ||
|
lastPublishedByID |
int |
yes | ||
|
SIS-188331 |
StateCreditGroupStructurePublishHistory |
stateCreditGroupStructurePublishHistoryID |
int |
no |
|
stateCreditGroupStructureID |
int |
no | ||
|
districtID |
int |
no | ||
|
stateCreditGroupStructureStatus |
int |
no | ||
|
stateCreditGroupStructureTimestamp |
datetime2(0) |
yes | ||
|
stateCreditGroupStructureGUID |
uniqueidentifier |
yes | ||
|
SIS-191522 |
CustomMigrantEligibility |
customID |
int |
no |
|
attributeID |
int |
no | ||
|
migrantEligibilityID |
int |
no | ||
|
value |
varchar(256) |
yes | ||
|
date |
date |
yes | ||
|
SIS-191522 |
MigrantEligibility |
migrantEligibilityID |
int |
no |
|
personID |
int |
no | ||
|
districtID |
int |
yes | ||
|
migrantEligibilityGUID |
uniqueidentifier |
no | ||
|
createdDate |
date |
no | ||
|
modifiedByID |
int |
yes | ||
|
modifiedDate |
date |
yes | ||
|
startDate |
date |
yes | ||
|
endDate |
date |
yes | ||
|
programStatus |
varchar(15) |
yes | ||
|
msixID |
varchar(12) |
yes | ||
|
qualifyingMoveDate |
varchar(255) |
yes | ||
|
fromCountry |
varchar(255) |
yes | ||
|
fromState |
varchar(50) |
yes | ||
|
toState |
varchar(50) |
yes | ||
|
fromCity |
varchar(255) |
yes | ||
|
toCity |
varchar(255) |
yes | ||
|
certificateOfEligibilityID |
varchar(30) |
yes | ||
|
certificateOfEligibilityStatus |
varchar(15) |
yes | ||
|
comments |
varchar(255) |
yes | ||
|
published |
bit |
no | ||
|
SIS-191523 |
CustomMigrantEnrollment |
customID |
int |
no |
|
attributeID |
int |
no | ||
|
migrantEnrollmentID |
int |
no | ||
|
value |
varchar(256) |
yes | ||
|
date |
date |
yes | ||
|
SIS-191523 |
MigrantEnrollment |
migrantEnrollmentID |
int |
no |
|
personID |
int |
no | ||
|
districtID |
int |
no | ||
|
migrantEnrollmentGUID |
uniqueidentifier |
no | ||
|
createdDate |
date |
no | ||
|
modifiedByID |
int |
yes | ||
|
modifiedDate |
date |
yes | ||
|
startDate |
date |
yes | ||
|
endDate |
date |
yes | ||
|
residencyDate |
date |
yes | ||
|
residencyVerificationDate |
date |
yes | ||
|
mepEnrollmentType |
varchar(25) |
yes | ||
|
mepProjectType |
varchar(25) |
yes | ||
|
withdrawalReason |
varchar(25) |
yes | ||
|
continuationOfServicesReason |
varchar(25) |
yes | ||
|
priorityForServicesIndicator |
bit |
no | ||
|
migrantEligibilityID |
int |
yes | ||
|
mepSchool |
varchar(10) |
yes | ||
|
mepProject |
varchar(25) |
yes | ||
|
comments |
varchar(255) |
yes | ||
|
SIS-195488 |
EdFiAudit |
auditID |
int |
no |
|
edFiConfigurationID |
int |
no | ||
|
edFiApplicationID |
int |
yes | ||
|
personID |
int |
yes | ||
|
auditTimestamp |
datetime2(2) |
no | ||
|
requestType |
varchar(25) |
no | ||
|
SIS-195488 |
EdFiAuditResource |
auditID |
int |
no |
|
edFiPreferenceID |
int |
no | ||
|
SIS-195488 |
EdFiAuditSchool |
auditID |
int |
no |
|
schoolID |
int |
no |
Modified Tables
Added Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-188331 |
CompoundRequirement |
stateCreditGroupStructureID |
int |
yes |
|
SIS-188331 |
CourseRequirement |
stateCreditGroupStructureID |
int |
yes |
|
SIS-188331 |
CourseRequirement |
evaluationStateCreditGroupStructureID |
int |
yes |
|
SIS-188331 |
CreditRequirement |
stateCreditGroupStructureID |
int |
yes |
|
SIS-194112 |
CTEStatusVA |
cteCreditAccommodation |
bit |
no |
|
SIS-188331 |
CurriculumStandard |
stateMappedCreditGroupStructureID |
int |
yes |
|
SIS-192178 |
EnrollmentHistory |
enrollmentHistoryGUID |
uniqueidentifier |
no |
|
SIS-195394 |
GraduationSeal |
graduationSealGUID |
uniqueidentifier |
no |
|
SIS-191524 |
MigrantService |
migrantEnrollmentID |
int |
yes |
|
SIS-188331 |
Program |
stateCreditGroupStructureID |
int |
yes |
|
SIS-194718 |
ProgramParticipation |
cteCreditAccommodationFlag |
varchar(15) |
yes |
|
SIS-191898 |
RecordsTransfer |
nasisXML |
varchar(max) |
yes |
|
SIS-191898 |
RecordsTransfer |
nasisFOP |
varchar(100) |
yes |
|
SIS-174362 |
Trial |
maxLoadAlternates |
tinyint |
yes |
Altered Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-185074 |
Calendar |
number |
varchar(4) |
yes |
|
SIS-196506 |
DigitalLearningVendorUpstreamAPIConfiguration |
clientKey |
varchar(2000) |
no |
|
SIS-197137 |
MessageEmailerJob |
messageID |
int |
yes |
|
SIS-197046 |
MessageRecipientDevice |
seq |
smallint |
yes |
|
SIS-197046 |
MessageRecipientDevicePreview |
seq |
smallint |
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-180134 |
VA |
Migrated roster.instructionalSetting to Section Student Detail Value |
|
SIS-188331 |
NV |
Moved credit groups into state structure |
|
SIS-191522 |
|
MigrantEligibility DIS object |
|
SIS-191523 |
|
MigrantEnrollment DIS object |
|
SIS-191935 |
|
Added ProgramOptOut to DCT |
|
SIS-192178 |
|
EnrollmentHistory DIS Object |
|
SIS-192180 |
ND |
Removed Early Learning from DIS list of object |
|
SIS-193571 |
|
Converted tribalEnrollment to tribalAffiliation |
|
SIS-193571 |
|
Converted tribalEnrollment to triablaAffiliation |
|
SIS-193571 |
|
Title 6 Data Conversion |
|
SIS-195394 |
|
Added graduationSealGUID to GraduationSeal table |
|
SIS-195498 |
|
Removed CertificateRenewJob |
|
SIS-195598 |
NH |
Immunization Rule Update |
|
SIS-195792 |
|
Created course management active school year change job |
|
SIS-195910 |
|
Assigned Owners to Campus Support and OLR Administrator User Groups |
|
SIS-195983 |
|
Removed IRC Conversion (INFINITECAMPUS) Program from all states but IA |
|
SIS-196034 |
TN |
Immunization Rule Update |
|
SIS-196419 |
|
Cleaned up null value and duplicate CustomCourse and CourseMasterAttribute records |
|
SIS-196454 |
MA |
Updated CourseMaster Level |
|
SIS-196565 |
ME |
Updated Language Codes to lowercase |
|
SIS-196591 |
NC |
Created specialCode default false value where not already true in CourseCodeFieldValue |
|
SIS-196694 |
|
Scheduled compass config to be reloaded if it was not already after start up |
|
SIS-196731 |
NM |
Updated languages to have leading zero |
|
SIS-197037 |
TX |
Converted Enrollment.endStatus code 99 |
