Scope: This document describes the weekly extract script for authority control vendor services (ACVS) including records that should be excluded from processing.
Contact: Leeda Adkins
Unit: Metadata & Discovery Strategy Department
Date last reviewed:8 11/517/20192022
Date of next review: acvs_weekly_bibscan.pl (**confirm name with LSIS)11/17/2023
...
Shell script is auth_wkly.sh and the Perl script is auth_wkly_query.pl
This Perl script calculates today’s date and last week’s date in order to capture all records in the DUK01 Z00 table that have a DUK01 Z106_UPDATE_DATE between those dates.
- Format Z00_DATA: (for each tag until Z00_DATA_LEN is reached)
Index From | Index To | Description |
0 | 3 | Field Length |
4 | 6 | Field Tag |
7 | 8 | Spaces |
9 | 9 | “L” constant for each Field |
10 | Field Length | Field |
17 | 17 | Encoding Level |
...
2. Exclude selected records:
...
Exclude if Tag is (245, 590 or 500) and Field is TEMPORARY RECORD
Exclude if Tag 035 has $a prefix of (SMI)
Exclude if Tag is 904 and Field is:
- Serials Solutions supplemental brief
- Serials Solutions original
- Bowker Global Books in Print
- Vendor-generated brief
- Temporary record
...
3. For regular extracts exclude if last update is:
- ACVS
- NEWCAT
- MADSSCRIPT
- OCLCEXP
4. For annual BIBFILEREPLACE extract, follow excludes listed in 2. above.