When users open a Work Order, often the first thing they want to determine is which item they'll be working on. Lucity's Work Order Asset Setup module allows agencies to control what information is copied to a Work Order Asset record from an Inventory record when the asset is added to a Work Order or PM/Template. Administrators can create different Setup records for each type of asset.
Configuring the Asset Description
There are two types of Work Asset fields that can be configured
Desc 1/Desc 2 - Provides a quick overview of the asset by pulling together important identification or classification information from one or more of the asset's fields. The information in this field for the first record in a work order's Asset grid can also appear directly on the work order.
Custom Fields - Provides information about the asset by pulling over a value from a single asset field.
Related Asset Information
If they choose, administrators can also add information from Lucity modules related to the asset to the Work Order Asset Setup record. For instance, when a Sewer Pipe asset is added to a Work Order, users may want to see which Pump Station is located along that line. Using a SQL statement, an administrator can configure the Work Order Asset Setup record to display both the Pipe ID and Pump Station ID on the Work Order.
Common Tasks
To open the Work Order Asset Setup module, select Work > Administration > Work Order Asset Setup.
In the Work > Administration > Work Order Asset Setup module, select the record to which you want to add a field.
Click in the module toolbar. The Work Asset Setup form appears, displaying any fields that have already been configured for the selected type of Work Asset.
Click the Create New Populated Asset Value button. A blank box appears at the top of the grid:
Click in the box. A pop-up appears that lists all Work Order Asset fields that can be configured.
Select the Work Order field that you would like to serve as the destination for the asset data. A new box appears to the right of the first box.
Click in the box. A pop-up appears that lists all Asset fields with the same Field Type as the Work Order field selected in Step 5.
Select the Asset field that you would like to copy to the Work Order Asset record.
Repeat Steps 3-7 until you have included all of the asset attributes you desire.
Click OK. Expand the Work Order Setup record and locate the destination field in the WO Asset Field1 column. You'll find the asset field you assigned to that field in the Inv Field 1 column of that record row.
The Desc 1 and Desc 2 fields are special fields on an Asset record that can display multiple pieces of information. They appear on the Work Request, Work Order Asset, and PM/Template Asset records.
To configure these fields:
Open the Work > Administration > Work Order Asset Setup module.
Select a record to modify.
Click in the module toolbar. A pop-up appears listing the asset fields that have already been configured.
Collect information from the Asset Inventory module about the field(s) you want to include in the Work Order Asset description fields.
Use the Field Properties tool on the target Asset Inventory module's form to identify the desired field names.
Edit the AS_TEXT1 or AS_TEXT2 boxes with the gathered information. You can overwrite the current values, including the Hardcoded value, if needed.
To include a single field, type the field name into a box . Example:MA_STRUCTURE.
OR
To include multiple fields, type each field name into a box using the following syntax requirements:
Enter the field names in the order in which they should appear, left to right.
Separate the fields with commas.
Do not include spaces.
Integer fields (numbers without decimals) - Place square brackets [ ] around the field name.
Double fields (numbers with decimals) - Place parenthesis ( ) around the field name.
Date fields - Place backslashes \ \ around the field name.
Agency administrators can also add data from a record related to the asset to any field in the Asset Setup record. To do so requires a SQL statement.
Open the Work > Administration > Work Order Asset Setup module.
Select the Work Order Asset Setup record you want to edit.
Click in module toolbar. A pop-up appears listing the fields that have already been configured.
Locate the field that you want to update or click Create New Populated Asset to add it.
Collect information from the Asset Inventory module about the field(s) you want to include in the Work Order Asset fields.
Use the Field Properties tool on the target Asset Inventory module's form to identify the desired field names.
Click in the box to the right of the Work Order field and write a SQL statement that selects the field from another table, following these rules:
The SQL statement must be enclosed in parenthesis ( ).
The SQL statement should select one field from the related table.
The result of the SQL statement must be compatible with the field that will display the data.
Click OK to save the record.
Samples
The following are examples of SQL Statements used on a Work Order Asset Setup record for a Sewer Pipe to collect information from a related Sewer Pump Station:
DESC 1 (Text)
(SELECT SN_LOCATIO FROM SWSTATN WHERE SN_STN_ID=SWNET.NT_SN_ID)
DESC 2 (Text)
(SELECT SN_STN_NAM FROM SWSTATN WHERE SN_STN_ID=SWNET.NT_SN_ID)
AS_USR11 (Double)
(SELECT SN_SHEAD FROM SWSTATN WHERE SN_STN_ID=SWNET. NT_SN_ID)
AS_USR1CD (Code)
(SELECT SN_CFRQ_CD FROM SWSTATN WHERE SN_STN_ID=SWNET.NT_SN_ID)
AS_USR1TY (Type)
(SELECT SN_CFRQ_TY FROM SWSTATN WHERE SN_STN_ID=SWNET.NT_SN_ID)
AS_USR21 (Date)
(SELECT SN_NCLN_DT FROM SWSTATN WHERE SN_STN_ID=SWNET.NT_SN_ID)
AS_USR24 (Boolean)
(CASE WHEN EXISTS (SELECT SN_SGEN FROM SWSTATN WHERE SN_STN_ID=SWNET.NT_SN_ID) THEN (SELECT SN_SGEN FROM SWSTATN WHERE SN_STN_ID=SWNET.NT_SN_ID) ELSE 0 END)
How to create a Work Order Asset Setup record
button.
button to save the record.
in the module toolbar. The Work Asset Setup form appears, displaying any fields that have already been configured for the selected type of Work Asset. 
