UFU01 tab tab11_acc 20050301180425 000023604 ! CAT 20030411 115509 FCLA 128.227.228.151 ! CAT 20030909 103153 REVIEW 128.227.223.58 ! CAT 20030909 104634 REVIEW 128.227.223.58 ! ! NOTE - 1) do not edit this header section ! - 2) this header is created from the template located ! in $alephe_headers/tab ! - 3) to add remarks within the table, ! start the line with !rem or !* ! - 4) to mark a line as non-used (but restorable) ! add ! at start of line, retaining column structure ! displaced by one position to the right ! - 5) all internal codes must be Latin characters A-Z,0-9 ! !============================================================================= ! tab11_acc - Assignment of fields to headings indexes !============================================================================= ! Last header change: 21/06/2002 ! ! HELP ! The tab11_acc table is used to assign fields to headings indexes. ! END_HELP ! ! COL 1. 5; ALPHA_NUM, UPPER; #; ! Field tag; ! Document record field code. # can be used for the third to ! fifth positions to indicate truncation of numeric additions to ! the field code (e.g., 245## for 2451, 2452, 24501); ! COL 2. 5; ALPHA_NUM; ; ! Not in use; ! Not in use; ! COL 3. 1; ALPHA_NUM; ; ! Subfield filter; ! Subfield to filter. It is used together with column 4. For ! example, if this column contains a '2' and column 4 contains ! 'usm50', then only records with usm50 in subfield 2 ! will have this field indexed; ! COL 4. 10; TEXT, LOWER; ; ! Subfield contents filter; ! Subfield contents filter. It is used together with column 3. ! For example, if column 3 contains a '2' and this column ! contains 'usm50', then only records with usm50 in subfield 2 ! will have this field indexed. If the contents is prefixed by ! a hyphen (minus), the content is considered negative. ! For example, if column 3 contains a '2' and this column ! contains '-usm50', then only records that do not have ! usm50 in subfield 2 will have this field indexed. ! !!NOTE!! filter text must be entered in lower case ! (irrespective of case in the record itself). ! Use * to indicate truncated text, use # to ! indicate single wild card for text match; ! COL 5. 5; ALPHA_NUM, UPPER; ; ! Index code; ! Code of the headings index file; ! COL 6. 20; ALPHA_NUM; -; ! Subfield(s); ! Subfield(s) of the field for indexing. Blank indicates ! entire field. Use minus (-) sign followed by subfields ! to define subfields to be stripped or list the ! subfields to be indexed; ! COL 7. 1; TEXT {A,B,C, ,}; ; ! Group; ! Values are: A, B or C. This column may be used to define a ! particular group of fields that will be used to create a ! new headings index. This option cannot be used for an ! already existing index. Also, this option is available ! only when the program is run from the Unix command line. ! It is not available from the Headings index batch service. ! The following is an example of the way in which the program ! should be run for fields that belong to group B: ! csh -f p_manage_02 USM01,0,000000000,999999999,B,1,N,00, ! Note that the program must be run from under aleph/proc; ! COL 8. 1; TEXT {1,2, ,}; ; ! Non-filing indicator; ! Non-filing indicator for non_filing procedure in tab_filing; ! ! 1 2 3 4 5 6 7 8 !!!!!-!!!!!-!-!!!!!!!!!!-!!!!!-!!!!!!!!!!!!!!!!!!!!-!-! 020## ISBN a z020 ISBN z 022## ISSN a y022 ISSN y z022 ISSN z 074## GPO a z074 GPO z 086## SUD a z086 SUD z 100## AUT abcdgjq 880## 6 100#* AUT abcdgjq 100## APE abcdgjq 880## 6 100#* APE abcdgjq 100## 4 ### PRT abcdgjq 100## TTL klnpt 100## t #* NWT abcdfgjklnpqt 110## AUT abcdgn 880## 6 110#* AUT abcdgn 110## 4 ### PRT abcdgn 110## ACO abcdgn 880## 6 110#* ACO abcdgn 110## TTL klpt 110## t #* NWT abcdfgklnpt 111## AUT acdegnq 880## 6 111#* AUT acdegnq 111## 4 ### PRT acdegnq 111## t #* NWT acdefgklnpqt AT100 NWT abcdfgjklmnopqrst AT110 NWT abcdfgklmnoprst AT111 NWT acdefgklmnoprst 111## AME acdegnq 880## 6 111#* AME acdegnq 111## TTL klpt 130## TTL adgklmnoprst 1 880## 6 130#* TTL adgklmnoprst 130## TUT adgklmnoprst 1 880## 6 130#* TUT adgklmnoprst !222## TTL ab 2 880## 6 222#* TTL ab 222## KTL ab 2 880## 6 222#* KTL ab 240## TTL adgklmnoprs 2 880## 6 240#* TTL adgklmnoprs 240## TUT adgklmnoprs 2 880## 6 240#* TUT adgklmnoprs 242## TTL abnpy 2 243## TTL adgklmnoprs 2 243## TUT adgklmnoprs 2 245## TTL abfgknps 2 880## 6 245#* TTL abfgknps 246## TTL abfgnp 880## 6 246#* TTL abfgnp 247## TTL abfgnp 400## AUT abcdg 400## 4 ### PRT abcdg 400## APE abcdg 400## TTL klnpt 400## t #* NWT abcdfgklnpqt 400## ISSN x 400## SRS klnpt 410## AUT abcdgn 410## 4 ### PRT abcdgn 410## ACO abcdgn 410## TTL klpt 410## t #* NWT abcdfgklnpt 410## ISSN x 410## SRS klpt 411## AUT acdegnq 411## 4 ### PRT acdegnq 411## AME acdegnq 411## TTL klpt 411## t #* NWT acdefgklnpqt 411## SRS klpt 411## ISSN x 440## TTL anp 2 880## 6 440#* TTL anp 440## SRS anp 2 880## 6 440#* SRS anp 440## ISSN x 490## ISSN x !t505 TTL t 505## URI u 506## URI u 514## URI u 520## URI u 530## URI u 534## TTL t 540## URI u 545## URI u 552## URI u !* the original XYZ lines listed below: !6###0 SULX -vxyz6 !6###0 SULX -vxz6 !6###0 SULX -xyz6 !6###0 SULX -yz6 !6###0 SULX -z6 !* new XYZ lines (corrections added 20040311): !6###0 SULX a !6###0 SULX ax 6###0 SULX -vxyz23468 6###0 SULX -vyz23468 6###0 SULX -v23468 600#0 SULX aqbcd 600#0 SULX aqbcdt 610#0 SULX abndc 610#0 SULX abndct 611#0 SULX andc 611#0 SULX andct 630#0 SULX ad !* !600#0 SUB abcdfgjklmnopqrstvxyz 600#0 SUB -ehu23468 880## 6 600#* SUB -ehu23468 !600#0 SUL abcdfgjklmnopqrstvxyz 600#0 SUL -ehu23468 !600#0 4 ### PRT abcdfgjklmnopqrstvxyz 600#0 4 ### PRT -ehu23468 600#0 t #* NWT abcdfgjklmnopqrst !600#1 SUB abcdfgjklmnopqrstvxyz 600#1 SUB -ehu23468 !600#1 SUC abcdfgjklmnopqrstvxyz 600#1 SUC -ehu23468 !600#1 4 ### PRT abcdfgjklmnopqrstvxyz 600#1 4 ### PRT -ehu23468 6###2 SUMX -vxyz6 6###2 SUMX -vxz6 6###2 SUMX -xyz6 6###2 SUMX -yz6 6###2 SUMX -z6 !600#2 SUM abcdfgjklmnopqrstvxyz 600#2 SUM -ehu23468 !600#2 4 ### PRT abcdfgjklmnopqrstvxyz 600#2 4 ### PRT -ehu23468 !600#4 SUB abcdfgjklmnopqrstvxyz 600#4 SUB -ehu23468 !600#4 SUO abcdfgjklmnopqrstvxyz 600#4 SUO -ehu23468 !600#4 4 ### PRT abcdfgjklmnopqrstvxyz 600#4 4 ### PRT -ehu23468 !600#7 SUB abcdfgjklmnopqrstvxyz 600#7 SUB -ehu23468 !600#7 SUO abcdfgjklmnopqrstvxyz 600#7 SUO -ehu23468 !600#7 4 ### PRT abcdfgjklmnopqrstvxyz 600#7 4 ### PRT -ehu23468 610#0 SUB abcdfgklmnoprstvxyz 880## 6 610#* SUB abcdfgklmnoprstvxyz 610#0 SUL abcdfgklmnoprstvxyz 610#0 4 ### PRT abcdfgklmnoprstvxyz 610#0 t #* NWT abcdfgklmnoprst 610#1 SUB abcdfgklmnoprstvxyz 610#1 SUC abcdfgklmnoprstvxyz 610#1 4 ### PRT abcdfgklmnoprstvxyz 610#2 SUM abcdfgklmnoprstvxyz 610#2 4 ### PRT abcdfgklmnoprstvxyz 610#4 SUB abcdfgklmnoprstvxyz 610#4 SUO abcdfgklmnoprstvxyz 610#4 4 ### PRT abcdfgklmnoprstvxyz 610#7 SUB abcdfgklmnoprstvxyz 610#7 SUO abcdfgklmnoprstvxyz 610#7 4 ### PRT abcdfgklmnoprstvxyz 611#0 SUB acdefgklnpqstvxyz 880## 6 611#* SUB acdefgklnpqstvxyz 611#0 SUL acdefgklnpqstvxyz 611#0 4 ### PRT acdefgklnpqstvxyz 611#0 t #* NWT acdefgklnpqst 611#1 SUB acdefgklnpqstvxyz 611#1 SUC acdefgklnpqstvxyz 611#1 4 ### PRT acdefgklnpqstvxyz 611#2 SUM acdefgklnpqstvxyz 611#2 4 ### PRT acdefgklnpqstvxyz 611#4 SUB acdefgklnpqstvxyz 611#4 SUO acdefgklnpqstvxyz 611#4 4 ### PRT acdefgklnpqstvxyz 611#7 SUB acdefgklnpqstvxyz 611#7 SUO acdefgklnpqstvxyz 611#7 4 ### PRT acdefgklnpqstvxyz 630#0 SUB adfgklmnoprstvxyz 1 880## 6 630#* SUB adfgklmnoprstvxyz 630#0 SUL adfgklmnoprstvxyz 1 630#1 SUB adfgklmnoprstvxyz 1 630#1 SUC adfgklmnoprstvxyz 1 630#2 SUM adfgklmnoprstvxyz 1 630#4 SUB adfgklmnoprstvxyz 1 630#4 SUO adfgklmnoprstvxyz 1 630#7 SUB adfgklmnoprstvxyz 1 630#7 SUO adfgklmnoprstvxyz 1 650#0 SUB abcdvxyz 880## 6 650#* SUB abcdvxyz 650#0 SUL abcdvxyz 650#1 SUB abcdvxyz 650#1 SUC abcdvxyz 650#2 SUM abcdvxyz 650#4 SUB abcdvxyz 650#4 SUO abcdvxyz 650#7 SUB abcdvxyz 650#7 SUO abcdvxyz 651## SGE avxyz 651#0 SUB avxyz 880## 6 651#* SUB avxyz 651#0 SUL avxyz 651#1 SUB avxyz 651#1 SUC avxyz 651#2 SUM avxyz 651#4 SUB avxyz 651#4 SUO avxyz 651#7 SUB avxyz 651#7 SUO avxyz 653## SUB a 653## SUO a 654## SUB abcvyz 880## 6 655#* SUB abcvxyz 655## SUB abcvxyz 655## SFG abcvxyz 656## SUB akvxyz 657## SUB avxyz 658## SUB abcd 690# SUB avxyz 880## 6 69#* SUB avxyz 690# SUO avxyz 690#0 SUB avxyz 690#0 SUO avxyz 690#1 SUB avxyz 690#1 SUO avxyz !690#2 SUB avxyz 690#2 SUO avxyz 690#4 SUB avxyz 690#4 SUO avxyz 690#7 SUB avxyz 690#7 SUO avxyz 690#9 SUB avxyz 690#9 SUO avxyz 690#9 SGM avxyz 691# SUB avxyz 691# SUO avxyz 691#0 SUB avxyz 691#0 SUO avxyz 691#1 SUB avxyz 691#1 SUO avxyz !691#2 SUB avxyz 691#2 SUO avxyz 691#4 SUB avxyz 691#4 SUO avxyz 691#7 SUB avxyz 691#7 SUO avxyz 691#9 SUB avxyz 691#9 SUO avxyz 691#9 SGM avxyz 692## SUB avxzy 692## SUO avxzy 693## SUB avxzy 693## SUO avxzy 694## SUB avxzy 694## SUO avxzy 695## SUB avxzy 695## SUO avxzy 696## SUB avxzy 696## SUO avxzy 697## SUB avxzy 697## SUO avxzy 698## SUB avxzy 698## SUO avxzy 699## SUB avxzy 699## SUO avxzy 699#9 SCN avxzy 700## AUT abcdgjq 880## 6 700#* AUT abcdgjq 700## APE abcdgjq 880## 6 700#* APE abcdgjq 700## 4 ### PRT abcdgjq 700## TTL klmnoprst 880## 6 700#* TTL klmnoprst 700## t #* NWT abcdfgjklmnopqrst 705## AUT a 705## APE a 705## PRT a 710## AUT abcdng 880## 6 710#* AUT abcdng 710## ACO abcdng 880## 6 710#* ACO abcdng 710## 4 ### PRT abcdng 710## TTL klmnoprst 880## 6 710#* TTL klmnoprst 710## t #* NWT abcdfgklmnoprst 711## AUT acdegnq 880## 6 711#* AUT acdegnq 711## AME acdegnq 880## 6 711#* AME acdegnq 711## 4 ### PRT acdegnq 711## TTL eklpst 880## 6 711#* TTL eklpst 711## t #* NWT acdefgklnpqst 715## AUT a 715## ACO a 715## PRT a 730## TTL adfgklmnoprst 1 880## 6 730#* TTL adfgklmnoprst 730## TUT adfgklmnoprst 1 880## 6 730#* TUT adfgklmnoprst 740## TTL anp 1 880## 6 740#* TTL anp 76### ISSN x !760## TTL st !760## TUT s !762## TTL st !762## TUT s 77### ISSN x 770## AUT a !770## TTL ckst !770## TUT s !772## TTL ckst !772## TUT s 773## AUT a !773## TTL kpst !773## TUT s !774## TTL ckst !774## TUT s 78### ISSN x 780## AUT a !780## TTL ckst !780## TUT s 785## AUT a !785## TTL ckst !785## TUT s 787## AUT a !787## TTL ckst !787## TUT s 800## AUT abcdgjq 880## 6 800#* AUT abcdgjq 800## APE abcdgjq 880## 6 800#* APE abcdgjq 800## 4 ### PRT abcdgjq 800## TTL klmnoprst 880## 6 800#* TTL klmnoprst 800## t #* NWT abcdfgjklmnopqrst 880## 6 800#* srs klmnoprst 800## SRS klmnoprst 810## AUT abcdgn 880## 6 810#* AUT abcdgn 810## ACO abcdgn 880## 6 810#* ACO abcdgn 810## 4 ### PRT abcdgn 810## TTL klmoprst 880## 6 810#* TTL klmoprst 810## t #* NWT abcdfgklmnoprst 880## 6 810#* SRS klmoprst 810## SRS klmoprst 811## AUT acdegnq 880## 6 811#* AUT acdegnq 811## AME acdegnq 880## 6 811#* AME acdegnq 811## 4 ### PRT acdegnq 811## TTL klpst 880## 6 811#* TTL klpst 811## t #* NWT acdefgklnpqst 880## 6 811#* SRS klpst 811## SRS klpst 830## TTL adgklmnoprst 2 880## 6 830#* TTL adgklmnoprst 830## TUT -hv68 2 830## SRS adgklmnoprst 2 880## 6 830#* SRS adgklmnoprst 840## TTL av 840## SRS av 880## 6 840#* SRS av 856## x -xnoindex* URI u !880## VER -0123465789 970## AUT df 970## ACO d 970## APE f 9701# TTL t 9702# TTL t TKR## TKR !* call # indexes below moved from IND, modified to shelflist !* -- lmt 20040204 !SHL0# LCC hi SHL0# h #* LCI hiabdpts SHL1# h #* DDC hiabdpts !SHL2# MSH hi SHL2# h #* LCI hiabdpts SHL3# h #* GVD hiabdpts !SHL3# j #* GVD jabdpts SHL4# h #* OTH hiabdpts SHL5# l #* OTH labdpts SHL6# h #* OTH hiabdpts SHL7# h #* OTH hijabdpts SHL7# j #* OTH jabdpts SHL7# l #* OTH labdpts SHL8# h #* OTH hijabdpts SHL8# j #* OTH jabdpts SHL8# l #* OTH labdpts !OWN## OWN !* !* 086 added for UF -- maod 20030106 (all -- ltm 20030829) !* 655 added for UF -- maod 20030106 !* 690#9, 691#9 SGM added for UF -- maod 20030106 (& NF ltm 20030829) !* 699#9 added for UF -- maod 20030106 !* 880 added for UF -- maod 20030106 !* 774 split into 2 lines for subfields a & z - maod 20030203 !* TKR commented out - maod 20030403//uncommented -- maod 20030523 !* $4 removed from author/name indexes -- maod 20030403 !* 222 filing indicator added -- maod 20030523 !* 4xx & 8xx $v removed from indexing; sort by $v in Brf Rcds -- maod 20030523 !* $t added to AUT, ACO, AME, APE indexes for 100,11x,400,41x,700,71x,800 !* 81x fields to match on auth records -- ltm 20030710 REMOVED !* 4xx, 7xx $x indexed in new ISN index;no longer in ISSN IND -- ltm 20030710 !* 6XX XYZ index added, per USM01 pattern -- ltm 20030715 REMOVED !* 1xx,4xx,7xx,8xx XYZ indexing added as experiment -- ltm 20030717 REMOVED !* removed $e from 100 in APE and AUT -- ltm 20030820 !* removed 6###2 from SUB index -- ltm 20030820 !* removed $f from TTL and TUT indexes -- ltm 20030820 !* removed 760 and above tags from TUT index -- ltm 20030825 !* added x10,x11,400,600,800 to PRT index -- lmt 20030825 !* removed $e from x10,x11 index entries -- ltm 20030825 !* NWT index added: tab_expand_join defines tags & tab_expand ACC includes !* new expand -- ltm 20030827 !* edited to change column 6 to fields to be kept instead of stripped for all cases dec 20030827 !* added SSP, SSC, SSK, SST for NF, SSC, SSK for UWF as a test -- ltm 20030829 !* removed 76x, 77x from TTL index -- ltm 20030829 !* OWN added (with serious reservations) -- ltm 20030901 !* OWN removed -- ltm ? !* NWT $t syntax corrected -- ltm 20030924 !* 5xx indicators corrected -- ltm 20030924 !* ISSN & ISBN moved from IND to ACC -- ltm 20031003 !* former ISN index entries moved to ISSN index -- ltm 20031003 !* removed 780/785/787 from TTL index -- ltm 20031010 !* SULX and SUMX indexes added -- ltm 20031026 !* removed 650#2, 690#2, 691#2 from SUB -- ltm 20031229 !* Uncommented 880 to allow cjk indexing -- dec 20040120 !* call # indexes moved from IND to ACC, now indexing SHL* "virtual fields" !* for shelflisting purposes -- ltm 20040204 !* control # subfield z moved to virtual fields to enable indexing of separate !* instances of repeatable subfields -- ltm 20040205 !* fix LCI to contain LOC0# and LOC2# -- cut LOC2# MSH; cut LOC0# LCC.[UFonly] !* db@uf 20031210 - ltm 20040205 !* re-add LOC4, LOC5, LOC6 for UF [UF only] db@uf20031217 - ltm 20040205 !* t505 virtual field created to index separate instances of $t -- ltm 20040205 !* z074 virtual field created to index separate instances of $z -- ltm 20040205 !* 650 $e removed -- ltm 20040205 !* 650#2 removed from SUB -- ltm 20040205 !* SULX index entries modified per Gerald Langford's specs -- ltm 20040206 !* call number indexing includes author/title data for shelflisting -- ltm 20040223 !* 600 lines changed to -ehu23468 because column width doesn't permit !* inclusion of all desired subfields without use of "-" -- ltm 20040223 !* XYZ/SULX corrections added -- ltm 20040311 !* t505 removed from TTL index -- ltm 20040401 !* 690# and 691# added to SUB, SUO - ltm 20040518 !* 610 lines corrected to include $v, p_manage_40 running 09/04 to !* correct affected records -- ltm 20040901 !* 880 added for various tags but commented out for now -- dec 20041206 !* 880s uncommented and verified for implementation -- dec 20041221 !* 222 removed from TTL index -- ltm 20041228 !* y022 added to ISSN, correction -- ltm 20041228 !* Added truncation symbol (*) to col. 4 for 880s to index all atl. chars -- dec 20050124 !* 970 added to support BNA TOC (UF only) -- maod 20050202 !* 856 $x filter added to drop long URLs - maod 20050301