Data dictionary: Items

Entity
Items
Description
Reading list item data
Database location
public.f_rl_items

Columns

Column Name Datatype Description Example
status VARCHAR(255) Status of the list this item appears on. Permitted values Draft, Published, Published with Unpublished Changes Draft
time_period VARCHAR(4096) Textual name of time period of the list this item appears on Autumn Term 2018
list_url VARCHAR(255) Canonical URL of the reading list  
item_url VARCHAR(255) Canonical URL of the reading list item  
list_guid VARCHAR(4096) Globally Unique ID for the reading list DE53F159-8AE9-F8D4-6518-263DED7D56E9
item_guid VARCHAR(4096) Globally Unique ID for the reading list item. This should be used for joining to other data 478A70D8-C627-91EC-D681-FFE617FABDD9
title VARCHAR(255) Title of the item A short history
chapter_article_title VARCHAR(255) Title of the article or chapter In the beginning
authors VARCHAR(4096) Authors of the work Fred R. L. Bloggs
type VARCHAR(255) Type of the resource, limited to the current resource types supported by Talis Aspire Book
isbn10 VARCHAR(255) The ISBN 10 012345678X
isbn13 VARCHAR(255) The ISBN 13 9780123456789
issn VARCHAR(255) An ISSN 1234-5678
eissn VARCHAR(255) An eISSN 1234-5678
lcn VARCHAR(255) The local control number. This can be linked to records in library system reports b1234567
doi VARCHAR(255) The Digital Object Identifier 10.123/456/adoi_link
date_of_publication VARCHAR(255) The date of publication (this is a representation of the date as found in original MARC record) c2009
issue VARCHAR(255) The Issue Number 22
volume VARCHAR(255) The Volume 1
edition VARCHAR(255) The Edition Rev. and exp. [ed.]
start_page VARCHAR(255) The start page 23
end_page VARCHAR(255) The end page 45
importance VARCHAR(255) Importance level of the item, limited to the values configured in your tenancy Suggested for student purchase
publisher VARCHAR(4096) Publisher of the resource SAGE
format VARCHAR(255) Format of the resource electronic resource
web_address VARCHAR(4096) Web Address of the resource. Semicolon + space '; ' separated if there are multiple web addresses. http://...; https://
digitisation_id VARCHAR(255) ID of the digitisation request in Talis Aspire Digitised Content that this item is linked to 22
digitisation_status VARCHAR(32) Status of the digitisation, e.g. LIVE, EXPIRED LIVE
has_container VARCHAR(255) The parent container GUID of the item - could be the list itself, or a section within the list. Prefixed with the type tenantLists or tenantSections to mark out type tenantSections:9CBA2921-17BD-0A62-7942-421DCD8E79E6
date_added TIMESTAMP Date the item was added to the list 2016-01-12 00:00:00.0
library_note VARCHAR(4096) Textual information about the item only visible to staff Example library note
student_note VARCHAR(4096) Textual information about the item visible to all users Example student note
year_added INTEGER Year of when the list was created 2018
month_added INTEGER Month of when the list was created, values 1-12 12
week_added INTEGER ISO 8601 week of when the list was created, note Monday is the start of the ISO 8601 week, values 1-53 52
dow_added INTEGER Day of week of when the list was created, values 0-6, Sunday is 0 5
primary_web_address VARCHAR(4096) This will be the web address field of the main part of the bookmark. Often the one for the Article or Chapter. Semicolon + space ; separated if there are multiple web addresses. http://...; https://
secondary_web_address VARCHAR(4096) This will be the web address field in the secondary part of the bookmark. Often the one for the Book or Journal. Semicolon + space ; separated if there are multiple web addresses. http://...; https://
online_resource_web_address VARCHAR(4096) If the Online Resource Source for the bookmark is ‘Web Address’ then the user selected web address will be the single URL in this field. Will be blank if Online Resource Source is set to anything else  
online_resource_source VARCHAR(4096) Will show whether the DOI, Open URL or Web Address is chosen as the source for the view online button DOI, Open URL, Web Address
has_upload_file VARCHAR(3) Whether or not a Talis Engage file is attached to the list item Yes
list_resource_content_file_type VARCHAR(10) The file type of the Talis Engage file pdf

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