Application Data Overview

Advanced MIS contains all list, item, user and hierarchy data in your Talis Aspire tenancy. You will see information from Reading Lists, Copyright Clearance and Talis Elevate.

The data is a replica - not live data - and is pushed to the data warehouse and reformatted to optimise for management reporting. Data can either be automatically or manually pushed, see the Pushing Content topic for more information.

Part of the refactoring for management reporting involves:


There is is a (rather large!!) entity relationship diagram available.


Refer to the data dictionary topics below to discover how to use the different entities in the warehouse:

Entity Description Fact Table Name
Lists Reading list data f_rl_lists
Items Reading list item data f_rl_items
Users Reading list user records f_rl_users
Hierarchy Hierarchy records f_rl_hierarchy
Hierarchy Descendants Calculated view of all descendants of a given node f_rl_hierarchy-descendants
Hierarchy Parents Linking table from a given node to its parents f_rl_hierarchy-parents
ISBN Link Linking table from an isbn to all items it appears on f_rl_lists
Rollovers Reading list rollover data f_rl_list_rollover_relationships
Digitisations Copyright cleared request data f_dc_requests
Elevate Users Talis Elevate users f_elevate_users
Elevate Modules Talis Elevate modules f_elevate_modules
Elevate Resources Talis Elevate resources f_elevate_resources
Elevate Module Resource Links Linking table between Talis Elevate modules and resources f_elevate_module_resource_links

WARNING: The data dictionary is subject to change. For that reason always refer to column names directly in your SQL statements, not column positions.