University of Wisconsin–Milwaukee


Student Data Warehouse Changes and Enhancements



Recent changes


Table/View Description of Change Date Implemented
VU_ADM_APPL_PROG_DIM, VU_ADM_APPL_PLAN_DIM Filter has been changed to include multiple terms for an application
Two columns have been added to VU_ADM_APPL_PROG_DIM:
      APPP_EFFDT
      APPP_EFFSEQ
Five columns have been added to VU_ADM_APPL_PLAN_DIM:
      APPLN_ADMIT_TERM
      APPLN_ADMIT_TERM_SDESC
      APPLN_ADMIT_TERM_LDESC
      APPLN_EFFDT
      APPLN_EFFSEQ
3/20/2014
VU_UWM_REGISTERED_STUDENT_DEMO Include more values to determine URSD_D_DISSERTATOR_IND
see the Data Dictionary for complete list
03/11/2014
VU_CC_RESIDENCY_DIM Six columns have been added:
FIN_AID_FED_RESIDENCY_EXCPT
FIN_AID_FED_RESIDENCY_EXCPT_SDESC
FIN_AID_FED_RESIDENCY_EXCPT_LDESC
FIN_AID_STATE_RESIDENCY_EXCPT
FIN_AID_STATE_RESIDENCY_EXCPT_SDESC
FIN_AID_STATE_RESIDENCY_EXCPT_LDESC
2/24/2014
VU_DPT_IR_STATMST_PLANS
VU_DPT_IR_STATMST_SUBPLANS
New views added 01/24/2014
VU_APPSTAT Change derivation of Appstat columns D_Admit_Group and D_Degree_Level to account for FLEX students 12/20/2013
VU_CC_VISA_PERMIT_DIM One column has been added:
VISA_EFFDT
11/27/2013
VU_UWM_TERM_PLAN Change derivation: select where the maximum effective date for the key is less than or equal to the maximum Ust_Census_Dt. Also select students if they are eligible to enroll or if their eligible to enroll flag is 'N' and their withdraw code is 'WDR' 11/22/2013
VU_REC_TEXT_BOOK_DTL New view added 11/7/2013
VU_FA_ISIR_DATA_DIM Two columns have been added:
ISIR_STUDENT_CHILDREN
ISIR_STUDENT_IWD_STD_EMAIL
10/17/2013
VU_FA_SFA_SAP_STDNT Two columns have been added:
FSSS_SFA_SAP_CUMERN_PCT
FSSS_SFA_SAP_CURERN_PCT
09/24/2013
VU_PREG_AM_DIR_DATA Change derivation of PDD_UWM_EPANTHER_EMAIL: will only contain CAMP email types and dir data will have ALL camp emails. 9/6/2013
VU_REC_CLASS_DIM
VU_REC_CLASS_MEETING_INSTRUCT_DIM
VU_UWM_FACILITY_TBL
Room characteristic columns have been added 8/23/2013
VU_UWM_EARLY_WARNING*,
VU_UWM_EW_DAILY*
Stop loading EW as it now is in MAPWORKS; last saved term 2132 8/1/2013
VU_CC_RELATIONSHIPS_DIM 43 columns from PS_RELATIONSHIPS have been added 07/17/2013
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: 3/25/2014