Technical Information - Release Pack Campus.2223

These cases are included in the Campus.2223 release pack

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

There were no new tables added with this release.

Case Number

Table

Description

SIS-151131

ActivityConfiguration

A configuration set to require activities to go through a preapproval process before an activity can be exposed on the school store.

SIS-151131

ActivityConfigurationForm

A form tied to a configuration that needs to be completed on associated preapprovals.

SIS-151131

ActivityConfigurationInternationalStaff

A staff member associated to a configuration as an international approver.

SIS-151131

ActivityConfigurationSchool

A school associated to a configuration school group.

SIS-151131

ActivityConfigurationSchoolGroup

A school group associated to a configuration.

SIS-151131

ActivityConfigurationStaff

A staff member associated to a configuration as an school/district approver.

SIS-151131

ActivityPreapproval

A preapproval record associated to an activity.

SIS-151131

ActivityPreapprovalForm

A preapproval form record associated to a preapproval and configuration form document.

SIS-151131

ActivityPreapprovalFormApproval

A preapproval form approval record associated to a preapproval form.

SIS-155761

DigitalLearningVendorUpstreamAPIConfiguration

Holds credentials to an API hosted by a digital learning vendor that campus can connect to.

Modified Tables

Because of a recent change to our database, Data Type information is no longer provided for these changes. Please comment at the end of this article if you have any concerns. Thank you!

Added

Case Number

Table

Column

Description

SIS-104581

CampusAttribute

stateOwned

Used to mark campus attributes as state-owned.

SIS-151131

Activity

level

Attribute activity level set on the activity.

SIS-151131

Activity

international

Denotes if a field trip will be international.

SIS-151131

HRPositionCode

activityPreapprover

Indicates if this position is for an activity preapproval approver.

SIS-151680

ApprenticeshipProgram

schoolID

Identifies the school for this program.

SIS-152707

AltProgram

reasonExited

The reason for exiting the program for the year.

SIS-152707

AltProgram

programCode

The code associated with the particular alternative education program.

SIS-152707

AltProgram

programMeetingTime

The time at which the program meets.

SIS-152707

AltProgram

altEdEligibility

Eligibility status for alternate education programs.

SIS-153371

EmploymentAssignment

pdReason

Related to pd class.

SIS-153371

EmploymentAssignment

activityPreapprover

Denotes the staff person as being an activity preapproval approver.

SIS-153371

EmploymentAssignmentHistory

pdReason

Related to pd class.

SIS-153371

EmploymentAssignmentHistory

activityPreapprover

Denotes the staff person as being an activity preapproval approver.

SIS-155431

PlanServiceLog

icd10CodeValue

Code value of the icd10code attribute.

SIS-155431

PlanServiceLog

cptCodeValue

Code value of the cptcode attribute.

SIS-155431

PlanServiceLog

icd10CodeName

Name value of the icd10code attribute.

SIS-155431

PlanServiceLog

cptCodeName

Name value of the cptcode attribute.

SIS-155620

Prenatal

endYear

Year indicator for the prenatal record.

SIS-155620

Prenatal

employmentStatus

The employment status of the mother.

SIS-155620

Prenatal

servicesReceived

The number of services received of the mother.

SIS-155620

Prenatal

educationReceived

The education received of the mother.

SIS-155893

SSRSConfiguration

serverName

Name of user created server.

SIS-155893

SSRSConfiguration

custom

Identifies a user created server.

Data Manipulation Language Scripts (DML)

This section lists scripts to add, modify, query, or remove data from a SQL Server database.

Case NumberStateDescription

SIS-104581


Updated stateOwned field

SIS-136271


Created Feature Toggle For FDF forms to use PDF js

SIS-144574

MI

Converted raceEthnicity

SIS-145498

KY

Added preschool to CustomModule

SIS-151038

WI

Updated SPED Process Alert Rule

SIS-151131


Activity Registration Preapproval MVP

SIS-153525

OH

Immunization Rule Update

SIS-153525

PA

Immunization Rule Update

SIS-153592


Converted Record Type

SIS-154575


Created Account Automation Config Error Notification Type

SIS-154758


Added new element oAuth2.scopesOptional to Preference table

SIS-154837


Fixed MessengerANI type

SIS-155098

NV

Immunization Rule Update

SIS-155466

HI

Immunization Rule Update

SIS-155542


Transferred Old Assessment Tool Rights to New Assessment Tool

SIS-155758

AZ

Updated District List

SIS-155866


Removed new assessment preference

SIS-155992


Updated Nondiscrimination statement