UsersV4
Read the user's core identity profile.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process filters that refer to Id, UserName, and ExternalId. The connector processes other filters client-side within the connector.
Use the filters to retrieve data only for the authenticated user since SAP Concur requires Company Level Authentication for retrieving data for all users.
For example, the connector will offload the processing of the following queries to the SAP Concur APIs:
SELECT * FROM UsersV4 WHERE UserName = '[email protected]' SELECT * FROM UsersV4 WHERE ExternalId = '1234_externalId' SELECT * FROM UsersV4 WHERE Id = '802546f7-52a4-4ce7-6380-d5a869af350f'Use the Id value returned from these queries when working with tables that require a UserId.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier for the user, also known as the UUID. |
| Active | Boolean | False |
If true, the user is active. |
| UserName | String | False |
The name that can be used to login to Concur Travel and Expense. |
| DisplayName | String | False |
The name of the user, suitable for public display. |
| GivenName | String | False |
The given or first name of the user. |
| MiddleName | String | False |
The middle name(s) of the user, if applicable. |
| FamilyName | String | False |
The family or last name of the user. |
| FormattedName | String | False |
The full name of the user, formatted for display. |
| NickName | String | False |
The casual way to address the user. |
| AddressesAggregate | String | False |
JSON aggregate of a physical mailing address for this user. |
| DateOfBirth | Date | False |
The user's date of birth. |
| EmailsAggregate | String | False |
JSON aggregate of the user's email addresses. |
| EmergencyContactsAggregate | String | False |
JSON aggregate of emergency contact information for the user. |
| Entitlements | String | False |
The features enabled for the user. Supported values: Expense, Invoice, Locate, Request, Travel. |
| ExternalId | String | False |
User identifier from the provisioning client. |
| Created | Datetime | False |
The datetime the user was created. |
| LastModified | Datetime | False |
The datetime the user was last modified. |
| PhoneNumbersAggregate | String | False |
JSON aggregate of the user's phone numbers. |
| Timezone | String | False |
The user's time zone in the Olson time zone database format. |
| Title | String | False |
The user's job title in the company. |
| CompanyId | String | False |
The SAP Concur ID of the company. |
| EmployeeNumber | String | False |
Client supplied employee number within the company, unique for the company. |
| UserStartDate | Datetime | False |
The user's start date. |
| UserTerminationDate | Datetime | False |
The user's termination date. |
| CostCenter | String | False |
The employee cost center for product. |
| PreferredLanguage | String | False |
Indicates the user's preferred written or spoken language. |
| PreferenceEndDayViewHour | String | False |
Preferred hour setting for the end of day. |
| PreferenceFirstDayOfWeek | String | False |
Preferred first day of the week for the user. |
| PreferenceDateFormat | String | False |
Preferred date format for the user. |
| PreferenceCurrencySymbolLocation | String | False |
Preferred currency symbol location for the user. Supported values: BeforeAmount, AfterAmount. |
| PreferenceHourMinuteSeparator | String | False |
Preferred separator between hour and minute. |
| PreferenceDistance | String | False |
Preferred distance metric. Supported values: mile, km. |
| PreferenceDefaultCalView | String | False |
Preferred default calendar view for the user. Supported values: day, week, month. |
| Preference24Hour | String | False |
Preferred 24 hour format for the user. |
| PreferenceNumberFormat | String | False |
Preferred number format for the user. |
| PreferenceStartDayViewHour | String | False |
Preferred start of day for the user, from 1. |
| PreferenceNegativeCurrencyFormat | String | False |
Preferred negative currency format for the user. |
| PreferenceNegativeNumberFormat | String | False |
Preferred negative number format for the user. |
| SchemasAggregate | String | False |