UWSDBDataStore Reorg on January 27, 2024
January 17, 2024
UWSDBDataStore Reorg on January 27, 2024
The student database (SDB) will go through a reorganization on January 27, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 29, 2024.
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 Updated – 1.23.24
**below additions to SF_Evaluation will result in additional records being shifted to SF_Evaluation1, will add details as soon as available.
Columns to be Added
| Table | Column | DataType |
| ISIR_TRANSACTIONS | ISIR_CPS_SAI | int |
| ISIR_CPS_PROV_SAI | int | |
| I_SP_SIGNATURE_CD | char(1) | |
| I_P1_SIGNATURE_CD | char(1) | |
| I_P2_SIGNATURE_CD | char(1) | |
| I_SP_SSN_MATCH_FL | char(1) | |
| I_P1_SSN_MATCH_FL | char(1) | |
| I_P2_SSN_MATCH_FL | char(1) | |
| PELL_DISBURSEMENT | PD_PAY_END_DT | datetime |
| PD_QTR_FLG | char(1) | |
| SA_WD_DET_TRANS | WD_DET_BANK_CD | char(1) |
| SA_WD_SUM_TRAN | WD_SUM_BANK_CD | char(1) |
| STUDENT_1 | DISAB_MORE_IND | bit |
| SYS_TBL_63_NONTUIT_CHARGES | AID_REPAY_CHARGE | bit |
| SPARE_BOOLEAN_2 | bit | |
| SDBDB01 | G_SA_FLAG4 | bit |
| SF_EVALUATION1 | PJ_STD_DEPS | tinyint |
| PJ_SP_DEPS | tinyint | |
| PJ_P1_DEPS | tinyint | |
| PJ_P2_DEPS | tinyint | |
| SP_TAX_RETURN_DT | datetime | |
| P2_TAX_RETURN_DT | datetime | |
| SF_EVALUATION | IP_S_IPA | decimal(15,0) |
| IP_S_APA | decimal(15,0) | |
| S_SP_SSN_MATCH_IND | char(1) | |
| P1_SSN_MATCH_IND | char(1) | |
| P2_SSN_MATCH_IND | char(1) | |
| S_DRUG_HOLD_IND | char(1) | |
| SSA_CITIZENSHIP_SP | char(1) | |
| SSA_CITIZENSHIP_P1 | char(1) | |
| SSA_CITIZENSHIP_P2 | char(1) | |
| STD_TU_MATCH_FLG | char(1) | |
| SP_TU_MATCH_FLG | char(1) | |
| P1_TU_MATCH_FLG | char(1) | |
| P2_TU_MATCH_FLG | char(1) | |
| MET_POVERTY_GUIDE | char(1) | |
| SPO_PENSIONS_MAN | decimal(11,0) | |
| P1_PENSIONS_MAN | decimal(11,0) | |
| SAI_BLK | bit | |
| PROV_SAI_BLK | bit | |
| S_NO_FAM_MEMB_BLK | bit | |
| S_NO_IN_COLLE_BLK | bit | |
| STD_WK_INCOME_BLK | bit | |
| STD_INTEREST_BLK | bit | |
| STD_IRA_DIST_BLK | bit | |
| STD_IRA_ROLL_BLK | bit | |
| STD_PENSIONS_BLK | bit | |
| STD_PENS_ROLL_BLK | bit | |
| STD_AGI_BLK | bit | |
| STD_TAX_PAID_BLK | bit | |
| STD_DEDCT_PMT_BLK | bit | |
| S_EDUC_CREDIT_BLK | bit | |
| STD_SCHED_C_BLK | bit | |
| STD_GRNT_SCHL_BLK | bit | |
| STD_FRGN_EXCL_BLK | bit | |
| STD_CHLD_SUPP_BLK | bit | |
| STD_CASH_BLK | bit | |
| STD_BUS_FARM_BLK | bit | |
| STD_INVEST_BLK | bit | |
| SPO_WK_INCOME_BLK | bit | |
| SPO_INTEREST_BLK | bit | |
| SPO_IRA_DIST_BLK | bit | |
| SPO_IRA_ROLL_BLK | bit | |
| SPO_PENSIONS_BLK | bit | |
| SPO_PENS_ROLL_BLK | bit | |
| SPO_AGI_BLK | bit | |
| SPO_TAX_PAID_BLK | bit | |
| SPO_DEDCT_PMT_BLK | bit | |
| SPO_EDUC_CRED_BLK | bit | |
| SPO_SCHED_C_BLK | bit | |
| SPO_FRGN_EXCL_BLK | bit | |
| P1_WK_INCOME_BLK | bit | |
| P1_INTEREST_BLK | bit | |
| P1_IRA_DIST_BLK | bit | |
| P1_IRA_ROLL_BLK | bit | |
| P1_PENSIONS_BLK | bit | |
| P1_PENS_ROLL_BLK | bit | |
| P1_AGI_BLK | bit | |
| P1_TAX_PAID_BLK | bit | |
| P1_DEDCT_PMT_BLK | bit | |
| P1_EDUC_CRED_BLK | bit | |
| P1_SCHED_C_BLK | bit | |
| P1_GRNT_SCHL_BLK | bit | |
| P1_FRGN_EXCL_BLK | bit | |
| P1_CHLD_SUPP_BLK | bit | |
| P1_BUS_FARM_BLK | bit | |
| P1_INVEST_BLK | bit | |
| P1_CASH_BLK | bit | |
| P2_WK_INCOME_BLK | bit | |
| P2_INTEREST_BLK | bit | |
| P2_IRA_DIST_BLK | bit | |
| P2_IRA_ROLL_BLK | bit | |
| P2_PENSIONS_BLK | bit | |
| P2_PENS_ROLL_BLK | bit | |
| P2_AGI_BLK | bit | |
| P2_TAX_PAID_BLK | bit | |
| P2_DEDCT_PMT_BLK | bit | |
| P2_EDUC_CRED_BLK | bit | |
| P2_SCHED_C_BLK | bit | |
| P2_FRGN_EXCL_BLK | bit | |
| IP_STD_FWS_BLK | bit | |
| IP_SP_FWS_BLK | bit | |
| IP_P1_FWS_BLK | bit | |
| IP_P2_FWS_BLK | bit | |
| IP_ATI_BLK | bit | |
| IP_P_PTA_BLK | bit | |
| IP_IPA_BLK | bit | |
| IP_P_PEEA_BLK | bit | |
| IP_AI_BLK | bit | |
| IP_AAI_BLK | bit | |
| IP_PC_BLK | bit | |
| IP_STD_PTA_BLK | bit | |
| IP_S_IPA_BLK | bit | |
| IP_STD_PNAAI_BLK | bit | |
| IP_STD_SEEA_BLK | bit | |
| IP_SATI_BLK | bit | |
| IP_STAI_BLK | bit | |
| IP_SCI_BLK | bit | |
| IP_SAAI_BLK | bit | |
| IP_SC_SAAI_BLK | bit | |
| IP_DNW_BLK | bit | |
| IP_NW_BLK | bit | |
| IP_APA_BLK | bit | |
| IP_PCA_BLK | bit | |
| IP_SDNW_BLK | bit | |
| IP_S_APA_BLK | bit | |
| IP_SCA_BLK | bit | |
| CUI_STD_AGI_BLK | bit | |
| CUI_STD_EXEMP_BLK | bit | |
| CUI_STD_DEPS_BLK | bit | |
| CUI_STD_INC_BLK | bit | |
| CUI_STD_TAX_BLK | bit | |
| CUI_STD_EDUC_BLK | bit | |
| CUI_STD_IRA_D_BLK | bit | |
| CUI_STD_IRA_P_BLK | bit | |
| CUI_STD_INTER_BLK | bit | |
| CUI_STD_PENSN_BLK | bit | |
| CUI_STD_SCHDC_BLK | bit | |
| CUI_SPO_AGI_BLK | bit | |
| CUI_SPO_EXEMP_BLK | bit | |
| CUI_SPO_DEPS_BLK | bit | |
| CUI_SPO_INC_BLK | bit | |
| CUI_SPO_TAX_P_BLK | bit | |
| CUI_SPO_EDUC_BLK | bit | |
| CUI_SPO_IRA_D_BLK | bit | |
| CUI_SPO_IRA_P_BLK | bit | |
| CUI_SPO_INTER_BLK | bit | |
| CUI_SPO_PENSN_BLK | bit | |
| CUI_SPO_SCHDC_BLK | bit | |
| CUI_P1_AGI_BLK | bit | |
| CUI_P1_EXEMPT_BLK | bit | |
| CUI_P1_DEPS_BLK | bit | |
| CUI_P1_INC_BLK | bit | |
| CUI_P1_TAX_BLK | bit | |
| CUI_P1_EDUC_BLK | bit | |
| CUI_P1_IRA_D_BLK | bit | |
| CUI_P1_IRA_P_BLK | bit | |
| CUI_P1_INTER_BLK | bit | |
| CUI_P1_PENSN_BLK | bit | |
| CUI_P1_SCHDC_BLK | bit | |
| CUI_P2_AGI_BLK | bit | |
| CUI_P2_EXEMPT_BLK | bit | |
| CUI_P2_DEPS_BLK | bit | |
| CUI_P2_INC_BLK | bit | |
| CUI_P2_TAX_BLK | bit | |
| CUI_P2_EDUC_BLK | bit | |
| CUI_P2_IRA_D_BLK | bit | |
| CUI_P2_IRA_P_BLK | bit | |
| CUI_P2_INTER_BLK | bit | |
| CUI_P2_PENSN_BLK | bit | |
| CUI_P2_SCHDC_BLK | bit | |
| IP_STI_BLK | bit | |
| IP_TI_BLK | bit | |
| IP_FTI_BLK | bit | |
| PJ_STD_WORK_BLK | bit | |
| PJ_STD_TAXES_BLK | bit | |
| PJ_STD_AGI_BLK | bit | |
| PJ_STD_UNTAXI_BLK | bit | |
| PJ_STD_IRA_P_BLK | bit | |
| PJ_STD_EDUC_BLK | bit | |
| PJ_STD_INTER_BLK | bit | |
| PJ_STD_EXMPT_BLK | bit | |
| PJ_STD_DEPS_BLK | bit | |
| PJ_STD_SCHDC_BLK | bit | |
| PJ_STD_UNTAXP_BLK | bit | |
| PJ_SP_WORK_BLK | bit | |
| PJ_SP_TAXES_BLK | bit | |
| PJ_SP_AGI_BLK | bit | |
| PJ_SP_UNTAXI_BLK | bit | |
| PJ_SP_IRA_P_BLK | bit | |
| PJ_SP_EDUC_BLK | bit | |
| PJ_SP_INTER_BLK | bit | |
| PJ_SP_EXMPT_BLK | bit | |
| PJ_SP_DEPS_BLK | bit | |
| PJ_SP_SCHDC_BLK | bit | |
| PJ_SP_UNTAXP_BLK | bit | |
| PJ_P1_WORK_BLK | bit | |
| PJ_P1_TAXES_BLK | bit | |
| PJ_P1_AGI_BLK | bit | |
| PJ_P1_UNTAXI_BLK | bit | |
| PJ_P1_IRA_PMT_BLK | bit | |
| PJ_P1_EDUC_BLK | bit | |
| PJ_P1_INTER_BLK | bit | |
| PJ_P1_EXMPT_BLK | bit | |
| PJ_P1_DEPS_BLK | bit | |
| PJ_P1_SCHDC_BLK | bit | |
| PJ_P1_UNTAXP_BLK | bit | |
| PJ_P2_WORK_BLK | bit | |
| PJ_P2_TAXES_BLK | bit | |
| PJ_P2_AGI_BLK | bit | |
| PJ_P2_UNTAXI_BLK | bit | |
| PJ_P2_IRA_PMT_BLK | bit | |
| PJ_P2_EDUC_BLK | bit | |
| PJ_P2_INTER_BLK | bit | |
| PJ_P2_EXMPT_BLK | bit | |
| PJ_P2_DEPS_BLK | bit | |
| PJ_P2_SCHDC_BLK | bit | |
| PJ_P2_UNTAXP_BLK | bit | |
| SPARE_BOOLEAN1 | bit | |
| SPARE_BOOLEAN2 | bit | |
| SPARE_BOOLEAN3 | bit | |
| SPARE_BOOLEAN4 | bit |
Columns with datatype changes
| Table | Column | DataType (existing) | DataType (New) |
| SF_EVALUATION1 (currently in SF_EVALUATION) |
SNG_SUM_ENROLL_ST | char(1) | char(2) |
| SNG_AUT_ENROLL_ST | char(1) | char(2) | |
| SNG_WIN_ENROLL_ST | char(1) | char(2) | |
| SNG_SPR_ENROLL_ST | char(1) | char(2) |
Columns to be Removed
| Table | Column | Notes |
| SDBDB01 | G_WORKDAY_FIN | Replaced with G_SA_FLAG4 |
| SF_EVALUATION | STD_TU_MATCH_DT | Not currently in use Replaced with STD_TU_MATCH_FLG |
| SP_TU_MATCH_DT | Not currently in use Replaced with SP_TU_MATCH_FLG |
|
| P1_TU_MATCH_DT | Not currently in use Replaced with P1_TU_MATCH_FLG |
|
| P2_TU_MATCH_DT | Not currently in use Replaced with P2_TU_MATCH_FLG |
|
| SR_DEPT_CODE | DEPT_FAS_ORG_CODE | |
| STUDENT_1 | S1_BOOLEAN_06 | Not currently in use Replaced with DISAB_MORE_IND |
| SA_WD_DET_TRANS | WD_DET_AID_TYPE | |
| SA_AID_DISB_TRANS | Entire table |
Columns moving from SF_Evaluation to SF_Evaluation1 due to column additions:
| Column |
| rev_req_dispos2 |
| rev_req_type |
| rev_req_type2 |
| routed_to |
| routed_to2 |
| s_accept_excl |
| s_income_base_usd |
| saf_child_care |
| ap_display_sw |
| sap_ovrd_cred_aut |
| sap_ovrd_cred_spr |
| sap_ovrd_cred_sum |
| sap_ovrd_cred_win |
| sap_ovrd_cred_yr |
| pep_ovrd_cred_aut |
| pep_ovrd_cred_win |
| pep_ovrd_cred_spr |
| pep_ovrd_cred_sum |
| pep_ovrd_cred_ay |
| acad_plan_aut |
| acad_plan_win |
| acad_plan_spr |
| acad_plan_sum |
| acad_plan_ay |
| sap_sum_flg |
| sap_aut_flg |
| sap_win_flg |
| sap_spr_flg |
| sap_ay_flg |
| sum_credits_att |
| sum_credits_comp |
| sum_curr_cr_att |
| sum_curr_cr_comp |
| aut_credits_att |
| aut_credits_comp |
| aut_curr_cr_att |
| aut_curr_cr_comp |
| win_credits_att |
| win_credits_comp |
| win_curr_cr_att |
| win_curr_cr_comp |
| spr_credits_att |
| spr_credits_comp |
| spr_curr_cr_att |
| spr_curr_cr_comp |
| pep_sum_cred_req |
| pep_aut_cred_req |
| pep_win_cred_req |
| pep_spr_cred_req |
| sap_sum_cred_req |
| sap_aut_cred_req |
| sap_win_cred_req |
| sap_spr_cred_req |
| sap_ay_cred_att |
| sap_ay_cred_comp |
| sap_ay_cred_req |
| schol_elig_code |
| sng_aut_enroll_st |
| sng_dca_elig |
| sng_spr_enroll_st |
| sng_sum_enroll_st |
| sng_win_enroll_st |
| sf_aut_enrl_lock |
| sf_spr_enrl_lock |
| sf_sum_enrl_lock |
| sf_win_enrl_lock |
| sum_stat_cd |
| aut_stat_cd |
| win_stat_cd |
| spr_stat_cd |
| ay_stat_cd |
| sws_eligible |
| val_complt |
| verif_req_1 |
| verif_req_2 |
| verif_req_3 |
| aid_from_parents |
| aid_hold_no |
| aid_prog_status |
| appeal_recd |
| appeal_recd2 |
| appeal_reviewed |
| appeal_reviewed2 |
| appli_date |
| appli_type |
| arm_date |
| arm_date_temp |
| audit_dt1 |
| audit_dt2 |
| audit_dt3 |
| audit_dt4 |
| audit_dt5 |
| audit_dt6 |
| audit_dt7 |
| audit_dt8 |
| basic_budget |
| books |
| budget_duration |
| child_care |
| corr_trans_cnt |
| corr_trans_sent |
| counselor_rev_dt |
| cps_ss_no |
| creation_date |
| date_last_update |
| dep_maint_allow |
| edit_dt |
| eval_spare_1 |
| eval_spare_2 |
| eval_spare_6 |
| eval_spare_15 |
| eval_spare_18 |
| eval_spare_28 |
| eval_spare_35 |
| eval_spare_36 |
| eval_spare_37 |
| eval_spare_38 |
| eval_spare_39 |
| eval_spare_40 |
| eval_spare_41 |
| eval_spare_42 |
| eval_spare_43 |
| eval_spare_44 |
| eval_spare_45 |
| eval_spare_46 |
| eval_spare_47 |
| extra_books |
| extra_med_dent |
| extra_trans |
| faf_proc_date |
| fws_rev_req_recd |
| gsl_fees |
| indep_pet_rcvd |
| jacket_dt |
| no_of_other_exp |
| other_resource_no |
| outside_aid_amt |
| outside_aid_dt |
| over_awarded_amt |
| p_1040_cy_rcvd |
| p_1040_cy_sent |
| p_1040_ly_rcvd |
| p_1040_ly_sent |
| p_assets_rcvd |
| p_assets_sent |
| p_non_filer_recd |
| p_non_filer_sent |
| p_non_filer_doc |
| p_tax_return_dt |
| p_drt_rev_dt |
| pell_enroll_stat |
| pell_remain_mths |
| pell_last_yr_flg |
| pell_su_st_value |
| pell_su_as_of_dt |
| personal_exp |
| pkg_sum_enroll_st |
| pkg_aut_enroll_st |
| pkg_win_enroll_st |
| pkg_spr_enroll_st |
| tran_no_ovrd |
| qa_reviewed |
| remaining_need |
| rev_req_recd |
| rev_req_recd2 |
| rev_req_review |
| rev_req_review2 |
| rm_bd |
| s_1040_cy_rcvd |
| s_1040_cy_sent |
| s_1040_ly_rcvd |
| s_1040_ly_sent |
| s_assets_rcvd |
| s_assets_sent |
| s_computer_costs |
| s_g845_rcvd |
| s_g845_sent |
| s_inc_exc_rcvd |
| s_inc_exc_sent |
| s_ins_rcvd |
| s_ins_sent |
| s_non_filer_recd |
| s_non_filer_sent |
| s_non_filer_doc |
| s_sel_serv_rcvd |
| s_sel_serv_sent |
| s_ssn_rcvd_dt |
| s_ssn_sent_dt |
| s_tax_return_dt |
| s_drt_rev_dt |
| s_vet_rcvd_dt |
| s_vet_sent_dt |
| s_sub_ovrd_amt |
| s_usub_ovrd_amt |
| s_perk_ovrd_flg |
| s_perk_ovrd_amt |