Data dictionary: Digitisations

Copyright cleared digitisation request data
Database location


Column Name Datatype Description Example
request_id INTEGER Request identifier, should be used for joining to other data 2
request_date TIMESTAMP Date the request was made 2017-08-24 00:00:00
course_code VARCHAR(128) Course code the request was made for LAW101
course_title VARCHAR(255) Course title the request was made for Intro to Law
start_date TIMESTAMP When the course starts 2017-08-24 00:00:00
end_date TIMESTAMP When the course ends 2017-11-14 00:00:00
student_numbers INTEGER Amount of students who should have access to the digitisation 51
isnx VARCHAR(16) Either the ISBN, or ISSN of the resource 0021-9460
publisher VARCHAR(255) Publisher of the resource SAGE
original_source VARCHAR(128) The source of the original that was digitised BL_FEE_PAY
copy_source VARCHAR(128)    
status VARCHAR(64) Request status LIVE
rolled_over_from INTEGER If this request was created as part of a roll over, the identifier of the original request 1
rolled_over_to INTEGER If this request was itself rolled over, the identifier of the newly created rolled over request 3
date_copied TIMESTAMP Date that the copy was added to the request 2017-08-24 00:00:00
date_released TIMESTAMP Course start date or the date the request was made available to students, if after the course start date 2017-08-24 00:00:00
original_format VARCHAR(64) Format of the original item, permitted values print, digital print
requester_name VARCHAR(255) Name of the person making the request  
requester_email VARCHAR(255) Email of the person making the request 52
rl_item_url VARCHAR(255) If the item is linked to a reading list item, the canonical URL of that item  
item_guid VARCHAR(255) The guid of the reading list item, to be used for joining data 478A70D8-C627-91EC-D681-FFE617FABDD9

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