User Tools

Site Tools


evergreen-user:reporting_data_dictionary

AC

Display Label DB Name Type
Barcodebarcodetext
Userusrlink

ACIRC

Display Label DB Name Type
Check In Librarycheckin_liborg_unit
Check In Staffcheckin_stafflink
Circulating Librarycirc_liborg_unit
Circulating Staffcirc_stafflink
Desk Renewaldesk_renewalbool
Circulation Durationdurationinterval
Circ Duration Ruleduration_rulelink
Fine Intervalfine_intervalinterval
Max Fine Rulemax_fine_rulelink
OPAC Renewalopac_renewalbool
Phone Renewalphone_renewalbool
Recurring Fine Rulerecuring_fine_rulelink
Fine Stop Reasonstop_finestext
Circulating Itemtarget_copylink
Patron ZIPusr_post_codetext
Transaction Billingsbillingslink
Transaction Paymentspaymentslink
Base Transactionbillable_transactionlink
Circulation Typecirc_typetext
Billing Totalsbilling_totalmoney
Payment Totalspayment_totalmoney
Patron Home Libraryusr_home_oulink
Patron Profile Groupusr_profilelink
Patron Birth Yearusr_birth_yearint
Call Numbercopy_call_numberlink
Shelving Locationcopy_locationlink
Copy Owning Librarycopy_owning_liblink
Copy Circulating Librarycopy_circ_liblink
Bib Recordcopy_bib_recordlink

ACN

Display Label DB Name Type
Copiescopieslink
Creating Usercreatorlink
Is Deleteddeletedbool
Last Editing Usereditorlink
Call Number Labellabeltext
Owning Libraryowning_liborg_unit
Bib Recordrecordlink
Notesnoteslink

ACNN

Display Label DB Name Type
Undefinedcreate_datetimestamp
Undefinedcreatorlink
Undefinedpubbool
Undefinedtitletext
Undefinedvaluetext

ACP

Display Label DB Name Type
Statistical Catagory Entriesstat_cat_entrieslink
Age Hold Protectionage_protectlink
Alert Messagealert_messagetext
Barcodebarcodetext
Circulating Librarycirc_liborg_unit
Circulation Modifiercirc_modifiertext
Can Circulatecirculatebool
Copy Number on Volumecopy_numbertext
Creating Usercreatorlink
Is Deleteddeletedbool
Is Deposit Requireddepositbool
Precat Dummy Authordummy_authortext
Precat Dummy Titledummy_titletext
Last Editing Usereditorlink
Fine Levelfine_levelint
Copy IDidid
Loan Durationloan_durationint
Shelving Locationlocationlink
Is Referencerefbool
Copy Statusstatuslink
Copy Notesnoteslink
Circulationscirculationslink
Total Circulationstotal_circ_countlink
Holdsholdslink

ACPL

Display Label DB Name Type
Location IDidid
Owning Org Unitowning_liborg_unit

ACPN

Display Label DB Name Type
Note Creatorcreatorlink
Copyowning_copylink
Note Titletitletext
Note Contentvaluetext

ACTSC

Display Label DB Name Type
Entriesentrieslink
OPAC Visibleopac_visiblebool
Owning Libraryownerorg_unit

ACTSCE

Display Label DB Name Type
Entry Ownerownerlink
Stat Catstat_catlink
Entry Valuevaluetext

ACTSCECM

Display Label DB Name Type
Statistical Categorystat_catlink
Entry Textstat_cat_entrytext
Usertarget_usrlink

AHCM

Display Label DB Name Type
Undefinedholdlink
Undefinedtarget_copylink

AHN

Display Label DB Name Type
Holdholdlink
Notification Methodmethodtext
Notification Notenotetext
Notifying Staffnotify_stafflink

AHR

Display Label DB Name Type
Fulfilling Libraryfulfillment_liborg_unit
Hold Typehold_typetext
Notifications Phone Numberphone_notifytext
Pickup Librarypickup_liborg_unit
Requesting Libraryrequest_liborg_unit
Requesting Userrequestorlink
Selection Locusselection_ouorg_unit
Target Object IDtargetlink
Hold Userusrlink
Notificationsnotify_timetimestamp
Bib Record linknotificationslink
Eligible Copiesbib_reclink
Currently Frozeneligible_copieslink
Undefinedfrozenbool

AHTC

Display Label DB Name Type
Copy Status at Transitcopy_statuslink
Destination Librarydestorg_unit
Hold requiring Transitholdlink
Previous Stopprev_hoplink
Sending Librarysourceorg_unit
Transited Copytarget_copylink
Base Transittransit_copylink

AIHU

Display Label DB Name Type
Using Libraryorg_unitorg_unit
Recording Staffstafflink

AMTR

Display Label DB Name Type
Matchpoint IDmatchpointid
Successsuccessbool
Failure Partfail_parttext

ANCC

Display Label DB Name Type
Circulating Librarycirc_liborg_unit
Patronpatronlink
Circulating Staffstafflink

AHCM

Display Label DB Name Type
Undefinedholdlink
Undefinedtarget_copylink

AHN

Display Label DB Name Type
Holdholdlink
Notification Methodmethodtext
Notification Notenotetext
Notifying Staffnotify_stafflink

AHR

Display Label DB Name Type
Fulfilling Libraryfulfillment_liborg_unit
Hold Typehold_typetext
Notifications Phone Numberphone_notifytext
Pickup Librarypickup_liborg_unit
Requesting Libraryrequest_liborg_unit
Requesting Userrequestorlink
Selection Locusselection_ouorg_unit
Target Object IDtargetlink
Hold Userusrlink
Notificationsnotify_timetimestamp
Bib Record linknotificationslink
Eligible Copiesbib_reclink
Currently Frozeneligible_copieslink
Undefinedfrozenbool

AHTC

Display Label DB Name Type
Copy Status at Transitcopy_statuslink
Destination Librarydestorg_unit
Hold requiring Transitholdlink
Previous Stopprev_hoplink
Sending Librarysourceorg_unit
Transited Copytarget_copylink
Base Transittransit_copylink

AIHU

Display Label DB Name Type
Using Libraryorg_unitorg_unit
Recording Staffstafflink

AMTR

Display Label DB Name Type
Matchpoint IDmatchpointid
Successsuccessbool
Failure Partfail_parttext

ANCC

Display Label DB Name Type
Circulating Librarycirc_liborg_unit
Patronpatronlink
Circulating Staffstafflink

ANCIHU

Display Label DB Name Type
Item Typeitem_typelink
Using Libraryorg_unitorg_unit
Recording Staffstafflink

AOA

Display Label DB Name Type
Undefinedaddress_typetext
Undefinedcitytext
Undefinedcountrytext
Undefinedcountytext
Undefinedorg_unitorg_unit
Undefinedpost_codetext
Undefinedstatetext
Undefinedstreet1text
Undefinedstreet2text
Undefinedvalidbool

AOC

Display Label DB Name Type
Undefinedcheckin_liblink
Undefinedcheckin_stafflink
Undefinedcheckin_timetimestamp
Undefinedcirc_liborg_unit
Undefinedcirc_stafflink
Undefineddesk_renewalbool
Undefineddue_datetimestamp
Undefineddurationinterval
Undefinedduration_rulelink
Undefinedfine_intervalinterval
Undefinedmax_fine_rulelink
Undefinedopac_renewalbool
Undefinedphone_renewalbool
Undefinedrecuring_fine_rulelink
Undefinedstop_finestext
Undefinedstop_fines_timetimestamp
Undefinedtarget_copylink
Undefinedusrlink
Undefinedcirculationlink

AOU

Display Label DB Name Type
Subordinate Organizational Unitschildrenorg_unit
Billing Addressbilling_addresslink
Holds Receiving Addressholds_addresslink
Organizational Unit IDidorg_unit
ILL Receiving Addressill_addresslink
Mailing Addressmailing_addresslink
Organizational Unit Typeou_typelink
Parent Organizational Unitparent_oulink
Email Addressemailtext
Phone Numberphonetext
OPAC Visibleopac_visiblebool
Usersuserslink
Closed Datesclosed_dateslink
Circulationscirculationslink
Settingssettingslink
Addressesaddresseslink
Checkinscheckinslink
Workstationsworkstationslink

AOUCD

Display Label DB Name Type
Undefinedorg_unitorg_unit
Undefinedreasontext

AOUHOO

Display Label DB Name Type
Undefinedorg_unitorg_unit

AOUP

Display Label DB Name Type
Undefinedfrom_orgorg_unit
Undefinedto_orgorg_unit

AOUS

Display Label DB Name Type
Undefinednametext
Undefinedorg_unitorg_unit
Undefinedvaluetext

AOUT

Display Label DB Name Type
Subordinate Typeschildrenlink
Type IDidid
Parent Typeparentlink
Org Unitsorg_unitsorg_unit

ARE

Display Label DB Name Type
Undefinedactivebool
Undefinedcreate_datetimestamp
Undefineddeletedbool
Undefinededit_datetimestamp

ARN

Display Label DB Name Type
Undefinedcreate_datetimestamp
Undefinedcreatorlink
Undefinededit_datetimestamp
Undefinededitorlink
Undefinedrecordlink
Undefinedvaluetext

ASC

Display Label DB Name Type
Entriesentrieslink
OPAC Visibleopac_visiblebool
Owning Libraryownerorg_unit

ASCE

Display Label DB Name Type
Entry Ownerownerlink
Stat Catstat_catlink

ASCECM

Display Label DB Name Type
Undefinedowning_copylink
Undefinedstat_catlink
Undefinedstat_cat_entrylink

ASV

Display Label DB Name Type
Questionsquestionslink
Responsesresponseslink
Descriptiondescriptiontext
Survey IDidid
Namenametext
Owning Libraryownerorg_unit
Display in User Summaryusr_summarybool

ASVA

Display Label DB Name Type
Responses using this Answerresponseslink
Answer Textanswertext
Questionquestionlink

ASVQ

Display Label DB Name Type
Answersanswerslink
Responsesresponseslink
Questionquestiontext
Surveysurveylink

ASVR

Display Label DB Name Type
Answeranswerlink
Questionquestionlink
Surveysurveylink
Responding Userusrlink

ARN

Display Label DB Name Type
Undefinedcreate_datetimestamp
Undefinedcreatorlink
Undefinededit_datetimestamp
Undefinededitorlink
Undefinedrecordlink
Undefinedvaluetext

ASC

Display Label DB Name Type
Entriesentrieslink
OPAC Visibleopac_visiblebool
Owning Libraryownerorg_unit

ASCE

Display Label DB Name Type
Entry Ownerownerlink
Stat Catstat_catlink

ASCECM

Display Label DB Name Type
Undefinedowning_copylink
Undefinedstat_catlink
Undefinedstat_cat_entrylink

ASV

Display Label DB Name Type
Questionsquestionslink
Responsesresponseslink
Descriptiondescriptiontext
Survey IDidid
Namenametext
Owning Libraryownerorg_unit
Display in User Summaryusr_summarybool

ASVA

Display Label DB Name Type
Responses using this Answerresponseslink
Answer Textanswertext
Questionquestionlink

ASVQ

Display Label DB Name Type
Answersanswerslink
Responsesresponseslink
Questionquestiontext
Surveysurveylink

ASVR

Display Label DB Name Type
Answeranswerlink
Questionquestionlink
Surveysurveylink
Responding Userusrlink

ATC

Display Label DB Name Type
Pretransit Copy Statuscopy_statusbool
Destinationdestlink
Transit IDidid
Sourcesourcelink
Transited Copytarget_copylink
Hold Transithold_transit_copylink

AU

Display Label DB Name Type
All Addressesaddresseslink
All Library Cardscardslink
All Circulationscheckoutslink
All Hold Requestshold_requestslink
All Permissionspermissionslink
All User Settingssettingslink
Standing Penaltiesstanding_penaltieslink
Statistical Category Entriesstat_cat_entrieslink
Survey Responsessurvey_responseslink
Activews_oulink
Alert Messagewsidlink
Barredactivebool
Physical Addressalert_messagetext
Current Library Cardbarredbool
Daytime Phonebilling_addresslink
Date of Birthcardlink
Email Addressday_phonetext
Evening Phonedobtimestamp
Privilege Expiration Dateemailtext
Last Nameevening_phonetext
First Nameexpire_datetimestamp
Home Libraryfamily_nametext
Primary Identification Typefirst_given_nametext
Secondary Identification Typehome_ouorg_unit
Primary Identificationident_typelink
Secondary Identificationident_type2link
Mailing Addressident_valuetext
Is Group Lead Accountident_value2text
Internet Access Levellast_xact_idtext
Other Phonemailing_addresslink
Photo URLmaster_accountbool
Prefixnet_access_levellink
Middle Nameother_phonetext
Is Super Userphoto_urltext
Family Linkage or other Groupprefixtext
Additional Permission Groupssecond_given_nametext
Is Deletedsuper_userbool
User Notesusrgroupint
Demographic Infogroupslink
Billable Transactionsdeletedbool
Checkinsnoteslink
Circulations Performed as Staffdemographiclink
Undefinedbillable_transactionslink
Undefinedcheckinslink
Undefinedperformed_circulationslink

ATC

Display Label DB Name Type
Pretransit Copy Statuscopy_statusbool
Destinationdestlink
Transit IDidid
Sourcesourcelink
Transited Copytarget_copylink
Hold Transithold_transit_copylink

AU

Display Label DB Name Type
All Addressesaddresseslink
All Library Cardscardslink
All Circulationscheckoutslink
All Hold Requestshold_requestslink
All Permissionspermissionslink
All User Settingssettingslink
Standing Penaltiesstanding_penaltieslink
Statistical Category Entriesstat_cat_entrieslink
Survey Responsessurvey_responseslink
Activews_oulink
Alert Messagewsidlink
Barredactivebool
Physical Addressalert_messagetext
Current Library Cardbarredbool
Daytime Phonebilling_addresslink
Date of Birthcardlink
Email Addressday_phonetext
Evening Phonedobtimestamp
Privilege Expiration Dateemailtext
Last Nameevening_phonetext
First Nameexpire_datetimestamp
Home Libraryfamily_nametext
Primary Identification Typefirst_given_nametext
Secondary Identification Typehome_ouorg_unit
Primary Identificationident_typelink
Secondary Identificationident_type2link
Mailing Addressident_valuetext
Is Group Lead Accountident_value2text
Internet Access Levellast_xact_idtext
Other Phonemailing_addresslink
Photo URLmaster_accountbool
Prefixnet_access_levellink
Middle Nameother_phonetext
Is Super Userphoto_urltext
Family Linkage or other Groupprefixtext
Additional Permission Groupssecond_given_nametext
Is Deletedsuper_userbool
User Notesusrgroupint
Demographic Infogroupslink
Billable Transactionsdeletedbool
Checkinsnoteslink
Circulations Performed as Staffdemographiclink
Undefinedbillable_transactionslink
Undefinedcheckinslink
Undefinedperformed_circulationslink

AUA

Display Label DB Name Type
Typeaddress_typetext
Citycitytext
Countrycountrytext
Countycountytext
Postal Codepost_codetext
Statestatetext
Userusrlink

AUFH

Display Label DB Name Type
Holdholdlink

AUN

Display Label DB Name Type
Creating Staffcreatorlink
Note Titletitletext
Note Contentvaluetext

AUOI

Display Label DB Name Type
Workstationopt_in_wslink
Staff Memberstafflink
Userusrlink
Allowed Org Unitorg_unitlink

AUS

Display Label DB Name Type
Namenametext
Userusrlink
Valuevaluetext

AUSP

Display Label DB Name Type
Undefinedpenalty_typetext
Undefinedusrlink

AWS

Display Label DB Name Type
Workstation IDidid
Workstation Namenametext
Owning Libraryowning_liborg_unit

BRE

Display Label DB Name Type
Call Numberscall_numberslink
Fixed Field Entryfixed_fieldslink
Record Creatorcreatorlink
Last Editing Usereditorlink
Fingerprintfingerprinttext
Last Transaction IDlast_xact_idtext
MARC21Slimmarctext
Record Sourcesourcelink
TCN Sourcetcn_sourcetext
TCN Valuetcn_valuetext
Metarecordmetarecordlink
Language Codelanguagelink
Indexed Keyword Field Entrieskeyword_field_entrieslink
Indexed Subject Field Entriessubject_field_entrieslink
Indexed Title Field Entriestitle_field_entrieslink
Indexed Author Field Entriesauthor_field_entrieslink
Indexed Series Field Entriesseries_field_entrieslink
Flattened MARC Fields full_record_entrieslink
Simple Record Extracts simple_recordlink

BREN

Display Label DB Name Type
Undefinedcreate_datetimestamp
Undefinedcreatorlink
Undefinededit_datetimestamp
Undefinededitorlink
Undefinedpubbool
Undefinedrecordlink
Undefinedvaluetext

CAM

Display Label DB Name Type
Audience Codecodetext

CBLVL

Display Label DB Name Type
Bib Level Codecodetext

CBREB

Display Label DB Name Type
Undefineditemslink
Undefinedbtypetext
Undefinednametext
Undefinedownerlink
Undefinedpubbool

CBREBI

Display Label DB Name Type
Undefinedbucketlink
Undefinedtarget_biblio_record_entrylink

CBS

Display Label DB Name Type
Undefinedidid
Undefinedsourcetext
Undefinedtranscendantbool

CCB

Display Label DB Name Type
Undefinedbtypetext
Undefinednametext
Undefinedownerlink
Undefinedpubbool

CCBI

Display Label DB Name Type
Undefinedtarget_copylink

CCM

Display Label DB Name Type
Codecodeid
Magnetic Mediamagnetic_mediabool

CCMCMT

Display Label DB Name Type
Test IDidid
Matchpoint IDmatchpointlink
Items Outitems_outint
Circulation Modifiercirc_modlink

CCMM

Display Label DB Name Type
Matchpoint IDidid
Org Unitorg_unitlink
Permission Groupgrplink
Circulation Modifiercirc_modifierlink
MARC Typemarc_typelink
MARC Formmarc_formlink
Videorecording Formatmarc_vr_formatlink

CCMRS

Display Label DB Name Type
Matchpoint IDmatchpointid
Duration Ruleduration_rulelink
Recurring Fine Rulerecurring_fine_rulelink
Max Fine Rulemax_fine_rulelink

CCMT

Display Label DB Name Type
Matchpoint IDmatchpointid
Max Items Outmax_items_outint
Max Overduemax_overdueint
Max Finesmax_finesmoney
Test Scriptscript_testtext

CCNB

Display Label DB Name Type
Undefineditemslink
Undefinedbtypetext
Undefinednametext
Undefinedownerlink
Undefinedpubbool

CCNBI

Display Label DB Name Type
Undefinedbucketlink

CCS

Display Label DB Name Type
Undefinedholdablebool
Undefinedidid
Undefinedopac_visiblebool

CHMM

Display Label DB Name Type
Matchpoint IDidid
User Home Libraryuser_home_oulink
Request Libraryrequest_oulink
Pickup Librarypickup_oulink
Owning Libraryitem_owning_oulink
Item Circ Libraryitem_circ_oulink
User Permission Groupusr_grplink
Requestor Permission Grouprequestor_grplink
Circulation Modifiercirc_modifierlink
MARC Typemarc_typelink
MARC Formmarc_formlink
Videorecording Formatmarc_vr_formatlink

CHMT

Display Label DB Name Type
Matchpoint IDmatchpointlink
Transit Rangetransit_rangeint
Max Holdsmax_holdsint
Max includes Frozeninclude_frozen_holdsbool
Copy Age Hold Protection Ruleage_hold_protect_rulelink

CIFM

Display Label DB Name Type
Item Form Codecodetext

CIRC

Display Label DB Name Type
Check In Librarycheckin_liborg_unit
Check In Staffcheckin_stafflink
Circulating Librarycirc_liborg_unit
Circulating Staffcirc_stafflink
Desk Renewaldesk_renewalbool
Circulation Durationdurationinterval
Circ Duration Ruleduration_rulelink
Fine Intervalfine_intervalinterval
Max Fine Rulemax_fine_rulelink
OPAC Renewalopac_renewalbool
Phone Renewalphone_renewalbool
Recurring Fine Rulerecuring_fine_rulelink
Fine Stop Reasonstop_finestext
Circulating Itemtarget_copylink
Patronusrlink
Transaction Billingsbillingslink
Transaction Paymentspaymentslink
Base Transactionbillable_transactionlink
Circulation Typecirc_typetext
Billing Totalsbilling_totalmoney
Payment Totalspayment_totalmoney

CIT

Display Label DB Name Type
Identification IDidid

CITM

Display Label DB Name Type
Item Type Codecodetext

CLFM

Display Label DB Name Type
LitF Codecodetext

CLM

Display Label DB Name Type
Language Codecodetext

CMF

Display Label DB Name Type
Undefinednametext
Undefinedxpathtext
Undefinedformatlink

CNAL

Display Label DB Name Type
Undefinedidid
Undefinednametext

CNCT

Display Label DB Name Type
Circulation Durationcirc_durationinterval
Owning Libraryowning_liborg_unit

COMBCIRC

Display Label DB Name Type
Check In Librarycheckin_liborg_unit
Check In Staffcheckin_stafflink
Circulating Librarycirc_liborg_unit
Circulating Staffcirc_stafflink
Desk Renewaldesk_renewalbool
Circulation Durationdurationinterval
Circ Duration Ruleduration_rulelink
Fine Intervalfine_intervalinterval
Max Fine Rulemax_fine_rulelink
OPAC Renewalopac_renewalbool
Phone Renewalphone_renewalbool
Recurring Fine Rulerecuring_fine_rulelink
Fine Stop Reasonstop_finestext
Circulating Itemtarget_copylink
Patron ZIPusr_post_codetext
Transaction Billingsbillingslink
Transaction Paymentspaymentslink
Base Transactionbillable_transactionlink
Circulation Typecirc_typetext
Billing Totalsbilling_totalmoney
Payment Totalspayment_totalmoney
Patron Home Libraryusr_home_oulink
Patron Profile Groupusr_profilelink
Patron Birth Yearusr_birth_yearint
Call Numbercopy_call_numberlink
Shelving Locationcopy_locationlink
Copy Owning Librarycopy_owning_liblink
Copy Circulating Librarycopy_circ_liblink
Bib Recordcopy_bib_recordlink

CRAHP

Display Label DB Name Type
Item Ageageinterval
Rule IDidid
Rule Namenametext

CRCD

Display Label DB Name Type
Undefinedextendedinterval
Undefinednametext
Undefinednormalinterval
Undefinedshrtinterval

CRMF

Display Label DB Name Type
Rule IDidid
Rule Namenametext
Is Percentis_percentbool

CRRF

Display Label DB Name Type
Undefinedidid
Undefinednametext
Undefinedrecurance_intervalinterval

CUB

Display Label DB Name Type
Undefineditemslink
Undefinedbtypetext
Undefinednametext
Undefinedownerlink
Undefinedpubbool

CUBI

Display Label DB Name Type
Undefinedbucketlink
Undefinedtarget_userlink

CVRFM

Display Label DB Name Type
Codecodeid

CXT

Display Label DB Name Type
Namespace URInamespace_uritext
Namespace Prefixprefixtext

I18N

Display Label DB Name Type
Undefinedfq_fieldtext
Undefinedidentity_valuetext
Undefinedtranslationtext
Undefinedstringtext

I18N_L

Display Label DB Name Type
Undefinedmarc_codetext

IATC

Display Label DB Name Type
Pretransit Copy Statuscopy_statusbool
Destinationdestlink
Transit IDidid
Sourcesourcelink
Transited Copytarget_copylink
Hold Transithold_transit_copylink

LASSO

Display Label DB Name Type
Undefinednametext

LMAP

Display Label DB Name Type
Undefinedlassolink
Undefinedorg_unitorg_unit

MAFE

Display Label DB Name Type
Undefinedfieldlink
Undefinedsourcelink
Undefinedvaluetext

MB

Display Label DB Name Type
Billing Timestampbilling_tstimestamp
Billing Typebilling_typetext
Notenotetext
Void Timestampvoid_timetimestamp
Voiding Staff Membervoiderlink
Transactionxactlink

MBP

Display Label DB Name Type
Notenotetext
Payment Typepayment_typetext
Billable Transactionxactlink
Cash Payment Detailcash_paymentlink
Credit Card Payment Detailcredit_card_paymentlink
Credit Payment Detailcredit_paymentlink
Check Payment Detailcheck_paymentlink
Work Payment Detailwork_paymentlink
Forgive Payment Detailforgive_paymentlink
Goods Payment Detailgoods_paymentlink

MBT

Display Label DB Name Type
Userusrlink
Grocery Billing linkgrocerylink
Circulation Billing linkcirculationlink
Billing Line Itemsbillingslink
Payment Line Itemspaymentslink
Billing Totalsbilling_totalmoney
Payment Totalspayment_totalmoney

MBTS

Display Label DB Name Type
Balance Owedbalance_owedmoney
Transaction IDidid
Last Billing Notelast_billing_notetext
Last Billing Timestamplast_billing_tstimestamp
Last Billing Typelast_billing_typetext
Last Payment Notelast_payment_notetext
Last Payment Timestamplast_payment_tstimestamp
Last Payment Typelast_payment_typetext
Total Owedtotal_owedmoney
Total Paidtotal_paidmoney
Billed Userusrlink
Transaction Typexact_typetext

MCCP

Display Label DB Name Type
Undefinedapproval_codetext
Undefinedcash_drawerlink
Undefinedcc_numbertext
Undefinedcc_typetext
Undefinednotetext
Undefinedpayment_tstimestamp
Undefinedxactlink
Undefinedpayment_typetext
Undefinedpaymentlink

MCKP

Display Label DB Name Type
Accepting Staff Memberaccepting_usrlink
Workstation linkcash_drawerlink
Notenotetext
Payment Timestamppayment_tstimestamp
Transaction linkxactlink
Payment linkpaymentlink
Payment Typepayment_typetext

MCP

Display Label DB Name Type
Undefinedaccepting_usrlink
Undefinedcash_drawerlink
Undefinednotetext
Undefinedpayment_tstimestamp
Undefinedxactlink
Undefinedpayment_typetext
Undefinedpaymentlink

MCRP

Display Label DB Name Type
Accepting Staff Memberaccepting_usrlink
Payment Notenotetext
Payment Timestamppayment_tstimestamp
Transactionxactlink
Payment Typepayment_typetext
Payment linkpaymentlink

MCT

Display Label DB Name Type
Undefinedenter_timetimestamp
Undefinedlocationlink
Undefinedusrlink

MDP

Display Label DB Name Type
Notenotetext
Payment Typepayment_typetext
Billable Transactionxactlink
Cash Drawercash_drawerlink
Cash Paymentcash_paymentlink
Credit Card Paymentcredit_card_paymentlink
Check Paymentcheck_paymentlink

MFP

Display Label DB Name Type
Undefinedaccepting_usrlink
Undefinednotetext
Undefinedpayment_tstimestamp
Undefinedxactlink
Undefinedpayment_typetext
Undefinedpaymentlink

MFR

Display Label DB Name Type
Indicator 1ind1text
Indicator 2ind2text
Bib Record Entryrecordlink
Subfieldsubfieldtext
Tagtagtext
Normalized Valuevaluetext

MG

Display Label DB Name Type
Billing Locationbilling_locationlink
Notenotetext
Userusrlink
Billingsbillingslink
Paymentspaymentslink
Billable Transaction linkbillable_transactionlink
Billing Totalsbilling_totalmoney
Payment Totalspayment_totalmoney

MGP

Display Label DB Name Type
Accepting Staff Memberaccepting_usrlink
Notenotetext
Payment Timestamppayment_tstimestamp
Transaction IDxactlink
Payment linkpaymentlink
Payment Typepayment_typetext

MKFE

Display Label DB Name Type
Undefinedfieldlink
Undefinedsourcelink
Undefinedvaluetext

MMR

Display Label DB Name Type
Undefinedfingerprinttext
Undefinedmaster_recordlink
Undefinedmodstext
Undefinedsource_recordslink

MMRSM

Display Label DB Name Type
Undefinedmetarecordlink
Undefinedsourcelink

MNDP

Display Label DB Name Type
Notenotetext
Payment Typepayment_typetext
Billable Transactionxactlink
Work Payment Detailwork_paymentlink
Forgive Payment Detailforgive_paymentlink
Goods Payment Detailgoods_paymentlink

MOBTS

Display Label DB Name Type
Undefinedbalance_owedmoney
Undefinedlast_billing_notetext
Undefinedlast_billing_tstimestamp
Undefinedlast_billing_typetext
Undefinedlast_payment_notetext
Undefinedlast_payment_tstimestamp
Undefinedlast_payment_typetext
Undefinedtotal_owedmoney
Undefinedtotal_paidmoney
Undefinedusrlink
Undefinedxact_typetext
Undefinedxactlink
Undefinedgrocerylink
Undefinedcirculationlink
Undefinedbilling_locationlink

MOUCS

Display Label DB Name Type
Undefinedusrlink

MOUS

Display Label DB Name Type
Undefinedusrlink

MP

Display Label DB Name Type
Notenotetext
Payment Typepayment_typetext
Billable Transactionxactlink
Cash Payment Detailcash_paymentlink
Credit Card Payment Detailcredit_card_paymentlink
Credit Payment Detailcredit_paymentlink
Check Payment Detailcheck_paymentlink
Work Payment Detailwork_paymentlink
Forgive Payment Detailforgive_paymentlink
Goods Payment Detailgoods_paymentlink

MRD

Display Label DB Name Type
Audnaudiencetext
BLvlbib_leveltext
Cat Formcat_formtext
Character Encodingchar_encodingtext
Ctrlcontrol_typetext
ELvlenc_leveltext
Formitem_formtext
Langitem_langtext
Typeitem_typetext
LitFlit_formtext
Pub Statuspub_statustext
Bib Record Entryrecordlink
TMattype_mattext
Video Recording Formatvr_formattext
Date1date1text
Date2date2text

MSEFE

Display Label DB Name Type
Undefinedfieldlink
Undefinedsourcelink
Undefinedvaluetext

MSFE

Display Label DB Name Type
Undefinedfieldlink
Undefinedsourcelink
Undefinedvaluetext

MTFE

Display Label DB Name Type
Undefinedfieldlink
Undefinedsourcelink
Undefinedvaluetext

MUCS

Display Label DB Name Type
Undefinedusrlink

MUS

Display Label DB Name Type
Undefinedusrlink

MWP

Display Label DB Name Type
Accepting Staff Memberaccepting_usrlink
Notenotetext
Payment Timestamppayment_tstimestamp
Transaction IDxactlink
Payment linkpaymentlink
Payment Typepayment_typetext

PGPM

Display Label DB Name Type
Undefinedgrantablebool
Undefinedgrplink
Undefinedpermlink

PGT

Display Label DB Name Type
Child Groupschildrenlink
Group IDidid
Parent Groupparentlink
User Expiration Intervalperm_intervalinterval
Required Permissionapplication_permtext
Is User Groupusergroupbool

PPL

Display Label DB Name Type
Undefinedcodetext
Undefinedidid

PUOPM

Display Label DB Name Type
Undefinedobject_idtext
Undefinedgrantablebool
Undefinedpermlink
Undefinedusrlink
Undefinedobject_typetext

PUPM

Display Label DB Name Type
Undefineddepthint
Undefinedgrantablebool
Undefinedpermlink
Undefinedusrlink

PUWOUM

Display Label DB Name Type
Undefinedusrlink
Undefinedwork_oulink

RCCBS

Display Label DB Name Type
Billing Location Namebilling_location_nametext
Billing Location Linkbilling_locationorg_unit
User Home Library Nameusr_home_ou_nametext
User Home Library Linkusr_home_ouorg_unit
User Barcodebarcodetext
User Linkusrlink
Transaction Typexact_typetext
Total Paidtotal_paidmoney
Total Billedtotal_owedmoney
Last Payment Notelast_payment_notetext
Last Payment Typelast_payment_typetext
Last Billing Notelast_billing_notetext
Last Billing Typelast_billing_typetext
User Age Demographicdemographic_general_divisiontext
User Countypatron_countytext
User Citypatron_citytext
User ZIP Codepatron_ziptext
Balance Owedbalance_owedmoney
User Profile Groupprofile_grouptext

RCCC

Display Label DB Name Type
Library Circulation Location Linkcirc_lib_idorg_unit
Circulation Typecirc_typetext
Copy Linkcopy_idlink
Circ Modifiercirc_modifiertext
Item Languagelanguagetext
Literary Formlit_formtext
MARC Formitem_formtext
MARC Typeitem_typetext
Shelving Locationshelving_locationtext
Patron Profile Groupprofile_grouptext
Patron Age Demographicdemographic_general_divisiontext
Call Number Linkcall_numberlink
Call Number Labelcall_number_labeltext
Patron Linkpatron_idlink
Patron Home Library Linkpatron_home_liblink
Patron Countypatron_countytext
Patron Citypatron_citytext
Patron ZIP Codepatron_ziptext
Legacy CAT1 Linkstat_cat_1link
Legacy CAT2 Linkstat_cat_2link
Legacy CAT1 Valuestat_cat_1_valuetext
Legacy CAT2 Valuestat_cat_2_valuetext

RCIRCT

Display Label DB Name Type
Circulation Typetypetext

RHRR

Display Label DB Name Type
Hold Request Typehold_typetext
Target Bib Recordbib_recordlink

RMOBBCOL

Display Label DB Name Type
Circulating Librarycirc_liborg_unit
Owning Libraryowning_liborg_unit
Billing Typesbilling_typestext
Balancebalancemoney

RMOBBHOL

Display Label DB Name Type
User Home Libraryhome_ouorg_unit
Owning Libraryowning_liborg_unit
Billing Typesbilling_typestext
Balancebalancemoney

RMOBBOL

Display Label DB Name Type
Owning Libraryowning_liborg_unit
Billing Typesbilling_typestext
Balancebalancemoney

RMOCBBCOL

Display Label DB Name Type
Circulation IDidlink
Circulating Librarycirc_liborg_unit
Owning Libraryowning_liborg_unit
Billing Typebilling_typetext
Total Billedbilledmoney

RMOCBBHOL

Display Label DB Name Type
Circulation IDidlink
User Home Libraryhome_ouorg_unit
Owning Libraryowning_liborg_unit
Billing Typebilling_typetext
Total Billedbilledmoney

RMOCBBOL

Display Label DB Name Type
Circulation IDidlink
Owning Libraryowning_liborg_unit
Billing Typebilling_typetext
Total Billedbilledmoney

RMSR

Display Label DB Name Type
Fingerprintfingerprinttext
Overall Record Qualityqualityint
TCN Sourcetcn_sourcetext
TCN Valuetcn_valuetext
ISBNisbntext
ISSNissntext
Full Bibliographic recordbiblio_recordlink

ROCIT

Display Label DB Name Type
Titletitletext
Authorauthortext
Pubdatepubdatetext
Copy IDidid
Pricepricemoney
Barcodebarcodetext
Callnumber Labelcall_number_labeltext
Dewy Tensdewey_block_tenstext
Dewy Hundredsdewey_block_hundredstext
Use Countuse_countint
Circ Modifiercirc_modifiertext
Shelving Location Nameshelving_locationtext
Legacy Stat Cat 1stat_cat_1text
Legacy Stat Cat 2stat_cat_2text
Legacy Stat Cat 1 Valuestat_cat_1_valuetext
Legacy Stat Cat 2 Valuestat_cat_2_valuetext
Edit Dateedit_datetimestamp
Create Datecreate_datetimestamp
Owning Lib Nameowning_lib_nametext
Circ Lib Namecirc_lib_nametext
Owning Libowning_liblink
Circ Libcirc_liblink
Creatorcreatorlink
Age Protectionage_protectlink
OPAC Visibleopac_visiblebool
Referencerefbool
Deposit Amountdeposit_amounttext
Deleteddeletedbool
TCNtcn_valuetext
Statusstatuslink
Stop Fines Reasonstop_finestext
Due Datedue_datetimestamp
Patron Barcodepatron_barcodetext
Patron Namepatron_nametext

RODCIRC

Display Label DB Name Type
Check In Librarycheckin_liborg_unit
Check In Staffcheckin_stafflink
Circulating Librarycirc_liborg_unit
Circulating Staffcirc_stafflink
Desk Renewaldesk_renewalbool
Circulation Durationdurationinterval
Circ Duration Ruleduration_rulelink
Fine Intervalfine_intervalinterval
Max Fine Rulemax_fine_rulelink
OPAC Renewalopac_renewalbool
Phone Renewalphone_renewalbool
Recurring Fine Rulerecuring_fine_rulelink
Fine Stop Reasonstop_finestext
Circulating Itemtarget_copylink
Patronusrlink
Transaction Billingsbillingslink
Transaction Paymentspaymentslink
Base Transactionbillable_transactionlink
Circulation Typecirc_typetext
Billing Totalsbilling_totalmoney
Payment Totalspayment_totalmoney

ROF

Display Label DB Name Type
Undefinedparentlink
Undefinedownerlink
Undefinedcreate_timetimestamp
Undefinednametext
Undefinedsharedbool
Undefinedshare_withlink
Undefinedchildrenlink
Undefinedoutputslink

RR

Display Label DB Name Type
Undefinedownerlink
Undefinedcreate_timetimestamp
Undefinedtemplatelink
Undefineddatalink
Undefinedfolderlink
Undefinedrecurbool
Undefinedrecuranceinterval
Undefinednametext
Undefineddescriptiontext
Undefinedrunslink

RRF

Display Label DB Name Type
Undefinedparentlink
Undefinedownerlink
Undefinedcreate_timetimestamp
Undefinednametext
Undefinedsharedbool
Undefinedshare_withlink
Undefinedchildrenlink
Undefinedreportslink

RS

Display Label DB Name Type
Undefinedrunnerlink
Undefinedstart_timetimestamp
Undefinedcomplete_timetimestamp
Undefinedrun_timetimestamp
Undefinedemailtext
Undefinedexcel_formatbool
Undefinedcsv_formatbool
Undefinedhtml_formatbool
Undefinederror_codeint
Undefinederror_texttext
Undefinedreportlink
Undefinedfolderlink
Undefinedchart_piebool
Undefinedchart_barbool
Undefinedchart_linebool

RSCE1

Display Label DB Name Type
Entry Ownerownerlink
Entry Valuevaluetext

RSCE2

Display Label DB Name Type
Entry Ownerownerlink
Entry Valuevaluetext

RSR

Display Label DB Name Type
Metarecordmetarecordlink
Overall Record Qualityqualityint
TCN Sourcetcn_sourcetext
TCN Valuetcn_valuetext
ISBNisbntext
ISSNissntext
Full Bibliographic recordbiblio_recordlink

RSSR

Display Label DB Name Type
Fingerprintfingerprinttext
Overall Record Qualityqualityint
TCN Sourcetcn_sourcetext
TCN Valuetcn_valuetext
ISBNisbntext
ISSNissntext
Full Bibliographic recordbiblio_recordlink

RT

Display Label DB Name Type
Undefinedownerlink
Undefinedcreate_timetimestamp
Undefinednametext
Undefineddatatext
Undefinedfolderlink
Undefineddescriptiontext
Undefinedreportslink

RTF

Display Label DB Name Type
Undefinedparentlink
Undefinedownerlink
Undefinedcreate_timetimestamp
Undefinednametext
Undefinedsharedbool
Undefinedshare_withlink
Undefinedchildrenlink
Undefinedtemplateslink

RUD

Display Label DB Name Type
Date of Birthdobtimestamp
General Demographic Divisiongeneral_divisiontext

RXBT

Display Label DB Name Type
Voided Billing Amountvoidedmoney
Total Billing Amounttotalmoney

RXPT

Display Label DB Name Type
Total Paid Amounttotalmoney

SRA

Display Label DB Name Type
IDidid
Activeactivebool
Index Fieldfieldlink
Bump Typebumptext
Multipliermultipliernumber

SSR

Display Label DB Name Type
Relevancerelfloat
Recordrecordlink
Checkedcheckedint
Visiblevisibleint
Deleteddeletedint
Excludedexcludedint

VAM

Display Label DB Name Type
Match IDidid
Queued Recordqueued_recordlink
Matched Attributefieldlink
Evergreen Recordeg_recordlink

VAQ

Display Label DB Name Type
Queue IDidid
Ownerownerlink
Completecompletebool
Typequeue_typetext
Purposequeue_purposetext

VBM

Display Label DB Name Type
Match IDidid
Queued Recordqueued_recordlink
Matched Attributefieldlink
Evergreen Recordeg_recordlink
Field Typefield_typetext

VBQ

Display Label DB Name Type
Queue IDidid
Ownerownerlink
Completecompletebool
Typequeue_typetext

VQAR

Display Label DB Name Type
Record IDidid
Create Timecreate_timetimestamp
Import Timeimport_timetimestamp
MARCmarctext
Queuequeuelink
Final Target Recordimported_aslink
Purposepurposetext

VQARA

Display Label DB Name Type
Attribute IDidid
Recordrecordlink
Fieldfieldlink
Valueattr_valuetext

VQARAD

Display Label DB Name Type
IDidid
Codecodetext
XPathxpathtext
Remove RegExpremovetext

VQBR

Display Label DB Name Type
Record IDidid
Create Timecreate_timetimestamp
Import Timeimport_timetimestamp
MARCmarctext
Queuequeuelink
Bib Sourcebib_sourcelink
Final Target Recordimported_aslink
Purposepurposetext

VQBRA

Display Label DB Name Type
Attribute IDidid
Recordrecordlink
Fieldfieldlink
Valueattr_valuetext

VQBRAD

Display Label DB Name Type
IDidid
Codecodetext
XPathxpathtext
Remove RegExpremovetext
evergreen-user/reporting_data_dictionary.txt · Last modified: 2008/08/14 14:51 (external edit)

© 2008-2017 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a member of Software Freedom Conservancy.