...
- Configured house and flock equipment types.
- Configured house and flock equipment.
- Permissions to view and or edit houses and or flock equipment.
- The equipment detail data set added to the "ReportTypeInclude" table.
...
Setting Up The Software
...
|
Adding Equipment Types and Equipment
System Types
System → Settings → System Types
From system settings, we will define our equipment types. These types cannot belong to both house and flock- it must be assigned to either one.
...
Equipment
System → Settings → Equipment
To define our equipment, we will open the Equipment form and set information about the manufacturer, model, etc.
Some equipment, like battery cages, will have additional,
...
information that can be filled out on additional tabs.
...
Assign Equipment to Flock
Live Inventory → Selected Flock → Equipment Tab
Flock equipment is assigned directly on the flock form.
...
Choosing a type will filter the specific definitions for that type.
...
Assign Equipment to House
Facility Management → Selected House → Equipment Tab
House Equipment is assigned directly on the house facility form.
...
Choosing an equipment type here will also filter the specific definitions for that type.
...
The Report Wizard
The equipment detail wizard is like many of the other's with a few exceptions. The most notable being that when we first run it, it prompts us to enter the type of equipment we will report: house, flock, or both.
The number of wizard steps will be determined by our selection. Should we choose both, we will be prompted to chose from lists of both houses and flocks. The number of steps on the top of the wizard will be determined by our selection.
...
If we select option one, we will only see four steps; the last of which is selecting the houses.
If we select option two or three, then we will be provided additional steps to filter and select flocks (industry type, flock status, attributes). As per other wizards, the list of flocks will also be filtered by the facilities we selected.
...
Regardless of what run type we chose, we will always be prompted to filter by equipment type. This list will include the types from both flocks and houses.
If we do not select any values from the list, the report will return records for all equipment types. If we select specific values it will filter by those specific selections.
...
Special Considerations for Sub Reports: House Equipment
We can run this report standalone and return records for only houses, whether flocks are placed in them, or not. However, other
...
reports do not include house selections that we can pass to override sub report parameters (when "is independent report" is set to false). When running this report as a sub report, and the wizard is set to run for "house and flocks" equipment, the flock's estimated and actual placement houses will be used to populate the house list.
The Report Data Set and Calculations |
| The data set has one table in it- EquipmentDetail. This table has all the records for both house and flock equipment records. Fields are as follows: |
| Company_Code - The company code that the |
| house or flock belongs to. |
| Company_Name - The company description that the |
| house or flock belongs to. |
| Division_Code - The division code that the |
| house or flock belongs to. |
| Division_Name - The division name that the |
| house or flock belongs to. |
| Equip_Allocation_Code - When equipment is assigned to a house or flock, users can give it a code. |
| Equip_Allocation_Count - The number of this type assigned to the flock or house. |
| Equip_Cage_Area - If this equipment is a cage, this will display the cage area. |
| Equip_Cage_Capacity_Max - If this equipment is a cage, this displays |
| maximum capacity. |
| Equip_Cage_Capacity_Min - If this equipment is a cage, this displays minimum capacity. |
| Equip_Cage_Depth - If this equipment is a cage, this displays the depth. |
| Equip_Cage_Height_Back - If this equipment is a cage, this displays the |
| rear height. |
| Equip_Cage_Height_Front - If this equipment is a cage, this displays the |
| from height. |
| Equip_Cage_UOM - If this equipment is a cage, This is the units used to measure the cage. |
| Equip_Cage_UOM_Code - If this equipment is a cage, This is the abbreviation of the units used to measure. |
| Equip_Cage_Width - If this equipment is a cage, this is the width of the cage. |
| Equip_Capacity - The count or quantity for this equipment. |
| Equip_Capacity_UOM - The count or quantity unit of measure. |
| Equip_Capacity_UOM_Code - The count or quantity unit of measure abbreviation. |
| Equip_Code - The equipment code |
| entered on the equipment setup. |
| Equip_Comment - The comment supplied by the users on the allocation screen. |
| Equip_Date_Allocation_End - The date this specific instance of equipment was used/removed/uninstalled. This value can be null! |
| Equip_Date_Allocation_Start - The date this specific instance of equipment was placed/installed/became available. This value can be null! |
| Equip_Date_Available - The date specified in equipment setup, for when this |
| equipment can be utilized. |
| Equip_Description - The equipment description entered on the equipment setup. |
| Equip_Designation - Describes what type of equipment this is: house or flock. |
| Equip_IsDeleted - Boolean true if the equipment master record has been deleted (but the allocation has not). |
| Equip_Manufacturer - The manufacturer entered on the equipment setup. |
| Equip_Model - The model |
| entered on the equipment setup. |
| Equip_Status - Active or inactive. |
| Equip_Status_Code - Active or Inactive. |
| Equip_Type_Code - The equipment type code, from system types. |
| Equip_Type_Description - The equipment type description, from system types. |
| Farm_Code - The farm code that the house or flock belongs to. |
| Farm_Name - The farm name that the house or flock belongs to. |
| General_GroupID - If the equipment is assigned to a flock, |
| General_HouseID - If the equipment is assigned to a house. This is the house id from the database. This can be used for joins to sub reports. |
| General_PeriodEndDate - This will always be the end date of the report, specified by the user from the report view. |
| General_PeriodStartDate - This will always be the start date of the report, specified by the user from the report view. |
| General_ReportEndDate - This will always be the end date of the report, specified by the user from the report view. |
| General_ReportStartDate - This will always be the start date of the report, specified by the user from the report view. |
| General_TransactionDate - This will always be the end date of the report, specified by the user from the report view. |