UWSDBDataStore Reorg on October 19, 2019
September 26, 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.