These cases are included in the Campus.2012 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-132726 | CustomMESA | MESA district elements. |
SIS-132726 | CustomNCLB | NCLB district elements. |
SIS-132726 | CustomYouthProgram | YouthProgram district elements. |
SIS-133126 | DataValidationProcParameter | Procedures used by data validation tool. |
SIS-133126 | DataValidationProcedure | Procedures used by data validation tool. |
SIS-129170 | LDAPStatus | Stores latest status of LDAP configuration for each app server. |
SIS-132726 | MESA | Identifies student involvement in mesa (math, engineering, science achievement). |
SIS-132726 | NCLB | No child left behind related data. |
SIS-128786 | PaymentFundProductType | Links a fund account to a product type for OLP. |
SIS-133177 | PortalDocumentOptions | Store preferences of document modules and types that are allowed to publish to portal. |
SIS-128786 | Product | Inventory - product. |
SIS-128786 | ProductAttribute | Inventory - product attributes. |
SIS-128786 | ProductAttributeValue | Inventory - product attribute values. |
SIS-128786 | ProductCategory | Inventory - product categories. |
SIS-128786 | ProductCategorySchool | Inventory - product category's relation to school. |
SIS-128786 | ProductCategorySchoolListing | Inventory - product's relation to a category at a given school. |
SIS-128786 | ProductFile | Inventory - product cloud files. |
SIS-128786 | ProductFileListing | Inventory - product listing for an attached file. |
SIS-128786 | ProductItem | Inventory - product items. |
SIS-128786 | ProductItemAttribute | Inventory - product item's attributes. |
SIS-128786 | ProductPrice | Inventory - pricing for product item. |
SIS-128786 | ProductSale | Inventory - product item sale. |
SIS-128786 | ProductTransaction | Inventory - product item transaction. |
SIS-128786 | ProductType | Defines product types for school store products to link to campus payments. |
SIS-128786 | SchoolStoreSettings | Stores settings for school store. |
SIS-132726 | YouthProgram | Youth program related data. |
Modified Tables
Added
| Case Number | Table | Column | Data Type | Description |
|---|---|---|---|---|
SIS-134010 | BehaviorResolution | charges | varchar(15) | Indicates the type of charges student was given for event. |
SIS-122902 | Calendar | deleteOrigin | varchar(1) | Used to determine where the deleteIndicator was set. District, State, or null (not set until deleteIndicator is set). |
SIS-122902 | Calendar | deleteRequestedTimestamp | smalldatetime | Date and time the deletion was requested. |
SIS-122902 | Calendar | deleteRequestedByGUID | uniqueidentifier | Reference to the person who requested the deletion person table GUID. |
SIS-122902 | Calendar | deleteReasonComments | varchar(100) | Comments for the reason for the deletion. |
SIS-122902 | Calendar | deleteRequestedByID | int | Internal db identifier of the person who requested the deletion. |
SIS-122902 | Calendar | deleteStatus | varchar(1) | Indicates the status of a delete. (null) not started, (i)n progress, (f)ailed. |
SIS-122902 | Calendar | deleteReasonCode | varchar(5) | Stores the reason code of this deletion. |
SIS-122902 | Calendar | deleteFailureReason | varchar(8000) | Indicates the reason of the delete failure. |
SIS-122902 | Calendar | deleteIndicator | varchar(1) | Marked for delete, Deleted (used for state edition), or null. |
SIS-133126 | DataValidationDef | baselineID | int | DataValidationDefID that is used as baseline for this rule. |
SIS-133126 | DataValidationDef | syncStatus | varchar(1) | Holds the sync state: unpublished - published - unpublished change. |
SIS-133126 | DataValidationDef | procedureID | int | ID of CampusValidationProcedure which supplies the data for a procedure data validation def. |
SIS-133126 | DataValidationDef | deletedByState | bit | True if data validation def has been deleted by state. |
SIS-133126 | DataValidationGroup | syncStatus | varchar(1) | Holds the sync state: unpublished to published to and from unpublished change. |
SIS-134569 | District | programType | varchar(255) | Indicates the educational programs offered by the district. |
SIS-132811 | EnrollmentBIE | daysAbsentBIE | smallint | Total days student was absent. |
SIS-132811 | EnrollmentBIE | scheduledDaysBIE | smallint | Total days student was enrolled. |
SIS-133177 | FormDocument | comments | varchar(500) | Comments only admins can see. |
SIS-133177 | FormDocument | publishToStudent | bit | Is this form allowed to be shown on campus student. |
SIS-133177 | FormDocument | publishToParent | bit | Is this form allowed to be shown on campus parent. |
SIS-133177 | FormDocument | displayInRoster | bit | Is this form allowed to be shown in the roster. |
SIS-131880 | MailgunEventStatus | senderID | int | Id of the sender, if one exists; otherwise 0 for system processes. |
SIS-134731 | PlanType | servicesLegalStatement | varchar(8000) | Legal statement that prints with each services editor. |
SIS-133826 | printUrl | varchar(8000) | The URL required to print the document. | |
SIS-134843 | SEPTransportationPlan | comments | varchar(8000) | This table is used in special education IEPs. |
Altered
Case Number | Table | Column | Data Type | Description |
|---|---|---|---|---|
SIS-135561 | Address | tract | varchar(10) | Government defined tract of which the address is part. Changed data type from varchar(5) to varchar(10). |
SIS-134715 | CFDocument | notes | varchar(MAX) | Notes for document. Changed data type from varchar(2000) to varchar(MAX). |
SIS-132726 | Title1 | instructionalOtherDescription | varchar(250) | Comment indicating type of additional Title I (part a or part d) instructional services. Changed data type from varchar(50) to varchar(250). |
Deprecated
Case Number | Table | Column | Data Type | Description |
|---|---|---|---|---|
SIS-133867 | CRReceipt | description | varchar(50) | User-entered details about the receipt. |
SIS-133867 | CRReceipt | headerGLAccountID | int | Default GL account number to be used in cash receipt lines. |
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-133445 | MA | Converted stateResCode |
SIS-132598 | Converted Journal Inquiry Rights | |
SIS-128786 | School Store CloudFile | |
SIS-135199 | Set default values for elastic preferences | |
SIS-134331 | Added Ed-Fi feature toggle | |
SIS-133721 | CO | Enrollment changed End Status Type to year 18-19 for code 24 |
SIS-133126 | Converted DataValidationGroup published to syncStatus | |
SIS-132811 | Added quartz job for weekly BIE Attendance update | |
SIS-131895 | UFARS CodeGroup 2020 Update 2-7-2020 | |
SIS-134392 | MO | Immunization Rule Update |
SIS-126279 | KY | KConversion of BehaviorResolution.schoolDaysDuration for 17-18 and 18-19 |
SIS-135011 | AZ | Removed non-AZ edfiResourcePreferences |
SIS-132582 | Trimmed trailing whitespace from Custom Tab and Campus Attribute | |
SIS-126443 | KS | Immunization Rule Update |
SIS-132581 | Split Student Academic Planning Program Rights | |
SIS-133177 | Removed portal forms preference | |
SIS-132726 | UT | Added LepServiceTypes |
SIS-122902 | Added DeleteCalendarJob |
