DARTS : Recommended Tables for Reporting in CS

As experienced Query writers in our data know, not all tables are created equal.  For the best, most accurate results, using tables that begin with 'UM_' is your best bet for a place to start.  These tables are maintained and updated regularly, and include many fields from commonly used core tables. If there are fields from a table that you regularly use and you cannot find them in one of the UM_ tables, please contact DARTS@maine.edu to discuss.

Tables here are listed in order of the frequency with which they are used.

• UM_STUD_EXTRACT - Student Reporting Extract

• UM_APPL_EXTRACT - Applicant Reporting Extract

• UM_STUD_EXT_VW - Student Reporting Extract

• UM_STUD_CENSUS - Student Reporting Extract Arch

• UM_D_STD_ENR_VW - Student Enrollment Table

• UM_D_APPL_PG_VW - Admission Applicant Program

• UM_NAMES_VW - Person Names Query View

• UM_FLAT_ADVISOR

• UM_FLAT_PRGPLAN

• UM_EXT_ORG_VW2
  
• UM_GRAD_APPL_VW
• UM_FERPA_VW
  
• UM_FIN_AID
• UM_GRAD_PROG_VW
  
• UM_SFA_VA_BENES
  
• UM_FLAT_CMPT_VW
  

• UM_STD_ENR_CENS
  

• UM_FGLEMPLOY_VW - Human Resources employee data flat file

• UM_DEGREES_COMP
  

• UM_EXT_ORG_N_VW
• UM_D_MIN_TERMS
  
• UM_IMMUN_COMPL
  
• UM_PROS_EXTRACT
• UM_ITYP_FA_VW - FA view of Item Types
  
• UM_ENRL_PIN
• UM_D_ADDRESS_VW
• UM_CLSS_SCH_FCL - Class Schedule and Facility Vw
• UM_STDNT_COHORT
• UM_AGGR_LOAN_VW
  
• UM_STUD_EXT_ARC - Student Reporting Extract Arch (used in 91 queries)
  
• UM_STUD_CENS_VW - Student Reporting Extract (used in 14 queries)