UWSDBDataStore Reorg on October 24, 2020

October 9, 2020

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

*Please Note:The scope listed below isn’t final until 1 week before the reorg. Please continuously monitor this site for the most current update.

New columns to be added

Table Name Column Name Data Type Description
sf_evaluation sf_aut_enrl_lock char(1)  Autumn Enrollment Lock
sf_spr_enrl_lock char(1)  Spring Enrollment Lock
sf_sum_enrl_lock char(1)  Summer Enrollment Lock
sf_win_enrl_lock char(1)  Winter Enrollment Lock
s_sched1_data_fld  char(1)  Information about the data in the ‘student filed schedule’ 1 field
p_sched1_data_fld char(1) Information about the data in the ‘parent filed schedule’ 1 field
sf_tuition t_pt_10cred int Part-time tuition for 10 credits (prof)
t_pt_11cred int Part-time tuition for 11 credits (prof)
t_pt_12cred int Part-time tuition for 12 credits (prof)
student_2 finaid_docs_guid char(36) Unique 36-character GUID for every student in the Fin-Aid Documents CRM system.
time_schedule remote_learn_cd char(2) Track sections units offered in-person(IP), via remote learning(RL) and either(E) way.

Data Type changes

Table Name Column Name Old Data Type New Data Type
sr_adm_appl appl_source_id int decimal(10,0)
appl_copy_src_id int decimal(10,0)

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