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 Number | State | Description |
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 |
