Technical Information - Release Pack Campus.2016

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

ContentSecurityPolicy

Stores campus default and custom content security policies.

SIS-125885

ContentSecurityPolicyReport

Stores campus content security policy report violations.

SIS-135521

CustomNativeAmericanEligibility

A place for users to store additional Native American eligibility information

SIS-135521

CustomSupplementalServices

Supplemental services district elements.

SIS-135521

NativeAmericanEligibility

Student Native American eligibility data.

SIS-135521

SupplementalServices

Identifies supplemental services for a student.

Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-121513

AdHocFilter

forceOrder

bit

The field records whether the filter should be executed with the force order query hint.

SIS-132255

Calendar

foodServiceEnrollOverride

smallint

Indicates the calendar will allow enrollment override for the food service edit check report.

SIS-129605

EnrollmentMT

jobCorpsFall

bit

Indicator of participation in job corps during the fall attendance count window.

SIS-129605

EnrollmentMT

mtYouthChallengeFall

bit

Indicator of participation in mt youth challenge during the fall attendance count window.

SIS-129605

EnrollmentMT

kgUnder5Fall

smalldatetime

Tracks the board approval date for under age kindergarten students during the fall attendance count window.

SIS-129605

EnrollmentMT

kgUnder5Spring

smalldatetime

Tracks the board approval date for under age kindergarten students during the spring attendance count window.

SIS-129605

EnrollmentMT

mtYouthChallengeSpring

bit

Indicator of participation in mt youth challenge during the spring attendance count window.

SIS-129605

EnrollmentMT

indianLangPrgFall

bit

Indicator of a student participating in an Indian language immersion program during the fall attendance count window.

SIS-129605

EnrollmentMT

jobCorpsSpring

bit

Indicator of participation in job corps during the spring attendance count window.

SIS-134532

EvalEditor

editorType

varchar(10)

UI editor type for the document angular app. acceptable values are flat, list, refresh, nested.

SIS-134532

EvalEditor

apiPath

varchar(200)

Campus rest API base path associated with this editor.

SIS-134532

EvalEditor

allowNotNeeded

bit

Allows the use of the not needed button within the document angular app.

SIS-134532

EvalEditor

manualEditorCard

bit

Determines if the elements card needs to be constructed manually for this editor.

SIS-134532

EvalEditor

parentCode

varchar(100)

Relates a nested editor to a parent plan editor.

SIS-134532

EvalEditor

keyName

varchar(100)

The primary key associated with the editor table mapping.

SIS-134532

EvalEditor

routeName

varchar(100)

The route name for editor in the the document angular app.

SIS-134532

EvalEditor

componentName

varchar(50)

Angular component name in the document angular app.

SIS-134532

EvalSectionStatus

objectID

int

References a table key for uniqueness for sections that have child records.

SIS-134532

EvalState

districtSpedAddress

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

districtSpedContactFirstNameAlt

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

districtPhone

varchar(25)

Snapshot from district table.

SIS-134532

EvalState

districtContactLastName

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

schoolYear

varchar(10)

The enrollment school year that relates to the evaluation.

SIS-134532

EvalState

districtSpedCity

varchar(25)

Snapshot from district table.

SIS-134532

EvalState

districtSpedContactLastNameAlt

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

districtAddress

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

districtSpedState

varchar(2)

Snapshot from district table.

SIS-134532

EvalState

districtContactFirstName

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

districtSpedContactLastName

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

districtUrl

varchar(100)

Snapshot from district table.

SIS-134532

EvalState

districtSpedPhone

varchar(25)

Snapshot from district table.

SIS-134532

EvalState

districtEmail

varchar(100)

Snapshot from district table.

SIS-134532

EvalState

stateDefinedDate

datetime2

A date to hold state defined data.

SIS-134532

EvalState

districtZip

varchar(10)

Snapshot from district table.

SIS-134532

EvalState

districtCity

varchar(25)

Snapshot from district table.

SIS-134532

EvalState

districtSpedContactFirstName

varchar(50)

Snapshot from district table.

SIS-134532

EvalState

districtSpedPhoneAlt

varchar(25)

Snapshot from district table.

SIS-134532

EvalState

districtSpedZip

varchar(10)

Snapshot from district table.

SIS-134532

EvalState

serviceSchoolCode

varchar(15)

The school code for the servicing school.

SIS-134532

EvalState

districtState

varchar(2)

Snapshot from district table.

SIS-134532

EvalType

elements

bit

Indicates this plan type is loaded into the document elements app.

SIS-135126

Gifted

acceleratedPlacement

varchar(15)

Means the practice of assigning a student to a specific content area at a higher instructional level than is typical given the student's grade.

SIS-135126

Gifted

giftedTest

varchar(15)

Gifted children who give evidence of high performance capability.

SIS-136286

Print

archive

bit

Indicates this print format should no longer be accessible/used and is hidden from UI.

SIS-135961

Product

defaultComments

varchar(500)

Default comments to be displayed to user.

SIS-135961

Product

variableRate

bit

Indicates if product can have a price determined by a consumer.

SIS-135961

ProductItem

seq

int

Sequence used to order items on the customer display.

SIS-135961

ProductSale

pickedUp

bit

Indicates if product from sale has been picked up.

SIS-134532

SEEProgress

reEvaluation

varchar(8000)

This table is used in special education evaluations.

SIS-134532

SEEProgress

seq

tinyint

Sequence number used to manually order records.

SIS-134532

SEEProvideToParent

documentProvided1

bit

Copy of the document provided to parents.

SIS-134532

SEEProvideToParent

documentProvided3

bit

Copy of the document provided to parents.

SIS-134532

SEEProvideToParent

providedMethod3

bit

Provided method documents were delivered.

SIS-134532

SEEProvideToParent

providedMethod2

bit

Provided method documents were delivered.

SIS-134532

SEEProvideToParent

dateProvided

datetime2

Date a copy of the special ed evaluation is provided to parents.

SIS-134532

SEEProvideToParent

documentProvided4

bit

Copy of the document provided to parents.

SIS-134532

SEEProvideToParent

providedMethod4

bit

Provided method documents were delivered.

SIS-134532

SEEProvideToParent

providedMethod1

bit

Provided method documents were delivered.

SIS-134532

SEEProvideToParent

print

bit

Whether to print this data in the evaluation.

SIS-134532

SEEProvideToParent

documentProvided2

bit

Copy of the document provided to parents.

SIS-134532

SEEProvideToParent

providedMethodOther

varchar(8000)

Specify the method provided.

SIS-134532

SEEProvideToParent

documentProvidedOther

varchar(8000)

Specify the document provided.

SIS-134532

SEETeamMember

comments

varchar(8000)

Additional team member comments.

SIS-134612

SpecialEDState

recordedDate

datetime2

Date the user supplies to indicate when the record was entered.

SIS-134612

SpecialEDState

exitDate

datetime2

Date the student exited from special education programming.

Altered

Case Number

Table

Column

Data Type

Description

SIS-135762

CurriculumStandard

name

nvarchar

User defined name of this standard.

SIS-136051

EdFiErrorLog

gradingTaskName

nvarchar

Used for errors associated with a grading task.

SIS-132438

Evaluation

physicianPhone

varchar(22)

Student's physician phone.

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

SIS-136051

GradingTask

name

nvarchar

Name assigned to the grading task.

SIS-135961

Product

description

varchar(MAX)

Product description.

Changed data type from varchar(1000) to varchar(MAX).

SIS-55428

SecurityAccess

name

varchar(128)

If the remote IP can be matched to a user, his/her name (last name, first name, middle initial) will be displayed.

Changed data type from varchar(75) to varchar(128).

SIS-136051

TranscriptCourse

standardName

nvarchar

State or district-defined standardname for this course.

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-133444

MA

SIF was not sending correct Ed Services Code.

SIS-136512

WI

Added value to unlocked Day eventType dictionary.

SIS-136511


COVID-19 Campus Attribute.

SIS-134612

MT

Data Conversion Enrollment To SpecialEdState.

SIS-134612


Added SpecialEDState DIS Object.

SIS-136511


COVID-19 Attendance ScheduledTasks.

SIS-135762


Increased curriculum standard name length.

SIS-135984

CA

Converted graduation postsecondaryStatus to multiselect.

SIS-134907


PartialReturned payment state.

SIS-124022

MD

Conversion of gifted flags to Enrollment.giftedTalented.

SIS-135376


OLPBadPaymentsIdentifierJob.

SIS-131823

WI

Inactive edfiResourcePreferences based on config profile.

SIS-135976

MN

Immunization Rule Update.

SIS-136086


Created a core field trip custom module.

SIS-134086


New Recurring Payment Frequencies.

SIS-135771


Expanded length of standard and standard group names.

SIS-134659

IN

Immunization Rule Update.

SIS-135478


Copied existing tool rights to new copy tools.

SIS-135178


Enrollment converted bits to not null.

SIS-55428


Updated SecurityAccess name to varchar 128.

SIS-125885


Created CspReportCleanUpJob.

SIS-125885


CSP preference creation.