Skip to content

April 17, 2026

UWSDBDataStore Reorg on May 2, 2026

UWSDBDataStore Reorg on May 2, 2026

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

Columns to be Added

Table Column DataType
NSLDS_DATA N_LOAN_LIM_EXC_FG CHAR(1)
N_DISB_DT_FLG CHAR(1)
N_LIFETM_LOAN_TOT DECIMAL(15,0)
N_G_COMB_LIM_FLGA CHAR(1)
N_P_COMB_LIM_FLGA CHAR(1)
N_PLUS_LIMIT_FLG CHAR(1)
N_LIFETIME_MAX_FG CHAR(1)
N_AGGR_GRAD_BAL DECIMAL(15,0)
N_GRAD_CONS_BAL DECIMAL(15,0)
N_AGGR_GRAD_PEND DECIMAL(15,0)
N_AGGR_GRAD_TOT DECIMAL(15,0)
N_GRAD_CONS_TOT DECIMAL(15,0)
N_GRAD_AWARD_YR SMALLINT
N_GRAD_DEP_IND CHAR(1)
N_AGGR_PROF_BAL DECIMAL(15,0)
N_PROF_CONS_BAL DECIMAL(15,0)
N_AGGR_PROF_PEND DECIMAL(15,0)
N_AGGR_PROF_TOT DECIMAL(15,0)
N_PROF_CONS_TOT DECIMAL(15,0)
N_PROF_AWARD_YR SMALLINT
N_PROF_DEP_IND CHAR(1)
N_GRAD_LN_LIM_FLG CHAR(1)
N_PROF_LN_LIM_FLG CHAR(1)
N_AGGR_STD_PL_FLG CHAR(1)
N_UG_AGGR_SUB_OPB DECIMAL(15,0)
N_UG_AGGR_UNS_OPB DECIMAL(15,0)
N_UG_AGGR_COM_OPB DECIMAL(15,0)
N_UG_AGGR_CON_OPB DECIMAL(15,0)
N_UG_AGGR_SUB_TOT DECIMAL(15,0)
N_UG_AGGR_UNS_TOT DECIMAL(15,0)
N_UG_AGGR_COM_TOT DECIMAL(15,0)
N_UG_AGGR_CON_TOT DECIMAL(15,0)
N_UG_AWARD_YR SMALLINT
N_UGRAD_DEP_IND CHAR(1)
N_PO_GP_SUB_OPB DECIMAL(15,0)
N_PO_GP_UNS_OPB DECIMAL(15,0)
N_PO_GP_COMB_BAL DECIMAL(15,0)
N_PO_GP_CONS_BAL DECIMAL(15,0)
N_PO_GP_AG_S_TOT DECIMAL(15,0)
N_PO_GP_AG_US_TOT DECIMAL(15,0)
N_PO_GP_AG_CN_TOT DECIMAL(15,0)
N_PO_GP_AG_UN_TOT DECIMAL(15,0)
N_PO_GP_AWARD_YR SMALLINT
N_PO_GP_DEP_IND CHAR(1)
N_LOAN_LIM_EXC_CH CHAR(1)
SA_ACCOUNT_INSURANCE_DATA INSUR_TYPE CHAR(1)
SA_TRANSACTION ECSI_PROCESS_IND CHAR(1)
ECSI_PROCESS_DT DATETIME
SF_EVALUATION** ENROLL_WORK_FORCE CHAR(1)
SF_EVALUATION1 UW_UNMET_NEED_NIL INT
ISIR_VERSION_FLAG CHAR(1)
SF_FEES SFF_MAJOR CHAR(6)
SFF_FULL_FEE_AMT INT
SF_HISTORY OVRD_LOAN_LIM_EXC CHAR(1)
LOAN_LIMIT_EXC_DT DATETIME
STUDENT_1 REGID CHAR(16)

Data Type Changes

Table Column Data Type (Old) Data Type (New)
NSLDS_DATA N_AGGR_SUB_BAL INT DECIMAL(15,0)
N_AGGR_USUB_BAL INT DECIMAL(15,0)
N_AGGR_COMB_BAL INT DECIMAL(15,0)
N_AGGR_CONS_BAL INT DECIMAL(15,0)
N_AGGR_TEACH_BAL INT DECIMAL(15,0)
N_SUB_PEND_DISB INT DECIMAL(15,0)
N_USUB_PEND_DISB INT DECIMAL(15,0)
N_COMB_PEND_DISB INT DECIMAL(15,0)
N_AGGR_SUB_TOT INT DECIMAL(15,0)
N_AGGR_USUB_TOT INT DECIMAL(15,0)
N_AGGR_COMB_TOT INT DECIMAL(15,0)
N_AGGR_CONS_TOT INT DECIMAL(15,0)
N_TEACH_LN_TOT INT DECIMAL(15,0)
N_PERK_DISB_AMT INT DECIMAL(15,0)
N_PERK_CURRYR_AMT INT DECIMAL(15,0)
N_AGGR_TCH_UDISB INT DECIMAL(15,0)
N_AGGR_TCH_GDISB INT DECIMAL(15,0)
N_SPARE7 INT DECIMAL(15,0)
N_SPARE8 INT DECIMAL(15,0)
N_SPARE9 INT DECIMAL(15,0)
N_SPARE_10 INT DECIMAL(15,0)
N_SPARE_11 INT DECIMAL(15,0)
N_SPARE_12 INT DECIMAL(15,0)
NSLDS_DATA_PELL_DATA N_PELL_SCHED_AMT INT DECIMAL(15,0)
N_PELL_PD_TO_DT INT DECIMAL(15,0)
N_PELL_AWARD_AMT INT DECIMAL(15,0)
NSLDS_DATA_TEACH_DATA N_TEACH_SCHED_AMT INT DECIMAL(15,0)
N_TEACH_PD_TO_DT INT DECIMAL(15,0)
N_TEACH_AWARD_AMT INT DECIMAL(15,0)
N_TEACH_SCHOOL_YR TINYINT SMALLINT
NSLDS_DATA_LN_DATA N_LN_OUT_BAL INT DECIMAL(15,0)
N_LN_LST_DISB_AMT INT DECIMAL(15,0)
SA_ACCOUNT_INSURANCE_DATA INSUR_SPARE_1 CHAR(6) CHAR(12)

 

Table Key Changes

Table Old Primary Key New Primary Key
SF_FEES SFF_YEAR_CODE
SFF_TERM
SFF_CAMPUS
SFF_CLASS
SFF_CREDIT_HOURS		 SFF_YEAR_CODE
SFF_TERM
SFF_CAMPUS
SFF_CLASS
SFF_MAJOR* (new PK field)
SFF_CREDIT_HOURS

 

New Table – SF_COD_DATA

Table Column DataType Primary Key
SF_COD_DATA SYSTEM_KEY INT Y
COD_YEAR SMALLINT Y
LOAN_ANNUAL_CRDS DECIMAL(5,1)
LOAN_ANNUAL_PRCNT SMALLINT
LOAN_ANNUAL_FT_CR TINYINT
LOAN_GRADE_LEVEL TINYINT
LOAN_INST_LIMIT CHAR(1)
LOAN_LIMIT_EXP CHAR(1)
PROG_ATND_BEG_DT DATETIME
PROG_PUB_LNGTH DECIMAL(6,3)
PROG_REM_LNGTH DECIMAL(6,3)
WRK_FRC_PELL_ELIG CHAR(1)
WRK_FRC_PELL_FEES INT
ENRL_INT_S_SUM SMALLINT
ENRL_INT_S_AUT SMALLINT
ENRL_INT_S_WIN SMALLINT
ENRL_INT_S_SPR SMALLINT
ENRL_INT_U_SUM SMALLINT
ENRL_INT_U_AUT SMALLINT
ENRL_INT_U_WIN SMALLINT
ENRL_INT_U_SPR SMALLINT
ENRL_INT_G_SUM SMALLINT
ENRL_INT_G_AUT SMALLINT
ENRL_INT_G_WIN SMALLINT
ENRL_INT_G_SPR SMALLINT
ENRL_INT_P_SUM SMALLINT
ENRL_INT_P_AUT SMALLINT
ENRL_INT_P_WIN SMALLINT
ENRL_INT_P_SPR SMALLINT
ENRL_STS_S_SUM DECIMAL(3,1)
ENRL_STS_S_AUT DECIMAL(3,1)
ENRL_STS_S_WIN DECIMAL(3,1)
ENRL_STS_S_SPR DECIMAL(3,1)
ENRL_STS_U_SUM DECIMAL(3,1)
ENRL_STS_U_AUT DECIMAL(3,1)
ENRL_STS_U_WIN DECIMAL(3,1)
ENRL_STS_U_SPR DECIMAL(3,1)
ENRL_STS_G_SUM DECIMAL(3,1)
ENRL_STS_G_AUT DECIMAL(3,1)
ENRL_STS_G_WIN DECIMAL(3,1)
ENRL_STS_G_SPR DECIMAL(3,1)
ENRL_STS_P_SUM DECIMAL(3,1)
ENRL_STS_P_AUT DECIMAL(3,1)
ENRL_STS_P_WIN DECIMAL(3,1)
ENRL_STS_P_SPR DECIMAL(3,1)

Table Removal – Empty & No Usage

Table
SR_DEC_RESULTS

Due to the field add in SF_Evaluation the following field will move to SF_Evaluation1

FOREIGN_STUDY_AMT