Overview of SDR‎ > ‎


On-Demand Data is a reporting tool that will generate data files containing information about specific populations of students.  The output of ODD is always in the form of comma-separated value files which can easily be manipulated through Microsoft Excel, Access, or Word. 

The definition of each population and the fields contained in a particular data set are stored in tables in the Student Data Repository.  The data generated also comes from tables in the SDR. 

The basic components of an ODD dataset:

  • population, consisting a base view and any number of additional criteria.
    • The criteria are functions that must return true for a particular student
    • Criteria may require user input at run-time.
  • output, consisting of any number of field lists that will be included in the output. 

Generally, new ODD datasets are created in response to someone filling out the  Data Request Form. End users may then generate a data set from Campus Solutions by submitting by an On Demand Data Request.  ODD setup is the process performed by Institutional Research staff to make a particular ODD data set available to be requested.  Many data sets have been already been defined, each returning a variety of fields shown in this data dictionary.  A list of jobs that are recurring or have been run recently can be seen at: Recurring Jobs.

Most ODD data sets contain data that was accurate at the beginning of the day.  With the exception of a few special circumstances, the data stored in the SDR and returned by ODD does not reflect changes that have been made to the data during the current day.  

ODD keeps a history of all requests for data and the students selected for each dataset.  Many ODD jobs can be submitted with a special "new only" parameter.  Setting this field to N will return all members of the dataset.  If this value is set to Y, only students who were not members of previous results for this dataset will be included.  This is an easy way to select students who now qualify as members of a population but didn't the last time the dataset was generated.  (Example: admitted students.)

More information about ODD intended for gatekeepers and analysts can be found at ODD design and details.

There are a number of advantages to using ODD instead PSQuery and other reporting tools.  A few versions of ODD have been created to address different needs.