Schema Reference
The application schema is used to configure the objects returned from a connector.
Note
-
The Account Schema tab is used to define the attributes for each object type in the application being configured. The schema attributes can be defined as Entitlement or Multi-Valued. Refer to Managing Source Account Schemas for more information.
-
The schema attributes that are not present by default must be defined as strings if not specified.
The Workday connector uses the following default correlation and object configurations.
Default Correlation Configuration
The source uses the following mapping correlation by default:
| Identity Attribute | Operation | Account Attribute |
|---|---|---|
| SailPoint User Name (uid) | Equals | FILENUMBER |
| SailPoint User Name (uid) | Equals | USERID |
| Work Email | Equals | EMAIL_ADDRESS_WORK |
| Employee Number | Equals | USERID |
Default Account Schema
Each source supports a variety of details, or attributes, about each user who has an account, such as their name, email address, manager name, and location.
The set of account attributes each source stores and how they're organized is known as the account's schema. To best represent your data, you can configure sources to use an account schema matching the one you use in the external connector. Refer to Managing Source Account Schemas for more information.
Default Account ID
SailPoint requires that certain attributes remain in your configuration. These attributes are referred to as account IDs.
Caution
Changing the attribute marked as the account ID after aggregating accounts can result in duplicate accounts being created. To avoid this, either reset the accounts on this source before editing the account ID attribute or edit the account ID attribute before aggregating accounts.
To resolve issues caused by changing account IDs, reconfigure them to their default values.
The following table lists the default account IDs for this connector:
| Account ID | Schema Object Type |
|---|---|
| FILENUMBER | Account |
Default Account Attributes
The Workday connector supports the following default account schema attributes and customer configurable attributes. The attributes must be defined as strings if not specified.
| Attribute Name | Description |
|---|---|
| USERID | The Worker ID associated with the worker. |
| FILENUMBER | The user's unique ID. This is an Account ID which must not be changed. |
| MANAGER_ID | The worker's manager's Employee ID. |
| JOBTITLE | The worker's business title. |
| JOBCODE | The worker's job profile. |
| POSITION | The worker's position. |
| EMPLOYEE_TYPE | The user's classification type within the organization. |
| FIRST_NAME | The worker's legal first name. |
| LAST_NAME | The worker's legal last name. |
| MIDDLE_NAME | The worker's preferred middle name. |
| LEGAL_MIDDLE_NAME | The worker's legal middle name. |
| WORKER_NAME | The worker's name. |
| CLASS | A concatenation of the worker's position, time type, and employment type. |
| DEPARTMENT | The worker's cost center. |
| COST_CENTER | The cost center's name in the worker's organization data. |
| COST_CENTER_HIERARCHY | The worker's cost center hierarchy. |
| COST_CENTER_REFERENCE_ID | The cost center's reference ID in the worker's organization data. |
| COMPANY_NAME | The company to which the worker belongs. |
| ORGANIZATION_NAME | The worker's business unit's name. |
| DIVISION | The sales channel in the worker's organization data. |
| TEAM | The team in the worker's organization data. |
| LOCATION | The worker's business site. |
| HIREDATE | The worker's hire date. |
| TERMINATION_DATE | The date the worker was terminated. |
| LAST_DAY_OF_WORK | The worker's last working day. |
| CONTRACT_END_DATE | The worker's contract end date. |
| FULLPARTTIME | Indicates whether the worker is full time or part time. |
| ON_LEAVE | Indicates if the worker is on leave. |
| FUTURE_DATE | Represents the worker's next future milestone date. For example, future date of hire, termination date, onboarding date, or end of their contingent worker contract. |
| FUTURE_ACTION | Represents the worker's next future action. For example, Hire, Terminate, Onboarding, or End Contingent Worker Contract (Hire Employee). |
| POSTAL_CODE | The worker's business site's postal code. |
| COUNTRY | The worker's business site's country. |
| CITY | The worker's business site's city. |
| STATE | The worker's business site's state. |
| ADDRESS_LINE_1 | The worker's business site's street address. |
| ADDRESS_HOME | The worker's home address. |
| ADDRESS_WORK | The worker's work address. |
| EMAIL_ADDRESS_HOME | The worker's home email address. |
| EMAIL_ADDRESS_WORK | The worker's email address. |
| ADDITIONAL_EMAIL_ADDRESS_HOME | The worker's additional home email address. |
| ADDITIONAL_EMAIL_ADDRESS_WORK | The worker's additional work email address. |
| WORK_MOBILE | The worker's work mobile number. |
| WORK_TELEPHONE | The worker's work telephone number. |
| HOME_MOBILE | The worker's home mobile number. |
| HOME_TELEPHONE | The worker's home telephone number. |
Note
For more information on Rescinded/Corrected Event for Hired and Terminated Workers, refer to Rescinded and Corrected User Records. The Workday connector can aggregate fields in addition to the fields present in the default account schema - for more information, refer to XPath to Support Additional Standard Attributes in Schema.
Optional Attributes
If you require the image attribute to be a String attribute type, add the following attributes:
| Attributes | Description | Source Data Element WD Object /Field Web Service Element File field |
|---|---|---|
| IMAGE_NAME (type as String) | Image file name | Worker_Data/Photo_Data/File name |
| IMAGE (type as String) | Image value as string | Worker_Data/Photo_Data/Image |
Note
Adding the image attribute to the schema may increase the time taken to fetch a response from the Workday source. To aggregate image details, set the Include_Photo parameter to true within the Configure_Response_Group configuration.
Additional Schema Attributes for Pre-Hire Functionality
Note
These attributes are available out of the box for new sources. For existing sources, additional schema attributes need to be added manually in order to use the Pre-Hire functionality.
| Schema Attribute | Description |
|---|---|
| PRE_HIRE_ID | Pre Hire ID for the person. |
| DATE_PRE_HIRE_ADDED_TO_SYSTEM | The date when pre-hire is added in Workday. |
| ELIGIBLE_FOR_HIRE | Specify whether Prehire is eligible for hire or not. |
| REFFERED_BY | Pre-Hires is referred by. |
| SOURCE | Pre-Hire Source. |
| COMMENT | The COMMENT added for the PreHire. |
Documentation Feedback
Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.