Database, tables and SQL queries

IDV_REPORT_INFO 

request_number

request_type

service_type

date_entered           

request_src

date_submitted         

request_title

article_title

publication_date

volume

issue

add_nums_letters

external_number

project_code

library_symbol

institution_name

patron_id

patron_type

patron_surname

patron_name

department

patron_pickup_location_desc

deliv_method

deliv_address

exception_code

pages

date_processed

delivery_date

supply_base

supply_copyright

supply_delivery

amount_base

amount_copyright

amount_delivery

amount_total

supplier_code_1

request_type_library

deliv_method_desc

pickup_location_desc

bib_title

publication_type

library_type

library_type_desc

library_cat_desc

stats_cat_lib_desc

department_library

department_desc

patron_type_desc

stats_cat_pat_desc

exception_type

exception_code_desc

country

supplier_cat_desc

stats_cat_sup1_desc