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.