I believe you're looking for biblio.record_entry. This (generally) corresponds to the "source" or "record" value of your metabib tables (if you do a '\d metabib.title_field_entry' [for example], you should see a "foreign key constraint').
An item (asset.copy) will link to a title (biblio.record_entry) via a volume (asset.call_number). There are also a number of useful views in the reporter schema. If you haven't yet seen it, this (http://open-ils.org/documentation/evergreen-schema-1.4.0.2.html) can be pretty helpful. There are some additions in 1.6 (Ex: Acq), but I find it quite helpful quite often. Hope this helps! --Don On Mon, Dec 7, 2009 at 6:30 PM, Jesse Ephraim <jephr...@roanoketexas.com> wrote: > I am the director of a library in a consortium of small libraries in the > Dallas-Fort Worth metroplex area of Texas. We launched Evergreen a few > months ago. > > > > I am working on some reports that go beyond the basic capabilities of the > built-in reporting tool in Evergreen, so I am pulling the data via standard > SQL queries. I have one quick question: > > > > I don’t see “title” and “author” information anywhere within any of the > ASSET tables (other than empty “dummy_title” and “dummy_author” fields in > asset_copy), so I looked to the METABIB table to pull that information. > However, I am having trouble locating the common identifier to tie the > tables together when I JOIN them so I can link the appropriate author and > title information to the individual copies. I know I must be overlooking > something obvious, but if someone could give me a quick hint, I would really > appreciate it! > > > > Thanks! > > > > Jesse Ephraim > > > > Director, Roanoke Public Library > > 308 S. Walnut > > Roanoke, Texas 76262 > > (817) 491-2691 > > jephr...@roanoketexas.com > > > >