Database Power Tools

From SwineBooks Pro

Jump to: navigation, search

Contents

Report Types

Report Type Intended Use Example
List Lists of animal IDs with events and event dates _ID_, _CurrentParity_, _LastEventName_, _LastEventDate_, _DaysSinceLastEvent_
Breakdown Effect of predictor variable on outcome variable. _TotalBorn_ (Z) by _PrevLactLength_
3D Breakdown Effect of predictor (X) variable on outcome (Z) variable with discriminating (Y) variable _TotalBorn_ (Z) by _PrevLactLength_ by _Parity_ (Y)
Cross Tab Relationship between two variables presented as a table. _PigletDeathDays_ (X) by _PigletDeathReason_ (Y)
Frequency Dist Frequency, showing variation in the values of a single variable _GestLength_
Graph
Statistics Descriptive statistics: Count; Sum; Average; Standard Deviation; Variance; Minimum; and Maximum for single or multiple variables. _WeanToConceptInt_
Scatter Plot Relationship between two variables presented as a graph of data points. _PigletDeathDays_ (X) by _PigletDeathReason_ (Y)

System Variables

Variable Type Formula or Definition
_EventDate_ Date The date associated with a recorded event in an animal history
_EventName_ Alphanumeric The name of an event associated with a recorded event in an animal history
_Today_ Date Today's date as read from the computer's clock setting. Note: 'Today' cannot be selected from the pick list. However, it is useful in the Filter Statement in constructs such as 'FarrowDate > (Today - 30)' which ensures that saved reports always display current data.

Current Parity Variables

Variable Type Formula or Definition
_AbortDate_ Date The date associated with an Abortion event recorded event in an animal history
. Date
_WeanUnaccountedPigs_ Date

Previous Parity Variables

Variable Variable Formula or Definition
_Prev1stTo2ndServiceInt_ Integer The interval (days) between the first and second service in an animal's previous parity record.
Integer ..
_PrevWeanTo1stServiceInt_ Integer

Biographical Variables

Variable Type Formula or Definition
_AbortionToRemovalInt_ Integer The interval (days) between the dates of an abortion and its remove event animal's record.
_AltID_ Alphanumeric The secondary, permanent identification mark of a breeding female or boar.
_Birthdate_ Date The date of birth of a breeding female or boar.
_EntryToRemoveInt_ Integer
_CurrentStatus_ Alphanumeric The reproductive status of a breeding female determined by the most recent events in it's Animal History. Current status classes are: Admitted; Open; Gestating; Lactating; Weaned; Removed; and Shipped
_CurrentStatusDays_ Integer The number of days that have elapsed since the date of the event which last altered the reproductive status of a breeding female.
_FirstServiceToRemoveInt_ Integer
_ID_ Alphanumeric The primary, permanent identification mark of a breeding female or boar.
_Litter1BornAlive_ Integer Number of live born pigs produced at a sow's first farrow event.
_Litter1Mummies_ Integer Number of mummies recorded at a sow's first farrow event.
_Litter1Stillborn_ Integer Number of stillborn pigs recorded at a sow's first farrow event.
_Litter1TotalBorn_ Integer Total number of pigs (born alive + stillborn + mummies + retained pigs) recorded at a sow's first farrow event.
_Litter1WeanAllPigs_ Integer Total number of pigs weaned (part- and full-wean) from a sow's first litter .
_Litter2BornAlive_ Integer Number of live born pigs produced at a sow's second farrow event.
_Litter2Mummies_ Integer Number of mummies recorded at a sow's second farrow event.
_Litter2Stillborn_ Integer Number of stillborn pigs recorded at a sow's second farrow event.
_Litter2TotalBorn_ Integer Total number of pigs (born alive + stillborn + mummies + retained pigs) recorded at a sow's second farrow event.
_Litter2WeanAllPigs_ Integer Total number of pigs weaned (part- and full-wean) from a sow's second litter .
_Litter3BornAlive_ Integer Number of live born pigs produced at a sow's third farrow event.
_Litter3Mummies_ Integer Number of mummies recorded at a sow's third farrow event.
_Litter3Stillborn_ Integer Number of stillborn pigs recorded at a sow's third farrow event.
_Litter3TotalBorn_ Integer Total number of pigs (born alive + stillborn + mummies + retained pigs) recorded at a sow's third farrow event.
_Litter3WeanAllPigs_ Integer Total number of pigs weaned (part- and full-wean) from a sow's third litter .
_Litter4BornAlive_ Integer Number of live born pigs produced at a sow's fourth farrow event.
_Litter4Mummies_ Integer Number of mummies recorded at a sow's fourth farrow event.
_Litter4Stillborn_ Integer Number of stillborn pigs recorded at a sow's fourth farrow event.
_Litter4TotalBorn_ Integer Total number of pigs (born alive + stillborn + mummies + retained pigs) recorded at a sow's fourth farrow event.
_Litter4WeanAllPigs_ Integer Total number of pigs weaned (part- and full-wean) from a sow's fourth litter .
_Litter5BornAlive_ Integer Number of live born pigs produced at a sow's fifth farrow event.
_Litter5Mummies_ Integer Number of mummies recorded at a sow's fifth farrow event.
_Litter5Stillborn_ Integer Number of stillborn pigs recorded at a sow's fifth farrow event.
_Litter5TotalBorn_ Integer Total number of pigs (born alive + stillborn + mummies + retained pigs) recorded at a sow's fifth farrow event.
_Litter5WeanAllPigs_ Integer Total number of pigs weaned (part- and full-wean) from a sow's fifth litter .
_Litter6BornAlive_ Integer Number of live born pigs produced at a sow's sixth farrow event.
_Litter6Mummies_ Integer Number of mummies recorded at a sow's sixth farrow event.
_Litter6Stillborn_ Integer Number of stillborn pigs recorded at a sow's sixth farrow event.
_Litter6TotalBorn_ Integer Total number of pigs (born alive + stillborn + mummies + retained pigs) recorded at a sow's sixth farrow event.
_Litter6WeanAllPigs_ Integer Total number of pigs weaned (part- and full-wean) from a sow's sixth litter .
_RemoveDate_ Date
_RemoveDay_ Integer
_RemoveMonth_ Integer
_RemoveParity_ Integer
_RemoveReason_
_RemoveType_
_ServeToRemoveInt_ Integer
_ShipDate_ Date
_VBoarCount_ Integer
_WeanToRemoveInt_ Integer

Lifetime Variables

Variable Type Formula or Definition
_LifeAvgBornAlive_ Numeric
Numeric
_LifeTotWeanAllPigs_ Numeric
Personal tools