To begin the validation process, the user can navigate to the Edit Rules interface () to outline the parameters of certain data items. This interface allows the user to implement rules that will trigger errors if item types do not comply. The Edit Rules interface is located under the Edit tab in the Managment section.
Edit a Rule
Once the "Edit Rules" icon is selected, this interface will appear.
Then, the user can follow the steps outlined below. Most steps will be associated with a table number (first, second, third, or fourth) which corresponds to the table placement as it is listed on the interface and shown in the image above.
(1) Select a Rule
In this interface, the user must first select the rule type they wish to edit-- Import, Coverage, Cross, or Edit-- from the picklist at the top of the Validation Rules Maintenance Interface. The first three options correspond to the validation types in HPMS Manager (Validations tab > HPMS Validations section). The Edit option corresponds to validations for SCDOT's Inventory Manager.
(2) Select a data item row (First Table)
(3) Edit the values in the criterion rows
There are many values the user can edit in this interface once a Rule Type and Data Item row are selected.
Failure Message
To edit the failure message, the user can click into the textbox and type a new value. If an HPMS Data Item does not have a rule for the selected Rule Type (Import, Cross, Coverage, or Edit), the failure message will appear blank.
Left Condition
Any information entered into the Left Condition table (third table) can be used to edit the Left Condition column in the Validation Rule Definition table (second table). In the Left Condition table, the user can select a Condition Type in the Type column (Data Item, Value, or Overlay Column), edit the Condition Value (picklist or textbox), add an arithmetic operation in the Arithmetic column (operation between 2+ conditions), add a condition (left "+" button), and remove a condition (left “X“ button). Then, the Left Condition column in the Validation Rule Definition table will be updated accordingly.
Right Condition
Any information entered into the Right Condition table (fourth table) can be used to edit the Right Condition column in the Validation Rule Definition table (second table). In the Right Condition table, the user can select a Condition Type in the Type column (Data Item, Value, Code list, and Overlay Column), edit the Condition Value (picklist or textbox), add an arithmetic operation in the Arithmetic column (operation between 2+ conditions), add a condition (left “+” button), and remove a condition (left “X“ button). Then, the Right Condition column in the Validation Rule Definition table will be updated accordingly.
Join/Parentheses
To group or create condition rule criteria in any of the tables, the Join and Parentheses fields can be used.
+/-
The "+/-" column can be used to add a new criterion row (+) or delete an existing criterion row (X).
(4) Save the edits
After editing the desired rule, click the "Save Changes" button at the bottom of the interface to solidify the new values.
Add New & Delete Rules
The user can both add a new rule and delete an existing rule in the first table on the Edit Rules interface. To add a new validation rule, click the "Add Rule" link, then edit the values in all four tables (see the editable fields above). To delete a validation rule, check the checkbox to the left of the desired rule(s). After selecting the desired rules, click the "Delete All Selected" link. Click the "Save Changes" button to solidify the addition or deletion.
Comments
0 comments
Please sign in to leave a comment.