UWSDBDataStore Reorg on October 21, 2023
October 11, 2023
UWSDBDataStore Reorg on October 21, 2023
The student database (SDB) will go through a reorganization on October 21, 2023 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 23, 2023
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 – 10.19.23
Columns to be Added
| Table | Column | DataType |
| SF_EDIT_DESC | SF_ED_Year_Code | smallint |
| SR_ADM_APPL | SEATTLE_PROMISE | char(1) |
| SR_TEST_SCORES | TEST_SCORE_DEC | decimal(4,1) |
| SYS_TBL_42_TEST_RANGE | TEST_MIN_SCORE_DEC | decimal(4,1) |
| TEST_MAX_SCORE_DEC | decimal(4,1) | |
| SYS_TBL_63_NONTUIT_CHANGES | AID_REPAY_FUND | int |
Columns with datatype changes
| Table | Column | DataType |
| SR_TEST_SCORES | TEST_PCTILE | smallint |
Columns to be Removed
| Table | Column | DataType |
| SYS_TBL_63_NONTUIT_CHANGES | ON_CHRG_DB_TAG | char(12) |
| ON_CHRG_DB_NAME | char(12) | |
| ON_CHRG_DB_RCAT | char(6) | |
| ON_PAY_DB_TAG | char(12) | |
| ON_PAY_DB_NAME | char(12) | |
| ON_PAY_DB_RCAT | char(6) | |
| ON_PAY_CR_TAG | char(12) | |
| ON_PAY_CR_NAME | char(12) | |
| ON_PAY_CR_RCAT | char(6) |
Columns to be Added in SF_EVALUATION*
SF_Evaluation will be split into multiple tables post reorg, splits will be available in this page as soon as determined 10.11.23 – see table split below column adds 10.18.23
| Column | DataType | |
| SF_EVALUATION | EVAL_SPARE_36 | int |
| EVAL_SPARE_37 | int | |
| EVAL_SPARE_38 | int | |
| EVAL_SPARE_39 | int | |
| EVAL_SPARE_40 | char(4) | |
| EVAL_SPARE_41 | char(4) | |
| EVAL_SPARE_42 | char(4) | |
| EVAL_SPARE_43 | char(4) | |
| EVAL_SPARE_44 | int | |
| EVAL_SPARE_45 | int | |
| EVAL_SPARE_46 | int | |
| EVAL_SPARE_47 | int | |
| SF_EVALUATION | FAFSA_UUID | char(36) |
| TRANS_UUID | char(36) | |
| PERSON_UUID | char(36) | |
| FAFSA_APP_SRC | tinyint | |
| FAFSA_TRANS_SRC | tinyint | |
| FAFSA_TRANS_TYPE | char(1) | |
| FAFSA_TRANS_LANG | char(1) | |
| FAFSA_PROC_DATE | datetime | |
| FAFSA_TRANS_STAT | char(30) | |
| FAFSA_RENEW_DATA | char(3) | |
| FPS_CORR_REASON | char(1) | |
| SAI_CHANGE_FLG | char(1) | |
| SAI | int | |
| SAI_ADJ | int | |
| PROV_SAI | int | |
| PROV_SAI_ADJ | int | |
| FPS_SAI | int | |
| SAI_FORMULA | char(1) | |
| COMP_TYPE | char(2) | |
| MAX_PELL_IND | char(1) | |
| MIN_PELL_IND | char(1) | |
| STD_ITIN | int | |
| STD_COUNTRY | char(2) | |
| PURS_TEACH_CERT | char(1) | |
| PARENTS_DECEASED | char(1) | |
| WARD_OF_COURT | char(1) | |
| IN_FOSTER_CARE | char(1) | |
| PERSONAL_CIRC | char(1) | |
| UNACC_HMLS_GEN | char(1) | |
| UNACC_HMLS_TRIO | char(1) | |
| UNACC_HMLS_FAA | char(1) | |
| OTHER_CIRCUMSTAN | char(1) | |
| UNSUB_ONLY | char(1) | |
| A_NUMBER | int | |
| PARENT_ATTND_COLL | char(1) | |
| PARENT_LINE_DUTY | char(1) | |
| HS_EQUIV_DIP_NAME | char(1) | |
| HS_EQUIV_DIP_ST | char(2) | |
| STD_EITC_MAN | char(1) | |
| STD_FED_HOUS_MAN | char(1) | |
| STD_FREE_LNCH_MAN | char(1) | |
| STD_MEDICAID_MAN | char(1) | |
| STD_36B_CRED_MAN | char(1) | |
| STD_SNAP_BEN_MAN | char(1) | |
| STD_SSI_BEN_MAN | char(1) | |
| STD_TNF_BEN_MAN | char(1) | |
| STD_WIC_BEN_MAN | char(1) | |
| STD_FED_BEN_MAN | char(1) | |
| STD_1040_MAN | char(1) | |
| STD_NON_US_MAN | char(1) | |
| STD_JOINT_RET_MAN | char(1) | |
| STD_RET_STAT_MAN | char(1) | |
| STD_WK_INCOME_MAN | decimal (11,0) | |
| STD_INTEREST_MAN | decimal (11,0) | |
| STD_IRA_DIST_MAN | decimal (11,0) | |
| STD_IRA_ROLL_MAN | decimal (11,0) | |
| STD_PENSIONS_MAN | decimal (11,0) | |
| STD_PENS_ROLL_MAN | decimal (11,0) | |
| STD_AGI_MAN | int | |
| STD_TAX_PAID_MAN | int | |
| STD_DEDCT_PMT_MAN | decimal (11,0) | |
| STD_FL_ABDEFH_MAN | char(1) | |
| STD_SCHED_C_MAN | decimal (11,0) | |
| STD_GRNT_SCHL_MAN | int | |
| STD_FRGN_EXCL_MAN | decimal (11,0) | |
| STD_CHLD_SUPP_MAN | int | |
| STD_CASH_MAN | int | |
| STD_INVEST_MAN | int | |
| STD_BUS_FARM_MAN | int | |
| STD_FTI_CONSENT | char(1) | |
| STD_SIGNED | char(1) | |
| STD_SIGNED_DT | datetime | |
| SPO_FIRST_NAME | char(35) | |
| SPO_MID_NAME | char(15) | |
| SPO_LAST_NAME | char(35) | |
| SPO_SUFFIX | char(10) | |
| SPO_BIRTH_DT | datetime | |
| SPO_SS_NO | char(9) | |
| SPO_ITIN | char(9) | |
| SPO_PHONE_NO | char(10) | |
| SPO_EMAIL | char(50) | |
| SPO_ADDRESS | char(40) | |
| SPO_CITY | char(30) | |
| SPO_STATE | char(2) | |
| SPO_ZIP | char(10) | |
| SPO_COUNTRY | char(2) | |
| SPO_1040_MAN | char(1) | |
| SPO_NON_US_MAN | char(1) | |
| SPO_RET_STAT_MAN | char(1) | |
| SPO_WK_INCOME_MAN | decimal (11,0) | |
| SPO_INTEREST_MAN | decimal (11,0) | |
| SPO_IRA_DIST_MAN | decimal (11,0) | |
| SPO_IRA_ROLL_MAN | decimal (11,0) | |
| SPO_PENS_ROLL_MAN | int | |
| SPO_AGI_MAN | int | |
| SPO_TAX_PAID_MAN | decimal (11,0) | |
| SPO_DEDCT_PMT_MAN | decimal (11,0) | |
| SPO_EDUC_CRED_MAN | int | |
| SPO_FL_ABDEFH_MAN | char(1) | |
| SPO_SCHED_C_MAN | decimal (11,0) | |
| SPO_FRGN_EXCL_MAN | int | |
| SPO_FTI_CNSNT_MAN | char(1) | |
| SPO_SIGNED_MAN | char(1) | |
| SPO_SIGN_DT_MAN | datetime | |
| P1_FIRST_NAME | char(35) | |
| P1_MIDDLE_NAME | char(15) | |
| P1_LAST_NAME | char(35) | |
| P1_SUFFIX | char(10) | |
| P1_DOB | datetime | |
| P1_SS_NO | int | |
| P1_ITIN | int | |
| P1_PHONE_NO | char(10) | |
| P1_EMAIL | char(50) | |
| P1_ADDRESS | char(50) | |
| P1_CITY | char(30) | |
| P1_STATE | char(2) | |
| P1_ZIP | char(10) | |
| P1_COUNTRY | char(2) | |
| P1_EITC_MAN | char(1) | |
| P1_FED_HOUS_MAN | char(1) | |
| P1_FREE_LNCH_MAN | char(1) | |
| P1_MEDICAID_MAN | char(1) | |
| P1_36B_CRED_MAN | char(1) | |
| P1_SNAP_BEN_MAN | char(1) | |
| P1_SSI_BEN_MAN | char(1) | |
| P1_TANF_BEN_MAN | char(1) | |
| P1_WIC_BEN_MAN | char(1) | |
| P1_FED_BEN_MAN | char(1) | |
| P1_1040_MAN | char(1) | |
| P1_NON_US_MAN | char(1) | |
| P1_JOINT_RET_MAN | char(1) | |
| P1_RET_STAT_MAN | char(1) | |
| P1_WK_INCOME_MAN | decimal (11,0) | |
| P1_INTEREST_MAN | decimal (11,0) | |
| P1_IRA_DIST_MAN | decimal (11,0) | |
| P1_IRA_ROLL_MAN | decimal (11,0) | |
| P1_PENS_ROLL_MAN | decimal (11,0) | |
| P1_AGI_MAN | int | |
| P1_TAX_PAID_MAN | int | |
| P1_DEDCT_PMT_MAN | decimal (11,0) | |
| P1_EDUC_CRED_MAN | decimal (11,0) | |
| P1_FL_ABDEFH_MAN | char(1) | |
| P1_SCHED_C_MAN | decimal (11,0) | |
| P1_GRNT_SCHL_MAN | int | |
| P1_FRGN_EXCL_MAN | int | |
| P1_CHLD_SUPP_MAN | int | |
| P1_CASH_MAN | int | |
| P1_INVEST_MAN | int | |
| P1_BUS_FARM_MAN | int | |
| P1_FTI_CONS_MAN | char(1) | |
| P1_SIGNED_MAN | char(1) | |
| P1_SIGN_DT_MAN | datetime | |
| P2_FIRST_NAME | char(35) | |
| P2_MIDDLE_NAME | char(15) | |
| P2_LAST_NAME | char(35) | |
| P2_SUFFIX | char(10) | |
| P2_DOB | datetime | |
| P2_SS_NO | int | |
| P2_ITIN | int | |
| P2_PHONE_NO | char(10) | |
| P2_EMAIL | char(50) | |
| P2_ADDRESS | char(50) | |
| P2_CITY | char(30) | |
| P2_STATE | char(2) | |
| P2_ZIP | char(10) | |
| P2_COUNTRY | char(2) | |
| P2_1040_MAN | char(1) | |
| P2_NON_US_MAN | char(1) | |
| P2_RET_STAT_MAN | char(1) | |
| P2_WK_INCOME_MAN | decimal (11,0) | |
| P2_INTEREST_MAN | decimal (11,0) | |
| P2_IRA_DIST_MAN | decimal (11,0) | |
| P2_IRA_ROLL_MAN | decimal (11,0) | |
| P2_PENSIONS_MAN | decimal (11,0) | |
| P2_PENS_ROLL_MAN | decimal (11,0) | |
| P2_AGI_MAN | int | |
| P2_TAX_PAID_MAN | decimal (11,0) | |
| P2_DEDCT_PMT_MAN | decimal (11,0) | |
| P2_EDUC_CRED_MAN | decimal (11,0) | |
| P2_FL_ABDEFH_MAN | char(1) | |
| P2_SCHED_C_MAN | decimal (11,0) | |
| P2_FRGN_EXCL_MAN | int | |
| P2_FTI_CONS_MAN | char(1) | |
| P2_SIGNED_MAN | char(1) | |
| P2_SIGN_DT_MAN | datetime | |
| STD_AFFIL_STAT | char(1) | |
| STD_SP_AFFIL_STAT | char(1) | |
| STD_P1_AFFIL_STAT | char(1) | |
| STD_P2_AFFIL_STAT | char(1) | |
| STD_CONS_GRNT_DT | datetime | |
| SP_CONS_GRNT_DT | datetime | |
| P1_CONS_GRNT_DT | datetime | |
| P2_CONS_GRNT_DT | datetime | |
| STD_TU_MATCH_DT | datetime | |
| SP_TU_MATCH_DT | datetime | |
| P1_TU_MATCH_DT | datetime | |
| P2_TU_MATCH_DT | datetime | |
| CORRECTION_APPLD | char(2) | |
| FAA_SIGNED | char(1) | |
| IASG_INDICATOR | char(1) | |
| COFH_INDICATOR | char(1) | |
| ETI_DEST_NUM | char(7) | |
| STD_SIGNED_SRC | char(1) | |
| SP_SIGNED_SRC | char(1) | |
| P1_SIGNED_SRC | char(1) | |
| P2_SIGNED_SRC | char(1) | |
| SPEC_HAND_IND | char(1) | |
| INCARC_APPL | char(1) | |
| SF_EVALUATION | IP_STD_FWS | decimal (15,0) |
| IP_SP_FWS | decimal (15,0) | |
| IP_P1_FWS | decimal (15,0) | |
| IP_P2_FWS | decimal (15,0) | |
| IP_P_PTA | decimal (15,0) | |
| IP_P_PEEA | decimal (15,0) | |
| IP_STD_PTA | decimal (15,0) | |
| IP_STD_PNAAI | decimal (15,0) | |
| IP_STD_SEEA | decimal (15,0) | |
| IP_STAI | decimal (15,0) | |
| IP_SCI | decimal (15,0) | |
| IP_SAAI | decimal (15,0) | |
| IP_SC_SAAI | decimal (15,0) | |
| IP_A_SFS | smallint | |
| IP_A_PFS | smallint | |
| SF_EVALUATION | CUI_BEGIN_STRING | char(11) |
| CUI_STD_TAX_YEAR | smallint | |
| CUI_STD_FILE_STAT | char(1) | |
| CUI_STD_AGI | int | |
| CUI_STD_EXEMPTS | tinyint | |
| CUI_STD_DEPS | tinyint | |
| CUI_STD_INC_EARN | decimal (11,0) | |
| CUI_STD_TAX_PAID | int | |
| CUI_STD_EDUC_CRED | int | |
| CUI_STD_IRA_DIST | decimal (11,0) | |
| CUI_STD_IRA_PYMTS | decimal (11,0) | |
| CUI_STD_INTEREST | decimal (11,0) | |
| CUI_STD_PENSIONS | decimal (11,0) | |
| CUI_STD_SCHED_C | decimal (11,0) | |
| CUI_STD_SCHED_A | char(1) | |
| CUI_STD_SCHED_B | char(1) | |
| CUI_STD_SCHED_D | char(1) | |
| CUI_STD_SCHED_E | char(1) | |
| CUI_STD_SCHED_F | char(1) | |
| CUI_STD_SCHED_H | char(1) | |
| CUI_STD_IRS_RESP | smallint | |
| CUI_SPO_TAX_YEAR | smallint | |
| CUI_SPO_FILE_STAT | char(1) | |
| CUI_SPO_AGI | int | |
| CUI_SPO_EXEMPTS | tinyint | |
| CUI_SPO_DEPS | tinyint | |
| CUI_SPO_INC_EARN | decimal (11,0) | |
| CUI_SPO_TAX_PAID | int | |
| CUI_SPO_EDUC_CRED | int | |
| CUI_SPO_IRA_DIST | decimal (11,0) | |
| CUI_SPO_IRA_PYMTS | decimal (11,0) | |
| CUI_SPO_INTEREST | decimal (11,0) | |
| CUI_SPO_PENSIONS | decimal (11,0) | |
| CUI_SPO_SCHED_C | decimal (11,0) | |
| CUI_SPO_SCHED_A | char(1) | |
| CUI_SPO_SCHED_B | char(1) | |
| CUI_SPO_SCHED_D | char(1) | |
| CUI_SPO_SCHED_E | char(1) | |
| CUI_SPO_SCHED_F | char(1) | |
| CUI_SPO_SCHED_H | char(1) | |
| CUI_SPO_IRS_RESP | smallint | |
| CUI_P1_TAX_YEAR | smallint | |
| CUI_P1_FILE_STAT | char(1) | |
| CUI_P1_AGI | int | |
| CUI_P1_EXEMPTS | tinyint | |
| CUI_P1_DEPS | tinyint | |
| CUI_P1_INC_EARN | decimal (11,0) | |
| CUI_P1_TAX_PAID | int | |
| CUI_P1_EDUC_CRED | int | |
| CUI_P1_IRA_DIST | decimal (11,0) | |
| CUI_P1_IRA_PYMTS | decimal (11,0) | |
| CUI_P1_INTEREST | decimal (11,0) | |
| CUI_P1_PENSIONS | decimal (11,0) | |
| CUI_P1_SCHED_C | decimal (11,0) | |
| CUI_P1_SCHED_A | char(1) | |
| CUI_P1_SCHED_B | char(1) | |
| CUI_P1_SCHED_D | char(1) | |
| CUI_P1_SCHED_E | char(1) | |
| CUI_P1_SCHED_F | char(1) | |
| CUI_P1_SCHED_H | char(1) | |
| CUI_P1_IRS_RESP | smallint | |
| CUI_P2_TAX_YEAR | smallint | |
| CUI_P2_FILE_STAT | char(1) | |
| CUI_P2_AGI | int | |
| CUI_P2_EXEMPTS | tinyint | |
| CUI_P2_DEPS | tinyint | |
| CUI_P2_INC_EARN | decimal (11,0) | |
| CUI_P2_TAX_PAID | int | |
| CUI_P2_EDUC_CRED | int | |
| CUI_P2_IRA_DIST | decimal (11,0) | |
| CUI_P2_IRA_PYMTS | decimal (11,0) | |
| CUI_P2_INTEREST | decimal (11,0) | |
| CUI_P2_PENSIONS | decimal (11,0) | |
| CUI_P2_SCHED_C | decimal (11,0) | |
| CUI_P2_SCHED_A | char(1) | |
| CUI_P2_SCHED_B | char(1) | |
| CUI_P2_SCHED_D | char(1) | |
| CUI_P2_SCHED_E | char(1) | |
| CUI_P2_SCHED_F | char(1) | |
| CUI_P2_SCHED_H | char(1) | |
| CUI_P2_IRS_RESP | smallint | |
| CUI_END_STRING | char(11) | |
| SF_EVALUATION1 | SYSTEM_KEY | int |
| YEAR_CODE | smallint | |
| PJ_STD_FILE_STAT | char(1) | |
| PJ_STD_WORK_INC | decimal (11,0) | |
| PJ_STD_TAXES_PD | decimal (11,0) | |
| PJ_STD_AGI | decimal (11,0) | |
| PJ_STD_UNTAX_IRS | decimal (11,0) | |
| PJ_STD_IRA_PMTS | decimal (11,0) | |
| PJ_STD_EDUC_CRED | decimal (11,0) | |
| PJ_STD_INTEREST | decimal (11,0) | |
| PJ_STD_EXMPTS | decimal (11,0) | |
| PJ_STD_SCHED_C | decimal (11,0) | |
| PJ_STD_UNTAX_PENS | decimal (11,0) | |
| PJ_STD_IRS_RESP | decimal (11,0) | |
| PJ_SP_FILE_STAT | char(1) | |
| PJ_SP_WORK_INC | decimal (11,0) | |
| PJ_SP_TAXES_PD | decimal (11,0) | |
| PJ_SP_AGI | decimal (11,0) | |
| PJ_SP_UNTAX_IRS | decimal (11,0) | |
| PJ_SP_IRA_PMTS | decimal (11,0) | |
| PJ_SP_EDUC_CRED | decimal (11,0) | |
| PJ_SP_INTEREST | decimal (11,0) | |
| PJ_SP_EXMPTS | decimal (11,0) | |
| PJ_SP_SCHED_C | decimal (11,0) | |
| PJ_SP_UNTAX_PENS | decimal (11,0) | |
| PJ_SP_IRS_RESP | decimal (11,0) | |
| PJ_P1_FILE_STAT | char(1) | |
| PJ_P1_WORK_INC | decimal (11,0) | |
| PJ_P1_TAXES_PD | decimal (11,0) | |
| PJ_P1_AGI | decimal (11,0) | |
| PJ_P1_UNTAX_IRS | decimal (11,0) | |
| PJ_P1_IRA_PMTS | decimal _NON(11,0) | |
| PJ_P1_EDUC_CRED | decimal (11,0) | |
| PJ_P1_INTEREST | decimal (11,0) | |
| PJ_P1_EXMPTS | decimal (11,0) | |
| PJ_P1_SCHED_C | decimal (11,0) | |
| PJ_P1_UNTAX_PENS | decimal (11,0) | |
| PJ_P1_IRS_RESP | decimal (11,0) | |
| PJ_P2_FILE_STAT | char(1) | |
| PJ_P2_WORK_INC | decimal (11,0) | |
| PJ_P2_TAXES_PD | decimal (11,0) | |
| PJ_P2_AGI | decimal (11,0) | |
| PJ_P2_UNTAX_IRS | decimal (11,0) | |
| PJ_P2_IRA_PMTS | decimal (11,0) | |
| PJ_P2_EDUC_CRED | decimal (11,0) | |
| PJ_P2_INTEREST | decimal (11,0) | |
| PJ_P2_EXMPTS | decimal (11,0) | |
| PJ_P2_SCHED_C | decimal (11,0) | |
| PJ_P2_UNTAX_PENS | decimal (11,0) | |
| PJ_P2_IRS_RESP | decimal (11,0) |
Columns currently in SF_Evaluation and moving to SF_Evaluation1
| Column |
| scholarship_apl |
| smart_progress_cd |
| sng_calc_dt |
| sng_dep_allowance |
| sng_grant_amt |
| sng_index |
| sng_osfa_qtrs |
| sum_only_costs |
| sum_stafford_fees |
| sumr_aid_apl |
| sum_housing |
| sum_class |
| sum_finish_prog |
| sum_credits |
| sum_term |
| sum_tuition |
| sum_books |
| sum_rm_bd |
| sum_trans |
| sum_personal_exp |
| sum_dep_mnt_allow |
| sum_foreign_stdy |
| sum_ay_housing |
| sws_accepted |
| sws_apl |
| sws_job_costs |
| total_budget |
| total_eligibility |
| remaining_elig |
| total_resources |
| misc_resources |
| total_equity |
| remaining_equity |
| sum_equity |
| sum_rem_equity |
| transportation |
| tuition |
| unassessed_pc |
| unusual_maint_all |
| unus_circumstance |
| uw_need |
| validate |
| verif_req_1_rcvd |
| verif_req_1_sent |
| verif_req_2_rcvd |
| verif_req_2_sent |
| verif_req_3_rcvd |
| verif_req_3_sent |
| xdrop_dt |
| spcl_program |
| sf_class |
| health_prof |
| sf_campus |
| deg_level |
| deg_type |
| pathway |
| college |
| major_abbr |
| resident |
| evening |
| commuter |
| budget_calculated |
| sumr_pr_stdnt |
| ser_corrected_rev |
| grad_minority |
| folder |
| appl_acknowledged |
| addl_unsub_elig |
| sf_boolean_20 |
| sf_boolean_21 |
| sf_boolean_22 |
| sf_boolean_23 |
| sf_boolean_24 |
| cps_grad_prof |
| exclude_va_amt |
| tg_serve_flg |
| tg_counsel_flg |
| coa_accepted_flg |
| coa_accepted_dt |
| s_asla_cmplt |
| s_asla_cmplt_dt |
| s_asla_cmplt_id |
| u_asla_cmplt |
| u_asla_cmplt_dt |
| u_asla_cmplt_id |
| p_asla_cmplt |
| p_asla_cmplt_dt |
| p_asla_cmplt_id |
| g_asla_cmplt |
| g_asla_cmplt_dt |
| g_asla_cmplt_id |
| strt_qtr_ovrd |
| bridge_grant_amt |
| state_aid_only |