Field lengths

Find field names, lengths, and types for request and patron IDs in Relais ILL.

ID_REQUEST

Field name Length Type
request_numberĀ  12 nchar
sort_key 10 int
library_id 10 int
patron_id 20 nvarchar
request_type 3 nchar
multipart_request 1 nchar
service_type 1 nchar
ill_service_types 5 nchar
service_level 1 nchar
date_entered 23 datetime
request_src 1 nchar
remote_source_id 20 nvarchar
date_submitted 23 datetime
local_item_found 1 nchar
author 300 nvarchar
title 400 nvarchar
sub_title 200 nvarchar
article_author 120 nvarchar
article_title 500 nvarchar
publisher 250 nvarchar
publication_type 1 nchar
publication_year 4 nchar
publication_date 25 nvarchar
publication_place 200 nvarchar
series_title 300 nvarchar
volume 200 nvarchar
issue 200 nvarchar
edition 20 nvarchar
issn 9 nvarchar
issn_2 9 nvarchar
isbn 17 nvarchar
isbn_2 17 nvarchar
ismn 13 nvarchar
sponsor 162 nvarchar
physical_description 200 nvarchar
item_or_folder_num 50 nvarchar
accession_num 50 nvarchar
box_number 200 nvarchar
image_or_page_num 200 nvarchar
pages_requested 50 nvarchar
estimated_pages 10 int
bibliography_num 25 nvarchar
bibliography 1 nchar
system_number 25 nvarchar
system_source 1 nchar
add_nums_letters 50 nvarchar
info_source 200 nvarchar
call_number 200 nvarchar
notes1 1000 nvarchar
requester 50 nvarchar
mailbox 8 nvarchar
amicus_num 10 nvarchar
aviso_goid 9 nvarchar
aviso_oid 9 nvarchar
docline_num 12 nvarchar
docline_flag 1 nchar
medline_num 12 nvarchar
external_number 25 nvarchar
oclc_num 10 int
opac_num 12 nvarchar
refcatss_num 25 nvarchar
rlin_num 25 nvarchar
expiry_date 23 datetime
need_by_date 23 datetime
oclc_ifm 1 nchar
max_cost 6 decimal
project_code 25 nvarchar
agreed_terms_cond 2000 nvarchar
copyright_cmp 1 nchar
copyright_code 1 nchar
copyright_terms_cmp 1 nchar
copyright_purpose 2000 nvarchar
copyright_use_terms 1000 nvarchar
copyright_holder 100 nvarchar
copyright_status 50 nvarchar

ID_PATRON

Field name Length Type
patron_id 20 nvarchar
library_id 10 int
alt_patron_id 20 nvarchar
ils_patron_id 20 nvarchar
patron_active 1 nchar
patron_type 1 nchar
date_entered 23 datetime
last_modified 23 datetime
stats_cat_pat 1 nchar
patron_surname 50 nvarchar
patron_name 50 nvarchar
department 3 nchar
branch 3 nchar
prime_address1 70 nvarchar
prime_address2 70 nvarchar
prime_city 40 nvarchar
prime_prov_state 20 nvarchar
prime_country 35 nvarchar
prime_post_zipcode 15 nvarchar
language_code 3 nchar
contact_phone 25 nvarchar
contact_phone2 25 nvarchar
inter_patno 20 nvarchar
billing_type 1 nchar
billing_rate 1 nchar
bill_address1 70 nvarchar
bill_address2 70 nvarchar
bill_city 40 nvarchar
bill_prov_state 20 nvarchar
bill_country 35 nvarchar
bill_post_zipcode 15 nvarchar
bill_contact 50 nvarchar
bill_phone 25 nvarchar
bill_fax 25 nvarchar
patron_account 20 nvarchar
currency_code 3 nchar
credit_card 1 nchar
credit_card_name 80 nvarchar
credit_card_num 40 nvarchar
credit_card_exp 40 nvarchar
credit_card_code 24 nvarchar
user_login 20 nvarchar
user_password 20 nvarchar
max_cost 6 decimal
max_days 10 int
loan_code 1 nchar
file_format 1 nchar
deliv_method_copy 1 nchar
deliv_method_loan 1 nchar
deliv_fax 25 nvarchar
deliv_email 80 nvarchar
msg_format 1 nchar
msg_method 1 nchar
msg_fax 25 nvarchar
msg_email 80 nvarchar
pickup_location 1 nchar
delivery_service 9 nvarchar
internet_ariel 80 nvarchar
docview_address 80 nvarchar
odyssey_address 80 nvarchar
quota_total 10 int
quota_filled 10 int
quota_reset_date 23 datetime