|business concept diagram||The Cognos business concept diagrams are subdivided into logical groups of ODS reporting views; groups of these are called business views. (Business views are not database objects like Oracle views.) Each business view contains ODS reporting views, one of which is the primary reporting view.|
|composite view||Views within Banner that contain the information that will be extracted into the ODS. The extract transfer load (ETL) process pulls information from the composite views and loads it into the composite tables of the ODS. In some cases, functions are used to calculate new data that will be created from source data and loaded into the ODS.|
|freeze table||Subsets of columns for tables that are loaded according to predefined “events” (e.g., snapshots of enrollment data at the beginning and end of terms and snapshots of admission applications received by week).|
|hierarchical display rule table||
Display rules allow us to customize how data stored in the ODS is displayed in reporting views. For hierarchical display rules tables, display rules determine the order in which a particular type of data should be retrieved.
|list of values (LOV) table||LOV tables enable users to create pull-down lists of values and their descriptions in their reporting applications. These values are extracted from validation tables in the source system.|
|positional slot table||
Used to denormalize repeating concepts from multiple rows to multiple columns. Slot tables store data values for a specific code related to a base table. For example, the TEST_SCORES_SLOT table in the ODS stores all valid test score values that were loaded from the source system to the ODS. The system pulls data from the composite tables according to the defined system codes. Since the system only needs to check for specific code values as needed, using slot tables optimizes the speed of user queries.
|primary reporting view||A primary reporting view is the view to which all other views in the business view are joined. It contains the main facts that will be in queries against the business view.|
|Purdue modified information||Any references to composite views in the metadata that end with “_PU” indicates it is a Purdue enhancement. Names of modified reporting views will not be renamed in order to assure backward compatibility to existing queries and reports written against them prior to any enhancement. Additional fields could be added to reporting views at any time and will be announced via Cognos student user groups.|
|reporting view||Data from each ODS composite table is presented in one or more reporting views. These are the views used to create reports within the ODS. Users will use Cognos as their report writing tool to access these views and build reports.|
|Social Security number||Referred to as “Tax IDs” in Banner, Social Security numbers are restricted and accessible only to those with defined business needs. Purdue University identification numbers (PUIDs) should be used as unique identifiers for all individuals.|