evergreen-user:reporting_data_dictionary
AC
| Display Label | DB Name | Type |
| Barcode | barcode | text |
| User | usr | link |
ACIRC
| 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 |
ACN
| 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 |
ACNN
| Display Label | DB Name | Type |
| Undefined | create_date | timestamp |
| Undefined | creator | link |
| Undefined | pub | bool |
| Undefined | title | text |
| Undefined | value | text |
ACP
| 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 |
ACPL
| Display Label | DB Name | Type |
| Location ID | id | id |
| Owning Org Unit | owning_lib | org_unit |
ACPN
| Display Label | DB Name | Type |
| Note Creator | creator | link |
| Copy | owning_copy | link |
| Note Title | title | text |
| Note Content | value | text |
ACTSC
| Display Label | DB Name | Type |
| Entries | entries | link |
| OPAC Visible | opac_visible | bool |
| Owning Library | owner | org_unit |
ACTSCE
| Display Label | DB Name | Type |
| Entry Owner | owner | link |
| Stat Cat | stat_cat | link |
| Entry Value | value | text |
ACTSCECM
| Display Label | DB Name | Type |
| Statistical Category | stat_cat | link |
| Entry Text | stat_cat_entry | text |
| User | target_usr | link |
AHCM
| Display Label | DB Name | Type |
| Undefined | hold | link |
| Undefined | target_copy | link |
AHN
| Display Label | DB Name | Type |
| Hold | hold | link |
| Notification Method | method | text |
| Notification Note | note | text |
| Notifying Staff | notify_staff | link |
AHR
| 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 |
AHTC
| 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 |
AIHU
| Display Label | DB Name | Type |
| Using Library | org_unit | org_unit |
| Recording Staff | staff | link |
AMTR
| Display Label | DB Name | Type |
| Matchpoint ID | matchpoint | id |
| Success | success | bool |
| Failure Part | fail_part | text |
ANCC
| Display Label | DB Name | Type |
| Circulating Library | circ_lib | org_unit |
| Patron | patron | link |
| Circulating Staff | staff | link |
AHCM
| Display Label | DB Name | Type |
| Undefined | hold | link |
| Undefined | target_copy | link |
AHN
| Display Label | DB Name | Type |
| Hold | hold | link |
| Notification Method | method | text |
| Notification Note | note | text |
| Notifying Staff | notify_staff | link |
AHR
| 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 |
AHTC
| 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 |
AIHU
| Display Label | DB Name | Type |
| Using Library | org_unit | org_unit |
| Recording Staff | staff | link |
AMTR
| Display Label | DB Name | Type |
| Matchpoint ID | matchpoint | id |
| Success | success | bool |
| Failure Part | fail_part | text |
ANCC
| Display Label | DB Name | Type |
| Circulating Library | circ_lib | org_unit |
| Patron | patron | link |
| Circulating Staff | staff | link |
ANCIHU
| Display Label | DB Name | Type |
| Item Type | item_type | link |
| Using Library | org_unit | org_unit |
| Recording Staff | staff | link |
AOA
| 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 |
AOC
| 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 |
AOU
| 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 | email | 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 |
AOUCD
| Display Label | DB Name | Type |
| Undefined | org_unit | org_unit |
| Undefined | reason | text |
AOUHOO
| Display Label | DB Name | Type |
| Undefined | org_unit | org_unit |
AOUP
| Display Label | DB Name | Type |
| Undefined | from_org | org_unit |
| Undefined | to_org | org_unit |
AOUS
| Display Label | DB Name | Type |
| Undefined | name | text |
| Undefined | org_unit | org_unit |
| Undefined | value | text |
AOUT
| Display Label | DB Name | Type |
| Subordinate Types | children | link |
| Type ID | id | id |
| Parent Type | parent | link |
| Org Units | org_units | org_unit |
ARE
| Display Label | DB Name | Type |
| Undefined | active | bool |
| Undefined | create_date | timestamp |
| Undefined | deleted | bool |
| Undefined | edit_date | timestamp |
ARN
| 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 |
ASC
| Display Label | DB Name | Type |
| Entries | entries | link |
| OPAC Visible | opac_visible | bool |
| Owning Library | owner | org_unit |
ASCE
| Display Label | DB Name | Type |
| Entry Owner | owner | link |
| Stat Cat | stat_cat | link |
ASCECM
| Display Label | DB Name | Type |
| Undefined | owning_copy | link |
| Undefined | stat_cat | link |
| Undefined | stat_cat_entry | link |
ASV
| 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 |
ASVA
| Display Label | DB Name | Type |
| Responses using this Answer | responses | link |
| Answer Text | answer | text |
| Question | question | link |
ASVQ
| Display Label | DB Name | Type |
| Answers | answers | link |
| Responses | responses | link |
| Question | question | text |
| Survey | survey | link |
ASVR
| Display Label | DB Name | Type |
| Answer | answer | link |
| Question | question | link |
| Survey | survey | link |
| Responding User | usr | link |
ARN
| 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 |
ASC
| Display Label | DB Name | Type |
| Entries | entries | link |
| OPAC Visible | opac_visible | bool |
| Owning Library | owner | org_unit |
ASCE
| Display Label | DB Name | Type |
| Entry Owner | owner | link |
| Stat Cat | stat_cat | link |
ASCECM
| Display Label | DB Name | Type |
| Undefined | owning_copy | link |
| Undefined | stat_cat | link |
| Undefined | stat_cat_entry | link |
ASV
| 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 |
ASVA
| Display Label | DB Name | Type |
| Responses using this Answer | responses | link |
| Answer Text | answer | text |
| Question | question | link |
ASVQ
| Display Label | DB Name | Type |
| Answers | answers | link |
| Responses | responses | link |
| Question | question | text |
| Survey | survey | link |
ASVR
| Display Label | DB Name | Type |
| Answer | answer | link |
| Question | question | link |
| Survey | survey | link |
| Responding User | usr | link |
ATC
| 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 |
AU
| 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 | email | 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 |
ATC
| 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 |
AU
| 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 | email | 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 |
AUA
| 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 |
AUFH
| Display Label | DB Name | Type |
| Hold | hold | link |
AUN
| Display Label | DB Name | Type |
| Creating Staff | creator | link |
| Note Title | title | text |
| Note Content | value | text |
AUOI
| Display Label | DB Name | Type |
| Workstation | opt_in_ws | link |
| Staff Member | staff | link |
| User | usr | link |
| Allowed Org Unit | org_unit | link |
AUS
| Display Label | DB Name | Type |
| Name | name | text |
| User | usr | link |
| Value | value | text |
AUSP
| Display Label | DB Name | Type |
| Undefined | penalty_type | text |
| Undefined | usr | link |
AWS
| Display Label | DB Name | Type |
| Workstation ID | id | id |
| Workstation Name | name | text |
| Owning Library | owning_lib | org_unit |
BRE
| 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 |
BREN
| 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 |
CAM
| Display Label | DB Name | Type |
| Audience Code | code | text |
CBLVL
| Display Label | DB Name | Type |
| Bib Level Code | code | text |
CBREB
| Display Label | DB Name | Type |
| Undefined | items | link |
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
CBREBI
| Display Label | DB Name | Type |
| Undefined | bucket | link |
| Undefined | target_biblio_record_entry | link |
CBS
| Display Label | DB Name | Type |
| Undefined | id | id |
| Undefined | source | text |
| Undefined | transcendant | bool |
CCB
| Display Label | DB Name | Type |
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
CCBI
| Display Label | DB Name | Type |
| Undefined | target_copy | link |
CCM
| Display Label | DB Name | Type |
| Code | code | id |
| Magnetic Media | magnetic_media | bool |
CCMCMT
| Display Label | DB Name | Type |
| Test ID | id | id |
| Matchpoint ID | matchpoint | link |
| Items Out | items_out | int |
| Circulation Modifier | circ_mod | link |
CCMM
| 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 |
CCMRS
| 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 |
CCMT
| 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 |
CCNB
| Display Label | DB Name | Type |
| Undefined | items | link |
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
CCNBI
| Display Label | DB Name | Type |
| Undefined | bucket | link |
CCS
| Display Label | DB Name | Type |
| Undefined | holdable | bool |
| Undefined | id | id |
| Undefined | opac_visible | bool |
CHMM
| 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 |
CHMT
| 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 |
CIFM
| Display Label | DB Name | Type |
| Item Form Code | code | text |
CIRC
| 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 |
CIT
| Display Label | DB Name | Type |
| Identification ID | id | id |
CITM
| Display Label | DB Name | Type |
| Item Type Code | code | text |
CLFM
| Display Label | DB Name | Type |
| LitF Code | code | text |
CLM
| Display Label | DB Name | Type |
| Language Code | code | text |
CMF
| Display Label | DB Name | Type |
| Undefined | name | text |
| Undefined | xpath | text |
| Undefined | format | link |
CNAL
| Display Label | DB Name | Type |
| Undefined | id | id |
| Undefined | name | text |
CNCT
| Display Label | DB Name | Type |
| Circulation Duration | circ_duration | interval |
| Owning Library | owning_lib | org_unit |
COMBCIRC
| 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 |
CRAHP
| Display Label | DB Name | Type |
| Item Age | age | interval |
| Rule ID | id | id |
| Rule Name | name | text |
CRCD
| Display Label | DB Name | Type |
| Undefined | extended | interval |
| Undefined | name | text |
| Undefined | normal | interval |
| Undefined | shrt | interval |
CRMF
| Display Label | DB Name | Type |
| Rule ID | id | id |
| Rule Name | name | text |
| Is Percent | is_percent | bool |
CRRF
| Display Label | DB Name | Type |
| Undefined | id | id |
| Undefined | name | text |
| Undefined | recurance_interval | interval |
CUB
| Display Label | DB Name | Type |
| Undefined | items | link |
| Undefined | btype | text |
| Undefined | name | text |
| Undefined | owner | link |
| Undefined | pub | bool |
CUBI
| Display Label | DB Name | Type |
| Undefined | bucket | link |
| Undefined | target_user | link |
CVRFM
| Display Label | DB Name | Type |
| Code | code | id |
CXT
| Display Label | DB Name | Type |
| Namespace URI | namespace_uri | text |
| Namespace Prefix | prefix | text |
I18N
| Display Label | DB Name | Type |
| Undefined | fq_field | text |
| Undefined | identity_value | text |
| Undefined | translation | text |
| Undefined | string | text |
I18N_L
| Display Label | DB Name | Type |
| Undefined | marc_code | text |
IATC
| 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 |
LASSO
| Display Label | DB Name | Type |
| Undefined | name | text |
LMAP
| Display Label | DB Name | Type |
| Undefined | lasso | link |
| Undefined | org_unit | org_unit |
MAFE
| Display Label | DB Name | Type |
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
MB
| 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 |
MBP
| 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 |
MBT
| 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 |
MBTS
| 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 |
MCCP
| 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 |
MCKP
| 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 |
MCP
| 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 |
MCRP
| 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 |
MCT
| Display Label | DB Name | Type |
| Undefined | enter_time | timestamp |
| Undefined | location | link |
| Undefined | usr | link |
MDP
| 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 |
MFP
| 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 |
MFR
| 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 |
MG
| 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 |
MGP
| 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 |
MKFE
| Display Label | DB Name | Type |
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
MMR
| Display Label | DB Name | Type |
| Undefined | fingerprint | text |
| Undefined | master_record | link |
| Undefined | mods | text |
| Undefined | source_records | link |
MMRSM
| Display Label | DB Name | Type |
| Undefined | metarecord | link |
| Undefined | source | link |
MNDP
| 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 |
MOBTS
| 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 |
MOUCS
| Display Label | DB Name | Type |
| Undefined | usr | link |
MOUS
| Display Label | DB Name | Type |
| Undefined | usr | link |
MP
| 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 |
MRD
| 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 |
MSEFE
| Display Label | DB Name | Type |
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
MSFE
| Display Label | DB Name | Type |
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
MTFE
| Display Label | DB Name | Type |
| Undefined | field | link |
| Undefined | source | link |
| Undefined | value | text |
MUCS
| Display Label | DB Name | Type |
| Undefined | usr | link |
MUS
| Display Label | DB Name | Type |
| Undefined | usr | link |
MWP
| 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 |
PGPM
| Display Label | DB Name | Type |
| Undefined | grantable | bool |
| Undefined | grp | link |
| Undefined | perm | link |
PGT
| 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 |
PPL
| Display Label | DB Name | Type |
| Undefined | code | text |
| Undefined | id | id |
PUOPM
| Display Label | DB Name | Type |
| Undefined | object_id | text |
| Undefined | grantable | bool |
| Undefined | perm | link |
| Undefined | usr | link |
| Undefined | object_type | text |
PUPM
| Display Label | DB Name | Type |
| Undefined | depth | int |
| Undefined | grantable | bool |
| Undefined | perm | link |
| Undefined | usr | link |
PUWOUM
| Display Label | DB Name | Type |
| Undefined | usr | link |
| Undefined | work_ou | link |
RCCBS
| 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 |
RCCC
| 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 |
RCIRCT
| Display Label | DB Name | Type |
| Circulation Type | type | text |
RHRR
| Display Label | DB Name | Type |
| Hold Request Type | hold_type | text |
| Target Bib Record | bib_record | link |
RMOBBCOL
| 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 |
RMOBBHOL
| 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 |
RMOBBOL
| Display Label | DB Name | Type |
| Owning Library | owning_lib | org_unit |
| Billing Types | billing_types | text |
| Balance | balance | money |
RMOCBBCOL
| 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 |
RMOCBBHOL
| 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 |
RMOCBBOL
| Display Label | DB Name | Type |
| Circulation ID | id | link |
| Owning Library | owning_lib | org_unit |
| Billing Type | billing_type | text |
| Total Billed | billed | money |
RMSR
| 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 |
ROCIT
| 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 |
RODCIRC
| 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 |
ROF
| 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 |
RR
| 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 |
RRF
| 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 |
RS
| Display Label | DB Name | Type |
| Undefined | runner | link |
| Undefined | start_time | timestamp |
| Undefined | complete_time | timestamp |
| Undefined | run_time | timestamp |
| Undefined | email | 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 |
RSCE1
| Display Label | DB Name | Type |
| Entry Owner | owner | link |
| Entry Value | value | text |
RSCE2
| Display Label | DB Name | Type |
| Entry Owner | owner | link |
| Entry Value | value | text |
RSR
| 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 |
RT
| 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 |
RTF
| 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 |
RUD
| Display Label | DB Name | Type |
| Date of Birth | dob | timestamp |
| General Demographic Division | general_division | text |
RXBT
| Display Label | DB Name | Type |
| Voided Billing Amount | voided | money |
| Total Billing Amount | total | money |
RXPT
| Display Label | DB Name | Type |
| Total Paid Amount | total | money |
SRA
| Display Label | DB Name | Type |
| ID | id | id |
| Active | active | bool |
| Index Field | field | link |
| Bump Type | bump | text |
| Multiplier | multiplier | number |
SSR
| Display Label | DB Name | Type |
| Relevance | rel | float |
| Record | record | link |
| Checked | checked | int |
| Visible | visible | int |
| Deleted | deleted | int |
| Excluded | excluded | int |
VAM
| Display Label | DB Name | Type |
| Match ID | id | id |
| Queued Record | queued_record | link |
| Matched Attribute | field | link |
| Evergreen Record | eg_record | link |
VAQ
| Display Label | DB Name | Type |
| Queue ID | id | id |
| Owner | owner | link |
| Complete | complete | bool |
| Type | queue_type | text |
| Purpose | queue_purpose | text |
VBM
| 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 |
VBQ
| Display Label | DB Name | Type |
| Queue ID | id | id |
| Owner | owner | link |
| Complete | complete | bool |
| Type | queue_type | text |
VQAR
| 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 |
VQARA
| Display Label | DB Name | Type |
| Attribute ID | id | id |
| Record | record | link |
| Field | field | link |
| Value | attr_value | text |
VQARAD
| Display Label | DB Name | Type |
| ID | id | id |
| Code | code | text |
| XPath | xpath | text |
| Remove RegExp | remove | text |
VQBR
| 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 |
VQBRA
| Display Label | DB Name | Type |
| Attribute ID | id | id |
| Record | record | link |
| Field | field | link |
| Value | attr_value | text |
VQBRAD
| Display Label | DB Name | Type |
| ID | id | id |
| Code | code | text |
| XPath | xpath | text |
| Remove RegExp | remove | text |
evergreen-user/reporting_data_dictionary.txt · Last modified: 2022/02/10 13:34 by 127.0.0.1
