(K) Load b & o, match on i - 020 & 001 [acq2]

Bib and order records will be created.

Match on the BIB UTIL number, then 020a only if there are no BIB UTIL matches, then match on 024 if there is no 020 match. If a BIB UTIL match is found 020a is ignored. If a 020a match is found 024 is ignored. Code: /^999||t|0|10| | |0|n|G|0|#com="ov"@ov_tag="o:i(020)v"i(024)j"

0 matches: Insert new bib 1 match: match and attach 2 matches: Insert new bib Code: |||0|0| | |0|n|G|0|@ov_action="a"

Variable (retain both incoming and target data) Field group: h LIB HAS Field group: k TOC DATA MARC tags: 970, 971 Field group: m LOAD NOTE MARC tags: 995 Field group: n NOTE MARC tags: 583 Field group: y MISC MARC tags: 948, 958 Variable (retain only target data, ignore incoming data) Field group: v LOCAL INFO MARC tags: 590, 690, 691, 856 (only if target field contains “|2pika”) Fixed SPEC’L USE Code: @ov_protect="b=V0123456789hk(970,971)m(995)n(583)v(590,69.,856:d)y(948,958)F31"

Bib: tapeb Item: mdlholddum Order: _o The template settings only take effect if that field is not defined in any other way by the record load. Templates only effect fixed fields when loading records with load profiles. Prompting for fields does nothing when loading records with load profiles. Code: /^999||o|0|20| | |0|n|G|0|#com="dflt"@dflt="tapeb,mdlholddum"

These commands will override defaults in the bib record. This is rarely used.

recs = Load Profile
bn = Bib Location
ct = Cat Date
b1 = Bib Lvl
b2 = Mat Type
b3 = Spec’l Use
la = Language
cy = Country

Format: 949 \\$a*recs=acq2;bn=cu;ct=01-18-2021;b1=m;b2=a;b3=w;la=spa;cy=cou; Code: /^999||z|0|10| | |0|n|G|0|#com="recs"@recs="acq2" /^999||a|0|30|b| |26|n|G|0|#com="bn" /^999||c|0|8|b| |28|n|G|0|#com="ct" /^999||d|0|1|b| |29|n|G|0|#com="b1" /^999||e|0|1|b| |30|n|G|0|#com="b2" /^999||f|0|1|b| |31|n|G|0|#com="b3" /^999||g|0|3|b| |24|n|G|0|#com="la" /^999||k|0|3|b| |89|n|G|0|#com="cy"

This load will not set the CAT DATE. Records should not get a CAT DATE until they get an item attached. Code: |||0|0| | |0|n|G|0|@cdate="n"

Processed by m2bmap.sky translation map. This translation map removes OCLC prefixes from 001 field. Other prefixes are left in place. SkyRiver prefix is left in place. If there is only a number with no prefix, the word “prefix” is added as a prefix. Code: 001||%|0|0|b|o|0|y|N|0|%map="m2bmap.sky" m2bmap.: @case=true @stop_on_map=true ^(001)$0ocl70*([1-9][0-9]*)$1|\0\1 ^(001)$0ocm0*([1-9][0-9]*)$1|\0\1 ^(001)$0ocn([1-9][0-9]*)$1|\0\1 ^(001)$0on([1-9][0-9]*)$1|\0\1 ^(001)$0( *[a-zA-Z].*)$1|\0\1 ^(001)$0(.*)$1|\0prefix\1

If the target record is in field group v LOCAL INFO and includes any of these strings: |2pika |2vufind |2image |2Pika |2VuFind |2Image then the field is protected. No incoming 856 field with “|2pika” will load in that case. All other 856 fields are not protected. They will be overlaid from the incoming record. If there is no 856 in the incoming record, they will be deleted from the target record. Code: 856||+|0|0|b|v|0|y|N|0|%map="m2bmap.art" 856||+|0|0|b|y|0|y|N|0|%map="m2bmap.not" m2bmap.art @delimiter=~ @case=true @stop_on_map=true (.*|2pika.*)$0~\0 (.*|2vufind.*)$0~\0 (.*|2image.*)$0~\0 (.*|2Pika.*)$0~\0 (.*|2VuFind.*)$0~\0 (.*|2Image.*)$0~\0 .*~ m2bmap.not @delimiter=~ @stop_on_map=true @case=true (.*|2pika.*)$0~ (.*|2vufind.*)$0~ (.*|2image.*)$0~ (.*|2Pika.*)$0~ (.*|2VuFind.*)$0~ (.*|2Image.*)$0~ (.*)$0~\0

FIXED FIELDS Incoming Output 008 Language LANG fixed field 008 Country Country fixed field Leader BLvl Bib Lvl fixed field Leader Type of Record Mat Type fixed field VARIABLE FIELDS Incoming field Output field group tag Notes 001 o OCLC prefix removed Other prefixes left in place Non-prefixed number will have “prefix” added. 002 - 007 y 13The incoming 005 is retained. Sierra does not change a 005. It should reflect the date the record was last updated where ever the record came from. 008 - 009 y Modifies 008 to add some fields from Leader, these fields returned to Leader on export. 010 l 011 NOT LOADED 012 NOT LOADED – Only used by CONSER 013 - 018 y 019 o 020 - 023 i 024 i Translation map will remove extra leading zeros. If there are two extra zeros preceding the 12 digit UPC, they will be removed. 025 y 026 NOT LOADED – Only used in rare book cataloging 027 - 028 i 029 NOT LOADED – OCLC uses this for non-OCLC control numbers 030 - 049 y 050 - 084 j 085 NOT LOADED – Synthesized Classification Number Components 086 g 087 NOT LOADED 088 j 089 NOT LOADED 090 - 099 j 100 - 111 a Exclude subfield w 112 - 129 NOT LOADED 130 t Exclude subfield w 131 - 209 NOT LOADED 210 y 211 - 222 u 223 -239 NOT LOADED 240 t Exclude subfield w 241 - 243 u 244 NOT LOADED 245 t 246 - 247 u 248 - 249 NOT LOADED 250 e 251 NOT LOADED – Only used in rare book cataloging 252 - 253 NOT LOADED 254 - 257 y 258 - 259 NOT LOADED 260 - 262 p 263 y 264 p 265 y 266 - 269 NOT LOADED 270 p 271 - 299 NOT LOADED 300 - 399 r 400 - 490 s Exclude subfield w 491 - 499 NOT LOADED 500 - 589 n 590 v Local note 591 - 599 NOT LOADED 600 - 689 d Exclude subfield w 690 - 691 v Exclude subfield w - Local Subject 692 - 699 d Exclude subfield w 700 - 711 b Exclude subfield w 712 - 719 NOT LOADED 720 y Exclude subfield w 721 - 729 NOT LOADED 730 - 740 u Exclude subfield w 741 - 751 NOT LOADED 752 - 755 y 756 - 759 NOT LOADED 760 - 777 q 778 - 779 NOT LOADED 780 x 781 - 784 NOT LOADED 785 z 786 y 787 w 788 - 799 NOT LOADED 800 - 811 s Exclude subfield w 812 - 829 NOT LOADED 830 s Exclude subfield w 831 - 839 NOT LOADED 840 s Exclude subfield w 841 - 855 y 856 y or v 856 loads into FGT v if the string “|2pika” is present in the field. However, the field is protected so this would only load if there were not already a matching field in the record. If there is already a |2pika field, then this will not load. Otherwise 856 loads into FGT y. 857 - 865 NOT LOADED 866 h 867 - 868 y 869 - 879 NOT LOADED 880 y 881-897 NOT LOADED 898 y 899 NOT LOADED 900 - 906 y 907 - 908 NOT LOADED Used to store Sierra record numbers when records are exported This would be confusing if these were loaded into the system and stored, they would be exported again, and mixed up with current numbers for attached records. 909 - 916 y 917 NOT LOADED Used by Marquis for the bib record number for matching 918 - 937 y 938 NOT LOADED Often filled with junk from other systems in OCLC 939 - 947 y 948 NOT LOADED Used to record our authority vendor loading information 949 LOT LOADED Used to create items, but this load does not create items 950 - 957 y 958 NOT LOADED 959 y 960 - 961 NOT LOADED Used for creating order records, not needed to live in bib records 962 - 987 y 988 - 989 NOT LOADED 990 - 994 y 995 m Inserts the text “Loaded with m2btab.acq2 in this month” Ignores any data incoming from the loaded record 996 - 999 y

001||%|0|0|b|o|0|y|N|0|%map="m2bmap.sky" 002-007||%|0|0|b|y|0|y|N|0| 008-009||%|0|0|b|y|0|y|N|0|%008="y" 010||+|0|0|b|l|0|y|N|0| #011-012 NOT LOADED 013-018||+|0|0|b|y|0|y|N|0| 019||+|0|0|b|o|0|y|N|0| 020-023||+|0|0|b|i|0|y|N|0| 024||+|0|0|b|i|0|y|N|0|%map="m2bmap.upc" 025||+|0|0|b|y|0|y|N|0| #026 NOT LOADED 027||+|0|0|b|i|0|y|N|0| 028||+|0|0|b|i|0|y|N|0| #029 NOT LOADED 030-049||+|0|0|b|y|0|y|N|0| 050-084||+|0|0|b|j|0|y|N|0| #085 NOT LOADED 086||+|0|0|b|g|0|y|N|0| #087 NOT LOADED 088||+|0|0|b|j|0|y|N|0| #089 NOT LOADED 090-099||+|0|0|b|j|0|y|N|0| 100-111||-w|0|0|b|a|0|y|N|0| #112-129 NOT LOADED 130||-w|0|0|b|t|0|y|N|0| #131-209 NOT LOADED 210||+|0|0|b|y|0|y|N|0| 211-222||+|0|0|b|u|0|y|N|0| #223-239 NOT LOADED 240||-w|0|0|b|t|0|y|N|0| 241-243||+|0|0|b|u|0|y|N|0| #244 NOT LOADED 245||+|0|0|b|t|0|y|N|0|%bracket="h" 246-247||+|0|0|b|u|0|y|N|0| #248-249 NOT LOADED 250||+|0|0|b|e|0|y|N|0| #251-253 NOT LOADED 254-257||+|0|0|b|y|0|y|N|0| #258-259 NOT LOADED 260-262||+|0|0|b|p|0|y|N|0| 263||+|0|0|b|y|0|y|N|0| 264||+|0|0|b|p|0|y|N|0| 265||+|0|0|b|y|0|y|N|0| #266-269 NOT LOADED 270||+|0|0|b|p|0|y|N|0| #271-299 NOT LOADED 300-399||+|0|0|b|r|0|y|N|0| 400-490||-w|0|0|b|s|0|y|N|0| #491-499 NOT LOADED 500-589||+|0|0|b|n|0|y|N|0| 590||+|0|0|b|v|0|y|N|0| #591-599 NOT LOADED 600-689||-w|0|0|b|d|0|y|N|0| 690-691||-w|0|0|b|v|0|y|N|0| 692-699||-w|0|0|b|d|0|y|N|0| 700-711||-w|0|0|b|b|0|y|N|0| #712-719 NOT LOADED 720||-w|0|0|b|y|0|y|N|0| #721-729 NOT LOADED 730-740||-w|0|0|b|u|0|y|N|0|%bracket="h" #741-751 NOT LOADED 752-755||+|0|0|b|y|0|y|N|0| #756-759 NOT LOADED 760-777||+|0|0|b|q|0|y|N|0| #778-779 NOT LOADED 780||+|0|0|b|x|0|y|N|0| #781-758 NOT LOADED 785||+|0|0|b|z|0|y|N|0| 786||+|0|0|b|y|0|y|N|0| 787||+|0|0|b|w|0|y|N|0| #788-799 NOT LOADED 800-811||-w|0|0|b|s|0|y|N|0| #812-829 NOT LOADED 830||-w|0|0|b|s|0|y|N|0|%bracket="h" #831-839 NOT LOADED 840||-w|0|0|b|s|0|y|N|0| 841-855||+|0|0|b|y|0|y|N|0| 856||+|0|0|b|v|0|y|N|0|%map="m2bmap.art" 856||+|0|0|b|y|0|y|N|0|%map="m2bmap.not" #857-865 NOT LOADED 866||+|0|0|b|h|0|y|N|0| 867-868||+|0|0|b|y|0|y|N|0| #869-879 NOT LOADED 880||+|0|0|b|y|0|y|N|0| #881-897 NOT LOADED 898||+|0|0|b|y|0|y|N|0| #899 NOT LOADED 900-906||+|0|0|b|y|0|y|N|0| #907-908 NOT LOADED 909-916||+|0|0|b|y|0|y|N|0| #917 NOT LOADED 918-937||+|0|0|b|y|0|y|N|0| #938 NOT LOADED 939-947||+|0|0|b|y|0|y|N|0| #948-949 NOT LOADED 950-957||+|0|0|b|y|0|y|N|0| #958 NOT LOADED 959||+|0|0|b|y|0|y|N|0| #960-961 NOT LOADED 962-987||+|0|0|b|y|0|y|N|0| #988-989 NOT LOADED 990-994||+|0|0|b|y|0|y|N|0| |995|T|0|0|b|m|0|y|N|0| |aLoaded with m2btab.acq2 in this month 996-999||+|0|0|b|y|0|y|N|0|

Every load will create one dummy item record based on the mdlholddum item template. There is no means to alter this dummy item. Code: |||0|0| | |0|n|G|0|@link="i:1:#1" 020||i|0|0|i|b|0|n|N|1|#com="i/a"@item

Creates one order record with every load. Order record data will be created based on the 960 and 961 fields. Incoming field Output field Notes 960$a ACQ TYPE 960$b CLAIM 960$c CODE1 960$d CODE2 960$e CODE3 960$f CODE4 960$g FORM 960$h ORD NOTE 960$i ORD TYPE 960$j RACTION 960$k RLOC 960$l BLOC 960$m STATUS 960$n TLOC 960$p CDATE 960$q ODATE 960$r RDATE 960$s E PRICE 960$t LOCATION 960$o COPIES 960$u FUND 960$v VENDOR 960$w LANG 960$x SELECTOR 960$y VOLUMES 020$a ISBN PICK 961$a IDENTITY 961$b FOREIGN CURRENCY 961$c NOTE 961$d INT. NOTE 961$f SELECTOR 961$g VEN. ADDR. 961$h VEN. NOTE 961$i VEN. TITLE# 961$l Blanket PO Number 961$p Blanket PO Number

|||0|0| | |0|n|G|0|@link="o:2:#1" ##order record fixed-length fields## /^960||a|0|0|o| |1|n|N|2|acq type /^960||b|0|0|o| |4|n|N|2|claim /^960||c|0|0|o| |6|n|N|2|code1 /^960||d|0|0|o| |7|n|N|2|code2 /^960||e|0|0|o| |8|n|N|2|code3 /^960||f|0|0|o| |9|n|N|2|code4 /^960||g|0|0|o| |11|n|N|2|format /^960||h|0|0|o| |14|n|N|2|ord note /^960||i|0|0|o| |15|n|N|2|ord type /^960||j|0|0|o| |16|n|N|2|raction /^960||k|0|0|o| |18|n|N|2|rloc /^960||l|0|0|o| |19|n|N|2|bloc /^960||m|0|0|o| |20|n|N|2|status /^960||n|0|0|o| |21|n|N|2|tloc /^960||p|0|0|o| |3|n|N|2|cdate /^960||q|0|0|o| |13|n|N|2|odate /^960||r|0|0|o| |17|n|N|2|rdate /^960||s|0|0|o| |10|n|N|2|eprice /^960||t|0|0|o| |2|n|N|2|location /^960||o|0|0|o| |5|n|N|2|copies /^960||u|0|0|o| |12|n|N|2|fund /^960||v|0|0|o| |22|n|N|2|vendor /^960||w|0|0|o| |23|n|N|2|language /^960||x|0|0|o| |100|n|N|2|selector /^960||y|0|0|o| |106|n|N|2|volume ##order record variable-length fields## /^020||a|0|0|o|b|0|n|N|2|PO info /^961||a|0|0|o|i|0|n|N|2|identity /^961||b|0|0|o|x|0|n|N|2|for curr /^961||c|0|0|o|n|0|n|N|2|note /^961||d|0|0|o|z|0|n|N|2|int note /^961||f|0|0|o|s|0|n|N|2|selector /^961||g|0|0|o|q|0|n|N|2|ven addr /^961||h|0|0|o|v|0|n|N|2|ven note /^961||i|0|0|o|f|0|n|N|2|ven title /^961||l|0|0|o|p|0|n|N|2|blanket PO /^961||p|0|0|o|p|0|n|N|2|blanket PO