Student Data Warehouse Changes and Enhancements

Recent Changes

Table/ViewDescription of ChangeDate Implemented
VU_ADM_APPL_PROG_DIM, VU_ADM_APPL_PLAN_DIMFilter 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_DEMOInclude more values to determine URSD_D_DISSERTATOR_IND
see the Data Dictionary for complete list
3/11/2014
VU_CC_RESIDENCY_DIMSix 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 added01/24/2014
VU_APPSTATChange derivation of Appstat columns D_Admit_Group and D_Degree_Level to account for FLEX students 12/20/2013
VU_CC_VISA_PERMIT_DIMOne column has been added:
VISA_EFFDT
11/27/2013
VU_UWM_TERM_PLANChange 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_DTLNew view added11/7/2013
VU_FA_ISIR_DATA_DIMTwo columns have been added:
ISIR_STUDENT_CHILDREN
ISIR_STUDENT_IWD_STD_EMAIL
10/17/2013
VU_FA_SFA_SAP_STDNTTwo columns have been added:
FSSS_SFA_SAP_CUMERN_PCT
FSSS_SFA_SAP_CURERN_PCT
9/24/2013
VU_PREG_AM_DIR_DATAChange 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 added8/23/2013
VU_UWM_EARLY_WARNING*,
VU_UWM_EW_DAILY*
Stop loading EW as it now is in MAPWORKS; last saved term 21328/1/2013
VU_CC_RELATIONSHIPS_DIM43 columns from PS_RELATIONSHIPS have been added7/17/2013
VU_FA_SFA_SAP_STDNTNew view added5/23/2013
VU_FA_ISIR_DATA_DIM89 columns from PS_ISIR_STUDENT have been added5/09/2013
VU_FA_VAR_DATA_FINA
VU_FA_VAR_DATA_FINT
VU_FA_VAR_DATA_LOAN
New views added4/24/2013
VU_REC_TRNS_CRSE
VU_REC_TRNS_OTHR
VU_REC_TRNS_TEST
Source filter changed to mirror other REC loads4/05/2013
VU_REC_TRNSFR_CRSE_EQUIVALENCYNew view added4/02/2013
VU_REC_STUDENT_TERM_FACT
VU_REC_STUDENT_TERM_FACT_X
One column has been added:
STFACT_UNT_PASSD_PRGRSS
3/20/2013
VU_REC_ACAD_STRUCTURE_DIM_NEDNew view added3/08/2013
VU_UWM_FACILITY_TBLNew view added3/07/2013
VU_REC_CLASS_MEETING_INSTRUCTTwo columns have been added:
CLASSM_START_DT
CLASSM_END_DT
3/01/2013
VU_REC_TRNS_CRSERTC_UNT_TRNSFR_SUM column added2/01/2013
VU_APPSTATBlank out first-gen indicator for 12/17/2012 and earlier1/25/2013
VU_REC_CLASS_ASSOC_DIMThirteen 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_PRMSNNew view added12/13/2012
VU_REC_STDNT_CONS_STATNew view added12/06/2012
VU_PREG_UWM_UDDSPUU_UWM_EMAIL_ADDR column added11/28/2012
VU_APPSTATModify first-gen indicator coding to account for multiple recruitment categories11/16/2012
VU_CC_ADDRESSES_LAST_KNOWNinclude 'CAMP' addresses11/06/2012
VU_REC_ACAD_DEGREE_HONORS_DIMThree columns have been added:
ADEGH_HONORS_CODE_SDESC
ADEGH_HONORS_CODE_LDESC
ADEGH_HONORS_CODE_DESCRFORMAL
10/05/2012
VU_STA_CLASSCLA_EXTRACT_DT column added10/03/2012
VU_UWM_TERM_PLANNine 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
8/23/2012
VU_REC_ENROLL_REQUEST_DIMTwo columns have been added:
ENREQ_ENRL_REQ_PROC_ST
ENREQ_ENRL_REQ_SOURCE
8/21/2012
VU_REC_ENROLL_MESSAGESNew view added8/21/2012
VU_APPSTATChange derivation process for D_APPLICATION_STATUS to handle changes in processing by CIE as compared to the undergrad office8/15/2012
VU_STA_CLASSFour columns removed7/18/2012
VU_STA_STUDENTFifty-four columns removed7/18/2012
VU_CC_ADDRESSES_LAST_KNOWNNew view added7/10/2012
VU_REC_STDNT_BLOCK_DTL New view added7/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
7/02/2012
VU_APPSTATFix D_Admit_Group6/12/2012
VU_STA_STUDENTBlank Out Stu_D_Athlete_Flag6/08/2012
VU_CC_SERVICE_INDICATOR_DIMTwo columns have been added:
SRVC_SCC_SI_END_TERM
SRVC_SCC_SI_END_DT
6/07/2012
VU_UWM_ACAD_CALSES_TBLNew view added5/18/2012
VU_CC_ADDRESSES_DIMFive columns have been removed:
ADDR_EMAIL_ADDR
ADDR_PREF_EMAIL_FLAG
ADDR_PHONE_COUNTRY_CD
ADDR_PHONE_NUMBER
ADDR_PHONE_EXTENSION
5/09/2012
VU_UWM_STDNT_GROUPS_NED_SNAPNew view added4/26/2012
VU_UWM_STDNT_GROUPS_DIM_NEDTwo columns have been added:
STDGRN_EFF_STATUS
STDGRN_COMMENTS
ALL rows of the PAWS source table are now selected. Previously, only "active" rows were
4/25/2012
VU_UWM_REGISTERED_STUDENT_DEMOChange term-specific columns to cumulative.
Add:
USRD_TERM_TRANSFER_CREDITS
USRD_TERM_TEST_CREDITS
USRD_TERM_OTHER_CREDITS
4/12/2012
VU_PREG_UWM_HR_APPT_PRIORITYPUA_HR_FUNDING_RESP column has been removed3/09/2012
VU_PREG_UWM_AM_DIR_DATAPDD_UW_HS_FUNDING_RESP column has been removed3/09/2012
VariousModified mappings to account for columns deleted in PAWS bundle CS 9 Bundle 242/24/2012
VU_ADM_EXTRACUR_ACTIVITY_DIM changed to
VU_CC_EXTRACUR_ACTIVITY_DIM
EXT_END_DT and other source columns have been added2/22/2012