Technical Information - Release Pack Campus.2211

These cases are included in the Campus.2211 release pack

Feedback Requested

As a user of this schema change document, would you find would you find this type of information helpful if it was provided for Rx releases such as Rx Pack - Campus.2132? (Schema changes in Rx cases are rare, on average one in thirty cases.)

Please respond in the comments field at the end of this article. Thanks!

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.

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-144010

CustomFormGroup

processing

Indicates the batch is processing, such as generating forms.

SIS-147560

EnrollmentTX

retention

Indicates an enrolled student was retained at the request of the parent or guardian.

SIS-147560

ExpandedLearningOpportunities

daysPerYear

Number of ELO days in a year.

SIS-149031

Survey

publishedTimestamp

Datetime the external survey was published to elasticsearch.

SIS-149031

Survey

documentID

The documentID from the elastic search.

SIS-149031

Survey

surveyGUID

Internal database identifier.

SIS-149031

SurveyResponse

documentID

The documentID from the elastic search.

SIS-149434

EmploymentAssignment

adminTypeBIE

Indicates type of administrator for BIE.

SIS-151803

IMLearningObjectSection

createdByVendorID

Digital learning vendorID the created the record.

SIS-150845

EnrollmentCT

truant

Override to indicate a student is truant or not.

SIS-152198

Lep

exitState

Used to track the state where a student exited their EL program.

SIS-152276

EvalChecklist

checklistCategory

Determines the type of checklist to differentiate between editors.

SIS-152861

MessengerRecordedSpeechFile

createdByID

Created by personID (nullable for legacy records.).

SIS-153065

Test

seq

Sequence order for sorting children from 0 to n.

SIS-153238

SpecialEDState

spedService

What type of sped service is provided.

SIS-153238

SpecialEDState

spedPlacement

What type of placement a student has.

SIS-153238

SpecialEDState

spedFundingCode

Special ed funding source code.

SIS-153238

SpecialEDState

specialEdTransportation

Is special ed transportation provided?

SIS-153238

SpecialEDState

specialEdStatus

Special education status.

SIS-153364

MIEarlyChildhood

comment

Early childhood program details.

SIS-153385

OneRosterStudent

sourcedIdV1P2

Sourced id for OneRoster v1p2 student, string value of personGUID

Altered

Case NumberTableColumnData TypeNoteDescription

SIS-149031

Survey

campusSurveyMetadata

nvarchar

Changed data type from None to nvarchar.


SIS-149031

Survey

userID

int

Changed data type from None to int.

Internal database identifier

SIS-149031

Survey

startTimestamp

datetime

Changed data type from None to datetime.

The day/time the survey becomes active for respondents

SIS-149031

Survey

surveyID

int

Changed data type from None to int.

Internal database identifier

SIS-149031

Survey

multiResponse

bit

Changed data type from None to bit.

If flagged, checkbox indicates respondents will be allowed to submit more than one response should they decide to repeat the survey

SIS-149031

Survey

createdByCampus

bit

Changed data type from None to bit.

Is the survey created and pushed by campus

SIS-149031

Survey

name

varchar(1000)

Changed data type from None to varchar(1000).

Name of the survey

SIS-149031

Survey

enabled

bit

Changed data type from None to bit.

If flagged, checkbox indicates survey is active for respondents

SIS-149031

Survey

groupID

int

Changed data type from None to int.

Internal database identifier

SIS-149031

Survey

surveyJSON

nvarchar

Changed data type from None to nvarchar.


SIS-149031

Survey

anonymous

bit

Changed data type from None to bit.

If flagged, checkbox indicates surveys will be submitted without any identifying information and that respondents will be notified of the anonymity of their responses

SIS-149031

Survey

endTimestamp

datetime

Changed data type from None to datetime.

The day/time the survey is inactivated for respondents

SIS-149031

Survey

introduction

varchar(MAX)

Changed data type from None to varchar(MAX).


SIS-149031

Survey

conclusion

varchar(MAX)

Changed data type from None to varchar(MAX).

Ending remarks/conclusion will display to respondents upon completion of survey

SIS-149031

SurveyResponse

responseKey

int

Changed data type from None to int.

System-generated number associated with the response

SIS-149031

SurveyResponse

completed

bit

Changed data type from None to bit.

Indicates the survey is complete

SIS-149031

SurveyResponse

startTimestamp

datetime

Changed data type from None to datetime.

The time the survey was first accessed by respondent

SIS-149031

SurveyResponse

surveyID

int

Changed data type from None to int.

Reference to the survey table

SIS-149031

SurveyResponse

respondentID

int

Changed data type from None to int.

Reference to the survey respondent table

SIS-149031

SurveyResponse

responseJSON

nvarchar

Changed data type from None to nvarchar.


SIS-149031

SurveyResponse

personID

int

Changed data type from None to int.

Reference to the person table

SIS-149031

SurveyResponse

responseID

int

Changed data type from None to int.

Internal database identifier

SIS-149031

SurveyResponse

endTimestamp

datetime

Changed data type from None to datetime.

The timestamp when the respondent finished or exited the survey

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-141190

OH

Immunization Rule Update

SIS-141728

WI

Data Conversion EnrollmentWI earlyIntervening to EarlyInterventionService

SIS-144010


clearFormBatchProcessing

SIS-148309

WI

Removed extra filler records

SIS-151314


joeltest

SIS-151314

AZ

Changed EdFiConfiguration student staff ID

SIS-151547

CO

Immunization Rule Update

SIS-151660

IL

Immunization Rule Update

SIS-153065


Updated seq in test to default alphabetical value

SIS-153091

OK

Updated Croatian language standardCode and SIF mapping

SIS-153238

KS

Converted SpEd fields to State Reporting tab

SIS-153292

AZ

Added new districts

SIS-153370


Added Leaders Of Tomorrow Early Learning Academy District

SIS-153464

HI

Immunization Rule Update

SIS-153560


Rebranded Messenger 2

SIS-153586

VA

Updated state event code

SIS-153629


Cleaned up DataValidationDefs with NULL owner

SIS-153900


Reindexed courseSection

SIS-154015

HI

Immunization Rule Update