Database Elements for Tracking
the Acquisition and Display of E-journals

For the User:

Field

Why

Problem

Journal TitleBibliographicSorting on "the", "and", and ampersands
URLClickable AccessDurable and direct URL without extra steps the best. Not always available; then complicated explanations needed.
Username and Password, if requiredAccessDifficult to make available to user
HoldingsBibliographicDifficult to get, one at a time; change as publishers adds backfiles.

For the librarian:

Field

Why

Problem

How purchased (use codes?)To get what you pay for and prioritize your workMany ways to purchase a title. Often end up purchasing same title from different sources.
Is it free to all on the web?To give more access to usersList everything or just those in scope?
Print includes free onlineCan change without notice to an extra cost and publisher cuts off access without notice.
Print comes with online at an extra costHow much more are you willing to pay: 25%? 33%?
Online onlyWill anyone ever know you own it if it is not on the shelf and they know nothing about online journals.
Part of an aggregation with a platform feeTo troubleshoot as a groupOften expensive; often not sold to smaller libraries.
A separate license from the print altogether (example: Science)
Vendor title numberTo claim online editionRely mostly on user complaints; often access cut off without notice.
Subscription code from print journal coverTo activate the title at the publisher's siteUsually toss info; messy to collect.
Administrator's Username and Password, if requiredTo change your IP ranges and other dataWhen asked for a password - often do not know if it for users or an admin password
SubjectTo organize for the userNot easy to display on the web; especially if there are multiple subjects. Most Database programs do not index.
ILS Bib record numberTo coordinate with the print productPrint and/or electronic Bib number? Or both?
ISSN - to identifyPrint and/or electronic?; Sometime multiple.
Imprint - to identifyWho does publish it? The print publisher who collects the data or the online publisher who displays it?
Price - printOnly if you don't keep this elsewhereDifficult to get what your cost increase is when you pay for an electronic edition.
Price - extra for onlineOnly if you don't keep this elsewhereditto
Access from more than one sourceHow many can be handled?Difficult to display on the Web or in a catalog
Notes and Comments - free text fieldTo track activity not covered by other fields

Date all notes
Notes are often on different problems but more than one field confusing

Aggregator name or groupTo handle problems as a groupWhen you order a title you usually do not know whether it is a single title or part of an aggregation
Use StatisticsTo eveluated titleIn all formats, one title a time. Difficult to collect.

Faculty Publications

The special challenge of nonadherence with sublingual immunotherapy. PubMed

Natural Killer T cell obsession with self-antigens. PubMed

Search Publications Database

Library News Blog

Read the latest news from Library and Knowledge Services on the news blog and set your RSS Reader to receive the latest bulletins.

New Title: The Lancet Respiratory Medicine

The Lancet Respiratory Medicine launched in March 2013 and is the fourth Lancet specialty journal following in the footsteps of The Lancet Oncology, The Lancet Neurology, and The Lancet Infectious Diseases. Topics include but are not limited to asthma, COPD, tobacco control, critical care, lung cancer, cystic fibrosis, pneumonia, sarcoidosis, mesothelioma, palliative medicine, and respiratory infections. Read more.

Colorado Healthcare Exchange

Starting Oct. 1st, Coloradans will be able to shop, compare, pick and purchase health plans at one site: Connect for Health Colorado! Wondering what individual insurance rates will look like? Looking for educational materials for your community members? Want to know who in your community is in the designated Health Assistance Network? Find out at the Connect for Health Colorado website. Read more.

Expert EndNote Tip

How to find and replace fields so that you can view metadata most efficiently… Recently, I was working on a project where I needed to sort EndNote records by publication type (the EN field, Type of Work). It’s simple enough to click on the the column header “Type of Work” and get it to sort alphabetically. BUT only one type of work displays in the library window, even when a record is indexed with multiple publication types! Read more.