Technical Information - Release Pack Campus.2012

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

Print

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 NumberStateDescription

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