Business Intelligence

UDEW Data Dictionaries

Note: All data dictionaries are works in progress. Check back periodically for updated versions.  If you have any questions, please contact ir-udew-it@UDel.Edu

The Student Enrollment Data Mart and UD Financial Data Mart have the data dictionaries included.  You can view the source and the definitions by hovering over the data item or query subject.

Dictionary Name Version
UDSIS Official Extract

  • Contains a snapshot of enrollment data
  • Unduplicated count (i.e., student will only be counted once; primary program/plan will be selected as program of study)
  • The snapshot is only taken once during the semester. Spring and Fall semesters, the snapshot is taken after drop/add period on the 10th day of classes. Winter and Summer sessions, the snapshot is taken at the end of the semester.
  • Used to report enrollment data for UD’s Facts and Figures
  • Only contains snapshots from Winter 2007 onwards
As of 9/02/2011
UDSIS Term Extract

  • Contains a daily snapshot of enrollment data for the current semester
  • Unduplicated count (i.e., student will only be counted once; primary program/plan will be selected as program of study)
  • Data is always 1 day old
As of 9/02/2011
Admissions Data Mart

  • Admissions data is always 1 day old
  • Only contains UDSIS admissions data from Fall 2006 onwards
  • Contains Graduate and Undergraduate admissions data
As of 9/25/2008
Admissions Snapshot

  • Admissions Snapshot is always 1 day old
  • Contains a daily snapshot ONLY OF Undergrad admissions data
  • Only contains UDSIS admissions data from Fall 2012 onwards
As of 7/3/2013
Degree Data Mart

  • Degree data is always 1 day old
  • Contains all degrees conferred from Fall 1971 onwards
As of 9/25/2008
SOC Data Mart

  • Data is always 1 day old
  • Contains class schedules from Fall 1971 onwards
As of 7/3/2013
UDSIS Training Extract

  • A scrubbed version (sensitive data removed) of the Student UDSIS Official Extract used for training purposes
As of 5/14/2009