ArrivalDate
|
Arrival date
|
BirthDate
|
Birthdate of the animal
|
Birthings
|
Number of Calvings recorded in a female's history. This value can be different from Parity if Initial Parity does not = 0 when a female is entered into the breeding herd. Parity = Initial Parity + Births. Births only refers to recorded Calvings. It is necessary in some functions, like SUM(Liveborn) / Births
|
BirthLitterId
|
Litter ID of the female
|
Bool1
|
User variable Bool1
|
Bool2
|
User variable Bool2
|
Bool3
|
User variable Boo3
|
Bool4
|
User variable Bool4
|
Comment
|
Any user-defined Comment inserted in the Current Status sheet
|
CurBirthLocation
|
Current calving location. A Location event that is entered within 14 days before or after a calving event.
|
CurLabels
|
"Assigned labels separated by ;"
|
CurGroupDate
|
Date of last group change
|
CurGroupId
|
Current group Id
|
CurLoc1
|
Location level 1
|
CurLoc2
|
Location level 2
|
CurLoc3
|
Location level 3
|
CurParity
|
Current parity number of the breeding female
|
Dam
|
Dam of the animal, defined in Genealogy sheet of the File
|
DateTime1
|
User variable DateTime1
|
DateTime2
|
User variable DateTime2
|
DateTime3
|
User variable DateTime3
|
DateTime4
|
User variable DateTime4
|
Decimal1
|
User variable Decimal1
|
Decimal2
|
User variable Decimal2
|
Decimal3
|
User variable Decimal3
|
DueBirthDate
|
Estimated Calving date, calculated from the date of the last service in the current parity + gestation length in days, as defined by the user in Options|Time Intervals|
|
DueDryOffDate
|
Due dry-off date
|
DueHeatDate
|
Date to observe for estrus, determined by the average length of an estrous cycle, as defined by user in Options|Time Intervals. It includes served and weaned females.
|
DuePrebirthDate
|
Date to perform a pre-Calving task, determined by number of days before the estimated Calving date as defined by user in Options|Time Intervals
|
DuePregCkDate
|
Date to test for pregnancy confirmation, determined by number of days after service as defined by user in Options|Time Intervals
|
EntryActiveDate
|
The date on which a breeding animal enters the breeding herd, null if itoccurred in another farm
|
EntryAge
|
Age at entry
|
EntryDate
|
The date on which a breeding animal enters the breeding herd
|
EntryWeight
|
The weight of a breeding animal when it enters the breeding herd
|
FstBirthingDate
|
First calving date
|
Genetics
|
Genetics or breed
|
HeatLstDate
|
The date of the last heat recorded for a female (heat not served or service event)
|
HNSFstServNo
|
Number of Heat Not Served events before the first service in parity 0 females
|
Id
|
Primary animal identification
|
IID_CurParity
|
Foreign key to current parity
|
IID_EntryEvent
|
Foreign key to entry event
|
IID_Female
|
Internal female identification. Used to link several tables together. Using a relational model, sometimes is necessary to join 2 or more tables. For example SQL can use Females.ID and Parity.ID to join these 2 tables, but it is not efficient (more time consuming). IID_FEMALE is a numeric indexed internal identification. Its value is assigned automatically by Porcitec and it speeds up use of SQL commands
|
IID_LstPCondition
|
Foreign key to last physical condition event
|
IID_LstPCondition1
|
Foreign key to last physical condition event with A type
|
IID_LstPCondition2
|
Foreign key to last physical condition event with B type
|
IID_LstPCondition3
|
Foreign key to last physical condition event with C type
|
IID_LstTreatment
|
Foreign key to last treatment
|
IID_LstUserEvent1
|
Foreign key to last user event 1
|
IID_LstUserEvent2
|
Foreign key to last user event 2
|
IID_LstUserEvent3
|
Foreign key to last user event 3
|
IID_P0FstHns
|
Foreign key to the first heat not served in the lifetime of the female, before the first service.
|
IID_P0FstService
|
Foreign key to first service of parity 0
|
IsActive
|
Active/Inactive status. If the animal is active, ISACTIVE will be 1, if it is removed it will be 0
|
LacDate
|
Begin date of current lactation. The lactation can begin with a calve or an abortion that is followed by a Nurse On event. If she is not lactating, the value is NULL
|
LactationStatus
|
Lactation status indicated by a numeric value: 0 None (unmated breeding female), 1 Not Lactating, 2 Lactating
|
LfAbortions
|
The total number of abortions for the lifetime of the female
|
LfAvgBirthingint
|
The average Calving interval for the lifetime of the female
|
LfAvgGestation
|
The average gestation length for the lifetime of the female
|
LfBirthingRate
|
Calving rate for the lifetime of the female
|
LfLiveborn
|
The total number of liveborn for the lifetime of the female
|
LfServices
|
The total number of services for the lifetime of the female
|
LfStillborn
|
The total number of stillborn for the lifetime of the female
|
LfSumAdjWeanWeight
|
The sum of litter weights at weaning for litters weaned in the lifetime of the female. Includes nurse litters
|
LfTotalborn
|
The total number of total born for the lifetime of the female
|
Location
|
Current location
|
LstLifeComment
|
Last comment event in the lifetime of the animal
|
LstLocationDate
|
Last location event date in the animal's record
|
MGrandDam
|
Maternal granddam of the animal, defined in Genealogy sheet of the File
|
MGrandSire
|
Maternal grandsire of the animal, defined in Genealogy sheet of the File
|
Morphscore
|
Morphologic score entered in the Current Status sheet of the File
|
Name
|
Animal name entered in the Current Status sheet of the File
|
Origin
|
Animal origin
|
OriType
|
Origin type. 0 raised, 1 purchased
|
P0FstServDate
|
First service date in the lifetime of the female. NULL if unkown, initial parity is not zero or calving without service
|
PGrandDam
|
Paternal granddam of the animal, defined in Genealogy sheet of the File
|
PGrandSire
|
Paternal grandsire of the animal, defined in Genealogy sheet of the File
|
PhotoDir1
|
Directory of photo 1
|
PhotoDir2
|
Directory of photo 2
|
RegisterId
|
Register or alternate ID of the animal
|
RemoveDate
|
The date an animal is removed from the herd.
|
RemoveReason
|
The reason an animal is removed from the herd.
|
RemoveStatusCode
|
Status of the breeding female at remove event.
|
RemoveType
|
Removal type
|
RemoveTypeId
|
Removal type: 0 Death, 1 Slaughtered, 2 Transferred, 3 Exported
|
ReproStatus
|
Reproductive status indicated by a numeric value: 0 None (unmated breeding female), 1 Open (not-pregnant, but with at least one mating event in her history record), 2 Served (served, assumed pregnant), 3 Diagnosed Pregnant (served with a positive pregnancy check event)
|
Serv1Age
|
Age of the female at first service. The birthdate must be recorded for this to be calculated.
|
ServLstDate
|
Last service date in a female's record, defined by the date of the first mating of the last service. Unlike ServDate variable, which is null when it occurrs before Arrival Date in recipient farm if the female was transferred, ServLstDate is always the last service in the record regardless of the farm where the service occurs.
|
Sire
|
Sire of the animal, defined in Genealogy sheet of the File
|
SiteName
|
Site name of location level 1
|
StatusCode
|
Current status of the breeding female. A female will have her status updated to the following by the corresponding events:E Entry, H Heat Not Served, S Served, N Pregnancy Diagnosis = Negative or Observed not pregnant, P Pregnancy Diagnosis = Positive, A Abortion, L Calving, W Weaning, R Removal
|
StatusDate
|
Date of the last event that has updated the STATUS variable
|
Text1
|
User variable Text1
|
Text2
|
User variable Text2
|
Text3
|
User variable Text3
|
Text4
|
User variable Text4
|
Text5
|
User variable Text5
|
Text6
|
User variable Text6
|
Text7
|
User variable Text7
|
Text8
|
User variable Text8
|
Text9
|
User variable Text9
|
ToBeRemoved
|
If the 'To be Removed' checkbox of the Current Status sheet of the File is checked, TOBEREMOVED will be 1, if not checked it will be 0
|