Name: feed_apollo Description: Raw data from Insentec’s daily VR files. Every time an animal visits an Insentec bin, a record is created. Therefore, each file has all visits made by all animals to all bins on a given day. These files are appended to this table every day. Classification: RDF402 Author: Michelle Edwards Author Email: edwardsm@uoguelph.ca
Date the animal’s RFID was read at the beginning of visit
diet
Diet
Diet inside of the feed bin. Animal-specific diets are named after the respective animal’s number
duration_sec
Duration in Seconds
Duration of the visit
end_time
End Time
Time the animal’s RFID was read at the end of visit
end_weight_kg
End Weight in Kilograms
Weight of the feed bin at the end of visit
intake
Intake in Kilograms
Difference between end_weight and start_weight
start_time
Start Time
Time the animal’s RFID was read at the beginning of visit
start_weight_kg
Start Weight in Kilograms
Weight of the feed bin at the beginning of visit
transponder_id
Transponder ID
RFID from animal tag
International schema information
Language
Name
Description
English
feed_apollo
Raw data from Insentec’s daily VR files. Every time an animal visits an Insentec bin, a record is created. Therefore, each file has all visits made by all animals to all bins on a given day. These files are appended to this table every day.
Language-independent schema details
Attribute
Sensitive
Unit
Type
Character encoding
apollo_id
false
Numeric
utf-8
bin_id
false
Numeric
utf-8
date
false
DateTime
utf-8
diet
false
Text
utf-8
duration_sec
false
DateTime
utf-8
end_time
false
DateTime
utf-8
end_weight_kg
false
Numeric
utf-8
intake
false
Numeric
utf-8
start_time
false
DateTime
utf-8
start_weight_kg
false
Numeric
utf-8
transponder_id
false
Numeric
utf-8
Language-specific schema details
English
Attribute
Label
Description
List
apollo_id
Apollo ID
Animal ID used on Apollo
Not a list
bin_id
Bin ID
Feed bin ID
Not a list
date
Date
Date the animal’s RFID was read at the beginning of visit
Not a list
diet
Diet
Diet inside of the feed bin. Animal-specific diets are named after the respective animal’s number
Not a list
duration_sec
Duration in Seconds
Duration of the visit
Not a list
end_time
End Time
Time the animal’s RFID was read at the end of visit
Not a list
end_weight_kg
End Weight in Kilograms
Weight of the feed bin at the end of visit
Not a list
intake
Intake in Kilograms
Difference between end_weight and start_weight
Not a list
start_time
Start Time
Time the animal’s RFID was read at the beginning of visit