Data Types and Stockbook Fields

Data Types and Stockbook Fields

Data Types and Stockbook Fields

When importing a CSV file to Stockbook the CSV file headings will need to be linked to Data Types and Stockbook Fields. 
The following is a list of Data Types and associated Stockbook fields available:

Data Type: Life Data
Stockbook Fields
  1. ID
  2. EID
  3. Alternate ID
  4. Sire ID
  5. Sire EID
  6. Sire Society ID
  7. Dam ID
  8. Dam EID
  9. Dam Society ID
  10. Foster Dam ID
  11. Recip. Dam ID
  12. Embryo ID
  13. Sex
  14. Birth Date
  15. Birth Year
  16. Birth Ease
  17. No. in Birth 
  18. Breed 1
  19. Breed 1%
  20. Breed 2
  21. Breed 2%
  22. Breed 3
  23. Breed 3%
  24. Breed 4
  25. Breed 4%
  26. Breed 5
  27. Breed 5%
  28. Breed 6
  29. Breed 6%
  30. Alive /Dead
  31. Genetic Mgt. Group
  32. Colour
  33. DNA sample No.
  34. Horn 
  35. Name 
  36. Mating Type (existing animals) 
  37. NLIS ID
  38. Dentition 
  39. Purchase Price ($/Hd)
  40. Vendor PIC
  41. TTag/Flock 
Data Type: Weight
Stockbook Fields: 
  1. Weight 
  2. Weight (Purchase
  3. Wt. Perf.Mgt.Grp
  4. Weight Type
  5. Weight Herd
Data Type: Date
Stockbook Fields:
  1. Observation Date
  2. Last Handled SB Date
  3. Last Handled Live Date
Data Type: Trait
Stockbook Fields
  1. Trait Code
  2. Trait Value
  3. Trait Mgt.Grp
  4. Trait Obs.Code
  5. Trait Comment 
  6. Hair Sample No. (#Score)
  7. Hair sample No. (#Mgt.Grp)
  8. Hair Sample No. (#Obs.Code)
  9. Hair Sample No. (Comment)
  10. MIP Case No. (#Score)
  11. MIP Case No. (Mgt. Grp.)
  12. MIP Case No. (Obs. Code)
  13. MIP Case No. (Comment)
  14. PMM Reliability Score (#Score)
  15. PMM Reliability Score (Mgt. Grp.)
  16. PMM Reliability Score (Obs. Code)
  17. PMM Reliability Score (Comment)
  18. Number Reared (#Measurement)
  19. Number Reared (Mgt. Grp.)
  20. Number Reared (Obs. Code)
  21. Number Reared (Comment)
  22. Animal Sighted (#Index)
  23. Animal Sighted (Mgt. Grp.)
  24. Animal Sighted (Obs. Code)
  25. Animal Sighted (Comment)
  26. Semen Morphology (#Index)
  27. Semen Morphology (Mgt. Grp.)
  28. Semen Morphology (Obs. Code)
  29. Semen Morphology (Comment)
  30. SNP Case Number (#Score)
  31. SNP Case Number (Mgt. Grp.)
  32. SNP Case Number (Obs. Code)
  33. SNP Case Number (Comment)
  34. TSU Sample Number (#Score)
  35. TSU Sample Number (Mgt. Grp.)
  36. TSU Sample Number (Obs. Code)
The following list will also appear for each individual trait that has been personally set up in the Setup menu:
  1. Trait Name (#Measurement/ #Index / #Score)
  2. Trait Name (#Obs.Code)
  3. Trait Name (#Comment)
  4. Trait Name (#Mgt.Grp.)
  5. Trait Name (#Herd)
Data Type: Fleece
Stockbook Fields
  1. Micron (FD)
  2. Micron Deviation
  3. Micron SD (FDSD)
  4. FD Coefficient (FDCV)
  5. GFW
  6. Course Edge Micron (CEM)
  7. Comfort Factor
  8. Spinning Fineness (FDSF)
  9. Length (SL)
  10. Yield% (YLD)
  11. Min Micron
  12. Max Micron
  13. FPFT Length
  14. MFE Micron (MFE)
  15. SD Along
  16. Curvature (CURV)
  17. Curvature SD (CURVESD)
  18. BWT
  19. CRV Fibre Diam
  20. CRV Fibre Len
  21. CFW
  22. Staple Strength (SS)
  23. Perf. Mgt.Grp.
  24. Months Growth (MONTHSWOOL)
  25. Weight 2
  26. Weight 3
  27. Course Edge (FDCE)
  28. % Tip Break
  29. % Mid Break
  30. % Base Break
  31. Obs. Code
  32. Bin
Date Type: Carcase
Stockbook Fields
  1. Body No.
  2. P8 Fat
  3. Muscle Score/Butt
  4. Marbling
  5. Meat Colour
  6. Fat Colour
  7. Texture
  8. Rib Fat
  9. EMA
  10. Via IMF %
  11. Via EMY
  12. Tenderness
  13. PH
  14. Sale Meat Yield
  15. Ossification
  16. MSA Grade
  17. MSA Index
  18. Carcase Hot Weight
  19. Carcase Price (per Kg)
  20. Left Hot Weight
  21. Right Hot Weight
  22. Left Price
  23. Right Price
  24. Left Bruise 
  25. Right Bruise
  26. Left Grade
  27. Right Grade
  28. Dentition
  29. JAS No.
  30. Left Entry 
  31. Right Entry
Date Type: EBV
Stockbook Fields
This list will contain all EBV's that are active under the EBV Setup Menu.

Date Type: Society Details
Stockbook Fields
  1. Society Id.
  2. Society Tattoo
  3. Society Horn
  4. Society Colour
  5. Society Grade
  6. Left Eye Pigment
  7. Right Eye Pigment

Date Type: Treatment Details
Stockbook Fields
  1. Product 1
  2. Product 1 Batch No.
  3. Product 1 Qty.
  4. Product 1 Comment 
  5. Product 2
  6. Product 2 Batch No.
  7. Product 2 Qty.
  8. Product 2 Comment 
  9. Product 3
  10. Product 3 Batch No.
  11. Product 3 Qty.
  12. Product 3 Comment 
  13. Product 4
  14. Product 4 Batch No.
  15. Product 4 Qty.
  16. Product 4 Comment 
Date Type: Joining Details 
Stockbook Fields
  1. Join Herd (new join)
  2. Join Perf. Mgt. Grp (new join)
  3. Join Sire (new join)
  4. Join Type (new join)
  5. Join Code (new join)
  6. Join Reference (new join)
  7. Practitioner (contact coe nly
  8. Join End/Out Date (new join)
  9. Join Comment (new join)
Date Type: Preg. Test Details
Stockbook Fields
  1. PT Result
  2. PT Days No.
  3. PT Weeks No.
  4. PT Months No.
  5. PT No. Foetuses Detected
  6. PT Start Conception Date
  7. PT is Backup Sire
  8. PT Sire ID
Date Type: ET Flush
Stockbook Fields
  1. Donor
  2. Sire
  3. No. Implanted
  4. No. Frozen 
  5. No. Infertile
  6. No. Degenerated
  7. Comment 
  8. Program Name
  9. Practitioner (contact code only)
  10. Freeze Method 
Date Type: ET Transfer
Stockbook Fields
  1. Recip. Dam 
  2. Embryo Id
  3. Donor Dam 
  4. Sire
  5. Comment 
  6. No. of Embryos
  7. Program Name
  8. Practitioner (Contact Code Only)
  9. Stage 
  10. Grade/Quality 
  11. Location (Contact Code Only)
  12. Implant Date
  13. Flush Ref. 
  14. Synchronisation 
  15. Side 
Date Type: Location/Group/Class
Stockbook Fields
  1. Mob 
  2. Group 
  3. Paddock (No.)
  4. Paddock (Name) 
  5. Livestock Class
Date Type: General
Stockbook Fields
  1. Animal Note 
  2. Animal Comment 
Date Type: Scanning
Stockbook Fields
  1. Scanned EMA
  2. Scanned EMD
  3. Scanned EMW
  4. Scanned Rib Fat
  5. Scanned Rib Site
  6. Scanned Rump Fat
  7. Scanned Marble%
  8. Scan Perf.Mgt.Grp
  9. Scan Obs. Code
  10. Scan Herd
Date Type: Faecal Egg Count Data
Stockbook Fields
  1. WEC
  2. WEC Strongyle
  3. WEC Nematodirus
  4. WEC Haemonchus
  5. Faecal Consistency
  6. WEC Perf.Mgt.Grp
  7. WEC Obs. Code
  8. WEC Flock/Herd
Date Type: Sale Data
Stockbook Fields
  1. Price $/hd
  2. Price c/kg
  3. Price $/kg
  4. Buyer PIC
  5. Buyer Code
Date Type: Purchase Details
Stockbook Fields
  1. Price $/hd
  2. Price c/kg
  3. Vendor PIC
  4. Vendor Dec.
Date Type: Costs
Stockbook Fields
  1. Cost Amount $
  2. Description 
  3. Date
Date Type: Extra Carcse Data
Stockbook Fields
  1. Extra N1
  2. Extra A1
  3. Extra N2
  4. Extra A2
  5. Extra N3
  6. Extra A3
  7. Extra N4
  8. Extra A4
  9. Extra N5
  10. Extra A5
  11. Extra N6
  12. Extra A6
  13. Extra N7
  14. Extra A7
  15. Extra N8
  16. Extra A8
  17. Extra N9
  18. Extra A9
  19. Extra N10
  20. Extra A10
  21. Extra N11
  22. Extra A11
  23. Extra N12
  24. Extra A12
Date Type: Sale Catalogue
Stockbook Fields
  1. Sale Catalogue Name
  2. Sale Catalogue Lot Number
  3. Sale Catalogue Notes
Date Type: DNA Samples
Stockbook Fields
  1. Sample Id
  2. Sample Type
Date Type: DNA Requests
Stockbook Fields
  1. Request ID
  2. Sample ID
  3. Lab
  4. Profile Type
  5. Genetic Test 1
  6. Genetic Test 2
  7. Genetic Test 3
  8. Genetic Test 4
  9. Genetic Test 5
  10. Genetic Test 6
  11. Genetic Test 7
  12. Genetic Test 8
Date Type: DNA Results
Stockbook Fields
  1. Request ID
  2. Sample ID
  3. Test Name
  4. Test Result
  5. Case Number

Article ID 748

    • Related Articles

    • Import a CSV File

      Importing a CSV File Importing CSV files allows the user to bring animals and associated data into Stockbook. Before you begin Always take a backup of your Stockbook data before importing CSV files. CSV files can corrupt so it is advisable to create ...

    • Importing Weights Data from CSV file

      Importing a Weights Data CSV file into Stockbook Until you are confident in importing the values please make sure to take a Backup before importing the data. If you have the CSV file open, please close it. Stockbook will not import data from a CSV ...

    • Exporting Data (Master CSV)

      Stockbook provides you with an easy method of creating a master .CSV (comma-separated variable) file, containing selected information, for easy transfer to other equipment or loading into other software. 1. Select Animals If you Do Not wish to ...

    • Import Sheep Genetics data into Stockbook

      Import Sheep Genetics Data into Stockbook Go the Sheep Genetics website: http://www.sheepgenetics.org.au/Home Login to the Sheep Genetics system using your login and password Find the file to import and save it to a convenient location Open Stockbook ...

    • Importing Carcase Data

      You are able to import carcase feedback from the Abattoir directly into Stockbook. The file must be in a CSV format. Importing carcass feedback data from Abattoirs Note: best practice is to create a copy of the CSV file before you open it to avoid ...