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