Column | Mandatory? | Notes | Examples |
ID | Yes | The ID of the animal (Commonly known as the Eartag or visual ID) | Eartag, Visual ID |
REG NUMBER | No | The registration ID of the animal | Official government number |
EID | No | The EID of the animal (Commonly known as the RFID or electronic number) | RFID, electronic number |
BIRTHDATE | Yes | The animal's date of birth | |
PEN | Yes | The animal's current Pen/Group (If unknown put 0) | |
SEX | Yes | The animal's sex (F, Female, M, Male) | |
BREED | No | The animal's breed (HO, JE, Holstein, Jersey, etc) | |
DAM ID | No | The animal's DAM ID (Dam's eartag or registration ID) | |
SIRE | No | The animal's SIRE (The animal's father) | |
MGSIR | No | The animal's Maternal Grand Sire (Mom's father) | |
FRESH DATE | No | The animal's last known freshen date | |
LACT | No | The animal's current lactation number (Integers only) | |
LAST BRED DATE | No | The animal's most recent service date | |
SERVICE SIRE | No | The sire associated with animal's most recent service | |
CDAT or REPRO STATUS | No | Conception Date or current Repro Status | |
DRY OFF DATE | No | Date of the last dry off. Only use if the animal is currently Dry | |
DNB Date or REPRO STATUS | No | Last DNB Date or current Repro Status | |
CULL DATE | No | Date of the animal was culled | Sold Date, Death Date, etc |
PURCHASED DATE | No | Date of purchase or entered herd | |
WEIGHT DATE | No | Date of last weight | |
WEIGHT | No | Last weight (integers only) | 500, 1000, etc |
STATUS DATE | Yes | If not sure, use animal's birth date | |
LAST ABORTION DATE | No | Date of last abortion |