To create a new attribute definition for the selected asset type, press the button in the Attributes tab.

The Add Attribute dialog opens.

Enter or update the required attributes:

Sequence Number (Required): Enter a sequence number that will order this Attribute in relation to other Attributes for this Asset Type.

Name (Required) (List): Enter the Table Column name to hold the Attribute data. When selecting a column, it is preferable to select one of the same Data Type as the information to stored. For example, if the Asset Attribute is a Date, then a Column of Type ‘Date’ should be selected. Similarly, if the Asset Attribute is a numeric value, then a Column of data type ‘Number’ should be selected. The datatype of each Column will be displayed in the List of Values.

If an appropriate Column is not available (as it may have already been selected for another attribute of this Asset Type) a data type format can be set using the ‘Format’ field to ensure the input data conforms to the data type of the column being used to store the information.

Screen Text (Required): Enter the text that the user will see when using this Asset Attribute.

Length (Required): Enter the maximum number of digits allowed for this Asset Attribute.

If this Attribute is to use an Asset Domain, and hence have an associated List of Values, the Length entered for this Attribute must not be less than the maximum number of digits used for any Value of the Asset Domain.

If the Attribute is used to store Numeric data with decimal places, the decimal point is not considered when calculated the number of digits required. For example, if the Attribute has a precision of 2 decimal places and the maximum value for the Attribute is 100.00, then the Length required to store this information would be 5.

Decimal Places (Optional): If an Asset Attribute is used to store numeric data with decimal places, enter the maximum number of decimal places allowed this value cannot be greater than the value returned for the selected column.

Format (Required) (List): Select the Data Type to be used with the selected Column. This should match the Data Type of the Attribute Values being entered and may be different than the Default Data Type of the selected Table Column. For example, if a Column of type Varchar2 is selected, but the Values being input into this Attribute are numeric, the format can be set to ‘Numeric’ thus allowing only numeric data to be entered.

Valid Formats are set-up using the Domains form and by updating domain DATA_FORMAT.

Format Mask (Optional): A format mask may be applied to an Attribute in order for data to be displayed in a consistent format. For example, if a format mask of DD/MM/YYYY is applied to a Date Attribute, the date will always be displayed in this form e.g., 01/01/2001. The Format Mask only affects how the value is displayed, not how it is stored in the table. A Format Mask is only applied once that data has been entered and nothing is displayed in the field to suggest or control the format in which data is entered.

Valid Format Masks for Dates are set-up using the Domains form and by updating domain DATE_FORMAT. A Format mask may also be used if the Data Type selected in the ‘format’ field is NUMBER, e.g., 00.00

Domain (Dropdown - Optional): If the selected Asset Attribute uses a List of Values to validate data entry, enter the Domain name from which to select the valid values. The Domains and associated list of values must have already been defined using Asset Domains form . The list of available Domains will only display those whose Data Type matches the Data Type selected for the Attribute.

Case (Dropdown - Required): Defines the case of the selected VARCHAR2 attribute, defaults to UPPER for NUMBER and DATE format attributes.

View Attribute (Required): Enter a Name for the View Attribute. The View Attribute name is used in the naming of a Column created in several Database Views if this Attribute is used as a ‘Splitting’ agent in a Merge Query definition.

Column Name (Required): Enter a name for the Column, which will be displayed in the View of the Asset Type, for this Attribute. For example, if the Screen Text for the Attribute was ‘Survey Id’, then the Column Name in the View may be called ‘IIT_SURVEY_ID’.

Query (Optional): This field is currently only used within Street Gazetteer Manager to create a dynamic List of Values for use with Associated Street Data. Street Gazetteer Manager is shipped with standard queries that must not be changed.

Min Value (Optional): Enter the minimum value allowable for this Attribute. You may only enter a value in this field if the data Format selected is ‘NUMBER’

Max Value (Optional): Enter the Maximum Value allowable for this attribute. You may only enter a value in this field if the data Format selected is ‘NUMBER’.

Units (Dropdown - Optional): If the Format for the selected Asset Attribute is ‘Numeric’, the Unit of measurement used for Asset Attribute may be entered here. The Unit Description will be displayed in the adjacent field to the Attribute value in the Asset Items Attribute window.

These Units must have already been set up using the Units and Conversions form and if appropriate Conversion Functions have been defined for the selected Unit, ‘Dynamic Unit Conversion’ may take place in the appropriate forms.

Start Date (Required): Enter the date from which the Asset Attribute is valid.

End Date (Optional): Enter the date from which the Asset Attribute is ceases to be valid.

Display Width: When displaying at Asset Attribute within the Results Grid of the Locator Module, the column Width within in Grid may be defined using this field. If left blank (null), the Grid Column width is determined in accordance with the Attribute length. This field is only available if the ‘Displayed’ Checkbox is selected.

Mandatory (Yes/No switch): Set this switch to 'Yes' if a Value must always be present for this Attribute. A ‘*’ will be displayed beside the Attribute Name in the Asset Items form to signify the Attribute is Mandatory.

Queryable (Yes/No switch): Set this switch to 'Yes' if the Asset Attribute can be used as a selection criteria parameter to query Asset Items of this Type.

Exclusive (Yes/No switch): Set this switch to 'Yes' if Items of this Asset Type are exclusive by virtue of the value of this Attribute. This means that many Items of an Exclusive Type may exist at the same linear offset within the same XSP, but the values of the 'Exclusive Flexible Attributes' must differ for each item. For example, an Asset Type of RUFF - Roughness may be flagged as Exclusive and have an Exclusive Attribute for 'Year'. This would mean that many Roughness Surveys could be located on the same extent of Network but each must have been surveyed in a different year. Exclusivity may only be applied to Attributes of Data Types of 'Number' and ‘Varchar2’ that are validated against an Asset Domain. Exclusive Attributes must also be flagged as 'Mandatory'.

Inspectable (Yes/No switch): Set this switch to 'Yes'if the Asset Attribute is to be downloaded to the edif file for map capture or a 3rd party mobile application.

Displayed (Yes/No switch): Set this switch to 'Yes' if the Asset Attribute is to be displayed within the Results Grid of the Locator Module.

Keep History (Yes/No switch): This switch is only used in conjunction with Map Capture by Exor. If set to ‘Yes’ a history of any changes made to the value of this Attribute within Map Capture will be kept even when the Inspector chooses not to keep history within Map Capture.

To update an attribute definition, press the button next to the attribute. The Edit Attribute dialog is displayed:

Enter or update the required attributes and click Save when finished.