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