UWSDBDataStore Reorgs on October 22, 2022 and December 21, 2022
UWSDBDataStore Reorgs on October 22, 2022 & December 21, 2022
The student database (SDB) will go through a reorganization on October 22, 2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 24, 2022.
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.
Please Note: The following column renames will be occurring in the SDB screens as of 10.22.22. The renames will be perpetuated to UWSDBDataStore and EDWPresentation December 21st 2022. There will be a mismatch in column names between UWSDBDataStore and SDB in the interim, but the data will be the same.
Last Updated – 12.20.2022
Column Renames – 12.21.22
Renames detailed below will occur end of day 12.21.2022. The data will be available Thursday 12.22.22, this data is typically available by 4am.
UWSDBDataStore Renames –
| Table | Existing Column Name | New Column Name |
| time_schedule | natural_world | natural_science |
| qsr | rsn | |
| indiv_society | social_science | |
| vis_lit_perf_arts | arts_hum | |
| sr_transfer_crs | tfr_nw | tfr_nsc |
| tfr_vlpa | tfr_ah | |
| tfr_is | tfr_ssc | |
| tfr_qsr | tfr_rsn | |
| sr_course_titles | natural_world | natural_science |
| qsr | rsn | |
| indiv_society | social_science | |
| vis_lit_perf_arts | arts_hum |
EDWPresentation Renames:
| Table | Existing Column Name | New Column Name |
| dimSectionAttributes | RqmtIndivSocInd | RqmtSocialScienceInd |
| RqmtIndivSocIndDesc | RqmtSocialScienceIndDesc | |
| RqmtNaturalWorldInd | RqmtNaturalScienceInd | |
| RqmtNaturalWorldIndDesc | RqmtNaturalScienceIndDesc | |
| RqmtQuantSymInd | RqmtReasoningInd | |
| RqmtQuantSymIndDesc | RqmtReasoningIndDesc | |
| RqmtVisLitPerfArtInd | RqmtArtHumanitiesInd | |
| RqmtVisLitPerfArtIndDesc | RqmtArtHumanitiesIndDesc | |
| dmSCH_dimCourseContentIndicators | RqmtIndivSocInd | RqmtSocialScienceInd |
| RqmtIndivSocIndDesc | RqmtSocialScienceIndDesc | |
| RqmtNaturalWorldInd | RqmtNaturalScienceInd | |
| RqmtNaturalWorldIndDesc | RqmtNaturalScienceIndDesc | |
| RqmtQuantSymInd | RqmtReasoningInd | |
| RqmtQuantSymIndDesc | RqmtReasoningIndDesc | |
| RqmtVisLitPerfArtInd | RqmtArtHumanitiesInd | |
| RqmtVisLitPerfArtIndDesc | RqmtArtHumanitiesIndDesc | |
| dmSCHLink_dimCourseContentIndicators | RqmtIndivSocInd | RqmtSocialScienceInd |
| RqmtNaturalWorldInd | RqmtNaturalScienceInd | |
| RqmtQuantSymInd | RqmtReasoningInd | |
| RqmtVisLitPerfArtInd | RqmtArtHumanitiesInd |
Columns to be Added – Completed 10.22.2022
| Table | Column | DataType |
| sa_wd_det_trans | wd_det_interco | char(10) |
| wd_det_aid_type | char(1) | |
| sa_wd_sum_tran | wd_sum_interco | char(10) |
| sf_tuition | t_pt_13cred | integer |
| t_pt_spare1 | integer | |
| t_pt_spare2 | integer | |
| t_pt_spare3 | integer | |
| t_pt_spare4 | char(3) | |
| student_2 | imm_consent | char(1) |
| imm_con_dt | datetime | |
| imm_id | char(12) | |
| rn_ins_conf | char(1) | |
| rn_ins_conf_dt | datetime |