This article collects the changes made to the database schema as part of the Campus.2427 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-175017 |
OAuth2OutboundClient |
oAuth2OutboundClientID |
int |
name |
varchar(50) | ||
oAuthUrl |
varchar(1024) | ||
clientID |
varchar(128) | ||
clientSecret |
varchar(2000) | ||
connectionTimeoutSeconds |
smallint | ||
socketTimeoutSeconds |
smallint | ||
passingMethod |
varchar(12) | ||
baseUrl |
varchar(1024) | ||
createdByID |
int | ||
createdDate |
datetime2(0) | ||
modifiedByID |
int | ||
modifiedDate |
datetime2(0) | ||
SIS-177084 |
TransportationRequestConfig |
transportationRequestConfigID |
int |
allowRouteTypeCode |
bit | ||
allowPickupLocation |
bit | ||
allowPickupTime |
bit | ||
allowDropoffLocation |
bit | ||
allowDropoffTime |
bit | ||
allowDaysOfWeek |
bit | ||
allowEndDate |
bit | ||
allowDueDate |
bit | ||
allowAccommodations |
bit | ||
allowMultipleRoutes |
bit | ||
allowFreeformAddress |
bit | ||
SIS-177084 |
CustomTransportationParking |
customID |
int |
attributeID |
int | ||
value |
varchar(256) | ||
parkingID |
int | ||
SIS-177714 |
EnrollmentDE |
enrollmentID |
int |
calendarID |
int | ||
personID |
int | ||
accountabilitySchool |
varchar(15) | ||
fundingSchool |
varchar(15) | ||
assessmentSchool |
varchar(15) | ||
SIS-178866 |
SpecialEDStateTest |
specialEDStateTestID |
int |
specialEDStateID |
int | ||
specialEDStateTestGUID |
uniqueidentifier | ||
assessment |
varchar(15) | ||
accommodation |
varchar(15) | ||
ecAccommodation |
varchar(200) | ||
SIS-179002 |
SpecialEDStateEvalConsent |
specialEDStateEvalConsentID |
int |
specialEDStateID |
int | ||
initialConsentDate |
date | ||
SIS-179002 |
SpecialEDStateFundingNeeds |
specialEDStateFundingNeedsID |
int |
specialEDStateID |
int | ||
category |
varchar(15) | ||
startDate |
date | ||
endDate |
date | ||
SIS-179574 |
EmploymentAssignmentValue |
employmentAssignmentValueID |
int |
assignmentID |
int | ||
employmentAssignmentValueGUID |
uniqueidentifier | ||
attributeID |
int | ||
value |
varchar(15) |
Modified Tables
Added
| Case Number | Table |
Column |
DataType |
|---|---|---|---|
SIS-174237 |
Employment |
leaveEndDate |
date |
SIS-174237 |
Employment |
leaveStartDate |
date |
SIS-175113, SIS-179834 |
AtRisk |
stateGrade |
varchar(4) |
SIS-175113, SIS-179834 |
AtRisk |
methodologyToolComments |
varchar(100) |
SIS-175113, SIS-179834 |
AtRisk |
methodologyTool |
varchar(15) |
SIS-176086 |
FreeReducedApplication |
householdIncome |
decimal(18,2) |
SIS-176086 |
FreeReducedApplication |
childIncome |
decimal(18,2) |
SIS-176086 |
FreeReducedApplication |
childIncomeType |
varchar(1) |
SIS-176086 |
FreeReducedApplication |
householdSize |
int |
SIS-176086 |
FreeReducedApplication |
householdIncomeType |
varchar(1) |
SIS-176086 |
OnlineMealBenefitApplication |
householdIncome |
decimal(18,2) |
SIS-176086 |
OnlineMealBenefitApplication |
childIncome |
decimal(18,2) |
SIS-176086 |
OnlineMealBenefitApplication |
childIncomeType |
varchar(1) |
SIS-176086 |
OnlineMealBenefitApplication |
householdSize |
int |
SIS-176086 |
OnlineMealBenefitApplication |
householdIncomeType |
varchar(1) |
SIS-177084 |
TransportationRequestDetail |
pickupAddressID |
int |
SIS-177084 |
TransportationRequestDetail |
dropoffAddressID |
int |
SIS-177217 |
Section |
lastImportedScoreDate |
datetime2(2) |
SIS-177265 |
PlanOfStudy |
personalFinance |
varchar(15) |
SIS-177911 |
MeetingCalendarAssociation |
meetingCalendarAssociationGUID |
uniqueidentifier |
SIS-177911 |
MeetingInvitee |
meetingInviteeGUID |
uniqueidentifier |
SIS-177911 |
MeetingLog |
meetingLogGUID |
uniqueidentifier |
SIS-177911 |
MeetingOutcome |
meetingOutcomeGUID |
uniqueidentifier |
SIS-177911 |
MeetingPurpose |
meetingPurposeGUID |
uniqueidentifier |
SIS-177911 |
RequiredInvitee |
requiredInviteeGUID |
uniqueidentifier |
SIS-177993 |
Address |
externalKey |
varchar(255) |
SIS-178006 |
SEPParentalAgreement |
tinyint2 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint17 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint4 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint8 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint10 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint18 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint11 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint3 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint9 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint12 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint14 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint1 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint16 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint15 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint6 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint5 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint13 |
tinyint |
SIS-178006 |
SEPParentalAgreement |
tinyint7 |
tinyint |
SIS-178259 |
FosterCare |
exitReason |
varchar(15) |
SIS-178259 |
Homeless |
exitReason |
varchar(15) |
SIS-178259 |
Homeless |
threeToFiveChildren |
int |
SIS-178259 |
Homeless |
twoChildren |
int |
SIS-178259 |
Migrant |
exitReason |
varchar(15) |
SIS-178259 |
NativeAmericanEligibility |
exitReason |
varchar(15) |
SIS-178259 |
NativeAmericanEligibility |
raceSubcategory |
varchar(15) |
SIS-178259 |
NativeAmericanEligibility |
placementReason |
varchar(15) |
SIS-178623 |
SSRSDistrictReport |
excel |
bit |
SIS-178623 |
SSRSDistrictReport |
bit | |
SIS-178623 |
SSRSDistrictReport |
word |
bit |
SIS-178623 |
SSRSDistrictReport |
html |
bit |
SIS-178623 |
SSRSDistrictReport |
csv |
bit |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
meetingInviteDEFOP |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
ferpaFOP |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
iepTransDEDataXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
isaDEFOP |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
digitalEquityXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
meetingInviteDEDataXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
meetingInviteDEXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
isaDEDataXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
iepTransDEXML |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
isaDEXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
ferpaXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
meetingFOP |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
migrantServiceFOP |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
iepTransDEFOP |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
digitalEquityFOP |
varchar(100) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
migrantServiceXML |
varchar(max) |
SIS-178997, SIS-179064, SIS-178259, SIS-178806 |
RecordsTransfer |
meetingXML |
varchar(max) |
SIS-178997 |
SEPGenericForm |
vcMax19 |
varchar(max) |
SIS-178997 |
SEPGenericForm |
vcMax18 |
varchar(max) |
SIS-178997 |
SEPGenericForm |
vcMax20 |
varchar(max) |
SIS-179002 |
SpecialEDState |
eligible |
bit |
SIS-179002 |
SpecialEDState |
otherCalendarPrograms |
varchar(15) |
SIS-179002 |
SpecialEDState |
evalID |
int |
SIS-179002 |
SpecialEDState |
planID |
int |
SIS-179002 |
SpecialEDState |
fundingCountException |
bit |
SIS-179002 |
SpecialEDState |
spedPreReferral |
varchar(15) |
SIS-179079 |
EnrollmentNC |
servingSchool |
varchar(15) |
SIS-179079 |
EnrollmentNC |
yearRoundTransferDaysOverride |
int |
SIS-179386 |
SEPExtendedYear |
startDate |
date |
SIS-179479 |
ActivityPreapprovalForm |
modified |
bit |
SIS-179285 |
ProgramParticipation |
cteConcentratorOverride |
varchar(15) |
SIS-179574 |
EmploymentAssignment |
k3TSAdminRole |
varchar(15) |
SIS-179574 |
EmploymentAssignment |
schoolnetRole |
varchar(15) |
SIS-179574 |
EmploymentAssignment |
amplifyRole |
varchar(15) |
SIS-179678 |
Meeting |
schoolToAttend |
varchar(10) |
Altered
| Case Number | Table |
Column |
DataType |
|---|---|---|---|
SIS-173825 |
PostSecondaryEnrollmentOptions |
highSchoolHrs |
decimal(5,1) |
SIS-175017 |
DISBatchHistory |
agentName |
varchar(75) |
SIS-177793 |
RelationshipType |
edFiRelationType |
varchar(15) |
SIS-179502 |
CareerTechnicalEducation |
specialPopulation |
varchar(8000) |
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-146566 |
Disabled Final Grade Passback | |
SIS-170735 |
IN |
Ed-Fi studentProgramAssociation objectKey change |
SIS-175017 |
VA |
DIS Quartz jobs |
SIS-175113 |
MT |
Enabled DIS for AtRisk |
SIS-177084 |
Transportation attribute | |
SIS-177217 |
Moved OneRoster IPGC to job | |
SIS-177607 |
DC |
Fixed invalid NCES Code values |
SIS-177911 |
Added Meeting to DIS | |
SIS-177993 |
DE |
Aaddress import quartz job |
SIS-178223 |
IL |
Immunization Rule Update |
SIS-178480 |
MD |
Immunization Rule Update |
SIS-178623 |
Added file type fields to SSRSDistrictReport | |
SIS-178858 |
NC |
TestAccommodations DIS |
SIS-178858 |
NC |
Added TestAccomodations DIS Object |
SIS-178866 |
NC |
Added SpecialEDState DISObject |
SIS-178884 |
Created CDE Sync Quartz Job | |
SIS-178997 |
DE |
Set enrollmentEditorMode to Edit for Pushed Out DE Plans |
SIS-179002 |
DE |
Added SpecialEDState DISObject |
SIS-179082 |
DE |
Renamed homeless service service type |
SIS-179341 |
Added programs to Data Change Tracker | |
SIS-179556 |
NC |
Truncated CourseCode names for State Edition |
SIS-179556 |
NC |
Truncated Course names for District Edition |
SIS-179630 |
Renamed constants in Cartridge Import Error table | |
SIS-179665 |
DE |
Early Learning Program Status Conversion |
SIS-179702 |
NC |
Added missed records to district list |
SIS-179860 |
NC |
Updated RaceEthnicity Preference |
