Columbia Escutcheon
Special Columbia Conversion Processes
          Path:  APIS  :  APIS Documentation  :  Metadata  :  Columbia Conversion  
NB: This document is to be used in conjuction with the Columbia / APIS Conversion Data Map, which includes requirements for straightforward data conversions.  More complex conversions (e.g., those involving multiple fields or data manipulation) are documented below.

  1. Dates (046)

    Convert MARC 046 dates as following:

                             046 |aq|b500|d690

    converts to:

                            cuDate_1 | 1 | -690
                            cuDate_2 | 1 | -500
    etc.
  2. Author/Associated Names

    Convert MARC 100/700 to cu100a and cu1004 as follows:

    1. Move each 100|a or 700|a to cu100a
    2. If 100|a, create a new cu1004 with content "aut" [i.e., author]
      if 700|a, create a new cu1004 with content "asn" [i.e., associated name]

      3. EXAMPLES

       

      a)  100 |aEuripides  converts to:
        cu100a | 1 | Euripides
           and
      cu1004 | 1 | aut
         
      b)  700 |aAthenarous, wife of Moros converts to:
       

      cu100a | 1 | Athenarous, wife of Moros
           and
      cu1004 | 1 | asn

      NB: See CLIO record KEY AAA0934. ($b used & not converted; fix error or convert as $c?)


  3. Writing Material / Medium (cu655)

    1. Transfer source MARC 300 field to APIS record as such.

    2. Also scan source MARC 300 field content for specified writing material / medium and generate a single cu655 field according to the following conversion table. (NB: The $ indicates wild card truncation.)

      Material/medium conversions
      300a text
      		   cu655 genre term
      papy$
      		   Papyri
      ostrac$
      		   Ostraca
      paper
      		   Paper

      EXAMPLE:

      300 |a1|fitem :|bpapyrus, twenty-one partly joined fragments ...
      converts to:

      300 | 1 | 1 item : papyrus, twenty-one partly joined fragments ...
      and
      cu655 | 1| Papyri
                                                         
  4. Reference / Link to Duke Databank of Documentary Papyri (DDBDP)

    Convert incoming 510 fields with P.Col. references (only) to both cu510 and cu510_dd (DDBDP citation form for link to Project Perseus)

    EXAMPLE

    "|aP.Col. II|b1 recto 2"

         converts to

    cu510 | 1 | P.Col. II 1 recto 2
         and
    cu510_dd | 1 | P.Col.:2:1


Columbia Libraries    Digital Program
Last revision: 09/10/03
© Columbia University