UWSDBDataStore Reorg on October 19, 2024
September 27, 2024
UWSDBDataStore Reorg on October 19, 2024
The student database (SDB) will go through a reorganization on October 19, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 21, 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 – 9.27.24
Columns to be Added
| Table | Column | DataType |
| ISIR_TRANSACTIONS | ISIR_MAX_PELL_IND | char(1) |
| ISIR_MIN_PELL_IND | char(1) | |
| I_SPO_BIRTH_DT | datetime | |
| I_SPO_SS_NO | int | |
| I_P1_BIRTH_DT | datetime | |
| I_P1_SS_NO | int | |
| I_P2_BIRTH_DT | datetime | |
| I_P2_SS_NO | int | |
| I_STD_FTI_CONS | char(1) | |
| I_SPO_FTI_CONS | char(1) | |
| I_P1_FTI_CONS | char(1) | |
| I_P2_FTI_CONS | char(1) | |
| SF_EVALUATION | CALC_P_FAM_SIZE | tinyint |
| CALC_S_FAM_SIZE | tinyint | |
| CPS_PELL_CHANGE | char(1) | |
| SF_EVALUATION1 | OVRD_EXCLUDE_ASTS | char(1) |
| OVRD_SINGL_PARENT | char(1) | |
| INAS_SINGL_PARENT | char(1) | |
| SR_ADM_RESULTS | SR_AAR_SSN | int |
| SR_AAR_SLATE_ID | int | |
| SR_AAR_SPARE_1 | int | |
| SR_AAR_SPARE_2 | int | |
| SR_AAR_SPARE_3 | int | |
| SR_AAR_SPARE_4 | char(10) | |
| SR_AAR_SPARE_5 | char(10) | |
| SR_AAR_SPARE_6 | char(10) | |
| SR_AAR_BOOLEAN_1 | bit | |
| SR_AAR_BOOLEAN_2 | bit | |
| SR_AAR_BOOLEAN_3 | bit | |
| SR_AAR_BOOLEAN_4 | bit | |
| SR_AAR_BOOLEAN_5 | bit | |
| SR_AAR_BOOLEAN_6 | bit | |
| SR_AAR_BOOLEAN_7 | bit | |
| SR_AAR_BOOLEAN_8 | bit | |
| STUDENT_2 | DEIB_STAT | tinyint |
| DEIB_STAT_DT | datetime | |
| DEIB_EXP_DT | datetime | |
| DEIB_COMMENT | char(75) | |
| DEIB_UPDT_DT | datetime | |
| DEIB_UPDT_ID | char(12) | |
| SYS_TBL_39_CALENDAR | DAY2_REG_DT | datetime |
Fields moving from SF_Evaluation to SF_Evaluation1
- INST_SAI_BLK
- JACKET_FLG
- LIV_ACCOMDATN