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 Number | State | Description |
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 |
