IT Connect
Information technology tools and resources at the UW

UWSDBDataStore Reorg on October 19, 2019

Hello,

The student database (SDB) will go through a reorganization on Oct. 19, 2019 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on Monday, Oct. 21, 2019 . (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.) *

New columns to be added: 
(last updated: 10.14.2019)

Table Name Column Name Data Type Description
 budget_resources br_pkg_formula_no tinyint The packaging formula being used for the student for the specified quarter
 sa_sf_fund osfa_group_code char(1) Code for grouping Awards (“G”rants “W”ork Study “L”oans “P”lus Loans blank=not assigned)
 sdb_security sdb_sf_power_user char(1) Specifies someone in OSFA who can edit restricted fields on finaid screens.
 sf_evaluation s_filed_sched1 char(1) Student filed a Schedule 1? (2, yes 1, no 3, don’t know, or blank)
s_untax_ira_pensn int Student’s Untaxed Portions of IRA Distributions and Pensions
p_filed_sched1 char(1) Parents filed a Schedule 1? (2, yes 1, no 3, don’t know, or blank)
p_untax_ira_pensn int Parents Untaxed Portions of IRA Distributions and Pensions
child_fallen_hero char(1) Children of Fallen Heroes Indicator (1=yes, 2=no, blank=no determination made)
 sr_adm_appl cnet_account_id integer CollegeNet account ID.
slate_appl_id integer Slate application ID
pg_schol_amt integer Purple and Gold Scholarship amount
 student_1 cnet_account_id integer CollegeNet account ID.
slate_appl_id integer Slate application ID
 student_2 s2_iso_stat_id char(12) ID of S2-ISO-STATUS updater.

 

*Please Note: The scope of the reorg may still change. Please check this site constantly to see changes to the scope.