UWSDBDataStore Reorg on February 1, 2025

January 6, 2025

UWSDBDataStore Reorg on February 1, 2025 – DRAFT

The student database (SDB) will go through a reorganization on February 1, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 3, 2025
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.6.2025

Columns to be Added

Table Column DataType
SF_EVALUATION1 PROF_JUDGE_DATE datetime
STUDENT_1 TOT_NONGRD_ATTMP decimal(4,1)
TRANSCRIPT QTR_NONGRD_ATTMP decimal(3,1)

Columns to be Removed

Table Column
SF_EVALUATION COFH_INDICATOR

 

Field moving from SF_Evaluation1 to SF_Evaluation:
INST_SAI_BLK