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 | 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 |