Skip to content

September 23, 2026

UWSDBDataStore Reorg on October 24, 2026

UWSDBDataStore Reorg on October 24, 2026

The student database (SDB) will go through a reorganization on October 24, 2026 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 26, 2026
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.7.26

Columns to be Added

Table Column DataType
NSLDS_DATA N_NSLDS_UPDATE_DT DATETIME
N_UAGGR_SUB_PEND DECIMAL(15,0)
N_UAGGR_COM_PEND DECIMAL(15,0)
BUDGET_RESOURCES BR_BASIC_BUDGET_F INT
SF_EVALUATION** UW_RECEIPT_DATE DATETIME
FAA_FRAUD_OVRD CHAR(1)
STD_PR_RTN_MAN CHAR(1)
STD_FORGN_RTN_MAN CHAR(1)
STD_COMB_AGI_MAN DECIMAL(9,0)
STD_COMB_TAX_MAN INT_
SPO_PR_RTN_MAN CHAR(1)
SPO_FORGN_RTN_MAN CHAR(1)
SPO_COMB_AGI_MAN DECIMAL(9,0)
SPO_COMB_TAX_MAN INT
P1_PR_RTN_MAN CHAR(1)
P1_FORGN_RTN_MAN CHAR(1)
P1_COMB_AGI_MAN DECIMAL(9,0)
P1_COMB_TAX_MAN INT
P2_PR_RTN_MAN CHAR(1)
P2_FORGN_RTN_MAN CHAR(1)
P2_COMB_AGI_MAN DECIMAL(9,0)
P2_COMB_TAX_MAN INT
CUI_IP_TI DECIMAL(15,0)
STD_COMB_AGI_BLK CHAR(1)
STD_COMB_TAX_BLK CHAR(1)
SPO_COMB_AGI_BLK CHAR(1)
SPO_COMB_TAX_BLK CHAR(1)
P1_COMB_AGI_BLK CHAR(1)
P1_COMB_TAX_BLK CHAR(1)
P2_COMB_AGI_BLK CHAR(1)
P2_COMB_TAX_BLK CHAR(1)
PJ_STD_CAGI_BLK CHAR(1)
PJ_SPO_CAGI_BLK CHAR(1)
PJ_P1_CAGI_BLK CHAR(1)
PJ_P2_CAGI_BLK CHAR(1)
PJ_STD_CAGT_BLK CHAR(1)
PJ_SPO_CAGT_BLK CHAR(1)
PJ_P1_CAGT_BLK CHAR(1)
PJ_P2_CAGT_BLK CHAR(1)
SF_EVALUATION1 PROF_LOAN_FLG CHAR(1)
BASIC_BUDGET_FT INT
BASIC_BUDGET_9M INT
PJ_STD_COMB_AGI DECIMAL(9,0)
PJ_SPO_COMB_AGI DECIMAL(9,0)
PJ_P1_COMB_AGI DECIMAL(9,0)
PJ_P2_COMB_AGI DECIMAL(9,0)
PJ_STD_COMB_TAX INT
PJ_SPO_COMB_TAX INT
PJ_P1_COMB_TAX INT
PJ_P2_COMB_TAX INT
SR_ADM_APPL EXTERNAL_ID INT
EXTERNAL_SUBMIT_DT DATETIME
SR_DEGREE DEG_PGM_FEE_SEQ SMALLINT
DEG_PGM_SUM_FEE CHAR(1)
DEG_BOOLEAN_2 CHAR(1)
DEG_BOOLEAN_3 CHAR(1)
DEG_BOOLEAN_4 CHAR(1)
SR_MAJOR_CODE MAJOR_PGM_FEE_SEQ SMALLINT
SYS_TBL_39_CALENDAR INSUR_ADMFEE_CHRG DECIMAL(10,0)
INSUR_BKRFEE_CHRG DECIMAL(10,0)
PSHIP_CHRG_CD DECIMAL(10,0)
PSHIP_ADMFEE_CHRG DECIMAL(10,0)
PSHIP_BKRFEE_CHRG DECIMAL(10,0)

 

Data Type Changes

Table Column Data Type (Old) Data Type (New)
SF_EVALUATION1 ISIR_VERSION_FLAG CHAR(1) CHAR(3)

Field Rename

Table Column (Old) Column (New)
SR_MAJOR_CODE MAJOR_TYPES_20 MAJOR_PGM_FEE_SUM

Tables to be Added

Table Column DataType
SA_ACCOUNT_PSHIP_INSUR_DATA PSHIP_YEAR SMALLINT
PSHIP_QTR TINYINT
PSHIP_SELECTION TINYINT
PSHIP_STATUS_FLG TINYINT
PSHIP_NUM_DEP_U21 TINYINT
PSHIP_NUM_DEP_21 TINYINT
PSHIP_COMMENT CHAR(12)
PSHIP_USER_ID CHAR(12)
PSHIP_UPDATE_DATE DATETIME
PSHIP_OPT_OUT CHAR(1)
PSHIP_ANNUAL CHAR(1)
PSHIP_SPOUSE CHAR(1)
PSHIP_BOOLEAN_4 CHAR(1)
PSHIP_SPARE_1 CHAR(12)
SYS_TBL_56_AP_EXAM_CREDIT_TBL AP_EC_TEST_TYPE CHAR(6)
AP_EC_TEST_SCORE SMALLINT
AP_EC_SEQ_NUM TINYINT
AP_EC_UW_DEPT CHAR(6)
AP_EC_COURSE_NUM SMALLINT
AP_EC_UW_CREDIT DECIMAL(3,1)
AP_EC_COURSE_TITLE CHAR(19)
AP_EC_TEST_CODE SMALLINT
AP_EC_MSG_CODE_1 CHAR(2)
AP_EC_MSG_CODE_2 CHAR(2)
AP_EC_MSG_CODE_3 CHAR(2)

**Fields moving from sf_evaluation to sf_evaluation1

  • appl_ack_flg
  • assumed_par_age
  • audit_event1
  • audit_event2
  • audit_event3
  • audit_event4
  • audit_event5
  • audit_event6
  • audit_event7
  • audit_event8
  • beog_index
  • budget_code
  • budget_qtrs
  • budget_updt_flg
  • budget_cont_flg
  • budget_dt
  • correction_flg
  • corr_in_process
  • counselor_rev_req
  • cps_degree_by_jul
  • cps_dependency
  • cps_marital
  • cps_married
  • cps_p_mar_status
  • cps_fisap_income
  • cps_pell_change
  • cps_pj_dt
  • edit_flg
  • efc_override
  • eval_spare_9
  • eval_spare_10
  • eval_spare_13
  • eval_spare_14
  • eval_spare_21
  • faf_dep_override