| Load Table | Creator | Purpose | Notes | Active Maps |
|---|---|---|---|---|
| a | iii | Authority record profile. | ||
| a.old | iii | |||
| aas | iii | Loads Evans records (American Antiquarian Society). | Original table (for microfiche) replaced with eebo table and edited for aas (digital) 7/2010. Creates no linked records and uses no command line. Loads 001 as is. Does not load 035--first load did, but these duplicate real OCLC numbers and I don't want dup reports every time we work on a valid OCLC record. Does not load 049 [XXXX]. No incoming call numbers. Adds 506. Loads 533 as is. Loads LC subject headings and 655 7, although latter not currently indexed. Loads 752s. Loads 856|z View the electronic version of this book. Manipulates 856 |u for Bates access. Loads 946. Adds 946: American Antiquarian Society. |
humanities adds the proxy prefix to the 856 |u and makes |z our standard wording. |
| alexstpress | sks | Written to load vendor records from Alexander Street Press.
|
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. Retired 11/2011. Now getting ASP as WorldCat Collection Set. |
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. |
| asp | sks | Loads Alexander St. Press WorldCat Collection Set records for textual material. | 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, loads LC call numbers, loads only LC sujbect headings. Creates 506 Access restricted note. Loads 533 (electronic
reproduction) without |n (Mode of Access note) since not all records have 533s. Creates 538 Mode of Access note. Loads 776 (these do not display, so they are no problem). asp maps proxy to 856 and adds |z with our standard wording. Does not loads 938s. Loads incoming 946 (Marcive authorities). Creates 946 OCLC WorldCat Collection Set Alexander Street Press (texts). |
asp
(Some URLS have |3 (need to keep), most have |3 Alexander Street Press (to be deleted). Some URLS others have |z (not wanted). Table loads both |3 and |z. Need to delete unwanted |z (Access restricted) and |3 (Alexander Street Press) via global update after the load. |
| aspsr | sks | Loads Alexander St. Press WorldCat Collection Set records for sound recordings. | 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, loads no call numbers (090, 092, 050, 052, 082, 084), loads only LC sujbect headings. Creates 506 Access restricted note. Loads 533 (electronic reproduction) without |n (Mode of Access note) since not all records have 533s. Loads 538 Mode of Access note. Loads 776 (these do not display, so they are no problem). Does not load 938s. Map adds proxy to 856 and |z with our standard wording. Loads incoming 946 (Marcive authorities). Creates 946 OCLC WorldCat Collection Set Alexander Street Press (sound recordings). |
aspsr
(Some URLS have |3 (need to keep) others have |z (not wanted), so loading both. Need to delete unwanted |z (Access restricted) via global update after the load. |
| 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 Solutions 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. |
| dram | sks | Loads Dram 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. Loads 037. Loads 506 (access restricted) and 530 (Also available on
compact
disc), since 530 contains New World Record CD number. Loads 710 (2,062 are DRAM (Online service), 1,042 are real.) Manipulates 856 |u for Bates access. Creates 946 OCLC WorldCat Collection Set. |
dram adds the proxy prefix to the 856 |u and keeps the incoming |z. |
| 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. 3/2010 Loads ebrary PDA 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 Solutions e-book service instead). Edited 3/5/2010 to load ebrary PDA records. Matches on 001, inserts record if a match is found. (OK to do since other ebrary records have ssj numbers.) Creates no linked records and uses no command line. Uses no holdings symbol; loads 050 call numbers (including eb at end); loads only LC subject headings. Creates 506 with standard Access restricted wording. Uses ebrary map to load 533 without the |n Access may be restricted note. Doesn't load a 538, since Mode of access note is in 533 |n. Uses ebrary1 map to add proxy and standard |z wording. Loads 710s. Adds 946 ebrary PDA. If I edit this to load the purchased titles at the end of the trial period, have these titles included in the CBB new books list and use 946 ebrary PDA purchase. Have it load incoming 946 (Marcive Authorities). 4/23/2010. Money is used up. The way we get records for purchased titles has changed. I need to download the non-purchased titles (they contain a delete code) and delete them. So: change load table to match and overlay on 001; output and send remaining records to marcive; have them reload protecting only cat date and without adding CBB RSS feed (since C and B not reloading). Updated these fields to load as they are: 506, 533, 856, 946. |
ebrary strips second 533|n (Access restricted note with ebrary wording) ebrary1 adds proxy and substitutes incoming |z wording with standard |z 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. |
|
| ecco | sks | Loads ecco records (18th century collections online) | Creates no linked records and uses no command line. Loads 003. No 049 or call numbers to load. Loads LC subject headings and 655 _7 (the latter are not indexed). Adds prefix: ESTC to 001. Adds 506. Keeps complete 533. Loads 852 (into y). Loads 856|z View the electronic version of this Loads 509. No 509 in marc manual, show up as invalid, but 509 does not dispaly in public. |
ecco2 replaces | in 008 23 with s (electronic) ecco adds ESTC to 001 ecco1 adds the proxy prefix to the 856 |u and makes |z our standard wording. |
| ecco.back.back | system | Created when file was being edited network caused Putty abort. Can be deleted. | ||
| 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 583 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). |
|
| fod | sks | Loads Films on Demand records. | Edited from eeco. Creates no linked records and uses no command line. Loads 003. Loads 008 as is, with code o in byte 29. No call numbers to load. Loads LC subject headings (650 and 655) . Does not load 655 _7 (Videorecording). Adds prefix: fod to 001. Does not load 506; adds our stock-phrase 506. Does not load 856|a. Loads 856|z View this video online. Manipulates 856 |u for Bates access. Keeps incoming 946; adds 946: Films on Demand. |
fod adds prefix to 001 fod1 manipulates the 856 to add stock-phrase |z and proxy to |u |
| fod2 | sks | Trying to re-load Films on Demand records. | Was trying to make a load table that protected all fields, since the first load of Films on Demand records did not match our purchase, and they couldn't run a file of deletes for us. Couldn't figure out the load table protection line, so this load table doesn't work, but could be used as the basis of a "protect all" load table if needed in the future. |
|
| fse | iii | Full screen editor. | ||
| 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.) |
|
| 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 2011 update: Format of 001 has changed from very long MIU numbers to very short numbers with no prefix. Load table now adds acls to 001. Nov. 2011: No longer used as of 11/2011; we now purchase Serials Solutions records. |
humanities adds the proxy prefix to the 856 |u and makes |z our standard wording.
acls add acls prefix to 001 |
| 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. |
|
| naxmus | sks | Loads Naxos records from Naxos (cataloged by the University of Hong Kong) | Some fileds were manipulated with Marc Edit before loading. See records loads page. Loads 028 |a as the 001. Loads an 008 approriate for material type j, rather than material type m. Use zxx instead of eng for the language code in 008 and in bib language code. Loads 028 with indicators 02 (instead of blanks). Does not load 246 |h[electronic resource]. Loads 946 Naxos/University of Hong Kong. Note: Loading the 028 |a as the 001 resulted in 18 overlaid book records. Load table changed to not overlay before loading 2nd set. Globally updated 001s after load, adding nax prefix. |
naxmus manipulates the 008 |
| 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) Naxos Jazz, 3/1/2010. These records are different from Naxos Classical records in use of 506, 530, 710, 830. Editing table for Naxos Jazz records, since this is presumably end of Naxos records from OCLC: Load 506 (these records have no 830 or 710 for Naxos); load 530 (these contains music labels and numbers for previous issues); load 710s (real); use map to add proxy to 856; load incoming 946 (Marcive authorities). |
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) | |
| obo | sks | Loads Oxford Bibliographies Online records. | Adds prefix obo to 001 (article record numbers start with EDZ but subject record numbers are strictly numeric). Loads 050 call numbers and LC subject headings. Loads no incoming 506 or 538 (present in subject records only). Adds stock 506 Access Restricted note and stock 538 Mode of Acces note. Map manipulates 856 to add proxy and |z wording. Loads incoming 946 and adds 946: Oxford. | obo add obo prefix to 001 obo2 adds the proxy prefix to the 856 |u and makes |z View the electronic version of this bibliography. |
| 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. | |
| spring | sks | Loads Springer (WorldCat Collection Set) 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 050 and 090 call numbers, loads only LC sujbect headings. Loads 035 and 037. Creates 506 (access restricted). Loads 533, using map to strip |n Access restrcited. Loads 710 (although only 257 are real, i.e., non-Springer 710s.) 856 41 and 856 42, loads these stripping the |z, since I had them add a |zView the electronic version of this book, not realizing there would be TOC and Publisher descriptions. Manipulates 85640 |u for Bates access. Creates 946 OCLC WorldCat Collection Set Springer 4/23/2010. If Springer 050s have |b, need to edit table before next update is loaded. 5/21/2010. Edited to load entire 050. |
dram adds the proxy prefix to the 856 |u and keeps the incoming |z. springer strips the last 533 |n Access may be restricted to subscribing institutions |
| springer | sks | Delete. Name too long. Using spring load table instead. | ||
| wccs | sks | Loads WorldCat Collection Set records. Currently edited to load Netlibrary records from WorldCat Collection Sets (except the dram map, which I edited, but after loading reverted to it's generic form, for the rest of the tables to work). |
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, loads 050 and 090 call numbers, loads only LC sujbect headings. Loads 035 and 037. Creates 506 (access restricted) and 538 (mode of access). Manipulates 85640 |u for Bates access. Creates 946 OCLC WorldCat Collection Set Netlibrary. |
dram adds the proxy prefix to the 856 |u and keeps the incoming |z.
|
| 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. |







