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:
ID
Embryo Id 
Breed 3
Colour
EID
Sex
Breed 3%
DNA Sample No.
Alternate IDBirth DateBreed 4
Horn 
Sire IDBirth YearBreed 4%
Name
Sire EID
Birth EaseBreed 5
Mating Type (existing animals)
Sire Society ID
No. in BirthBreed 5%
NLIS Id
Dam ID
Breed 1
Breed 6
Dentition
Dam EID
Breed 1%
Breed 6%
Purchase Price ($/Hd)
Dam Society IDBreed 2Alive / Dead
Vendor PIC
Foster Dam ID
Breed 2%Genetic Mgt. Group
Alive / Dead

Data Type: Weight
Stockbook Fields: 
Weight 
Weigh Herd
Weight Type
Wt. Perf. Mgt. Grp.
Weight (Purchase)


Data Type: Date
Stockbook Fields:
Observation Date
Last Handled SB Live
Last Handled SB Date

Data Type: Trait
Stockbook Fields:
Trait Code
E7 Pompe (#Score)
Animal Sighted (#Index)
Trait Value
E7 Pompe (Mgt. Grp.)
Animal Sighted (Mgt. Grp.)
Trait Mgt. Group
E7 Pompe (Obs. Code)
Animal Sighted (Obs. Code)
Trait Obs. Code
E7 Pompe (Comment)
Animal Sighted (Comment)
Trait Comment
PMM Reliability Score (#Score)
SNP Case Number (#Score)
Hair Sample No. (#Score)
PMM Reliability Score (Mgt. Grp.)
SNP Case Number (Mgt. Grp.)
Hair Sample No. (Mgt. Grp.)
PMM Reliability Score (Obs. Code)
SNP Case Number (Obs. Code)
Hair Sample No. (Obs. Code)
PMM Reliability Score (Comment)
SNP Case Number (Comment)
Hair Sample No. (Comment)
Number Reared (#Measurement)
TSU Sample Number (#Score)
MIP Case No. (#Score)
Number Reared (Mgt. Grp.)
TSU Sample Number (Mgt. Grp.)
MIP Case No. (Mgt. Grp.)
Number Reared (Obs. Code)
TSU Sample Number (Obs. Code)
MIP Case No. (Obs. Code)
Number Reared (Comment)
TSU Sample Number (Comment)
MIP Case No. (Comment)


The following list will also appear for each individual trait that has been personally set up in the Setup menu:
Trait Name (#Measurement/ #Index / #Score)
Trait Name (#Obs.Code)
Trait Name (#Comment)
Trait Name (#Mgt.Grp.)
Trait Name (#Herd)

Date Type: Carcase
Stockbook Fields
Body No.
EMA
MSA Index
Right Bruise
P8 Fat
VIA IMF%
Carcase Hot Weight
Left Grade
Muscle Score / Butt
VIA EMY
Carcase Price (per Kg)
Right Grade
Marbling
Tenderness
Left Hot Weight
Dentition
Meat Colour
PH
Right Hot Weight
Jas No.
Fat Colour
Sale Meat Yield
Left Price
Left Entry
Texture
Ossification
Right Price
Right Entry
Rib Fat
MSA Grade
Left Bruise


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
Society ID.
Society Horn
Society Grade
Right Eye Pigment
Society Tattoo
Society Colour
Left Eye Pigment


Date Type: Treatment Details
Stockbook Fields
Product 1
Product 2
Product 3
Product 4
Product 1 Batch No.
Product 2 Batch No.
Product 3 Batch No.
Product 4 Batch No.
Product 1 Qty.
Product 2 Qty.
Product 3 Qty.
Product 4 Qty.
Product 1 Comment
Product 2 Comment
Product 3 Comment
Product 4 Comment

Date Type: Joining Types
Stockbook Fields
Join Herd (New Join)
Practitioner (Contact Code Only)
Join Type (New Join)
Join Sire ( New Join)
Join Comment (New Join)
Join Reference (New Join)
Join Code (New Join)
Join Perf. Mgt. Grp. (New Join)
Join End / out Date (New Join)

Date Type: Preg. Test Details
Stockbook Fields
PT Result
PT Backup Sire
PT Start Conception Date
Pt No. Foetuses Detected
PT Week No.
PT Sire ID

Date Type: ET Flush
Stockbook Fields
Donor
Sire
No. Implanted
No. Frozen
No. Infertile
No. Degenerate
Comment
Program Name
Practitioner(Contact Code Only)
Freeze Method

Date Type: ET Transfer
Stockbook Fields
Recip. Dam
Location (Contact Code Only)
No. of Embryos
Donor Dam
Flush Ref. 
Flush Ref. Practitioner (Contact Code Only)
Comment 
Side
Grade / Quality
Program Name
Embryo ID
Implant Date
Stage
Sire
Synchronisation

Date Type: Location/Group/Class
Stockbook Fields
Mob
Group
Paddock
Paddock Name
Livestock Class


Date Type: General
Stockbook Fields
Animal Note
Animal Comment


Date Type: Scanning
Stockbook Fields
Scanned EMA
Scanned Rump Fat
Scanned EMD
Scanned Marble %
Scanned EMW
Scan Perf. Mgt. Grp.
Scanned Rib Fat
Scan Obs. Code
Scanned Rib Site
Scan Herd

Date Type: Faecal Egg Count Data
Stockbook Fields
WEC
WEC Nematodirus
Faecal Consistency
WEC Obs. Code
WEC Strongyle
WEC Haemonchus
WEC Per. Mgt. Grp.
WEC Flock /Herd

Date Type: Sale Data
Stockbook Fields
Price $/hd
Price $/kg
Buyer Trading Name
Buyer Code
Price c/kg
Buyer Surname
Buyer PIC


Date Type: Purchase Details
Stockbook Fields
Price $/hd
Vendor PIC
Price c/kg
Vendor Dec.

Date Type: Costs
Stockbook Fields
Cost Amount ($)
Description
Date

Date Type: Extra Carcse Data
Stockbook Fields
Alpha 1 Field
Number 1 Field
Alpha 2 Field
Number 2 Field
Alpha 3 Field
Number 3 Field
Alpha 4 Field
Number 4 Field
Alpha 5 Field
Number 5 Field
Alpha 6 Field
Number 6 Field
Alpha 7 Field
Number 7 Field
Alpha 8 Field
Number 8 Field
Alpha 9 Field
Number 9 Field
Alpha 10 Field
Number 10 Field
Alpha 11 Field
Number 11 Field
Alpha 12 Field
Number 12 Field

Date Type: Sale Catalogue
Stockbook Fields
Sale Catalogue Name
Sale Catalogue Lot Number
Sale Catalogue Notes

Date Type: DNA Samples
Stockbook Fields
Sample Id
Sample Type

Date Type: DNA Requests
Stockbook Fields
Request ID
Profiles Type
Genetic Test 3
Genetic Test 6
Sample ID
Genetic Test 1
Genetic Test 4
Genetic Test 7
Lab
Genetic Test 2
Genetic Test 5
Genetic Test 8

Date Type: DNA Results
Stockbook Fields
Request ID
Test Name
Case Number
Sample ID
Test Result


Article ID 748

    • Related Articles

    • Weights Data Import 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 ...

    • Import / Export Master CSV File

      Import / Export Master CSV File Before starting backup your data before importing or exporting your data. Please follow the link below to navigate though Importing / Exporting: Importing CSV Files Exporting Data to Other Systems Article ID 1493

    • Importing CSV Files

      Importing CSV Files Importing CSV files with information such as EID's, weights, etc into my Stockbook Always do a backup of your Stockbook data before importing the csv file in case you need to go back and start again. Always create a copy of a .csv ...

    • Importing Carcase Data

      Stockbook provides an option that allows you to import carcass feedback data from Abattoirs. If the meat-works can supply you with a carcase feedback file in CSV format, you are able to import this information directly into Stockbook, which saves you ...

    • 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 ...