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.
- quantities and costs of materials required to carry out the related maintenance work, with breakdown by estimated and actual figures for each material.
The editor can be used to perform resource management calculations.
Resource Details
Database Table Name: cams_resource_details for collection networks, wams_resource_details for distribution networks and ams_resource_details for asset networks
|
Show Columns |
Database Names |
|
Size, Type and Units |
|
|
Defaults and Error Limits |
|
Position in Data Structure |
Field Name |
Help Text |
Database Field |
Size |
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.
|
Show Columns |
Database Names |
|
Size, Type and Units |
|
|
Defaults and Error Limits |
|
Position in Data Structure |
Field Name |
Help Text |
Database Field |
Size |
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.
