This article collects the changes made to the database schema as part of the Campus.2419 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	Data Type
SIS-165560	ActivityClearedRoster	activityClearedRosterID	int
		personID	int
		activitySectionID	int
		createdDate	datetime2(0)
		productSaleID	int
		deletedByID	int
		activityClearedRosterBatchID	int
SIS-165560	ActivityClearedRosterBatch	activityClearedRosterBatchID	int
		activitySectionID	int
		createdDate	datetime2(0)
		removedComment	varchar(1000)
SIS-171791	Tuition	tuitionID	int
		tuitionGroupID	int
		description	varchar(120)
		name	varchar(50)
		tuitionAmount	decimal(9,2)
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-171791	TuitionAdjustment	tuitionAdjustmentID	int
		tuitionGroupID	int
		personID	int
		amount	decimal(9,2)
		adjustmentDate	date
		comments	varchar(255)
		description	varchar(120)
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-171791	TuitionAssignment	tuitionAssignmentID	int
		tuitionID	int
		tuitionPaymentPlanID	int
		personID	int
		createdByID	int
		createdDate	date
SIS-171791	TuitionDiscount	tuitionDiscountID	int
		tuitionGroupID	int
		name	varchar(50)
		description	varchar(120)
		discountType	varchar(50)
		discountAmountType	varchar(7)
		discountAmount	decimal(9,2)
		multiStudentType	varchar(50)
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-171791	TuitionDiscountAssignment	tuitionDiscountAssignmentID	int
		tuitionDiscountID	int
		tuitionDiscountMultiStudentID	int
		personID	int
		createdByID	int
		createdDate	date
SIS-171791	TuitionDiscountMultiStudent	tuitionDiscountMultiStudentID	int
		tuitionDiscountID	int
		name	varchar(50)
		tierAmountType	varchar(7)
		tierAmount	decimal(9,2)
		afterStudents	int
SIS-171791	TuitionFee	tuitionFeeID	int
		tuitionID	int
		name	varchar(50)
		tuitionFeeAmount	decimal(9,2)
SIS-171791	TuitionGroup	tuitionGroupID	int
		name	varchar(50)
		endYear	smallint
		description	varchar(120)
		effectiveDate	date
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-171791	TuitionPaymentPlan	tuitionPaymentPlanID	int
		tuitionGroupID	int
		name	varchar(50)
		description	varchar(120)
		discountAmountType	varchar(7)
		discountAmount	decimal(9,2)
		adminFeeAmountType	varchar(7)
		adminFeeAmount	decimal(9,2)
		numberOfPayments	smallint
		allowRecurringPayments	bit
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-171791	TuitionPaymentPlanDate	tuitionPaymentPlanDateID	int
		tuitionPaymentPlanID	int
		paymentNumber	smallint
		paymentDueDate	date
SIS-171791	TuitionRelatedDocument	tuitionRelatedDocumentID	int
		tuitionID	int
		documentID	int
SIS-171791	TuitionScholarship	tuitionScholarshipID	int
		tuitionGroupID	int
		name	varchar(50)
		description	varchar(120)
		scholarshipType	varchar(50)
		scholarshipAmountType	varchar(7)
		scholarshipAmount	decimal(9,2)
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-171791	TuitionScholarshipAssignment	tuitionScholarshipAssignmentID	int
		tuitionScholarshipID	int
		personID	int
		createdByID	int
		createdDate	date
SIS-171791	PaymentFundTuition	paymentFundTuitionID	int
SIS-171791	PaymentFundTuition	fundAccountID	int
SIS-172917	ComEdSchedule	comEdScheduleID	int
		type	varchar(2)
		scheduleName	varchar(50)
		code	varchar(2)
SIS-172917	DependentCareApplication	dependentCareApplicationID	int
		personID	int
		dependentCareSessionProgramID	int
		userID	int
		submittedBy	varchar(102)
		firstAttendanceDate	date
		lastAttendanceDate	date
		submitDate	datetime2(0)
		status	varchar(10)
SIS-172917	DependentCareApplicationForm	dependentCareApplicationFormID	int
		dependentCareApplicationID	int
		dependentCareSessionFormID	int
		formID	int
SIS-172917	DependentCareApplicationSchedule	dependentCareApplicationScheduleID	int
		dependentCareApplicationID	int
		dependentCareSessionSectionID	int
		monday	bit
		tuesday	bit
		wednesday	bit
		thursday	bit
		friday	bit
		scheduleCode	varchar(2)
SIS-172917	DependentCareAuthorizedPickup	dependentCareAuthorizedPickupID	int
		dependentCareApplicationID	int
		fullName	varchar(102)
		relationship	varchar(50)
		guardian	bit
		homePhone	varchar(25)
		workPhone	varchar(25)
		cellPhone	varchar(25)
		authorized	bit
SIS-172917	DependentCareSession	dependentCareSessionID	int
		sessionName	varchar(50)
		comEdScheduleID	int
		enrollmentStartDate	datetime2(0)
		enrollmentEndDate	datetime2(0)
		sessionStartDate	date
		sessionEndDate	date
		federalTaxID	varchar(9)
		infoBox1	varchar(max)
		minNumberDays	int
SIS-172917	DependentCareSessionCharge	dependentCareSessionChargeID	int
		dependentCareSessionID	int
		chargeName	varchar(50)
		active	bit
		amount	decimal(7,2)
SIS-172917	DependentCareSessionDiscount	dependentCareSessionDiscountID	int
		dependentCareSessionID	int
		discountName	varchar(50)
		active	bit
		flatAmount	decimal(7,2)
		percentAmount	decimal(7,2)
SIS-172917	DependentCareSessionExclusionDate	dependentCareSessionExclusionDateID	int
		dependentCareSessionID	int
		exclusionDate	date
SIS-172917	DependentCareSessionForm	dependentCareSessionFormID	int
		dependentCareSessionID	int
		documentID	int
		required	bit
SIS-172917	DependentCareSessionProgram	dependentCareSessionProgramID	int
		dependentCareSessionID	int
		programName	varchar(50)
		siteName	varchar(50)
		scheduleCode	varchar(2)
		maximumParticipants	int
SIS-172917	DependentCareSessionSection	dependentCareSessionSectionID	int
		dependentCareSessionProgramID	int
		sectionName	varchar(50)
		chargePerDayOne	decimal(7,2)
		chargePerDayTwo	decimal(7,2)
		chargePerDayThree	decimal(7,2)
		chargePerDayFour	decimal(7,2)
		chargePerDayFive	decimal(7,2)
SIS-172917	PaymentFundDependentCare	paymentFundDependentCareID	int
SIS-172917	PaymentFundDependentCare	fundAccountID	int
SIS-174334	TNEIS052History	tnEIS052HistoryID	int
		tnEISBatchTransmissionLogID	int
		enrollmentID	int
		keyHashValue	binary
		updateHashValue	binary
		recordVersion	varchar(2)
		recordType	varchar(1)
		districtNum	varchar(3)
		schoolNum	varchar(4)
		schoolYear	varchar(4)
		instructionalProgramNumber	varchar(2)
		studentSocialSecurityNumber	varchar(9)
		studentPIN	varchar(9)
		localStudentKey	varchar(10)
		clubID	varchar(15)
		clubMembershipBeginDate	varchar(8)
		clubMembershipEndDate	varchar(8)
		stateAssignedStudentID	varchar(9)
		ctsoChapterID	varchar(20)
		ctsoMembershipID	varchar(9)
		formattedOutput	varchar(8000)
SIS-176031	SRTCloudRecord	srtCloudRecordID	int
		releasingFileID	int
		requestingFileID	int
		requestedPersonID	int
		fileName	varchar(100)
SIS-176300	MedicaidEligibility	medicaidEligibilityID	int
		personID	int
		districtID	int
		medicaidEligibilityGUID	uniqueidentifier
		updateMonth	varchar(15)
		updateYear	varchar(4)
		eligibilityMonth	varchar(15)
		eligibilityYear	varchar(4)
		eligibility	bit
SIS-176227	ProductStateEditionLicense	productStateEditionLicenseID	int
		productID	int
		startDate	datetime2(0)
		endDate	datetime2(0)
SIS-176398	IMAssessmentDeleted	objectID	int
		teacherInstructions	nvarchar
		studentInstructions	nvarchar
		cutScore	decimal(18,6)
		assessmentID	int
		displayFeedback	int
SIS-176398	IMAssessmentItemDeleted	assessmentItemID	int
		partID	int
		itemID	int
		seq	int
		randomizeResponses	bit
SIS-176398	IMAssessmentPartDeleted	partID	int
		objectID	int
		seq	smallint
		name	varchar(50)
		htmlContent	nvarchar
		randomizeItems	tinyint
		cutScore	decimal(18,6)
		minQuestions	int
		alignmentCode	varchar(60)
SIS-176398	IMItemDeleted	objectID	int
		itemType	varchar(10)
		scoringGuide	nvarchar
		randomizeResponses	tinyint
		instructions	nvarchar
		selectedResponse	bit
		points	decimal(18,6)
SIS-176398	IMItemInteraction	interactionID	int
		objectID	int
		seq	smallint
SIS-176398	IMItemResponseDeleted	itemResponseID	int
		objectID	int
		seq	smallint
		correct	bit
		name	varchar(100)
		htmlContent	nvarchar
		pointsFraction	decimal(18,6)
		feedbackText	nvarchar
		matchingValue	nvarchar
		previousItemResponseID	int
SIS-176398	IMItemScoreGuide	itemScoreGuideID	int
		objectID	int
		seq	int
		pointsFraction	decimal(18,6)
		partialGrading	bit
SIS-176398	IMItemScoreGuideResponse	itemScoreGuideResponseID	int
		itemScoreGuideID	int
		responseSeq	int
		interactionSeq	int
		correctSeq	int
		numericValue	decimal(18,6)
		maximumValue	decimal(18,6)
		minimumValue	decimal(18,6)
SIS-176924	CampusEventPublishHistory	historyID	int
		districtID	int
		eventID	int
		eventGUID	uniqueidentifier
		eventStatus	int
		eventTimestamp	datetime2(0)
SIS-177209	EnrollmentNC	enrollmentID	int
		calendarID	int
		personID	int
		admissionStatus	varchar(15)
SIS-177713	CustomFERPA	customID	int
		attributeID	int
		ferpaID	int
		value	varchar(256)
		date	date
SIS-177713	FERPA	ferpaID	int
		personID	int
		districtID	int
		ferpaGUID	uniqueidentifier
		modifiedByID	int
		modifiedDate	date
		startDate	date
		endDate	date
		schoolYear	varchar(15)
		changesMadeBy	varchar(15)
		programStatus	varchar(15)
		createdDate	date
		comments	varchar(255)
		directoryQuestion	varchar(15)
		militaryQuestion	varchar(15)
		collegesQuestion	varchar(15)
		actQuestion	varchar(15)
SIS-178054	CustomTransportationRequest	customID	int
		attributeID	int
		value	varchar(256)
		transportationRequestID	int
SIS-178054	CustomTransportationRoute	customID	int
		attributeID	int
		value	varchar(256)
		transportationRouteID	int
SIS-178054	TransportationAccommodation	transportationAccommodationID	int
		personID	int
		attributeID	int
		value	varchar(15)
SIS-178054	TransportationRequest	transportationRequestID	int
		personID	int
		status	varchar(20)
		requestComments	varchar(120)
		startDate	date
		endDate	date
		dueDate	date
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-178054	TransportationRequestAccommodation	TransportationRequestAccommodationID	int
		transportationRequestID	int
		attributeID	int
		value	varchar(15)
SIS-178054	TransportationRequestDetail	transportationRequestDetailID	int
		transportationRequestID	int
		routeTypeCode	varchar(15)
		pickupLocation	varchar(120)
		pickupTime	time(7)
		dropoffLocation	varchar(120)
		dropoffTime	time(7)
		monday	bit
		tuesday	bit
		wednesday	bit
		thursday	bit
		friday	bit
		saturday	bit
		sunday	bit
SIS-178054	TransportationRequestRelation	transportationRequestRelationID	int
		transportationRequestID	int
		transportationRouteID	int
SIS-178054	TransportationRoute	transportationRouteID	int
		transportationRouteGUID	uniqueidentifier
		personID	int
		routeName	varchar(50)
		routeTypeCode	varchar(15)
		startDate	date
		endDate	date
		busID	int
		stopNumber	varchar(15)
		comments	varchar(120)
		pickupLocation	varchar(120)
		pickupTime	time(7)
		dropoffLocation	varchar(120)
		dropoffTime	time(7)
		monday	bit
		tuesday	bit
		wednesday	bit
		thursday	bit
		friday	bit
		saturday	bit
		sunday	bit
		milesTransported	decimal(9,2)
		importFlag	bit
		lastSyncTimestamp	datetime2(0)
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date
SIS-178054	TransportationRouteAccommodation	transportationRouteAccommodationID	int
		transportationRouteID	int
		attributeID	int
		value	varchar(15)
SIS-178054	TransportationStudentDetail	transportationStudentDetailID	int
		attributeID	int
		value	varchar(256)
		personID	int
		enrollmentID	int
		startDate	date
		endDate	date
		comments	varchar(120)
		createdByID	int
		createdDate	date
		modifiedByID	int
		modifiedDate	date

Modified Tables

Added

Case Number	Table	Column	DataType
SIS-177938	Address	development	varchar(255)
SIS-177938	Address	municipality	varchar(255)
SIS-177938	Address	externalGUID	varchar(255)
SIS-177602	AtRisk	assessmentUsed	varchar(150)
SIS-177017	BehaviorEvent	bullyingEvent	bit
SIS-177017	BehaviorEvent	bullyingReason	varchar(15)
SIS-176924	CampusEvent	eventGUID	uniqueidentifier
SIS-176924	CampusEvent	stateOwned	bit
SIS-176924	CampusEvent	syncStatus	varchar(1)
SIS-176924	CampusEventAction	actionGUID	uniqueidentifier
SIS-176924	CampusEventProcedure	stateOwned	bit
SIS-177666	CareerTechnicalEducation	wblCIPCode	varchar(15)
SIS-148723	DigitalLearningVendorOAuth2ClientCredentials	useSecondaryEmail	bit
SIS-177721	EarlyEducationMN	enrollmentID	int
SIS-171791	HouseholdMember	tuition	bit
SIS-176398	IMAssessmentPart	parentPartID	int
SIS-176398	IMItem	minValue	decimal(18,6)
SIS-176398	IMItem	maxValue	decimal(18,6)
SIS-176398	IMItem	threshold	decimal(18,6)
SIS-176398	IMItem	nonUniqueAnswers	bit
SIS-176398	IMItem	subType	varchar(20)
SIS-176398	IMItem	tickSpacing	decimal(18,6)
SIS-176398	IMItem	multipleAnswers	bit
SIS-176398	IMItem	labelFrequency	int
SIS-176398	IMItem	exactMatch	bit
SIS-176398	IMItem	snapToTick	bit
SIS-176398	IMItem	partialCredit	bit
SIS-176398	IMItem	wordLimit	int
SIS-176398	IMItemResponse	interactionID	int
SIS-176398	IMItemResponse	numericValue	decimal(18,6)
SIS-176398	IMResponseItem	numericValue	decimal(18,6)
SIS-176398	IMResponseItem	interactionID	int
SIS-176398	IMResponseItemResponse	orderSeq	int
SIS-176398	IMResponseItemScore	responseID	int
SIS-176398	IMResponseItemScore	objectID	int
SIS-176398	IMResponseItemScore	scoreFeedback	varchar(255)
SIS-177670	Identity	languageAlt4	varchar(5)
SIS-177670	Identity	languageAlt3	varchar(5)
SIS-173744	Lep	assessmentUsedOverride	varchar(15)
SIS-173744	Lep	englishProficiencyOverride	varchar(15)
SIS-177366	Print	nonStandardExclude	bit
SIS-176227	ProductDefinition	usesStateEditionLicense	bit
SIS-176031, SIS-176925	RecordsTransfer	title1XML	varchar(max)
SIS-176031, SIS-176925	RecordsTransfer	cloudFileXML	varchar(max)
SIS-176031, SIS-176925	RecordsTransfer	title1FOP	varchar(100)
SIS-171791	RelatedPair	tuition	bit
SIS-177663	SEPlan	hsTransitionProgram	bit
SIS-177567	SpecialEDState	ecReferral	varchar(200)
SIS-177567	SpecialEDState	ecAccommodation	varchar(200)
SIS-176925	Title1	createdDate	date
SIS-171603	TranscriptCourse	stateReportExclude	bit
SIS-176082	YouthProgram	residentialTreatment	varchar(15)

Altered

Case Number	Table	Column	DataType
SIS-177828	Enrollment	dropoutCode	varchar(15)
SIS-176398	IMItem	numericValue	decimal(18,6)
SIS-176398	IMResponseItem	value	vachar(max)
SIS-176398	IMResponseItemResponse	selectedMatchingValue	nvarchar(max)
SIS-177213	PlanServiceProvided	serviceFreqPeriod	varchar(100)

Deprecated

Case Number	Table	Column
SIS-176398	IMItem	selectedResponse
SIS-176398	IMItem	instructions
SIS-176398	IMItem	scoringGuide
SIS-176398	IMItemResponse	objectID
SIS-176398	IMItemResponse	correct
SIS-176398	IMItemResponse	pointsFraction
SIS-176398	IMItemResponse	name
SIS-176398	IMResponseItem	itemID
SIS-176398	IMResponseItemScore	responseItemID
SIS-176398	IMResponseItemScore	taskID
SIS-176398	IMResponseItemScore	itemBank

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-177598		Update status to not required
SIS-177665		Converted CTE cipCodes
SIS-177912		Removed require field enforcement on title 1 program field
SIS-178171		Offset incorrect transaction fee reversals
SIS-177510	MO	Removed Ed-Fi locations resource
SIS-177437	WY	Immunization Rule Update
SIS-171014		CTE Student Org Converstion
SIS-178098		Added cmqHealthCheck quartz job
SIS-177913	DE	Enabled migrant
SIS-178073	NC	Updated distict table
SIS-176082	UT	Added residential facility to YouthProgram
SIS-176388	CT	Immunization Rule Update
SIS-178073	NC	Updated State Grade Levels
SIS-177406	NC	Added Migrant DIS Object
SIS-172917		Inserted campus schedules for DC
SIS-172917		Created a core dependent care custom module
SIS-172917		Created Feature Toggle Depedent Care
SIS-148723		Default useSecondayEmail when oneRoster preference enabled
SIS-176398		Quiz to Assessment Conversion
SIS-177730	DE	Enabled StudentAssignment to true in Preference
SIS-177368		Updated negative section numbers for trials in this year and beyond
SIS-175055	OH	Deactivated District Service
SIS-177209	NC	Updated enrollment attributes.bak
SIS-177209	NC	Updated enrollment attributes
SIS-167941	CO	Converted BehaviorResolution fields
SIS-171791		Added tuition preference

Technical Information - Release Pack Campus.2419