MLN2 - Load Profiles in Data Exchange

(C) LOAD Lafayette brief bibs and orders

m2btab.lafbibord

One order record loaded with every MARC

i index, 020 field
then
i index, 022 field
then
v index, 024 field

Yes

Match and Attach

LAordbib,
LAorder

Loaded in bib

Use this table to create vendor brief bib and order records

(D) LOAD a MDE GovDoc marcive shipping list MARC file

m2btab.mdg

Item record created with each 949\1

o index
035 field

No

Overlay

marciv,
marcit

Loaded in bib

MDE Gov. Doc loader for both shipping list

(E) LOAD a MDE GovDoc marcive full list MARC file

m2btab.mdgfill

Item record created with each 949\1

o index
035 field

No

Overlay

marciv,
marcit

Loaded in bib

MDE Gov. Doc loader for full list
Same as mdg, but does not protect bib location

(F) OVERLAY LAF brief bib and order with full bib and item

m2btab.lafbibitemov

Item record created with each 949\\

v index
910 field

No

Overlay

biblio,
Larec

Not loaded

Uses overlay priority function

(G) LOAD Longmont brief bibs and orders

m2btab.lgbibord

One order record loaded with every MARC

i index, 020 field
then
i index, 022 field
then
v index, 024 field

Yes

Match and Attach

LGgen,
LGorder

Loaded in bib

for LG brief bibs and orders

(H) LOAD new member exact and fuzzy bibs and items

m2btab.exfuzzybibs

Item record created with each 949\1

Match on Sierra record number in 907 of incoming record

No

Match and Attach, but insert 690, 590, and 913

tapeb,
tapei

Loaded in bib

for loading Loveland exact and fuzzy bibs and item records.

(I) LOAD new member unique bibs and items

m2btab.uniquebibs

Item record created with each 949\1

None

No

Insert. All records inserted as new.

tapeb,
tapei

Loaded in bib

for loading converted unique MARC and item records

(J) LOAD a BPL brief MARC and order file

m2btab.bbibord

One order record loaded with every MARC

i index, 020 field
then
i index, 022 field
then
v index, 024 field

Yes

Match and Attach

bibliomw,
Bomiddvd

Loaded in bib

Use this table to create brief bib and order records from Midwest

(K) LSV overlay Ingram brief bib with full bib and items

m2btab.lsvfullbibs

Item record created with each 949\\

record number in 910 field

No

Overlay

lsvbib,
bmwcdi

Loaded in bib

for LSV outsourced full bib overlay

(L) LOAD LTI cleaned bibs MARC file

m2btab.ltibib

None

None

No

No overlay

biblio

Not loaded

LTI bib merge load table

(O) OVERLAY an LG brief bib with a full bib and attach item

m2btab.lgbibitem

Item record created with each 949\\

record number in 935, i index, 020 field

No

Overlay

LGgen,
lganf

Loaded in bib

Longmont loader to overlay bibs and create items

Uses overlay priority function

(P) OVERLAY a BPL brief bib and order with full bib MARC file and item

m2btab.bbibitemov

Item record created with each 949\\

v index, 910 field

No

Overlay

bibliomw,
bmwcdi

Not loaded

for Midwest full bib overlay

(U) LOAD a Loveland brief MARC and order file

m2btab.lovbibord

One order record loaded with every MARC

i index, 020 field
then
i index, 022 field
then
v index, 024 field

Yes

Match and Attach

biblio,
LVorder

Loaded in bib

Use this table to download vendor brief bibs and create order records

(V) OVERLAY a Loveland brief bib and order with full bib MARC file and item

m2btab.lovbibitemov

Item record created with each 949\\

v index, 910 field

No

Overlay

biblio,
tapei

Not loaded

Use to download vendor brief bibs and create order records

(W) LOAD a Serials Solution MARC file

m2btab.sersol

Item record created with each 949\1

o index, 035 field

No

Overlay

bibss,
item

Loaded in bib

Serials Solutions loader Bibs only

(X) LOAD a MDE Baker and Taylor bib and order MARC file

m2btab.mdebt

One order record loaded with every MARC

i index, 020 field
then
i index, 022 field
then
v index, 024 field

Yes

Match and Attach

mdebto,
mdebtb

Loaded in bib

Use this table to create bib and order records from OneClick on BTP

(Y) LOAD an LSV bib and order MARC file

m2btab.lsvbibord

One order record loaded with every MARC

i index, 020 field
then
i index, 022 field
then
v index, 024 field

Yes

Match and Attach

lsvbwio,
lsvbwib

Loaded in bib

Use this table to create bib and order records from BWi

(Z) Attach an LG item to existing full bib

m2btab.lgitem

Item record created with each 949\\

i index, 020 field

No

Match and Attach

LGgen,
lganf

Loaded in bib

Longmont loader to attach items to existing bibs