UWSDBDataStore Reorgs on January 28, 2023
January 23, 2023
UWSDBDataStore Reorgs on January 28, 2023
The student database (SDB) will go through a reorganization on January 28, 2023 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 30, 2023.
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 – 01.23.2023
Column Adds to Existing Tables:
| Table | Column | DataType |
| STUDENT_2 | IMM_CON_ID | CHAR(12) |
| STUDENT_2_UW_DEGREE_INFO | DEG_GRANT_DATE | DATETIME |
| SF_EVALUATION | INCARC_APP_FLG | CHAR(1) |
Columns to be Removed:
| Table | Column |
| STUDENT_2 | IMM_ID (not in use yet) |