Technical Information - Release Pack Campus.2004

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

Table

Description

SIS-133589

RegisteredToolHierarchy

Navigation tool hierarchy of registered application, product, or optional feature

Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-131856

Contact

photoOptIn

varchar(15)

Used to determine if photo should be shown in state edition.

SIS-133109

EnrollmentVT

preKindergartenID

varchar(10)

Pre-Kindergarten organization ID.

SIS-117145

HealthScreeningDental

examiner

varchar(50)

Who performed the screening.

SIS-117145

HealthScreeningGrowth

examiner

varchar(50)

Who performed the screening.

SIS-117145

HealthScreeningHearing

examiner

varchar(50)

Who performed the screening.

SIS-117145

HealthScreeningScoliosis

examiner

varchar(50)

Who performed the screening.

SIS-117145

HealthScreeningVision

examiner

varchar(50)

Who performed the screening.

SIS-131774

PlanEditor

editorType

varchar(10)

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

SIS-131774

PlanEditor

componentName

varchar(50)

Angular component name in the document angular app.

SIS-131774

PlanEditor

parentCode

varchar(100)

Relates a nested editor to a parent PlanEditor.

SIS-131774

PlanEditor

routeName

varchar(100)

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

SIS-131774

PlanEditor

keyName

varchar(100)

The primary key associated with the editor table mapping.

SIS-131774

PlanEditor

apiPath

varchar(200)

Campus rest API base path associated with this editor.

SIS-131774

PlanEditor

manualEditorCard

bit

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

SIS-131774

PlanEditor

allowNotNeeded

bit

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

SIS-131774

PlanSectionStatus

objectID

int

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

SIS-131774

PlanState

districtSpedPhone

varchar(25)

Snapshot from district table.

SIS-131774

PlanState

areaServed

varchar(15)


SIS-131774

PlanState

districtContactLastName

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtSpedContactFirstName

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtUrl

varchar(100)

Snapshot from district table.

SIS-131774

PlanState

districtCity

varchar(25)

Snapshot from district table.

SIS-131774

PlanState

districtEmail

varchar(100)

Snapshot from district table.

SIS-131774

PlanState

extendedYear

varchar(15)

Indicates student is enrolled in extended year programming

SIS-131774

PlanState

districtSpedZip

varchar(10)

Snapshot from district table.

SIS-131774

PlanState

gaaFlag

varchar(15)

This field is used to identify students that will take the GAA this school year. This information is used to generate labels for the GAA assessment.

SIS-131774

PlanState

districtSpedContactFirstNameAlt

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtContactFirstName

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtPhone

varchar(25)

Snapshot from district table.

SIS-131774

PlanState

serviceSchoolCode

varchar(15)


SIS-131774

PlanState

districtSpedState

varchar(2)

Snapshot from district table.

SIS-131774

PlanState

districtSpedContactLastNameAlt

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtSpedAddress

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

serviceSchool

varchar(100)


SIS-131774

PlanState

districtZip

varchar(10)

Snapshot from district table.

SIS-131774

PlanState

districtNumber

varchar(12)

Snapshot from district table.

SIS-131774

PlanState

districtSpedCity

varchar(25)

Snapshot from district table.

SIS-131774

PlanState

districtState

varchar(2)

Snapshot from district table.

SIS-131774

PlanState

homeSchool

varchar(100)


SIS-131774

PlanState

homeSchoolCode

varchar(15)


SIS-131774

PlanState

districtName

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtSpedContactLastName

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtAddress

varchar(50)

Snapshot from district table.

SIS-131774

PlanState

districtSpedPhoneAlt

varchar(25)

Snapshot from district table.

SIS-131774

PlanState

schoolYear

varchar(10)


SIS-131774

PlanType

elements

bit

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

SIS-131774

PlanType

enrollmentEditorMode

varchar(15)

Indicates the mode of the enrollment information editor: readonly, editable, push.

SIS-131774

Print

elements

bit

Indicates this print format is loaded into the document elements app.

SIS-131774

SEPBehaviorIntervention

sbiDate

datetime2

Generic date field to be used as states see fit.

SIS-131774

SEPExtendedYear

consideration7

bit

Consideration to making ESY decision.

SIS-131774

SEPExtendedYear

consideration1

bit

Consideration to making ESY decision.

SIS-131774

SEPExtendedYear

consideration4

bit

Consideration to making ESY decision.

SIS-131774

SEPExtendedYear

consideration3

bit

Consideration to making ESY decision.

SIS-131774

SEPExtendedYear

consideration2

bit

Consideration to making ESY decision.

SIS-131774

SEPExtendedYear

consideration5

bit

Consideration to making ESY decision.

SIS-131774

SEPExtendedYear

consideration8

bit

Consideration to making ESY decision.

SIS-131774

SEPExtendedYear

consideration6

bit

Consideration to making ESY decision.

SIS-132851

Section504

disability

varchar(50)

Disability of the section 504 record.

SIS-132851

Section504

exitReason

varchar(15)

Exit reason of the section 504 record.

Altered

Case Number

Table

Column

Data Type

Description

SIS-133678

AP1099MiscItem

invoiceNumber

varchar(25)

Invoice number imported from the accounts payable system; used for display in ui.

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

SIS-131774

SEPActionPlan

actionTitle

varchar(1000)

This table is used in special education ieps.

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

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-133013

OH

Updated SPED document tab PWN lock rights.

SIS-131774


Added SPED Evaluation docSection rights.

SIS-133471


Migrated Beta UI User Tool Option to User Home Page

SIS-133269

NE

Fixed EdFi attendance mapping.

SIS-133697

WI

Updated campus object type for WI edfi3 ssepa

SIS-130721


Updated stateGradeLevel definition.

SIS-133013


Updated SPED document tab lock rights.

SIS-132852

MN

District Added - Cannon Valley

SIS-133101

VA

Activated 504 and moved enrollment 504 to 504 tab

SIS-117145


Health Screening Vision Unlocked

SIS-117145


Health Screening Examiners