Approval Level (Asset) Data Fields

Closed

Approval Level data can be edited on the Approval Level Grid Window of the Resource Grid or the Approval 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: ams_approval_level

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 approval level.

id

Text

40

 

0

 

 

 

 

 

Task type

Type of the task the approval level applies to. 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 GPS accuracy 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

 

 

 

 

 

User defined properties fields See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.                    
Notes See Common Data Fields - Notes for further information about the Notes, Unique identifier and Mobile identifier fields.                    
Unique identifier                    
Mobile identifier                    
Hyperlinks See Common Data Fields - Hyperlinks for further information about this field.                    
Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.

Approval Level

Resources

Resource Grid

Scheduled Tasks