This article collects the changes made to the database schema as part of the Campus.2431 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-176493 |
CDESPublishLog |
cdesPublishLogID |
int |
cdesKey |
uniqueidentifier | ||
publishType |
varchar(255) | ||
publishTimestamp |
datetime2(2) | ||
lastUpdateTimestamp |
datetime2(2) | ||
deleteTimestamp |
datetime2(2) | ||
SIS-178541 |
NCSnapshotGRSSummary |
ncSnapshotGRSSummaryID |
int |
ncSnapshotGRSSummaryGUID |
uniqueidentifier | ||
districtID |
int | ||
psu |
varchar(50) | ||
schoolID |
int | ||
schoolNumber |
varchar(50) | ||
schoolName |
varchar(50) | ||
endYear |
int | ||
schoolMonth |
int | ||
rerun |
bit | ||
americanIndianM |
int | ||
americanIndianF |
int | ||
asianM |
int | ||
asianF |
int | ||
hispanicM |
int | ||
hispanicF |
int | ||
blackM |
int | ||
blackF |
int | ||
pacificIslanderM |
int | ||
pacificIslanderF |
int | ||
whiteM |
int | ||
whiteF |
int | ||
twoOrMoreRacesM |
int | ||
twoOrMoreRacesF |
int | ||
summaryM |
int | ||
summaryF |
int | ||
total |
int | ||
SIS-179036 |
NCSnapshotPMRDetail |
ncSnapshotPMRDetailID |
int |
ncSnapshotPMRSummaryID |
int | ||
personID |
int | ||
enrollmentID |
int | ||
schoolMonth |
int | ||
schoolMonthStartDate |
datetime2(0) | ||
schoolMonthEndDate |
datetime2(0) | ||
psu |
varchar(12) | ||
schoolName |
varchar(50) | ||
schoolNumber |
varchar(50) | ||
race |
varchar(50) | ||
sex |
char(1) | ||
lastname |
varchar(50) | ||
firstname |
varchar(50) | ||
stateID |
varchar(15) | ||
summaryGroup |
varchar(50) | ||
stateGrade |
varchar(15) | ||
admissionStatus |
varchar(15) | ||
startStatus |
varchar(15) | ||
endStatus |
varchar(15) | ||
startDate |
datetime2(0) | ||
transferDaysOverride |
int | ||
effectiveStartDate |
date | ||
endDate |
datetime2(0) | ||
primaryEnrollment |
char(1) | ||
e1 |
int | ||
e2 |
int | ||
r1 |
int | ||
r2 |
int | ||
r3 |
int | ||
startStatusTotal |
int | ||
w1 |
int | ||
w2 |
int | ||
w3 |
int | ||
w4 |
int | ||
w2T |
int | ||
endStatusTotal |
int | ||
memLastDayNVIO |
int | ||
memLastDayVIO |
int | ||
memDaysNVIO |
int | ||
memDaysVIO |
int | ||
instructionalDays |
int | ||
daysPresent |
int | ||
daysAbsentNon |
int | ||
daysAbsent |
int | ||
daysAbsent1R |
int | ||
adm |
decimal(10,3) | ||
ada |
decimal(10,3) | ||
presentOnSite |
decimal(5,2) | ||
presentOffSite |
decimal(5,2) | ||
calendarInstMins |
int | ||
SIS-179036 |
NCSnapshotPMRSummary |
ncSnapshotPMRSummaryID |
int |
ncSnapshotPMRSummaryGUID |
uniqueidentifier | ||
verified |
bit | ||
reviewed |
bit | ||
rerun |
bit | ||
createdByID |
int | ||
createdTimestamp |
datetime2(0) | ||
verifiedByID |
int | ||
verifiedTimestamp |
datetime2(0) | ||
districtID |
int | ||
schoolID |
int | ||
endyear |
int | ||
schoolMonth |
int | ||
psu |
varchar(50) | ||
summaryGroup |
varchar(50) | ||
grade |
varchar(15) | ||
e1 |
int | ||
e2 |
int | ||
r1 |
int | ||
r2 |
int | ||
r3 |
int | ||
total |
int | ||
w1 |
int | ||
w2 |
int | ||
w3 |
int | ||
w4 |
int | ||
w2t |
int | ||
memLastDayNVIO |
int | ||
memLastDayVIO |
int | ||
memDaysNVIO |
int | ||
memDaysVIO |
int | ||
daysPresent |
int | ||
daysAbsentNon |
int | ||
daysAbsent |
int | ||
daysAbsent1R |
int | ||
adm |
decimal(10,3) | ||
ada |
decimal(10,3) | ||
presentOnSite |
decimal(5,2) | ||
presentOffSite |
decimal(5,2) |
Modified Tables
Added
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-176493 |
CrossSiteScoreGroupMap |
crossDistrictScoreGroupVersion |
varchar(200) |
SIS-177299 |
EnrollmentGA |
prior10DaysCalc |
smallint |
SIS-176493 |
GradingScore |
acceptCSEScores |
bit |
SIS-179996 |
Graduation |
associateDegreeType |
varchar(20) |
SIS-179948 |
Graduation |
financialAid |
varchar(15) |
SIS-178239 |
PendingHomeCrossDistrictRoster |
modifiedByID |
int |
SIS-177918 |
PlanGoalPLAAFP |
presentLevelDate |
datetime2(0) |
SIS-177918 |
PlanGoalPLAAFP |
years |
int |
SIS-177918 |
PlanGoalPLAAFP |
months |
int |
SIS-176493 |
ScoreGroup |
crossDistrictScoreGroupVersion |
varchar(200) |
SIS-178727 |
SEEGenericSubForm |
subFormType |
varchar(50) |
SIS-178727 |
SEEGenericSubForm |
recordDate2 |
date |
SIS-178727 |
SEEGenericSubForm |
intVal1 |
int |
SIS-178727 |
SEEGenericSubForm |
intVal2 |
int |
SIS-177918 |
SEPSpecialFactors |
languageNeeds |
varchar(250) |
SIS-177918 |
SEPTeamMeetingAttendanceAlt |
varChar3 |
varchar(8000) |
SIS-177918 |
SEPTestAccommodationList |
accommodationsMSStr |
varchar(8000) |
SIS-177918 |
SEPTestAccommodationList |
altAccommodationsMSStr |
varchar(8000) |
SIS-179534 |
TranscriptCourse |
stateCodeName |
varchar(200) |
SIS-179915 |
VaccineShot |
imported |
tinyint |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-178745 |
BehaviorEvent |
reporterType |
varchar(5) |
SIS-178745 |
BehaviorRole |
relationshipToSchool |
varchar(15) |
SIS-176493 |
CrossSiteCourseGradingTaskMap |
modifiedByID |
int |
SIS-176493 |
CrossSiteScoreGroupMap |
modifiedByID |
int |
SIS-176493 |
CrossSiteScoreListItemMap |
modifiedByID |
int |
SIS-179598 |
EarlyEducationMN |
membershipHours |
decimal(8,3) |
SIS-179598 |
EarlyEducationMN |
attendanceHours |
decimal(8,3) |
SIS-178472 |
Enrollment |
endAction |
varchar(15) |
SIS-178472 |
EnrollmentHistory |
endAction |
varchar(15) |
SIS-180333 |
Meeting |
residentSchool |
varchar(15) |
SIS-180333 |
Meeting |
servingSchool |
varchar(15) |
SIS-180333 |
Meeting |
residentDistrict |
varchar(15) |
SIS-180333 |
Meeting |
servingDistrict |
varchar(15) |
SIS-177918 |
PlanGoalPLAAFP |
otherVal1 |
varchar(8000) |
SIS-177918 |
PlanServiceProvided |
paymentSource2 |
varchar(150) |
SIS-177918 |
PlanServiceProvided |
paymentSource3 |
varchar(150) |
SIS-177918 |
PlanServiceProvided |
model |
varchar(150) |
SIS-177918 |
PlanServiceProvided |
otherVal |
varchar(150) |
SIS-177918 |
PlanServiceProvided |
otherVal2 |
varchar(150) |
SIS-179931 |
SpecialEDState |
secondaryDisability |
varchar(1000) |
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-180120 |
NV |
Udpdate Homeless unaccompaniedYourth value |
SIS-179984 |
Disabled OneRoser OAuth 1 Connections | |
SIS-179305 |
CDR OffpremisesAllowedDefault | |
SIS-176493 |
Null modifiedByID values for three Cross-Site Grading-related tables | |
SIS-179598 |
Filled in Early Ed DistrictIDs | |
SIS-178745 |
OK |
Converted OK state event codes |
SIS-178745 |
Converted BehaviorIncident location codes | |
SIS-178200 |
KY |
district 880 name change |
SIS-180086 |
Trim terminal name whitespace | |
SIS-178745 |
BehaviorResType stateResCode data conversion | |
SIS-178541 |
NC |
Added NCSnapshotGRSSummary DISObject |
SIS-178745 |
OK |
BehaviorEvent context data conversion |
SIS-178236 |
WA |
Inserted new state grade level |
SIS-180085 |
Set Student Number Format Preference for NC | |
SIS-179300 |
NV |
Deleted records from SCEDConcentrator table |
SIS-176493 |
Null out CrossSiteCourseGradingTaskMap modifiedByID values when applicable | |
SIS-179721 |
IN |
Removing StudentCurricularMaterialProgramAssociation from Edfi |
SIS-178541 |
NC |
Enabled school month syncing via DIS |
SIS-180035 |
NC & DE |
Disallowed school creation in NC & DE |
SIS-178659 |
MT |
Added State-Owned Educational Savings Account Flag |
SIS-179192 |
WI |
Immunization Rule Update |
SIS-179802 |
BIE |
Disabled CUPS and CDES |
SIS-176492 |
IL |
Home Primary Language list update |
SIS-179534 |
NC |
Set EnableDefaultTranscript to false one off |
SIS-179036 |
NC |
Added NCSnapshotPMRSummary DISObject |
SIS-179534 |
Populated stateCodeName column in TranscriptCourse table | |
SIS-179534 |
Populated state course name field in TranscriptCourse table | |
SIS-176493 |
Default GradingScore acceptCSEScores |
