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 Accounts connector uses the following default correlation and object configurations.
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 |
| ID | Group |
Default Account Attributes
The Workday Accounts 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 Workday account user name. |
| FILENUMBER | The unique ID for Employee, Contractor, Service Center Representative, Extended Enterprise Learner, Implementer, Integration and Students System accounts. This identifier can be an alphanumeric value based on the value present in the Workday system. When aggregating service center representative accounts, implementers and integration system accounts, the WID is populated in the FILENUMBER attribute.This is an Account ID which must not be changed. |
| ACCOUNT_DISABLED | Indicates whether the Workday account is disabled. |
| REQUIRE_NEW_PASSWORD_AT_NEXT_SIGN_IN | Indicates whether the Workday account will require a new password at next sign in. |
| SESSION_TIMEOUT_MINUTES | The number of minutes the user may be idle. |
| MULTI_FACTOR_AUTHENTICATION_EXEMPT | Indicates if the user is exempt from multi-factor authentication. |
| MULTI_FACTOR_AUTHENTICATION_GRACE_PERIOD_ENABLED | Indicates if the user's multi-factor grace period is enabled. |
| GRACE_PERIOD_LOGINS_REMAINING | The remaining number of times the user can login without providing a multi-factor authentication passcode. |
| ACCOUNT_EXPIRATION_DATE | Prevents the user from signing on to the system after this date. |
| OPENID_IDENTIFIER | The email address associated with the Open ID account. |
| OPENID_INTERNAL_IDENTIFIER | Open ID GUID. |
| OPENID_CONNECT_INTERNAL_IDENTIFIER | OpenID Connect subject. |
| EXEMPT_FROM_DELEGATED_AUTHENTICATION | Indicates if the user is exempt from delegated authentication. |
| WORKER_TYPE | Workers type (Employee|Contingent_Worker|Service Center Representative|Extended Enterprise Learner|Implementer Account|Integration System User|Applicant Student|Prospect Student|Pre-Matriculant Student|Matriculant Student) |
| USER_BASED_SECURITY_GROUPS | Enables aggregation of user-based security groups of the account. |
| SECURITY_GROUPS | Fetches all the security groups of the account except user-based security groups. |
| INTEGRATION_SYSTEM_ID | Fetches Integration System ID associated with Integration system account. |
Default Entitlement Attributes
Entitlement attributes define the entitlements, such as groups or roles, that can be assigned to the managed system's user accounts. Refer to Managing Entitlements for more information.
Caution
Changing the attribute marked as the Entitlement ID after aggregating accounts or entitlements can result in duplicate entitlements being created, or access profiles and roles breaking. To avoid this, edit the entitlement schema before performing any aggregations.
Default Group Attributes
The Workday Accounts connector also supports groups. The following attributes must be configured on the managed system and in the SailPoint source schema to manage groups.
The following table lists the group attributes for user-based Security Groups:
| Attributes | Description | Path |
|---|---|---|
| ID | The internal ID for this group. This is an Account ID which must not be changed. | The path is automatically assigned. |
| COMMENT | The description for this group. | The path is automatically assigned. |
| DESCRIPTOR | The name for this group. | The path is automatically assigned. |
Note
The COMMENT and DESCRIPTOR attributes are only supported for the OAuth 2.0 Authentication Type.
By default, "ID" is marked as displayAttribute and descriptionAttribute. To update it, use update-source | SailPoint Developer Community. The following is an example of API body content:
The following table lists the group attributes for SECURITY_GROUPS:
| Attributes | Description | Path |
|---|---|---|
| ID | The internal ID for the groups. | The path is automatically assigned. |
| TYPE | The type for this group. | The path is automatically assigned. |
| NAME | The name for this group. | The path is automatically assigned. |
Note
The SECURITY_GROUPS group attributes are only supported for the OAuth 2.0 Authentication Type.
Group Object: OrganizationRole
By default, the OrganizationRole group object is not part of the out-of-the-box schema. Use the createSchema API to create a new group schema for your source.
Note
Refer to Best Practices: REST API Authentication and REST API - Update Source (Partial) in the SailPoint Developer Community for more information on SailPoint's REST APIs.
Refer to OAuth 2.0 Authentication for more information on the additional permissions required for aggregating the OrganizationRole group object.
The following table lists the attributes of the OrganizationRole group object:
| Attributes | Description | Path |
|---|---|---|
| ORG_ROLE##ORG_NAME | Associates an organization role reference ID with an organization name reference ID. | The path is automatically assigned. |
| ROLE_NAME | Organization role name. | The path is automatically assigned. |
| ASSOCIATED_SECURITY_GROUP | Associated role-based security group. | The path is automatically assigned. |
| ORGANIZATION_NAME | Name of the organization. | The path is automatically assigned. |
To aggregate custom fields defined for the OrganizationRole group object, refer to Configuring Custom Attributes for the OrganizationRole Group.
Note
The new group object is only supported for the OAuth 2.0 Authentication Type.
Configuring Custom Attributes for the OrganizationRole Group
This section describes the procedure for fetching custom attributes from Workday.
The Workday Accounts supports aggregating custom fields defined for the OrganizationRole group object.
Configure an Integration System in Workday
Perform the following steps to configure the Workday Integration System:
- Search for Create Integration Field Override Service in Workday, and create a new Integration Field Override Service.
- Assign a name to the Integration Field Override Service and select the business object as Organizations.
-
Add the fields, as per your requirement, and provide a name for each field:
- Select the Plus icon to add a new row, and then select OK.
- Choose a name that will match the schema attribute.
- Define the required settings for the new fields.
- Select Done.
- Repeat these steps for each new field.
-
Create a new Workday Integration System as follows:
- On your Workday Home page, go to Integration System > Create Integration System.
- Provide a name for the Integration System.
- Select New Using Template and provide the value as Document Transformation.
- Select OK.
- Go to Actions > Integration System > Configure Integration Attachment Service.
- Select the Attachment column and select Create Integration Attachment Service.
- Attach an empty text file and select OK.
-
In your new Workday Integration System, add the field override service created in the previous steps, as follows:
- Go to Custom Integration Services.
- Select the Plus icon. Under Custom Integration Services, add the field override service you created.
- Select OK.
-
Note the System ID for this Workday Integration System. It is required to retrieve the custom or calculated attributes.
- Search for View Integration System.
- Enter the name of the Workday Integration System you created.
- Select OK.
-
Map the new fields to the correct value:
- Go to Integration System > Configure Integration Field Overrides.
- Select the calculated or custom field and map the correct value to it in Override External Field.
- Select OK.
- Select Done.
-
When applicable, grant the required permissions to the service account associated with the source to aggregate the new custom or calculated fields.
Note
- Custom and calculated attributes added to the Workday OrganizationRole Group schema must have
__cappended to the field names created in Workday. For example, if you addedPREVIOUS_EMPLOYERto Workday, you would addPREVIOUS_EMPLOYER__cin the source schema. - Aggregation takes more time for a larger number of configured custom attributes and calculated fields. The value of the calculated fields and custom attributes are calculated at run time, and aggregation is delayed, as it requires extra time to fetch the calculated values.
Organization Roles
The Workday Accounts aggregates and provisions an organization role with the organization name.
You must add a new schema attribute ORG_ROLE##ORG_NAME in the account schema. The ORG_ROLE##ORG_NAME is a multi-valued entitlement attribute of type OrganizationRole. The ORG_NAME value is used as the organization reference ID while assigning a role to a worker.
Assigning an Organization Other Than the Default Organization
If you want to assign an organization other than the default organization, configure the Organization_Reference_ID_Item attribute in the provisioning policy. This is the reference ID of the organization.
For example, if the value of the ORG_ROLE##ORG_NAME attribute is Admin##Test_Organization and you want to assign the Admin role to a different organization than Test_Organization, you must use the Organization_Reference_ID_Item attribute in the provisioning policy and pass the required organization reference ID.
Excluding Inherited Roles During Aggregation
The Workday Accounts supports aggregation and provisioning of Organization Roles assigned to the user in Workday. These roles are assigned to the user's parent/direct organization, as well as the underlying inherited organization. By default, the Workday Accounts aggregates both the direct and underlying inherited roles assigned to the users.
If you want to exclude the inherited roles during account aggregation, then on the Additional Settings configuration page, select the Exclude Inherited Organization Roles checkbox.
Aggregating Security Groups
The Workday Account source supports the aggregation of the security group as a group object.
The new security group schema containing the ID attribute is introduced to aggregate the security group. The object type is SecurityGroup.
For the new Workday Accounts sources, the schema will be populated by default with the ID as an attribute. The aggregation will fetch all user-based security groups present on the Workday Accounts managed system.
For the existing Workday Accounts sources, you must add the USER_BASED_SECURITY_GROUPS attribute to the schema to fetch the groups through entitlement aggregation.
You must add and mark the USER_BASED_SECURITY_GROUPS attribute as a managed, multi-valued attribute, and as an entitlement. Additionally, the group schema must be defined.
Aggregating and Provisioning User-Based Security Groups
The Workday Accounts source supports the aggregation and provisioning of user-based Security Groups.
USER_BASED_SECURITY_GROUPS is the new schema attribute:
- XPath:
ns1:Get_Assign_User-Based_Security_Groups_Response/ns1:Response_Data/ns1:Assign_User-Based_Security_Groups
For new Workday Accounts sources, by default, the account schema will have the USER_BASED_SECURITY_GROUPS attribute. Account aggregation fetches all user-based security groups linked to workers.
For existing Workday Accounts sources, you must add the USER_BASED_SECURITY_GROUPS attribute to the schema with values as a managed, multi-valued attribute, and as an entitlement.
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.