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“.