| Display Label | DB Name | Type |
|---|---|---|
| Barcode | barcode | text |
| User | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Check In Library | checkin_lib | org_unit |
| Check In Staff | checkin_staff | link |
| Circulating Library | circ_lib | org_unit |
| Circulating Staff | circ_staff | link |
| Desk Renewal | desk_renewal | bool |
| Circulation Duration | duration | interval |
| Circ Duration Rule | duration_rule | link |
| Fine Interval | fine_interval | interval |
| Max Fine Rule | max_fine_rule | link |
| OPAC Renewal | opac_renewal | bool |
| Phone Renewal | phone_renewal | bool |
| Recurring Fine Rule | recuring_fine_rule | link |
| Fine Stop Reason | stop_fines | text |
| Circulating Item | target_copy | link |
| Patron ZIP | usr_post_code | text |
| Transaction Billings | billings | link |
| Transaction Payments | payments | link |
| Base Transaction | billable_transaction | link |
| Circulation Type | circ_type | text |
| Billing Totals | billing_total | money |
| Payment Totals | payment_total | money |
| Patron Home Library | usr_home_ou | link |
| Patron Profile Group | usr_profile | link |
| Patron Birth Year | usr_birth_year | int |
| Call Number | copy_call_number | link |
| Shelving Location | copy_location | link |
| Copy Owning Library | copy_owning_lib | link |
| Copy Circulating Library | copy_circ_lib | link |
| Bib Record | copy_bib_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Copies | copies | link |
| Creating User | creator | link |
| Is Deleted | deleted | bool |
| Last Editing User | editor | link |
| Call Number Label | label | text |
| Owning Library | owning_lib | org_unit |
| Bib Record | record | link |
| Notes | notes | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | create_date | timestamp |
| Undefined | creator | link |
| Undefined | pub | bool |
| Undefined | title | text |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Statistical Catagory Entries | stat_cat_entries | link |
| Age Hold Protection | age_protect | link |
| Alert Message | alert_message | text |
| Barcode | barcode | text |
| Circulating Library | circ_lib | org_unit |
| Circulation Modifier | circ_modifier | text |
| Can Circulate | circulate | bool |
| Copy Number on Volume | copy_number | text |
| Creating User | creator | link |
| Is Deleted | deleted | bool |
| Is Deposit Required | deposit | bool |
| Precat Dummy Author | dummy_author | text |
| Precat Dummy Title | dummy_title | text |
| Last Editing User | editor | link |
| Fine Level | fine_level | int |
| Copy ID | id | id |
| Loan Duration | loan_duration | int |
| Shelving Location | location | link |
| Is Reference | ref | bool |
| Copy Status | status | link |
| Copy Notes | notes | link |
| Circulations | circulations | link |
| Total Circulations | total_circ_count | link |
| Holds | holds | link |
| Display Label | DB Name | Type |
|---|---|---|
| Location ID | id | id |
| Owning Org Unit | owning_lib | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Note Creator | creator | link |
| Copy | owning_copy | link |
| Note Title | title | text |
| Note Content | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Entries | entries | link |
| OPAC Visible | opac_visible | bool |
| Owning Library | owner | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Entry Owner | owner | link |
| Stat Cat | stat_cat | link |
| Entry Value | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Statistical Category | stat_cat | link |
| Entry Text | stat_cat_entry | text |
| User | target_usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | hold | link |
| Undefined | target_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| Hold | hold | link |
| Notification Method | method | text |
| Notification Note | note | text |
| Notifying Staff | notify_staff | link |
| Display Label | DB Name | Type |
|---|---|---|
| Fulfilling Library | fulfillment_lib | org_unit |
| Hold Type | hold_type | text |
| Notifications Phone Number | phone_notify | text |
| Pickup Library | pickup_lib | org_unit |
| Requesting Library | request_lib | org_unit |
| Requesting User | requestor | link |
| Selection Locus | selection_ou | org_unit |
| Target Object ID | target | link |
| Hold User | usr | link |
| Notifications | notify_time | timestamp |
| Bib Record link | notifications | link |
| Eligible Copies | bib_rec | link |
| Currently Frozen | eligible_copies | link |
| Undefined | frozen | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Copy Status at Transit | copy_status | link |
| Destination Library | dest | org_unit |
| Hold requiring Transit | hold | link |
| Previous Stop | prev_hop | link |
| Sending Library | source | org_unit |
| Transited Copy | target_copy | link |
| Base Transit | transit_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| Using Library | org_unit | org_unit |
| Recording Staff | staff | link |
| Display Label | DB Name | Type |
|---|---|---|
| Matchpoint ID | matchpoint | id |
| Success | success | bool |
| Failure Part | fail_part | text |
| Display Label | DB Name | Type |
|---|---|---|
| Circulating Library | circ_lib | org_unit |
| Patron | patron | link |
| Circulating Staff | staff | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | hold | link |
| Undefined | target_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| Hold | hold | link |
| Notification Method | method | text |
| Notification Note | note | text |
| Notifying Staff | notify_staff | link |
| Display Label | DB Name | Type |
|---|---|---|
| Fulfilling Library | fulfillment_lib | org_unit |
| Hold Type | hold_type | text |
| Notifications Phone Number | phone_notify | text |
| Pickup Library | pickup_lib | org_unit |
| Requesting Library | request_lib | org_unit |
| Requesting User | requestor | link |
| Selection Locus | selection_ou | org_unit |
| Target Object ID | target | link |
| Hold User | usr | link |
| Notifications | notify_time | timestamp |
| Bib Record link | notifications | link |
| Eligible Copies | bib_rec | link |
| Currently Frozen | eligible_copies | link |
| Undefined | frozen | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Copy Status at Transit | copy_status | link |
| Destination Library | dest | org_unit |
| Hold requiring Transit | hold | link |
| Previous Stop | prev_hop | link |
| Sending Library | source | org_unit |
| Transited Copy | target_copy | link |
| Base Transit | transit_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| Using Library | org_unit | org_unit |
| Recording Staff | staff | link |
| Display Label | DB Name | Type |
|---|---|---|
| Matchpoint ID | matchpoint | id |
| Success | success | bool |
| Failure Part | fail_part | text |
| Display Label | DB Name | Type |
|---|---|---|
| Circulating Library | circ_lib | org_unit |
| Patron | patron | link |
| Circulating Staff | staff | link |
| Display Label | DB Name | Type |
|---|---|---|
| Item Type | item_type | link |
| Using Library | org_unit | org_unit |
| Recording Staff | staff | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | address_type | text |
| Undefined | city | text |
| Undefined | country | text |
| Undefined | county | text |
| Undefined | org_unit | org_unit |
| Undefined | post_code | text |
| Undefined | state | text |
| Undefined | street1 | text |
| Undefined | street2 | text |
| Undefined | valid | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | checkin_lib | link |
| Undefined | checkin_staff | link |
| Undefined | checkin_time | timestamp |
| Undefined | circ_lib | org_unit |
| Undefined | circ_staff | link |
| Undefined | desk_renewal | bool |
| Undefined | due_date | timestamp |
| Undefined | duration | interval |
| Undefined | duration_rule | link |
| Undefined | fine_interval | interval |
| Undefined | max_fine_rule | link |
| Undefined | opac_renewal | bool |
| Undefined | phone_renewal | bool |
| Undefined | recuring_fine_rule | link |
| Undefined | stop_fines | text |
| Undefined | stop_fines_time | timestamp |
| Undefined | target_copy | link |
| Undefined | usr | link |
| Undefined | circulation | link |
| Display Label | DB Name | Type |
|---|---|---|
| Subordinate Organizational Units | children | org_unit |
| Billing Address | billing_address | link |
| Holds Receiving Address | holds_address | link |
| Organizational Unit ID | id | org_unit |
| ILL Receiving Address | ill_address | link |
| Mailing Address | mailing_address | link |
| Organizational Unit Type | ou_type | link |
| Parent Organizational Unit | parent_ou | link |
| Email Address | text | |
| Phone Number | phone | text |
| OPAC Visible | opac_visible | bool |
| Users | users | link |
| Closed Dates | closed_dates | link |
| Circulations | circulations | link |
| Settings | settings | link |
| Addresses | addresses | link |
| Checkins | checkins | link |
| Workstations | workstations | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | org_unit | org_unit |
| Undefined | reason | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | org_unit | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | from_org | org_unit |
| Undefined | to_org | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | name | text |
| Undefined | org_unit | org_unit |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Subordinate Types | children | link |
| Type ID | id | id |
| Parent Type | parent | link |
| Org Units | org_units | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | active | bool |
| Undefined | create_date | timestamp |
| Undefined | deleted | bool |
| Undefined | edit_date | timestamp |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | create_date | timestamp |
| Undefined | creator | link |
| Undefined | edit_date | timestamp |
| Undefined | editor | link |
| Undefined | record | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Entries | entries | link |
| OPAC Visible | opac_visible | bool |
| Owning Library | owner | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Entry Owner | owner | link |
| Stat Cat | stat_cat | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | owning_copy | link |
| Undefined | stat_cat | link |
| Undefined | stat_cat_entry | link |
| Display Label | DB Name | Type |
|---|---|---|
| Questions | questions | link |
| Responses | responses | link |
| Description | description | text |
| Survey ID | id | id |
| Name | name | text |
| Owning Library | owner | org_unit |
| Display in User Summary | usr_summary | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Responses using this Answer | responses | link |
| Answer Text | answer | text |
| Question | question | link |
| Display Label | DB Name | Type |
|---|---|---|
| Answers | answers | link |
| Responses | responses | link |
| Question | question | text |
| Survey | survey | link |
| Display Label | DB Name | Type |
|---|---|---|
| Answer | answer | link |
| Question | question | link |
| Survey | survey | link |
| Responding User | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | create_date | timestamp |
| Undefined | creator | link |
| Undefined | edit_date | timestamp |
| Undefined | editor | link |
| Undefined | record | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Entries | entries | link |
| OPAC Visible | opac_visible | bool |
| Owning Library | owner | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Entry Owner | owner | link |
| Stat Cat | stat_cat | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | owning_copy | link |
| Undefined | stat_cat | link |
| Undefined | stat_cat_entry | link |
| Display Label | DB Name | Type |
|---|---|---|
| Questions | questions | link |
| Responses | responses | link |
| Description | description | text |
| Survey ID | id | id |
| Name | name | text |
| Owning Library | owner | org_unit |
| Display in User Summary | usr_summary | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Responses using this Answer | responses | link |
| Answer Text | answer | text |
| Question | question | link |
| Display Label | DB Name | Type |
|---|---|---|
| Answers | answers | link |
| Responses | responses | link |
| Question | question | text |
| Survey | survey | link |
| Display Label | DB Name | Type |
|---|---|---|
| Answer | answer | link |
| Question | question | link |
| Survey | survey | link |
| Responding User | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Pretransit Copy Status | copy_status | bool |
| Destination | dest | link |
| Transit ID | id | id |
| Source | source | link |
| Transited Copy | target_copy | link |
| Hold Transit | hold_transit_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| All Addresses | addresses | link |
| All Library Cards | cards | link |
| All Circulations | checkouts | link |
| All Hold Requests | hold_requests | link |
| All Permissions | permissions | link |
| All User Settings | settings | link |
| Standing Penalties | standing_penalties | link |
| Statistical Category Entries | stat_cat_entries | link |
| Survey Responses | survey_responses | link |
| Active | ws_ou | link |
| Alert Message | wsid | link |
| Barred | active | bool |
| Physical Address | alert_message | text |
| Current Library Card | barred | bool |
| Daytime Phone | billing_address | link |
| Date of Birth | card | link |
| Email Address | day_phone | text |
| Evening Phone | dob | timestamp |
| Privilege Expiration Date | text | |
| Last Name | evening_phone | text |
| First Name | expire_date | timestamp |
| Home Library | family_name | text |
| Primary Identification Type | first_given_name | text |
| Secondary Identification Type | home_ou | org_unit |
| Primary Identification | ident_type | link |
| Secondary Identification | ident_type2 | link |
| Mailing Address | ident_value | text |
| Is Group Lead Account | ident_value2 | text |
| Internet Access Level | last_xact_id | text |
| Other Phone | mailing_address | link |
| Photo URL | master_account | bool |
| Prefix | net_access_level | link |
| Middle Name | other_phone | text |
| Is Super User | photo_url | text |
| Family Linkage or other Group | prefix | text |
| Additional Permission Groups | second_given_name | text |
| Is Deleted | super_user | bool |
| User Notes | usrgroup | int |
| Demographic Info | groups | link |
| Billable Transactions | deleted | bool |
| Checkins | notes | link |
| Circulations Performed as Staff | demographic | link |
| Undefined | billable_transactions | link |
| Undefined | checkins | link |
| Undefined | performed_circulations | link |
| Display Label | DB Name | Type |
|---|---|---|
| Pretransit Copy Status | copy_status | bool |
| Destination | dest | link |
| Transit ID | id | id |
| Source | source | link |
| Transited Copy | target_copy | link |
| Hold Transit | hold_transit_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| All Addresses | addresses | link |
| All Library Cards | cards | link |
| All Circulations | checkouts | link |
| All Hold Requests | hold_requests | link |
| All Permissions | permissions | link |
| All User Settings | settings | link |
| Standing Penalties | standing_penalties | link |
| Statistical Category Entries | stat_cat_entries | link |
| Survey Responses | survey_responses | link |
| Active | ws_ou | link |
| Alert Message | wsid | link |
| Barred | active | bool |
| Physical Address | alert_message | text |
| Current Library Card | barred | bool |
| Daytime Phone | billing_address | link |
| Date of Birth | card | link |
| Email Address | day_phone | text |
| Evening Phone | dob | timestamp |
| Privilege Expiration Date | text | |
| Last Name | evening_phone | text |
| First Name | expire_date | timestamp |
| Home Library | family_name | text |
| Primary Identification Type | first_given_name | text |
| Secondary Identification Type | home_ou | org_unit |
| Primary Identification | ident_type | link |
| Secondary Identification | ident_type2 | link |
| Mailing Address | ident_value | text |
| Is Group Lead Account | ident_value2 | text |
| Internet Access Level | last_xact_id | text |
| Other Phone | mailing_address | link |
| Photo URL | master_account | bool |
| Prefix | net_access_level | link |
| Middle Name | other_phone | text |
| Is Super User | photo_url | text |
| Family Linkage or other Group | prefix | text |
| Additional Permission Groups | second_given_name | text |
| Is Deleted | super_user | bool |
| User Notes | usrgroup | int |
| Demographic Info | groups | link |
| Billable Transactions | deleted | bool |
| Checkins | notes | link |
| Circulations Performed as Staff | demographic | link |
| Undefined | billable_transactions | link |
| Undefined | checkins | link |
| Undefined | performed_circulations | link |
| Display Label | DB Name | Type |
|---|---|---|
| Type | address_type | text |
| City | city | text |
| Country | country | text |
| County | county | text |
| Postal Code | post_code | text |
| State | state | text |
| User | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Hold | hold | link |
| Display Label | DB Name | Type |
|---|---|---|
| Creating Staff | creator | link |
| Note Title | title | text |
| Note Content | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Workstation | opt_in_ws | link |
| Staff Member | staff | link |
| User | usr | link |
| Allowed Org Unit | org_unit | link |
| Display Label | DB Name | Type |
|---|---|---|
| Name | name | text |
| User | usr | link |
| Value | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | penalty_type | text |
| Undefined | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Workstation ID | id | id |
| Workstation Name | name | text |
| Owning Library | owning_lib | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Call Numbers | call_numbers | link |
| Fixed Field Entry | fixed_fields | link |
| Record Creator | creator | link |
| Last Editing User | editor | link |
| Fingerprint | fingerprint | text |
| Last Transaction ID | last_xact_id | text |
| MARC21Slim | marc | text |
| Record Source | source | link |
| TCN Source | tcn_source | text |
| TCN Value | tcn_value | text |
| Metarecord | metarecord | link |
| Language Code | language | link |
| Indexed Keyword Field Entries | keyword_field_entries | link |
| Indexed Subject Field Entries | subject_field_entries | link |
| Indexed Title Field Entries | title_field_entries | link |
| Indexed Author Field Entries | author_field_entries | link |
| Indexed Series Field Entries | series_field_entries | link |
| Flattened MARC Fields | full_record_entries | link |
| Simple Record Extracts | simple_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | create_date | timestamp |
| Undefined | creator | link |
| Undefined | edit_date | timestamp |
| Undefined | editor | link |
| Undefined | pub | bool |
| Undefined | record | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Audience Code | code | text |
| Display Label | DB Name | Type |
|---|---|---|
| Bib Level Code | code | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | items | link |
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | bucket | link |
| Undefined | target_biblio_record_entry | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | id | id |
| Undefined | source | text |
| Undefined | transcendant | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | target_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| Code | code | id |
| Magnetic Media | magnetic_media | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Test ID | id | id |
| Matchpoint ID | matchpoint | link |
| Items Out | items_out | int |
| Circulation Modifier | circ_mod | link |
| Display Label | DB Name | Type |
|---|---|---|
| Matchpoint ID | id | id |
| Org Unit | org_unit | link |
| Permission Group | grp | link |
| Circulation Modifier | circ_modifier | link |
| MARC Type | marc_type | link |
| MARC Form | marc_form | link |
| Videorecording Format | marc_vr_format | link |
| Display Label | DB Name | Type |
|---|---|---|
| Matchpoint ID | matchpoint | id |
| Duration Rule | duration_rule | link |
| Recurring Fine Rule | recurring_fine_rule | link |
| Max Fine Rule | max_fine_rule | link |
| Display Label | DB Name | Type |
|---|---|---|
| Matchpoint ID | matchpoint | id |
| Max Items Out | max_items_out | int |
| Max Overdue | max_overdue | int |
| Max Fines | max_fines | money |
| Test Script | script_test | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | items | link |
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | bucket | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | holdable | bool |
| Undefined | id | id |
| Undefined | opac_visible | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Matchpoint ID | id | id |
| User Home Library | user_home_ou | link |
| Request Library | request_ou | link |
| Pickup Library | pickup_ou | link |
| Owning Library | item_owning_ou | link |
| Item Circ Library | item_circ_ou | link |
| User Permission Group | usr_grp | link |
| Requestor Permission Group | requestor_grp | link |
| Circulation Modifier | circ_modifier | link |
| MARC Type | marc_type | link |
| MARC Form | marc_form | link |
| Videorecording Format | marc_vr_format | link |
| Display Label | DB Name | Type |
|---|---|---|
| Matchpoint ID | matchpoint | link |
| Transit Range | transit_range | int |
| Max Holds | max_holds | int |
| Max includes Frozen | include_frozen_holds | bool |
| Copy Age Hold Protection Rule | age_hold_protect_rule | link |
| Display Label | DB Name | Type |
|---|---|---|
| Item Form Code | code | text |
| Display Label | DB Name | Type |
|---|---|---|
| Check In Library | checkin_lib | org_unit |
| Check In Staff | checkin_staff | link |
| Circulating Library | circ_lib | org_unit |
| Circulating Staff | circ_staff | link |
| Desk Renewal | desk_renewal | bool |
| Circulation Duration | duration | interval |
| Circ Duration Rule | duration_rule | link |
| Fine Interval | fine_interval | interval |
| Max Fine Rule | max_fine_rule | link |
| OPAC Renewal | opac_renewal | bool |
| Phone Renewal | phone_renewal | bool |
| Recurring Fine Rule | recuring_fine_rule | link |
| Fine Stop Reason | stop_fines | text |
| Circulating Item | target_copy | link |
| Patron | usr | link |
| Transaction Billings | billings | link |
| Transaction Payments | payments | link |
| Base Transaction | billable_transaction | link |
| Circulation Type | circ_type | text |
| Billing Totals | billing_total | money |
| Payment Totals | payment_total | money |
| Display Label | DB Name | Type |
|---|---|---|
| Identification ID | id | id |
| Display Label | DB Name | Type |
|---|---|---|
| Item Type Code | code | text |
| Display Label | DB Name | Type |
|---|---|---|
| LitF Code | code | text |
| Display Label | DB Name | Type |
|---|---|---|
| Language Code | code | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | name | text |
| Undefined | xpath | text |
| Undefined | format | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | id | id |
| Undefined | name | text |
| Display Label | DB Name | Type |
|---|---|---|
| Circulation Duration | circ_duration | interval |
| Owning Library | owning_lib | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Check In Library | checkin_lib | org_unit |
| Check In Staff | checkin_staff | link |
| Circulating Library | circ_lib | org_unit |
| Circulating Staff | circ_staff | link |
| Desk Renewal | desk_renewal | bool |
| Circulation Duration | duration | interval |
| Circ Duration Rule | duration_rule | link |
| Fine Interval | fine_interval | interval |
| Max Fine Rule | max_fine_rule | link |
| OPAC Renewal | opac_renewal | bool |
| Phone Renewal | phone_renewal | bool |
| Recurring Fine Rule | recuring_fine_rule | link |
| Fine Stop Reason | stop_fines | text |
| Circulating Item | target_copy | link |
| Patron ZIP | usr_post_code | text |
| Transaction Billings | billings | link |
| Transaction Payments | payments | link |
| Base Transaction | billable_transaction | link |
| Circulation Type | circ_type | text |
| Billing Totals | billing_total | money |
| Payment Totals | payment_total | money |
| Patron Home Library | usr_home_ou | link |
| Patron Profile Group | usr_profile | link |
| Patron Birth Year | usr_birth_year | int |
| Call Number | copy_call_number | link |
| Shelving Location | copy_location | link |
| Copy Owning Library | copy_owning_lib | link |
| Copy Circulating Library | copy_circ_lib | link |
| Bib Record | copy_bib_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Item Age | age | interval |
| Rule ID | id | id |
| Rule Name | name | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | extended | interval |
| Undefined | name | text |
| Undefined | normal | interval |
| Undefined | shrt | interval |
| Display Label | DB Name | Type |
|---|---|---|
| Rule ID | id | id |
| Rule Name | name | text |
| Is Percent | is_percent | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | id | id |
| Undefined | name | text |
| Undefined | recurance_interval | interval |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | items | link |
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | bucket | link |
| Undefined | target_user | link |
| Display Label | DB Name | Type |
|---|---|---|
| Code | code | id |
| Display Label | DB Name | Type |
|---|---|---|
| Namespace URI | namespace_uri | text |
| Namespace Prefix | prefix | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | fq_field | text |
| Undefined | identity_value | text |
| Undefined | translation | text |
| Undefined | string | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | marc_code | text |
| Display Label | DB Name | Type |
|---|---|---|
| Pretransit Copy Status | copy_status | bool |
| Destination | dest | link |
| Transit ID | id | id |
| Source | source | link |
| Transited Copy | target_copy | link |
| Hold Transit | hold_transit_copy | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | name | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | lasso | link |
| Undefined | org_unit | org_unit |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Billing Timestamp | billing_ts | timestamp |
| Billing Type | billing_type | text |
| Note | note | text |
| Void Timestamp | void_time | timestamp |
| Voiding Staff Member | voider | link |
| Transaction | xact | link |
| Display Label | DB Name | Type |
|---|---|---|
| Note | note | text |
| Payment Type | payment_type | text |
| Billable Transaction | xact | link |
| Cash Payment Detail | cash_payment | link |
| Credit Card Payment Detail | credit_card_payment | link |
| Credit Payment Detail | credit_payment | link |
| Check Payment Detail | check_payment | link |
| Work Payment Detail | work_payment | link |
| Forgive Payment Detail | forgive_payment | link |
| Goods Payment Detail | goods_payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| User | usr | link |
| Grocery Billing link | grocery | link |
| Circulation Billing link | circulation | link |
| Billing Line Items | billings | link |
| Payment Line Items | payments | link |
| Billing Totals | billing_total | money |
| Payment Totals | payment_total | money |
| Display Label | DB Name | Type |
|---|---|---|
| Balance Owed | balance_owed | money |
| Transaction ID | id | id |
| Last Billing Note | last_billing_note | text |
| Last Billing Timestamp | last_billing_ts | timestamp |
| Last Billing Type | last_billing_type | text |
| Last Payment Note | last_payment_note | text |
| Last Payment Timestamp | last_payment_ts | timestamp |
| Last Payment Type | last_payment_type | text |
| Total Owed | total_owed | money |
| Total Paid | total_paid | money |
| Billed User | usr | link |
| Transaction Type | xact_type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | approval_code | text |
| Undefined | cash_drawer | link |
| Undefined | cc_number | text |
| Undefined | cc_type | text |
| Undefined | note | text |
| Undefined | payment_ts | timestamp |
| Undefined | xact | link |
| Undefined | payment_type | text |
| Undefined | payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| Accepting Staff Member | accepting_usr | link |
| Workstation link | cash_drawer | link |
| Note | note | text |
| Payment Timestamp | payment_ts | timestamp |
| Transaction link | xact | link |
| Payment link | payment | link |
| Payment Type | payment_type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | accepting_usr | link |
| Undefined | cash_drawer | link |
| Undefined | note | text |
| Undefined | payment_ts | timestamp |
| Undefined | xact | link |
| Undefined | payment_type | text |
| Undefined | payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| Accepting Staff Member | accepting_usr | link |
| Payment Note | note | text |
| Payment Timestamp | payment_ts | timestamp |
| Transaction | xact | link |
| Payment Type | payment_type | text |
| Payment link | payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | enter_time | timestamp |
| Undefined | location | link |
| Undefined | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Note | note | text |
| Payment Type | payment_type | text |
| Billable Transaction | xact | link |
| Cash Drawer | cash_drawer | link |
| Cash Payment | cash_payment | link |
| Credit Card Payment | credit_card_payment | link |
| Check Payment | check_payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | accepting_usr | link |
| Undefined | note | text |
| Undefined | payment_ts | timestamp |
| Undefined | xact | link |
| Undefined | payment_type | text |
| Undefined | payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| Indicator 1 | ind1 | text |
| Indicator 2 | ind2 | text |
| Bib Record Entry | record | link |
| Subfield | subfield | text |
| Tag | tag | text |
| Normalized Value | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Billing Location | billing_location | link |
| Note | note | text |
| User | usr | link |
| Billings | billings | link |
| Payments | payments | link |
| Billable Transaction link | billable_transaction | link |
| Billing Totals | billing_total | money |
| Payment Totals | payment_total | money |
| Display Label | DB Name | Type |
|---|---|---|
| Accepting Staff Member | accepting_usr | link |
| Note | note | text |
| Payment Timestamp | payment_ts | timestamp |
| Transaction ID | xact | link |
| Payment link | payment | link |
| Payment Type | payment_type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | fingerprint | text |
| Undefined | master_record | link |
| Undefined | mods | text |
| Undefined | source_records | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | metarecord | link |
| Undefined | source | link |
| Display Label | DB Name | Type |
|---|---|---|
| Note | note | text |
| Payment Type | payment_type | text |
| Billable Transaction | xact | link |
| Work Payment Detail | work_payment | link |
| Forgive Payment Detail | forgive_payment | link |
| Goods Payment Detail | goods_payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | balance_owed | money |
| Undefined | last_billing_note | text |
| Undefined | last_billing_ts | timestamp |
| Undefined | last_billing_type | text |
| Undefined | last_payment_note | text |
| Undefined | last_payment_ts | timestamp |
| Undefined | last_payment_type | text |
| Undefined | total_owed | money |
| Undefined | total_paid | money |
| Undefined | usr | link |
| Undefined | xact_type | text |
| Undefined | xact | link |
| Undefined | grocery | link |
| Undefined | circulation | link |
| Undefined | billing_location | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Note | note | text |
| Payment Type | payment_type | text |
| Billable Transaction | xact | link |
| Cash Payment Detail | cash_payment | link |
| Credit Card Payment Detail | credit_card_payment | link |
| Credit Payment Detail | credit_payment | link |
| Check Payment Detail | check_payment | link |
| Work Payment Detail | work_payment | link |
| Forgive Payment Detail | forgive_payment | link |
| Goods Payment Detail | goods_payment | link |
| Display Label | DB Name | Type |
|---|---|---|
| Audn | audience | text |
| BLvl | bib_level | text |
| Cat Form | cat_form | text |
| Character Encoding | char_encoding | text |
| Ctrl | control_type | text |
| ELvl | enc_level | text |
| Form | item_form | text |
| Lang | item_lang | text |
| Type | item_type | text |
| LitF | lit_form | text |
| Pub Status | pub_status | text |
| Bib Record Entry | record | link |
| TMat | type_mat | text |
| Video Recording Format | vr_format | text |
| Date1 | date1 | text |
| Date2 | date2 | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Accepting Staff Member | accepting_usr | link |
| Note | note | text |
| Payment Timestamp | payment_ts | timestamp |
| Transaction ID | xact | link |
| Payment link | payment | link |
| Payment Type | payment_type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | grantable | bool |
| Undefined | grp | link |
| Undefined | perm | link |
| Display Label | DB Name | Type |
|---|---|---|
| Child Groups | children | link |
| Group ID | id | id |
| Parent Group | parent | link |
| User Expiration Interval | perm_interval | interval |
| Required Permission | application_perm | text |
| Is User Group | usergroup | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | code | text |
| Undefined | id | id |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | object_id | text |
| Undefined | grantable | bool |
| Undefined | perm | link |
| Undefined | usr | link |
| Undefined | object_type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | depth | int |
| Undefined | grantable | bool |
| Undefined | perm | link |
| Undefined | usr | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | usr | link |
| Undefined | work_ou | link |
| Display Label | DB Name | Type |
|---|---|---|
| Billing Location Name | billing_location_name | text |
| Billing Location Link | billing_location | org_unit |
| User Home Library Name | usr_home_ou_name | text |
| User Home Library Link | usr_home_ou | org_unit |
| User Barcode | barcode | text |
| User Link | usr | link |
| Transaction Type | xact_type | text |
| Total Paid | total_paid | money |
| Total Billed | total_owed | money |
| Last Payment Note | last_payment_note | text |
| Last Payment Type | last_payment_type | text |
| Last Billing Note | last_billing_note | text |
| Last Billing Type | last_billing_type | text |
| User Age Demographic | demographic_general_division | text |
| User County | patron_county | text |
| User City | patron_city | text |
| User ZIP Code | patron_zip | text |
| Balance Owed | balance_owed | money |
| User Profile Group | profile_group | text |
| Display Label | DB Name | Type |
|---|---|---|
| Library Circulation Location Link | circ_lib_id | org_unit |
| Circulation Type | circ_type | text |
| Copy Link | copy_id | link |
| Circ Modifier | circ_modifier | text |
| Item Language | language | text |
| Literary Form | lit_form | text |
| MARC Form | item_form | text |
| MARC Type | item_type | text |
| Shelving Location | shelving_location | text |
| Patron Profile Group | profile_group | text |
| Patron Age Demographic | demographic_general_division | text |
| Call Number Link | call_number | link |
| Call Number Label | call_number_label | text |
| Patron Link | patron_id | link |
| Patron Home Library Link | patron_home_lib | link |
| Patron County | patron_county | text |
| Patron City | patron_city | text |
| Patron ZIP Code | patron_zip | text |
| Legacy CAT1 Link | stat_cat_1 | link |
| Legacy CAT2 Link | stat_cat_2 | link |
| Legacy CAT1 Value | stat_cat_1_value | text |
| Legacy CAT2 Value | stat_cat_2_value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Circulation Type | type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Hold Request Type | hold_type | text |
| Target Bib Record | bib_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Circulating Library | circ_lib | org_unit |
| Owning Library | owning_lib | org_unit |
| Billing Types | billing_types | text |
| Balance | balance | money |
| Display Label | DB Name | Type |
|---|---|---|
| User Home Library | home_ou | org_unit |
| Owning Library | owning_lib | org_unit |
| Billing Types | billing_types | text |
| Balance | balance | money |
| Display Label | DB Name | Type |
|---|---|---|
| Owning Library | owning_lib | org_unit |
| Billing Types | billing_types | text |
| Balance | balance | money |
| Display Label | DB Name | Type |
|---|---|---|
| Circulation ID | id | link |
| Circulating Library | circ_lib | org_unit |
| Owning Library | owning_lib | org_unit |
| Billing Type | billing_type | text |
| Total Billed | billed | money |
| Display Label | DB Name | Type |
|---|---|---|
| Circulation ID | id | link |
| User Home Library | home_ou | org_unit |
| Owning Library | owning_lib | org_unit |
| Billing Type | billing_type | text |
| Total Billed | billed | money |
| Display Label | DB Name | Type |
|---|---|---|
| Circulation ID | id | link |
| Owning Library | owning_lib | org_unit |
| Billing Type | billing_type | text |
| Total Billed | billed | money |
| Display Label | DB Name | Type |
|---|---|---|
| Fingerprint | fingerprint | text |
| Overall Record Quality | quality | int |
| TCN Source | tcn_source | text |
| TCN Value | tcn_value | text |
| ISBN | isbn | text |
| ISSN | issn | text |
| Full Bibliographic record | biblio_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Title | title | text |
| Author | author | text |
| Pubdate | pubdate | text |
| Copy ID | id | id |
| Price | price | money |
| Barcode | barcode | text |
| Callnumber Label | call_number_label | text |
| Dewy Tens | dewey_block_tens | text |
| Dewy Hundreds | dewey_block_hundreds | text |
| Use Count | use_count | int |
| Circ Modifier | circ_modifier | text |
| Shelving Location Name | shelving_location | text |
| Legacy Stat Cat 1 | stat_cat_1 | text |
| Legacy Stat Cat 2 | stat_cat_2 | text |
| Legacy Stat Cat 1 Value | stat_cat_1_value | text |
| Legacy Stat Cat 2 Value | stat_cat_2_value | text |
| Edit Date | edit_date | timestamp |
| Create Date | create_date | timestamp |
| Owning Lib Name | owning_lib_name | text |
| Circ Lib Name | circ_lib_name | text |
| Owning Lib | owning_lib | link |
| Circ Lib | circ_lib | link |
| Creator | creator | link |
| Age Protection | age_protect | link |
| OPAC Visible | opac_visible | bool |
| Reference | ref | bool |
| Deposit Amount | deposit_amount | text |
| Deleted | deleted | bool |
| TCN | tcn_value | text |
| Status | status | link |
| Stop Fines Reason | stop_fines | text |
| Due Date | due_date | timestamp |
| Patron Barcode | patron_barcode | text |
| Patron Name | patron_name | text |
| Display Label | DB Name | Type |
|---|---|---|
| Check In Library | checkin_lib | org_unit |
| Check In Staff | checkin_staff | link |
| Circulating Library | circ_lib | org_unit |
| Circulating Staff | circ_staff | link |
| Desk Renewal | desk_renewal | bool |
| Circulation Duration | duration | interval |
| Circ Duration Rule | duration_rule | link |
| Fine Interval | fine_interval | interval |
| Max Fine Rule | max_fine_rule | link |
| OPAC Renewal | opac_renewal | bool |
| Phone Renewal | phone_renewal | bool |
| Recurring Fine Rule | recuring_fine_rule | link |
| Fine Stop Reason | stop_fines | text |
| Circulating Item | target_copy | link |
| Patron | usr | link |
| Transaction Billings | billings | link |
| Transaction Payments | payments | link |
| Base Transaction | billable_transaction | link |
| Circulation Type | circ_type | text |
| Billing Totals | billing_total | money |
| Payment Totals | payment_total | money |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | parent | link |
| Undefined | owner | link |
| Undefined | create_time | timestamp |
| Undefined | name | text |
| Undefined | shared | bool |
| Undefined | share_with | link |
| Undefined | children | link |
| Undefined | outputs | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | owner | link |
| Undefined | create_time | timestamp |
| Undefined | template | link |
| Undefined | data | link |
| Undefined | folder | link |
| Undefined | recur | bool |
| Undefined | recurance | interval |
| Undefined | name | text |
| Undefined | description | text |
| Undefined | runs | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | parent | link |
| Undefined | owner | link |
| Undefined | create_time | timestamp |
| Undefined | name | text |
| Undefined | shared | bool |
| Undefined | share_with | link |
| Undefined | children | link |
| Undefined | reports | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | runner | link |
| Undefined | start_time | timestamp |
| Undefined | complete_time | timestamp |
| Undefined | run_time | timestamp |
| Undefined | text | |
| Undefined | excel_format | bool |
| Undefined | csv_format | bool |
| Undefined | html_format | bool |
| Undefined | error_code | int |
| Undefined | error_text | text |
| Undefined | report | link |
| Undefined | folder | link |
| Undefined | chart_pie | bool |
| Undefined | chart_bar | bool |
| Undefined | chart_line | bool |
| Display Label | DB Name | Type |
|---|---|---|
| Entry Owner | owner | link |
| Entry Value | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Entry Owner | owner | link |
| Entry Value | value | text |
| Display Label | DB Name | Type |
|---|---|---|
| Metarecord | metarecord | link |
| Overall Record Quality | quality | int |
| TCN Source | tcn_source | text |
| TCN Value | tcn_value | text |
| ISBN | isbn | text |
| ISSN | issn | text |
| Full Bibliographic record | biblio_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Fingerprint | fingerprint | text |
| Overall Record Quality | quality | int |
| TCN Source | tcn_source | text |
| TCN Value | tcn_value | text |
| ISBN | isbn | text |
| ISSN | issn | text |
| Full Bibliographic record | biblio_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | owner | link |
| Undefined | create_time | timestamp |
| Undefined | name | text |
| Undefined | data | text |
| Undefined | folder | link |
| Undefined | description | text |
| Undefined | reports | link |
| Display Label | DB Name | Type |
|---|---|---|
| Undefined | parent | link |
| Undefined | owner | link |
| Undefined | create_time | timestamp |
| Undefined | name | text |
| Undefined | shared | bool |
| Undefined | share_with | link |
| Undefined | children | link |
| Undefined | templates | link |
| Display Label | DB Name | Type |
|---|---|---|
| Date of Birth | dob | timestamp |
| General Demographic Division | general_division | text |
| Display Label | DB Name | Type |
|---|---|---|
| Voided Billing Amount | voided | money |
| Total Billing Amount | total | money |
| Display Label | DB Name | Type |
|---|---|---|
| Total Paid Amount | total | money |
| Display Label | DB Name | Type |
|---|---|---|
| ID | id | id |
| Active | active | bool |
| Index Field | field | link |
| Bump Type | bump | text |
| Multiplier | multiplier | number |
| Display Label | DB Name | Type |
|---|---|---|
| Relevance | rel | float |
| Record | record | link |
| Checked | checked | int |
| Visible | visible | int |
| Deleted | deleted | int |
| Excluded | excluded | int |
| Display Label | DB Name | Type |
|---|---|---|
| Match ID | id | id |
| Queued Record | queued_record | link |
| Matched Attribute | field | link |
| Evergreen Record | eg_record | link |
| Display Label | DB Name | Type |
|---|---|---|
| Queue ID | id | id |
| Owner | owner | link |
| Complete | complete | bool |
| Type | queue_type | text |
| Purpose | queue_purpose | text |
| Display Label | DB Name | Type |
|---|---|---|
| Match ID | id | id |
| Queued Record | queued_record | link |
| Matched Attribute | field | link |
| Evergreen Record | eg_record | link |
| Field Type | field_type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Queue ID | id | id |
| Owner | owner | link |
| Complete | complete | bool |
| Type | queue_type | text |
| Display Label | DB Name | Type |
|---|---|---|
| Record ID | id | id |
| Create Time | create_time | timestamp |
| Import Time | import_time | timestamp |
| MARC | marc | text |
| Queue | queue | link |
| Final Target Record | imported_as | link |
| Purpose | purpose | text |
| Display Label | DB Name | Type |
|---|---|---|
| Attribute ID | id | id |
| Record | record | link |
| Field | field | link |
| Value | attr_value | text |
| Display Label | DB Name | Type |
|---|---|---|
| ID | id | id |
| Code | code | text |
| XPath | xpath | text |
| Remove RegExp | remove | text |
| Display Label | DB Name | Type |
|---|---|---|
| Record ID | id | id |
| Create Time | create_time | timestamp |
| Import Time | import_time | timestamp |
| MARC | marc | text |
| Queue | queue | link |
| Bib Source | bib_source | link |
| Final Target Record | imported_as | link |
| Purpose | purpose | text |
| Display Label | DB Name | Type |
|---|---|---|
| Attribute ID | id | id |
| Record | record | link |
| Field | field | link |
| Value | attr_value | text |
| Display Label | DB Name | Type |
|---|---|---|
| ID | id | id |
| Code | code | text |
| XPath | xpath | text |
| Remove RegExp | remove | text |