October 6, 2025

UWSDBDataStore Reorg on October 18, 2025

UWSDBDataStore Reorg on October 18, 2025

The student database (SDB) will go through a reorganization on October 18, 2025 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 20, 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 – 10.19.2025

Columns to be Added

Table	Column	DataType
SA_WD_DET_TRANS	WD_DET_BATCH_NO	smallint
SA_WD_SUM_TRAN	WD_SUM_SYSTEM_KEY	int
SA_WD_SUM_TRAN	WD_SUM_BATCH_NO	smallint

New Tables

Table	Column	DataType
SR_DEC_RESULTS	SR_DEC_NAME	char(45)
	SR_DEC_DOB	datetime
	SR_DEC_SYSKEY	int
	SR_DEC_SSN	int
	SR_DEC_SLATE_ID	int
	SR_DEC_CAMPUS	tinyint
	SR_DEC_APPL_TYPE	char(1)
	SR_DEC_APPL_STATUS	char(1)
	SR_DEC_MESSAGE	char(50)
	SR_DEC_POSTED_DT	datetime
	SR_DEC_SPARE_1	int
	SR_DEC_SPARE_2	int
	SR_DEC_SPARE_3	int
	SR_DEC_SPARE_4	char(10)
	SR_DEC_SPARE_5	char(10)
	SR_DEC_SPARE_6	char(10)
	SR_DEC_BOOLEAN_1	bit
	SR_DEC_BOOLEAN_2	bit
	SR_DEC_BOOLEAN_3	bit
	SR_DEC_BOOLEAN_4	bit
	SR_DEC_BOOLEAN_5	bit
	SR_DEC_BOOLEAN_6	bit
	SR_DEC_BOOLEAN_7	bit
	SR_DEC_BOOLEAN_8	bit

Table	Column	DataType
SR_MINI_MASTER_MINOR_PROGRAM	MM_YEAR	smallint
	MM_QTR	tinyint
	MM_PROC_IND	tinyint
	MM_STUDENT_NO	int
	INDEX_1	smallint
	MM_MINOR_BRANCH	tinyint
	MM_MINOR_COLLEGE	char(1)
	MM_MINOR_ABBR	char(6)
	MM_MINOR_PATHWAY	tinyint
	MM_MINOR_CAT_YR	smallint
	MM_MINOR_CAT_QTR	tinyint
	MM_MINOR_DT	datetime
	MM_MINOR_USER_ID	char(12)
	MM_MINOR_EVENING	bit

Columns to be Removed

Table	Column Name
SDBDB01	LAST_RUN_NUM

Columns to be Renamed

Table	Column Name	New Column Name
STUDENT_1	S1_BOOLEAN_08	NO_MAC_NAME_CAPS
STUDENT_1	S1_BOOLEAN_09	PEND_RESIDENCY_ST

Table to be Renamed

Table Name	New Table Name
SR_ADV_SYS_SET	SR_ADVISER_NOTES