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 |
