This article collects the changes made to the database schema as part of the Campus.2351 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-173462 | LEAStatsGA | leaStatsID | int |
districtID | int | ||
endYear | smallint | ||
tkesSelection | varchar(15) | ||
compEvalsBySystemPsych | int | ||
compEvalsByNonSystemPsych | int | ||
nonCompEvals | int | ||
initialReferralsNotSeen | int | ||
evalsNotCompleted | int | ||
summerCompEvalsBySystemPsych | int | ||
summerCompEvalsByNonSystemPsych | int | ||
parentOnlyConsultations | int | ||
supportTeamConsultations | int | ||
studentConsultations | int | ||
otherSchoolConsultations | int | ||
allOtherConsultations | int | ||
initialEvaluations | int | ||
reEvaluations | int | ||
foundInitiallyEligible | int | ||
SIS-174194 | SchoolStatsGA | schoolStatsID | int |
schoolID | int | ||
endYear | smallint | ||
titleISchoolCode | varchar(15) | ||
dualEnrollmentAwareness8th | bit | ||
dualEnrollmentAwareness9th | bit | ||
dualEnrollmentAwareness10th | bit | ||
dualEnrollmentAwareness11th | bit | ||
onlineSchoolOnly | bit | ||
cprTrainingProvided | bit | ||
stemSchool | varchar(15) | ||
nutritionSchool | varchar(15) | ||
aggravatedBattery | smallint | ||
aggravatedChildMolestation | smallint | ||
aggravatedSexualBattery | smallint | ||
aggravatedSodomy | smallint | ||
armedRobbery | smallint | ||
felonyDrugs | smallint | ||
felonyWeapons | smallint | ||
firstDegreeArson | smallint | ||
kidnapping | smallint | ||
murder | smallint | ||
nonFelonyDrugs | smallint | ||
rape | smallint | ||
terroristicThreats | smallint | ||
voluntaryManslaughter | smallint | ||
academicSupport | smallint | ||
dropoutPreventionServices | smallint | ||
childAbuseNeglectServices | smallint | ||
familyServices | smallint | ||
caseHealthServices | smallint | ||
fosterCareServices | smallint | ||
homelessServices | smallint | ||
behaviorDisciplineServices | smallint | ||
specialEducation | smallint | ||
specialPrograms | smallint | ||
caseMentalHealthServices | smallint | ||
countStudentsServed | smallint | ||
communityAgencies | smallint | ||
departmentFamChildServices | smallint | ||
referralHealthServices | smallint | ||
juvenileOtherCourt | smallint | ||
referralMentalHealthServices | smallint | ||
agencyVisits | smallint | ||
conferencesParentsGuardians | smallint | ||
consultsWithAgencies | smallint | ||
consultsSchoolStaff | smallint | ||
crisisIntervention | smallint | ||
economicAidSupport | smallint | ||
groupInterventions | smallint | ||
homeVisits | smallint | ||
conferencesWithStudents | smallint | ||
supervisoryConferences | smallint | ||
communityParticipation | smallint | ||
crisisResponseTeam | smallint | ||
SIS-174529 | SpecialEDStateGA | specialEDStateGAID | int |
personID | int | ||
districtID | int | ||
modifiedByID | int | ||
modifiedDate | date | ||
specialEDStateGAGUID | uniqueidentifier | ||
startDate | date | ||
endDate | date | ||
specialEdSetting | varchar(10) | ||
exitReason | varchar(15) | ||
exitDate | date | ||
areaOfExceptionality | varchar(15) | ||
audiologyServices | varchar(15) | ||
autismServiceHours | varchar(15) | ||
babiesCannotWaitDate | date | ||
initialEvalDate | date | ||
blindServiceHours | varchar(15) | ||
dBServiceHours | varchar(15) | ||
deafServiceHours | varchar(15) | ||
diagnosticServices | varchar(15) | ||
hHServiceHours | varchar(15) | ||
iEPARDate | date | ||
iepStartDate | date | ||
iEDDate | date | ||
iIEPMDate | date | ||
iIEPSDate | date | ||
interpreterServices | varchar(15) | ||
miIServiceHours | varchar(15) | ||
moIServiceHours | varchar(15) | ||
nEIPSDate | date | ||
oTServices | varchar(15) | ||
counselingServices | varchar(15) | ||
oMServices | varchar(15) | ||
oIServiceHours | varchar(15) | ||
oHIServiceHours | varchar(15) | ||
pCToEDate | date | ||
pCForPSDate | date | ||
pPAnnRev | bit | ||
pPInitIEP | bit | ||
pPSecIEP | bit | ||
pRIPSDate | date | ||
pRCDate | date | ||
pTServices | varchar(15) | ||
primarySchool | varchar(15) | ||
pIServiceHours | varchar(15) | ||
psychologicalServices | varchar(15) | ||
receivesAllIEP | varchar(15) | ||
recreationServices | varchar(15) | ||
reEvaluationDate | date | ||
reEvalWDate | date | ||
sSWServices | varchar(15) | ||
sDDServiceHours | varchar(15) | ||
secondarySchool | varchar(15) | ||
sIEPARDate | date | ||
sREDDate | date | ||
sIServiceHours | varchar(15) | ||
sLDServiceHours | varchar(15) | ||
sTServices | varchar(15) | ||
sLIServiceHours | varchar(15) | ||
sPAnnRev | bit | ||
sPInitIEP | bit | ||
sPSecIEP | bit | ||
iRSWDPYDate | date | ||
tBIServiceHours | varchar(15) | ||
vIServiceHours | varchar(15) | ||
sHNServices | varchar(15) | ||
eBDServiceHours | varchar(15) |
Modified Tables
Added
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-170838 | DigitalLearningVendorOAuth2ClientCredentials | exPartnerProgramParticipationAccess | BIT |
SIS-170838 | DigitalLearningVendorOAuth2ClientCredentials | exPartnerAssessmentAccess | BIT |
SIS-172612 | BehaviorEvent | indeterminateVictim | BIT |
SIS-172612 | BehaviorResolution | assignedBy | VARCHAR(15) |
SIS-172612 | BehaviorRole | hearingOfficer | BIT |
SIS-173565 | EvalGuardian | printInInvite | BIT |
SIS-173565 | Evaluation | notice2Modality | VARCHAR(500) |
SIS-173565 | Evaluation | noticeDate3 | DATE |
SIS-173565 | Evaluation | meetingCheck9 | BIT |
SIS-173565 | Evaluation | specifyOther4 | VARCHAR(150) |
SIS-173565 | Evaluation | noticeDate2 | DATE |
SIS-173565 | Evaluation | meetingCheck5 | BIT |
SIS-173565 | Evaluation | studentQuestionnaire | VARCHAR(500) |
SIS-173565 | Evaluation | notice3Modality | VARCHAR(500) |
SIS-173565 | Evaluation | parentQuestionnaire | VARCHAR(500) |
SIS-173565 | Evaluation | meetingFEmail | VARCHAR(255) |
SIS-173565 | Evaluation | inviteDate | DATE |
SIS-173565 | Evaluation | meetingCheck8 | BIT |
SIS-173565 | Evaluation | printInEval | BIT |
SIS-173565 | Evaluation | specifyOther2 | VARCHAR(150) |
SIS-173565 | Evaluation | comments | VARCHAR(8000) |
SIS-173565 | Evaluation | specifyOther3 | VARCHAR(150) |
SIS-173565 | Evaluation | meetingCheck4 | BIT |
SIS-173565 | Evaluation | meetingType | VARCHAR(500) |
SIS-173565 | Evaluation | specifyOther1 | VARCHAR(150) |
SIS-173565 | Evaluation | meetingCheck2 | BIT |
SIS-173565 | Evaluation | meetingFName | VARCHAR(150) |
SIS-173565 | Evaluation | meetingCheck6 | BIT |
SIS-173565 | Evaluation | meetingCheck1 | BIT |
| SIS-173565 | Evaluation | meetingCheck10 | BIT |
SIS-173565 | Evaluation | meetingCheck7 | BIT |
SIS-173565 | Evaluation | meetingDate | DATE |
SIS-173565 | Evaluation | meetingTime | TIME |
SIS-173565 | Evaluation | notice1Modality | VARCHAR(500) |
SIS-173565 | Evaluation | noticeDate1 | DATE |
SIS-173565 | Evaluation | meetingCheck3 | BIT |
SIS-173565 | Evaluation | meetingLocation | VARCHAR(150) |
SIS-173565 | Evaluation | meetingFPhone | VARCHAR(50) |
SIS-173565 | SEPParentalAgreement | placementAgree | TINYINT |
SIS-173565 | SEPParentalAgreement | placementDisagree | TINYINT |
SIS-173565 | SEPParentalAgreement | ageOfMajorityInformed | TINYINT |
SIS-173565 | SEPParentalAgreement | noAgeOfMajorityInformed | TINYINT |
SIS-173922, SIS-174321 | Section | wblProgramCategorySec | VARCHAR(15) |
SIS-174074 | TranscriptCourse | edFiCourseResult | VARCHAR(25) |
SIS-174172 | TestScore | addedByVendor | BIT |
SIS-174172 | TestScore | modifiedByID | INT |
SIS-174172 | TestScore | imported | BIT |
SIS-174353 | CalendarGPA | portal | BIT |
SIS-174461 | AssessmentScoreImportColumnMapping | applyDistrictToImport | BIT |
SIS-174461 | AssessmentScoreImportColumnMapping | districtID | INT |
SIS-174510 | POSTransaction | offline | BIT |
SIS-174510 | POSTransaction | occurredAtTerminal | BIT |
SIS-174510 | POSTransactionHistory | offline | BIT |
SIS-174510 | POSTransactionHistory | occurredAtTerminal | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPATerm (formerly gradesTermGPA) | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPACustom | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPACumUW | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPACumBonusUW | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPACum (formerly gradesCulumativeGPA) | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPATermBonusUW | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPATermBonus | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPACumBonus | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPARollingCum | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPATermUW | BIT |
SIS-174353 | PortalDisplayOptions | gradesGPARollingCumBonus | BIT |
Altered
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-168520 | District | state | VARCHAR(2) (changed from NOT NULL) |
SIS-173565 | PlanState | servingSchoolName | VARCHAR(150) |
SIS-174077 | Section | stateCode | VARCHAR(20) |
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-173880 | Added SchoolYearGPA DIS Object | |
SIS-168520 | State Not Null | |
SIS-174598 | Loaded AIR research setup data | |
SIS-173922 | GA | wbl custom field to core |
SIS-173195 | Added DefaultStateEnrollmentTypeForCrossSiteEnrollments to Preferences | |
SIS-174384 | Unhid TestScore comments, resultLevel, questionCount | |
SIS-173743 | CopyExemptionsFromOldToNewVaccines | |
SIS-173743 | VA | Immunization Rule Update |
SIS-173195 | Cleaned up Enrollment Start and End Status Type endYears | |
SIS-173195 | Cleaned up Enrollment Start | |
SIS-174302 | Security Filter Preference Insert | |
SIS-174315 | OH | District IRN Override on District DN tab must use District List dictionary |
SIS-173701 | MN | Immunization Rule Update |
SIS-173194 | Cleaned up orphaned crossSiteSectionGUIDs |
