This article collects the changes made to the database schema as part of the Campus.2415 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 |
DataType |
|---|---|---|---|
SIS-176910 |
CrossSiteNotificationRecipient |
csNotificationRecipientID |
int |
schoolID |
int | ||
notificationType |
varchar(1) | ||
recipientName |
varchar(100) | ||
recipientEmail |
varchar(255) | ||
modifiedByID |
int | ||
modifiedDateTime |
datetime2(0) |
Modified Tables
Added
Case Number |
Table |
Column |
DataType |
|---|---|---|---|
SIS-160114 |
PersonDistrictIDs |
districtPersonID |
int |
SIS-160114 |
DISLog |
xmlDataInfo |
varchar(max) |
SIS-169640 |
Gifted |
evaluatedDate |
date |
SIS-169640 |
Gifted |
evaluationMethod |
varchar(15) |
SIS-174897 |
CertificationCriterion |
cipCode |
varchar(8000) |
SIS-175068 |
FeeCredit |
purchaseProductPaymentID |
int |
SIS-175117 |
EnrollmentOR |
eoyCTEStatus |
varchar(15) |
SIS-175117 |
EnrollmentOR |
disadvantaged |
bit |
SIS-175767 |
DataValidationDef |
supportOnly |
bit |
SIS-175767 |
DataValidationGroup |
supportOnly |
bit |
SIS-176149, SIS-177202 |
DigitalEquity |
createdDate |
date |
SIS-176149, SIS-177202 |
DigitalEquity |
programStatus |
varchar(15) |
SIS-176149, SIS-177202 |
DigitalEquity |
uploadSpeedOptions |
varchar(15) |
SIS-176149, SIS-177202 |
DigitalEquity |
internetAccessInResidenceOther |
varchar(255) |
SIS-176149, SIS-177202 |
DigitalEquity |
deviceAccessOther |
varchar(255) |
SIS-176149, SIS-177202 |
DigitalEquity |
downloadSpeed |
varchar(255) |
SIS-176149, SIS-177202 |
DigitalEquity |
uploadSpeed |
varchar(255) |
SIS-176149, SIS-177202 |
DigitalEquity |
downloadSpeedOptions |
varchar(15) |
SIS-176149, SIS-177202 |
DigitalEquity |
internetAccessTypeOther |
varchar(255) |
SIS-176322 |
EvalChecklist |
evalChecklistGUID |
uniqueidentifier |
SIS-176322 |
EvalChecklistParticipant |
evalChecklistParticipantGUID |
uniqueidentifier |
SIS-176322 |
EvalConducted |
evalConductedGUID |
uniqueidentifier |
SIS-176322 |
EvalGuardian |
evalGuardianGUID |
uniqueidentifier |
SIS-176322 |
EvalSectionStatus |
evalSectionStatusGUID |
uniqueidentifier |
SIS-176322 |
InterventionSuccessStatus |
interventionSuccessStatusGUID |
uniqueidentifier |
SIS-176322 |
PlanAccommodationProvided |
planAccommodationProvidedGUID |
uniqueidentifier |
SIS-176322 |
PlanAmendment |
planAmendmentGUID |
uniqueidentifier |
SIS-176322 |
PlanGuardian |
planGuardianGUID |
uniqueidentifier |
SIS-176322 |
PlanSectionStatus |
planSectionStatusGUID |
uniqueidentifier |
SIS-176423 |
RecordsTransfer |
atRiskFOP |
varchar(100) |
SIS-176423 |
RecordsTransfer |
atRiskXML |
varchar(max) |
SIS-176322 |
SEEAddtlTests |
seeAddtlTestsGUID |
uniqueidentifier |
SIS-176322 |
SEEAreaData |
seeAreaDataGUID |
uniqueidentifier |
SIS-176322 |
SEEAssessmentResult |
seeAssessmentResultGUID |
uniqueidentifier |
SIS-176322 |
SEEAssessmentResultEvidence |
seeAssessmentResultEvidenceGUID |
uniqueidentifier |
SIS-176322 |
SEEDocumentInvolvement |
seeDocumentInvolvementGUID |
uniqueidentifier |
SIS-176322 |
SEEEligibilityTeam |
seeEligibilityTeamGUID |
uniqueidentifier |
SIS-176322 |
SEEEligibilityTeamConsent |
seeEligibilityTeamConsentGUID |
uniqueidentifier |
SIS-176322 |
SEEGenericForm |
seeGenericFormGUID |
uniqueidentifier |
SIS-176322 |
SEEGenericSubForm |
seeGenericSubFormGUID |
uniqueidentifier |
SIS-176322 |
SEEInfoReviewExisting |
seeInfoReviewExistingGUID |
uniqueidentifier |
SIS-176322 |
SEEHistoricalRecords |
seeHistoricalRecordsGUID |
uniqueidentifier |
SIS-176322 |
SEEInfoReviewExisting |
seeInfoReviewExistingGUID |
uniqueidentifier |
SIS-176322 |
SEEInterventionData | seeInterventionDataGUID | uniqueidentifier |
| SIS-176322 | SEEInterventionStrategies | seeInterventionStrategiesGUID | uniqueidentifier |
SIS-176322 |
SEEListOthers |
seeListOthersGUID |
uniqueidentifier |
SIS-176322 |
SEEManifestationDetermination |
seeManifestationDeterminationGUID |
uniqueidentifier |
SIS-176322 |
SEEProgress |
seeProgressGUID |
uniqueidentifier |
| SIS-176322 | SEEReevaluationSummary |
seeReevaluationSummaryGUID |
uniqueidentifier |
SIS-176322 |
SEEReferral |
seeReferralGUID |
uniqueidentifier |
SIS-176322 |
SEEReport |
seeReportGUID |
uniqueidentifier |
SIS-176322 |
SEETeamMeetingAttendance |
seeTeamMeetingAttendanceGUID |
uniqueidentifier |
| SIS-176322 | SEESpecificDisabilityData |
seeSpecificDisabilityDataGUID |
uniqueidentifier |
SIS-176322, SIS-176422 |
SEETeamMeetingAttendanceAlt |
seeTeamMeetingAttendanceAltGUID |
uniqueidentifier |
SIS-176322, SIS-176422 |
SEETeamMeetingAttendanceAlt |
varChar3 |
varchar(8000) |
SIS-176322 |
SEETeamMeetingAttendanceCustom |
seeTeamMeetingAttendanceCustomGUID |
uniqueidentifier |
SIS-176322 |
SEETeamMember |
seeTeamMemberGUID |
uniqueidentifier |
SIS-176322 |
SEPAccommodationDeterminationListKY |
sepAccommodationDeterminationListKYGUID |
uniqueidentifier |
SIS-176322 |
SEPAccommodationPlan |
sepAccommodationPlanGUID |
uniqueidentifier |
SIS-176322 |
SEPActionPlan |
sepActionPlanGUID |
uniqueidentifier |
SIS-176322 |
SEPBehaviorIntervention |
sepBehaviorInterventionGUID |
uniqueidentifier |
SIS-176322 |
SEPCourseOfStudy |
sepCourseOfStudyGUID |
uniqueidentifier |
SIS-176322 |
SEPGenericForm |
sepGenericFormGUID |
uniqueidentifier |
SIS-176322 |
SEPGenericSubForm |
sepGenericSubFormGUID |
uniqueidentifier |
SIS-176322 |
SEPGenericSubForm2 |
sepGenericSubForm2GUID |
uniqueidentifier |
SIS-176322 |
SEPManifestationDetermination |
sepManifestationDeterminationGUID |
uniqueidentifier |
SIS-176322 |
SEPModification |
sepModificationGUID |
uniqueidentifier |
SIS-176322 |
SEPMultiSelect1 |
sepMultiSelect1GUID |
uniqueidentifier |
SIS-176322 |
SEPOutcome |
sepOutcomeGUID |
uniqueidentifier |
SIS-176322 |
SEPPLEPEvaluation |
sepPLEPEvaluationGUID |
uniqueidentifier |
SIS-176322 |
SEPStateReportedData |
sepStateReportedDataGUID |
uniqueidentifier |
SIS-176322 |
SEPStrengthConcern |
sepStrengthConcernGUID |
uniqueidentifier |
SIS-176322 |
SEPTeamMeetingAttendance |
sepTeamMeetingAttendanceGUID |
uniqueidentifier |
SIS-176322 |
SEPTeamMeetingAttendanceAlt |
sepTeamMeetingAttendanceAltGUID |
uniqueidentifier |
SIS-176322 |
SEPTeamMeetingAttendanceCustom |
sepTeamMeetingAttendanceCustomGUID |
uniqueidentifier |
SIS-176322 |
SEPTestAccommodationList |
sepTestAccommodationListGUID |
uniqueidentifier |
SIS-176322 |
SEPTestAccommodationsPA |
sepTestAccommodationsPAGUID |
uniqueidentifier |
SIS-176322 |
SEPTransitionAssessment |
sepTransitionAssessmentGUID |
uniqueidentifier |
SIS-176322 |
SEPTransitionService |
sepTransitionServiceGUID |
uniqueidentifier |
SIS-176361 |
SpecialEDStateGA |
speechTherapy |
varchar(15) |
SIS-176423 |
AtRisk |
endYear |
varchar(15) |
SIS-176423 |
AtRisk |
grade |
varchar(15) |
SIS-176423 |
AtRisk |
support |
vaarchar(8000) |
SIS-176423 |
AtRisk |
exitReason |
varchar(15) |
SIS-176423 |
AtRisk |
intervention |
varchar(8000) |
SIS-176423 |
AtRisk |
exitStatus |
varchar(15) |
SIS-176584 |
Homeless |
homelessServedOtherFund |
varchar(15) |
SIS-177086 |
CareerTechnicalEducation |
organizationEndDate |
varchar(8000) |
SIS-177086 |
CareerTechnicalEducation |
wblType |
varchar(8000) |
SIS-177086 |
CareerTechnicalEducation |
credentialStatus |
varchar(8000) |
SIS-177086 |
CareerTechnicalEducation |
organizationStartDate |
varchar(8000) |
SIS-177086 |
CareerTechnicalEducation |
administeredDate |
varchar(8000) |
SIS-177086 |
CareerTechnicalEducation |
careerCluster |
varchar(15) |
SIS-177208, SIS-175303 |
Migrant |
createdDate |
date |
SIS-177208, SIS-175303 |
Migrant |
programStatus |
varchar(15) |
SIS-177208, SIS-175303 |
Migrant |
outOfSchoolYouth |
varchar(15) |
SIS-177208, SIS-175303 |
Migrant |
fromCountry |
varchar(15) |
SIS-177208, SIS-175303 |
Migrant |
h2aVisa |
varchar(15) |
Altered
Case Number |
Table |
Column |
DataType |
|---|---|---|---|
SIS-176149, SIS-177202 |
DigitalEquity | internetBarrierInResidence |
varchar(255) |
SIS-176149, SIS-177202 |
DigitalEquity | deviceAccess |
varchar(255) |
| SIS-176149, SIS-177202 | DigitalEquity | digitalDevice | varchar(255) |
| SIS-176149, SIS-177202 | DigitalEquity | internetAccessType |
varchar(255) |
| SIS-176149, SIS-177202 | DigitalEquity | internetAccessInResidence |
varchar(255) |
| SIS-177086 | CareerTechnicalEducation |
otherCertCredentialDegree |
varchar(8000) |
| SIS-177086 | CareerTechnicalEducation |
certCredentialDegree |
varchar(8000) |
| SIS-177086 | CareerTechnicalEducation |
studentOrganizationCharterID |
varchar(8000) |
| SIS-177086 | CareerTechnicalEducation |
studentOrganizationMemberID | varchar(8000) |
| SIS-177086 | CareerTechnicalEducation |
studentOrganization |
varchar(8000) |
| SIS-177086 | CareerTechnicalEducation |
cipCode |
varchar(8000) |
SIS-177208, SIS-175303 |
Migrant |
migrantCOEStatusIndicator |
varchar(15) |
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-176157 |
NC |
Immunization Rule Update2 |
SIS-176972 |
Off Premise Only for New CDR Customers | |
SIS-176157 |
NC |
Immunization Rule Update |
SIS-177096 |
BIE |
Deactivated CampusJob |
SIS-177050 |
NC |
Updated attributte |
SIS-176211 |
NM |
EdFi - Removed Migrant as resource |
SIS-168192 |
FRAM Income Guide 24-25 | |
SIS-176968 |
AZ |
Removed get ESSDDCExtract stored procedure |
SIS-174850 |
NV |
Updated language code |
SIS-176718 |
NC |
Immunization Rule Update |
SIS-176584 |
NC |
Defaults in Attributes |
SIS-176900 |
AZ |
Updated year for deprecated End Statuses |
SIS-175869 |
PA |
2324 Updates Adding New Field Cambridge Indicator |
SIS-169640 |
MT |
Added Gifted DIS Object |
