These cases are included in the Campus.2032 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-108367 | AdultEd | Identifies student adult ed records. |
SIS-108367 | AdultEdEL | AdultEd EL records. |
SIS-108367 | AdultEdExam | AdultEd exam records. |
SIS-108367 | AdultEdSubtest | AdultEd subtest records. |
SIS-138400 | BlendedLearningPreference | Saves virtual learning attendance preferences. |
SIS-135427 | BorderStudent | Stores borderStudent records. |
SIS-108367 | CustomAdultEd | State reporting table for custom defined attribute values of adultEd record. |
SIS-135427 | CustomBorderStudent | BorderStudent district elements. |
SIS-139067 | CustomDailyHealthCheck | Used to store custom defined attribute values of daily health check entries. |
SIS-139456 | CustomDigitalEquity | DigitalEquity district elements. |
SIS-137257 | CustomPlanOfStudy | State reporting table for custom defined attribute values of plan of study. |
SIS-139067 | DailyHealthCheck | Used to store daily health check entries. |
SIS-137211 | DatabaseChangeTrackingVersionHistory | |
SIS-139456 | DigitalEquity | Digital equity related data. |
SIS-139306 | GradingWindowGrade | Represents the grades to filter to in a particular gradingwindow. if this table is empty for a particular gw, that gw applies to all grades. |
SIS-139306 | GradingWindowTask | Represents the tasks in a particular gradingwindow. |
SIS-137257 | PlanOfStudy | State reporting table for plan of study. |
SIS-139175 | StudentParticipation | Stores an event of student participation recorded by either a teacher or student. |
SIS-138746 | TransientProcess | Used to be able to track a process's progress (ie. a batch job initiated from an APIi call) and then removed once completed or before the next process starts (unique index on 'name'). |
| SIS-111766 | UserAccountPasswordHistory | Table storing a user's recently used passwords to enforce district password policies. |
Modified Tables
Added
| Case Number | Table | Column | Data Type | Description |
SIS-138765 | ActivitySchool | sectionID | int | Foreign key to the section that the students will be rostered into. |
SIS-138765 | ActivitySchool | hasPosted | bit | Notes if the section has already had the students rostered into it. |
SIS-138765 | ActivitySectionRoster | rosterID | int | Foreign key to the roster table to know that activity registration created this roster record. |
SIS-138407 | AttendanceExcuse | participationBased | bit | Indicates this excuse is for student participation-based virtual attendance. |
SIS-139257 | Calendar | secondarySchool | int | Used by NE Ed-Fi to override the school for a given calendar on the student school association and attendance resources. |
SIS-138457 | Course | college | varchar(15) | College setting for the course. |
SIS-138457 | CourseCatalog | lockCollege | bit | Indicates lockcollege is locked on a course. |
SIS-138457 | CourseMaster | college | varchar(15) | College setting for the course. |
SIS-131775 | DocumentFile | locked | bit | Indicates whether this document is locked and should no longer be editable. |
SIS-138765 | EmploymentAssignment | activity | bit | Denotes the staff person as being an activity staff. |
SIS-138765 | EmploymentAssignmentHistory | activity | bit | Denotes the staff person as being an activity staff. |
SIS-138765 | EmploymentAssignmentHistory | framProcessor | bit | Denotes the staff person as being a FRAM processor for use with household applications and online applications. |
SIS-138765 | EmploymentAssignmentHistory | responseApprover | bit | Denotes the staff person as being able to approve behavior responses. |
SIS-137502 | EnrollmentCO | outcomeStatus | bit | Indicates if the student is eligible for the state's alternative assessment. |
SIS-138389 | EvalGuardian | hideContactInfo | bit | Indicates if the contact information should be hidden. |
SIS-138389 | EvalStudent | hideContactInfo | bit | Indicates if the contact information should be hidden. |
SIS-138457 | Gifted | exceptionality | varchar(15) | The exceptionality code for the student. |
SIS-139306 | GradingWindow | gradingWindowID | int | Identifier |
SIS-139306 | GradingWindow | startDateTime | smalldatetime | Date and time of day when the grading window open(ed). |
SIS-139306 | GradingWindow | endDateTime | smalldatetime | Date and time of day when the grading window close(ed). |
SIS-138765 | HRPositionCode | activity | bit | Indicates if this position is for an activity staff. |
SIS-138921 | HealthScreeningDental | dentalDisabilityProblem | bit | Does the student have a disability problem. |
SIS-138921 | HealthScreeningDental | dentalPediatricRef | varchar(15) | Was pediatric dentist recommended. |
SIS-138921 | HealthScreeningDental | dentalPediatricRefDate | smalldatetime | Date pediatric dentist recommended. |
SIS-138921 | HealthScreeningDental | dentalMedicalObjection | bit | Does the student have a medical objection. |
SIS-138921 | HealthScreeningDental | dentalCarieRestoration | varchar(15) | Did the student receive restoration due to caries. |
SIS-138921 | HealthScreeningDental | dentalFluorideTreatment | varchar(15) | Did the student receive fluoride treatment. |
SIS-138921 | HealthScreeningDental | dentalSealantsTreatment | varchar(15) | Did the student get sealants. |
SIS-138921 | HealthScreeningDental | dentalCleaning | varchar(15) | Did the student receive a dental cleaning. |
SIS-137502 | Homeless | causeOfHousingCrisis2 | varchar(20) | Indicates the additional reason for the student's homeless status. |
SIS-137502 | Homeless | causeOfHousingCrisis | varchar(20) | Indicates the reason for the student's homeless status. |
SIS-139156 | POSApplication | enhanced | bit | Indication of this application being served as part of POS 2.0 rewrite. |
SIS-139156 | POSPreference | allergyPopup | bit | Flag used to display allergy warning popup/slide out on a terminal. |
SIS-138389 | PlanGuardian | hideContactInfo | bit | Indicates if the contact information should be hidden. |
SIS-138389 | PlanStudent | hideContactInfo | bit | Indicates if the contact information should be hidden. |
SIS-139397 | PortalOptions | dailyHealthCheck | bit | Flag indicating daily health checks should be available on the portal. |
SIS-139397 | PortalOptions | immunizations | bit | Flag indicating immunizations should be available on the portal. |
SIS-138763 | Product | receiptComments | varchar(1000) | Comments to be included in the receipt for a product after purchase. |
SIS-139016 | ProgramPerson | satelliteProgram | bit | Student is participating in a cte program at a satellite location. |
SIS-108367 | RecordsTransfer | adultEdXML | varchar(MAX) | Xml representation of the released student's adult ed documents. |
SIS-108367 | RecordsTransfer | adultEdFOP | varchar(100) | The adult ed rendering object intended to be used in conjunction with the associated XML data. |
SIS-138493 | SEPTestAccommodationsKY | largePrintCheck | tinyint | Indication student uses large print when taking assessments. |
SIS-138493 | SEPTestAccommodationsKY | interpDetailText | varchar(8000) | Describes other interpreter accommodation. |
SIS-138493 | SEPTestAccommodationsKY | readersDetailCheck | tinyint | Indication which reader accommodation student uses when taking assessments. |
SIS-138493 | SEPTestAccommodationsKY | interpDetailCheck | tinyint | Indication which interpreter accommodation student uses when taking assessments. |
SIS-138493 | SEPTestAccommodationsKY | calcDetailText | varchar(8000) | Describes other calculator accommodation. |
SIS-138493 | SEPTestAccommodationsKY | calcDetailCheck | tinyint | Indication which calculator accommodation student uses when taking assessments. |
SIS-139227 | SchoolStoreSettings | freeStoreEnabled | bit | Boolean indicating for store can be used for $0 products without OLP. |
SIS-138389 | TeamMember | hideContactInfo | bit | Indicates if the team member's contact information should be hidden. |
SIS-135119 | TestAccommodations | alternateAssessmentInd | bit | Test accommodation alternateassessmentind option. |
SIS-135119 | TestAccommodations | printSize | varchar(15) | Test accommodation printsize option. |
SIS-135119 | TestAccommodations | translatedGlossaryLanguage | varchar(15) | Test accommodation translatedglossarylanguage option. |
SIS-135119 | TestAccommodations | mousePointerSizeColor | varchar(15) | Test accommodation mousepointersizecolor option. |
Altered
| Case Number | Table | Column | Data Type | Note | Description |
SIS-139045 | EdFiErrorLog | termName | varchar(60) | Changed data type from varchar(10) to varchar(60). | Used for errors associated with a term. |
SIS-137409 | EnrollmentMN | servPercent | varchar(15) | Changed data type from int to varchar(15). | Service hrs percent reported. |
SIS-137175 | GradingTask | abbreviation | varchar(40) | Changed data type from varchar(20) to varchar(40). | Abbreviation assigned to the standard. |
SIS-137502 | Graduation | graduationOptions | varchar(20) | Changed data type from varchar(1) to varchar(20). | Indicates the student met graduation requirements. |
Deprecated
| Case Number | Table | Column | Data Type | Description |
SIS-138646 | TEDSKY | credentialEarned | varchar(2) | Selection indicates the type of credential earned by the student. |
SIS-138646 | TEDSKY | tedsIndustryCertificate | varchar(15) | Selected certificate when programming complete. |
SIS-138646 | TEDSKY | federalIndicator | bit | Indicates the teds record will be federally reported. |
SIS-138646 | TEDSKY | tedsTerminationStatus | varchar(2) | Status of termination in TEDS. |
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-135427 | Fixed Foreign Key Typo | |
SIS-138416 | Migrated COVID attendance data into blendedLearningPreference | |
SIS-137257 | Added Grade Level | |
SIS-139414 | Triggered NewNavPreference ES Reindex | |
SIS-133431 | CA | Converted EL and Programs to EL Services |
SIS-139531 | MD | Immunization Rule Updated |
SIS-137510 | ID | Immunization Rule Updated |
SIS-131775 | Updated non-SPED document tab lock rights | |
SIS-136700 | PA | Immunization Rule Updated |
SIS-139262 | MO | Added district 115930 |
SIS-138746 | Added job for blended learning group auto assign process | |
SIS-137782 | DataValidationDef owner match stateOwned | |
SIS-139192 | TN | Immunization Rule Updated |
SIS-139192 | TN | Updated HepB-3 code |
SIS-137257 | KS | LepServiceType updated |
SIS-138812 | SchoolStorePaymentJob | |
SIS-138395 | KS | Immunization Rule Updated NewErrWrapper |
SIS-138407 | Removed COVID-19 Scheduled Tasks | |
SIS-135152 | PA | Converted cipCodes |
SIS-138407 | Added job to post non-participation to attendance | |
SIS-138457 | NC | Added StateGradeLevelDefinitions and Districts |
SIS-138998 | Added FosterCareBIE to DCT and Audit Tables | |
SIS-138395 | KS | Immunization Rule Updated - NCMT |
SIS-138986 | Updated enrollmetnType to P when Null | |
SIS-137502 | Converted Enrollments to Homeless Table | |
SIS-137257 | Added PlanOfStudy Table | |
SIS-135427 | Data Conversion for new Border Student Table | |
SIS-135427 | Border Student Data Conversion | |
SIS-137409 | Changeed ServPercent to a string field | |
SIS-137257 | Added Lep Service Types | |
SIS-137850 | MO | Immunization Rule Updated |
SIS-108367 | Added AdultEd to DIS | |
SIS-108367 | Added AdultEd to DCT | |
SIS-135359 | Disabled CTE Program Associations resource for EdFi 2020 2021 | |
SIS-138395 | KS | Immunization Rule Updated |
SIS-135298 | Updated Column Lengths In Identity | |
SIS-135298 | Converted VisaType and Citizen Fields | |
SIS-131956 | Fixed invalid MessageDeliveryStatus |
