This article collects the changes made to the database schema as part of the Campus.2315 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
We've made some changes!
Thanks for your feedback via our recent survey. We're continuing to make updates to how we provide this information; here are the changes we've made this time:
- Added the column names and data types included in each new table.
- Restored the Data Type information for new columns.
- Removed the Description for new and modified columns to simplify and reduce confusion.
Please use the comments field at the end of this article if you have feedback. Thanks!
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-166383 | CareerReadiness | careerReadinessID | int |
personID | int | ||
districtID | int | ||
careerReadinessGUID | uniqueidentifier | ||
modifiedByID | int | ||
modifiedDate | date | ||
startDate | date | ||
endDate | date | ||
year | smallint | ||
type | varchar(25) | ||
hours | int | ||
courseName | varchar(100) | ||
stateCode | varchar(104) | ||
courseNumber | varchar(13) | ||
sectionNumber | smallint | ||
careerCluster | varchar(15) | ||
employer | varchar(150) | ||
supervisor | varchar(150) | ||
phone | varchar(25) | ||
varchar(150) | |||
position | varchar(150) | ||
comments | varchar(500) | ||
passStatus | bit | ||
| SIS-166383 | CustomCareerReadiness | customID | int |
attributeID | int | ||
careerReadinessID | int | ||
value | varchar(256) | ||
date | date | ||
| SIS-160174 | CustomOnTrack | customID | int |
attributeID | int | ||
onTrackID | int | ||
value | varchar(256) | ||
date | date | ||
| SIS-166084 | EnrollmentOR | enrollmentID | int |
calendarID | int | ||
personID | int | ||
tuitionPaid | varchar(2) | ||
FTE | varchar(2) | ||
foreignStudent | bit | ||
withdrawFactor | int | ||
residentCounty | varchar(15) | ||
distanceLearning | bit | ||
programType | varchar(2) | ||
SIS-160174 | OnTrack | onTrackID | int |
personID | int | ||
modifiedByID | int | ||
modifiedDateTime | datetime2(0) | ||
onTrackGUID | uniqueidentifier | ||
districtID | int | ||
creationDateTime | datetime2(0) | ||
startDate | date | ||
endDate | date | ||
icap | bit | ||
review9th | bit | ||
review10th | bit | ||
review11th | bit | ||
review12th | bit | ||
graduate | bit | ||
creditsEarn | decimal(6,2) | ||
SIS-152749 | TrialUserViewSettings | trialUserViewSettingsID | int |
trialID | int | ||
userID | int | ||
periodsOnYAxis | bit | ||
coursesOnYAxis | bit | ||
conflictTeacher | bit | ||
conflictRoom | bit | ||
conflictRoster | bit | ||
conflictSingleton | bit | ||
conflictStudentToStudent | bit | ||
gridDisplay | tinyint | ||
highlightSeats | bit | ||
highlightFull | bit | ||
highlightEmpty | bit | ||
highlightSingleton | bit | ||
highlightLocked | bit | ||
missingTeacher | bit | ||
missingRoom | bit | ||
missingGroup | bit | ||
missingBuild | bit | ||
orangeMultiple | bit | ||
hiddenCourses | varchar(160) | ||
hiddenDepartments | varchar(90) | ||
hiddenTerms | varchar(217) | ||
hiddenPeriodSchedules | varchar(210) | ||
hiddenPeriods | varchar(360) | ||
collapsedDepartments | varchar(90) | ||
showLockedBuild | bit | ||
showLockedRosters | bit |
Modified Tables
Added
Case Number | Table | Column | Data Type |
|---|---|---|---|
| SIS-157065 | ActivityProposalProduct | futureEnrollmentDays | bit |
SIS-157065 | ActivityProposalProduct | includeFutureEnrollments | smallint |
SIS-152637 | CourseCatalog | lockCompositeWeights | bit |
SIS-152637 | GradingTaskCalculation | districtSourcedWeight | bit |
SIS-152637 | GradingTaskCalculationCourse | masterManagedWeight | bit |
SIS-152637 | GradingTaskCalculationCourse | trackMasterWeight | bit |
SIS-157065 | Product | futureEnrollmentDays | bit |
SIS-157065 | Product | includeFutureEnrollments | bit |
SIS-152749 | Trial | studentRequestsStatistic | varchar(24) |
SIS-152749 | Trial | requestsStatistic | varchar(22) |
Altered
Case Number | Table | Column | Data Type |
|---|---|---|---|
| SIS-166383 | CampusDictionary | standardCode | varchar(25) |
SIS-152749 | SectionStaffHistory | sectionStaffID | int |
| SIS-124483 | TranscriptCourse | teacherNumber | varchar(10) |
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-152749 | Cleaned up parentIDs for orphaned trials | |
SIS-152749 | Added Job for Save Trial process | |
SIS-152637 | DISCON Course Push Quartz Job to Batch Queue | |
SIS-152637 | Set up lockCompositeWeights value | |
SIS-153890 | FramIncomeGuide2023-2024 | |
SIS-153999 | Removed StudentPicture from DIS Access | |
SIS-166233 | All Districts must have a state | |
SIS-166534 | Gave permission tool right to users with eligibility tool right | |
SIS-167266 | NY | Added StateGradeLevelDefinition Unknown |
SIS-167779 | Fixed Convert SLD Checkbox Data | |
SIS-167779 | Converted SLD Checkbox Data | |
SIS-168092 | Removed duplicate composites | |
SIS-168350 | Cleaned up SectionStaffHistory staffType |
