Data Formats, Requirements, and Default Values

 Birth date (REQUIRED) 
 SlaughterDate — Date format: "yyyy-mm-dd"|"Mon dd, yyyy"|"mm/dd/yyyy"

       M : Male
       F : Female
       C : Cow
       S : Steer
       B : Bull

 EarTag — (optional but important) EarTag Number from farm.

 PedID — (automatically generated) "Pedigree ID", Assigned based on this
         this rule: 4 digits year + additional number, where "additional
         number" is determined by:
         (1) if ISU animal: 4-5 digits EarTag (left pad to 4 if less); OR
         (2) if External animal: 6 digits EarTag (left pad to 6 if less); OR
         (3) if No EarTag: 3 digits incremental number within a year (001-999),
             left pad to 3 digits if less.

 PreRegID — Intrim IDs, formulated from "BirthID" + other info,
            used as a handle to communicate with breed associations.
            (for historical data; may be deprecated??)

 RegID — Registration ID obtained from breed association.
 Intl_ID — International (cattle) ID (refer to CBCD ID Guide)

 Location|Farm code — (REQUIRED) Codes defined in this database.
                      Location codes are assigned as location info are
                      added to this db.
                      Code a column when there are different locations
                      on one sheet; Otherwise not to code but to use
                      pull-down selector at step 4 during data upload.

 Breed code — (REQUIRED) Code defined in this database.
              Breed code are assigned as breed info entered into the db.
              Code a column when there are different breeds on
              one data sheet; Otherwise not to code but use
              pull-down selector at step 4 during data upload.

 ISUBPID — ISU Breeding Program ID (aka. ISU Farm Birth ID)

 Season — S - Spring (Birth time season)
          F - Fall

 Presentation — Birth orientation (normal, abnormal,
                Anterior, Posterior, etc?) [Abbr. format or free text??]

 TWorET — Twin or Embryo transferred 

 AIorNA — AI (artificial insemination) or NAtural born


 o How to use "Comments" field to enter in-frequent meta data:

   "Comments" field is a free text space. It's designed to accept multiple
   and varying kinds of meta data that's easily parsable/retrievable.

    1. One piece of meta data be represented by "name":"value" pairs
    2. Multiple meta data are separated with semi-column (";")
       (therefore the “:” and “;” are reserved, they cannot be used
       elsewhere in “Comments” text)

   Example: "Data source: ABC Lboratory; Note: this animal might ate
   something before blood sampling".

   Note: All text can be in one line.

A shared copy of this doc is for cooperated edits.
Last update: June 11 2024 05:18 PM.