| Load Table | Creator | Purpose | Notes | Active Maps |
|---|---|---|---|---|
| a | iii | Authority record profile. | ||
| a.old | iii | |||
| aas | iii | Loaded Evans records (American Antiquarian Society). | This loads call number as 099 instead of 099 0. Should be looked at if ever needed again. | |
| alexstpress | sks | Loads Alexander Street Press records.
|
Loads first 12 characters of 001 (omitting suffix). Matches on 001; overlaying, protects only the cat date. Creates no linked records and uses no command line. Uses no holdings symbol; loads 050 call numbers; loads only LC subject headings. Adds 506: Access restricted to subscribing institutions. Adds 583: include CBB RSS. Loads 856|z View the electronic version of this book and adds proxy to 856|u using humanities map. Loads incoming 946 (Marcive Authorities); adds 946 Alexander Street Press. |
humanities adds the proxy prefix to the 856 |u and makes |z our standard wording. |
| anam | iii | Name authority profile. | Used for single record export and batch loading in Data Exchange: Load name authority records. | |
| anam.old | iii | |||
| anamx | sks | Load name authority records from Marcive. | No longer used as of 7/1/2009. During an IUG presentation on authority work, I learned Marcive could indeed add these cross references (unlike what I was told a year ago). So I guess finding out a year late (and after much added work) is better than nothing. Adds a 4xx cross reference so Automated authorities module will update bib records for headings that need to have death dates added. When using, follow these procedures. |
(no longer active) auth puts |wtremove and |wodremove in 4xx fields with open dates. |
| asub | iii | Subject authority profile. | Used for single record export and batch loading in Data Exchange: Load subject authority records. | |
| asub.old | iii | |||
| b | iii | Default bib table; can create items with 949. | III corrected old errors that kept table from validating and replaced out dated key title match with new match code (!), Spring 2002. | |
| bi | sks | Loads bib, creates items. | When all items in a shipment are scores have Techpro us recs=bi; and set default item template to gscore. When loading Muskie reords for finding aids, set default item template to spec. | none |
| bo | iii | Loads bib, can create orders with 949. | ||
| bocd | sks | Same as bo, but loads 028 twice; once in bib record, once in order record vendor note. | none | |
| boi | sks | Loads bibs, creates both orders and items. | For Techpro records (scores) for items sent directly from vendor to Techpro. Need to edit default templates (order: scores, item: gscore) for fixed values (e.g., vendor) so Techpro only needs to add 949 *recs=boi; | none |
| cam | sks | Written to Load Cambridge records.
|
Creates no linked records and uses no command line. Uses no holdings symbol; loads 050 call numbers; loads LC subject headings. Adds prefix: cam to the 001 field. Adds |h[electronic resource] to the 245 field. Adds 506: Access restricted to subscribing institutions. Adds 583: include CBB RSS. Loads 856|z View the electronic version of this book. Manipulates 856 |u for Bates access. Adds 946: Cambridge Collections Online. Retired 4/2009 (getting these records via Serials Soltuions e-book service instead). |
cam adds cam to 001 field. (Don't know why x is needed, but it works.) For genuine OCLC record numbers, strips (OCoLC)ocm before adding cam prefix. electronic adds 245 |h [electronic resource] humanities adds the proxy prefix to the 856 |u and makes |z our standard wording. |
| ead | iii | Not in the list of m2btab under Load Profile Maintenance. Accessed from Import Invoives, Load Profile dropdown menu: Marc enhanced approvals and firm orders (ead) |
Per Innovative c1099657, this is a standard profile that comes with the Extended Approval Plan Interface. Although we do not use, I'm not having Innovative remove it from the menu--it's not clear to me what it does, and if we would need it in the future. (3/2009) | |
| eai | sks | Loads aggregator records created with MarcMaker; creates checkin with holdings statement. | Created for EAI records; currently used for Science Direct. Procedures. No longer used as of 9/2003; we now purchase Serials Solutions records. |
|
| eBates | sks | This is a mistake and can be deleted. Names of load tables cannot have uppercase letters. | ||
| ebrary | sks | Loads ebrary records.
|
Loads 001 as is. Matches on 001; if overlaid, protects only the cat date. Creates no linked records and uses no command line. Uses no holdings symbol; loads 050 call numbers; loads only LC subject headings. Loads 533 |n as note field. Loads 856|z View the electronic version of this book. Adds 946 ebrary instead of 710 2 ebrary, Inc. Retired 4/2009 (getting these records via Serials Soltuions e-book service instead). |
xref makes 856 |z our standard wording. |
| ebsco | sks | Loads Ebsco records; creates checkin with holdings statement. | No longer used as of 9/2003; we now purchase Serials Solutions records. | |
| ebsco2 | sks | Loads Ebsco records; leaves holdings statement in 856 |3. |
Procedures.
No longer used as of 9/2003; we now purchase Serials Solutions records. |
|
| ebsco3 | sks | Loads Ebsco records; leaves holdings statement in 856 |3; revised
from
ebsco2 to accomodate Ebsco's reordering of 856 |u and |z. |
Procedures. No longer used as of 9/2003; we now purchase Serials Solutions records. |
|
| eebo | sks | Loads Early English Books Online records. | Creates no linked records and uses no command line. Loads 003, strips 049. Loads 090 call numbers; loads LC subject headings. Adds prefix: eebo to the 001 field. Adds 506: Access restricted to subscribing institutions. Loads 856|z View the electronic version of this book. Manipulates 856 |u for Bates access. Adds 946: ProQuest. | eebo adds eebo to 001 field. (Don't know why x is needed, but it works.) For genuine OCLC record numbers, strips ocm before adding eebo prefix.
humanities adds the proxy prefix to the 856 |u and makes |z our standard wording. |
| emono1 | sks | Loads Oxford Reference Online records. | Creates item with blank call number. No longer used (2005); Oxford Reference added to Serials Solutions. |
|
| ecbbbates | sks | Loads single title ebooks shared by CBB, purchased by Bates from Yankee. Accessed from Import Invoives, Load Profile dropdown menu: CBB Bates purchased ebooks.
|
Does not overlay (would insert if match were found). Loads 001 as is. Uses no holdings symbol (049). Loads 050 and 090. Loads only LC subject headings. 856 11 will load as 856 41. Added 538 since these will go in CBB RSS feed. Loads 910. Creates 946 Yankee. Creates order from 980, using info from 980 and 981. Creates no item. |
|
| ecbbshared | sks | Loads single title ebooks shared by CBB, purchased by Colby or Bowdoin from Yankee. Those that Bates purchases have to be loaded first through ecbbbates table. | This table is the same as ecbbbates except:
The reject function allows Yankee to create one shared file (identical for all 3 schools). |
|
| gobi | sks | Loads short bib records exported from GOBI (Yankee); creates order record. | gobi adds a 946 Yankee (GOBI). (Written before T funcationality in position 3 existed.) |
|
| fse | iii | Full screen editor. | ||
| humanities ebook |
sks | Loads ACLS/Humanities e-book records. | Creates no linked records and uses no command line. Uses no holdings symbol; loads 090 call numbers, stripping |bINTERNET; loads only LC subject headings. Adds 506: Access restricted to subscribing institutions. Loads 856|z View the electronic version of this book. Manipulates 856 |u for Bates access. Adds 946: University of Michigan/ACLS. Not to be included in CBB RSS feed, so no 583 loaded. |
humanities adds the proxy prefix to the 856 |u and makes |z our standard wording. |
| jstor | sks | Loads JSTOR records using microenhancer. | Procedures.
No longer used as of 9/2003; we now purchase Serials Solutions records. |
|
| mrcv | iii | Loads Marcive records. | Was resulting in records with 2 086's; 1 from load table, 1 from
holdings
table. 086 removed and holdings table updated to include all 049's
that
Marcive adds to records (5-6/02). Procedures. |
|
| myb | sks | My working space. Currently (7/2007) a copy of b | ||
| mybo | sks | Copy of iii bo; made to try to have it also create items. Doesn't work, using boi instead. Can be deleted. | ||
| mymrcv | sks | Copy of iii mrcv. III mrcv is more up to date; this should be deleted. | ||
| mypcat | sks | Copied from iii pcat. | Not used for anything. Copied from pcat, edited to create boi. boi
validates
with pass 1 for both orders and items. (12/2003) 1/2006 Working copy to edit pcat to validate and not overlay. |
|
| naxos | sks | Loads Naxos records. | Loads 001 as an normal OCLC number is loaded (stripping ocm).
Matches
on 001, protects only cat date if overlaid, creates no linked
records, uses
no command line, uses no holdings symbol, loads no call numbers
(090, 092,
050, 052, 082, 084), loads only LC sujbect headings. Load table
creates
a 506 (access restricted); does not load 530 (Also available on
compact
disc). Creates 946 Cataloging Partners. (8/29/2006, sks) Second batch of naxos records (12/06) has 506 fields. But not loading, keeping the table generating one for each record so wording will be the same as the first load. (1/5/07, sks) |
none |
| net | iii | Not in the list of m2btab under Load Profile Maintenance. Accessed from Import Invoives, Load Profile dropdown menu: Marc enhanced approvals and firm orders (net) |
Per Innovative c1099657, this is a standard profile that comes with the Extended Approval Plan Interface. Although we do not use, I'm not having Innovative remove it from the menu--it's not clear to me what it does, and if we would need it in the future. (3/2009) | |
| oldiiib | sks | Copy of old iii b, made just in case my replacement of their b didn't work. Can be deleted. | ||
| oldiiibo | sks | Copy of old iii bo. | I couldn't update iii bo to have new duplicate match code (!) added because of old errors that kept table from validating. III fixed and updated bo; this can be deleted. | |
| oldiiipcat | sks | Copy of original pcat created by iii. | I couldn't update pcat to not have it overlay records because of old errors in using pass 2 that keep table from validating. So am archiving their copy and editing mypcat to replace pcat. 1/2006 | |
| oldiiimrcv | sks | Copy of old iii mrcv, now outdated (results in records with 2 086's). Can be deleted. | ||
| oops | iii | |||
| p | iii | Loads patron records. | ||
| pcat | iii | Loads PromptCat records; creates order and item. Accessed from Import Invoives, Load Profile dropdown menu: MARC enhanced approvals and firm orders (pcat) |
This will not validate; finds errors with pass 2, which is what
creates
item. Have asked Matt to correct this (5/02 e-mail; no reply; need
to follow-up--open
help desk call?). (12/2003--Was able to create my own load table that creates orders and items (boi). No longer need this to validate since I can now copy boi if I need another table that creates orders and items. Since it works as written and is an Innovative table, I'm leaving it as it is.) 1/19/2006. Need to have pcat validate, so I can edit it to have it not overlay anymore. Copied to oldiiipcat so I can edit pcat. 1/2006. Am replacing this with a copy that validates and editing it to not overlay. Original pcat was allowing short promtcat records from firm orders to overlay our fully-cataloged bib records when duplicates, etc. were unknowingly ordered on Gobi2 by liaisons. |
|
| pcat.bw | iii | ? | ||
| pcat.qz | iii | ? | ||
| pjb | iii | ? | ||
| pshare | iii | Loaded patron records from Colby and Bowdoin. Probably no longer needed now that we use Maine Info Net. | I think Karl is leaving Bowdoin's copy in their system. | |
| sersol | sks | Loads Serials Solutions Journal records. | This table matches on the 035, rather than 001. It overlays if a match is found, protecting only the cat date. It creates no linked records and uses no command line. It uses no holdings symbol. It loads only LC subject headings. It adds a 246 for every 245|a. Originally it got the OCLC number from the 913 field and loaded it into the 001. Edited 9/16/05 to keep OCLC number in 913, and load the ssj number--without (WaSeSS) prefix--in 001 (for NExpress matching). | none |
| sersol2 | sks | Loads Serials Solutions E-book records (4/2009). | Matches on the 001. It overlays if a match is found, protecting only the cat date. It creates no linked records and uses no command line. It uses no holdings symbol. It loads 050 and 090 call numbers. It loads only LC subject headings. | |
| xref | sks | Written to load Xrefer records. No longer used for xref as of 7/2007; we no longer purchase Xrefer records. Now used for one-time loads of records to freely-accessible material (e.g., Wright American Fiction), editing as needed before loading (e.g., 946, 049). | Loads 001 as is. Matches on 001; if overlaid, protects only the cat date. Creates no linked records and uses no command line. Uses no holdings symbol; loads only LC call numbers; loads only LC subject headings. Loads 856 |u as is. Loads 856|z View the electronic version of this book. Adds 946. | xref makes 856 |z our standard wording. |
