Technical Information - Release Pack Campus.2032

These cases are included in the Campus.2032 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

Case NumberTableDescription

SIS-108367

AdultEd

Identifies student adult ed records.

SIS-108367

AdultEdEL

AdultEd EL records.

SIS-108367

AdultEdExam

AdultEd exam records.

SIS-108367

AdultEdSubtest

AdultEd subtest records.

SIS-138400

BlendedLearningPreference

Saves virtual learning attendance preferences.

SIS-135427

BorderStudent

Stores borderStudent records.

SIS-108367

CustomAdultEd

State reporting table for custom defined attribute values of adultEd record.

SIS-135427

CustomBorderStudent

BorderStudent district elements.

SIS-139067

CustomDailyHealthCheck

Used to store custom defined attribute values of daily health check entries.

SIS-139456

CustomDigitalEquity

DigitalEquity district elements.

SIS-137257

CustomPlanOfStudy

State reporting table for custom defined attribute values of plan of study.

SIS-139067

DailyHealthCheck

Used to store daily health check entries.

SIS-137211

DatabaseChangeTrackingVersionHistory


SIS-139456

DigitalEquity

Digital equity related data.

SIS-139306

GradingWindowGrade

Represents the grades to filter to in a particular gradingwindow. if this table is empty for a particular gw, that gw applies to all grades.

SIS-139306

GradingWindowTask

Represents the tasks in a particular gradingwindow.

SIS-137257

PlanOfStudy

State reporting table for plan of study.

SIS-139175

StudentParticipation

Stores an event of student participation recorded by either a teacher or student.

SIS-138746

TransientProcess

Used to be able to track a process's progress (ie. a batch job initiated from an APIi call) and then removed once completed or before the next process starts (unique index on 'name').

SIS-111766

UserAccountPasswordHistory

Table storing a user's recently used passwords to enforce district password policies.

Modified Tables

Added

Case NumberTableColumnData TypeDescription

SIS-138765

ActivitySchool

sectionID

int

Foreign key to the section that the students will be rostered into.

SIS-138765

ActivitySchool

hasPosted

bit

Notes if the section has already had the students rostered into it.

SIS-138765

ActivitySectionRoster

rosterID

int

Foreign key to the roster table to know that activity registration created this roster record.

SIS-138407

AttendanceExcuse

participationBased

bit

Indicates this excuse is for student participation-based virtual attendance.

SIS-139257

Calendar

secondarySchool

int

Used by NE Ed-Fi to override the school for a given calendar on the student school association and attendance resources.

SIS-138457

Course

college

varchar(15)

College setting for the course.

SIS-138457

CourseCatalog

lockCollege

bit

Indicates lockcollege is locked on a course.

SIS-138457

CourseMaster

college

varchar(15)

College setting for the course.

SIS-131775

DocumentFile

locked

bit

Indicates whether this document is locked and should no longer be editable.

SIS-138765

EmploymentAssignment

activity

bit

Denotes the staff person as being an activity staff.

SIS-138765

EmploymentAssignmentHistory

activity

bit

Denotes the staff person as being an activity staff.

SIS-138765

EmploymentAssignmentHistory

framProcessor

bit

Denotes the staff person as being a FRAM processor for use with household applications and online applications.

SIS-138765

EmploymentAssignmentHistory

responseApprover

bit

Denotes the staff person as being able to approve behavior responses.

SIS-137502

EnrollmentCO

outcomeStatus

bit

Indicates if the student is eligible for the state's alternative assessment.

SIS-138389

EvalGuardian

hideContactInfo

bit

Indicates if the contact information should be hidden.

SIS-138389

EvalStudent

hideContactInfo

bit

Indicates if the contact information should be hidden.

SIS-138457

Gifted

exceptionality

varchar(15)

The exceptionality code for the student.

SIS-139306

GradingWindow

gradingWindowID

int

Identifier

SIS-139306

GradingWindow

startDateTime

smalldatetime

Date and time of day when the grading window open(ed).

SIS-139306

GradingWindow

endDateTime

smalldatetime

Date and time of day when the grading window close(ed).

SIS-138765

HRPositionCode

activity

bit

Indicates if this position is for an activity staff.

SIS-138921

HealthScreeningDental

dentalDisabilityProblem

bit

Does the student have a disability problem.

SIS-138921

HealthScreeningDental

dentalPediatricRef

varchar(15)

Was pediatric dentist recommended.

SIS-138921

HealthScreeningDental

dentalPediatricRefDate

smalldatetime

Date pediatric dentist recommended.

SIS-138921

HealthScreeningDental

dentalMedicalObjection

bit

Does the student have a medical objection.

SIS-138921

HealthScreeningDental

dentalCarieRestoration

varchar(15)

Did the student receive restoration due to caries.

SIS-138921

HealthScreeningDental

dentalFluorideTreatment

varchar(15)

Did the student receive fluoride treatment.

SIS-138921

HealthScreeningDental

dentalSealantsTreatment

varchar(15)

Did the student get sealants.

SIS-138921

HealthScreeningDental

dentalCleaning

varchar(15)

Did the student receive a dental cleaning.

SIS-137502

Homeless

causeOfHousingCrisis2

varchar(20)

Indicates the additional reason for the student's homeless status.

SIS-137502

Homeless

causeOfHousingCrisis

varchar(20)

Indicates the reason for the student's homeless status.

SIS-139156

POSApplication

enhanced

bit

Indication of this application being served as part of POS 2.0 rewrite.

SIS-139156

POSPreference

allergyPopup

bit

Flag used to display allergy warning popup/slide out on a terminal.

SIS-138389

PlanGuardian

hideContactInfo

bit

Indicates if the contact information should be hidden.

SIS-138389

PlanStudent

hideContactInfo

bit

Indicates if the contact information should be hidden.

SIS-139397

PortalOptions

dailyHealthCheck

bit

Flag indicating daily health checks should be available on the portal.

SIS-139397

PortalOptions

immunizations

bit

Flag indicating immunizations should be available on the portal.

SIS-138763

Product

receiptComments

varchar(1000)

Comments to be included in the receipt for a product after purchase.

SIS-139016

ProgramPerson

satelliteProgram

bit

Student is participating in a cte program at a satellite location.

SIS-108367

RecordsTransfer

adultEdXML

varchar(MAX)

Xml representation of the released student's adult ed documents.

SIS-108367

RecordsTransfer

adultEdFOP

varchar(100)

The adult ed rendering object intended to be used in conjunction with the associated XML data.

SIS-138493

SEPTestAccommodationsKY

largePrintCheck

tinyint

Indication student uses large print when taking assessments.

SIS-138493

SEPTestAccommodationsKY

interpDetailText

varchar(8000)

Describes other interpreter accommodation.

SIS-138493

SEPTestAccommodationsKY

readersDetailCheck

tinyint

Indication which reader accommodation student uses when taking assessments.

SIS-138493

SEPTestAccommodationsKY

interpDetailCheck

tinyint

Indication which interpreter accommodation student uses when taking assessments.

SIS-138493

SEPTestAccommodationsKY

calcDetailText

varchar(8000)

Describes other calculator accommodation.

SIS-138493

SEPTestAccommodationsKY

calcDetailCheck

tinyint

Indication which calculator accommodation student uses when taking assessments.

SIS-139227

SchoolStoreSettings

freeStoreEnabled

bit

Boolean indicating for store can be used for $0 products without OLP.

SIS-138389

TeamMember

hideContactInfo

bit

Indicates if the team member's contact information should be hidden.

SIS-135119

TestAccommodations

alternateAssessmentInd

bit

Test accommodation alternateassessmentind option.

SIS-135119

TestAccommodations

printSize

varchar(15)

Test accommodation printsize option.

SIS-135119

TestAccommodations

translatedGlossaryLanguage

varchar(15)

Test accommodation translatedglossarylanguage option.

SIS-135119

TestAccommodations

mousePointerSizeColor

varchar(15)

Test accommodation mousepointersizecolor option.

Altered

Case Number
Table
Column
Data Type
Note
Description

SIS-139045

EdFiErrorLog

termName

varchar(60)

Changed data type from varchar(10) to varchar(60).

Used for errors associated with a term.

SIS-137409

EnrollmentMN

servPercent

varchar(15)

Changed data type from int to varchar(15).

Service hrs percent reported.

SIS-137175

GradingTask

abbreviation

varchar(40)

Changed data type from varchar(20) to varchar(40).

Abbreviation assigned to the standard.

SIS-137502

Graduation

graduationOptions

varchar(20)

Changed data type from varchar(1) to varchar(20).

Indicates the student met graduation requirements.

Deprecated

Case Number
Table
Column
Data Type
Description

SIS-138646

TEDSKY

credentialEarned

varchar(2)

Selection indicates the type of credential earned by the student.

SIS-138646

TEDSKY

tedsIndustryCertificate

varchar(15)

Selected certificate when programming complete.

SIS-138646

TEDSKY

federalIndicator

bit

Indicates the teds record will be federally reported.

SIS-138646

TEDSKY

tedsTerminationStatus

varchar(2)

Status of termination in TEDS.

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-135427


Fixed Foreign Key Typo

SIS-138416


Migrated COVID attendance data into blendedLearningPreference

SIS-137257


Added Grade Level

SIS-139414


Triggered NewNavPreference ES Reindex

SIS-133431

CA

Converted EL and Programs to EL Services

SIS-139531

MD

Immunization Rule Updated

SIS-137510

ID

Immunization Rule Updated

SIS-131775


Updated non-SPED document tab lock rights

SIS-136700

PA

Immunization Rule Updated

SIS-139262

MO

Added district 115930

SIS-138746


Added job for blended learning group auto assign process

SIS-137782


DataValidationDef owner match stateOwned

SIS-139192

TN

Immunization Rule Updated

SIS-139192

TN

Updated HepB-3 code

SIS-137257

KS

LepServiceType updated

SIS-138812


SchoolStorePaymentJob

SIS-138395

KS

Immunization Rule Updated NewErrWrapper

SIS-138407


Removed COVID-19 Scheduled Tasks

SIS-135152

PA

Converted cipCodes

SIS-138407


Added job to post non-participation to attendance

SIS-138457

NC

Added StateGradeLevelDefinitions and Districts

SIS-138998


Added FosterCareBIE to DCT and Audit Tables

SIS-138395

KS

Immunization Rule Updated - NCMT

SIS-138986


Updated enrollmetnType to P when Null

SIS-137502


Converted Enrollments to Homeless Table

SIS-137257


Added PlanOfStudy Table

SIS-135427


Data Conversion for new Border Student Table

SIS-135427


Border Student Data Conversion

SIS-137409


Changeed ServPercent to a string field

SIS-137257


Added Lep Service Types

SIS-137850

MO

Immunization Rule Updated

SIS-108367


Added AdultEd to DIS

SIS-108367


Added AdultEd to DCT

SIS-135359


Disabled CTE Program Associations resource for EdFi 2020 2021

SIS-138395

KS

Immunization Rule Updated

SIS-135298


Updated Column Lengths In Identity

SIS-135298


Converted VisaType and Citizen Fields

SIS-131956


Fixed invalid MessageDeliveryStatus