ERM Database Documentation

I. Working in the ERM Database
Procedures	Working in ERM	Reports and Batch Jobs
Access Confirmations: MetaPress E-Journals Initial Activations for Sage Publications Initial Activations for Blackwell Synergy Initial Activations for ScienceDirect Swets Notifications (doc) Data Entry Guidelines: New Request Forms (Non-CDROM) (xls) Renewal Review Forms (xls) Managing Weekly ERM Reports: On Order, Claim Needed, and Claimed (doc) URLs Locating Primary Access URL (doc) URL Source (xls) Managing URL Changes	Electronic Resource Record Tabs: Bib Rec Record Type Value List Resource Status Value List Material Type Value List Acquisition Renewal/Review Status Value List Cost Access Authentication Method Value List Admin Info Contacts & Organizations License/Terms Workflow Pre-Selection Status Access Status Value List Action Items Targets/SFX	Crystal Reports Nightly Batch Jobs (doc) Batchloading Format (xls)

II. Data Structure and Dictionary
Overview	Primary Entities	Bridge and Log Entites
Version 1.0: Database History Technical Specifications Relationship to SFX and Aleph Entity Relation Diagram (doc) Loading Data (doc)	Access Information (xls) Account (xls) Acquisition (xls) Action Item (xls) Administrative Information (xls) Contact (xls) Cost (xls) Electronic Resource (xls) License (xls) Organization (xls) Processing Workflow (xls) Terms Defined (xls) Trial (xls)	acqER (xls) acqLog (xls) Contact Responsibility (xls) erCost (xls) Journal Titles (xls) Object Link (xls) orgContact (xls)

Screen Shots
Access Record Acquisition Record Action Items Admin. Record Bib. Record Contact Record Cost Record	License Record License Terms Record Search Form Search Results SFX Journals Trial Record Workflow Record

Boston College Libraries
last revised: February 3, 2006
mckelvee@bc.edu