UWSDBDataStore Reorg on October 23, 2021

October 12, 2021

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

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

Old Columns to be deleted

Table Name Column Name
sdbdb01 g_sa_flag4
sa_sf_awards award_event_dt1
award_event_dt2
award_event_dt3
award_event_dt4
award_event_dt5
award_event_dt6
award_status_cd1
award_status_cd2
award_status_cd3
award_status_cd4
award_status_cd5
award_status_cd6

 

New columns to be added

Table Column DataType
sdbdb01 g_workday_fin bit
addresses text_message_ok bit
sa_sf_award_awards tara_last_elig_dt datetime
sr_adm_appl interest_in_other bit
sr_adm_appl_guardian_data guardian_email char(50)
student_2 rn_ferpa_year smallint
rn_ferpa_qtr tinyint
sys_tbl_33_home_addr_by_code home_addr_st_ter char(24)
sys_tbl_39_calendar tacoma_ymca_chrg decimal(10,0)
sys_tbl_72_appl_status appl_stat_long_ds char(120)

 

New Tables to be Added

Table Column Name Datatype
sa_aid_disb_trans system_key int
sa_aid_fund_info smallint
sa_aid_tran_dt datetime
sa_aid_year tinyint
sa_aid_qtr tinyint
sa_aid_disb_amt decimal(9,2)
sa_tara_funding system_key int
sa_tara_fund_no smallint
sa_tara_seq_no smallint
sa_tara_date datetime
sa_tara_aid_yr smallint
sa_tara_qtr tinyint
sa_tara_status bit
sa_tara_ex_amt decimal(9,2)
sa_tara_src_tag1 char(10)
sa_tara_src_tag2 char(10)
sa_tara_src_tag3 char(10)
sa_tara_spare_1 char(10)
sa_tara_spare_2 char(10)
sa_tara_spare_3 int
sa_tara_spare_4 int
sr_raw_transfer system_key int
sr_raw_inst_cd smallint
sr_raw_year char(6)
sr_raw_term char(1)
sr_raw_curric char(6)
sr_raw_crs_no char(4)
sr_raw_dup_crs tinyint
sr_raw_crs_ttl char(24)
sr_raw_credits decimal(3, 1)
sr_raw_grade char(2)
sr_raw_qual char(2)
sr_raw_ta_group smallint
sr_raw_eval char(1)
sr_raw_pend_group smallint
sr_raw_pend_eval char(1)
sr_raw_ta_dt datetime
sr_raw_updt_dt datetime
sr_raw_updt_id char(12)
sr_raw_spare_1 char(10)
sr_raw_spare_2 char(10)
sr_raw_spare_3 int
sr_raw_spare_4 int