Resource Details

The Resource Details editor is used to define :

• resources with breakdown by hours worked (normal, overtime and double time) showing an estimated and actual cost for carrying out maintenance work (repairs, incidents or surveys) on a selected asset.

The editor can be used to perform resource management calculations.

• quantities and costs of materials required to carry out the related maintenance work, with breakdown by estimated and actual figures for each material.

Resource Details

Database Table Name: cams_resource_details for collection networks, wams_resource_details for distribution networks and ams_resource_details for asset networks

Position in Data Structure	Field Name	Help Text	Database Field	Data Type	Size	Units	Precision	Default	Error Lower Limit	Error Upper Limit	Warning Lower Limit	Warning Upper Limit
1	Resource ID	Unique identifier for the resource. Any resources already defined are included in the dropdown list.	resource_id	Text	40		0		0
2	Estimated hours	Estimated time in terms of normal hours required to carry out the task.	estimated_hours	Double			2		0
3	Estimated overtime hours	Estimated time in terms of overtime hours required to carry out the task.	estimated_overtime_hours	Double			2		0
4	Estimated Double Time Hours	Estimated time in terms of double time hours required to carry out the task.	estimated_double_time_hours	Double			2		0
5	Estimated Cost	The estimated cost of carrying out the task.	estimated_cost	Double		WN_COST	2		0
6	Actual Hours	Actual time in terms of normal hours taken to carry out the task.	actual_hours	Double			2		0
7	Actual Overtime Hours	Actual time in terms of overtime hours taken to carry out the task.	actual_overtime_hours	Double			2		0
8	Actual double time hours	Actual time in terms of double time hours taken to carry out the task.	actual_double_time_hours	Double			2		0
9	Actual cost	The actual cost of carrying out the task.	actual_cost	Double		WN_COST	2		0
10	Actual date	Actual date on which the resource was used.	actual_date	Date/Time			3

Material Details

Database Table Name: cams_material_details for collection networks, wams_material_details for distribution networks and ams_material_details for asset networks.

Position in Data Structure	Field Name	Help Text	Database Field	Data Type	Size	Units	Precision	Default	Error Lower Limit	Error Upper Limit	Warning Lower Limit	Warning Upper Limit
1	Material ID	Unique identifier for the material. Any materials already defined are included in the dropdown list.	material_id	Text	40		0		0
2	Estimated number	Estimated number of items of this material required to perform the task.	estimated_number	Integer			0		0
3	Estimated cost	Estimated cost of the material required to carry out the task.	estimated_cost	Double		WN_COST	2		0
4	Actual number	Number of items of the material actually used to perform the task.	actual_number	Integer			0		0
5	Actual cost	Actual cost of the material used to carry out the task.	actual_cost	Double		WN_COST	2		0
6	Actual date	Actual date on which the material was used.	actual_date	Date/Time			3

The Totals section is a container for calculated costs and durations. Refer to the data fields topic corresponding to your survey or repair or incident for details on the fields available in this section or the Resource Management Calculations topic for more details on how to perform the calculations.