ArrivalDate
|
Arrival date
|
BirthDate
|
Birthdate of the breeding female
|
BirthingRate
|
Lambing rate for the lifetime of the female
|
Birthings
|
Number of Lambings 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 + BirthsBirths only refers to recorded Lambings. It is necessary in some functions, like SUM(Liveborn) / Births
|
Comment
|
Any user-defined Comment inserted in the Current Status sheet of the Females File
|
CurBirthLocation
|
Current Lambing location. A Location event must be entered within 14 days before or after a Lambing event.
|
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
|
CurPreweaneds
|
Current number of preweaned animals if the status of the female is lactating
|
Dam
|
Dam of the female, defined in Genealogy sheet of the Females File
|
DueBirthDate
|
Estimated Lambing 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-Lambing task, determined by number of days before the estimated Lambing 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
|
DueWeanDate
|
Date for a lactating female to be weaned, determined by the number of days after Lambing as defined by user in Options|Time Intervals
|
EntryAge
|
Age at entry
|
EntryDate
|
The date on which a breeding female enters the breeding herd
|
Genetics
|
Genetics, or Breed, of the breeding female
|
HeatLstDate
|
The date of the last Heat Not Served event recorded for a female
|
Id
|
Female identification
|
IID_CurParity
|
Foreign key to current parity
|
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_LstTreatment
|
Foreign key to last treatment
|
IsActive
|
Active/Inactive status. If the female is active, ISACTIVE will be 1, if she is removed it will be 0
|
LacDate
|
Start date of current lactation. The lactation can start with birth or after an abortion. If she is not lactating, the value is NULL
|
LactationStatus
|
Lactation status indicated by a numeric value: 0 None (nullipara breeding female), 1 Not Lactating, 2 Lactating
|
LfAbortions
|
The total number of abortions for the lifetime of the female
|
LfAvgBirthingint
|
The average Lambing interval for the lifetime of the female
|
LfAvgGestation
|
The average gestation length for the lifetime of the female
|
LfAvgLiveborn
|
The average number of liveborn per parity for the lifetime of the female
|
LfAvgStillborn
|
The average number of stillborn per parity for the lifetime of the female
|
LfAvgTotalborn
|
The average number of total born per parity for the lifetime of the female
|
LfAvgTotalWeaned
|
The average number of weaned per parity from Wean and Part-Wean Events for the lifetime of the female, includes number weaned from nurse litters.
|
LfAvgWean1Age
|
Average age of weaned animals of birth litters for the lifetime of the female
|
LfAvgWeanedWeight
|
The average weight of weaned animals for the lifetime of the female
|
LfCountAdjWeanWeight
|
Number of animals weighed at weaning with adjustment
|
LfLittersWeaned
|
The total number of litters weaned for the lifetime of the female
|
LfLiveborn
|
The total number of liveborn for the lifetime of the female
|
LfLivebornLitWeaned
|
The number of Liveborn for litters weaned or nursed off during the lifetime of the female
|
LfNetadded
|
The sum of animals fostered on minus fostered off for the lifetime of the female,as recorded with the Foster event
|
LfNetFostered
|
The total number of net fosters for the lifetime of the female, includes both fosters and nurses.
|
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
|
LfTotalWeaned
|
The total number of animals weaned for the lifetime of the female
|
LfWean1Num
|
Total number weaned from a female's birth litter for the life of the female.
|
Location
|
Current location of the female
|
LstLocationDate
|
Last location event date in a female's record
|
LstComment
|
Last comment
|
FstBirthingDate
|
First lambing date
|
MGrandDam
|
Maternal granddam of the female, defined in Genealogy sheet of the Females File
|
MGrandSire
|
Maternal grandsire of the female, defined in Genealogy sheet of the Females File
|
Morphscore
|
Morphologic score entered in the Current Status sheet of the Females File
|
Name
|
Female name entered in the Current Status sheet of the Females File
|
OriType
|
Origin, 0 means raised, 1 means purchased
|
PGrandDam
|
Paternal granddam of the female, defined in Genealogy sheet of the Females File
|
PGrandSire
|
Paternal grandsire of the female, defined in Genealogy sheet of the Females File
|
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.
|
RemoveType
|
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 in her record), 2 Served (served, assumed pregnant), 3 Diagnosed Pregnant (served with a positive pregnancy check)
|
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 in the service
|
Sire
|
Sire of the female, defined in Genealogy sheet of the Females File
|
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 Lambing, W Weaning, R Removal
|
StatusDate
|
Date of the last event that has updated the STATUS variable
|
ToBeRemoved
|
"If the ""To be Removed"" checkbox of the Current Status sheet of the Females File is checked, TOBEREMOVED will be 1, if not checked it will be 0"
|
UserFieldA1
|
User field number 1, defined in Current Status sheet of the Females File
|
UserFieldA2
|
User field number 2, defined in Current Status sheet of the Females File
|
UserFieldL1
|
User list field number 1, defined in Current Status sheet of the Females File
|
UserFieldL2
|
User list field number 2, defined in Current Status sheet of the Females File
|