Criteria for ACVS Bibliographic Extracts

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: 07 Sep 2021
Date of next review: 01 Sep 2022

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. 

1. Format Z00_DATA:  (for each tag until Z00_DATA_LEN is reached)

2. Exclude selected records: 

              Exclude if Tag is STA and Field is (SUPPRESSED, DELETED, CRASH, or CIRC-CREATED)

              Exclude if Tag is DEL

              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

4. For annual BIBFILEREPLACE extract, follow excludes listed in 2 above.