1 <IDL xmlns="http://opensrf.org/spec/IDL/base/v1" xmlns:oils_persist="http://open-ils.org/spec/opensrf/IDL/persistence/v1" xmlns:oils_obj="http://open-ils.org/spec/opensrf/IDL/objects/v1" xmlns:reporter="http://open-ils.org/spec/opensrf/IDL/reporter/v1">
3 <!-- Virtual classes -->
4 <class id="mups" controller="open-ils.cstore" oils_obj:fieldmapper="money::user_payment_summary" oils_persist:virtual="true">
6 <field name="isnew" oils_obj:array_position="0" oils_persist:virtual="true" />
7 <field name="ischanged" oils_obj:array_position="1" oils_persist:virtual="true" />
8 <field name="isdeleted" oils_obj:array_position="2" oils_persist:virtual="true" />
9 <field name="usr" oils_obj:array_position="3" oils_persist:virtual="true" />
10 <field name="forgive_payment" oils_obj:array_position="4" oils_persist:virtual="true" />
11 <field name="work_payment" oils_obj:array_position="5" oils_persist:virtual="true" />
12 <field name="credit_payment" oils_obj:array_position="6" oils_persist:virtual="true" />
13 <field name="goods_payment" oils_obj:array_position="7" oils_persist:virtual="true" />
16 <link field="usr" reltype="has_a" key="id" map="" class="au"/>
19 <!-- Actually in the DB -->
20 <class id="auoi" controller="open-ils.cstore" oils_obj:fieldmapper="actor::usr_org_unit_opt_in" oils_persist:tablename="actor.usr_org_unit_opt_in" reporter:label="User Sharing Opt-in">
21 <fields oils_persist:primary="id" oils_persist:sequence="actor.usr_org_unit_opt_in_id_seq">
22 <field name="isnew" oils_obj:array_position="0" oils_persist:virtual="true" />
23 <field name="ischanged" oils_obj:array_position="1" oils_persist:virtual="true" />
24 <field name="isdeleted" oils_obj:array_position="2" oils_persist:virtual="true" />
25 <field reporter:label="Opt-in ID" name="id" oils_obj:array_position="3" oils_persist:virtual="false" reporter:datatype="id"/>
26 <field reporter:label="Workstation" name="opt_in_ws" oils_obj:array_position="4" oils_persist:virtual="false" reporter:datatype="link"/>
27 <field reporter:label="Staff Member" name="staff" oils_obj:array_position="5" oils_persist:virtual="false" reporter:datatype="link"/>
28 <field reporter:label="User" name="usr" oils_obj:array_position="6" oils_persist:virtual="false" reporter:datatype="link"/>
29 <field reporter:label="Allowed Org Unit" name="org_unit" oils_obj:array_position="7" oils_persist:virtual="false" reporter:datatype="link"/>
30 <field reporter:label="Opt-in Date/Time" name="opt_in_ts" oils_obj:array_position="8" oils_persist:virtual="false" reporter:datatype="timestamp"/>
33 <link field="org_unit" reltype="has_a" key="id" map="" class="aou"/>
34 <link field="usr" reltype="has_a" key="id" map="" class="au"/>
35 <link field="staff" reltype="has_a" key="id" map="" class="au"/>
36 <link field="opt_in_ws" reltype="has_a" key="id" map="" class="aws"/>
39 <class id="aws" controller="open-ils.cstore" oils_obj:fieldmapper="actor::workstation" oils_persist:tablename="actor.workstation" reporter:label="Workstation">
40 <fields oils_persist:primary="id" oils_persist:sequence="actor.workstation_id_seq">
41 <field name="isnew" oils_obj:array_position="0" oils_persist:virtual="true" />
42 <field name="ischanged" oils_obj:array_position="1" oils_persist:virtual="true" />
43 <field name="isdeleted" oils_obj:array_position="2" oils_persist:virtual="true" />
44 <field reporter:label="Workstation ID" name="id" oils_obj:array_position="3" oils_persist:virtual="false" reporter:datatype="id"/>
45 <field reporter:label="Workstation Name" name="name" oils_obj:array_position="4" oils_persist:virtual="false" reporter:datatype="text"/>
46 <field reporter:label="Owning Library" name="owning_lib" oils_obj:array_position="5" oils_persist:virtual="false" reporter:datatype="org_unit"/>
49 <link field="owning_lib" reltype="has_a" key="id" map="" class="aou"/>
52 <class id="rodcirc" controller="open-ils.reporter-store" oils_obj:fieldmapper="reporter::overdue_circs" oils_persist:tablename="reporter.overdue_circs" reporter:core="true" reporter:label="Overdue Circulation">
53 <fields oils_persist:primary="id" oils_persist:sequence="money.billable_xact_id_seq">
54 <field name="isnew" oils_obj:array_position="0" oils_persist:virtual="true" />
55 <field name="ischanged" oils_obj:array_position="1" oils_persist:virtual="true" />
56 <field name="isdeleted" oils_obj:array_position="2" oils_persist:virtual="true" />
57 <field reporter:label="Check In Library" name="checkin_lib" oils_obj:array_position="3" oils_persist:virtual="false" reporter:datatype="org_unit"/>
58 <field reporter:label="Check In Staff" name="checkin_staff" oils_obj:array_position="4" oils_persist:virtual="false" reporter:datatype="link"/>
59 <field reporter:label="Check In Date/Time" name="checkin_time" oils_obj:array_position="5" oils_persist:virtual="false" reporter:datatype="timestamp"/>
60 <field reporter:label="Circulating Library" name="circ_lib" oils_obj:array_position="6" oils_persist:virtual="false" reporter:datatype="org_unit"/>
61 <field reporter:label="Circulating Staff" name="circ_staff" oils_obj:array_position="7" oils_persist:virtual="false" reporter:datatype="link"/>
62 <field reporter:label="Desk Renewal" name="desk_renewal" oils_obj:array_position="8" oils_persist:virtual="false" reporter:datatype="bool"/>
63 <field reporter:label="Due Date/Time" name="due_date" oils_obj:array_position="9" oils_persist:virtual="false" reporter:datatype="timestamp"/>
64 <field reporter:label="Circulation Duration" name="duration" oils_obj:array_position="10" oils_persist:virtual="false" reporter:datatype="interval"/>
65 <field reporter:label="Circ Duration Rule" name="duration_rule" oils_obj:array_position="11" oils_persist:virtual="false" reporter:datatype="link"/>
66 <field reporter:label="Fine Interval" name="fine_interval" oils_obj:array_position="12" oils_persist:virtual="false" reporter:datatype="interval"/>
67 <field reporter:label="Circ ID" name="id" oils_obj:array_position="13" oils_persist:virtual="false" reporter:datatype="id" />
68 <field reporter:label="Max Fine Amount" name="max_fine" oils_obj:array_position="14" oils_persist:virtual="false" reporter:datatype="money" />
69 <field reporter:label="Max Fine Rule" name="max_fine_rule" oils_obj:array_position="15" oils_persist:virtual="false" reporter:datatype="link"/>
70 <field reporter:label="OPAC Renewal" name="opac_renewal" oils_obj:array_position="16" oils_persist:virtual="false" reporter:datatype="bool"/>
71 <field reporter:label="Phone Renewal" name="phone_renewal" oils_obj:array_position="17" oils_persist:virtual="false" reporter:datatype="bool"/>
72 <field reporter:label="Recurring Fine Amount" name="recuring_fine" oils_obj:array_position="18" oils_persist:virtual="false" reporter:datatype="money" />
73 <field reporter:label="Recurring Fine Rule" name="recuring_fine_rule" oils_obj:array_position="19" oils_persist:virtual="false" reporter:datatype="link"/>
74 <field reporter:label="Remaining Renewals" name="renewal_remaining" oils_obj:array_position="20" oils_persist:virtual="false" reporter:datatype="int" />
75 <field reporter:label="Fine Stop Reason" name="stop_fines" oils_obj:array_position="21" oils_persist:virtual="false" reporter:datatype="text"/>
76 <field reporter:label="Fine Stop Date/Time" name="stop_fines_time" oils_obj:array_position="22" oils_persist:virtual="false" reporter:datatype="timestamp"/>
77 <field reporter:label="Circulating Item" name="target_copy" oils_obj:array_position="23" oils_persist:virtual="false" reporter:datatype="link"/>
78 <field reporter:label="Patron" name="usr" oils_obj:array_position="24" oils_persist:virtual="false" reporter:datatype="link"/>
79 <field reporter:label="Transaction Finish Date/Time" name="xact_finish" oils_obj:array_position="25" oils_persist:virtual="false" reporter:datatype="timestamp" />
80 <field reporter:label="Check Out Date/Time" name="xact_start" oils_obj:array_position="26" oils_persist:virtual="false" reporter:datatype="timestamp" />
81 <field reporter:label="Transaction Billings" name="billings" oils_obj:array_position="27" oils_persist:virtual="true" reporter:datatype="link"/>
82 <field reporter:label="Transaction Payments" name="payments" oils_obj:array_position="28" oils_persist:virtual="true" reporter:datatype="link"/>
83 <field reporter:label="Base Transaction" name="billable_transaction" oils_obj:array_position="29" oils_persist:virtual="true" reporter:datatype="link"/>
84 <field reporter:label="Circulation Type" name="circ_type" oils_obj:array_position="30" oils_persist:virtual="true" reporter:datatype="text"/>
85 <field reporter:label="Billing Totals" name="billing_total" oils_obj:array_position="31" oils_persist:virtual="true" reporter:datatype="money"/>
86 <field reporter:label="Payment Totals" name="payment_total" oils_obj:array_position="32" oils_persist:virtual="true" reporter:datatype="money"/>
89 <link field="billable_transaction" reltype="might_have" key="id" map="" class="mbt"/>
90 <link field="circ_staff" reltype="has_a" key="id" map="" class="au"/>
91 <link field="checkin_lib" reltype="has_a" key="id" map="" class="aou"/>
92 <link field="target_copy" reltype="has_a" key="id" map="" class="acp"/>
93 <link field="checkin_staff" reltype="has_a" key="id" map="" class="au"/>
94 <link field="usr" reltype="has_a" key="id" map="" class="au"/>
95 <link field="circ_lib" reltype="has_a" key="id" map="" class="aou"/>
96 <link field="payments" reltype="has_many" key="xact" map="" class="mp"/>
97 <link field="billings" reltype="has_many" key="xact" map="" class="mb"/>
98 <link field="duration_rule" reltype="has_a" key="name" map="" class="crcd"/>
99 <link field="max_fine_rule" reltype="has_a" key="name" map="" class="crmf"/>
100 <link field="recuring_fine_rule" reltype="has_a" key="name" map="" class="crrf"/>
101 <link field="circ_type" reltype="might_have" key="id" map="" class="rcirct"/>
102 <link field="billing_total" reltype="might_have" key="xact" map="" class="rxbt"/>
103 <link field="payment_total" reltype="might_have" key="xact" map="" class="rxpt"/>