UWSDBDataStore Reorg on October 22, 2022

September 30, 2022

UWSDBDataStore Reorg on October 22, 2022 

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

Columns to be Added

Table Column DataType
sa_wd_det_trans wd_det_interco char(10)
wd_det_aid_type char(1)
sa_wd_sum_tran wd_sum_interco char(10)
sf_tuition t_pt_13cred integer
t_pt_spare1 integer
t_pt_spare2 integer
t_pt_spare3 integer
t_pt_spare4 char(3)
student_2 imm_consent char(1)
imm_con_dt datetime
imm_id char(12)
rn_ins_conf char(1)
rn_ins_conf_dt datetime

Column Renames

Please Note: The following column renames will be occurring in the SDB screens as of 10.22.22. The renames will be perpetuated to UWSDBDataStore in December 2022. There will be a mismatch in column names between UWSDBDataStore and SDB in the interim, but the data will be the same.

Table Existing Column Name New Column Name
time_schedule natural_world natural_science
qsr rsn
indiv_society social_science
vis_lit_perf_arts arts_hum
sr_transfer_crs tfr_nw tfr_nsc
tfr_vlpa tfr_ah
tfr_is tfr_ssc
tfr_qsr tfr_rsn
sr_course_titles natural_world natural_science
qsr rsn
indiv_society social_science
vis_lit_perf_arts arts_hum