UFU01 tab tab11_ind 20040421140716 000007226 ! CAT 20030909 101323 REVIEW 128.227.223.58 ! CAT 20030909 102836 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_ind - Assignment of fields to Direct indexes !============================================================================= ! Last header change: 19/11/2001 ! ! HELP ! The tab11 table is used to assign fields to Direct indexes. Direct indexes ! enable the user to retrieve a specific record. A direct index is suited to ! unique or almost unique identifiers of the record, and serves as quick ! access to a record. ! 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; ; ! 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 Direct 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; ALPHA_NUM; ; ! Not in use; ! Not in use; ! 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 !!!!!-!!!!!-!-!!!!!!!!!!-!!!!!-!!!!!!!!!!!!!!!!!!!!-!-! 010## LCN a 010## NNN a z010 NNN z 020## 020 a 020## NNN a z020 NNN z 022## 022 a 022## NNN a y022 NNN y z022 NNN z 028## AVN a 028## NNN a 028## NNN b 0240# IRC a 0240# NNN a z0240 IRC z z0240 NNN z 0241# UPC a 0241# NNN a z0241 UPC z z0241 NNN z 0242# ISM a 0242# NNN a z0242 ISM z z0242 NNN z 0243# EAN a 0243# NNN a z0243 EAN z z0243 NNN z 0244# SIC a 0244# NNN a z0244 SIC z z0244 NNN z 0247# SNO a 0247# NNN a z0247 SNO z z0247 NNN z 0248# SNU a 0248# NNN a z0248 SNU z z0248 NNN z 027## STRN a z027 STRN z 027## NNN a z027 NNN z 030## COD a z030 COD z 030## NNN a z030 NNN z 035## UTL a 035## NNN a 035## a #ocolc* OCL a 0359# CNO a 037## STK a 037## NNN a 088## RPT a !a088 RPT a !088## RPT z z088 RPT z 088## NNN a !a088 NNN a !088## NNN z z088 NNN z !400## ISSN x !410## ISSN x !411## ISSN x !440## ISSN x !490## ISSN x !76### ISSN x !77### ISSN x !78### ISSN x 260## AVN d 262## AVN celk 909## a #tmp* 909 a !LOC0# LCC hi !LOC0# LCI hi !LOC1# DDC hi !LOC2# MSH hi !LOC2# LCI hi !LOC3# GVD hi !LOC7# OTH hij !LOC7# OTH l !LOC8# OTH hij !LOC8# OTH l !* !* TKR moved to ACC index -- maod 20021230 !* LOC # added for UF -- maod 20030106 !* LOC4, LOC5, LOC6 added for UF -- maod 20030106 !* 020,022,024,027,028,030,088 subfields split out -- maod 20030203 !* LOC $$l's moved to sep line to index separately -- maod 20030408 !* LOC7 $$2 filters added for FLD for NF -- maod 20030408 !* LOC0 and LOC2 added to LCI -- maod 20030509 !* 4xx,7xx $x omitted from ISSN index -> new "ISN" ACC index--ltm20030710 !* OCL index added -- ltm 20030821 !* 909 index added -- ltm 20030826 !* WONLY for OTH and SIC indexes -- ltm 20030829 !* ISBN and ISSN indexes moved to ACC -- ltm 20031003 !* ## added to 035 for OCLC, NNN, UTL indexes -- ltm 20040204 !* LCC, LCI, DDC, MSH, GVD, OTH moved to ACC index per EL recommendation !* to facilitate shelflisting -- ltm 20040204 !* $z split into "virtual tags" to create separate index entries for !* multiple occurrences -- ltm 20040205 !* 260 & 262 added to AVN for UF -- ltm 20040205 !* 010 $z added to NNN, per maod -- ltm 20040205