These cases are included in the Campus.2239 release pack.
We're making improvements
and we want to learn more about how customers use this article. Please respond to this survey and let us know what you use, what you don't use, and how the information in this article fits into your day. Thanks!
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-156958 | AssessmentUserSecurity | List of user groups allowed to view certain tests. |
SIS-157989 | CustomReadingDeficiency | Custom data for readingdeficiency records. |
SIS-157815 | CustomRefugee | Refugee district elements. |
SIS-158496 | DataExtractHistory | History for all the tasks ran through data extract utility. |
SIS-158496 | DataExtractUtil | Utility to extract data from campus and send it to a third party. |
SIS-157989 | ReadingDeficiency | State program readingdeficiency. |
SIS-157815 | Refugee | Refugee related data. |
Modified Tables
Added
Case Number | Table | Column | Description |
SIS-154690 | EnrollmentWI | evalOnlyStudent | Indicates a student is not currently enrolled in the school or district but is needed to report for special ed evaluation only for indicator 11 reporting. |
SIS-156902 | Homeless | missingDocAssistance | Indicates student is missing document assistance. |
SIS-156902 | Homeless | academicReferrals | Indicates academic referrals. |
SIS-156902 | Homeless | summerSchoolProgramAttended | Indicates program/tutoring attended summer school. |
SIS-156902 | Homeless | mcKinneyVentoConsult | Indicates student has a Mckinney-Vento consult. |
SIS-156902 | Homeless | welfare | Indicates welfare services. |
SIS-156902 | Homeless | transportation | Indicates transportation services. |
SIS-156902 | Homeless | crossDistrictTransDistrict | Indicates the cross district transportation district. |
SIS-156902 | Homeless | academicEnrichment | Indicates academic enrichment. |
SIS-156902 | Homeless | communityAgencyReferral | Indicates the community agency a student was referred to. |
SIS-156902 | Homeless | afterSchoolProgramAttended | Indicates program/tutoring attended after school. |
SIS-156902 | Homeless | beforeSchoolProgramAttended | Indicates program/tutoring attended before school. |
SIS-157441 | Graduation | compSciLang | Computer science is a sub for world language. |
SIS-157458 | PlanOfStudy | comments | Comments associated with the record. |
SIS-157458 | PlanOfStudy | schoolID | School associated with the record. |
SIS-158124 | EnrollmentSD | afterSchoolProgram | Indicates student participates in after school program. |
SIS-158294 | EnrollmentPA | bidAUN | Bid AUN |
SIS-158294 | EnrollmentPA | bidSchoolNumber | School number of bid. |
SIS-158294 | EnrollmentPA | pasaTestingAUN | Pasa testing AUN. |
SIS-158496 | EnrollmentMT | dropoutReason | Reason for dropping out. |
SIS-158496 | TranscriptRequest | authorized | |
SIS-158589 | Course | dualEnrollAUN | Indicates the district of dual enrollment. |
SIS-158589 | CourseCatalog | lockDualEnrollAUN | DualEnrollaun locked on course. |
SIS-158589 | CourseMaster | dualEnrollAUN | Indicates the district of dual enrollment. |
Altered
Case Number | Table | Column | Data Type | Note | Description |
SIS-154017 | FreeReducedIncomeGuide | mealStatus | varchar(1) | Changed data type from None to varchar(1). | The status with which the income guidelines will be associated (e.g., free, reduced). |
SIS-154017 | FreeReducedIncomeGuide | endYear | smallint | Changed data type from None to smallint. | The school year selected from the dropdown list and the end year associated with it as taken from the schoolyear table (e.g., the end year for the 08-09 school year is 2009). |
SIS-154017 | FreeReducedIncomeGuide | guideID | int | Changed data type from None to int. | Internal database identifier. |
SIS-154017 | FreeReducedIncomeGuide | yearlyIncome | decimal | Changed data type from None to decimal. | The maximum yearly income level associated with the meal status and household size. |
SIS-154017 | FreeReducedIncomeGuide | weeklyIncome | decimal | Changed data type from None to decimal. | The maximum weekly income level associated with the meal status and household size. |
SIS-154017 | FreeReducedIncomeGuide | biweeklyIncome | decimal | Changed data type from None to decimal. | The maximum biweekly income level associated with the meal status and household size. |
SIS-154017 | FreeReducedIncomeGuide | bimonthlyIncome | decimal | Changed data type from None to decimal. | The maximum bimonthly income level associated with the meal status and household size. |
SIS-154017 | FreeReducedIncomeGuide | memberCount | tinyint | Changed data type from None to tinyint. | The number of household members for the income guidelines. *locked field. |
SIS-154017 | FreeReducedIncomeGuide | monthlyIncome | decimal | Changed data type from None to decimal. | The maximum monthly income level associated with the meal status and household size. |
Deprecated
Case Number | Table | Column |
SIS-153300 | EnrollmentNJ | sentReceivedMISC |
SIS-153300 | EnrollmentNJ | sentReceivedCounty |
SIS-153300 | EnrollmentNJ | sentVocational |
SIS-153300 | EnrollmentNJ | onRoll |
SIS-153300 | EnrollmentNJ | onRollCategory |
SIS-153300 | EnrollmentNJ | assaEnrollmentCategory |
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-152243 | Appended Wildcard Route Fix to Custom Angular Tools. | |
SIS-153194 | Reindexed Person. | |
SIS-154017 | Updated Income Verbiage in FRAM Letters. | |
SIS-154247 | HI, NV | Hid StateExclude. |
SIS-154247 | State Exclude Attribute Modification. | |
SIS-155852 | Converted GraduationSeal type field to certificate field. | |
SIS-156302 | NV | Provided base set of Graduation diplomaTypes. |
SIS-156748 | Converted District Number Values. | |
SIS-158012 | NM | Inserted new state grade level. |
SIS-158187 | IN | Converted facilityCode to correct bad formatting. |
SIS-158375 | NE | Updated District List. |
SIS-158399 | KY | Updated FormDocument Program Services Plan. |
SIS-158484 | Added Lift Up Messenger Templates. | |
SIS-158601 | AZ | SPED - Converted Plan.exitReason to new code format with no leading zeroes. |
SIS-158620 | Set up decrypt email job. | |
SIS-158658 | ME | Updated stategradeLevelDefinition. |
SIS-158712 | MD | Dropped stored procs get MCAPElaMath, get MCAPMisa. |
SIS-158715 | ME | Dropped procedure get ME AttendanceCalculation. |
SIS-158761 | Added renew certificates quartz job. |
