UWSDBDataStore Reorg on February 1, 2020
January 7, 2020
Hello,
The student database (SDB) will go through a reorganization on February 1, 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, February 3, 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: 2.1.2020)
New columns to be added:
| Table Name | Column Name | Data Type | Description |
| budget_resources | br_bgt_code_calc | char(2) | Budget code calculated by budget calc library, P404 |
| dl_origination | dl_ibc_comp_flg | char(1) | Informed Borrower Completion (Y/N). |
| dl_ibc_comp_dt | datetime | Informed Borrower Completion Date. | |
| dl_ibc_comp_id | char(12) | Informed Borrower Completion ID. | |
| sa_sf_awards_awards | sum_request_amt | decimal(7,2) | Summer loan Amount requested by student. |
| aut_request_amt | decimal(7,2) | Autumn loan Amount requested by student. | |
| win_request_amt | decimal(7,2) | Winter loan Amount requested by student. | |
| spr_request_amt | decimal(7,2) | Spring loan Amount requested by student . | |
| awrd_request_dt | datetime | Request Date (CCYYMMDD). | |
| awrd_request_id | char(12) | Request ID | |
| sf_evaluation | s_drt_rev_dt | datetime | Date the Student DRT is reviewed. |
| p_drt_rev_dt | datetime | Date the Parent DRT is reviewed. | |
| sf_eval_outside_aid_area | oa_award_code | int | Over Award Budget or Fund Number. |
| sf_history | vebo_grnt_elg_ovr | char(1) | Veterans grant eligibility override |
Data type change:
| Table Name | Column Name | Old Data Type | New Data Type |
| sr_room_master_attribute | sr_room_char_cnt | smallint | int |