UWSDBDataStore Reorg on July 20, 2024
February 29, 2024
UWSDBDataStore Reorg on July 20, 2024
The student database (SDB) will go through a reorganization on July 20, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on July 22, 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 – 7.18.24
Columns to be Added
| Table | Column | DataType |
| ADDRESSES | SF_COUNTRY | char(2) |
| BUDGET_RESOURCES | BR_FOOD | int |
| BR_HOUSING | int | |
| BR_EXTRA_FOOD | int | |
| BR_EXTRA_HOUSING | int | |
| ISIR_TRANSACTIONS | ISIR_CPS_SAI_BLK | bit |
| ISIR_CPS_P_SAI_BLK | bit | |
| ISIR_INAS_SAI | int | |
| ISIR_INAS_SAI_BLK | bit | |
| NSLDS_DATA_PELL_DATA | N_PELL_SAI | int |
| SF_EVALUATION | S_MIDDLE_NAME | char(15) |
| S_SUFFIX | char(10) | |
| STD_EITC_RCVD | char(1) | |
| P1_EITC_RCVD | char(1) | |
| USER_PROV_DATA | char(5) | |
| P_INCOME_ADDITIONS | decimal(11,0) | |
| S_INCOME_ADDITIONS | decimal(11,0) | |
| INSTITUTIONAL_SAI | int | |
| INST_SAI_BLK | bit | |
| IP_S_ADJ_BUS_FARM | decimal(15,0) | |
| IP_P_ADJ_BUS_FARM | decimal(15,0) | |
| SF_EVALUATION1 | PJ_STD_FAM_SIZE | char(2) |
| PJ_P1_FAM_SIZE | char(2) | |
| SR_MAJOR_CODE | MAJOR_TYPES_20 | bit |
| STUDENT_1 | DISAB_ARCHIVE_FLG | bit |
| S1_BOOLEAN_09 | bit | |
| S1_BOOLEAN_10 | bit | |
| S1_BOOLEAN_11 | bit | |
| S1_BOOLEAN_12 | bit | |
| S1_BOOLEAN_13 | bit | |
| S1_BOOLEAN_14 | bit | |
| S1_BOOLEAN_15 | bit | |
| S1_BOOLEAN_16 | bit | |
| DISAB_ARC_UPDT_DT | datetime | |
| DISAB_ARC_UPDT_ID | char(12) | |
| S1_SPARE_F | char(64) | |
| S1_SPARE_M | char(64) | |
| S1_SPARE_L | char(64) | |
| S1_SPARE_S | char(10) |
New Table
| Table | Column | Key | DataType |
| SR_ADM_RESULTS | MY_AA | Y | char(12) |
| SR_AAR_APPL_NAME | char(45) | ||
| SR_AAR_APPL_DOB | datetime | ||
| SR_AAR_SYSKEY | int | ||
| SR_AAR_EXACTID | char(10) | ||
| SR_AAR_CAMPUS | tinyint | ||
| SR_AAR_FORM_TYPE | char(8) | ||
| SR_AAR_APPL_TYPE | char(1) | ||
| SR_AAR_ENTRY_TERM | char(6) | ||
| SR_AAR_STATUS | char(1) | ||
| SR_AAR_MESSAGE | char(50) | ||
| SR_AAR_POSTED_DT | datetime |
Columns to be Removed
| Table | Column | Notes |
| SR_ADM_APPL | UW_PROMISE | No data |
| SR_MAJOR_CODE | MAJOR_EXCHANGE | Not in use, all records ‘0’ |
| STUDENT_1 | S1_BOOLEAN_07 | Not in use, being replaced by Disab_Archive_Flg |
Datatype Changes
| Table | Column | DataType(new) | Data Type (old) |
| SA_WD_SUM_TRAN | WD_SUM_DB_AMOUNT | decimal(11,2) | decimal(9,2) |
| WD_SUM_CR_AMOUNT | decimal(11,2) | decimal(9,2) | |
| SF_EVALUATION | IP_PC | decimal(15,0) | int |
| IP_TI | decimal(15,0) | int | |
| IP_SATI | decimal(15,0) | int | |
| IP_ATI | decimal(15,0) | int | |
| SF_EVALUATION1 | PJ_STD_EXMPTS | tinyint | decimal(15,0) |
| PJ_SP_EXMPTS | tinyint | decimal(15,0) | |
| PJ_P1_EXMPTS | tinyint | decimal(15,0) | |
| PJ_P2_EXMPTS | tinyint | decimal(15,0) |
Field Moves – from SF_Evaluation to SF_Evaluation1
-
- ON_TIME_FLG
- P_ACCEPT_EXCL
- P_INCOME_BASE_USD
- PREFERRED_AID
- PROF_JUDGE_TYPE
- QA_SELECTED
- QA_STATUS
- QA_TRAN_NO
- QA_DT_COMPLETE
- QA_PAID_TRAN_NO
- REV_REQ_DISPOS