Technical Information - Release Pack Campus.2008

These cases are included in the Campus.2008 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-125763

APCreditCardImport

The credit card number in the uploaded file.

SIS-125763

APCreditCardImportHeader

The user entered information about the credit card statement upload.

SIS-125763

APCreditCardImportItem

The lines in the credit card statement upload.

SIS-125763

APCreditCardImportItemDistribution

The distribution of credit card statement line items between GL accounts.

SIS-125763

APCreditCardInfo

Information on the district credit cards.

SIS-125763

APCreditCardUploadCSVMapping

The user entered information about the CSV file mapping for credit card statements.

SIS-125763

APCreditCardVendor

Will maintain records of credit card vendors.

SIS-125763

APVendorAlias

The vendor aliases from the credit card statements.

SIS-129416

CFAssociation

Case competency framework association: this is the container for the data about the relationship between two cfdocuments or between two cfitems outside of the context of a cfpackage or cfitem.

SIS-129416

CFAssociationGrouping

Case competency framework association grouping.

SIS-129416

CFConcept

Case competency framework concept.

SIS-129416

CFDocument

Case competency framework document.

SIS-129416

CFDocumentSubject

Case competency framework document subject join table.

SIS-129416

CFImportLog

Import log for case competency framework data.

SIS-129416

CFItem

Case competency framework item: this is the container for the cfitem data outside of the context of a cfpackage. This is the content that either describes a specific competency (learning objective) or describes a grouping of competencies within the taxonomy of a competency framework document.

SIS-129416

CFItemType

Case competency framework item type.

SIS-129416

CFLicense

Case competency framework license.

SIS-129416

CFLink

Case competency framework link.

SIS-129416

CFSubject

Case competency framework subject.

SIS-129416

CurriculumStandard_CASEId


SIS-129486

EarlyInterventionServiceBIE

BIE specific table for coordinated early intervening services.

SIS-134417

ExpandedLearningOpportunities


SIS-129416

GradingTask_CASEId


SIS-133501

GradingWindowExceptionGrade

Represents the grades in a particular gradingwindowexception.

SIS-132868

GradingWindowExceptionStudent

Represents the students in a particular gradingwindowexception.

Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-125763

APInvoice

parentID

int

Internal database identifier to the parent invoice (used for credit card processing).

SIS-125763

APInvoice

hasChildren

bit

This determines if this invoice has related children invoices.

SIS-133565

ARInvoice

shipToName

varchar(100)

The ship to address name on the invoice.

SIS-133565

ARInvoice

billToName

varchar(100)

The bill to address name on the invoice.

SIS-129416

CurriculumStandard

imported

bit

Indicates the standard group task was imported, may related to case standards.

SIS-129416

CurriculumStandard

batchImporting

bit

Indicates the standard group task is being imported with batch, skips trigger sorting for TreeTraversalSeq.

SIS-133389

EdFiResync

disableResources

bit

Determines whether the resources in this resync should be disabled while it is running.

SIS-123647

EnrollmentMN

independentStudy

varchar(15)

Independent student flag.

SIS-123647

EnrollmentMN

enrollingSchool

varchar(6)

Enrolling school.

SIS-123647

EnrollmentMN

schoolStatus

bit

Enrolling public school.

SIS-123647

EnrollmentMN

displacedHomemaker

varchar(15)

Displaced homemaker.

SIS-123647

EnrollmentMN

specialServiceHours

varchar(8)

Special ed service hours.

SIS-123647

EnrollmentMN

cISPSEOConEnr

bit

CIS PSEO concurrent enrollment flag.

SIS-123647

EnrollmentMN

stateWard

varchar(15)

Ward of state.

SIS-123647

EnrollmentMN

pseo1

bit

Post secondary options indicator.

SIS-123647

EnrollmentMN

specialCare

varchar(15)

Indicator to identify when a student has been placed in care and treatment.

SIS-123647

EnrollmentMN

servPercent

int

Service hours percent reported.

SIS-123647

EnrollmentMN

supplementalServices

varchar(15)

Type of supplemental educational service provided to low-income students.

SIS-123647

EnrollmentMN

militaryConnected

bit

Flag used to identify students who have an immediate family member who is currently in the armed forces either as a reservist or on active duty or has recently retired from the armed forces.

SIS-129416

GradingTask

imported

bit

Indicates the grading task was imported, may related to case standards.

SIS-129416

GradingTask

batchImporting

bit

Indicates the grading task is being imported with batch, skips trigger sorting for TreeTraversalSeq.

SIS-130786

OLPSettings

eCheckServiceFee

decimal

The service fee for using online payments with an e-check payment method, that the payer pays.

SIS-130786

OLPSettings

eCheckServicePercentActive

bit

If the district is charging a e-check service fee by an amount or percent.

SIS-130786

OLPSettings

eCheckServicePercent

decimal

The service fee for using online payments with an e-check payment method. Indicates the percentage of the amount the user must pay.

SIS-134141

RecurringFeePayment

lastExecutionStatus

varchar(30)

The status of the last recurring payment execution.

SIS-134141

RecurringFeePayment

lastExecutedDate

smalldatetime

The most previous date the recurring payment was executed on.

SIS-134141

RecurringPOSPayment

lastExecutionStatus

varchar(30)

The status of the last recurring payment execution.

SIS-134141

RecurringPOSPayment

lastExecutedDate

smalldatetime

The most previous date the recurring payment was executed on.

SIS-134050

SEPBehaviorIntervention

varchar2

varchar(8000)

Generic varchar field to be used as states need.

SIS-134050

SEPBehaviorIntervention

varchar1

varchar(8000)

Generic varchar field to be used as states need.

SIS-134417

School

pkFullDayWaiver

bit

Indicates if the school has been approved to not support full day preschool.

Altered

Case Number

Table

Column

Data Type

Note

Description

SIS-129416

CurriculumStandard

description

nvarchar

Changed data type from varchar(MAX) to nvarchar.

Plain text long description of this standard.

SIS-129416

CurriculumStandard

name

nvarchar

Changed data type from varchar(50) to nvarchar.

User defined name of this standard.

SIS-129416

EdFiErrorLog

gradingTaskName

nvarchar

Changed data type from varchar(500) to nvarchar.

Used for errors associated with a grading task.

SIS-129416

GradingTask

description

nvarchar

Changed data type from varchar(MAX) to nvarchar.

Defintion of the standard, noting what the student is expected to perform or be able to do upon completion of the standard.

SIS-129416

GradingTask

name

nvarchar

Changed data type from varchar(500) to nvarchar.

Name assigned to the grading task.

SIS-134073

GraduationSeal

method

varchar(15)

Changed data type from varchar(5) to varchar(15).

User-defined value.

SIS-129416

TranscriptCourse

standardName

nvarchar

Changed data type from varchar(500) to nvarchar.

State or district-defined standardname for this course.

Data Manipulation Language Scripts (DML)

This section lists scripts to add, modify, query, or remove data from a SQL Server database.

Case NumberStateDescription

SIS-135131


Cleanup Script for Behavior Incident Context and Location.

SIS-133645

WY

Immunization Rule Updated.

SIS-126145

GA

Immunization Rule Updated.

SIS-131679

AZ

Immunization Rule Updated.

SIS-130255

TC

Immunization Rule Updated.

SIS-134698

WI

Removed non-WI edfiResourcePreferences.

SIS-134007

CA

Immunization Rule Updated.

SIS-129034

KY

Conversion of BehaviorResolution schoolDaysDurationField.

SIS-133389


Converted remaining Ed-Fi v2 mapping. 

SIS-133389


Added DeleteOldErrorsFromEdFiErrorLog Job.

SIS-129486


Added DIS Object EarlyInterventionServiceBIE.

SIS-123647

MN

Moved Enrollment Fields from CustomStudent to EnrollmentMN.

SIS-130786


Transfered eCheck OLP Settings.

SIS-133896


Added roster report tool right.

SIS-132265


Deleted old mapping and choice discipline resources.

SIS-132886


Updated new program column.

SIS-133421

NJ

Added district.