Technical Information - Release Pack Campus.2001

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

BIEDMAssessmentCertification

BIE assessment certification data.

SIS-130110

BIEDMAssessmentVerification

BIE assessment verification data.

SIS-130110

BIEDMAttendanceCertification

BIE attendance certification data.

SIS-130110

BIEDMAttendanceVerification

BIE attendance verification data.

SIS-130110

BIEDMCohortsCertification

BIE cohort certification data.

SIS-130110

BIEDMCohortsVerification

BIE cohort verification data.

SIS-130110

BIEDMParticipationCertification

BIE participation certification data.

SIS-130110

BIEDMParticipationVerification

BIE participation verification data.

SIS-130653

EdFiResync

Holds records to be processed for Ed-Fi, when the resync is requested through the resync tool.

SIS-130653

EdFiResyncResource

Holds configuration references, and resource name that relate to the selection that was made when the resync was requested.

SIS-130653

EdFiResyncSchool

Holds configuration and school references that relate to the selection that was made when the resync was requested.

SIS-131062

UserGroupDataValidationGroupRights


Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-131651

Course

academicLevel

varchar(2)

Used to identify the course academic level.

SIS-131651

CourseCatalog

lockAcademicLevel

bit

Indicates lockAcademicLevel is locked on a course.

SIS-131651

CourseMaster

academicLevel

varchar(2)

Used to identify the course academic level.

SIS-131062

DataValidationDef

dataValidationDefGUID

uniqueidentifier

Internal database identifier.

SIS-130653

EdFiConfiguration

studentUniqueID

varchar(15)

The unique identifier to be used for student.

SIS-130653

EdFiConfiguration

staffUniqueID

varchar(15)

The unique identifier to be used for staff.

SIS-130653

EdFiErrorLog

configurationType

varchar(5)

The type of the Ed-Fi configuration: state or core.

SIS-130653

EdFiEventQueue

configurationType

varchar(5)

The type of the Ed-Fi configuration: state or core.

SIS-130653

EdFiEventQueueHistory

configurationType

varchar(5)

The type of the Ed-Fi configuration: state or core.

SIS-130653

EdFiEventQueueHistory

schoolID

int

School that the record relates to.

SIS-130653

EdFiTables

configurationType

varchar(5)

Configuration type (state or core) for this combination of trigger information.

SIS-130484

Migrant

servicesEndDate

smalldatetime

Indicates the date services ended.

SIS-127957

NHCATE

apprenticeshipProgram

bit

Participation in an approved apprenticeship program.

SIS-127957

NHCATE

careerPathway

bit

Participation in career pathways.

SIS-132115

ProgramPerson

instHrsMet

bit

Indicates if they are receiving at least 700 instructional hours in the CTE program in one year.

SIS-131230

SEEGenericForm

vcMax17

varchar(MAX)

A field for text.

SIS-131230

SEEGenericForm

vcMax16

varchar(MAX)

A field for text.

SIS-131727

SEPlan

exitReason

varchar(15)

Reason for exit from program. used for Idaho PLP.

SIS-131727

SEPlan

tinyint1

tinyint

Generic tinyint field for checkbox use to meet different state needs

SIS-131727

SEPlan

exitDate

smalldatetime

Date of exit from program. used for Idaho PLP.

SIS-131727

SEPlan

contentArea

varchar(15)

The content area for the RTI plan.

SIS-131727

SEPlan

parentInputDate

smalldatetime

This table is used in special education OMPS.

SIS-131727

SEPlan

programCode

varchar(20)

Program code which is a state reported code for CO.

SIS-132433

TestAccommodations

accessibilityMode

bit

Test accommodation setting option.

SIS-131651

TranscriptCourse

academicLevel

varchar(2)

Used to identify the course academic level.

SIS-131651

TranscriptCourse

charterNonCoreCollegePrep

bit

CA - an indication of whether or not a charter school has identified a course as non-core, non-college preparatory. a “y” would mean that the course is non-core, non-college prep. an “n” would mean that the course is a core or college prep course.

SIS-131651

TranscriptCourse

middleSchoolCoreCourseInd

bit

CA - an indication of whether or not a course is being taught in a middle school core setting. e.g., two blocked periods of math and science taught by a teacher in grades 5-8.

SIS-131651

TranscriptCourse

gssmCategory

varchar(15)

Indicates which CA GSSM category the course counts towards.

SIS-131651

TranscriptCourse

teachingMethod

varchar(4)

Stores the teaching method of the course.

SIS-131651

TranscriptCourse

embeddedCourseNumber

varchar(20)

Indicates the state course number of the course this course should roll up to.

SIS-131651

TranscriptCourse

level

varchar(4)

Indicates the level of the course. not available in all states.

SIS-131651

TranscriptCourse

wblCourseType

varchar(15)

Indicates the type of work-based learning program in which a student is enrolled.

SIS-131651

TranscriptCourse

highQualityCTEInd

bit

CA - indicates whether the course section and teacher meet the high quality CTE course qualifications.

SIS-131651

TranscriptCourse

contentStandard

varchar(20)

The content standard of the course. Not available in all states.

SIS-132901

UserReportOption

name

varchar(1024)

Template name.

SIS-132901

UserReportOption

template

bit

Indicates whether a record is for a user-defined template.

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-132592


Inactivated customer locations if customer is inactive.

SIS-132592


ARInvoiceItem made arItemMasterID nullable.

SIS-132592


Converted Customer Inquiry rights.

SIS-132592


Converted AR Invoice Inquiry rights.

SIS-132592


Converted AR Batch Inquiry rights.

SIS-131456

NY

Immunization Rule Updated.

SIS-130653


Ed-Fi convert config type and uniqueId.

SIS-131903

ID

Added new eval area attributes and convert exisiting to share definition dictionary.

SIS-133118

MN

EdFi ID population.

SIS-131062


Added DIS Object DataValidationDef.

SIS-130216


Updated Grading Services Vendor Process Inbox Message.

SIS-132626

MI

Inactivated Demo IEP PlanType.

SIS-131861

CA

Unlocked context location.

SIS-131762

NH

Immunization Rule Update.

SIS-130339

MO

Immunization Rule Update.

SIS-131651

CA

Updated new columns.

SIS-131927


Updated convenience to service fee FinanceSubSystemPosting.

SIS-130160


ServiceFeeFundAccount.

SIS-131452


Updated falg to flag.