APIS: Berkeley Metadata Review:
8/2003 file submission

1. Missing dd510_dd fields (Duke Databank Citations) (ca. 1400 records)
   
   For future reference, see instructions at:
   
   http://www.columbia.edu/cu/libraries/inside/projects/apis/documentation/ddbdp.html
   
   especially Note 8.
   
   In order to get these in process for the next round of data loading, I've gone ahead and created a set of DDBDP-formatted citations based on the presence of P.Tebt. (etc.) in the incoming dd510 fields. In the spreadsheet referenced below, there are up to 3 dd510_dd fields per record. Since these are mechanically generated, they include bogus links to literary papyri and documentary papyri volumes not yet available in the DDBDP.
   
   http://www.columbia.edu/cu/libraries/inside/projects/apis/berkeley/input/ddbdp_generation.xls
   
   My suggestion is that someone in your shop find a way to review the DDBDP-type citations in the spreadsheet, cull out any incorrect ones, and then amalgamate these fields into your central database. Or you may be able to find an alternate way to generate needed DDBDP citations, as I believe John Weise did at Michigan.
   
   When inputting new records into your system, however, or adding publication information to existing records, you'll probably want either to define new fields for the parallel manual input of these structured citations, or else generate them semi-automatically in the input system when keying traditional citations, or else generate them automatically in some fashion each time you create extract files to send to the central APIS database. (This last alternative will probably be more error-prone.)
   
   
2. Invalid language codes (ca. 17 recs.)
   
   dd041, e.g. 'grc?', 'dem?' or 'grcd'
   
   berkeley.apis.3735
   berkeley.apis.3738
   berkeley.apis.3740
   berkeley.apis.3741
   berkeley.apis.3744
   berkeley.apis.3745
   berkeley.apis.3788
   berkeley.apis.3889
   berkeley.apis.3890
   berkeley.apis.3918
   berkeley.apis.4152
   berkeley.apis.4063
   berkeley.apis.4087
   berkeley.apis.4292
   berkeley.apis.4293
   berkeley.apis.4300
   berkeley.apis.4301
   berkeley.apis.3232
   

3. Missing presentation (structural) metadata data (ca. 600 records)
   
   These records have the "Part" structure, but no corresponding "Presentation" structures (i.e., links to images, etc.).  Are there images for these records? If not, no "Part" fields should be included.

   
   EXAMPLES
   
   a) berkeley.apis.1015
   
       cuPart_caption | 1 | Recto
      cuPart_no | 1 | 1
      cuPart_section | 1 | recto

   b) berkeley.apis.850

   cuPart_caption | 1 | Frame 1/4 Verso
   cuPart_caption | 2 | Frame 2/4 Verso
   cuPart_caption | 3 | Frame 3/4 Verso
   cuPart_caption | 4 | Frame 4/4 Verso
   cuPart_no | 1 | 1
   cuPart_no | 2 | 2
   cuPart_no | 3 | 3
   cuPart_no | 4 | 4
   cuPart_section | 1 | verso
   cuPart_section | 2 | verso
   cuPart_section | 3 | verso
   cuPart_section | 4 | verso