Attribute Assistant methods

The Value Method field in the DynamicValue table defines the actions to occur when the Attribute Assistant is enabled and features are modified or created in ArcMap. Four fields in the DynamicValue table (Value Method, Table Name, Field Name, and Value Info) must be configured to use an Attribute Assistant method. The remaining fields define when the Attribute Assistant method should be applied.

The following Attribute Assistant methods can be configured in your DynamicValue table:

Method	Description
Angle	Calculates the geographic or arithmetic angle of a line feature.
Autonumber	Finds the largest value in a field and calculates the next sequential value.
Cascade Attributes	Updates all occurrences of a value in the input table, feature layer, or feature class when one occurrence is changed.
Copy Features	Copies a feature when an attribute is updated to a specified value.
Copy Field Value	Copies the values from one field to another within a feature class.
Copy Linked Records	Updates an attribute of a feature with a value from a related table.
Create Linked Records	Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship.
Create Perpendicular Line	Constructs a perpendicular line from an input point to the nearest line feature.
Current Username	Populates the current user name.
Edge Statistics	Provides statistics on a specified field for all connected edges in a geometric network.
Expression	Executes a VBScript. Fields can be used as part of the expression by encasing the field name with []. The MSScriptControl is used to evaluate the expression. This control has been extended to process IIF statements. Both the True and False parts of the expression must be able to be evaluated. This means you cannot use functions on Null values. Example iif(1=1,left(Null), "false")
Feature Statistics	Summarizes the attribute values of the affected feature as a series of statistics, or a single calculated value.
Field Trigger	Updates a field to a specified value when the value of another field is updated.
From Edge Field	Transfers a field value from a connected edge feature to a junction feature.
From Edge Multiple Field Intersection	Stores values for all From edges connected to a junction in a series of fields in the source layer.
From Edge Statistics	Provides statistics on a specified field for all features connected to From edges in a geometric network.
From Junction Field	Stores a field value from a junction feature or the name of the feature at the start of the currently edited line.
Generate ID	Increments a row in an unversioned table and stores that newly incremented value.
Generate ID From A Grid	Generates unique identifiers for features based on the identifiers of intersecting grid features.
Get Address From Centerline	Extracts address information from the closest point on a road. It is similar to a reverse geocode, but a locator service is not used.
Get Address Using ArcGIS Service	Performs a reverse geocode using a specified ArcGIS service.
Get Address Using Geocoder	Performs a reverse geocode using a geocoder.
GUID	Creates a globally unique identifier (GUID).
Intersect Count	Calculate the number of intersecting features and stores the count in the specified field.
Intersecting Edges	Copies a field value from the first intersecting edge feature.
Intersecting Feature	Copies a value from an intersecting feature in the specified layer.
Intersecting Feature Distance	Calculates the distance along a line feature where a line is intersected by another feature.
Intersecting Layer Details	Extracts the name or file path of an intersecting feature.
Intersecting Raster	Extracts a raster cell value at a feature location. If the feature is a line or polygon, the raster value at the feature centroid is used.
Intersecting Statistics	Calculates statistics on a specified field for intersecting features.
Junction Rotation	Stores the rotation angle of a junction feature based on connected edge features.
Last Value	Repeats the last value used in a field.
Latitude	Stores the y-coordinate value projected to WGS84 decimal degrees.
Length	Calculates the length of line features.
Link Table Asset	Updates a field in the table or layer with a value from a selected feature.
Longitude	Stores the x-coordinate value projected to WGS84 decimal degrees.
Minimum Length	Rejects a newly created line feature if the length of the line is less than the specified distance.
Multiple Field Intersecting Values	Copies values from new intersecting features into a target layer.
Nearest Feature	Copies a value from the nearest feature in a specified layer.
Nearest Feature Attributes	Copies a series of values from the nearest feature in a specified layer.
Offset	Creates a point feature a specified distance from the nearest line feature.
Previous Value	Monitors a field, and when it is changed, stores the previous value into another field.
Prompt	Identifies records containing null values. If the field uses a subtype or domain, those options are presented in the dialog box for the user to select.
Set Measures	Populates the m-coordinates of line features. M-values can be used to add route events to point and line events dynamically along line features.
Side	Determines if a point feature is to the left or right of a corresponding line feature.
Split Intersecting Feature	Splits features that intersect with features in a source layer.
Timestamp	Populates the current date and time.
To Edge Field	Copies a field value from a connected To edge feature to a junction feature.
To Edge Multiple Field Intersect	Copies values for all to edges connected to a junction to a series of fields in the source layer.
To Edge Statistics	Calculates statistics on a specified field for all features connected to To edges in a geometric network.
To Junction Field	Copies a value from a junction feature or the name of the feature at the end of the currently edited line.
Update Intersecting Feature	Updates a field in an intersecting feature with a value or a field value from the modified or created feature.
Update Linked Record	Finds the related records in another table or layer and updates a field in those records.
Validate Attribute Lookup	Verifies field values against entries in a lookup table. Wild card values can be used to search for valid entries, and multiple possibilities will be presented for selection. The lookup table can be used to validate attributes in multiple fields.
Validate Attributes	Compares values in the input fields to all feature templates for the feature class.
Validate Connectivity	Validates the number of connections on a feature and rejects the edits if the criteria are not met.
X Coordinate	Calculates the x-coordinate of a feature in database units.
Y Coordinate	Calculates the y-coordinate of a feature in database units.

Angle

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class name	Field used to store the calculated angle	ANGLE	Angle type

This rule can only be configured on linear features, and the angle value must be populated in Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter	Description
A	Populates arithmetic angle
G	Populates geographic angle

Example

AssignmentBreak|ANGLE|G

Top

Autonumber

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to autonumber	AUTONUMBER	No Value

This rule can only be configured on an Integer field.

Parameters

There are no parameters for this method.

Example

FacilitySite|FACILITYID

Top

Cascade Attributes

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class containing the field to monitor for changes	Field triggering the cascading attributes	CASCADE_ATTRIBUTE	Input\|Trigger\|Prompt

Parameters

The method parameters are as follows:

Parameter	Value	Description
Input	Table, layer, or feature class	Table or feature layer containing the field affected by the cascading updates.
Trigger	Field name	Field affected by the cascading updates.
Prompt	Blank	Display prompt to confirm the cascading update.
Prompt	False	Prompt will not display.

Example

Address|Name|False

Top

Copy Features

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class from which features will be copied	Field to monitor for updates	COPY_FEATURE	Value\|Target\|{Template}\|{Method}\|{Field Pairs}

Parameters

The method parameters are as follows:

Parameter	Value	Description
Value	String or numeric value	Rule is triggered when this value is entered into the field of interest.
Target	Feature layer or feature class	Affected features are copied or moved to this feature layer.
Template (Optional)	Editing template	Editing template used to symbolize and attribute the copied or moved feature. The feature symbology will be updated when the edits are saved.
Method (Optional)	Copy	Copies features from original location to the target location, but does not delete original feature. Deleting or Moving the feature is not supported.
Field Pairs (Optional)	String	Field map for transferring attribute values between the source and target features. Format: Source field-target field.

Example

wAbandonedLine|Abandoned Water Mains|COPY|DIAMETER-DIAMETER,MATERIAL-MATERIAL

wAbandonedLine

wAbandonedLine|||

Top

Copy Field Value

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class from which fields will be copied	Field to copy	FIELD	Source\|{Value}

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Field name	Field from which the values will be copied.
Value	CODE	The code value will be copied for fields with subtypes and/or domains.
Value	DISPLAY (Default)	The display value will be copied for fields with subtypes and/or domains.

Example

0|wAbandonedLine|Abandoned Water Mains|CUT|DIAMETER-DIAMETER,MATERIAL-MATERIAL

0|wAbandonedLine

0|wAbandonedLine|||

Top

Copy Linked Records

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class from which fields will be copied	Field to store the copied value	COPY_LINKED_RECORD	Target\|Target Field\|Primary Key\|Foreign Key

Parameters

The method parameters are as follows:

Parameter	Value	Description
Target	Table	Related table
Target Field	Field Name	Related table field containing the values to copy
Primary Key	Field name	Source features identifier used in the related table
Foreign Key	Field name	Related table field with values corresponding to the source feature identifiers

Top

Create Linked Records

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Blank or null	CREATE_LINKED_RECORD	Target\|Target Fields\|Source Fields\|Primary Key\|Foreign Key

Parameters

The method parameters are as follows:

Parameter	Value	Description
Target	Table or feature layer	Related table
Target Fields	Field Names	List of fields which in the related record layer/table in which values will be copied too. The format is a comma delimited list of field names. Example: field1,field2, and so on. List must have the same number of values as the Source Fields.
Source Fields	Field Name	List of fields in the source record to copy to the target related record. The format is a comma delimited list of field names. Example: field1,field2, and so on. List must have the same number of values as the Target Fields.
Primary Key	Field name	Source features identifier used in the related table
Foreign Key	Field name	Related table field with values corresponding to the source feature identifiers

Example

SWAP|Point_Y,Point_X|Point_Y,Point_X|FolioID|FolioID

Top

Create Perpendicular Line

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Blank or null	CREATE_PERP_LINE	Source\|Offset\|Neighborhood\|Snapping\|Target\|{Template}

This rule can only be configured on point features.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Line feature layer or feature class	Feature layer containing the existing line features.
Offset	Field name or value	Field containing the offset values, or a single value to use for all features.
Neighborhood	Value	Distance around each point to search for a line feature.
Snapping	True	Snap the new line to the existing line feature.
Snapping	False	Do not snap the new line to the existing line feature.
Target	Line feature layer or feature class	Feature layer to contain the new perpendicular lines.
Template (Optional)	Editing template	Editing template used to symbolize and attribute the new line feature.

Example

Top

Current Username

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to store the user name	CURRENT_USER	User name format

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Value	Description
W	Full Windows login name as domain\user name
U	Windows user name
D	Connected database user for the edit session
Null	Connected database user name if available; otherwise, full Windows login name as your domain\user name

Example

wHydrant|LASTEDITOR|W

Top

Edge Statistics

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Geometric network junction feature class	Field to store the statistics	EDGE_STATS	Source\|Statistic\|Delimiter\|SortOrder

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Field name	Numeric field to analyze
Statistic	Min	Minimum value
	Max	Maximum value
	Sum	Sum of all values
	Mean	Mean value
	Concat	Comma-delimited string containing the minimum, maximum, sum, and mean values
Delimiter	; or : or , or any other character, you cannot use \|	; or : or , or any other character, you cannot use \|	Value used in the concat Statistic method to join data
SortOrder	ASC or DESC	Option to specify how the results are sorted in when the concat statistic is used

Example

DIAMETER|Concat|;|ASC

Top

Expression

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field on which the expression should be executed	EXPRESSION	VbScript Expression

This rule can be configured on any field type.

Parameters

IIF statements can be used to create complex If Else statements. TCase was added to the script engine to support converting a string to title case, this is not a standard vbscript method. To run the expression on the edited field, use #, in the Field Name field. In the expression, the edited field can be indicated using [#].

Example

replace(([FROMMH] & "-" & [TOMH]),"MH-","")

IIF([DIAM] <= 6, "RED", IIF([DIAM] <=10 , "ORANGE", IIF([DIAM] <=15 , "GREEN","BLUE") ) )

IIF(isNull([UNIT]),[ADDRESS],TCase([ADDRESS]))

Top

Feature Statistics

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to store the statistics	FEATURE_STATS	Source\|Statistic\|Delimiter\|SortOrder

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Field name	List of numeric fields to summarize
Statistic	Min	Minimum value
	Max	Maximum value
	Sum	Sum of all values
	Mean	Mean value
	Concat	Comma-delimited string containing the minimum, maximum, sum, and mean values
Delimiter	; or : or , or any other character, you cannot use \|	Value used in the concat Statistic method to join data
SortOrder	ASC or DESC	Option to specify how the results are sorted in when the concat statistic is used

Example

POPFEMALE,POPMALE|Sum

Top

Field Trigger

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to monitor for change	FIELD_TRIGGER	Trigger\|Target\|Value

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Trigger	String or number	This value causes the target field to update.
Target	Field name	Field to update.
Value	String or number	The target field is updated to this value.

Example

ABANDONED|PRESSUREZONE|NONE

Top

From Edge Field

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Point feature class participating in a geometric network	Field in the junction feature layer	FROM_EDGE_FIELD	Field\|{Source}\|{Filter Field}\|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Field	Field name	Connected edge feature layer field to copy.
Source (Optional)	Layer or feature class	Limit the connected edge features to a single source layer.
Filter Field (Optional)	Field name	Only copy features with the filter value in this field.
Filter Value (Optional)	Value	Only copy features with this value in the filter field.

Example

FACILITYID|wServiceConnection|Service Type|Domestic

Top

From Edge Multiple Field Intersection

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Geometric network junction feature class	Null or blank	FROM_EDGE_MULTI_FIELD_INTERSECT	Source\|Target

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Field name	Field to copy
Target	String	Array of fields to populate

Example

DIAMETER|Diam1,Diam2,Diam3

Top

From Edge Statistics

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to store the statistics	FROM_EDGE_STATS	Source\|Statistic\|Delimiter\|SortOrder

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Field name	List of numeric fields to summarize
Statistic	Min	Minimum value
	Max	Maximum value
	Sum	Sum of all values
	Mean	Mean value
	Concat	Comma-delimited string containing the minimum, maximum, sum, and mean values
Delimiter	; or : or , or any other character, you cannot use \|	Value used in the concat Statistic method to join data
SortOrder	ASC or DESC	Option to specify how the results are sorted in when the concat statistic is used

Example

DIAMETER|Max

Top

From Junction Field

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Line feature class participating in a geometric network	Field in the line feature layer	FROM_JUNCTION_FIELD	Field\|{Source}\|{Filter Field}\|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Field	Field name	Junction feature layer field to copy. If you use (NAME), the name of the feature class that the feature is in will be populated, not a value from the feature.
Source (Optional)	Layer or feature class	To limit the rule to only run when a particular layer is connected, list the name of the junction feature layer or feature class.
Filter Field (Optional)	Field name	Only copy features with the filter value in this field.
Filter Value (Optional)	Value	Only copy features with this value in the filter field.

Example

FACILITYID|wServiceConnection|Service Type|Domestic

FACILITYID

Top

Generate ID

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	The field to contain the identifier	GENERATE_ID	Name\|{Width}\|{Format}[seq]\|{Option}

This rule can be configured on any field type, but the format of the field should be coordinated with the format of your identifier.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Name	String	The name of the sequence.
Width	Integer	The length of the identifier. If the current value of [seq] is shorter than this value, zeros will be added to the left of [seq] to create the specified width. This setting is only valid for string fields.
Format	String	Format of the resulting ID. Placeholder for the iterated value; [seq] may appear anywhere in the format string.
Option	True or False	Option to limit the rule to only be triggered when the field is null. This will save the rule from accidentally overriding existing IDs

Example

POLE|4|POLE-[seq]|True

Top

Generate ID From A Grid

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	The field to contain the identifier	GENERATE_ID_BY_INTERSECT	Source\|Source Field\|Name\|{Width}\|{Format}[id][seq]\|{Option}

This rule can be configured on any field type, but the format of the field should be coordinated with the format of your identifier.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Polygon feature class or feature layer	Grid features.
Source Field	Field name	Field containing grid identifiers.
Name	String	The name of the sequence.
Width (Optional)	Integer	The length of the identifier. If the current value of [seq] is shorter than this value, zeros will be added to the left of [seq] to create the specified width.
Format (Optional)	String	Static portion of the identifier.
[id]	[id]	Placeholder for the grid identifier in the generated ID; [id] may appear anywhere in the formatted string.
[seq]	[seq]	Placeholder for the iterated value; [seq] may appear anywhere in the format string.
Option	True or False	Option to limit the rule to only be triggered when the field is null. This will save the rule from accidentally overriding existing IDs

Example

Grid|GRID_ID|wHydrant|3|FH-[ID]-[SEQ] will populate FH-A1-001 where the Generate ID Table has the sequence name wHydrantA1 with a Sequence counter of 1

Top

Get Address From Road Centerline

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to which the address will be written	GET_ADDRESS_FROM_CENTERLINE	Roads\|Source\|{Neighborhood}

This rule always searches the feature class, not the feature layer.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Roads	Feature class	Road centerlines feature class
Source	String	Addressing information fields in the format: Road Name, To Left, To Right, From Left, From Right
Neighborhood (Optional)	Value	Search distance

Example

RoadCenterline|ROADNAME,TOLEFT,TORIGHT,FROMLEFT,FROMRIGHT|5

Top

Get Address Using ArcGIS Service

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to which the address will be written	GET_ADDRESS_USING_ARCGIS_SERVICE	{URL to Locator}\|{WKID}

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
URL to Locator	String	The default service is the ArcGIS Online geocoding service.
WKID (Optional)	String	If the coordinate you are passing to the service is in a different coordinate system, specify the projection of the service.

Example

http://yourlocator/arcgis/rest/services/Address_with_Zone|4326

Top

Get Address Using Geocoder

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to which the address will be written	GET_ADDRESS_USING_GEOCODER	URL to Locator

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
URL to Locator	String	The path to locator and locator name

Example

SERVER=mylaptop_sqlexpress;INSTANCE=sde:sqlserver:mylaptop\sqlexpress;DATABASE=LocalGovernment;AUTHENTICATION_MODE=OSA;VERSION=dbo.DEFAULT|LocatorName

Top

Generate a Globally Unique Identifier (GUID)

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	String field long enough to store the desired format of GUID	GUID	Format of GUID

Parameters

The method parameters are as follows:

Value	Description
B (Default)	GUID with dashes, braces, and length of 38
D	GUID with dashes and length of 36
N	GUID with no special characters and length of 32
P	GUID with dashes, parentheses, and length of 38

Example

wHydrant|PRIMARYKEY|D

Top

Intersect Count

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field into which the count will be copied	INTERSECT_COUNT	Intersecting layer or feature class

This rule can be configured on polygon features, and the count value must be populated in Floating or Short fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Feature class or feature layer	Intersecting features from which a count will be calculated. Note: The feature class name within the .mxd must be used.

Parameter

Value

Description

Source

Feature class or feature layer

Intersecting features from which a count will be calculated.

Note: The feature class name within the .mxd must be used.

Example

Water Hydrants

Top

Intersecting Edges

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field into which the values will be copied	INTERSECTING_EDGE	Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Field	Field name	Field to copy from the intersecting edge

Example

DIAMETER

Top

Intersecting Feature

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field for the intersecting values	INTERSECTING_FEATURE	Input\|Source\|Method\|SetNullIfNone

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Input	String	List of layers to search for intersecting features in the format layer1,layer2, and so on.
Source	Field name	Intersecting features field to copy value from.
Method	P	Prompt for search method.
	C	Search using centroids.
	F	Return the first result found.
SetNullIfNone	TRUE or FALSE	If no intersecting feature is found, value will be set to null if parameter is TRUE

Examples

ssPressurizedMain,ssGravityMain|DIAMETER|C

wMain|DIAMETER|F|True

Top

Intersecting Feature Distance

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to hold the distance measurement	INTERSECTING_FEATURE_DISTANCE	Source\|Identifier

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Feature class or feature layer	List of features which may intersect the lines in the format layer1,layer2, and so on
Identifier	Field name	Field identifying the intersecting feature

Example

ssPressurizedMain,ssGravityMain|FACILITYID

Top

Intersecting Layer Details

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to hold the details of the intersecting feature	INTERSECTING_LAYER_DETAILS	Source\|Result\|Method\|{Filter}

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	RASTER	Extract details for intersecting rasters only.
	VECTOR	Extract details for intersecting vector features only.
	BOTH	Extract details for intersecting rasters and vectors.
	List of feature classes or feature layers	Extract details for intersecting features from a defined list of feature classes or feature layers in the format layer1,layer2, and so on.
Result	P	Extract the full path of the intersecting feature class.
	N	Name of the intersecting layer.
	F	The name of the feature class.
Method	C	Search using centroids.
	P	Prompt for search method.
	F	Return the first result found.
Filter (Optional)	String	Restrict the intersecting features to those matching a wildcard filter.

Example

VECTOR|N|P

Top

Intersecting Raster

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to hold the extracted value	INTERSECTING_RASTER	Source\|Label(optional)

If a label is specified and the target field is not a text field, the label will be omitted.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	RASTER	Raster from which the value will be extracted. A list of rasters may be entered in the format raster1,raster2, and so on.
Label	Any text value	Optional text to add prior to the elevation information. Any valid if the result is being stored in a text field.

Example: This will result in a value stored like Elevation: 698.23

FiveMeterSurface|Elevation:

Example: This will result in a value stored like 698.23

FiveMeterSurface

Top

Intersecting Statistics

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to store the statistics	INTERSECT_STATS	Source\|Source Field\|Statistic\|Neighborhood\|Delimiter\|SortOrder

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Layer or feature class	Intersecting features
Source Field	Field name	Numeric field to analyze
Statistic	Min	Minimum value
	Max	Maximum value
	Sum	Sum of all values
	Mean	Mean value
	Concat	Comma-delimited string containing the Source Field values from intersecting features
Neighborhood	Value	Search tolerance
Delimiter	; or : or , or any other character, you cannot use \|	Value used in the concat Statistic method to join data
SortOrder	ASC or DESC	Option to specify how the results are sorted in when the concat statistic is used

Example

ssGravityMain|DIAMETER|Max|25

Top

Junction Rotation

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Junction feature class or feature layer	Field to store the rotation angle	JUNCTION_ROTATION	Type\|{Additional}\|{Special}\|{Feature Class}

This rule can only be configured on Floating, Integer, or Double fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Type	A	Arithmetic rotation.
Type	G (Default)	Geographic rotation.
Additional (Optional)	Value	Additional degrees to rotate the features.
Special (Optional)	Numeric field name	Features will be spun from the smaller to the larger value. For example, you can use this for reducer fittings and the diameter field of the mains so the reducer is properly oriented.
Source (Optional)	Feature class	Rotation will be calculated based on angle of features only in this layer. Note: The database name of the feature class must be used.

Example

G|90|Diameter|ssLateralLines

Top

Last Value

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	The field in which the value will be repeated	LAST_VALUE	Null Values\|Default

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Null Values	True	Only affects null values
Null Values	False	Overwrites all field values
Default	Value	The value to enter in the field if there is no last value

Example

True|PVC

Top

Latitude

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	The field in which the value will be stored	LATITUDE	Feature location to use for coordinate

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Value	Description
None	Coordinate of the centroid of line and polygon features
S	Coordinate of the start point of line features
E	Coordinate of the end point of line features

Example

INCIDENTPT|LATLOC|

Top

Length

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	The field to store the measurement	LENGTH	None

This rule can only be configured on linear features, and the length value must be populated in Floating or Double fields.

Parameters

There are no parameters for this method.

Top

Link Table Asset

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	The field to update. List multiple fields in the format field1,field2, and so on.	LINK_TABLE_ASSET	Source\|Source Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Layer or feature class	The feature layer or feature class from which the values will be copied
Source Field	Field name	The field to copy the value from

This rule lists multiple fields in the format field1,field2, and so on. The value of the first field listed will be copied to the first field listed in Field Name.

Example

wMain|FacilityID

Top

Longitude

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	The field in which the value will be stored	LONGITUDE	Feature location to use for coordinate

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Value	Description
None	Coordinate of the centroid of line and polygon features
S	Coordinate of the start point of line features
E	Coordinate of the end point of line features

Example

INCIDENTPT|LONGLOC|

Top

Minimum Length

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Blank or null	MINIMUM_LENGTH	Parameter

This rule can only be configured on linear features and the length value must be populated in Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Value	Minimum length	Minimum length of line

Top

Multiple Fields Intersecting Values

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class with which features will intersect	Null or blank	MULTI_FIELD_INTERSECT	Source\|Source Field\|Target Fields\|Neighborhood

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Layer or feature class	Intersecting features from which values will be copied
Source Field	Field Name	Field from which values will be copied
Target Fields	Field Name	List of fields to which values will be copied in the format field1,field2, and so on
Neighborhood	Value	Distance to search for intersecting features

Example

ssGravityMain|DIAMETER|Diam1,Diam2,Diam3|25

Top

Nearest Feature

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to which the values will be copied	NEAREST_FEATURE	Source\|Source Field\|Neighborhood\|Source Filter\|Target Filter

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Feature layer or feature class	List of datasets that may contain the nearest feature in the format layer1,layer2, and so on.
Source Field	Field name	Field from which values will be copied.
Neighborhood	Value	Maximum distance to search for the nearest feature.
Source Filter (Optional)	Field name	Filter by restricting results to source features with a value in this field matching the value in the Target Filter field.
Target Filter (Optional)	Field name	Filter by restricting results to source features with a value in this field matching the value in the Source Filter field.

Example

To populate ACCOUNT in wLateralLine using the value from ACCOUNT from a feature from wMeter or wLateralPoint within 100ft:

Table Name: wLateralLine
Field Name: ACCOUNT
Value Method: wMeter,sLateralPoint|ACCOUNT|100

To populate ACCOUNT in wLateralLine using the value from ACCOUNT from a feature from wMeter or wLateralPoint within 100ft who's DIAMETER matches the DIAMETER in the edited feature:

Table Name: wLateralLine
Field Name: ACCOUNT
Value Method: wMeter,sLateralPoint|ACCOUNT|100|DIAMETER|DIAMETER

Top

Nearest Feature Attributes

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Null or blank	NEAREST_FEATURE_ATTRIBUTES	Feature Class Search\|Fields in that feature class\|Fields in the source Feature class\| Distance

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Line feature layer or feature class	Dataset near the target dataset.
Source Field	Field name	List of fields from which values will be copied in the format field1,field2, and so on. List must have the same number of values as the Target Fields.
Target Fields	Field name	List of fields to which values will be copied in the format field1,field2, and so on. List must have the same number of values as the Source Fields.
Neighborhood	Value	Maximum distance to search for nearest feature.

Example

wServiceConnection|LOCATIONID,LASTEDITOR|SVCLOCID,SVCEDITOR|50

Top

Offset

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Two field names in the format field1,field2 to store the x and y values	OFFSET	Source\|Offset\|Neighborhood

This rule can only be configured on point features, and the angle value must be populated in Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Layer or feature class	Line feature class or feature layer
Offset	Field name or value	Field containing the offset values, or a single value to use for all features
Neighborhood	Value	Maximum distance around each point to search for a line feature

Example

sewpipes|5|5

Top

Previous Value

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to monitor	PREVIOUS_VALUE	Field

Parameters

The method parameters are as follows:

Parameter	Value	Description
Field	Field name	Field to store the previous value

Top

Prompt

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	List of fields to search in the format field1,field2, and so on	PROMPT	Null or blank

This rule can be configured on any field type.

Parameters

There are no parameters for this method.

Top

Set Measures

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class with m-values enabled	Field to contain m-values	SET_MEASURES	Calculation type

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Calculation Type	Blank	Calculates m-values from zero to the length of the line in map units
Calculation Type	P	Calculates m-values as a percentage of the length of the line (0–100%)

Top

Side

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field to contain LEFT and RIGHT values	SIDE	Source\|Primary Key\|Foreign Key

This rule can only be configured on point features, and the value must be populated in a String field.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Layer or feature class	Line features
Primary Key	Field name	Identifying field for line features in the line feature class
Foreign Key	Field name	Field in the point feature class containing the identifiers of the corresponding line features

Example

ssGravityMain|OBJECTID|MainID

Top

Split Intersecting Feature

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Null or blank	SPLIT_INTERSECTING_FEATURE	Feature classes

This rule can only be configured on point features, and the value must be populated in a String field.The method does not work for geometric network features.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Feature Class	List of feature classes	Lists feature classes that will be split by the input features in the format layer1\|layer2\| and so on

Example

wConstructionLine|wMain

Top

Timestamp

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Date or string field	TIMESTAMP	Date and time format to use

This rule can only be configured on String fields if you select the YEAR, DAY, or MONTH parameters.

Parameters

The method parameters are as follows:

Value	Description
Blank	Leaving the Value Info field blank will use the current date and time.
DATE	Date only.
TIME	Time only in 12-hour format.
TIME24	Time only in 24-hour format.
DAY	Day only.
MONTH	Month only.
YEAR	Year only.
CUSTOM	Specify format; for example, hh:mm:ss tt = 09:30:00 AM, MMMM = Month in text, such as March, and HH = Hour of the day, such as 23.

Example

YEAR

Top

To Edge Field

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Point feature class participating in a geometric network	Field in the junction feature layer	TO_EDGE_FIELD	Field\|{Source}\|{Filter Field}\|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Field	Field name	Junction field from which the values will be copied.
Source (Optional)	Layer or feature class	Restricts the To edge features to a single feature class.
Filter Field (Optional)	Field name	Filters the To edge features where the values in this field match the Filter value.
Filter Value (Optional)	Value	Only copy features with this value in the filter field.

Example

FACILITYID|wServiceConnection|Service Type|Domestic

Top

To Edge Multiple Field Intersect

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Geometric network junction feature class	Null or blank	TO_EDGE_MULTI_FIELD_INTERSECT	Source\|Target

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Field name	Field to copy
Target	String	Array of fields to populate

Example

DIAMETER|Diam1,Diam2,Diam3

Top

To Edge Statistics

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field to store the statistics	TO_EDGE_STATS	Source\|Statistic\|Delimiter\|SortOrder

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Field name	List of numeric fields to analyze
Statistic	Min	Minimum value
	Max	Maximum value
	Sum	Sum of all values
	Mean	Mean value
	Concat	Comma-delimited string containing the minimum, maximum, sum, and mean values
Delimiter	; or : or , or any other character, you cannot use \|	Value used in the concat Statistic method to join data
SortOrder	ASC or DESC	Option to specify how the results are sorted in when the concat statistic is used

Example

DIAMETER|Max

Top

To Junction Field

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Line feature class participating in a geometric network	Field in the line feature layer	TO_JUNCTION_FIELD	Field\|{Source}\|{Filter Field}\|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Field	Field name	Junction feature layer field to copy. If you use (NAME), the name of the feature class that the feature is in will be populated, not a value from the feature.
Source (Optional)	Layer or feature class	To limit the rule to only run when a particular layer is connected, list the name of the junction feature layer or feature class.
Filter Field (Optional)	Field name	Only copy features with the filter value in this field.
Filter Value (Optional)	Value	Only copy features with this value in the filter field.

Example

FACILITYID|wServiceConnection|Service Type|Domestic

FACILITYID

Top

Update Intersecting Feature

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Feature class or feature layer that, when updated, is tested for intersecting Target features	Layer or feature class to monitor for changes	UPDATE_INTERSECTING_FEATURE	Target\|Target Field\|Source Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Target	Layer or feature class	Layer or layers containing features that intersect the original updated feature. List multiple layers in the format layer1,layer2, and so on.
Target Field	Field name	Field in the Target layers into which a value will be copied. Only one Target Field may be defined, so a common field name is required for multiple Target layers.
Source Field	Value or field name	Value or field in Table Name that will be copied into the Target Field.

Top

Update Linked Record

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class to monitor for updates	The field to monitor and copy	UPDATE_LINKED_RECORD	Target\|Target Field\|Primary Key\|Foreign Key

This rule can be configured on any field type. This method cannot be triggered from the Attribute Assistant toolbar.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Target	Layer or feature class	Related table into which the values will be copied
Target Field	Field name	The field to populate with the copied record
Primary Key	Field name	Source features identifier used in the related table
Foreign Key	Field name	Related table field corresponding to the source features

Example

CABLES|NO_CABLES|DUCT_ID|DUCT_ID

Top

Validate Attribute Lookup

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field or fields to monitor	VALIDATE_ATTRIBUTE_LOOKUP	Source\|Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Source	Table, layer, or feature class	Lookup table.
Field	Field name	Field or fields in the lookup table. List multiple fields separated by commas.

Example

MasterStreetName|FULLNAME,MUNICIPALITY

Top

Validate Attributes

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Table, layer, or feature class	Field or fields to monitor	VALIDATE_ATTRIBUTES	Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Field or fields	List of field names	List fields to monitor in the format field1,field2, and so on

Example

DIAMETER,MATERIAL,Line Type

Top

Validate Connectivity

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	Field name to provide different valid connection values for each value within this field	VALIDATE_CONNECTIVITY	Parameter

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter	Value	Description
Connections	List number of connections	List the number of valid connections separated by \|.

Example

No field defined and one, two, or four connections are valid.

1|2|4

A field is defined in Field Name containing values Bend and Tap. If a feature has a value of Bend in this field, one or three connections are valid. If the feature has a value of Tap, one or four connections are valid.

Bend,1| Bend,3|Tap,1,4

Top

X Coordinate

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	The field in which the value will be stored	X_COORDINATE	Parameter

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Value	Description
None	Coordinate of the centroid of line and polygon features
S	Coordinate of the start point of line features
E	Coordinate of the end point of line features

Example

INCIDENTPT|XCOORDLOC|

Top

Y Coordinate

To configure this method, populate the following in the DynamicValue table:

Table	Field	Value Method	Value Info
Layer or feature class	The field in which the value will be stored	Y_COORDINATE	Parameter

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Value	Description
None	Coordinate of the centroid of line and polygon features
S	Coordinate of the start point of line features
E	Coordinate of the end point of line features

Example

INCIDENTPT|YCOORDLOC|

Top