What are Census Tables?

To facilitate the development of data marts specific to a given subject area or reporting need, IAP has developed a number of "census" tables in the UNLV Data Warehouse. A census table contains data from one or more snapshot tables, effective as of a given census date, and consolidated to simplify querying and reporting.  Census dates may be official or unofficial.

Typically, a census-based data mart will provide access to data housed in more than one census table, each relating to one another, around a particular subject area. For example, the enrollment census is comprised of tables that house records about enrolled students, their academic careers and plans, and their enrollments.


Census%20Process%20Schematic