tab_events.eng types and pc_tab_exp_field.eng values used by ARC - Questions
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
We are working on Circulation Statistics and have several questions about them.
Please answer the following quetions:
1. In Arc,” Event Type ID” and “Event Type Description “comes from tab_events.eng. Event “Category Id “ and ”Event Category Description” comes from pc_tab_exp_field.eng. It seems that there is a file or table that maps the fields in tab_events.eng to the fields pc_tab_exp_field.eng. Where is this table? In pc_tab_exp_field.eng we have a field description as 10 “unknow” and the fields from tab_events.eng that map to it seem to be booking statistics, and we are getting “Event Type Ids” of 95 and 96 that are not mapped or described.
2. We are getting data with an “Event Type ID “of 95 and 96, which is not mapped to any field in pc_tab_exp_field.eng. What type of events do these fields count?
3. Loans: Transfer Loan - tab_events.eng type 56. Does this event count loans to the “In Transit “patron?
4. How are Returns from the “IN Transit” patron counted or logged? There doesn’t seem to be a category for them in tab_events.eng.
5. Holds. tab_events.eng counts:
71 Expand Hold Request on Available Item
72 Non-Expand Hold Request on Available Item
73 Expand Hold Request on Nonavailable Item
74 Non-Expand Hold Request on Nonavailable Item
What is an “Expand” hold or a “Non-Expand hold’?
Resolution:
QUESTION 1: Is there a relationship between pc_tab_exp_field.eng and tab_events.eng?
ANSWER: The relation between them is connected only to ARC and occurs only in ARC.
QUESTION 2: Does “Event Type ID” and “Event Type Description“ from tab_events.eng relate to “Category Id“ and ”Event Category Description” in pc_tab_exp_field.eng?
ANSWER: The relation between them is connected only to ARC and occurs only in ARC.
Please see the following tables:
pc_tab_exp_field.eng:
Event Type desc Event Category
31 Creating New ILL Request 01
50 Simple Loan 02
51 Reading Room Loan 02
52 Offline Loan 02
53 Advance Booking Loan 02
54 Routing List Loan 02
55 ILL Loan 02
56 Transfer Loan 02
57 Remote Storage Loan 02
61 Return 03
62 Web Renewal 04
63 PC Renewal 04
64 Batch Renewal 04
65 Item Declared Lost 05
66 Item Claimed Returned 06
71 Expand Hold Request on Available Item 07
72 Non-Expand Hold Request on Available Item 07
73 Expand Hold Request on Nonavailable Item 07
74 Non-Expand Hold Request on Nonavailable Item 07
75 Reserve Advance Booking Item 07
80 In-house Use 08
81 Photocopy Request 09
82 Return of Item Not on Loan 03
tab_events.eng:
Event ID Event Category
01 ILL Requests
02 Loans
03 Returns
04 Renewals
05 Lost
06 Claimed Returned
07 Hold Requests
08 In-house Use
09 Photocopy Request
10 Unknown
This table shows the relations between event type and event category. For example Event types 62-64 are part of event category 04 (Renewals).
QUESTION 3: In usm50/tab/pc_tab_exp_field.eng - what does this value do?:
EVENT-CATEGORY L Unknow 10
ANSWER: It should be ‘Unknown’. When the event type is not one of the above, then it will receive event category 10 (Unknown).
QUESTION 4: Does the following setup in mh50/tab/pc_tab_exp_field.eng and tab_events.eng allow *all* possible values available in the ARC reports?
EVENT-CATEGORY L ILL Requests 01
EVENT-CATEGORY L Loans 02
EVENT-CATEGORY L Returns 03
EVENT-CATEGORY L Renewals 04
EVENT-CATEGORY L Lost 05
EVENT-CATEGORY L Claimed Returned 06
EVENT-CATEGORY L Hold Requests 07
EVENT-CATEGORY L In-house Use 08
EVENT-CATEGORY L Photocopy Request 09
EVENT-CATEGORY L Booking 10
!1 2 3
!!-!-!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
31 Y Creating New ILL Request
50 Y Simple Loan
51 Y Reading Room Loan
52 Y Offline Loan
53 Y Advance Booking Loan
54 Y Routing List Loan
55 Y ILL Loan
56 Y Transfer Loan
57 Y Remote Storage Loan
58 Y Delete loan
59 Y Maintenance Loan
61 Y Return
62 Y Web Renewal
63 Y PC Renewal
64 Y Batch Renewal
65 Y Item Declared Lost
66 Y Item Claimed Returned
71 Y Expand Hold Request on Available Item
72 Y Non-Expand Hold Request on Available Item
73 Y Expand Hold Request on Nonavailable Item
74 Y Non-Expand Hold Request on Nonavailable Item
75 Y Reserve Advance Booking Item
80 Y In-house Use
81 Y Photocopy Request
82 Y Return of Item Not on Loan
90 Y Booking
91 Y Booking turning to Loan
92 Y Delete Booking
95 Y Other Institute Fulfillment
96 Y Item Is Received at Pickup Location
ANSWER: If you wish that there will be ‘new’ event categories, please create a new SI with Enhancement request for new categories. Please write which event type you would like to see per each new category.
If you wish to add event types to existing categories please state that in the enhancement request.
I see that the client had changed category ‘10’ to ‘booking’ in tab_events.eng:
EVENT-CATEGORY L Booking 10
All ‘other’ types will receive this category.
QUESTION 5: Are "in transit" loans and returns recorded as a type 50 (simple loan) according to tab_ev
- Article last edited: 10/8/2013