These cases are included in the Campus.2227 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
There were no new tables added with this release.
Modified Tables
Because of a recent change to our database, Data Type information is no longer provided for these changes. Please comment at the end of this article if you have any concerns. Thank you!
Added
Case Number | Table | Column | Description |
SIS-149430 | Cloud | offPrem | Indicates that CDR is hosted off premises. |
SIS-153086 | School | ncesDistrictIDOverride | Override field used when CNES district id differs from the value in the associated district record. |
SIS-153242 | Course | activityType | Indicates the type of activity for the course. |
SIS-153242 | CourseCatalog | lockActivityType | ActivityType locked on course. |
SIS-153242 | CourseMaster | activityType | Indicates the type of activity for the course. |
SIS-153242 | EnrollmentAZ | cteCreditHours | Total CTE credit hours attempted. |
SIS-153242 | EnrollmentAZ | cteMinutes | Total number of planned instructional minutes in CTE courses. |
SIS-155768 | Evaluation | stateReportExclude | OH state reporting reporting exclude checkbox. |
SIS-155768 | Plan | stateReportExclude | OH state reporting reporting exclude checkbox. |
SIS-155771 | EarlyLearning | addEligFactors | CSVv of codes concerning additional factors for child's eligibility. |
SIS-155771 | EarlyLearning | qualFactors | CSV of codes concerning factors for child's eligibility. |
SIS-156481 | SecurityAccess | loggedInApp | Enumeration indicating if the user logged into campus student or campus parent. |
SIS-156350 | Enrollment | excludeFromDpsaCalculation | Indicates whether to exclude from DPSA calculations. |
SIS-156350 | Enrollment | dpsaReportedTier | Reported tier for direct post secondary admissions. |
SIS-156350 | Enrollment | dpsaCalculatedTier | Calculated tier for direct post secondary admissions. |
SIS-156350 | Program | dpsaTier | Configured tier for direct post secondary admission. |
SIS-156424 | AltProgram | eligibilityDetails | Details relating to a student's eligibility. |
SIS-156875 | InstructionMode | learningModality | Indicates the learning modality mode a student is participating in. |
Deprecated
Case Number | Table | Column | Description |
SIS-155771 | MIEarlyChildhood | workingParents | Y or n status of whether child's parents work |
SIS-155771 | MIEarlyChildhood | endDate | The end date of the early childhood program. |
SIS-155771 | MIEarlyChildhood | startDate | The start date of the early childhood program. |
SIS-155771 | MIEarlyChildhood | exitReason | The reason the child left the program. |
SIS-155771 | MIEarlyChildhood | qualFactors | CSV of codes concerning factors for child's eligibility |
SIS-155771 | MIEarlyChildhood | earlyChildhoodID | Internal database identifier |
SIS-155771 | MIEarlyChildhood | fundingType | Type of funding for student in EC program |
SIS-155771 | MIEarlyChildhood | personID | Internal database identifier |
SIS-155771 | MIEarlyChildhood | fiscalEntity1 | The state-assigned code identifying the entity receiving funding directly from the state to provide programs and/or services to the student/child reported. |
SIS-155771 | MIEarlyChildhood | addEligFactors | CSV of codes concerning additional factors for child's eligibility |
SIS-155771 | MIEarlyChildhood | licenseNumber | License number to the location child receives EC services. |
SIS-155771 | MIEarlyChildhood | deliveryMethod | Location through which the program is given. |
SIS-155771 | MIEarlyChildhood | comment | Early childhood program details |
SIS-155771 | MIEarlyChildhood | fiscalEntity2 | The state-assigned code identifying the entity receiving funding directly from the state to provide programs and/or services to the student/child reported. |
SIS-155771 | MIEarlyChildhood | deliverySchedule | Schedule of programming |
SIS-155771 | MIEarlyChildhood | daysPerWeek | The number of days per week that the early childhood program meets. |
SIS-155771 | MIEarlyChildhood | povertyLevel | The federal poverty level that a child belongs to. |
SIS-155771 | MIEarlyChildhood | program | Program code and name. |
SIS-155771 | MIEarlyChildhood | hoursPerDay | The number of hours per day that the early childhood program meets. |
SIS-155773 | EnrollmentMI | supportService3 | The third of any special educational support services that are provided to the student, ranked by contact time. |
SIS-155773 | EnrollmentMI | specialEducation | |
SIS-155773 | EnrollmentMI | programService1 | The first of any special education programs or services in which the student participates, ranked by contact time. |
SIS-155773 | EnrollmentMI | migrantPrevention | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (mep) funds. |
SIS-155773 | EnrollmentMI | title1SocialWork | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | adultEdJulyFTE1 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | atRiskSupport2 | |
SIS-155773 | EnrollmentMI | programService3 | The third of any special education programs or services in which the student participates, ranked by contact time. |
SIS-155773 | EnrollmentMI | migrantHealth | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (mep) funds. |
SIS-155773 | EnrollmentMI | adultEdFebProgram2 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | adultEdJulyProgram3 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | adultEdSeptFTE2 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | migrantInstructionOther | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (mep) funds. |
SIS-155773 | EnrollmentMI | adultEdAprilProgram2 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | migrantSummerEyeCare | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (mep) funds. |
SIS-155773 | EnrollmentMI | earlyOnEligibility | Indicates the student's early on service eligibility. |
SIS-155773 | EnrollmentMI | giftedProgramOption1 | The type(s) of advanced or accelerated program(s) the student participated in at any point during the current school year. |
SIS-155773 | EnrollmentMI | refugee | |
SIS-155773 | EnrollmentMI | adultEdAprilFTE1 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | migrantSummerReading | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | title1InstructionOther | Indicates the title i instructional service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | adultEdSeptFTE3 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | atRiskSupport4 | |
SIS-155773 | EnrollmentMI | qualifyMoveDate | Date of the most recent move that qualifies the student for migrant education services. |
SIS-155773 | EnrollmentMI | adultEdDiploma | |
SIS-155773 | EnrollmentMI | migrantSummerEnglish | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | migrantTransportation | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | title1Health | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | title1SupportOther | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | adultEdSeptProgram1 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | migrantSummerMath | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | earlyOnService2 | Indicates the early-on service being provided to the student. |
SIS-155773 | EnrollmentMI | atRiskInstruction6 | |
SIS-155773 | EnrollmentMI | cclc21stCentury | Indicates the student is eligible and/or participates in a 21st century cclc program. |
SIS-155773 | EnrollmentMI | migrantSummerDental | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | votechRegularCareer | |
SIS-155773 | EnrollmentMI | giftedProgramOption2 | The type(s) of advanced or accelerated program(s) the student participated in at any point during the current school year. |
SIS-155773 | EnrollmentMI | migrantSummerVocational | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | atRiskInstruction4 | |
SIS-155773 | EnrollmentMI | migrantMath | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | title1Math | Indicates the title i instructional service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | supportService5 | The fifth of any special educational support services that are provided to the student, ranked by contact time. |
SIS-155773 | EnrollmentMI | migrantSummerTransportation | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | earlyOnExitReason | Indicates the reason the student exited early-on services. |
SIS-155773 | EnrollmentMI | migrantSummerCounseling | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | votechAcademicDisadvantaged | |
SIS-155773 | EnrollmentMI | migrantDental | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | adultEdSeptProgram3 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | adultEdAprilFTE2 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | adultEdFebFTE3 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | ecEnrollment3 | No longer reported |
SIS-155773 | EnrollmentMI | atRiskSupport3 | |
SIS-155773 | EnrollmentMI | adultEdAprilProgram3 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | supportService1 | The first of any special educational support services that are provided to the student, ranked by contact time. |
SIS-155773 | EnrollmentMI | migrantEnglish | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | adultEdFunding | Indicates the entity funding the adult education. |
SIS-155773 | EnrollmentMI | atRiskInstruction1 | |
SIS-155773 | EnrollmentMI | migrantVocational | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | atRiskInstruction3 | |
SIS-155773 | EnrollmentMI | adultEdFebProgram3 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | giftedProgramOption3 | The type(s) of advanced or accelerated program(s) the student participated in at any point during the current school year. |
SIS-155773 | EnrollmentMI | migrantSummerSocialWork | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | title1Prevention | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | collegeParticipation | Indicates the student is eligible and/or participates in an early/middle college participation program. |
SIS-155773 | EnrollmentMI | earlyOnService5 | Indicates the early-on service being provided to the student. |
SIS-155773 | EnrollmentMI | alternativeEducation | Indicates the student is eligible and/or participates in an alternative ed program. |
SIS-155773 | EnrollmentMI | adultEdSeptProgram2 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | outOfState | Used to identify which type of categorical program/service the student is eligible and/or participates in. |
SIS-155773 | EnrollmentMI | adultEdFebFTE1 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | title1TAS | |
SIS-155773 | EnrollmentMI | migrantFunding | Indicates the type of funding through which the student is eligible to receive programs/services. |
SIS-155773 | EnrollmentMI | adultEdJulyFTE3 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | title1English | Indicates the title i instructional service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | title1EyeCare | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | atRiskInstruction2 | |
SIS-155773 | EnrollmentMI | migrantSocialStudies | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | ecEnrollment5 | No longer reported |
SIS-155773 | EnrollmentMI | cteFollowUp | |
SIS-155773 | EnrollmentMI | earlyOnService3 | Indicates the early-on service being provided to the student. |
SIS-155773 | EnrollmentMI | teamMeetingDate | |
SIS-155773 | EnrollmentMI | advanceAccelerated | Not a field |
SIS-155773 | EnrollmentMI | title1SocialStudies | Indicates the title i instructional service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | personalCurriculum | Indicates the academic area(s) for which the student has a personal |
SIS-155773 | EnrollmentMI | adultEdJulyProgram2 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | programService2 | The second of any special education programs or services in which the student participates, ranked by contact time. |
SIS-155773 | EnrollmentMI | votechCompletion | |
SIS-155773 | EnrollmentMI | ecEnrollment1 | No longer reported |
SIS-155773 | EnrollmentMI | pepeDistrict | The primary education providing entity (PEPE) district code. the PEPE district is the district where the student is actually being educated. this may or may not be the entity claiming the FTE for the student. this is also the entity accountable for AYP if it carries the ?accountable for AYP? flag in the EEM. |
SIS-155773 | EnrollmentMI | cteProgram4 | Indicates the CTE program the student is participating in. |
SIS-155773 | EnrollmentMI | migrantEyeCare | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | migrantSummerScience | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | title1Counseling | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | migrantScience | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | seatTimeWaiver | |
SIS-155773 | EnrollmentMI | atRiskInstruction5 | |
SIS-155773 | EnrollmentMI | migrantSupportOther | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | adEducation | Indicates the student is participating in adult education. |
SIS-155773 | EnrollmentMI | supportService2 | The second of any special educational support services that are provided to the student, ranked by contact time. |
SIS-155773 | EnrollmentMI | title1Dental | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | votechDisplacedHomemaker | |
SIS-155773 | EnrollmentMI | ifspDate | Date the IEFSP began |
SIS-155773 | EnrollmentMI | migrantSummerSocialStudies | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | pepeRequestJustification | The reason for this request to change the student's PEPE. |
SIS-155773 | EnrollmentMI | cteProgram3 | Indicates the CTE program the student is participating in. |
SIS-155773 | EnrollmentMI | earlyOnExitDate | The date the student exited early-on services. |
SIS-155773 | EnrollmentMI | ecEnrollment4 | No longer reported |
SIS-155773 | EnrollmentMI | adultEdFebProgram1 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | earlyOnService6 | Indicates the early-on service being provided to the student. |
SIS-155773 | EnrollmentMI | supportService4 | The fourth of any special educational support services that are provided to the student, ranked by contact time. |
SIS-155773 | EnrollmentMI | adultEdAprilFTE3 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | votechJuvenileOffender | Indicates if the student is considered a juvenile offender (committed a crime). |
SIS-155773 | EnrollmentMI | cteProgram1 | Indicates the CTE program the student is participating in. |
SIS-155773 | EnrollmentMI | multipleBirth | Indicates the student was part of a multiple birth. this field is intended to prove some distinguishing data for cases where the cultural practice is to provide twins (triplets, etc) of the same gender with the same first name or where children of the same gender have similar first names. |
SIS-155773 | EnrollmentMI | primarySetting | Indication of the student's setting for part c programming |
SIS-155773 | EnrollmentMI | cteProgram2 | Indicates the CTE program the student is participating in. |
SIS-155773 | EnrollmentMI | adultEdAprilProgram1 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | adultEdFebFTE2 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | votechLEP | |
SIS-155773 | EnrollmentMI | title1Transportation | Indicates the title 1 support service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | ecExitReason | The reason the student exited the early childhood program. |
SIS-155773 | EnrollmentMI | adultEdJulyProgram1 | Indicate the adult education program in which the student participates. |
SIS-155773 | EnrollmentMI | adultEdSeptFTE1 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | migrantSummerInstructionOther | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | title1Reading | Indicates the title i instructional service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | title1Vocational | Indicates the title i instructional service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | migrantSocialWork | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | migrantSummerPrevention | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | votechSingleParent | |
SIS-155773 | EnrollmentMI | atRiskSupport1 | |
SIS-155773 | EnrollmentMI | votechDisabled | |
SIS-155773 | EnrollmentMI | internationalStudent | Used to identify which type of categorical program/service the student is eligible and/or participates in. |
SIS-155773 | EnrollmentMI | migrantReading | The student's instructional service during the reported term. this includes only those instructional services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | iepDate | Date the IEP began |
SIS-155773 | EnrollmentMI | migrantSummerHealth | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | retentionKindergarten | Used to identify which type of categorical program/service the student is eligible and/or participates in. |
SIS-155773 | EnrollmentMI | earlyOnService1 | Indicates the early-on service being provided to the student. |
SIS-155773 | EnrollmentMI | earlyOnService4 | Indicates the early-on service being provided to the student. |
SIS-155773 | EnrollmentMI | title1Science | Indicates the title i instructional service(s) received by the student in a targeted assistance schools program. |
SIS-155773 | EnrollmentMI | giftedProgramModel | The type(s) of advanced or accelerated program(s) the student participated in at any point during the current school year. |
SIS-155773 | EnrollmentMI | ecEnrollment2 | No longer reported |
SIS-155773 | EnrollmentMI | pepeBuilding | The primary education providing entity (PEPEpe) building code. the PEPE building is the building where the student is being educated. this is also the entity accountable for AYP if it carries the ?accountable for AYP? flag in the EEM. if the entity code entered is a unique education provider (UEP), it cannot be an accountable entity. |
SIS-155773 | EnrollmentMI | pepeEffectiveDate | The date that the requested PEPE change(s) will be effective. |
SIS-155773 | EnrollmentMI | migrantCounseling | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | migrantSummerSupportOther | The student's support services during the reported term. this includes only those support services provided in whole or in part with migrant education program (MEP) funds. |
SIS-155773 | EnrollmentMI | adultEdJulyFTE2 | The full time equivalency (FTE) for which the student is eligible for the instructional program identified. |
SIS-155773 | EnrollmentMI | relatedWorkStudy |
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-140809 | FRAMIncomeGuide02-03 | |
SIS-148676 | KS | Section 504 Conversion |
SIS-150931 | Added Edit Lockers subRight for Lockers in Instruction | |
SIS-151999 | Added preference for offering off premises digital repository | |
SIS-151999 | Added column to Cloud table | |
SIS-152109 | MN | Immunization Rule Update |
SIS-153690 | Excluded Attendance Tables | |
SIS-154553 | MI | Converted BorderStudent records. |
SIS-154553 | MI | Converted BorderStudent records |
SIS-155059 | Updated seq for Cov2 | |
SIS-155059 | Changed seq to 5 | |
SIS-155059 | Added COV2 vaccine code | |
SIS-155693 | MT | Immunization Rule Update |
SIS-155771 | MI | Converted EarlyChildhood to Early Learning |
SIS-155938 | WY | Immunization Rule Update |
SIS-156085 | NJ | Updated Insert Districts |
SIS-156127 | KS | Homeless Conversion |
SIS-156537 | Updated standard type varchar length | |
SIS-156320 | KY | Updated inactivated language codes |
SIS-156703 | Updated existing SCEDConcentrator Code | |
SIS-156875 | WI | Conversion of InstructionMode.status to InstructionMode.learningModality |
SIS-156911 | Reindexed newNavPreference | |
| SIS-156928 | Enabled new look for in-district hosting. | |
SIS-156914 | Converted program meeting times |
