Service Directory > v32.1 > Resource_Management > Import_Expense_Rate_Table
 

Operation: Import_Expense_Rate_Table

This web service operation will add or update Expense Rate Tables. This contains Name, Type, Default Currency, Expense Item Type for evaluation and Rate Table Lines. Each Rate Table Line contains a reference to a Condition Rule, Behavior Spend Data, and Graduated Expense Data.


@ - A parameter name with this symbol denotes an XML attribute within the document instead of an XML element.


Contents

 

Web Service

 

Request

 

Response

 

Element(s)

 

Request Element: Expense_Rate_Table_Header__HV__Request

Element containing Expense Rate Table reference for update and all Expense Rate Table data items
 
Parameter name Type/Value Cardinality Description Validations
@version string [0..1] Web Service version  
@Add_Only  boolean  [1..1]  Add Only Flag. Indicates that the service is an add only, not an update. If an existing instance is found and this flag is set there will be an error.   
Expense_Rate_Table_Reference  Expense_Rate_TableObject  [0..1]  Reference to an existing Expense Rate Table for update only purposes   
Expense_Rate_Table_Data  Expense_Rate_Table__HV__Data  [1..1]  Element containing all Expense Rate Table data 
Validation Description
Currency is required for Expense Rate Table with table type of Amount, Graduated Amount, or Maximum Amount. Currency is not used in Expense Rate Table with table type of Graduated Percent.  Currency is required for Expense Rate Table with table type of Amount, Graduated Amount, or Maximum Amount. Currency is not used in Expense Rate Table with table type of Graduated Percent. 
Expense Item Attribute Type is not used by Expense Rate Table with table type of Maximum.  Expense Item Attribute Type is not used by Expense Rate Table with table type of Maximum. 
 
top
 

Response Element: Put_Import_Process_Response

Put Import Process Response element
 
Parameter name Type/Value Cardinality Description Validations
@version string [0..1] Web Service version  
Import_Process_Reference  Web_Service_Background_Process_RuntimeObject  [0..1]  Web Service Background Process Runtime element   
Header_Instance_Reference  InstanceObject  [0..1]  Header Instance element   
top
 

Expense_Rate_TableObject

part of: Expense_Rate_Table_Header__HV__Request
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Expense_Rate_TableObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Expense_Rate_TableObjectID

part of: Expense_Rate_TableObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Expense_Rate_Table_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Expense_Rate_Table__HV__Data

part of: Expense_Rate_Table_Header__HV__Request
Element containing all Expense Rate Table data
 
Parameter name Type/Value Cardinality Description Validations
Expense_Rate_Table_ID  string  [0..1]  Expense Rate Table ID   
Expense_Rate_Table_Name  string  [1..1]  Free form text for a meaningful Expense Rate Table Name   
Expense_Rate_Table_Type_Reference  Expense_Rate_Table_TypeObject  [1..1]  Reference to an existing Expense Rate Table Type. This will determine the usage of the expense rate table, as well as how it is evaluated on the calculation of the fixed/maximum amount of an expense item   
Currency_Reference  CurrencyObject  [0..1]  Reference to an existing Currency   
Expense_Item_Attribute_Type_Reference  Expense_Item_Attribute_TypeObject  [0..1]  Reference to an existing Expense Item Attribute Type. The expense item attribute will be evaluated by the range of a graduated expense rate and/or is a variable in the calculation of the fixed amount of an expense item   
Expense_Rate_Table_Effective_Date  date  [1..1]  Effective Date   
Expense_Rate_Table_Line_Replacement_Data  Expense_Rate_Table_Line__HV__Data  [0..*]  Element containing all Expense Rate Table Line data 
Validation Description
"[rule]" is not an Expense Rate Table Rule and cannot be used on an Expense Rate Table.  Expense Rate Table specifically use Expense Rate Table Rules and not any type of Condition Rule. 
Only one criteria for each type is allowed for each expense rate table line.  Only one criteria for each type is allowed for each expense rate table line. 
Expense Rate Table with table type of Amount or Maximum can only have one Graduated Expense Rate per Expense Rate Table Line.  Expense Rate Table with table type of Amount or Maximum can only have one Graduated Expense Rate per Expense Rate Table Line. 
This expense rate table has existing criteria. Create a new expense rate table or edit the original expense rate table if you need to change the criteria.  This expense rate table has existing criteria. Create a new expense rate table or edit the original expense rate table if you need to change the criteria. 
 
Validation Description
Currency is required for Expense Rate Table with table type of Amount, Graduated Amount, or Maximum Amount. Currency is not used in Expense Rate Table with table type of Graduated Percent.  Currency is required for Expense Rate Table with table type of Amount, Graduated Amount, or Maximum Amount. Currency is not used in Expense Rate Table with table type of Graduated Percent. 
Expense Item Attribute Type is not used by Expense Rate Table with table type of Maximum.  Expense Item Attribute Type is not used by Expense Rate Table with table type of Maximum. 
top
 

Expense_Rate_Table_TypeObject

part of: Expense_Rate_Table__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Expense_Rate_Table_TypeObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Expense_Rate_Table_TypeObjectID

part of: Expense_Rate_Table_TypeObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Expense_Rate_Table_Type_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

CurrencyObject

part of: Expense_Rate_Table__HV__Data, Graduated_Expense_Rate__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  CurrencyObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

CurrencyObjectID

part of: CurrencyObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Currency_ID, Currency_Numeric_Code  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Expense_Item_Attribute_TypeObject

part of: Expense_Rate_Table__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Expense_Item_Attribute_TypeObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Expense_Item_Attribute_TypeObjectID

part of: Expense_Item_Attribute_TypeObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Expense_Item_Attribute_Type_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Expense_Rate_Table_Line__HV__Data

part of: Expense_Rate_Table__HV__Data
Element containing all Expense Rate Table Line data
 
Parameter name Type/Value Cardinality Description Validations
Line_Order  string (6)   [0..1]  Line order   
Expense_Rate_Table_Rule_Reference [Choice]   Condition_RuleObject  [0..1]  Reference to an existing Expense Rate Table Rule   
Criteria_Reference [Choice]   Behavior_Spend_DataObject  [0..*]  Reference to existing Spend Data   
Graduated_Expense_Rate_Data  Graduated_Expense_Rate__HV__Data  [1..*]  Element containing all Graduated Expense Rate data 
Validation Description
Currency is not used in Expense Rate Table with table type of Graduated Percent.  Currency is not used in Expense Rate Table with table type of Graduated Percent. 
Maximum Value is not used in Expense Rate Table with table type of Amount.  Maximum Value is not used in Expense Rate Table with table type of Amount. 
Minimum Value is not used in Expense Rate Table with table type of Amount.  Minimum Value is not used in Expense Rate Table with table type of Amount. 
Average Value is used in Expense Rate Table with table type of Maximum.  Average Value is used in Expense Rate Table with table type of Maximum. 
Expense Rate is not used in Expense Rate Table with table type of Maximum.  Expense Rate is not used in Expense Rate Table with table type of Maximum. 
Maximum Value is required for Expense Rate Table with table type Maximum or Graduated Amount  Maximum Value is required for Expense Rate Table with table type Maximum or Graduated Amount 
Expense Rate is required for Expense Rate Table with table type Amount, Graduated Amount, or Graduated Percent  Expense Rate is required for Expense Rate Table with table type Amount, Graduated Amount, or Graduated Percent 
A Start of Range can only be used once for an Expense Rate Table line.  A Start of Range can only be used once for an Expense Rate Table line. 
An End of Range can only be used once for an Expense Rate Table line.  An End of Range can only be used once for an Expense Rate Table line. 
End of Range must be greater than the Start of Range.  End of Range must be greater than the Start of Range. 
The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next must be 0.1 when any of the End of Range values is a decimal.  The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next must be 0.1 when any of the End of Range values is a decimal. 
The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next line must be 1.  The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next line must be 1. 
 
Validation Description
"[rule]" is not an Expense Rate Table Rule and cannot be used on an Expense Rate Table.  Expense Rate Table specifically use Expense Rate Table Rules and not any type of Condition Rule. 
Only one criteria for each type is allowed for each expense rate table line.  Only one criteria for each type is allowed for each expense rate table line. 
Expense Rate Table with table type of Amount or Maximum can only have one Graduated Expense Rate per Expense Rate Table Line.  Expense Rate Table with table type of Amount or Maximum can only have one Graduated Expense Rate per Expense Rate Table Line. 
This expense rate table has existing criteria. Create a new expense rate table or edit the original expense rate table if you need to change the criteria.  This expense rate table has existing criteria. Create a new expense rate table or edit the original expense rate table if you need to change the criteria. 
top
 

Condition_RuleObject

part of: Expense_Rate_Table_Line__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Condition_RuleObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Condition_RuleObjectID

part of: Condition_RuleObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Condition_Rule_ID, WCP_Component_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Behavior_Spend_DataObject

part of: Expense_Rate_Table_Line__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Behavior_Spend_DataObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Behavior_Spend_DataObjectID

part of: Behavior_Spend_DataObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Airline_ID, Airport_ID, Applicant_ID, Car_Rental_Agency_ID, Class_of_Service_Value, Contingent_Worker_ID, Country_Region_ID, Eligibility_ID, Employee_ID, External_Committee_Member_ID, Fuel_Type_ID, Hotel_ID, Invoice_Type_ID, ISO_3166-1_Alpha-2_Code, ISO_3166-1_Alpha-3_Code, ISO_3166-1_Numeric-3_Code, ISO_3166-2_Code, Spend_Data_ID, Travel_City_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Graduated_Expense_Rate__HV__Data

part of: Expense_Rate_Table_Line__HV__Data
Element containing all Graduated Expense Rate data
 
Parameter name Type/Value Cardinality Description Validations
Minimum_Value  decimal (26, 6)   [0..1]  Minimum Amount for Maximum Expense Rate Tables or Start of Range for Graduated Amount and Percent Expense Rate Tables.   
Average_Value  decimal (18, 6) >0   [0..1]  Average Amount for Maximum Expense Rate Tables.   
Maximum_Value  decimal (26, 6)   [0..1]  Maximum Amount for Maximum Expense Rate Tables or End of Range for Graduated Amount and Percent Expense Rate Tables.   
Rate  decimal (18, 6) >0   [0..1]  Percentage for Percent Expense Rate Tables or Fixed Amount for Amount and Graduated Amount Expense Rate Tables.   
Currency_Reference  CurrencyObject  [0..1]  Reference to an existing Currency. Sets the currency of graduated expense rate.   
Validation Description
Currency is not used in Expense Rate Table with table type of Graduated Percent.  Currency is not used in Expense Rate Table with table type of Graduated Percent. 
Maximum Value is not used in Expense Rate Table with table type of Amount.  Maximum Value is not used in Expense Rate Table with table type of Amount. 
Minimum Value is not used in Expense Rate Table with table type of Amount.  Minimum Value is not used in Expense Rate Table with table type of Amount. 
Average Value is used in Expense Rate Table with table type of Maximum.  Average Value is used in Expense Rate Table with table type of Maximum. 
Expense Rate is not used in Expense Rate Table with table type of Maximum.  Expense Rate is not used in Expense Rate Table with table type of Maximum. 
Maximum Value is required for Expense Rate Table with table type Maximum or Graduated Amount  Maximum Value is required for Expense Rate Table with table type Maximum or Graduated Amount 
Expense Rate is required for Expense Rate Table with table type Amount, Graduated Amount, or Graduated Percent  Expense Rate is required for Expense Rate Table with table type Amount, Graduated Amount, or Graduated Percent 
A Start of Range can only be used once for an Expense Rate Table line.  A Start of Range can only be used once for an Expense Rate Table line. 
An End of Range can only be used once for an Expense Rate Table line.  An End of Range can only be used once for an Expense Rate Table line. 
End of Range must be greater than the Start of Range.  End of Range must be greater than the Start of Range. 
The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next must be 0.1 when any of the End of Range values is a decimal.  The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next must be 0.1 when any of the End of Range values is a decimal. 
The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next line must be 1.  The Start of Range and End of Range cannot overlap or have gaps between Expense Rate Table lines. The gap between the End of Range on one line and the Start of Range on the next line must be 1. 
top
 

Web_Service_Background_Process_RuntimeObject

part of: Put_Import_Process_Response
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Web_Service_Background_Process_RuntimeObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Web_Service_Background_Process_RuntimeObjectID

part of: Web_Service_Background_Process_RuntimeObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Background_Process_Instance_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

InstanceObject

part of: Put_Import_Process_Response
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]     
ID  Instance_ID  [0..*]     
top
 

Instance_ID

part of: InstanceObject
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@parent_id  string  [1..1]     
@parent_type  string  [1..1]     
@type  string  [1..1]     
top
 

Expense_Rate_TableReferenceEnumeration

part of: Expense_Rate_TableObjectID
Base Type
string
top
 

Expense_Rate_Table_TypeReferenceEnumeration

part of: Expense_Rate_Table_TypeObjectID
Base Type
string
top
 

CurrencyReferenceEnumeration

part of: CurrencyObjectID
Base Type
string
top
 

Expense_Item_Attribute_TypeReferenceEnumeration

part of: Expense_Item_Attribute_TypeObjectID
Base Type
string
top
 

Condition_RuleReferenceEnumeration

part of: Condition_RuleObjectID
Base Type
string
top
 

Behavior_Spend_DataReferenceEnumeration

part of: Behavior_Spend_DataObjectID
Base Type
string
top
 

Web_Service_Background_Process_RuntimeReferenceEnumeration

part of: Web_Service_Background_Process_RuntimeObjectID
Base Type
string
top