Mapping of 300 Employee Import to V4 UPS APIs

Import # Import Field Name API Field Name Extension
1 Transaction Type = 300    
2 First Name givenName core:2.0:User
3 Middle Name middleName core:2.0:User
4 Last Name familyName core:2.0:User
5 Employee ID employeeNumber enterprise:2.0:User
6 Login ID userName core:2.0:User
7 Password NOT SUPPORTED NOT SUPPORTED
8 Email Address email core:2.0:User
9 Locale Code locale spend:2.0:User
10 Country Code country spend:2.0:User
11 Country Sub Code stateProvince spend:2.0:User
12 Ledger Code ledgerCode spend:2.0:User
13 Reimbursement Currency Code reimbursementCurrency spend:2.0:User
14 Cash Advance Account Code cashAdvanceAccountCode spend:2.0:User
15 Active active core:2.0:User
16 Organizational Unit 1 customData
<id:orgUnit1 / value:orgUnit1Value>
spend:2.0:User
17 Organizational Unit 2 customData
<id:orgUnit2 / value:orgUnit2Value>
spend:2.0:User
18 Organizational Unit 3 customData
<id:orgUnit3 / value:orgUnit3Value>
spend:2.0:User
19 Organizational Unit 4 customData
<id:orgUnit4 / value:orgUnit4Value>
spend:2.0:User
20 Organizational Unit 5 customData
<id:orgUnit5 / value:orgUnit5Value>
spend:2.0:User
21 Organizational Unit 6 customData
<id:orgUnit6 / value:orgUnit6Value>
spend:2.0:User
22 Custom 1 customData
<id:custom1 / value:custom1Value>
spend:2.0:User
23 Custom 2 customData
<id:custom2 / value:custom2Value>
spend:2.0:User
24 Custom 3 customData
<id:custom3 / value:custom3Value>
spend:2.0:User
25 Custom 4 customData
<id:custom4 / value:custom4Value>
spend:2.0:User
26 Custom 5 customData
<id:custom5 / value:custom5Value>
spend:2.0:User
27 Custom 6 customData
<id:custom6 / value:custom6Value>
spend:2.0:User
28 Custom 7 customData
<id:custom7 / value:custom7Value>
spend:2.0:User
29 Custom 8 customData
<id:custom8 / value:custom8Value>
spend:2.0:User
30 Custom 9 customData
<id:custom9 / value:custom9Value>
spend:2.0:User
31 Custom 10 customData
<id:custom10 / value:custom10Value>
spend:2.0:User
32 Custom 11 customData
<id:custom11 / value:custom11Value>
spend:2.0:User
33 Custom 12 customData
<id:custom12 / value:custom12Value>
spend:2.0:User
34 Custom 13 customData
<id:custom13 / value:custom13Value>
spend:2.0:User
35 Custom 14 customData
<id:custom14 / value:custom14Value>
spend:2.0:User
36 Custom 15 customData
<id:custom15 / value:custom15Value>
spend:2.0:User
37 Custom 16 customData
<id:custom16 / value:custom16Value>
spend:2.0:User
38 Custom 17 customData
<id:custom17 / value:custom17Value>
spend:2.0:User
39 Custom 18 customData
<id:custom18 / value:custom18Value>
spend:2.0:User
40 Custom 19 customData
<id:custom19 / value:custom19Value>
spend:2.0:User
41 Custom 20 customData
<id:custom20 / value:custom20Value>
spend:2.0:User
42 Custom 21 customData
<id:custom21 / value:custom20Value>
spend:2.0:User
43 Send email when the cash advance status changes emailStatusChangeOnCashAdvance spend:2.0:WorkflowPreference
44 Send email when a cash advance is awaiting emailAwaitApprovalOnCashAdvance spend:2.0:WorkflowPreference
45 Send email when the report status changes emailStatusChangeOnReport spend:2.0:WorkflowPreference
46 Send email when a report is awaiting approval emailAwaitApprovalOnReport spend:2.0:WorkflowPreference
47 Prompt for approver when submitting a report promptForApproverOnReportSubmit spend:2.0:WorkflowPreference
48 Send email when the request status changes emailStatusChangeOnTravelRequest spend:2.0:WorkflowPreference
49 Send email when a request is awaiting approval emailAwaitApprovalOnTravelRequest spend:2.0:WorkflowPreference
50 Prompt for approver when submitting a request promptForApproverOnTravelRequestSubmit spend:2.0:WorkflowPreference
51 Send email when the payment status changes emailStatusChangeOnPayment spend:2.0:WorkflowPreference
52 Send email when a payment is awaiting approval emailAwaitApprovalOnPayment spend:2.0:WorkflowPreference
53 Prompt for approver when submitting a payment promptForApproverOnPaymentSubmit spend:2.0:WorkflowPreference
54 Prompt to add company card transactions to report promptForCardTransactionsOnReport spend:2.0:UserPreference
55 Send email when new company card transactions arrive allowCreditCardTransArrivalEmails spend:2.0:UserPreference
56 Send email when faxed receipts received defaultReportPrintFormat
Allowed Values: FAX/DETAILED/RECEIPTS
spend:2.0:UserPreference
57 Display instructional help on the application pages showInstructHelpPanel spend:2.0:UserPreference
58 Display imaging introduction page showImagingIntro spend:2.0:UserPreference
59 Employee ID of the expense report approver approver.employeeNumber
“Approver Type: report, Primary: true”
spend:2.0:Approver 
60 Employee ID of the cash advance approver approver.employeeNumber
“Approver Type: cashAdvance, Primary: true”
spend:2.0:Approver 
61 Employee ID of the request approver approver.employeeNumber
“Approver Type: request, Primary: true”
spend:2.0:Approver 
62 Employee ID of the Invoice approver approver.employeeNumber
“Approver Type: invoice, Primary: true”
spend:2.0:Approver 
63 Expense User entitlements
Value: “Expense”
core:2.0:User
64 Approver roles
“Role Name: EXP_APPROVER”
spend:2.0:Role 
65 Company Card Administrator roles
“Role Name: EXP_CARD_ADMIN”
spend:2.0:Role
66 Integration Administrator (now known as Import/Extract Administrator) roles
“Role Name: SHD_IMPORT_EXTRACT_ADMIN”
spend:2.0:Role
67 Receipt Processor roles “Role Name: EXP_RECEIPT_PROCESSOR” spend:2.0:Role
68 Authorization Request Approver roles
“Role Name: EXP_AUTH_REQUEST_APPROVER”
spend:2.0:Role
69 Integration Administrator (Restricted) (now known as Import/Extract Monitor) roles
“Role Name: SHD_IMPORT_EXTRACT_ADMIN_RO”
spend:2.0:Role
70 Company Info Administrator roles
“Role Name: SHD_COMPANY_INFO_ADMIN”
spend:2.0:Role
71 Offline User NOT SUPPORTED NOT SUPPORTED
72 Reporting Configuration administrator roles
“Role Name: REPORTING_CONFIG_ADMIN”
spend:2.0:Role
73 Invoice User entitlements
“Value: Invoice”
core:2.0:User
74 Invoice Approver roles
“Role Name: INV_APPROVER”
spend:2.0:Role
75 Invoice Vendor Manager roles
“Role Name: INV_VENDOR_ADMIN”
spend:2.0:Role
76 Expense Audit Required expenseAuditRequired
“Allowed Values: ALWAYS/NEVER/REQUIRED”
spend:2.0:UserPreference
77 BI Manager Employee ID biManager.employeeNumber(TBD) spend:2.0:User
78 Request User entitlements
“Value: Request”
core:2.0:User
79 Request Manager roles
“Role Name: REQ_APPROVER”
spend:2.0:Role
80 Expense Report Approver Employee ID 2 approver.employeeNumber
“Approver Type: report, Primary: false”
spend:2.0:Approver
81 A Payment Request has been Assigned emailStatusChangeOnPayment spend:2.0:WorkflowPreference
82 Future Use 18 - 19 NOT SUPPORTED NOT SUPPORTED
83 Future Use 18 - 19 NOT SUPPORTED NOT SUPPORTED
84 Tax Administrator roles
“Role Name: SHD_TAX_ADMIN”
spend:2.0:Role
85 FBT Administrator roles
“Role Name: EXP_FB_TAX_ADMIN”
spend:2.0:Role
86 Travel Wizard User roles
“Role Name: TRAVEL_USER”
spend:2.0:Role

On this page