Resource Data Fields (Collection)
Resource data can be edited on either the Resource Grid Window of the Resource Grid or the Resource Property Sheet.
To view and edit all resource data, use the Property Sheet.
The following describes all the data which can be used to define a resource.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Resource Data
Database Table Name: cams_resource
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID |
Unique identifier for the resource. |
id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||
|
Resource type |
Type of the resource:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
resource_type |
Text |
40 |
|
0 |
|
|
|
|
|
||||||
|
Hourly rate |
Current hourly rate for the resource (can also be used for equipment that is being hired). |
hourly_rate |
Double |
|
WN_COST |
2 |
|
|
|
|
|
||||||
|
Overtime rate |
Current resource overtime rate. |
overtime_rate |
Double |
|
WN_COST |
2 |
|
|
|
|
|
||||||
|
Double time rate |
Current resource double time rate. |
double_time_rate |
Double |
|
WN_COST |
2 |
|
|
|
|
|
||||||
|
Fixed cost |
Resource fixed cost. |
fixed_cost |
Double |
|
WN_COST |
2 |
|
|
|
|
|
||||||
| General properties fields | See Common Data Fields for details of field in the General properties section of the property sheet. | ||||||||||||||||
| User defined properties fields | See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet. |
Network Data Fields Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.
