This article collects the changes made to the database schema as part of the Campus.2603 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-192770 |
MessageErrorLog |
messageID |
int |
no |
|
reason |
varchar(256) |
yes | ||
|
stackTrace |
varchar(1024) |
yes | ||
|
timeStamp |
datetime2(0) |
yes | ||
|
SIS-193016 |
SIFResponseStateIDHistory |
sifResponseStateIDHistoryID |
int |
no |
|
sifResponseHistoryID |
int |
no | ||
|
personID |
int |
no | ||
|
SIS-193571 |
IdentityValue |
identityValueID |
int |
no |
|
identityID |
int |
no | ||
|
identityValueGUID |
uniqueidentifier |
no | ||
|
attributeID |
int |
no | ||
|
value |
varchar(256) |
yes |
Modified Tables
Added Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-194663 |
CareerReadiness |
cteConcentrator |
bit |
no |
|
SIS-194663 |
CareerReadiness |
credentialOrDegree2 |
varchar(500) |
yes |
|
SIS-194653 |
Lep |
planManagerNumber |
varchar(20) |
yes |
|
SIS-192770 |
Message |
processingStatus |
varchar(1) |
yes |
|
SIS-191336 |
PlanOfStudy |
ratioWaiverList |
bit |
no |
|
SIS-194674 |
Title3 |
refugee |
varchar(15) |
yes |
|
SIS-194674 |
Title3 |
title3Refugee |
varchar(15) |
yes |
Altered Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-184044 |
BIEDMAssessmentCertification |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
BIEDMAssessmentCertification |
partSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
BIEDMAssessmentVerification |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
BIEDMAssessmentVerification |
partSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
BIEDMAttendanceCertification |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
BIEDMAttendanceVerification |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
BIEDMCohortsCertification |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
BIEDMCohortsVerification |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
BIEISEPCertInstructional |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
BIEISEPVerInstructional |
schoolName |
varchar(60) |
yes |
|
SIS-194663 |
CareerReadiness |
type |
varchar(25) |
yes |
|
SIS-194585 |
ContentSecurityPolicy |
applicationCSP |
varchar(2500) |
yes |
|
SIS-184044 |
Course |
providerSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
CourseMaster |
providerSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
CTEDataME |
sendingSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
EdFiErrorLog |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
EnrollmentHistory |
schoolName |
varchar(60) |
yes |
|
SIS-195300 |
EnrollmentMO |
careerCluster |
varchar(15) |
yes |
|
SIS-184044 |
EnrollmentOH |
homeSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
EnrollmentOH |
testingSchoolNameOverride |
varchar(60) |
yes |
|
SIS-184044 |
EvalState |
servingSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
FLFASTERLineT1 |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
FLFASTERLineT4 |
creditSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
GraduationRateReportResults |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
InterdistrictDataSyncLog |
servingSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
ISEP_Cert |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
ISEP_Ver |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
NCSnapshotGRSSummary |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
NCSnapshotPMRDetail |
schoolName |
varchar(60) |
no |
|
SIS-184044 |
PlanStaff |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
PlanState |
privateSchoolName |
varchar(60) |
yes |
|
SIS-184044 |
School |
name |
varchar(60) |
no |
|
SIS-184044 |
SchoolHistory |
name |
varchar(60) |
yes |
|
SIS-184044 |
Section |
providerSchoolNameOverride |
varchar(60) |
yes |
|
SIS-184044 |
SENoticeEvaluation |
schoolName |
varchar(60) |
yes |
|
SIS-184044 |
TranscriptCourse |
schoolName |
varchar(60) |
yes |
Deprecated Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
|---|---|---|
|
SIS-194244 |
ESSKY |
essAssessmentStudentGrades |
|
SIS-194244 |
ISEP_Cert |
perc |
|
SIS-194244 |
ISEP_Ver |
perc |
|
SIS-194244 |
MedicaidInsurance |
type_dep20092 |
|
SIS-194244 |
MedicaidInsurance |
carrierName_dep20092 |
|
SIS-194244 |
MedicaidInsurance |
carrierAddress_dep20092 |
|
SIS-194244 |
MedicaidInsurance |
carrierCity_dep20092 |
|
SIS-194244 |
MedicaidInsurance |
carrierState_dep20092 |
|
SIS-194244 |
MedicaidInsurance |
carrierZip_dep20092 |
|
SIS-194244 |
MedicaidServiceProvided |
diagnosisDescription_dep20092 |
Altered Columns
|
Case Number |
Table |
Column |
|---|---|---|
|
SIS-195484 |
Title3 |
createdByID |
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-176757 |
|
Corrected Missing OLP Purchase data |
|
SIS-192846 |
MT |
EnrollmentEndStatusType update |
|
SIS-193488 |
CA |
Added Attendance Recovery Preference |
|
SIS-193605 |
NC |
Deactivated tk |
|
SIS-193605 |
NC |
Removed transitional kindergarten |
|
SIS-193630 |
NY |
Immunization Rule Update |
|
SIS-193657 |
VA |
Immunization Rule Update |
|
SIS-193733 |
CO |
LepServiceType update and data conversion |
|
SIS-193733 |
CO |
EL Service Type Dictionary Data Conversion |
|
SIS-193815 |
MT |
Show noShow in MT BIE |
|
SIS-193945 |
MA |
Updated Course Level |
|
SIS-194105 |
CA |
CCGI Set up Data Extract Utility for 5 CCGI Extracts |
|
SIS-194458 |
NM |
EdFi studentMigrantEducationProgramAssociations object key cleanup |
|
SIS-194545 |
AZ |
Immunization Rule Update |
|
SIS-194585 |
|
Added Curriculum Import Fallback Preference |
|
SIS-194851 |
MN |
studentEarlyChildhoodScreeningProgramAssociations cleanup |
|
SIS-194905 |
TN |
Added job to delete old Ed-Fi identity mapping records |
|
SIS-195484 |
|
Added Title3 all states |
|
SIS-195484 |
ND |
Added Title6 DIS object |
