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 |
