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 Oracle PeopleSoft ERP 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 |
|---|---|
| UserID | Account |
| ROLENAME | Group |
Default Account Attributes
The Oracle PeopleSoft ERP 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 PeopleSoft User ID. This is an Account ID which must not be changed. |
| AccountLocked | Status of Account if it is locked or not. |
| AllowSwitchUser | Indicates if the individual user is permitted to change identities within a PeopleSoft session |
| AlternateUserID | User ID Alias. |
| CurrencyCode | Currency code of the user. |
| DefaultMobilePage | Default mobile page. |
| EffectiveDateFrom | Workflow attribute - from date. |
| EffectiveDateTo | Workflow attribute - to date. |
| EmailAddresses | Email address of the user. |
| EmailUser | Routing preferences - email user. It is a multivalued attribute. |
| ExpertEntry | Enable expert entry. |
| FailedLogins | Number of failed logins. |
| IDTypes | User ID types and values. |
| LanguageCode | Language code. |
| LastUpdateDateTime | Last update date and time. |
| LastUpdateUserID | Last update user ID. |
| MultiLanguageEnabled | Enabled if user has multiple languages. |
| NavigatorHomePermissionList | Default navigator home page permission list. |
| Opertype | Use external authentication. |
| PasswordExpired | Is password expired. |
| PrimaryEmailAddress | Primary email address. |
| PrimaryPermissionList | Primary permission list. |
| ProcessProfilePermissionList | Process profile permission list. |
| roleNames | Roles and Roles along with Route Controls assigned to the user profile. |
| RowSecurityPermissionList | Row security permission list. |
| SymbolicID | Used to map the User ID to Access ID. |
| UserDescription | Description of the user. |
| Roles | Roles and Roles along with Route Controls assigned to the user - detailed. |
| Encrypted | Encrypted status of the account. |
| ReassignWork | Reassign work to alternate user. |
| ReassignUserID | Reassigned user's UserID. |
| RowSecurityPermissionList | Row Security Permissions. |
| SupervisingUserID | Supervisor's User ID. |
| UserIDAlias | Alias of the user. |
| WorkListEntriesCount | Count of worklist entries. |
| WorklistUser | Displays user workflow. |
Default Entitlement Attributes
Default Group Attributes
The Oracle PeopleSoft ERP connector also supports groups. The following attributes must be configured on the managed system and in the SailPoint source schema to manage groups.
| Attribute Name | Description |
|---|---|
| ALLOWNOTIFY | Workflow routing - allow notifications. |
| ALLOWLOOKUP | Workflow routing - allow recipient lookup. |
| DESCR | Description of the role. |
| DESCRLONG | Long description. |
| LASTUPDDTTM | Last update date/time. |
| LASTUPDOPERID | Last update user ID. |
| RolePermissionLists | Permission List for the role. |
| ROLENAME | Name of the role. This is an Account ID which must not be changed. |
| ROLETYPE | Type of the role. |
| RouteControl | Route Control name. |
| RouteControlDescription | Route Control description. |
| Roles that can be granted | Roles that can be granted by this role. |
| Roles that can grant | Roles that can grant this role. |
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.