Student Data Warehouse Hist View List

Most of these views are refreshed on the last Saturday of the month. Views with an ‘_PY’ or ‘_PY’ and 2 digit year at the end are created once at the end of the fiscal year.

ViewNotes
VU_REC_ACAD_DEGREE_DIM
VU_REC_ACAD_DEGREE_HONORS_DIM
VU_REC_ACAD_DEGREE_PLAN_DIM
VU_REC_ACAD_STRUCTURE_DIM
VU_REC_CLASS_ASSOC_DIM
VU_REC_CLASS_ATTRIBUTES_DIM
VU_REC_CLASS_DIM
VU_REC_CLASS_MEETING_INSTRUCT
VU_REC_CLASS_NOTES_DIM
VU_REC_CLASS_PRMSN
VU_REC_CRSE_ATTRIBUTES_DIM
VU_REC_CRSE_CATALOG_DIM
VU_REC_CRSE_COMPONENT_DIM
VU_REC_CRSE_OFFER_DIM
VU_REC_CRSE_TOPICS_DIM
VU_REC_ENROLLMENT_FACT
VU_REC_ENROLLMENT_FACT_PY
VU_REC_ENROLLMENT_FACT_PY_09
VU_REC_ENROLLMENT_FACT_PY_10
VU_REC_ENROLLMENT_FACT_PY_11
VU_REC_ENROLLMENT_FACT_X
VU_REC_ENROLL_MESSAGES
VU_REC_ENROLL_REQUEST_DIM
VU_REC_GLOBAL_NOTE_DIM
VU_REC_INSTR_ADVISOR_DIM
VU_REC_INSTR_CRSE_DIM
VU_REC_MILESTONES_DIM
VU_REC_SSS_CRSE_PLNR
VU_REC_STDNT_ADVISOR_DIM
VU_REC_STDNT_CONS_STAT
VU_REC_STDNT_GROUPS_DIM
VU_REC_STUDENT_TERM_DIM
VU_REC_STUDENT_TERM_DIM_PY
VU_REC_STUDENT_TERM_DIM_PY_09
VU_REC_STUDENT_TERM_DIM_PY_10
VU_REC_STUDENT_TERM_DIM_PY_11
VU_REC_STUDENT_TERM_FACT
VU_REC_STUDENT_TERM_FACT_X
VU_REC_TRANSCRIPT_DIM
VU_REC_TRANSCRIPT_TEXT_DIM
VU_REC_TRNS_CRSE
VU_REC_TRNS_OTHR
VU_REC_TRNS_TEST
VU_SF_ITEM_FACT_DIM_PY
VU_SF_ITEM_FACT_DIM_PY_09
VU_SF_ITEM_FACT_DIM_PY_10
VU_SF_ITEM_FACT_DIM_PY_11
VU_SF_ITEM_LINE_FACT_PY
VU_SF_ITEM_LINE_FACT_PY_09
VU_SF_ITEM_LINE_FACT_PY_10
VU_SF_ITEM_LINE_FACT_PY_11
VU_SF_ITEM_XREF_DIM_PY
VU_SF_ITEM_XREF_DIM_PY_09
VU_SF_ITEM_XREF_DIM_PY_10
VU_SF_ITEM_XREF_DIM_PY_11
VU_SF_PAYMENT_DIM_PY
VU_SF_PAYMENT_DIM_PY_09
VU_SF_PAYMENT_DIM_PY_10
VU_SF_PAYMENT_DIM_PY_11
VU_SF_UW_GL_INT_09
VU_SF_UW_GL_INT_10
VU_SF_UW_GL_INT_PY
VU_SF_UW_GL_INT_PY_11
VU_UWM_AND_TRANSFER_COURSEWORK
VU_UWM_REGISTERED_STUDENT_DEMO