This article collects the changes made to the database schema as part of the Campus.2627 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
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 | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-196005 | DependentCareMemberCredit | dependentCareMemberCreditID | int | no |
personID | int | no | ||
creditTypeCode | varchar(15) | no | ||
creditName | varchar(50) | no | ||
effectiveDate | date | no | ||
amount | decimal(9,2) | no | ||
comments | varchar(100) | yes | ||
createdByID | int | no | ||
createdDate | date | no | ||
SIS-196005 | DependentCareMember CreditBalanceAdjustment | dependentCareMemberCreditBalanceAdjustmentID | int | no |
personID | int | no | ||
adjustmentName | varchar(50) | no | ||
effectiveDate | date | no | ||
amount | decimal(9,2) | no | ||
comments | varchar(100) | yes | ||
createdByID | int | no | ||
createdDate | date | no | ||
SIS-196005 | DependentCareMemberCreditInvoice | dependentCareMemberCreditInvoiceID | int | no |
dependentCareSessionInvoiceID | int | no | ||
amount | decimal(9,2) | no | ||
SIS-196005 | DependentCarePaymentFailure | dependentCarePaymentFailureID | int | no |
dependentCarePaymentID | int | no | ||
amount | decimal(11,2) | no | ||
comment | varchar(150) | yes | ||
commentByID | int | yes | ||
commentDate | datetime2(0) | yes | ||
failureDate | datetime2(0) | no | ||
status | varchar(10) | no | ||
purchaseProductPaymentID | int | yes | ||
SIS-196005 | DependentCareRelatedPairAuthorization | dependentCareRelatedPairAuthorizationID | int | no |
dependentCareApplicationID | int | no | ||
personID | int | no | ||
authorized | bit | no | ||
SIS-196926 | PaymentsTaxSettings | paymentsTaxSettingsID | int | no |
paymentVendorAccountID | int | no | ||
varchar(254) | yes | |||
deliveryPreference | varchar(10) | no | ||
modifiedDateTime | datetime2(3) | no | ||
modifiedByID | int | yes | ||
SIS-197843 | CustomSummerEBT | customID | int | no |
attributeID | int | no | ||
summerEBTID | int | no | ||
value | varchar(256) | yes | ||
date | date | yes | ||
SIS-197843 | SummerEBT | summerEBTID | int | no |
personID | int | no | ||
districtID | int | yes | ||
summerEBTGUID | uniqueidentifier | no | ||
modifiedByID | int | yes | ||
modifiedDate | date | yes | ||
startDate | date | no | ||
endDate | date | yes | ||
schoolYear | varchar(15) | yes | ||
createdDate | date | yes | ||
comments | varchar(255) | yes | ||
appealOutcome | varchar(15) | yes | ||
denialReason | varchar(15) | yes | ||
eligibilityStatus | varchar(15) | yes | ||
issuanceStatus | varchar(15) | yes | ||
issuanceDate | date | yes | ||
tribalEligibility | bit | no | ||
eligibilityDate | date | yes | ||
incomeVerification | varchar(15) | yes | ||
stateDirectCertification | bit | no | ||
residencyVerified | bit | no | ||
SIS-197843 | SummerEBTValue | summerEBTValueID | int | no |
summerEBTID | int | no | ||
summerEBTValueGUID | uniqueidentifier | no | ||
attributeID | int | no | ||
value | varchar(15) | yes | ||
SIS-198890 | NCUIDRequestLog | logID | int | no |
personID | int | no | ||
firstName | varchar(50) | yes | ||
lastName | varchar(50) | yes | ||
middleName | varchar(50) | yes | ||
suffix | varchar(50) | yes | ||
birthdate | date | yes | ||
gender | varchar(1) | yes | ||
raceEthnicCode | varchar(6) | yes | ||
grade | varchar(4) | yes | ||
stateGrade | varchar(4) | yes | ||
districtCode | varchar(12) | yes | ||
schoolCode | varchar(3) | yes | ||
existingStateID | varchar(15) | yes | ||
endYear | varchar(5) | yes | ||
modifiedByID | int | yes | ||
returnedStateID | varchar(15) | yes | ||
nearMatch | bit | yes | ||
httpResponseCode | varchar(3) | yes | ||
errorMessage | varchar(8000) | yes | ||
requestTimestamp | datetime2(2) | no | ||
SIS-198890 | NCUIDRequestQueue | queueID | int | no |
personID | int | no | ||
endYear | int | no | ||
modifiedByID | int | no | ||
status | varchar(20) | no | ||
retryCount | int | no | ||
errorMessage | varchar(8000) | yes | ||
createdTimestamp | datetime2(2) | no | ||
processedTimestamp | datetime2(2) | yes | ||
SIS-199158 | COPaymentsDeviceCode | paymentDeviceCodeID | int | no |
deviceCode | varchar(6) | no | ||
mobileDeviceID | int | yes | ||
expirationTimestampUTC | datetime2(0) | no |
Deleted Tables
Case Number | Table |
|---|---|
SIS-199889 | ACT_EVT_LOG |
SIS-199889 | ACT_GE_BYTEARRAY |
SIS-199889 | ACT_GE_PROPERTY |
SIS-199889 | ACT_HI_ACTINST |
SIS-199889 | ACT_HI_ATTACHMENT |
SIS-199889 | ACT_HI_COMMENT |
SIS-199889 | ACT_HI_DETAIL |
SIS-199889 | ACT_HI_IDENTITYLINK |
SIS-199889 | ACT_HI_PROCINST |
SIS-199889 | ACT_HI_TASKINST |
SIS-199889 | ACT_HI_VARINST |
SIS-199889 | ACT_PROCDEF_INFO |
SIS-199889 | ACT_RE_DEPLOYMENT |
SIS-199889 | ACT_RE_MODEL |
SIS-199889 | ACT_RE_PROCDEF |
SIS-199889 | ACT_RU_DEADLETTER_JOB |
SIS-199889 | ACT_RU_EVENT_SUBSCR |
SIS-199889 | ACT_RU_EXECUTION |
SIS-199889 | ACT_RU_IDENTITYLINK |
SIS-199889 | ACT_RU_JOB |
SIS-199889 | ACT_RU_SUSPENDED_JOB |
SIS-199889 | ACT_RU_TASK |
SIS-199889 | ACT_RU_TIMER_JOB |
SIS-199889 | ACT_RU_VARIABLE |
SIS-199889 | Workflow |
SIS-199889 | WorkflowMessageTemplate |
SIS-199889 | WorkflowMessageTemplateVariable |
SIS-199889 | WorkflowProcess |
SIS-199889 | WorkflowProcessHistory |
SIS-199889 | WorkflowProcessVariable |
SIS-199889 | WorkflowResource |
SIS-199889 | WorkflowSelectionRule |
SIS-199889 | WorkflowSelectionRuleElement |
SIS-199889 | WorkflowTaskForm |
SIS-199889 | WorkflowTemplate |
SIS-199889 | WorkflowTemplateVersion |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-198443 | CampusJobTrigger | splaySet | bit | no |
SIS-196005 | DependentCarePayment | dependentCareSessionInvoiceID | int | yes |
SIS-196005 | DependentCareSectionAttendance | dependentCareRelatedPairAuthorizationID | int | yes |
SIS-196005 | DependentCareSession | lastInvoiceProcessDate | date | yes |
SIS-196005 | DependentCareSession | invoiceBillType | varchar(2) | no |
SIS-196005 | DependentCareSession | invoiceTimeframe | varchar(2) | no |
SIS-196005 | DependentCareSession | invoiceSchedule | varchar(2) | no |
SIS-196005 | DependentCareSession | invoiceWeeklyRunDay | varchar(2) | yes |
SIS-196005 | DependentCareSession | invoiceMonthlyRunDay | varchar(2) | yes |
SIS-196005 | DependentCareSession | invoiceInformation | varchar(200) | yes |
SIS-196005 | DependentCareSessionInvoice | startDate | date | no |
SIS-196005 | DependentCareSessionInvoice | endDate | date | no |
SIS-196005 | DependentCareSessionInvoice | personID | int | no |
SIS-196005 | DependentCareSessionInvoice | totalAmount | decimal(7,2) | yes |
SIS-196005 | DependentCareSessionInvoice | rollForwardAmount | decimal(7,2) | yes |
SIS-196005 | DependentCareSessionInvoice | paidInFullDateTime | datetime2(0) | yes |
SIS-196005 | DependentCareSessionInvoice | generationDate | date | no |
SIS-196005 | DependentCareSessionInvoice | dueDate | date | no |
SIS-196005 | DependentCareSessionInvoice | billedOverdue | bit | no |
SIS-196005 | DependentCareSessionInvoice | rolledDependentCareSessionInvoiceID | int | yes |
SIS-196005 | DependentCareSessionMemberCharge | customAmount | decimal(7,2) | yes |
SIS-196005 | DependentCareSetting | weeklyDue | int | no |
SIS-196005 | DependentCareSetting | monthlyDue | int | no |
SIS-196005 | DependentCareSetting | oneRowConstraint | int | no |
SIS-199959 | EnrollmentDE | studentCharacteristics | varchar(50) | yes |
SIS-198981 | Graduation | gradOptOut | bit | no |
SIS-199158 | MobilePaymentsDevice | linkFlow | varchar(8) | no |
SIS-195815 | POSEligibility | stateEligible | bit | no |
SIS-195815 | POSPurchasable | stateEligible | bit | no |
SIS-195815 | POSPurchasable | statePrice | decimal(5,2) | yes |
SIS-195815 | POSPurchasablePriceHistory | statePrice | decimal(5,2) | yes |
SIS-197843 | RecordsTransfer | summerEBTXML | varchar(max) | yes |
SIS-197843 | RecordsTransfer | summerEBTFOP | varchar(100) | yes |
SIS-194074 | SEPStateReportedData | regionalDayProgram | varchar(15) | yes |
SIS-194074 | SEPStateReportedData | regionalDayProgramString | varchar(50) | yes |
SIS-194074 | SEPStateReportedData | LEAOfRDSPDService | varchar(50) | yes |
Altered Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-194761 | CFDocument | version | varchar(200) | yes |
SIS-196005 | DependentCarePayment | dependentCareInvoiceID | int | yes |
SIS-196005 | DependentCareSessionCharge | calculation | varchar(15) | yes |
SIS-196005 | DependentCareSessionInvoice | dependentCareInvoiceID | int | yes |
SIS-196005 | DependentCareSetting | runInvoices | varchar(10) | yes |
SIS-196005 | DependentCareSetting | invoiceDueBuffer | int | yes |
SIS-196733 | EdFiApplication | clientSecret | varchar(500) | no |
Deprecated Columns
Ordered by Table Name.
Case Number | Table | Column |
|---|---|---|
SIS-196005 | DependentCareAuthorizedPickup | relationship |
SIS-196005 | DependentCareAuthorizedPickup | guardian |
SIS-196005 | DependentCareAuthorizedPickup | workPhone |
SIS-196005 | DependentCareAuthorizedPickup | cellPhone |
SIS-196005 | DependentCareSetting | runInvoices |
SIS-196005 | DependentCareSetting | invoiceDueBuffer |
Renamed Tables and Columns
Case Number | Table | New Name | Column | New Name |
|---|---|---|---|---|
SIS-196005 | DependentCareAuthorizedPickup | NoChange | homePhone | phone |
SIS-196005 | DependentCareSectionAttendance | NoChange | checkInTime | checkInDateTime |
checkOutTime | checkOutDateTime |
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-189024 | Added job to hash passwords and adjust frequency to be nightly | |
SIS-189024 | Hash Unhashed Passwords on a Regular Basis | |
SIS-196005 | Dropped All Removed and Renamed Dependent Care Stored Procedures | |
SIS-196005 | Dropped unused Dependent Care Financial Report stored procedures | |
SIS-196005 | Added startup trigger for DependentCareInvoiceJob | |
SIS-196005 | Dependent Care Add Flex Schedule | |
SIS-196005 | Added Flex Schedule | |
SIS-196005 | Updated Dependent Care Notification Type elementsUrl | |
SIS-196036 | CO | Immunization Rule Update |
SIS-196194 | CO | Renamed district |
SIS-197368 | DE | Removed Student504ProgramAssociation from resource preferences |
SIS-197376 | Added new view gender tool right for all existing user groups | |
SIS-197376 | Updated name lock on Gender Attribute | |
SIS-197376 | Added View Gender Preference | |
SIS-197606 | KY | Immunization Rule Update |
SIS-197843 | Added SummerEBT DIS Object | |
SIS-198537 | NY | Converted SCED Course ID |
SIS-198823 | Fixed up unmapped state Course Requirement field | |
SIS-198852 | Immunization Rule Update | |
SIS-198890 | Created NcUidQueueProcessorJob | |
SIS-199295 | NC | District record updates |
SIS-199306 | VT | Immunization Rule Update |
SIS-199307 | MD | Fixed wyEval19 replace MD field |
SIS-199494 | Added RSV Vaccine | |
SIS-199757 | DE | Added new Behavior Resolution stateCode |
SIS-199988 | Letter to Household Disclaimer Update | |
SIS-200149 | NC | District number updates |
