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

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Field Name

Help Text

Database Field

Data Type

Size

Units

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:

Database Value

Description

TYPE1

Resource Type 1

TYPE2

Resource Type 2

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.

Resources

Resource Data Fields (Distribution)

Resource Data Fields (Asset)

Resource Grid

Resource Management Calculations