Student Data Warehouse Changes and Enhancements
Recent changes
| Table/View | Description of Change | Date Implemented |
| VU_FA_SFA_SAP_STDNT | New view added | 05/23/2013 |
| VU_FA_ISIR_DATA_DIM | 89 columns from PS_ISIR_STUDENT have been added | 05/09/2013 |
| VU_FA_VAR_DATA_FINA VU_FA_VAR_DATA_FINT VU_FA_VAR_DATA_LOAN |
New views added | 04/24/2013 |
| VU_REC_TRNS_CRSE VU_REC_TRNS_OTHR VU_REC_TRNS_TEST |
Source filter changed to mirror other REC loads | 04/05/2013 |
| VU_REC_TRNSFR_CRSE_EQUIVALENCY | New view added | 04/02/2013 |
| VU_REC_STUDENT_TERM_FACT VU_REC_STUDENT_TERM_FACT_X |
One column has been added: STFACT_UNT_PASSD_PRGRSS |
03/20/2013 |
| VU_REC_ACAD_STRUCTURE_DIM_NED | New view added | 03/08/2013 |
| VU_UWM_FACILITY_TBL | New view added | 03/07/2013 |
| VU_REC_CLASS_MEETING_INSTRUCT | Two columns have been added: CLASSM_START_DT CLASSM_END_DT |
03/01/2013 |
| VU_REC_TRNS_CRSE | RTC_UNT_TRNSFR_SUM column added | 02/01/2013 |
| VU_APPSTAT | Blank out first-gen indicator for 12/17/2012 and earlier | 01/25/2013 |
| CMA Module | Retired | 01/23/2013 |
| VU_REC_CLASS_ASSOC_DIM | Thirteen columns have been added: CASSC_UNITS_ACAD_PROG CASSC_UNITS_FINAID_PROG CASSC_GRADING_BASIS CASSC_GRADE_ROSTER_PRINT CASSC_RQRMNT_GROUP CASSC_USE_CATLG_RQS CASSC_RQMNT_DESIGNTN CASSC_CRSE_COUNT CASSC_INSTRUCTOR_EDIT CASSC_USE_BLIND_GRADING CASSC_SEL_GROUP CASSC_COMPONENT_PRIMARY CASSC_UPDATE_STDNT_ENRL |
1/10/2013 |
| VU_REC_CLASS_PRMSN | New view added | 12/13/2012 |
| VU_REC_STDNT_CONS_STAT | New view added | 12/06/2012 |
| VU_PREG_UWM_UDDS | PUU_UWM_EMAIL_ADDR column added | 11/28/2012 |
| VU_APPSTAT | Modify first-gen indicator coding to account for multiple recruitment categories | 11/16/2012 |
| VU_CC_ADDRESSES_LAST_KNOWN | include 'CAMP' addresses | 11/06/2012 |
| VU_REC_ACAD_DEGREE_HONORS_DIM | Three columns have been added: ADEGH_HONORS_CODE_SDESC ADEGH_HONORS_CODE_LDESC ADEGH_HONORS_CODE_DESCRFORMAL |
10/05/2012 |
| VU_STA_CLASS | CLA_EXTRACT_DT column added |
10/03/2012 |
| VU_UWM_TERM_PLAN | Nine columns have been added: UTP_ACAD_PROG_SDESC UTP_ACAD_PROG_LDESC UTP_ACAD_PLAN_SDESC UTP_ACAD_PLAN_LDESC UTP_ACAD_SUB_PLAN_SDESC UTP_ACAD_SUB_PLAN_LDESC UTP_ACAD_GROUP UTP_ACAD_GROUP_SDESC UTP_ACAD_GROUP_LDESC |
08/23/2012 |
| VU_REC_ENROLL_REQUEST_DIM | Two columns have been added: ENREQ_ENRL_REQ_PROC_ST ENREQ_ENRL_REQ_SOURCE |
08/21/2012 |
| VU_REC_ENROLL_MESSAGES | New view added | 08/21/2012 |
| VU_APPSTAT | Change derivation process for D_APPLICATION_STATUS to handle changes in processing by CIE as compared to the undergrad office | 08/15/2012 |
| VU_STA_CLASS | Four columns removed | 07/18/2012 |
| VU_STA_STUDENT | Fifty-four columns removed | 07/18/2012 |
| VU_CC_ADDRESSES_LAST_KNOWN | New view added | 07/10/2012 |
| VU_REC_STDNT_BLOCK_DTL | New view added | 07/10/2012 |
| VU_REC_ENROLLMENT_FACT_PY... VU_REC_STUDENT_TERM_DIM_PY... VU_SF_ITEM_FACT_DIM_PY... VU_SF_ITEM_LINE_FACT_PY... VU_SF_ITEM_XREF_DIM_PY... VU_SF_PAYMENT_DIM_PY... VU_SF_UW_GL_INT_PY... |
In V8HIST - Created new year-specific views for last year's _PY Refreshed the end-of-year views Deleted the _08 views |
07/02/2012 |
| VU_APPSTAT | Fix D_Admit_Group | 06/12/2012 |
| VU_STA_STUDENT | Blank Out Stu_D_Athlete_Flag | 06/08/2012 |
| VU_CC_SERVICE_INDICATOR_DIM | Two columns have been added: SRVC_SCC_SI_END_TERM SRVC_SCC_SI_END_DT |
06/07/2012 |
| VU_UWM_ACAD_CALSES_TBL | New view added | 05/18/2012 |
| VU_CC_ADDRESSES_DIM | Five columns have been removed: ADDR_EMAIL_ADDR ADDR_PREF_EMAIL_FLAG ADDR_PHONE_COUNTRY_CD ADDR_PHONE_NUMBER ADDR_PHONE_EXTENSION |
05/09/2012 |
| VU_UWM_STDNT_GROUPS_NED_SNAP | New view added | 04/26/2012 |
| VU_UWM_STDNT_GROUPS_DIM_NED | Two columns have been added: STDGRN_EFF_STATUS STDGRN_COMMENTS ALL rows of the PAWS source table are now selected. Previously, only "active" rows were |
04/25/2012 |
| VU_UWM_REGISTERED_STUDENT_DEMO | Change term-specific columns to cumulative. Add: USRD_TERM_TRANSFER_CREDITS USRD_TERM_TEST_CREDITS USRD_TERM_OTHER_CREDITS |
04/12/2012 |
| VU_PREG_UWM_HR_APPT_PRIORITY | PUA_HR_FUNDING_RESP column has been removed | 03/09/2012 |
| VU_PREG_UWM_AM_DIR_DATA | PDD_UW_HS_FUNDING_RESP column has been removed | 03/09/2012 |
| Various | Modified mappings to account for columns deleted in PAWS bundle CS 9 Bundle 24 | 02/24/2012 |
| VU_ADM_EXTRACUR_ACTIVITY_DIM changed to VU_CC_EXTRACUR_ACTIVITY_DIM |
EXT_END_DT and other source columns have been added | 02/22/2012 |
Last revision date: 5/23/2013