These cases are included in the Campus.2104 release pack.
Data Manipulation Language Scripts (DML)
This section lists scripts to add, modify, query, or remove data from a SQL Server database.
New Tables
| Case Number | Table | Description |
SIS-136188 | HandRaise | Campus instruction hand raise questions between students and teachers |
SIS-136188 | IMLearningObjectPerson | Association between instructional management learning object and person |
SIS-136188 | LessonPlanSubmissionDeleted | Student submissions that were deleted because they were orphaned. |
SIS-139047 | PaymentDeposit |
Modified Tables
Added
| Case Number | Table | Column | Data Type | Description |
SIS-136188 | ForumSystemCI | objectID | int | Internal database identifier for associated discussion curriculum block object. |
SIS-136188 | IMItemResponse | previousItemResponseID | int | The previous IMItemResponse when versioned. |
SIS-136188 | IMLearningObject | wysiwygSubmission | bit | Indicates if a student can leave an online response to this assignment. |
SIS-136188 | IMLearningObject | driveSubmission | bit | Indicates if a student can attach a file to this assignment using google drive. |
SIS-136188 | IMLearningObject | upload | bit | Indicates if a student can attach a file to this assignment. |
SIS-136188 | IMLearningObjectSection | modifiedDate | smalldatetime | Indicates the date the record was modified. |
SIS-136188 | IMLearningObjectSection | notGraded | bit | Indicates the assignment is not graded. |
SIS-136188 | IMLearningObjectSection | objectID | int | Internal database identifier for associated curriculum learning object. |
SIS-136188 | IMLearningObjectSection | parentObjectSectionID | int | Internal database identifier for parent IMLearningObjectSection record. |
SIS-136188 | IMLearningObjectSection | abbrev | varchar(5) | Abbreviation of assignment that will appear in grade book. |
SIS-136188 | IMLearningObjectSection | modifiedByID | int | Indicates the campus user who modified the record |
SIS-136188 | IMRubricItem | previousRubricItemID | int | The previous IMItemResponse when versioned. |
SIS-136188 | IMRubricItemDescription | previousRubricItemDescriptionID | int | The previous RubricItemDescriptionid when versioned. |
SIS-136188 | LessonPlanSubmission | objectSectionID | int | Internal database identifier that references IMLearningobjectsection. |
SIS-136188 | LessonPlanSubmission | objectID | int | Internal database identifier for associated submission curriculum block object. |
SIS-136188 | LessonPlanSubmission | sectionID | int | Internal database identifier from section table. |
SIS-136188 | PortalOptions | handRaise | bit | Flag to allow students to ask a question to their teacher. |
SIS-139047 | PaymentMethodReference | vendorPaymentMethodID | varchar(255) | Additional identifier of the payment method passed from vendor. |
SIS-139047 | PaymentTransactionProduct | depositDate | date | Date indicating when vendor has deposited funds into district's bank account. |
SIS-139047 | PaymentTransactionProduct | description | varchar(100) | Description of the item the PaymentTransactionProduct represents. |
SIS-139047 | PaymentTransactionProduct | paymentDepositID | int | Internal database identifier to the original product following a reversal. |
SIS-139949 | CampusEvent | premium | bit | Flag the associated event is premium. |
SIS-139949 | CampusEventProcedure | premium | bit | Flag the associated procedure is premium. |
SIS-139949 | DataValidationDef | premium | bit | Flags the associated def as premium. |
SIS-139949 | DataValidationGroup | premium | bit | Flags the associated group as premium. |
SIS-139949 | DataValidationProcedure | premium | bit | Flags the associated procedure as premium. |
SIS-142628 | PACTE | adultCumulativeCreditEquiv | bit | Indicates that adult cumulative credit was awarded. |
SIS-142628 | PACTE | status | varchar(15) | Indicates the status of the PACTE record. |
SIS-142628 | PACTE | simulatedWorkEnvironment | bit | Indicates if the program occurred in a simulated work environment. |
SIS-142628 | PACTE | degreeAwarded | bit | Indicates if a degree was awarded. |
SIS-142628 | PACTE | certificateOfApprenticeship | bit | Indicates if a certificate of apprenticeship was awarded. |
SIS-142628 | ProgramParticipationCTE | adultCumulativeCreditEquiv | bit | Indicates that adult cumulative credit was awarded. |
SIS-142628 | ProgramParticipationCTE | degreeAwarded | bit | Indicates if a degree was awarded. |
SIS-142628 | ProgramParticipationCTE | certificateOfApprenticeship | bit | Indicates if a certificate of apprenticeship was awarded. |
SIS-142913 | Message | senderDisplayName | varchar(100) | Display name sent with the reply to address. |
SIS-142913 | MessagePreview | senderDisplayName | varchar(100) | Display name sent with the reply to address. |
SIS-142913 | MessengerDistrictSchedule | senderDisplayName | varchar(100) | The display name that will show on the emails received by recipients. |
SIS-142938 | BehaviorResolution | durationHours | decimal | The number of duration hours the resolution will last. |
SIS-143032 | BlendedLearningPreference | allowPhysicalOverride | bit | Whether a teacher is allowed to indicate that a physical student can be considered virtual for a period. |
SIS-143032 | StudentParticipation | physicalOverride | bit | Flag to override physical attendance as virtual. |
SIS-143289 | ElasticDatabaseEvents | id | int | Identifier of the item that caused the database change. |
SIS-143478 | Evaluation | disabilityString | varchar(8000) | A string representation of a students disability or disabilities. |
Altered
| Case Number | Table | Column | Data Type | Note | Description |
SIS-139047 | PaymentTransaction | transactionRef | varchar(100) | Changed data type from bigint to varchar(100). | Transaction identifier shared with customer |
SIS-139047 | PaymentTransactionProduct | paymentTransactionProductRef | varchar(100) | Changed data type from bigint to varchar(100). | Vendor-originated reference for transaction product |
SIS-143323 | LepService | sheltered | varchar(15) | Changed data type from bit to varchar(15). | Sheltered instruction - used in hi |
SIS-143535 | Survey | name | varchar(1000) | Changed data type from varchar(50) to varchar(1000). | Name of the survey |
Deprecated
| Case Number | Table | Column | Data Type | Description |
SIS-136188 | IMLearningObjectSchedulingSet | wysiwygSubmission | bit | Indicates if a student can leave an online response to this assignment. |
SIS-136188 | IMLearningObjectSchedulingSet | driveSubmission | bit | Indicates if a student can attach a file to this assignment using google drive. |
SIS-136188 | IMLearningObjectSchedulingSet | upload | bit | Indicates if a student can attach a file to this assignment. |
SIS-136188 | IMLearningObjectSection | dueTimestamp | smalldatetime | Due time of the assignment's assessment on the due date. |
SIS-136188 | IMLearningObjectSection | assignedTimestamp | smalldatetime | Assigned time of the assignment's assessment on the assigned date. |
SIS-136188 | IMLearningObjectSection | schedulingSetID | int | References imlearningobjectschedulingset table |
SIS-136188 | IMLearningObjectSection | subRosterID | int | References subroster (student group) table |
SIS-136188 | IMRubricItemDescription | objectID | int | Foreign key to imlearningobject |
SIS-139047 | PaymentUserAccount | paymentClientAccountID | int | Internal database identifier |
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.
| Case Number | State | Description |
SIS-143535 | Increased the maximum length of the survey name | |
SIS-130267 | WY | Immunization Rule Updated |
SIS-142576 | NY | Immunization Rule Updated |
SIS-143215 | UT | Immunization Rule Updated |
SIS-143003 | IL | Immunization Rule Updated |
SIS-141859 | Deleted UserToolOption Duplicated Records And Add Unique Constraint | |
SIS-139727 | Added New PlanAccommodation Records | |
SIS-141753 | Updated District table entityID | |
SIS-139047 | Added Settlement State and Job | |
SIS-139047 | Added Payrix Payment Vendor | |
SIS-142674 | Added defaults for BIE password preferences | |
SIS-143211 | NM | Updated Language Codes |
SIS-143123 | Associated Daily Health Survey with SIS Security Role Group | |
SIS-142938 | AZ | Converted BehaviorResolution duration to durationHours field |
SIS-136188 | Updated portal assignment NotificationType workspaceUrl | |
SIS-139949 | Added Quartz Job for Data Validation Remaining Sites |
