Approval Level (Collection) Data Fields

Approval Level data can be edited on the Approval Level Grid Window of the Resource Grid or the Approved Level Property Sheet.

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

The following describes all the data which can be used to define an approved level.

Common Data Fields

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

Approval Level Data

Database Table Name: cams_approval_level

Field Name	Help Text	Database Field	Data Type	Size	Units	Precision	Error Lower Limit	Error Upper Limit	Warning Lower Limit	Warning Upper Limit
ID	Unique identifier for the approval level.	id	Text	40		0
Task type	Type of the task the approval level applies to. The Task type list is read-only and contains all the surveys and repairs available for your network type. To make the approval level generic, leave its task type blank. The Task type may be selected from a choice list or input by the user.	task_type	Text	40		0
Description	Description of the approval level.	description	Text	100		0
Cost threshold	Cost level at which the approval level is enforced.	cost_threshold	Double		WN_COST	2
Number of approvals	Number of approvals required for this approval level.	number_of_approvals	Integer			0	0	0	0	0
Approving officer 1 to 10	Names of the approving officers available for this approval level. The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.	approving_officer_1 to approving_officer_10	Text	50		0
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.