UsersV4
Read the user's core identity profile.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that refer to Id, UserName, and ExternalId. The add-in processes other filters client-side within the add-in.
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 add-in 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 |