These cases are included in the Campus.2215 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.
Case Number | Table | Description |
|---|---|---|
SIS-141352 | DEUConnectionConfig | Connection information that can be consumed by any data extract utility entry. |
SIS-151327 | PaymentTransactionFeeDistribution | Details how a transaction fee is distributed between different transaction products. |
SIS-153088 | SectionStudentDetailValue |
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-146779 | SAMLSPConfig | hideParentPortalSSO | Hide SSO for parent portal users. |
SIS-146779 | SAMLSPConfig | hideMainLoginSSO | Hide SSO for main login page users. |
SIS-146779 | SAMLSPConfig | hideStudentPortalSSO | Hide SSO for student portal users. |
SIS-146779 | UserAccount | samlConfigurationID | Foreign key of the samlspconfig.configid |
SIS-150167 | Employment | exitReason3 | Tertiary reason the employee is no longer employed at the district. |
SIS-150167 | Employment | exitReason2 | Secondary reason the employee is no longer employed at the district. |
SIS-150167 | EmploymentAssignment | adultEd | Indicates Adult Ed only type position. |
SIS-150167 | EmploymentAssignment | ell | Indicates English language only type position. |
SIS-152565 | EarlyWarningScoreDaily | districtID | Reference to district table. |
SIS-152565 | EarlyWarningScoreMonthly | districtID | Reference to district table. |
SIS-152565 | EarlyWarningScoreYearly | districtID | Reference to district table. |
SIS-152921 | PsNotification | subSystem | Indicates part of SIS that the notification corresponds with. |
SIS-152921 | PsNotification | schoolID | References school that notification is attached to. |
SIS-153206 | EnrollmentCO | remoteLearningCode | Indicates if the student was enrolled in full time distance learning. |
Deprecated
Case Number | Table | Column | Description |
SIS-154372 | OLPSettings | transFeeFinDefaultID | Foreign key to the finance sub system default for transaction fees |
SIS-154372 | OLPSettings | serviceFeeFinDefaultID | Foreign key to the finance sub system default for service fees |
SIS-154372 | PaymentTransaction | ccStatus | This is only returned for credit card transactions. p=processed, e=error, did not process, f=failed, did not process. |
SIS-154372 | PaymentTransaction | accountType | C=checking, s=savings, cc=credit card. |
SIS-154372 | PaymentTransaction | ccAuthDesc | Text description of the credit card authorization response. this is only returned for credit card transactions. this can be used as the fail reason for a credit card transaction. |
SIS-154372 | PaymentTransaction | paymentTransactionStateID | Internal database identifier |
SIS-154372 | PaymentTransaction | returnCode | Vendor generated code for the reason of the return. null if transaction was not returned. |
SIS-154372 | PaymentTransaction | customerRef | A value generated by Vanco to identify a payer. this is a unique value in campus. |
SIS-154372 | PaymentTransaction | paymentMethodRef_dep2011M | |
SIS-154372 | PaymentTransaction | customerID | Alphanumeric id that identifies the customer you are searching for under the given client. |
SIS-154372 | PaymentTransaction | autoVoided | This flag is set to true when a transaction is auto voided by a campus quartz job. |
SIS-154372 | PaymentTransaction | returnReason | Written out reason for the return. null if transaction was not returned. |
SIS-154372 | PaymentUserAccount | customerID | Alphanumeric id that identifies the customer you are searching for under the given client. |
SIS-154372 | PaymentUserAccount | customerRef | Payment vendor's identifier of the individual payer |
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-138322 | CA | Removed blue card report process |
SIS-138322 | CA | Immunization Rule Update |
SIS-144014 | Converted Enrollment attributes | |
SIS-146779 | Data migration for UserAccount | |
SIS-146779 | Data migration for SAMLSPConfig | |
SIS-151085 | MN | Added 3 districts to district list |
SIS-152231 | KY | State Defined Service Position |
SIS-152461 | Updated Report Service Notification Link | |
SIS-152921 | Renamed Tasks | |
SIS-153206 | CO | Data conversion for new remote learning codes in EnrollmentCO |
SIS-153392 | GA | Immunization Rule Update name mcv4 |
SIS-153392 | GA | Immunization Rule Update |
SIS-153472 | Added Fee Calculation Job and Trigger | |
SIS-153723 | FRAM Income Guide 2022-2023 | |
SIS-153767 | WY | Home Primary Language Update |
SIS-153808 | NY | Conversion of string null field to NULL field in TranscriptCourse and Roster |
SIS-153950 | VA | Added district 101 |
SIS-154524 | Updated SchoolAttribute schoolTypeBIE |
