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