Technical Information - Release Pack Campus.2052

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

BIEPSOInterview


SIS-138509

StateReportSnapshot

Setup info for snapshot data.

SIS-138509

StateReportSnapshotFileType

Snapshot file types.

SIS-138509

StateReportSnapshotFileTypeValidation

Joins snapshot filetypes to validation methods.

SIS-138509

StateReportSnapshotGroup

State report snapshot group.

SIS-138509

StateReportSnapshotSource

Snapshot sources.

SIS-138509

StateReportSnapshotValidation

Snapshot validation methods.

Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-142360

ALPSS

endReasonComment

varchar(500)

Additional comments to explain endreason in HI.

SIS-142884

ActivitySection

registrationProcessToggle

bit

True/false tracks the registration process toggle status on the roster screen.

SIS-142225

DistrictAttribute

caresAct

varchar(15)

CARES act info for the district.

SIS-142405

EarlyLearning

endingProviderReason

varchar(20)

Early childhood ending provider reason, IL.

SIS-142405

EarlyLearning

providerType

varchar(20)

Early childhood provider type, IL. 

SIS-142405

EarlyLearning

serviceEndDate

date

Date services end, IL. 

SIS-142405

EarlyLearning

serviceType

varchar(20)

Early childhood service type, IL. 

SIS-142635

Employment

sifExclude

bit

Flag to determine if employment should be excluded.

SIS-142335

EmploymentAssignment

typeBIE

varchar(15)

Identifies a staff members BIE district assignment type.

SIS-142335

EmploymentAssignmentHistory

typeBIE

varchar(15)

Identifies a staff members BIE district assignment type.

SIS-142635

EmploymentAssignmentLocation

sifExclude

bit

Flag to determine if employment should be excluded.

SIS-142635

EmploymentAssignmentLocationHistory

sifExclude

bit

Flag to determine if employment should be excluded.

SIS-142635

EmploymentHistory

sifExclude

bit

Flag to determine if employment should be excluded.

SIS-142584

EnrollmentMA

studentTruancyVirtual

varchar(15)

The number of days a student has been truant for virtual days.

SIS-142432

Graduation

eduInstitutionType

varchar(15)

The type of educational or training institution based on the institution's tax status: public, private nonprofit, for profit.

SIS-141709

HRDemographics

eoyStatusOverride

varchar(15)

Field for EOY status override in MA.

SIS-141709

HRDemographics

oct1StatusOverride

varchar(15)

Field for Oct 1 status override in MA.

SIS-141709

HRDemographicsHistory

eoyStatusOverride

varchar(15)

Field for EOY status override in MA.

SIS-141709

HRDemographicsHistory

oct1StatusOverride

varchar(15)

Field for Oct 1 status override in MA.

SIS-142222

Lep

languageVerification

varchar(15)

Description for language verification - used in HI.

SIS-142222

Lep

notes

varchar(500)

Language identification notes - used in HI.

SIS-142222

Lep

actionCode

varchar(15)

Description for action - used in HI.

SIS-142222

Lep

completeDate

date

Date for language idenitifcation complete - used in HI.

SIS-142222

Lep

sentDate

date

Date for language identification notification sent to parent - used in HI.

SIS-142222

Lep

conductedBy

varchar(50)

Language identification conducted by - used in HI.

SIS-142222

LepAccommodation

altAccommodation

bit

Alternative access for ells accommodations - used in HI.

SIS-142222

LepService

languageTime

varchar(15)

Language time for BIL program - used in HI.

SIS-142222

LepService

otherSetting

varchar(500)

Other information for setting - used in HI.

SIS-142222

LepService

otherTime

varchar(50)

Other language time description - used in HI.

SIS-142222

LepService

sheltered

bit

Sheltered instruction - used in HI.

SIS-142222

LepService

bilProgram

varchar(15)

Bilingual program - used in HI.

SIS-142222

LepService

eldProgram

varchar(15)

English language development program - used in HI.

SIS-142222

LepService

frequencyPeriod

varchar(15)

The type of period used for service (day/week/etc).

SIS-142222

LepService

frequency

tinyint

The number of services in a period.

SIS-140922

SessionTracker

previousSessionID

varchar(32)

Previous http session id - set on session restore after tomcat restart.

SIS-142605

UserAccount

passwordUpdatedTimestamp

smalldatetime

The datetime the password was last changed.

Altered

Case Number

Table

Column

Data Type

Note

Description

SIS-142360

CampusAttribute

maxSize

int

Changed data type from tinyint to int.

Lists the maximum amount of characters the data entered into the field can have.

SIS-138911

FeeVoid

voidReasonCode

varchar(15)

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

Reason for the voided fee assignment.

SIS-142222

LepService

location

varchar(15)

Changed data type from varchar(12) to varchar(15).

Identifies the appropriate location id for the individual service record.

SIS-137445

MailgunEventStatus

reason

varchar(510)

Changed data type from varchar(255) to varchar(510).

Reason returned by mailgun for this event.

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-142748

MA

Added Quartz Job for SIF.

SIS-143202


Removed duplicate responses in the responseJSON

SIS-142432


Added column to Graduation and alter 2 columns

SIS-142635


Made sifExclude columns non-nullable

SIS-142222


Added English Learners to CustomForms

SIS-142641

CT

Updated AttendanceExcuse State Code for DLA and DLP

SIS-142956

CO

Ensured state specific IEP SEEArea records are populated

SIS-143136

CO

Updated Convert Enrollment Section504 to Section504 Tab

SIS-142317


Updated ReindexLog in Elasticsearch Aliases Again

SIS-142317


Updated ReindexLog in Elasticsearch Alias Again

SIS-142360

HI

Prepopulated ALPSSSAfterCare droplist

SIS-142545

KY

Updated FormDocument For Program Service Plan customForm

SIS-142447

MN

Updated District list

SIS-142676

AZ

Zero pad district number

SIS-140490


Disabled Restraint Events resource

SIS-142724

NJ

Added district and county code

SIS-142759

MA

Updated EmploymentCrediential degreeType field

SIS-142317


Updated ReindexLog in Elasticsearch Alias

SIS-142296

TN

Corrected grade 3 NCES grade

SIS-134016


Added BIEPSOInterview DISObject

SIS-138911


Changed FeeVoid code to max length 15