This article collects the changes made to the database schema as part of the Campus.2451 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-168838	Organization Renamed table, formerly "Forum"	orgID	int
		orgTypeID	int
		title	nvarchar(80)
		description	nvarchar(max)
		lastPostID	int
		lastPostTimestamp	datetime
		createdPersonID	int
		active	bit
		startTimestamp	smalldatetime
		endTimestamp	smalldatetime
		postToView	bit
		allowArchiveWithoutReplies	bit
		allowEditPublished	bit
		allowParticipantCreateThread	bit
		moderateContent	bit
		archive	bit
		allowFileAttachment	bit
		allowPhotosInPost	bit
		guardianViewer	smallint
		allowParticipantReplyPost	bit
		allowParticipantDeletePost	bit
SIS-168838	OrganizationCurriculum Renamed table, formerly "ForumSystemCI"	orgCurriculumID	int
		orgID	int
		sectionID	int
		subRosterID	int
		allSection	bit
		objectSectionID	int
		objectID	int
SIS-168838	OrganizationType Renamed table, formerly "ForumGroup"	orgTypeID	int
		title	nvarchar(200)
		campusCode	varchar(10)
		context	varchar(50)
		enableCDR	bit
SIS-168838	OrganizationGroup	orgGroupID	int
		orgID	int
		schoolID	int
		name	varchar(50)
		icon	varchar(100)
		color	varchar(20)
		privateGroup	bit
		manualJoinApproval	bit
		enableAccessCode	bit
		accessCode	varchar(20)
		archive	bit
SIS-168838	OrganizationGroupMember	orgGroupMemberID	int
		orgGroupID	int
		personID	int
		moderationLevel	tinyint
		startTimeStamp	datetime2(0)
		endTimeStamp	datetime2(0)
		pendingJoinApproval	bit
SIS-168838	OrganizationMemberSettings	orgMemberSettingsID	int
		orgID	int
		personID	int
		muted	bit
SIS-168838	OrganizationSection	orgSectionID	int
		orgID	int
		sectionID	int
SIS-178770	NCSnapshotLCSCS	ncSnapshotLCSCSID	int
		ncSnapshotLCSCSGUID	uniqueidentifier
		snapshotDate	date
		snapshotPeriod	varchar(12)
		verified	bit
		reviewed	bit
		fatalsCleared	smallint
		createdByID	int
		createdTimestamp	datetime2(0)
		verifiedByID	int
		verifiedTimestamp	datetime2(0)
		districtID	int
		schoolID	int
		endYear	smallint
		classGradeLevel	varchar(4)
		departmentName	varchar(50)
		teacherDuties	varchar(16)
		courseStateID	varchar(20)
		courseName	varchar(30)
		sectionID	int
		sectionNumber	smallint
		staffUID	varchar(20)
		leadTeacher	varchar(103)
		teacherCount	int
		studentCount	int
SIS-178770	NCSnapshotLCSCSA	ncSnapshotLCSCSAID	int
		ncSnapshotLCSCSAGUID	uniqueidentifier
		snapshotDate	date
		snapshotPeriod	varchar(12)
		verified	bit
		reviewed	bit
		fatalsCleared	smallint
		createdByID	int
		createdTimestamp	datetime2(0)
		verifiedByID	int
		verifiedTimestamp	datetime2(0)
		districtID	int
		schoolID	int
		endYear	smallint
		classGradeLevel	varchar(4)
		courseStateCode	varchar(20)
		teacherCount	int
		studentCount	int
		studentTeacherRatio	float
SIS-178770	NCSnapshotLCSPET	ncSnapshotLCSPETID	int
		ncSnapshotLCSPETGUID	uniqueidentifier
		snapshotDate	date
		snapshotPeriod	varchar(12)
		verified	bit
		reviewed	bit
		fatalsCleared	smallint
		createdByID	int
		createdTimestamp	datetime2(0)
		verifiedByID	int
		verifiedTimestamp	datetime2(0)
		districtID	int
		schoolID	int
		endYear	smallint
		courseStateID	varchar(20)
		courseName	varchar(30)
		staffUID	varchar(20)
		teacherName	varchar(103)
SIS-179356	OwlErrorLog	errorLogID	int
		owlType	varchar(255)
		owlJSON	nvarchar(max)
		otherDistrictGUID	uniqueidentifier
		sentOrReceived	char(1)
		errorMessage	nvarchar(max)
		eventTimestamp	datetime2(2)
		poolName	varchar(255)
SIS-179487	CrossSiteConstraintDistrictAccept	csConstraintDistrictAcceptID	int
SIS-179487	CrossSiteConstraintDistrictAccept	peerID	int
SIS-182314	StaffEdOrgVacancy	vacancyID	int
		modifiedByID	int
		modifiedDate	date
		organizationEdFiID	varchar(20)
		districtNumber	varchar(12)
		endYear	smallint
		bilingualEducation40D	smallint
		counselor40D	smallint
		elementaryEducation40D	smallint
		elementaryPrincipal40D	smallint
		generalEducation40D	smallint
		secondaryMathematics40D	smallint
		secondaryPrincipals40D	smallint
		secondaryScience40D	smallint
		socialWorkers40D	smallint
		specialEducation40D	smallint
		bilingualEducation80D	smallint
		counselor80D	smallint
		elementaryEducation80D	smallint
		elementaryPrincipal80D	smallint
		generalEducation80D	smallint
		secondaryMathematics80D	smallint
		secondaryPrincipals80D	smallint
		secondaryScience80D	smallint
		socialWorkers80D	smallint
		specialEducation80D	smallint
		bilingualEducation120D	smallint
		counselor120D	smallint
		elementaryEducation120D	smallint
		elementaryPrincipal120D	smallint
		generalEducation120D	smallint
		secondaryMathematics120D	smallint
		secondaryPrincipals120D	smallint
		secondaryScience120D	smallint
		socialWorkers120D	smallint
		specialEducation120D	smallint
		bilingualEducationEOY	smallint
		counselorEOY	smallint
		elementaryEducationEOY	smallint
		elementaryPrincipalEOY	smallint
		generalEducationEOY	smallint
		secondaryMathematicsEOY	smallint
		secondaryPrincipalsEOY	smallint
		secondaryScienceEOY	smallint
		socialWorkersEOY	smallint
		specialEducationEOY	smallint
SIS-182553	AppCacheReloadHistory	reloadCacheID	int
		personID	int
		personName	varchar(255)
		reloadTime	datetime2(2)
SIS-183382	PaymentVendorEvents	eventID	int
		vendorEventRef	varchar(100)
		eventDateTime	datetime2(0)
		eventDesc	varchar(50)
		eventType	varchar(50)
		eventSubjectRef	varchar(100)
		processedDateTime	datetime2(0)
		createdDateTime	datetime2(0)

Deprecated Tables

Case Number	Table
SIS-168838	ForumPersonAccess

Deleted Tables

Case Number	Table
SIS-180817	SAMLAction
SIS-180817	SAMLConfig
SIS-180817	SAMLTemplate

Modified Tables

Added Columns

Ordered by Table Name.

Case Number	Table	Column	Data Type
SIS-184174	Attendance	reconciledByServing	bit
SIS-183283	BehaviorType	standardizedEventCode	varchar(15)
SIS-168838	DiscussionFile	wysiwygFile	bit
SIS-184100	EnrollmentIA	credential1	varchar(20)
SIS-180713	EvalChecklistParticipant	check2	tinyint
SIS-183293	ExtendedLearningOpportunity	totalProgramDays	decimal(5,2)
SIS-168838	ForumPost	orgID (renamed column from ForumPost.forumID)	int
SIS-168838	ForumPost	authorRole	varchar(1)
SIS-168838	ForumThread	orgID (renamed column from ForumThread.forumID)	int
SIS-168838	ForumThread	stickyTimestamp	datetime2(0)
SIS-168838	ForumWatch	orgID (renamed column from ForumWatch.forumID)	int
SIS-183136	HealthScreeningTuberculosis	tbRiskAssessment	varchar(15)
SIS-183136	HealthScreeningTuberculosis	tbRiskAssCompletedBy	varchar(15)
SIS-183378	NCSnapshotGRSSummary	gradeGrouping	varchar(100)
SIS-173818	PaymentDepositAccount	reviewRef	varchar(50)
SIS-173818	PaymentDepositAccount	documentationFileName	varchar(100)
SIS-173818	PaymentDepositAccount	documentationRef	varchar(50)
SIS-173818	PaymentDepositAccount	documentationDateTime	datetime2(0)
SIS-173818	PaymentDepositAccount	reviewDenialReason	varchar(30)
SIS-183382	PaymentVendorAccount	terminalConfigRef	varchar(30)
SIS-183382	PaymentVendorAccount	accountStatus	varchar(20)
SIS-168838	PortalDisplayOptions	sectionFeed	bit
SIS-168838	PortalDisplayOptions	sectionFeedStudentComments	bit
SIS-168838	PortalDisplayOptions	sectionFeedStudentNames	bit
SIS-177827	SchoolAttribute	charterStatus	varchar(15)
SIS-180713	SEPGenericForm	varChar2	varchar(8000)
SIS-180713	SEPGenericForm	varChar3	varchar(8000)
SIS-180713	SEPGenericForm	varChar4	varchar(8000)
SIS-180713	SEPReportingProgress	otherVal2	varchar(150)
SIS-180713	SEPReportingProgress	methodText2	varchar(500)
SIS-168838	TeacherPreference	sectionFeedDisplayStudentComments	bit
SIS-168838	TeacherPreference	sectionFeedDisplayStudentNames	bit

Altered Columns

Ordered by Table Name.

Case Number	Table	Column	Data Type
SIS-179487	CrossSiteNotificationRecipient	schoolID	int
SIS-173818	PaymentDepositAccount	paymentBankAccountRef	varchar(50)
SIS-173818	PaymentDepositAccount	tokenID	varchar(50)
SIS-180713	SEPReportingProgress	otherVal	varchar(150)

Deprecated Columns

Ordered by Table Name.

Case Number	Table	Column
SIS-168838	ForumPost	title
SIS-168838	OrganizationCurriculum	subRosterID
SIS-168838	OrganizationCurriculum	allSection

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-143709		Updated the grading window notification type
SIS-168838		Populated lastPostTimestamp and lastPostID
SIS-168838		Updated OrganizationTypes
SIS-172116		Cleared store image description metadata
SIS-174032	MO	Updated CIP code
SIS-178770	NC	Added Feature Toggle Preference for LCS Extract
SIS-178770	NC	Added NCSnapshotLCSSummary DISObject
SIS-179633	NV	Converted virtual checkbox to droplist
SIS-182928	NJ	Special Ed conversion
SIS-183281		Updated to Ferpa
SIS-183283		Migrated regionalEventCode to standardizedEventCode in the dbo.BehaviorType table
SIS-183378	NC	Added missing grs gradelevel summary records
SIS-183382		Payments Event Job
SIS-183382		Stripe Vendor Configuration
SIS-183491	ND	Populated StateGradeLevel County and District tables
SIS-183493	NY	Enrollment State End Status code incorrect
SIS-183668	OR	Converted Tribal Codes
SIS-183679	MO	Added 999420 and 999419 to attending district
SIS-183679	MO	Added 999420 Monaco Success Academy in Calhoun to transfer district
SIS-183685	MN	Immunization Rule Update
SIS-183979	NC	Added attendance code 1T
SIS-184026	NC	Migrant data cleanup
SIS-184396		Enabled CSE for 13 more states

Technical Information - Release Pack Campus.2451

Data Definition Language Scripts (DDL)

New Tables

Deprecated Tables

Deleted Tables

Modified Tables

Added Columns

Altered Columns

Deprecated Columns

Data Manipulation Language Scripts (DML)

Related Articles