Page Comparison

Capability

This Import allows the User to INSERT or UPDATE existing Approval Criteria for Requests created through CustomerCenter.

Matches On

You can match on existing records by either

• RECID

• Matching by Criteria fields

Every Criteria field can be Matched On and when using Criteria fields to match, all fields that have values in the database must be provided in the Import in order to match.

For example, if there is an existing record with a GLA, Department Owner, and Equipment Catalog all three of those would need to be provided to match. Supplying just the GLA and Department Owner would not be enough since there are no partial matches, only exact.

All Criteria fields have a "duplicate" field prefixed with "New" to denote the new value that will be applied on the completion of the update.

Fields

RECID

Datatype is Number

Default: blank

EQP CATALOG

Datatype is Hierarchical String

Note: Service Catalog and Equipment Catalog cannot both have values.

SERV CATALOG

Datatype is Hierarchical String

Note: Service Catalog and Equipment Catalog cannot both have values.

OWNER CONTACTS CUSTOMER NUMBER

Datatype is String

Note: Owner Contacts and Owner Department cannot both have values.

OWNER CONTACTS FIRST NAME

Datatype is String

MUST be used with OWNER CONTACTS LAST NAME.

Note: Owner Contacts and Owner Department cannot both have values.

OWNER CONTACTS LAST NAME

Datatype is String

MUST be used with OWNER CONTACTS FIRST NAME.

Note: Owner Contacts and Owner Department cannot both have values.

OWNER DEPT HIERARCHY

Datatype is Hierarchical String

The full Department Hierarchy Path Code value should be provided.

The Import does not accept the Department Hierarchy Name.

Note: Owner Contacts and Owner Department cannot both have values.

GLA

Datatype is Hierarchical String

AMOUNT MINIMUM

Datatype is Number

AMOUNT MAXIMUM

Datatype is Number

APPROVER CONTACTS CUSTOMER NUMBER

Datatype is String

APPROVER CONTACTS FIRST NAME

Datatype is String

MUST be used with APPROVER CONTACTS LAST NAME.

APPROVER CONTACTS LAST NAME

Datatype is String

MUST be used with APPROVER CONTACTS FIRST NAME.

NEW EQP CATALOG

Datatype is Hierarchical String

Note: New Service Catalog and New Equipment Catalog cannot both have values

NEW SERV CATALOG

Datatype is Hierarchical String

Note: New Service Catalog and New Equipment Catalog cannot both have values

NEW OWNER CONTACTS CUSTOMER NUMBER

Datatype is String

Note: Owner Contacts and Owner Department cannot both have values.

NEW OWNER CONTACTS FIRST NAME

Datatype is String

MUST be used with NEW OWNER CONTACTS LAST NAME.

Note: Owner Contacts and Owner Department cannot both have values.

NEW OWNER CONTACTS LAST NAME

Datatype is String

MUST be used with NEW OWNER CONTACTS FIRST NAME.

Note: Owner Contacts and Owner Department cannot both have values.

NEW OWNER DEPT HIERARCHY

Datatype is Hierarchical String

The full Department Hierarchy Path Code value should be provided.

Note: Owner Contacts and Owner Department cannot both have values.

NEW GLA

Datatype is Hierarchical String

NEW AMOUNT MINIMUM

Datatype is Number.

NEW AMOUNT MAXIMUM

Datatype is Number.

Flags

FLAG_CLEAR_APPROVERS

Datatype is Boolean

Default: False

Will remove all approvers for criteria.

Note: If this is set to true when updating, the approver is required

FLAG_UPDATE_BLANKS

Datatype is Boolean

Default: False

This flag is only relevant when updating a record. When set to true, any fields that were mapped either with Column Mappings or Conditional Logic and have a blank value will be cleared on the record. If the flag is false or a field has not been mapped the value on the record will be retained.

Note:it will only update blank mapped fields

Errors

• Fields that convert to recids can throw
  • No records found
  • Multiple records found
  • Record must be active
• Catalog fields cannot be a category
• Amount fields must be numeric
• Amount fields cannot be negative
• Minimum Amount cannot be greater than Maximum Amount
• At least one Approver required for
  • Inserts
  • Updates when Clear Approvers is true
• Inserts require at least one criteria field.
• Update would result in all blank criteria fields.