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:
- Dropping high-cardinality columns, such as
student_note - Exploding dates into their parts to enable queries such as Find users who mostly log in on Tuesdays in September
- Flattening data structures
- Adding external identifiers so data can be linked to other sources
- Calculating new lookup tables based on the existing data. For example a view that links all isbns with the item it appears on.
Diagram
There is is a (rather large!!) entity relationship diagram available.
Details
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.