January 8, 2026
UWSDBDataStore Reorg on January 31, 2026
UWSDBDataStore Reorg on January 31, 2026
The student database (SDB) will go through a reorganization on January 31, 2026 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 2, 2026
However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data.
Last Updated – 1.8.26
Columns to be Added
| Table | Column | DataType |
| SF_EVALUATION** | STD_ISIR_EMAIL | char(50) |
| STUDENT_1 | EO_MODCAMP_ID | char(8) |
| EO_MODCAMP_DT | datetime | |
| STUDENT_2 | CERTIF_YR | smallint |
| CERTIF_QTR | tinyint | |
| CERTIF_BRANCH | tinyint | |
| CERTIF_MAJOR_ABBR | char(6) | |
| CERTIF_PATHWAY | tinyint | |
| CERTIF_LEVEL | tinyint | |
| CERTIF_TYPE | tinyint |
Columns to be Removed
| Table | Column |
| SR_DEC_RESULTS | SR_DEC_NAME |
| SR_DEC_DOB | |
| SR_DEC_SSN | |
| SR_DEC_SPARE_1 | |
| SR_DEC_SPARE_2 | |
| SR_DEC_SPARE_3 | |
| SR_DEC_SPARE_4 | |
| SR_DEC_SPARE_5 | |
| SR_DEC_SPARE_6 | |
| SR_DEC_BOOLEAN_1 | |
| SR_DEC_BOOLEAN_2 | |
| SR_DEC_BOOLEAN_3 | |
| SR_DEC_BOOLEAN_4 | |
| SR_DEC_BOOLEAN_5 | |
| SR_DEC_BOOLEAN_6 | |
| SR_DEC_BOOLEAN_7 | |
| SR_DEC_BOOLEAN_8 |
**Moving from SF_Evaluation to SF_Evaluation1 due to the column addition:
HEAL_LOAN_FLG