Work Package (Asset) Data Fields

Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Please contact us for information about adding this option to your existing licence.

Work Package data can be edited on either the Work Package Grid Window of the Zones Grid or the Work Package (Asset) 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.

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

Work Package Data

Database Table Name: ams_work_package

Field Name	Help Text	Database Field	Data Type	Size	Units	Precision
ID	Unique identifier for the work package.	id	Text	40		0
Work package type	The type of the work package. The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.	work_package_type	Text	100
Asset type	Type of asset associated with the work package: 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 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 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 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
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
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 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 on-premise database can be found in the Network Data Fields section.

Work Package (Asset) Data Fields

Work Package Data

Related Information

Was this information helpful?