ArrivalDate
|
Arrival date
|
BirthDate
|
Birthdate of the animal
|
Birthings
|
Number of Kindlings 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 Kindlings. 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 kindling location. A Location event that is entered within 14 days before or after a kindling 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
|
CurPreweaneds
|
Current number of preweaned animals of females with lactating status
|
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 Kindling 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-Kindling task, determined by number of days before the estimated Kindling 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 Kindling as defined by user in Options|Time Intervals
|
EID
|
Electronic Identification
|
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 kindling 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 birth 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 Kindling 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
|
LfBirthingRate
|
Kindling rate for the lifetime of the female
|
LfBornYear
|
The total number of animals born per year
|
LfCountAdjWeanWeight
|
Number of animals with adjusted weights
|
LfGestationDays
|
Sum of gestation days for the lifetime of the female. If she is served, it adds the days from service
|
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 foster and nurse events.
|
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 preweaning 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
|
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 kindling 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 Kindling, 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
|