Work Package (Collection) Data Fields

Work Package data can be edited on either the Work Package Grid Window of the Zones Grid or the Work Package (Collection) Property Sheet.

To view and edit all property data, use the Property Sheet.

The following describes all the data which can be used to define a work package.

Common Data Fields

Fields that are common to the majority of objects can be found in the Common Fields topic.

Work Package Data

Database Table Name: cams_work_package

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

Work package ID

Unique identifier for the work package.

id

Text

40

 

0

 

 

 

 

 

Work package type

The type of the work package.

work_package_type

Text

100

 

 

 

 

 

 

 

Asset type

Type of asset associated with the work package:

Database Value

Description
cams_ancillary User ancillary
cams_channel Channel
cams_connection_node Connection node
cams_connection_pipe Connection pipe
cams_data_logger Data logger
cams_defence_structure Defence structure
cams_defence_area Defence area
cams_flume Flume
cams_general_asset General asset
cams_generator Generator
cams_manhole Node
cams_orifice Orifice
cams_outlet Outlet
cams_property Property
cams_pump Pump
cams_pump_station Pump station
cams_screen Screen
cams_siphon Siphon
cams_sluice Sluice
cams_storage Storage Area
cams_valve Valve
cams_vortex Vortex
cams_weir Weir
cams_wtw Treatment works
cams_zone Zone

The dropdown list will also contain any user defined assets that have been specified for the network.

asset_type

Text

100

 

 

 

 

 

 

 
Asset ID Identifier for the asset. asset_id

Text

40

              

Location

Address / description of the location of the work package.

location

Text

100

0

 

 

 

 

 

Area

Polygon area.

Default value is calculated from polygon geometry.

area

Double

 

 NA

3

 

 

 

 

 

X coordinate

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Total actual duration

Actual total time taken to carry out all the tasks that are part of the work package.

total_actual_duration

Double

 

  

2

 

 

 

 

 

Total estimated duration

Estimate of total time required to carry out all the tasks that are part of the work package.

total_estimated_duration

Double

    

2

          

Total actual cost

Total actual cost of carrying out all the tasks that are part of the work package.

Work package total cost (actual and estimated) calculation can be performed by selecting the work package on the GeoPlan or the Zones Grid and choosing Selection operations | Calculate work package costs from the Selection menu.

 total_actual_cost

Double

  

WN_COST

2

 

 

 

 

 

Total estimated cost

Total estimated cost of carrying out all the tasks that are part of the work package.

Work package total cost (actual and estimated) calculation can be performed by selecting the work package on the GeoPlan or the Zones Grid and choosing Selection operations | Calculate work package costs from the Selection menu.

 total_estimated_cost

Double

  

WN_COST

2

 

 

 

 

 

Tasks

Read-only

The scheduled tasks assigned to the work package are displayed in a grid when you either click on the button (if you are viewing the Work Package property sheet) or by selecting the Task tab (if the object properties are being viewed in tabbed format).

Double-clicking on a cell in the grid will display the applicable task's property sheet.

tasks

Array

      

 

 

 

 

 

Scheduled Task fields

See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet.

          

 

 

 

 

 

Attachments

Click the Ellipsis button button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

See Attachments Editor and Common Data Fields for further details.

attachments

Array

      

 

 

 

 

 

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.

Work Packages

Zones Grid