Technical Information - Release Pack Campus.2132

These cases are included in the Campus.2132 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 NumberTableDescription
SIS-125073LessonPlanActivityDeprecatedDeprecated table.

SIS-148345

LepProgress

Modified Tables

Added

Case NumberTableColumnData TypeDescription
SIS-138440PlanServiceProvidedignoreDateValidationbitFlag to determine if start and end dates should be validated against Plan dates.
SIS-138440PlanStateresidentSchoolvarchar(100)Name identifying student's home school.
SIS-138440SEPGenericFormvarChar1varchar(8000)A generic field for text to be used as states see fit.
SIS-138440SEPTeamMeetingsepMeetingTypevarchar(150)Indicates what type the meeting record is.
SIS-145134TwentyFirstCCLCprogramProviderintIndicates program provider.
SIS-145134TwentyFirstCCLCfallVisitsintFall Visits
SIS-145134TwentyFirstCCLCspringVisitsintSpring Visits
SIS-145134TwentyFirstCCLCsummerVisitsintSummer Visits
SIS-145134TwentyFirstCCLCincreasedMathGradevarchar(15)Increased Math Grade
SIS-145134TwentyFirstCCLCincreasedReadingGradevarchar(15)Increased Reading Grade
SIS-145134TwentyFirstCCLCturningHomeworkOnTimevarchar(15)Turning Homework On Time
SIS-145134TwentyFirstCCLChomeworkSatisfactionvarchar(15)Completing Homework To Satisfaction
SIS-145134TwentyFirstCCLCparticipatingInClassvarchar(15)Participating In Class
SIS-145134TwentyFirstCCLCvolunteeringvarchar(15)Volunteering
SIS-145134TwentyFirstCCLCattendingClassRegularlyvarchar(15)Attending Class Regularly
SIS-145134TwentyFirstCCLCbeingAttentiveInClassvarchar(15)Being Attentive In Class
SIS-145134TwentyFirstCCLCbehavingWellInClassvarchar(15)Behaving Well In Class
SIS-145134TwentyFirstCCLCacademicPerformancevarchar(15)Academic Performance
SIS-145134TwentyFirstCCLCgettingAlongWellWithOthersvarchar(15)Getting Along Well With Others
SIS-145134TwentyFirstCCLCcomingMotivatedToLearnvarchar(15)Coming Motivated To Learn
SIS-146552MigrantcontinuationOfServicesReasonvarchar(225)Reason of continuing migrant services.
SIS-146670LessonPlanFlagPreferencestructureIDintInternal database identifier from ScheduleStructure table
SIS-147483EnrollmentMTsixWeekActivitiesvarchar(15)The number of six+ week activities a student is in.
SIS-147483EnrollmentMTeighteenWeekActivitiesvarchar(15)The number of eighteen+ week activities a student is in.
SIS-147483EnrollmentMTextracurriculuarActivitiesintWhether the student is extracurricular-only.
SIS-147634GraduationiepGradCourseReqvarchar(15)Indicates whether the Individualized Education Program (IEP) of a student with a disability contains an exemption or modification to the state course requirement component of NJDOE graduation requirements.
SIS-147634GraduationiepGradAttendancevarchar(15)Indicates whether the Individualized Education Program (IEP) of a student with a disability contains an exemption or modification to the local attendance requirement component of NJDOE graduation requirements.
SIS-147634LepliepInstructionLanguagevarchar(15)The language of instruction for the Language Instruction Educational Program (LIEP) course in which an English language learner (ELL) is placed in order to develop and attain English proficiency while meeting challenging State academic standards.
SIS-147188EnrollmentMTgiftedTalentedEvalbitIndicator of a student who has been evaluated for a gifted and talented program.
SIS-148145EarlyLearningearlyHeadStartbitPrior to attending a preschool program, the child received Early Head Start services.

Data Definition Language Scripts

DDL: Statements to create, alter, or drop data structures in an instance of SQL Server.

Case NumberStateDescription

SIS-100810

OH

Converted postGradPlans

SIS-124752


Converted school cityid attrbute

SIS-138440

PA

New Campus Defined Service

SIS-145511


Set Global Captcha preference and notification entry

SIS-146552


Added EdFiImport Job

SIS-146552


Added EdFiImport Job

SIS-146587


Scheduled IPGC to run for all active calendars

SIS-147133

CO

Updated District List

SIS-147188


Conversion of new EnrollmentMT giftedTalentedEval field

SIS-147434

CO

Updated District List

SIS-147634

NJ

Moved data to from Enrollment to Graduation

SIS-147993


Updated entityID in districtTable

SIS-148112

MA

Immunization Rule Update

SIS-148315


Removed DIS objects from sites that should not have them

SIS-148394

WY

Added dictionary code and SIF Mapping

SIS-148607

NT

Immunization Rule Update

SIS-148617


Regenerated Ed-Fi triggers