UWSDBDataStore Reorg on June 3, 2023

May 22, 2023

UWSDBDataStore Reorg on June 3, 2022

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

Last Updated – 06.01.23

 

Columns to be Added

Table Column DataType
BUDGET_RESOURCES BR_PPLUS_LOAN_FEE int
BR_GPLUS_LOAN_FEE int
DL_SUPL_PLUS SP_PREV_CR_STAT char(1)
SF_EDIT_DESC SF_ED_EDIT_CD2 char(3)
SF_ED_EDIT_CD3 char(3)
SF_ED_HOLD_CD2 char(2)
SF_EVALUATION UNUS_CIRCUMSTANCE char(1)
SF_FEES SFF_TERM char(1)
SFF_CLASS tinyint
SFF_FEES_SPARE1 tinyint
SFF_FEES_SPARE2 char(2)
SFF_FEES_SPARE3 int
SF_HISTORY UNACC_YTH_HISTORY char(1)
UNACC_YTH_HIST_DT datetime
UNUS_CIRC_HISTORY char(1)
UNUS_CIRC_HIST_DT datetime
COMP_DEP_HISTORY char(1)
SF_ROOM_BOARD_TBL RB_HOUSING_AMT int
RB_FOOD_AMT int
SR_ADM_APPL UW_PROMISE char(1)
STUDENT_1 DISAB_START_YR smallint
DISAB_START_QTR tinyint
DISAB_PR_BEG_YR smallint
DISAB_PR_BEG_QTR tinyint
DISAB_PR_END_YR smallint
DISAB_PR_END_QTR tinyint
DISAB_RC_BEG_YR smallint
DISAB_RC_BEG_QTR tinyint
DISAB_RC_END_YR smallint
DISAB_RC_END_QTR tinyint
S1_BOOLEAN_06 bit
S1_BOOLEAN_07 bit
S1_BOOLEAN_08 bit
SYS_TBL_63_NONTUIT_CHARGES NONT_MEDICINE bit
SPARE_BOOLEAN_1 bit

Column Renames (all currently not in use)

Table Existing Name New Name
SDBDB01  G_SR_FLAG5 G_SR_BATCH_IP
SR_MAJOR_CODE MAJOR_TYPES_20 MAJOR_EXCHANGE
STUDENT_1 S1_BOOLEAN_13 DISAB_RCLOAD
S1_BOOLEAN_14 DISAB_ALTFMT

Columns with data type changes

Table Column DataType
FINAID_DOCS FD_DOC_KEY char(30)