UWSDBDataStore Reorg on July 20, 2024 (DRAFT)
February 29, 2024
UWSDBDataStore Reorg on July 20, 2024 (DRAFT)
The student database (SDB) will go through a reorganization on July 20, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on July 22, 2024.
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 – 3.8.24
Columns to be Added
Table | Column | DataType |
STUDENT_1 | DISAB_ARCHIVE_FLG | bit |
Columns to be Removed
Table | Column | Notes |
STUDENT_1 | S1_BOOLEAN_07 | Not in use, being replaced by Disab_Archive_Flg |
Datatype Changes
Table | Column | DataType(new) | Data Type (old) |
SF_Evaluation | PJ_STD_EXMPTS | tinyint | decimal (11,0) |
PJ_SP_EXMPTS | tinyint | decimal (11,0) | |
PJ_P1_EXMPTS | tinyint | decimal (11,0) | |
PJ_P2_EXMPTS | tinyint | decimal (11,0) |