University of Illinois System

Description

Contains the online web application information (including un-submitted and submitted web applications). This information is NOT transformed in anyway, thus the data is the “raw” data stored in the Banner Web Application tables which is ONLY updated in the Data Warehouse once a week on Sundays. This information is SELF reported by the applicant, therefore it should not be used for official UI reporting purposes. Although applicants are to only submit one application per term, they may have started and/or saved several iterations of the same application or multiple applications.

Because of the nature of this data (not complete or partial), limit conditions in the report so you will receive data results. Once you understand what you are seeing in the reports, you can add additional conditions to limit the data you are receiving.

NOTE: The Student Web Application Universe is only available to the Office of Admissions for each campus because of the data complexity involved.

Commonly used objects: Term Code, Applicant Name, Applicant Question/Answer

Types of business questions you can answer using this universe:

  • What curricula is the applicant interested in?
  • What contact and address information was supplied by the applicant?

How far back does the data exist in the Data Warehouse? Fall 2004 to present.

How often is the data updated? Weekly on Sundays.

Universe Guides

Find out how to use the Web Applications universe to create custom reports: