The MainTrac Asset Category Listing report allows you to print a list of all (or some) Asset Category Codes in your MainTrac module. By default the report lists the Asset Type, Asset Category Code, Description, and Count for the Asset Category Codes you opt to print.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
From the bottom of the screen…
Core Criteria
Asset Category Codes (MTAssetCategory_AssetCategoryCode_DataGrid)
The Asset Category DataGrid displays all Asset Category Codes in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Asset Category Codes, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Asset Category Range option.
THEN
Input the range of Asset Category Codes you wish to include.
Make selections in the DataGrid or use an Asset Category Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO ASSET CATEGORY CODES being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Asset Category Code Range (MTAssetCategory_AssetCategoryCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Asset Category Codes.
THEN
Enter the range of Asset Category Codes.
OR
Leave this option de-selected to skip the Asset Category Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Asset Type (MTAssetCategory_Type_ComboBox)
Click the Combo Box icon to select individual Asset Category Types, if desired. Multiple selection is allowed. This field works in conjunction with the Asset Category Range and filters the output to those Asset Category Types selected. For Example: Your Asset Category Code Range is <blank> to ZZZZZZZZ." You select "Equipment" and "Facility" in this field. All other fields are at their default settings. When you Process the report the output will list all of your Equipment and Facility Asset Category Codes.
Leave this field at its default "(0)" Selected to skip it the Asset Category Type check.
DeleteBegin Asset Category Code (MTAssetCategory_AssetCategoryCode_Begin)
This field is applicable only if you opt to Use Asset Category Range.
Click the Picklist icon to select the Beginning and Ending Asset Category Codes for their respective fields. Asset Category Codes within the range entered will be included in the process.
DeleteEnd Asset Category Code (MTAssetCategory_AssetCategoryCode_End)
This field is applicable only if you opt to Use Asset Category Range.
Click the Picklist icon to select the Beginning and Ending Asset Category Codes for their respective fields. Asset Category Codes within the range entered will be included in the process.
DeleteAsset Category Code WildCard (MTAssetCategory_AssetCategoryCode_Equals)
If opting to Use Asset Category Range, then click the Picklist icon to select a single Asset Category Code, if desired, to use as a base for a Wildcard selection.
OR
Enter a Wildcard value, if desired
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (MTAssetCategory_AssetCategoryCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr ' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by ' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Use Asset Count Range (MTAssetCategory_AssetCount_UseRange)
Select this option to limit your selection to a range of Asset Category Codes by Count (i.e. by the number of records you have for a particular Asset Category)..
THEN
Enter the Count range.
Begin Asset Count (MTAssetCategory_AssetCount_Begin)
This field is applicable only if you opt to Use Asset Count Range.
Enter the numerical range by which you wish to filter the report. Only those Assets with a number of records within the range you enter will be listed. For Example: Your range is "5-10." You have three (3) Pickup Trucks Eight (8) Mowers and 12 Weed Whackers. The Mowers only will be listed because eight (8) falls within your range of "5-10."
DeleteEnd Asset Count (MTAssetCategory_AssetCount_End)
This field is applicable only if you opt to Use Asset Count Range.
Enter the numerical range by which you wish to filter the report. Only those Assets with a number of records within the range you enter will be listed. For Example: Your range is "5-10." You have three (3) Pickup Trucks Eight (8) Mowers and 12 Weed Whackers. The Mowers only will be listed because eight (8) falls within your range of "5-10."
DeleteFEMA Cost Code WildCard (MTAssetCategory_FEMACostCode_Equals)
Enter all or part of a Federal Emergency Management Agency (FEMA) Cost Code ID in this field, if desired, to use as a Wildcard value.
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
Note: This field is applicable for Equipment Asset Types only. If using a FEMA Wildcard then the output will list only those Equipment Asset Category Codes that meet your Wildcard conditions. The report will not list any other Asset Types regardless of your other filters.
WildCard Option (MTAssetCategory_FEMACostCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr ' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by ' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.