Female

ArrivalDate	Arrival date
BirthDate	Birthdate of the breeding female
BirthingRate	Farrowing rate for the lifetime of the female
Birthings	Number of Farrowings 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 Farrowings. It is necessary in some functions, like SUM(Liveborn) / Births
BVSP	Breeding Value Sow Productivity
Comment	Any user-defined Comment inserted in the Current Status sheet of the Females File
CurBirthLocation	Current Farrowing location. A Location event must be entered within 14 days before or after a Farrowing 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 Farrowing 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\|
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-Farrowing task, determined by number of days before the estimated Farrowing 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 Farrowing 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 farrow 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 Farrowing 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
LfBornYear	The total number of animals born per year
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
LfMummies	The total number of mummies for 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.
LfNetFosterParity	Animals fostered on with a foster event - fostered off with a foster event + nursed on with a nurse on event - nursed off with a nurse off event with the corresponding wean event.
LfPreweanedMortality	The average prewean mortality for the lifetime of the female
LfRecordedPwDeaths	The total number of preweaned deaths 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
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.
LfWeanedYear	Total number weaned per year
Location	Current location of the female
LstLocationDate	Last location event date in a female's record
LstComment	Last comment
FstBirthingDate	First farrowing 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 Farrowing, 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