UWSDBDataStore Reorg on January 30, 2021

December 18, 2020

The student database (SDB) will go through a reorganization on January 30, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 1, 2021.
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 modified: 03.03.2021)

*Please continuously monitor this site for the most current update.

Old Columns to be deleted

Table Name Column Name
registration_courses crs_fee_budget
crs_rev_obj_cd
crs_cost_acct_cd
sa_tuition_table no_per_std_surch
sdb_security sdb_home_dept
sdb_org_code
sr_course_instr fac_budget_no
fac_course_bgt
fac_wkld_pct
fac_contact_hr
fac_is_contact_hr
sr_instructor instr_home_dept
instr_hepps_fte
instr_tot_fte
instr_job_class
instr_teach_fte
instr_f_s_hrs
instr_other_i_hrs
instr_i_rel_hrs
instr_admin_hrs
instr_st_res_hrs
instr_st_svc_hrs
instr_sp_res_hrs
instr_extra1_hrs
instr_extra2_hrs
instr_extra3_hrs
instr_extra4_hrs
instr_st_res_fte
instr_st_svc_fte
instr_sp_res_fte
instr_extra1_fte
instr_extra2_fte
instr_extra3_fte
instr_extra4_fte
instr_direct_fte
instr_i_rel_fte
instr_admin_fte
instr_n_s_hrs
instr_n_s_fte
instr_st_res_bgt
instr_st_svc_bgt
instr_sp_res_bgt
instr_extra1_bgt
instr_extra2_bgt
instr_extra3_bgt
instr_extra4_bgt
instr_teaching
instr_field_2
instr_field_3
instr_field_4
instr_field_5
instr_field_6
instr_field_7
instr_field_8

New columns to be added

Table Column DataType
dl_origination dl_rltn_to_std char(1)
dl_supl_plus sp_rltn_to_std char(1)
sa_sf_fund fund_wd_tag char(12)
fund_wd_spend_cat char(6)
sa_transaction op_dat_crhr1_tag char(12)
op_dat_crhr1_rcat char(6)
sa_tuition_per_cr_hr_charges perc_wd_tag char(12)
perc_wd_rev_cat char(6)
sf_evaluation ibc_completed_sw char(1)
ibc_completed_dt int
ibc_completed_id char(12)
sr_course_titles fee_wd_tag char(12)
fee_wd_rev_cat char(6)
sys_tbl_39_calendar frosh_reg_dt_c2 datetime
soph_reg_dt_c2 datetime
junior_reg_dt_c2 datetime
senior_reg_dt_c2 datetime
fifth_yr_reg_dt_c2 datetime
sys_tbl_62_tuit_distrib_subtot dtbl_wd_tag char(12)
dtbl_wd_rev_cat char(6)
sys_tbl_63_nontuit_charges on_chrg_db_tag char(12)
on_chrg_db_name char(12)
on_chrg_db_rcat char(6)
on_chrg_cr_tag char(12)
on_chrg_cr_name char(12)
on_chrg_cr_rcat char(6)
on_pay_db_tag char(12)
on_pay_db_name char(12)
on_pay_db_rcat char(6)
on_pay_cr_tag char(12)
on_pay_cr_name char(12)
on_pay_cr_rcat char(6)
on_pay_cr_fund int
time_schedule fee_wd_tag char(12)
fee_wd_rev_cat char(6)

New Table to be Added

Table Column Name Datatype
sa_wd_det_trans wd_det_trans_date datetime
wd_det_system_key int
wd_det_seq smallint
wd_det_proc_date datetime
indexd1 datetime
wd_det_proc_pd smallint
wd_det_trans_type char(4)
wd_det_ref_cd char(6)
wd_det_trans_info char(20)
wd_det_company char(10)
wd_det_ledger int
wd_det_tag char(12)
wd_det_spend_cat char(6)
wd_det_rev_cat char(6)
wd_det_db_amount decimal(9,2)
wd_det_cr_amount decimal(9,2)
wd_det_spare_1 char(10)
wd_det_spare_2 char(10)
wd_det_spare_3 int
wd_det_spare_4 int
sa_wd_sum_trans wd_sum_trans_date datetime
wd_sum_seq int
wd_sum_proc_date datetime
wd_sum_proc_pd smallint
indexd1 datetime
wd_sum_trans_type char(4)
wd_sum_ref_cd char(6)
wd_sum_trans_info char(20)
wd_sum_company char(10)
wd_sum_ledger int
wd_sum_tag char(12)
wd_sum_spend_cat char(6)
wd_sum_rev_cat char(6)
wd_sum_db_amount decimal(9,2)
wd_det_cr_amount decimal(9,2)
wd_det_spare_1 char(10)
wd_sum_spare_2 char(10)
wd_sum_spare_3 int
wd_sum_spare_4 int
time_schedule_enrl_excl_clas ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_excl_class tinyint
time_schedule_enrl_excl_coll ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_excl_college char(1)
time_schedule_enrl_excl_maj ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_excl_maj_ab char(6)
time_schedule_enrl_excl_sp_p ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_excl_sp_pgm tinyint
time_schedule_enrl_excl_stu ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_excl_stu_grp char(5)
time_schedule_enrl_prioritie ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
enrl_req_honors char(1)
enrl_req_eop char(1)
enrl_req_evening bit
enrl_excl_honors char(1)
enrl_excl_eop char(1)
enrl_excl_evening bit
coreq_course_no smallint
coreq_branch char(1)
coreq_curric_abbr char(6)
coreq_sect_id char(3)
time_schedule_enrl_req_class ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_req_class tinyint
time_schedule_enrl_req_colle ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_req_college char(1)
time_schedule_enrl_req_crs_n ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_req_crs_no smallint
time_schedule_enrl_req_dept ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_req_dept char(6)
time_schedule_enrl_req_maj_a ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_req_maj_ab char(6)
time_schedule_enrl_req_sp_pg ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_req_sp_pgm tinyint
time_schedule_enrl_req_stu_g ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
enrl_req_stu_grp char(5)
time_sched_req_building ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
req_building char(4)
time_sched_req_rm_features ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
req_rm_features smallint
time_sched_req_rm_partition ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
req_rm_partition smallint
time_sched_req_room ts_year smallint
ts_quarter tinyint
course_branch tinyint
course_no smallint
dept_abbrev char(6)
section_id char(3)
index1 smallint
index2 smallint
req_room char(8)

Send all questions and concerns to help@uw.edu, with the subject line: “UWSDBDataStore Reorg 01.30.2021“.