This article collects the changes made to the database schema as part of the Campus.2423 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 |
Table |
Column |
DataType |
|---|---|---|---|
SIS-174667 |
MeetingChairperson |
meetingChairpersonID |
int |
meetingID |
int | ||
personID |
int | ||
SIS-174667 |
RequiredInvitee |
requiredInviteeID |
int |
meetingID |
int | ||
fullName |
varchar(100) | ||
role |
varchar(100) | ||
roleCode |
varchar(15) | ||
invited |
bit | ||
attended |
bit | ||
contact |
bit | ||
disagreed |
bit | ||
disagreeComments |
varchar(255) | ||
SIS-176129 |
FormDocumentPublishHistory |
formDocumentPublishHistoryID |
int |
documentID |
int | ||
documentName |
varchar(1000) | ||
districtID |
int | ||
objectName |
varchar(128) | ||
published |
bit | ||
lastPublishedTimeStamp |
datetime2(0) | ||
SIS-176282 |
SEPTestAccommodationsMO |
accommodationsID |
int |
planID |
int | ||
type |
varchar(100) | ||
gradeLevelParticipation |
varchar(150) | ||
breakCheck |
tinyint | ||
calculatorCheck |
tinyint | ||
englishDictionaryCheck |
tinyint | ||
grammarHandbookCheck |
tinyint | ||
graphingToolCheck |
tinyint | ||
highlighterCheck |
tinyint | ||
lineGuideCheck |
tinyint | ||
magnificationCheck |
tinyint | ||
markForReviewCheck |
tinyint | ||
maskingCheck |
tinyint | ||
protractorCheck |
tinyint | ||
readAloudCheck |
tinyint | ||
referenceSheetCheck |
tinyint | ||
rulerCheck |
tinyint | ||
scratchPaperCheck |
tinyint | ||
strikeThroughCheck |
tinyint | ||
thesaurusCheck |
tinyint | ||
writingToolsCheck |
tinyint | ||
bilingualDictionaryCheck |
tinyint | ||
colorContrastCheck |
tinyint | ||
colorContrastCheck2 |
tinyint | ||
colorOverlayCheck |
tinyint | ||
magnification2Check |
tinyint | ||
masking2Check |
tinyint | ||
paperBasedCheck |
tinyint | ||
scribeCheck |
tinyint | ||
separateSettingCheck |
tinyint | ||
translationCheck |
tinyint | ||
noneCheck |
tinyint | ||
noneCheck2 |
tinyint | ||
noneCheck3 |
tinyint | ||
blindCheck |
tinyint | ||
algebra1Check1 |
tinyint | ||
algebra1Check2 |
tinyint | ||
algebra2Check1 |
tinyint | ||
algebra2Check2 |
tinyint | ||
geometryCheck1 |
tinyint | ||
geometryCheck2 |
tinyint | ||
americanHistoryCheck1 |
tinyint | ||
americanHistoryCheck2 |
tinyint | ||
governmentCheck1 |
tinyint | ||
governmentCheck2 |
tinyint | ||
personalFinanceCheck1 |
tinyint | ||
personalFinanceCheck2 |
tinyint | ||
english1Check1 |
tinyint | ||
english1Check2 |
tinyint | ||
english2Check1 |
tinyint | ||
english2Check2 |
tinyint | ||
biologyCheck1 |
tinyint | ||
biologyCheck2 |
tinyint | ||
physicalScienceCheck1 |
tinyint | ||
physicalScienceCheck2 |
tinyint | ||
textToSpeechCheck1 |
tinyint | ||
textToSpeechCheck2 |
tinyint | ||
humanReaderCheck1 |
tinyint | ||
humanReaderCheck2 |
tinyint | ||
assistiveTechCheck1 |
tinyint | ||
assistiveTechCheck2 |
tinyint | ||
nativeLanguageCheck1 |
tinyint | ||
nativeLanguageCheck2 |
tinyint | ||
sectionDNoneCheck1 |
tinyint | ||
sectionDNoneCheck2 |
tinyint | ||
sectionCEnglishMS |
varchar(8000) | ||
sectionCMathMS |
varchar(8000) | ||
sectionCScienceMS |
varchar(8000) | ||
sectionCSocialStudiesMS |
varchar(8000) | ||
sectionDGradesMS1 |
varchar(8000) | ||
sectionDGradesMS2 |
varchar(8000) | ||
sectionEEnglishMS |
varchar(8000) | ||
sectionEMathMS |
varchar(8000) | ||
sectionEScienceMS |
varchar(8000) | ||
englishLanguageArtsCheck1 |
tinyint | ||
englishLanguageArtsCheck2 |
tinyint | ||
mathematicsCheck1 |
tinyint | ||
mathematicsCheck2 |
tinyint | ||
scienceCheck1 |
tinyint | ||
scienceCheck2 |
tinyint | ||
dlmCheck1 |
tinyint | ||
dlmCheck2 |
tinyint | ||
dlmCheck3 |
tinyint | ||
widaAssessments |
varchar(150) | ||
kindergartenWIDA |
varchar(50) | ||
studentOnlineWIDA |
varchar(50) | ||
studentPaperAndPencilWIDA |
varchar(50) | ||
k12AlternateAccommodationWIDA |
varchar(50) | ||
specializedEquipmentCheck |
tinyint | ||
alternativeMicrophoneCheck |
tinyint | ||
audioAidsCheck |
tinyint | ||
extendedTestingTimeCheck |
tinyint | ||
familiarTestAdminCheck |
tinyint | ||
individualCheck |
tinyint | ||
keyboardNavCheck |
tinyint | ||
verballyRedirectCheck |
tinyint | ||
monitorResponsesCheck |
tinyint | ||
verbalPraiseCheck |
tinyint | ||
specificSeatingCheck |
tinyint | ||
shortSegmentsCheck |
tinyint | ||
sectionBListenMS |
varchar(8000) | ||
sectionBReadMS |
varchar(8000) | ||
sectionBSpeakMS |
varchar(8000) | ||
sectionBWriteMS |
varchar(8000) | ||
sectionCListenMS |
varchar(8000) | ||
sectionCReadMS |
varchar(8000) | ||
sectionCSpeakMS |
varchar(8000) | ||
sectionCWriteMS |
varchar(8000) | ||
sectionDListenMS |
varchar(8000) | ||
sectionDReadMS |
varchar(8000) | ||
sectionDSpeakMS |
varchar(8000) | ||
sectionDWriteMS |
varchar(8000) | ||
sectionDUniversalMS |
varchar(8000) | ||
sectionEAccommodationsMS |
varchar(8000) | ||
sectionFAlgebra1MS |
varchar(8000) | ||
sectionFAlgebra2MS |
varchar(8000) | ||
sectionFAmericanHistoryMS |
varchar(8000) | ||
sectionFBiologyMS |
varchar(8000) | ||
sectionFEnglish1MS |
varchar(8000) | ||
sectionFEnglish2MS |
varchar(8000) | ||
sectionFGeometryMS |
varchar(8000) | ||
sectionFGovernmentMS |
varchar(8000) | ||
sectionFPersonalFinanceMS |
varchar(8000) | ||
sectionFPhysicalScienceMS |
varchar(8000) | ||
participateInNaepCheck |
tinyint | ||
naepAssessmentAccommodations |
varchar(50) | ||
closedCaptioningCheck |
tinyint | ||
colorThemingCheck |
tinyint | ||
directionsReadAloudCheck |
tinyint | ||
directionsExplainedCheck |
tinyint | ||
eliminationCapabilityCheck |
tinyint | ||
smallGroupCheck |
tinyint | ||
computerUseCheck |
tinyint | ||
volumeAdjustmentCheck |
tinyint | ||
zoomingCheck |
tinyint | ||
naepSectionBMath |
varchar(8000) | ||
naepSectionBReading |
varchar(8000) | ||
sepTestAccommodationsMOGUID |
uniqueidentifier | ||
SIS-176393 |
POSPatronImport |
importID |
int |
legacyFamilyAccounts |
bit | ||
uploadStaffByID |
int | ||
uploadStudentByID |
int | ||
importByID |
int | ||
uploadStudentFilename |
varchar(8000) | ||
uploadStaffFilename |
varchar(8000) | ||
uploadStudentTimestamp |
datetime2(0) | ||
uploadStaffTimestamp |
datetime2(0) | ||
importTimestamp |
datetime2(0) | ||
uploadStudentCount |
int | ||
uploadStaffCount |
int | ||
importStudentCount |
int | ||
importStaffCount |
int | ||
uploadStudentBalance |
decimal(12,2) | ||
uploadStaffBalance |
decimal(12,2) | ||
importStudentBalance |
decimal(12,2) | ||
importStaffBalance |
decimal(12,2) | ||
completedStep |
int | ||
pinType |
varchar(8000) | ||
matchRan |
bit | ||
SIS-176393 |
POSPatronImportLog |
logID |
int |
logTimestamp |
datetime2(0) | ||
type |
varchar(5) | ||
message |
varchar(8000) | ||
SIS-176393 |
POSPatronImportRecord |
recordID |
int |
importID |
int | ||
student |
bit | ||
firstNameIn |
varchar(8000) | ||
lastNameIn |
varchar(8000) | ||
studentNumberIn |
varchar(8000) | ||
staffNumberIn |
varchar(8000) | ||
birthdateIn |
varchar(8000) | ||
personIDIn |
int | ||
balance |
decimal(12,2) | ||
pin |
varchar(8000) | ||
confidence |
int | ||
duplicate |
bit | ||
personIDMatch |
int | ||
warningLog |
varchar(8000) | ||
SIS-177395 |
DistrictLiteracyInstructionInformation |
districtLiteracyInstructionInformationID |
int |
districtID |
int | ||
districtLiteracyInstructionInformationGUID |
uniqueidentifier | ||
schoolYear |
int | ||
modifiedByID |
int | ||
modifiedDate |
datetime2(0) | ||
code |
varchar(15) | ||
type |
varchar(15) | ||
status |
varchar(15) | ||
gradeLevel |
varchar(150) | ||
SIS-177811 |
CustomMigrantService |
customID |
int |
attributeID |
int | ||
migrantServiceID |
int | ||
value |
varchar(256) | ||
date |
date | ||
SIS-177811 |
MigrantService |
migrantServiceID |
int |
migrantID |
int | ||
personID |
int | ||
districtID |
int | ||
migrantServiceGUID |
uniqueidentifier | ||
startDate |
date | ||
endDate |
date | ||
serviceType |
varchar(15) | ||
serviceFunding |
varchar(15) | ||
comments |
varchar(255) | ||
modifiedByID |
int | ||
modifiedDate |
date | ||
createdByID |
int | ||
createdDate |
date | ||
SIS-177965 |
CrossDistrictPeer |
peerID |
int |
districtGUID |
uniqueidentifier | ||
districtName |
varchar(50) | ||
SIS-177965 |
CupsRegistration |
registrationID |
int |
clientId |
nvarchar(100) | ||
clientSecret |
nvarchar(500) | ||
publicKey |
nvarchar(500) | ||
poolName |
varchar(255) | ||
SIS-177965 |
OwlHistory |
owlHistoryID |
int |
sentOrReceived |
char | ||
owlType |
varchar(255) | ||
owlJSON |
nvarchar(max) | ||
owlGUID |
uniqueidentifier | ||
timestamp |
datetime2(2) | ||
queueDurationMs |
int | ||
otherDistrictGUID |
uniqueidentifier | ||
poolName |
varchar(255) | ||
SIS-177965 |
OwlListener |
owlListenerID |
int |
url |
varchar(255) | ||
poolName |
varchar(255) | ||
productName |
varchar(255) | ||
modifiedTimestamp |
datetime2(2) | ||
SIS-177965 |
PendingHomeCrossDistrictRoster |
pendingID |
int |
rosterAction |
varchar(1) | ||
personID |
int | ||
sectionID |
int | ||
effectiveDate |
date | ||
crossSiteSectionGUID |
uniqueidentifier | ||
homeRosterGUID |
uniqueidentifier | ||
altAchievementStandard |
varchar(15) | ||
attendanceStatus |
varchar(15) | ||
courseCode |
varchar(18) | ||
createdDate |
datetime2(2) | ||
creditRecovery |
bit | ||
crossSiteRosterGUID |
uniqueidentifier | ||
crossSiteSection |
bit | ||
crossSiteStudent |
bit | ||
dualCreditCode |
varchar(15) | ||
eipDelivery |
varchar(15) | ||
ellDelivery |
varchar(15) | ||
endDate |
datetime2(2) | ||
eoc |
varchar(2) | ||
exitReason |
varchar(4) | ||
giftedDelivery |
varchar(15) | ||
instructionalSetting |
varchar(15) | ||
lock |
bit | ||
noCredit |
bit | ||
postSecondaryCredits |
varchar(15) | ||
provider |
varchar(15) | ||
removePts |
bit | ||
repeatCourse |
bit | ||
specialCode |
varchar(50) | ||
spedDelivery |
varchar(15) | ||
startDate |
datetime2(2) | ||
status |
varchar(4) | ||
servingSchoolFailure |
bit | ||
SIS-177982 |
FERPAValue |
ferpaValueID |
int |
ferpaID |
int | ||
ferpaValueGUID |
uniqueidentifier | ||
attributeID |
int | ||
value |
varchar(15) | ||
SIS-178159 |
CustomDropout |
customID |
int |
attributeID |
int | ||
dropoutID |
int | ||
value |
varchar(256) | ||
date |
date | ||
SIS-178159 |
Dropout |
dropoutID |
int |
personID |
int | ||
districtID |
int | ||
dropoutGUID |
uniqueidentifier | ||
startDate |
date | ||
endDate |
date | ||
dropoutReason |
varchar(15) | ||
createdDate |
date | ||
modifiedByID |
int | ||
modifiedDate |
date | ||
comments |
varchar(255) | ||
SIS-178336 |
GiftedValue |
giftedValueID |
int |
giftedID |
int | ||
attributeID |
int | ||
value |
varchar(50) | ||
giftedValueGUID |
uniqueidentifier | ||
SIS-178377 |
CustomLanguage |
customID |
int |
attributeID |
int | ||
identityID |
int | ||
value |
varchar(5) |
Renamed Tables
| Case Number | Old Table Name | New Table Name |
|---|---|---|
| SIS-176953 | CartridgeImport.myCurriculum | teacherImport |
Modified Tables
Added
Case Number |
Table |
Column |
DataType |
|---|---|---|---|
SIS-178225 |
ALPSS |
entryReason |
varchar(15) |
SIS-178636 |
AtRisk |
readingCamp |
varchar(15) |
SIS-178636 |
AtRisk |
days |
int |
SIS-177054 |
BehaviorResponse |
staffTrainingDetails |
varchar(1024) |
SIS-177054 |
BehaviorResponse |
responseFollowUp |
bit |
SIS-177054 |
BehaviorResponse |
supportPlanChangeType |
varchar(2) |
SIS-177054 |
BehaviorResponse |
treatmentType |
varchar(15) |
SIS-177054 |
BehaviorResponse |
witnessInterviewDetails |
varchar(1024) |
SIS-177054 |
BehaviorResponse |
contactType |
varchar(15) |
SIS-177054 |
BehaviorResponse |
policyChangeDetails |
varchar(1024) |
SIS-177054 |
BehaviorResponse |
techniqueUsed |
varchar(15) |
SIS-177054 |
BehaviorResponse |
studentInterviewDetails |
varchar(1024) |
SIS-177054 |
BehaviorResponse |
responseReason |
varchar(15) |
SIS-177054 |
BehaviorResponse |
usedCrisisResponse |
bit |
SIS-177054 |
BehaviorResponse |
responseLocation |
varchar(15) |
SIS-177054 |
BehaviorResponse |
changeDescription |
varchar(1024) |
SIS-177054 |
BehaviorResponseRole |
treatmentTypeStaff |
varchar(15) |
SIS-177796 |
CareerTechnicalEducation |
localArticulation |
varchar(15) |
SIS-176953 |
CartridgeImport |
curriculumDeleted |
bit |
SIS-177965 |
Course |
crossDistrictCourseVersion |
varchar(200) |
SIS-177965 |
Course |
peerID |
int |
SIS-178138 |
CourseCode |
type |
varchar(15) |
SIS-178138 |
CourseCode |
gpaWeight |
decimal(6,3) |
SIS-178138 |
CourseCode |
transcript |
bit |
SIS-178353 |
CrossSiteCourseGradingTaskMap |
invalidTask |
bit |
SIS-178353 |
CrossSiteCourseGradingTaskMap |
invalidTerm |
bit |
SIS-178353 |
CrossSiteScoreGroupMap |
hasUnmappedScores |
bit |
SIS-178353 |
CrossSiteScoreGroupMap |
invalidScoreMapped |
bit |
SIS-177965 |
District |
crossSiteParticipationType |
varchar(15) |
SIS-177797 |
Enrollment |
choiceBasisReason |
varchar(15) |
SIS-177797 |
Enrollment |
peerID |
int |
SIS-177965 |
EnrollmentHistory |
peerID |
intt |
SIS-178426 |
FRAMPermission |
code |
varchar(50) |
SIS-176129 |
FormDocument |
documentGUID |
uniqueidentifier |
SIS-176129 |
FormDocument |
publishToDistrict |
bit |
SIS-176129 |
FormElement |
formElementGUID |
uniqueidentifier |
SIS-174669 |
FundedProgram |
schoolYear |
varchar(15) |
SIS-174669 |
FundedProgram |
exitReason |
varchar(15) |
SIS-174669 |
FundedProgram |
certificateReceived |
varchar(15) |
SIS-174669 |
FundedProgram |
dateOfIssuance |
date |
SIS-178336 |
Gifted |
identificationArea |
varchar(15) |
SIS-178074 |
GraduationSeal |
certificateReviewDate |
date |
SIS-178074 |
GraduationSeal |
certificateIssueConfirm |
bit |
SIS-178074 |
GraduationSeal |
assessmentTitle |
varchar(20) |
SIS-178716 |
HealthScreeningConcussion |
concussionLocation |
varchar(15) |
SIS-178716 |
HealthScreeningDental |
dentalLocation |
varchar(15) |
SIS-178716 |
HealthScreeningDevelopmental |
devLocation |
varchar(15) |
SIS-178716 |
HealthScreeningEarlyChildhood |
ecScreeningLocation |
varchar(15) |
SIS-178716 |
HealthScreeningGrowth |
growthLocation |
varchar(15) |
SIS-178716 |
HealthScreeningHearing |
hearingLocation |
varchar(15) |
SIS-178716 |
HealthScreeningScoliosis |
scoliosisLocation |
varchar(15) |
SIS-178716 |
HealthScreeningLead |
leadLocation |
varchar(15) |
SIS-178716 |
HealthScreeningPhysical |
physicalLocation |
varchar(15) |
SIS-178716 |
HealthScreeningSocialEmotional |
socialEmotionalLocation |
varchar(15) |
SIS-178716 |
HealthScreeningSpeech |
speechLocation |
varchar(15) |
SIS-178716 |
HealthScreeningTuberculosis |
tbLocation |
varchar(15) |
SIS-178716 |
HealthScreeningVision |
visionLocation |
varchar(15) |
SIS-177811 |
HomelessService |
createdByID |
int |
SIS-177811 |
HomelessService |
homelessID |
int |
SIS-177965 |
Household |
householdGUID |
uniqueidentifier |
SIS-177696 |
ImpactAidEmployment |
payGrade |
varchar(15) |
SIS-178716 |
Medication |
medRequired |
bit |
SIS-174667 |
Meeting |
placementDateChange |
date |
SIS-174667 |
Meeting |
residentDistrict |
int |
SIS-174667 |
Meeting |
modifiedByID |
int |
SIS-174667 |
Meeting |
servingDistrict |
int |
SIS-174667 |
Meeting |
meetingType |
varchar(15) |
SIS-174667 |
Meeting |
outcomeComments |
varchar(255) |
SIS-174667 |
Meeting |
meetingGUID |
uniqueidentifier |
SIS-174667 |
Meeting |
schoolOfOriginTransportation |
bit |
SIS-174667 |
Meeting |
residentSchool |
int |
SIS-174667 |
Meeting |
studentPersonID |
int |
SIS-174667 |
Meeting |
districtID |
int |
SIS-174667 |
Meeting |
meetingFormat |
varchar(15) |
SIS-174667 |
Meeting |
servingSchool |
int |
SIS-174667 |
Meeting |
programType |
varchar(15) |
SIS-174667 |
Meeting |
purpose |
varchar(15) |
SIS-174667 |
Meeting |
purposeComments |
varchar(255) |
SIS-174667 |
Meeting |
chairpersonComments |
varchar(255) |
SIS-174667 |
Meeting |
outcome |
varchar(15) |
SIS-178584 |
Message |
isTest |
bit |
SIS-177254, SIS-178023 |
PlanOfStudy |
studentWeeklyMinutes |
int |
SIS-177254, SIS-178023 |
PlanOfStudy |
healthPhysicalEd |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
expectedReturnDate |
date |
SIS-177254, SIS-178023 |
PlanOfStudy |
consentSignReceived |
date |
SIS-177254, SIS-178023 |
PlanOfStudy |
mathematics |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
socialStudies |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
createdDate |
date |
SIS-177254, SIS-178023 |
PlanOfStudy |
reasonCode |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
science |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
residentMinutesAvail |
int |
SIS-177254, SIS-178023 |
PlanOfStudy |
worldLanguages |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
visualPerformingArts |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
reasonComment |
varchar(50) |
SIS-177254, SIS-178023 |
PlanOfStudy |
englishLanguageArts |
varchar(15) |
SIS-177254, SIS-178023 |
PlanOfStudy |
legalInfoSignReceived |
date |
SIS-178074 |
Program |
certificateIssueConfirm |
bit |
SIS-178074 |
Program |
assessmentTitle |
varchar(20) |
SIS-177861 |
PupilCount |
secondFriJanMembOverride |
varchar(15) |
SIS-177861 |
PupilCount |
firstFriMayMembOverride |
varchar(15) |
SIS-177861 |
PupilCount |
thirdFriSeptMembOverride |
varchar(15) |
SIS-178159, SIS-178732 |
RecordsTransfer |
dropoutXML |
varchar(max) |
SIS-178159, SIS-178732 |
RecordsTransfer |
dropoutFOP |
varchar(100) |
SIS-178159, SIS-178732 |
RecordsTransfer |
fundedProgramXML |
varchar(max) |
SIS-178159, SIS-178732 |
RecordsTransfer |
fundedProgramFOP |
varchar(100) |
SIS-177965 |
Roster |
peerID |
int |
SIS-178047 |
SEPTestAccommodationList |
schoolYearLabel |
varchar(5) |
SIS-176282 |
SEPlan |
nextTriennialEvalDate |
date |
SIS-176282 |
SEPlan |
previousIEPDate |
date |
SIS-176282 |
SEPlan |
additionalInfo |
varchar(150) |
SIS-176282 |
SEPlan |
guardianInformedDate |
date |
SIS-177798 |
School |
exceptionSchoolEdFiID |
varchar(15) |
SIS-177965, SIS-177799, SIS-178353 |
Section |
crossDistrictStructureGUID |
uniqueidentifier |
SIS-177965, SIS-177799, SIS-178353 |
Section |
avgMinutesWeek |
int |
SIS-177965, SIS-177799, SIS-178353 |
Section |
avgPassTimeMinutesWeek |
int |
SIS-177965, SIS-177799, SIS-178353 |
Section |
crossDistrictSectionVersion |
varchar(200) |
SIS-177794 |
Section504 |
evaluationDate |
date |
SIS-177794 |
Section504 |
meetingDate |
date |
SIS-177794 |
Section504 |
dnqDate |
date |
SIS-177592 |
TestAccommodations |
tsMtMastEla |
varchar(400) |
SIS-177592 |
TestAccommodations |
tsMtMastMath |
varchar(400) |
Altered
Case Number |
Table |
Column |
DataType |
|---|---|---|---|
SIS-177902 |
CustomFundedProgram |
date |
date |
SIS-176289 |
FRAMPermission |
permissionName |
varchar(50) |
SIS-175870 |
FormDocument |
urlBlank |
varchar(500) |
SIS-175870 |
FormDocument |
url |
varchar(500) |
SIS-177991 |
SpecialEDState |
exitDate |
date |
SIS-177991 |
SpecialEDState |
recordedDate |
date |
SIS-177268 |
Title1Services |
title1Service |
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-176842 |
Scheduled Refresh of OneRoster Cache | |
SIS-179124 |
NC |
Internal Fix FK script for CampusMasterNC |
SIS-178664 |
Enabled Mobile Notification Service by default | |
SIS-179124 |
NC |
Attribute Additions Part 2 insert impact aid sites fixed |
SIS-176842 |
Re-Enabled OneRoster Sequence tables | |
SIS-177696 |
NC |
Attribute Additions Part 2 insert impact aid sites fixed |
SIS-178138 |
NC |
Added Course Codes |
SIS-178639 |
Disabled CDR for homeless service | |
SIS-178126 |
NY |
Immunization Rule Update |
SIS-176953 |
Curriculum Import Add New Notifications | |
SIS-177054 |
DE |
Inserted state-defined response types into BehaviorResponseType table for DE |
SIS-178225 |
NC |
Renamed end and start dates |
SIS-178225 |
Added ALPSS to DIS | |
SIS-178733 |
Added Foster Care and Homeless Custom Forms | |
SIS-178159 |
Added Dropout to DIS | |
SIS-178811 |
CO |
weaponType update |
SIS-177696 |
NC |
Replaced raceEthnicity dictionary |
SIS-177811 |
Created Feature Toggle for services tab | |
SIS-178758 |
Quiz to Assessment Conversion fix | |
SIS-177303 |
Added Title1Services to DIS | |
SIS-177696 |
NC |
Attribute Additions Part 2 sasr 1562 Impact Aid Sites |
SIS-177696 |
NC |
Attribute Additions Part 2 |
SIS-177303 |
Added FERPA to DIS | |
SIS-177303 |
Added DigitalEquity to DIS | |
SIS-177303 |
Added AtRisk to DIS | |
SIS-177965 |
Created Cups Auto Register Quartz job | |
SIS-177965 |
Inserted OwlHistory Preference | |
SIS-177965 |
Updated intra and inter toggles for certain states | |
SIS-177811 |
Moved CDR uploaded files from Homeless Services to Homeless | |
SIS-177303 |
Added Title1 to DIS | |
SIS-178167 |
Updated and Added CAS items | |
SIS-177811 |
NC |
Added Program Service related DIS Objects |
SIS-177866 |
OK |
Immunization Rule Update |
SIS-178026 |
KS |
Immunization Rule Update |
SIS-177997 |
MN |
Immunization Rule Update |
SIS-178023 |
Added columns to PlanOfStudy | |
SIS-174669 |
Added FundedProgram to DIS | |
SIS-174669 |
Added Driver's Ed Certificate Custom Forms | |
SIS-177392 |
NC |
Immunization Rule Update |
SIS-177254 |
Added columns to PlanOfStudy | |
SIS-176992 |
NV |
Program cluster conversion |
SIS-176809 |
VA |
Serving Division School number conversion |
SIS-177560 |
MO |
Ed-Fi Inactive Grades resource |
SIS-173636 |
AZ |
InvalidatedTitle 1 schoolwide object keys |
