Title request, patrons' order and hold request letters/slip

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
18 ver. production.
Send book to Joanna or Gary? Why hold request slip is printed for Joanna if Gary is the first with on hold status?
In the attachment 'CLICS- Joanna Cross' (from ho_pick_Nov6-2008) the hold request is for Joanna Cross (why??) but in GUI states it is on hold at BB for Gary.
item b.33381005189381 doc.5828627 10 from HO returned 11/11 2:19pm Dreams from my father : a story of race and inheritance
a) 091688301 MOON, GARY 10/6/08 on hold (S) from 11/11till 11/21
z37_expand N, z37_letter_status 02 (fulfillment notice sent), z37_letter_date 20081111, z37_print_status P
b) 098885088 CROSS, JOANNA A 11/6/08 A in process
z37_status A, z37_expand Y, z37_open_date 20081106, z37_open_hour 1653, z37_letter_status 04 (letter is printed after cir12), z37_letter_date 20081106, z37_print_status P.

Resolution:
The following shows the loan history of this HO001 item 005828627-000010:

abc50> select z36h_id, z36h_loan_date, z36h_returned_date from z36h where z36h_rec_key = '005828627000010' order by z36h_loan_date;
**** Hit return to continue ****

Z36H_ID Z36H_LOAN_DATE Z36H_RETURNED_DATE
------------ -------------- ------------------
SCR20081106 20080703 20080728
SCR20081228 20080916 20080918
SCR20090110 20080929 20081001
BB001 20081107 20081111

(currently on loan to Joanna Cross:)

abc50> select z36_id, z36_loan_date, z36_returned_date from z36 where z36_rec_key = '005828627000010';
**** Hit return to continue ****

Z36_ID Z36_LOAN_DATE Z36_RETURNED_DATE
------------ ------------- -----------------
098885088 20081130 0
[Cross, Joanna]

<end loan history>


Moon, Gary had placed a hold on the book on 20081006:

01 z37h_hold \
02 z37h_time ......................200811232201275
02 z37h_rec_key \
03 doc_number ...................005828627
03 item_sequence ................000010
03 sequence .....................0001
02 z37h_id ........................091688301 <----Moon, Gary
02 z37h_status ....................S
02 z37h_expand ....................N
02 z37h_priority ..................20
02 z37h_open_date .................20081006 <--
02 z37h_open_hour .................1258
02 z37h_request_date ..............20081006
02 z37h_end_request_date ..........20081206
02 z37h_hold_date .................20081111 <--
02 z37h_letter_status .............02 <--
02 z37h_letter_date ...............20081111
02 z37h_alpha .....................L
02 z37h_author ....................
02 z37h_title .....................
02 z37h_pages .....................
02 z37h_note_1 ....................
02 z37h_note_2 ....................
02 z37h_print_status ..............P
02 z37h_requester_id ..............
02 z37h_cataloger_name ............
02 z37h_cataloger_ip ..............150.210.225.108
02 z37h_hold_sequence .............000
02 z37h_pickup_location ...........BB001
02 z37h_send_action ...............01
02 z37h_end_hold_date .............20081121 <-------------
02 z37h_recall_type ...............01
02 z37h_rush_request ..............N
02 z37h_filter_sub_library ........HO001
02 z37h_filter_item_status ........#
02 z37h_filter_process_status .....#
02 z37h_filter_collection .........#
02 z37h_filter_copy ...............00000
02 z37h_filter_buffers \
03 enumeration \
04 enumeration_a ..............
04 enumeration_b ..............
04 enumeration_c ..............
03 chronological \
04 chronological_i ............
04 chronological_j ............
04 chronological_k ............
02 z37h_request_type ..............T
<etc.>

Joanna Cross placed a hold on the item on 20081106:

01 z37h_hold \
02 z37h_time ......................200811301725341
02 z37h_rec_key \
03 doc_number ...................005828627
03 item_sequence ................000010
03 sequence .....................0002
02 z37h_id ........................098885088 <----- Cross, Joanna
02 z37h_status ....................S
02 z37h_expand ....................N
02 z37h_priority ..................20
02 z37h_open_date .................20081106 <--
02 z37h_open_hour .................1653
02 z37h_request_date ..............20081106
02 z37h_end_request_date ..........20090106
02 z37h_hold_date .................20081124 <--
02 z37h_letter_status .............02 <--
02 z37h_letter_date ...............20081124
02 z37h_alpha .....................L
02 z37h_author ....................
02 z37h_title .....................
02 z37h_pages .....................
02 z37h_note_1 ....................
02 z37h_note_2 ....................
02 z37h_print_status ..............P
02 z37h_requester_id ..............
02 z37h_cataloger_name ............
02 z37h_cataloger_ip ..............150.210.225.108
02 z37h_hold_sequence .............000
02 z37h_pickup_location ...........BB001
02 z37h_send_action ...............01
02 z37h_end_hold_date .............20081206
02 z37h_recall_type ...............01
02 z37h_rush_request ..............N
02 z37h_filter_sub_library ........HO001
02 z37h_filter_item_status ........#
02 z37h_filter_process_status .....#
02 z37h_filter_collection .........#
02 z37h_filter_copy ...............00000
02 z37h_filter_buffers \
03 enumeration \
04 enumeration_a ..............
04 enumeration_b ..............
04 enumeration_c ..............
03 chronological \
04 chronological_i ............
04 chronological_j ............

• Article last edited: 10/8/2013