This connector supports only Provisioning.
The functionalities of this connector enable exporting, adding and modifying Employees in an Oracle HCM system. It does not support deleting employees in Oracle HCM system. The connector also supports exporting job families, jobs, locations, positions and organizations.
Functionalities
Provisioning Integration
Data Format |
Export |
Create |
Modify |
Delete |
Trigger |
---|---|---|---|---|---|
Employee |
Yes |
Yes |
Yes |
No |
No |
JobFamily |
Yes |
No |
No |
No |
No |
Job |
Yes |
No |
No |
No |
No |
Location |
Yes |
No |
No |
No |
No |
Position |
Yes |
No |
No |
No |
No |
Organization |
Yes |
No |
No |
No |
No |
HR Combined | Yes | No | No | No | No |
Worker | Yes | Yes | Yes | No | No |
Prerequisites
Ensure that these prerequisites are satisfied:
Oracle HCM is installed, configured, and running.
An administrator account that can be used to establish a connection and has authority to manage Employees on the connected system.
The following REST end points are used in a Oracle HCM connector and therefore the Administrator account should have the required permissions in Oracle HCM to execute these operations:
Resources |
End Point |
Method |
Purpose |
Employees |
/hcmRestApi/resources/<Version>/emps |
Get |
Get Employees |
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID> |
Get |
Get an Employee |
|
/hcmRestApi/resources/<Version>/emps |
Post |
Create an Employee |
|
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID> |
Patch |
Update an Employee |
|
Assignments |
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID>/child/assignments |
Post |
Create an Employee Assignment |
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID>/child/assignments/<AssignmentUID> |
Patch |
Update an Employee Assignment |
|
Roles |
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID>/child/roles |
Get |
Get Employee Roles |
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID>/child/roles/<RoleGUID |
Get |
Get an Employee Roles |
|
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID>/child/roles |
Post |
Create an Employee role |
|
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID>/child/roles/<RoleGUID> |
Patch |
Update an employee role |
|
/hcmRestApi/resources/<Version>/emps/ <EmployeeUID>/child/roles/<RoleGUID> |
Delete |
Delete an employee role |
|
Job Families |
/hcmRestApi/resources/<Version>/jobFamilies |
Get |
Get Job Families |
/hcmRestApi/resources/<Version>/jobFamilies/ <JobFamilyUID> |
Get |
Get a Job Family |
|
Jobs |
/hcmRestApi/resources/<Version>/jobs |
Get |
Get Jobs |
/hcmRestApi/resources/<Version>/jobs/<JobUID> |
Get |
Get a Job |
|
Locations |
/hcmRestApi/resources/<Version>/locations |
Get |
Get Locations |
/hcmRestApi/resources/<Version>/locations/ <LocationUID> |
Get |
Get a Location |
|
Organizations |
/hcmRestApi/resources/<Version>/organizations |
Get |
Get Organizations |
/hcmRestApi/resources/<Version>/organizations/ <OrganizationUID> |
Get |
Get an Organization |
|
Positions |
/hcmRestApi/resources/<Version>/positions |
Get |
Get Positions |
/hcmRestApi/resources/<Version>/positions/ <PositionUID> |
Get |
Get a Position |
|
Workers | /hcmRestApi/resources/<Version>/workers |
Get | Get Workers |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID> |
Get a Worker | ||
/hcmRestApi/resources/<Version>/workers | Post | Create a Worker | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID> |
Patch | Update a Worker | |
Worker Address |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/addresses |
Get | Get Worker Addresses |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/addresses/<AddressUID> |
Get | Get a Worker Address | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/addresses |
Post | Create a Worker Address | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/addresses/<AddressUID> |
Patch | Update a Worker Address | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/addresses/<AddressUID> |
Delete | Delete a Worker Address | |
Worker Email |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/emails |
Get | Get Worker Emails |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/emails/<EmailUID> |
Get | Get a Worker Email | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/emails |
Post | Create a Worker Email | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/emails/<EmailUID> |
Patch | Update a Worker Email | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/emails/<EmailUID> |
Delete | Delete a Worker Email | |
Worker ExternalIdentifier |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/externalIdentifiers |
Get | Get Worker External Identifier |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/externalIdentifiers/<ExternalIdentifierUID> |
Get | Get a Worker External Identifier | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/externalIdentifiers |
Post | Create a Worker External Identifier | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/externalIdentifiers/<ExternalIdentifierUID> |
Patch | Update a Worker External Identifier | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/externalIdentifiers/<ExternalIdentifierUID> |
Delete | Delete a Worker External Identifier | |
Worker LegislativeInfo |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/legislativeInfo |
Get | Get Worker Legislative Informations |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/legislativeInfo/<LegislativeInfoUID> |
Get | Get a Worker Legislative Information | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/legislativeInfo |
Post | Create a Worker Legislative Information | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/legislativeInfo/<LegislativeInfoUID> |
Patch | Update a Worker Legislative Information | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/legislativeInfo/<LegislativeInfoUID> |
Delete | Delete a Worker Legislative Information | |
Worker Name |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/names |
Get | Get Worker Emails |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/names/<NameUID> |
Get | Get a Worker Names | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/names |
Post | Create a Worker Name | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/names/<NameUID> |
Patch | Update a Worker Name | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/names/<NameUID> |
Delete | Delete a Worker Name | |
Worker Phone |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/phones |
Get | Get Worker Phones |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/phones/<PhoneUID> |
Get | Get a Worker Phone | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/phones |
Post | Create a Worker Phone | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/phones/<PhoneUID> |
Patch | Update a Worker Phone | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/phones/<PhoneUID> |
Delete | Delete a Worker Phone | |
Worker WorkRelationship |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/workRelationships |
Get | Get Worker Work Relationships |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/workRelationships/<WorkRelationshipUID> |
Get | Get a Worker Work Relationship | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/workRelationships |
Post | Create a Worker Work Relationship | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/workRelationships/<WorkRelationshipUID> |
Patch | Update a Worker Work Relationship | |
/hcmRestApi/resources/<Version>/workers/ <WorkerUID>/child/workRelationships/<WorkRelationshipUID> |
Delete | Delete a Worker Work Relationship |
If the Administrator account does not have any of the above permissions in Oracle HCM, the following error is displayed during the connector operation:
Error: Agent Execution Failed. <EndPointURL> returned a response status of 403 Forbidden.
Creating the Connected System in the Admin UI
- Log in to Identity Administration and click the Systems tab.
- On the Connected System View page, click the Add button and select the Oracle HCM connected system from the Type drop-down list. The Connected System Details page displays the default values:
3. Enter the desired information:
Definition | |
Supported Connectors |
Displays whether the connected system supports Provisioning only. |
Type | Select the connected system type. |
Locale |
Select the preferred language (default: English). Locale specific information such as Display Name and Description can be added only while modifying the connected system. |
Name | The name for this connected system. Note: The name cannot be modified later. |
Display Name | The display name of the new connected system. |
Description | The description of the connected system. |
Associated With |
Select how the connector associated with this system will run:
See Using the Global Identity Gateway with Connected Systems for additional information. |
Password Reset By | This feature is not available for this connector. |
Provisioning Option | Select the provisioning option:
|
Enable HPAM Support | Select to make the connected system HPAM enabled (default: cleared). Note: This can only be set for systems that support Identity. |
Enable Transfer of Accounts | Select to make the transfer of Accounts enabled (default cleared). |
Connection Information | |
Service URL |
The URL of the Oracle HCM Server. To enable a secure SSL connection, use the HTTPS protocol. |
HCM Cloud Version | Version number of Oracle HCM Cloud release to be called. |
Service Account Name | The name of the administrative user account used to connect to the server. |
Service Account Password | The administrative user password. |
Connection Timeout | The maximum number of seconds to wait for the Web Service to respond before the connection attempt times-out. 0 means no time out. |
Password Expiration Support | |
Expiration Options For Admin/OBO User Password Reset |
Specify the password expiration: None or Immediate. |
System Owner |
Add or Remove users assigned as the owners of the system. Displays the Connected System Owner Search page for selecting users. The HPAM column indicates whether the system owner is authorized to use the HPAM feature. The Approvers column indicates whether the system owner is an approver in the approval process. |
4. Click the Test Connection button to test the Connection Information:
- If successful, this message will display:
Message: Connection from Provisioning to the connected system was established successfully.
- If unsuccessful, this message will display:
Error: Failed to establish connection from Provisioning to the connected system.
Note: If the connection fails, additional messages may display providing more information regarding the failure, and additional information may be posted to the Provisioning logs.
5. System Owner(Optional) Adds or removes users assigned as the owners of the system. Displays the Connected System Owner Search page for selecting users:To select owners of the system, click the System Owner Add button. The Connected System Owner Search page displays
- To select owners of the system, click the System Owner Add button. The Connected System Owner Search page displays:
-
Select the owners and then click the Select button. The system owner displays under the System Owner section:
The HPAM column indicates whether the system owner is authorized to use the HPAM feature. The Approvers column indicates whether the system owner is an approver in the approval process. The Status column indicates whether the system owner is active.
Note: More than one user can be assigned as an owner.
- To add additional system owners, click the Add button.
- On the Connected System Details page, click the Add button to save the configured connected system. The Object Category Association page displays a list of categories that are already associated and/or can be selected to add additional associations to this connected system:
Select one or more available object categories or provide search criteria and click the Search button to find specific categories to select. If there are no available categories to select, proceed to Step 7.
Click the Add Association button to associate the selected object categories to the connected system.
Click the Back button to return to the Connected System View page. The new connected system displays in the list.
See Copying, Modifying, and Deleting Connected Systems for additional information.
Creating the Connected System in the Studio
- Log in to the Workflow and Connectivity Studio and click Connectivity ► Add Systems on the menu bar. The Add Connected Systems window displays.
- Select the Oracle HCM connected system from the Type drop-down list. The default values display:
-
Enter the desired information:
Definition Supported Connectors
Displays that the connected system supports Provisioning only. Type Select the connected system type. Locale Select the preferred language (default: English). Locale specific information such as Display Name and Description can be added only while modifying the connected system. Name The name for this connected system. Note: The name cannot be modified later. Display Name The display name of the new connected system. Description The description of the connected system. Associated With
Select how the connector associated with this system will run:
- Server (default) - Runs locally on the Provisioning/Identity Server.
- Global Identity Gateway - Runs remotely on a Global Identity Gateway cluster member. Note: Only GIG clusters that have at least one registered and enabled member will display in this
See the appendix Using the Global Identity Gateway with Connected Systems for additional information.
Password Reset By This feature is not available for this connector. Provisioning Option
Select the provisioning option:
- Automated (default) - The connected system functions as a normal connected system; there are no restrictions.
- Administrative - The connected system cannot be used as an object in a workflow.
Enable HPAM Support Select to make the connected system HPAM enabled (default: cleared). Note: This can only be set for systems that support Identity. Enable Transfer Of Accounts Select to make the transfer of Accounts enabled (default cleared). Connection Information Service URL
The URL of the Oracle HCM Server. To enable a secure SSL connection, use the HTTPS protocol.
Note: This connector uses the Java key store for SSL communication with the system. See the guide Configuring SSL for additional information about enabling SSL.HCM Cloud Version Version number of Oracle HCM Cloud release to be called. Service Account Name
The name of the administrative user account used to connect to the server. Service Account Password
The administrative user password. Connection Timeout
The maximum number of seconds to wait for the Web Service to respond before the connection attempt times-out. 0 means no time out. Password Expiration Support Expiration Options For Admin/ OBO User Password Reset
Specify the password expiration: None or Immediate. - Click the Connect button to test the Connection Information:
- If successful, this message displays:
Connection from Studio to the connected system was established successfully.
- If unsuccessful this message displays:
Failed to establish connection from Studio to the connected system.
Note: If the connection fails, additional messages may display providing more information regarding the failure.
-
Click the Apply button to apply changes. The Category Association window displays.
Select one or more object categories from the Available Categories list or enter a category name and click the Search button to find a specific category to select. If there are no available categories to select, proceed to Step 6.
Click the Add button to associate the selected object categories to the connected system.
Click OK to accept selected categories.
See Copying, Modifying, and Deleting Connected Systems for additional information.
Using the Connected System for Provisioning
Perform these procedures to configure the connector:
- Configuring for Export
- Configuring for Import
- Connector Details for Provisioning
Note: If the number of records to be processed exceeds one thousand, we recommend configuring the workflow to use bulk mode, which lowers the memory consumption of the system by streaming data to files. Because data is streamed for every task, performance of the workflow execution will be decreased due to increased read-write operations. See the Workflow and Connectivity Studio document for details on how to configure bulk mode.
Configuring for Export
Perform these procedures to configure the connector:
- Configuring the Export Connector
- Configuring the Export Link
From the Workflow and Connectivity Studio, select the Oracle HCM UserExport workflow listed under the projects folder.
If a workflow does not already exist, create an export workflow. See the Workflow and Connectivity Studio document for details on creating export workflows.
Configuring the Export Connector
- In the Design pane, double-click the export object (the first workflow object after the Start object). The Configure Data Source window displays:
2. From the Configure Plug-in tab, set these properties as required:
Associated Connected System |
Select the connected system from the list. The export operation will be done from this connected system. |
Data Formats | Select the type of data format to use: Employee (dafault), JobFamily, Job, Location, Postion, Organization, HR Combined or Worker. |
DeltaExportMode |
Select the type of attribute to export if a change takes place (this works in conjunction with ExportMode when DeltaExport is selected):
|
DynamicConnectedSystem | Select the global variable to use as the dynamic connected system name. This works in conjunction with DynamicConnectedSystemOption when GlobalVariable is selected. |
DynamicConnectedSystemOption |
Select how to control Dynamic System Support (DSS):
|
ExecuteGIGAssociatedTaskAsynchronously | If this property is True, GIG associated tasks will execute asynchronously. |
ExportMode |
Select the type of data to export:
|
Filter | Specify search criteria to determine the objects to be exported from the container specified in ExportDN. Use the Set Filter button that becomes active to create a filter. See "Set Filter" for additional information. |
GetEmployeeByUID |
Specify the UID of an employee to fetch the details. This property is available only for Employee data format. |
GetEntryByUID | Specify the UID of the entry to fetch the details. This property is not available for Employee data format. |
MaxResults | Select the maximum number of results to be returned (this works in conjunction with ExportMode when FullExport is selected). If this is 0, all entries matching the search criteria are returned. |
ResultsPerPage |
Specify the number of entries to be fetched from Oracle HCM in a single call. |
Set Filter
Setting the filter is a means to narrow the search scope and return specific results.
(Optional) Select the Appearance tab to change how the Connected System object displays in the Design pane.
Attributes | Select the attribute of the filter. This represents the attribute name for searching the EventPro system. |
Comparison |
Select the operator value for this filter. |
AND Condition List |
Creates an AND statement comparing selected conditions. If there is more than one condition in this list box, all conditions must be true. |
OR Condition List |
Creates an OR statement comparing selected conditions. If there is more than one condition in this list box, one of the conditions must be true. |
Filter Syntax | Displays the filter syntax used to retrieve entries from the LDAP directory and to build the export list. |
Using logical AND/OR, generate the complex filter to narrow the search result.
Click OK when complete to return to the Configure Data Source window
Configuring the Export Link
-
In the Design pane, double-click the export link between the export object (the first workflow object after the Start object) and the Data Mapper object. The Configure Link window displays:
Source Attributes
List of attributes which can be exported. Selected Attributes
Displays default attributes and those attributes that have been selected from the Source Attributes.
Notes:
The check boxes are used only for delta export operations. These checked attributes will always be exported whether they were changed or not. Usually, the attributes that are selected as mandatory attributes help in identifying or verifying an entry when completing mapping functions.
Format Displays the Format Date window to specify a date/time format to be applied to the selected date type attribute, for example, BirthDate. During export, the attribute's value is converted to the specified format. See the Format Date steps below for additional information.
Notes:- The Format button is only enabled for date attributes.
Advanced Settings Displays the Configure Attributes window for selecting any attributes that need to be encrypted. From the Attribute Selection tab, select attributes to export. Usually, these attributes that are selected (mandatory attributes) help in identifying or verifying an entry when completing Data Mapper functions.
- (Optional) Click the Format button to specify a date/time format to be applied to the selected date type attribute. The Format Date window displays.
- Select the Include Time check box to add the timestamp with the date.
- Select the 24 Hour or 12 Hour option button and then select the required date/time format.
- Click OK to save the selected format. The Configure Link window displays.
- Click OK to save any changes and return to the Workflow and Connectivity Studio window.
- Deploy the workflow by selecting Deploy ► New Deployment. See the Workflow and Connectivity Studio documentation for details of deployment options.
- Manage and run the deployed workflow from the Admin UI ► Server tab. See the Identity Suite Administration documentation for details.
Configuring for Import
Perform these procedures to configure the connector for data import:
Configuring the Import Connector
Configuring the Import Link
From the Workflow and Connectivity Studio, select the Oracle HCM UserModify workflow listed under the projects folder. If a workflow does not already exist, create an import workflow. See the Workflow and Connectivity Studio document for details on creating import workflows.
Configuring the Import Connector
- In the Design pane, double-click the import object (the last workflow object). The Configure Data Source window displays
-
From the Configure Plug-in tab, set these properties as required:
Associated Connected System
Select the connected system from the list. The import operation will be done to this connected system. Data Formats Select the type of data format to use: Employee, Worker. DynamicConnectedSystem
Select the global variable to use as the dynamic connected syStem name. This works in conjunction with DynamicCon- nectedSystemOption when GlobalVariable is selected. DynamicConnectedSystemOption
Select how to control Dynamic System Support (DSS):
- None - There will not be any Dynamic System
- Transaction-SystemName - The value of the Transaction- SystemName attribute in data will be used as the dynamic connected system. The connected system name must be passed as the value of the attribute Transaction- SystemName; if it is missing in data, the operation will
- GlobalVariable - Select a global variable to use as the dynamic connected system name from the property DynamicConnectedSystem.
ExecuteGIGAssociatedTaskAsynchronously If this property is True, GIG associated tasks will execute asynchronously. Id *
Enter the attribute that contains the value used to uniquely identify the user account user ID on the connected system (ACCOUNT_ID column of the FISC_USER_ACCOUNT table). loginId *
Enter the attribute that contains the value used to uniquely identify the user account login ID (uniqueId) on the connected system (ACCOUNT_USERNAME column of the FISC_USER_ACCOUNT table). Notes:
* Id and loginId are used by the Provisioning Policy and IdentityHub features to populate the ACCOUNT_ID and ACCOUNT_USERNAME columns of the FISC_USER_ACCOUNT table of the Product database. See the ‘Provisioning Policy’ and ‘Provisioning Using the IdentityHub’ chapters of the Identity Suite Administration Guide for details.
Hover the pointer over a property to view its description.
- (Optional) Select the Attributes tab. Only standard attributes display:
Modify schema attributes with the buttons.
- (Optional) Select the Appearance tab to change how the Connected System object displays in the Design pane.
-
Click OK to save any changes and return to the Workflow and Connectivity Studio window.
Configuring the Import Link
-
In the Design pane, double-click the import link between the Data Mapper object and the import object (the last workflow object). The Configure Link window displays:
Source Attributes Select the attributes to import. Check for attribute- level auditing
If auditing is enabled and these attributes below are checked, Provisioning will log all events for auditing purposes. Selected Attributes
Displays default attributes and those attributes that have been selected from the Source Attributes. Check the box of any attribute required for attribute-level auditing. Format
Displays the Format Date window to specify a date/time format to be applied to the selected date type attribute, for example, BirthDate. During import, the attribute's value is converted to the specified format.
Notes: The Format button is only enabled for date attributes.
Advanced Settings
Displays the Configure Attributes window for selecting any attributes that need to be encrypted. Select the attribute to be used as the key attribute. Key Attribute
Select the attribute to be used as the key attribute. - From the Attribute Selection tab, select attributes to import.
- (Optional) Select the Appearance tab to change how the link displays in the Design pane.
- Click OK to save any changes and return to the Workflow and Connectivity Studio window.
- Deploy the workflow by selecting Deploy ► New Deployment. See the Workflow and Connectivity Studio document for details of deployment options.
- Manage and run the deployed workflow from the Admin UI ► Server tab. See the Identity Suite Administration Guide for details.
Connector Details for Provisioning
Connector Attributes
The items in the Export, Add and Modify columns have these meanings:
Y* = Yes (attribute is mandatory for this operation)
Y** = attribute is auto generated by Oracle HCM if no value is Auto-generated attributes are returned with the call response and is included in import status data.
Y = Yes (attribute is supported for this operation)
N = No (attribute is not supported for this operation)
Delete is not supported for Oracle HCM data formats.
Employee Data Format
Name |
Type |
MV |
Export |
Add |
Modify |
AddressLine1 |
string |
N |
Y |
Y |
Y |
AddressLine2 |
string |
N |
Y |
Y |
Y |
AddressLine3 |
string |
N |
Y |
Y |
Y |
CitizenshipId |
integer |
N |
Y |
Y |
Y |
CitizenshipLegislationCode |
string |
N |
Y |
Y |
Y |
CitizenshipStatus |
string |
N |
Y |
Y |
Y |
CitizenshipToDate |
date |
N |
Y |
Y |
Y |
City |
string |
N |
Y |
Y |
Y |
CorrespondenceLanguage |
string |
N |
Y |
Y |
Y |
Country |
string |
N |
Y |
Y |
Y |
CreationDate |
date-time |
N |
Y |
Y |
Y |
DateOfBirth |
date |
N |
Y |
Y |
Y |
DisplayName |
string |
N |
Y |
Y |
Y |
DriversLicenseExpirationDate |
date |
N |
Y |
Y |
Y |
DriversLicenseId |
integer |
N |
Y |
Y |
Y |
DriversLicenseIssuingCountry |
string |
N |
Y |
Y |
Y |
EffectiveStartDate |
date |
N |
Y |
Y |
Y |
EmployeeUID |
string |
N |
Y |
N |
N |
Ethnicity |
string |
N |
Y |
Y |
Y |
FirstName |
string |
N |
Y |
Y |
Y |
Gender |
string |
N |
Y |
Y |
Y |
HireDate |
date |
N |
Y |
Y |
Y |
HomeFaxAreaCode |
string |
N |
Y |
Y |
Y |
HomeFaxCountryCode |
string |
N |
Y |
Y |
Y |
HomeFaxExtension |
string |
N |
Y |
Y |
Y |
HomeFaxLegislationCode |
string |
N |
Y |
N |
N |
HomeFaxNumber |
string |
N |
Y |
Y |
Y |
HomePhoneAreaCode |
string |
N |
Y |
Y |
Y |
HomePhoneCountryCode |
string |
N |
Y |
Y |
Y |
HomePhoneExtension |
string |
N |
Y |
Y |
Y |
HomePhoneLegislationCode |
string |
N |
Y |
N |
N |
HomePhoneNumber |
string |
N |
Y |
Y |
Y |
Honors |
string |
N |
Y |
Y |
Y |
LastName |
string |
N |
Y |
Y* |
Y |
LastUpdateDate |
date-time |
N |
Y |
Y |
Y |
LegalEntityId |
integer |
N |
Y |
Y* |
Y |
LicenseNumber |
string |
N |
Y |
Y |
Y |
MaritalStatus |
string |
N |
Y |
Y |
Y |
MiddleName |
string |
N |
Y |
Y |
Y |
MilitaryVetStatus |
string |
N |
Y |
Y |
Y |
NameSuffix |
string |
N |
Y |
Y |
Y |
PersonId |
integer |
N |
Y |
Y** |
Y |
PersonNumber |
string |
N |
Y |
Y** |
Y |
PostalCode |
string |
N |
Y |
Y |
Y |
PreferredName |
string |
N |
Y |
Y |
Y |
PreviousLastName |
string |
N |
Y |
Y |
Y |
ProjectedTerminationDate |
date |
N |
Y |
Y |
Y |
Region |
string |
N |
Y |
Y |
Y |
Region2 |
string |
N |
Y |
Y |
Y |
Religion |
string |
N |
Y |
Y |
Y |
ReligionId |
integer |
N |
Y |
Y |
Y |
Salutation |
string |
N |
Y |
Y |
Y |
TerminationDate |
date |
N |
Y |
Y |
Y |
UserName |
string |
N |
Y |
Y |
Y |
WorkEmail |
string |
N |
Y |
Y |
Y |
WorkFaxAreaCode |
string |
N |
Y |
Y |
Y |
WorkFaxCountryCode |
string |
N |
Y |
Y |
Y |
WorkFaxExtension |
string |
N |
Y |
Y |
Y |
WorkFaxLegislationCode |
string |
N |
Y |
N |
N |
WorkFaxNumber |
string |
N |
Y |
Y |
Y |
WorkMobilePhoneAreaCode |
string |
N |
Y |
Y |
Y |
WorkMobilePhoneCountryCode |
string |
N |
Y |
Y |
Y |
WorkMobilePhoneExtension |
string |
N |
Y |
Y |
Y |
WorkMobilePhoneLegislationCode |
string |
N |
Y |
N |
N |
WorkMobilePhoneNumber |
string |
N |
Y |
Y |
Y |
WorkPhoneAreaCode |
string |
N |
Y |
Y |
Y |
WorkPhoneCountryCode |
string |
N |
Y |
Y |
Y |
WorkPhoneExtension |
string |
N |
Y |
Y |
Y |
WorkPhoneLegislationCode |
string |
N |
Y |
N |
N |
WorkPhoneNumber |
string |
N |
Y |
Y |
Y |
WorkerType |
string |
N |
Y |
Y |
Y |
Employee Assignment attributes. Employee assignments can be managed using these attributes. One employee assignment is mandatory while adding an employee. |
|||||
assignments->ActionCode |
string |
N |
Y |
Y |
Y |
assignments->ActionReasonCode |
string |
N |
Y |
Y |
Y |
assignments->ActualTerminationDate |
date |
N |
Y |
Y |
Y |
assignments->AssignmentCategory |
string |
N |
Y |
Y |
Y |
assignments->AssignmentId |
integer |
N |
Y |
Y |
Y* |
assignments->AssignmentName |
string |
N |
Y |
Y |
Y |
assignments->AssignmentNumber |
string |
N |
Y |
Y |
Y |
assignments- >AssignmentProjectedEndDate |
date |
N |
Y |
Y |
Y |
assignments->AssignmentStatus |
string |
N |
Y |
Y |
Y |
assignments->AssignmentStatusTypeId |
string |
N |
Y |
N |
N |
assignments->AssignmentUID |
string |
N |
Y |
N |
N |
assignments->BusinessUnitId |
integer |
N |
Y |
Y* |
Y |
assignments->CreationDate |
date-time |
N |
Y |
Y |
Y |
assignments->DepartmentId |
integer |
N |
Y |
Y |
Y |
assignments->EffectiveEndDate |
date |
N |
Y |
Y |
Y |
assignments->EffectiveStartDate |
date |
N |
Y |
Y |
Y |
assignments->EndTime |
string |
N |
Y |
Y |
Y |
assignments->Frequency |
string |
N |
Y |
Y |
Y |
assignments->FullPartTime |
string |
N |
Y |
N |
N |
assignments->GradeId |
integer |
N |
Y |
Y |
Y |
assignments->GradeLadderId |
string |
N |
Y |
N |
N |
assignments->JobId |
integer |
N |
Y |
Y |
Y |
assignments->LastUpdateDate |
date-time |
N |
Y |
Y |
Y |
assignments->LegalEntityId |
integer |
N |
Y |
Y* |
Y |
assignments->LocationId |
integer |
N |
Y |
Y |
Y |
assignments->ManagerAssignmentId |
integer |
N |
Y |
Y |
Y |
assignments->ManagerId |
integer |
N |
Y |
Y |
Y |
assignments->ManagerType |
string |
N |
Y |
Y |
Y |
assignments->OriginalHireDate |
date |
N |
Y |
Y |
Y |
assignments->PeriodOfServiceId |
integer |
N |
Y |
Y |
Y |
assignments->PersonTypeId |
integer |
N |
Y |
Y |
Y |
assignments->PositionId |
integer |
N |
Y |
Y |
Y |
assignments->PrimaryAssignmentFlag |
boolean |
N |
Y |
Y |
Y |
assignments->PrimaryWorkRelationFlag |
boolean |
N |
Y |
Y |
Y |
assignments->PrimaryWorkTermsFlag |
boolean |
N |
Y |
Y |
Y |
assignments->ProbationPeriodEndDate |
date |
N |
Y |
Y |
Y |
assignments->ProbationPeriodLength |
number |
N |
Y |
Y |
Y |
assignments- >ProbationPeriodUnitOfMeasure |
string |
N |
Y |
Y |
Y |
assignments->ProjectedStartDate |
date |
N |
Y |
Y |
Y |
assignments->ProposedPersonTypeId |
string |
N |
Y |
Y |
Y |
assignments->RegularTemporary |
string |
N |
Y |
N |
N |
assignments->SalaryAmount |
number |
N |
Y |
Y |
Y |
assignments->SalaryBasisId |
integer |
N |
Y |
Y |
Y |
assignments->SalaryCode |
string |
N |
Y |
Y |
Y |
assignments->StartTime |
string |
N |
Y |
Y |
Y |
assignments->TermsEffectiveStartDate |
date |
N |
Y |
Y |
Y |
assignments->WorkTaxAddressId |
integer |
N |
Y |
Y |
Y |
assignments->WorkerCategory |
string |
N |
Y |
Y |
Y |
assignments->WorkingAsManager |
string |
N |
Y |
Y |
Y |
assignments->WorkingAtHome |
string |
N |
Y |
Y |
Y |
assignments->WorkingHours |
number |
N |
Y |
Y |
Y |
Employee Role attributes. Employee roles can be managed using these attributes. Employee roles can be added, modified and deleted. RoleName/RoleCommonName/RoleGUID is mandatory to add Employee Role. RoleGUID is mandatory to add multiple Employee Roles together. To modify/delete Employee Role, RoleUID/RoleGUID is mandatory. |
|||||
roles->CreationDate |
date-time |
N |
Y |
Y |
Y |
roles->EndDate |
date |
N |
Y |
Y |
Y |
roles->LastUpdateDate |
date-time |
N |
Y |
Y |
Y |
roles->RoleCommonName |
string |
N |
Y |
Y |
Y |
roles->RoleGUID |
string |
N |
Y |
Y |
Y |
roles->RoleName |
string |
N |
Y |
Y |
Y |
roles->RoleUID |
string |
N |
Y |
Y |
Y |
roles->StartDate |
date |
N |
Y |
Y |
Y |
Job Family Data Format
Name |
Type |
MV |
Export |
Add |
Modify |
ActionReasonId |
string |
N |
Y |
N |
N |
ActiveStatus |
string |
N |
Y |
N |
N |
CreationDate |
date-time |
N |
Y |
N |
N |
EffectiveEndDate |
date |
N |
Y |
N |
N |
EffectiveStartDate |
date |
N |
Y |
N |
N |
JobFamilyCode |
string |
N |
Y |
N |
N |
JobFamilyId |
integer |
N |
Y |
N |
N |
JobFamilyName |
string |
N |
Y |
N |
N |
JobFamilyUID |
string |
N |
Y |
N |
N |
LastUpdateDate |
string |
N |
Y |
N |
N |
Job Data Format
Name |
Type |
MV |
Export |
Add |
Modify |
ActiveStatus |
string |
N |
Y |
N |
N |
Approval Authority |
number |
N |
Y |
N |
N |
CreationDate |
date-time |
N |
Y |
N |
N |
EffectiveEndDate |
date |
N |
Y |
N |
N |
EffectiveStartDate |
date |
N |
Y |
N |
N |
FullPartTime |
string |
N |
Y |
N |
N |
GradeLadderId |
integer |
N |
Y |
N |
N |
JobCode |
string |
N |
Y |
N |
N |
JobFamilyUID |
integer |
N |
Y |
N |
N |
JobFunctionCode |
string |
N |
Y |
N |
N |
JobId |
integer |
N |
Y |
N |
N |
JobUID |
string |
N |
Y |
N |
N |
LastUpdateDate |
date-time |
N |
Y |
N |
N |
ManagerLevel |
string |
N |
Y |
N |
N |
MedicalCheckupRequired |
string |
N |
Y |
N |
N |
Name |
string |
N |
Y |
N |
N |
RegularTemporary |
string |
N |
Y |
N |
N |
SetId |
integer |
N |
Y |
N |
N |
Location Data Format
Name |
Type |
MV |
Export |
Add |
Modify |
AddressLine1 |
string |
N |
Y |
N |
N |
AddressLine2 |
string |
N |
Y |
N |
N |
AddressLine3 |
string |
N |
Y |
N |
N |
AddressLine4 |
string |
N |
Y |
N |
N |
BillToSiteFlag |
boolean |
N |
Y |
N |
N |
Country |
string |
N |
Y |
N |
N |
CreationDate |
date-time |
N |
Y |
N |
N |
Description |
string |
N |
Y |
N |
N |
EffectiveEndDate |
date |
N |
Y |
N |
N |
EffectiveStartDate |
date |
N |
Y |
N |
N |
EmailAddress |
string |
N |
Y |
N |
N |
LastUpdateDate |
date-time |
N |
Y |
N |
N |
LocationCode |
string |
N |
Y |
N |
N |
LocationId |
integer |
N |
Y |
N |
N |
LocationName |
string |
N |
Y |
N |
N |
LocationUID |
string |
N |
Y |
N |
N |
MainAddressId |
integer |
N |
Y |
N |
N |
OfficeSiteFlag |
boolean |
N |
Y |
N |
N |
PostalCode |
string |
N |
Y |
N |
N |
ReceivingSiteFlag |
boolean |
N |
Y |
N |
N |
Region1 |
string |
N |
Y |
N |
N |
Region2 |
string |
N |
Y |
N |
N |
Region3 |
string |
N |
Y |
N |
N |
SetId |
integer |
N |
Y |
N |
N |
ShipToSiteFlag |
boolean |
N |
Y |
N |
N |
TelephoneNumber1 |
string |
N |
Y |
N |
N |
TelephoneNumber2 |
string |
N |
Y |
N |
N |
TelephoneNumber3 |
string |
N |
Y |
N |
N |
TownOrCity |
string |
N |
Y |
N |
N |
Organization Data Format
Name |
Type |
MV |
Export |
Add |
Modify |
ClassificationCode |
string |
N |
Y |
N |
N |
CreationDate |
date-time |
N |
Y |
N |
N |
EffectiveEndDate |
date |
N |
Y |
N |
N |
EffectiveStartDate |
date |
N |
Y |
N |
N |
InternalAddressLine |
string |
N |
Y |
N |
N |
LastUpdateDate |
date-time |
N |
Y |
N |
N |
LocationId |
integer |
N |
Y |
N |
N |
Name |
string |
N |
Y |
N |
N |
OrganizationCode |
string |
N |
Y |
N |
N |
OrganizationId |
integer |
N |
Y |
N |
N |
OrganizationUID |
string |
N |
Y |
N |
N |
OrgCode |
string |
N |
Y |
N |
N |
Status |
string |
N |
Y |
N |
N |
Position Data Format
Name |
Type |
MV |
Export |
Add |
Modify |
BusinessUnitId |
integer |
N |
Y |
N |
N |
CreationDate |
date-time |
N |
Y |
N |
N |
DepartmentId |
integer |
N |
Y |
N |
N |
EffectiveEndDate |
date |
N |
Y |
N |
N |
EffectiveStartDate |
date |
N |
Y |
N |
N |
EntryGradeId |
integer |
N |
Y |
N |
N |
EntryStepId |
integer |
N |
Y |
N |
N |
FTE |
number |
N |
Y |
N |
N |
FullPartTime |
string |
N |
Y |
N |
N |
GradeLadderId |
integer |
N |
Y |
N |
N |
HeadCount |
number |
N |
Y |
N |
N |
HiringStatus |
string |
N |
Y |
N |
N |
JobId |
integer |
N |
Y |
N |
N |
LastUpdateDate |
date-time |
N |
Y |
N |
N |
LocationId |
integer |
N |
Y |
N |
N |
Name |
string |
N |
Y |
N |
N |
OverlapAllowedFlag |
boolean |
N |
Y |
N |
N |
PositionCode |
string |
N |
Y |
N |
N |
PositionId |
integer |
N |
Y |
N |
N |
PositionType |
string |
N |
Y |
N |
N |
PositionUID |
string |
N |
Y |
N |
N |
ProbationPeriod |
number |
N |
Y |
N |
N |
RegularTemporary |
string |
N |
Y |
N |
N |
SeasonalEndDate |
date |
N |
Y |
N |
N |
SeasonalFlag |
boolean |
N |
Y |
N |
N |
SeasonalStartDate |
date |
N |
Y |
N |
N |
SecurityClearance |
string |
N |
Y |
N |
N |
Worker Data Format
Name |
Type |
MV |
Export |
Add |
Modify |
ApplicantNumber |
string |
N |
Y |
Y |
Y |
BloodType |
string |
N |
Y |
Y |
Y |
CorrespondenceLanguage |
string |
N |
Y |
Y |
Y |
CountryOfBirth |
string |
N |
Y |
Y |
Y |
CreatedBy |
string |
N |
Y |
N |
N |
CreationDate |
date-time |
N |
Y |
N |
N |
DateOfBirth |
string |
N |
Y |
Y |
Y |
DateOfDeath |
string |
N |
Y |
Y |
Y |
LastUpdateDate |
date-time |
N |
Y |
N |
N |
LastUpdatedBy |
string |
N |
Y |
N |
N |
PersonId |
string |
N |
Y |
Y |
Y |
PersonNumber |
string |
N |
Y |
Y |
Y |
RegionOfBirth |
string |
N |
Y |
Y |
Y |
TownOfBirth |
string |
N |
Y |
Y |
Y |
WorkerUID |
string |
N |
Y |
Y |
Y |
Worker Address Attributes |
|||||
addresses->AddlAddressAttribute1 |
string |
N |
Y |
Y |
Y |
addresses->AddlAddressAttribute2 |
string |
N |
Y |
Y |
Y |
addresses->AddlAddressAttribute3 |
string |
N |
Y |
Y |
Y |
addresses->AddlAddressAttribute4 |
string |
N |
Y |
Y |
Y |
addresses->AddlAddressAttribute5 |
string |
N |
Y |
Y |
Y |
addresses->AddressId |
string |
N |
Y |
Y |
Y |
addresses->AddressLine1 |
string |
N |
Y |
Y |
Y |
addresses->AddressLine2 |
string |
N |
Y |
Y |
Y |
addresses->AddressLine3 |
string |
N |
Y |
Y |
Y |
addresses->AddressLine4 |
string |
N |
Y |
Y |
Y |
addresses->AddressType |
string |
N |
Y |
Y |
Y |
addresses->AddressUID |
string |
N |
Y |
Y |
Y |
addresses->Country |
string |
N |
Y |
Y |
Y |
addresses->CreatedBy |
string |
N |
Y |
N |
N |
addresses->CreationDate |
date-time |
N |
Y |
N |
N |
addresses->EffectiveEndDate |
date |
N |
Y |
Y |
Y |
addresses->EffectiveStartDate |
date |
N |
Y |
Y |
Y |
addresses->LastUpdateDate |
date-time |
N |
Y |
N |
N |
addresses->LastUpdatedBy |
string |
N |
Y |
N |
N |
addresses->LongPostalCode |
string |
N |
Y |
Y |
Y |
addresses->PersonAddrUsageId |
string |
N |
Y |
Y |
Y |
addresses->PostalCode |
string |
N |
Y |
Y |
Y |
addresses->PrimaryFlag |
string |
N |
Y |
Y |
Y |
addresses->Region1 |
string |
N |
Y |
Y |
Y |
addresses->Region2 |
string |
N |
Y |
Y |
Y |
addresses->Region3 |
string |
N |
Y |
Y |
Y |
addresses->TownOrCity |
string |
N |
Y |
Y |
Y |
Worker Citizenship Attributes | |||||
citizenships->Citizenship |
string |
N |
Y |
N |
N |
citizenships->CitizenshipId |
string |
N |
Y |
N |
N |
citizenships->CitizenshipStatus |
string |
N |
Y |
N |
N |
citizenships->CitizenshipUID |
string |
N |
Y |
N |
N |
citizenships->CreatedBy |
string |
N |
Y |
N |
N |
citizenships->CreationDate |
date-time |
N |
Y |
N |
N |
citizenships->FromDate |
date |
N |
Y |
N |
N |
citizenships->LastUpdateDate |
date-time |
N |
Y |
N |
N |
citizenships->LastUpdatedBy |
string |
N |
Y |
N |
N |
citizenships->ToDate |
date |
N |
Y |
N |
N |
Worker Driver License Attributes |
|||||
driverLicenses->CreatedBy |
string |
N |
Y |
N |
N |
driverLicenses->CreationDate |
date-time |
N |
Y |
N |
N |
driverLicenses->DriverLicenseUID |
string |
N |
Y |
N |
N |
driverLicenses->DriversLicenseId |
string |
N |
Y |
N |
N |
driverLicenses->FromDate |
date |
N |
Y |
N |
N |
driverLicenses->IssuingAuthority |
string |
N |
Y |
N |
N |
driverLicenses->IssuingCountry |
string |
N |
Y |
N |
N |
driverLicenses->IssuingLocation |
string |
N |
Y |
N |
N |
driverLicenses->LastUpdateDate |
date-time |
N |
Y |
N |
N |
driverLicenses->LastUpdatedBy |
string |
N |
Y |
N |
N |
driverLicenses->LicenseNumber |
string |
N |
Y |
N |
N |
driverLicenses->LicenseSuspendedFlag |
string |
N |
Y |
N |
N |
driverLicenses->LicenseType |
string |
N |
Y |
N |
N |
driverLicenses->NumberOfPoints |
string |
N |
Y |
N |
N |
driverLicenses->SuspendedFromDate |
date |
N |
Y |
N |
N |
driverLicenses->SuspendedToDate |
date |
N |
Y |
N |
N |
driverLicenses->ToDate |
date |
N |
Y |
N |
N |
driverLicenses->Violations |
string |
N |
Y |
N |
N |
Worker Email Attributes |
|||||
emails->CreatedBy |
string |
N |
Y |
N |
N |
emails->CreationDate |
date-time |
N |
Y |
N |
N |
emails->EmailAddress |
string |
N |
Y |
Y |
Y |
emails->EmailAddressId |
string |
N |
Y |
Y |
Y |
emails->EmailType |
string |
N |
Y |
Y |
Y |
emails->EmailUID |
string |
N |
Y |
Y |
Y |
emails->FromDate |
date |
N |
Y |
Y |
Y |
emails->LastUpdateDate |
date-time |
N |
Y |
N |
N |
emails->LastUpdatedBy |
string |
N |
Y |
N |
N |
emails->PrimaryFlag |
string |
N |
Y |
Y |
Y |
emails->ToDate |
date |
N |
Y |
Y |
Y |
Worker Ethnicities Attributes |
|||||
ethnicities->CreatedBy |
string |
N |
Y |
N |
N |
ethnicities->CreationDate |
date-time |
N |
Y |
N |
N |
ethnicities->Ethnicity |
string |
N |
Y |
N |
N |
ethnicities->EthnicityId |
string |
N |
Y |
N |
N |
ethnicities->EthnicityUID |
string |
N |
Y |
N |
N |
ethnicities->LastUpdateDate |
date-time |
N |
Y |
N |
N |
ethnicities->LastUpdatedBy |
string |
N |
Y |
N |
N |
ethnicities->LegislationCode |
string |
N |
Y |
N |
N |
ethnicities->PrimaryFlag |
string |
N |
Y |
N |
N |
Worker External Identifier Attributes |
|||||
externalIdentifiers->AssignmentId |
string |
N |
Y |
Y |
Y |
externalIdentifiers->AssignmentNumber |
string |
N |
Y |
Y |
Y |
externalIdentifiers->Comments |
string |
N |
Y |
Y |
Y |
externalIdentifiers->CreatedBy |
string |
N |
Y |
N |
N |
externalIdentifiers->CreationDate |
date-time |
N |
Y |
N |
N |
externalIdentifiers->ExternalIdentifierId |
string |
N |
Y |
Y |
Y |
externalIdentifiers->ExternalIdentifierNumber |
string |
N |
Y |
Y |
Y |
externalIdentifiers->ExternalIdentifierSequence |
string |
N |
Y |
Y |
Y |
externalIdentifiers->ExternalIdentifierType |
string |
N |
Y |
Y |
Y |
externalIdentifiers->ExternalIdentifierUID |
string |
N |
Y |
Y |
Y |
externalIdentifiers->FromDate |
date |
N |
Y |
Y |
Y |
externalIdentifiers->LastUpdateDate |
date-time |
N |
Y |
N |
N |
externalIdentifiers->LastUpdatedBy |
string |
N |
Y |
N |
N |
externalIdentifiers->ToDate |
date |
N |
Y |
Y |
Y |
Worker Legislative Info Attributes |
|||||
legislativeInfo->CreatedBy |
string |
N |
Y |
N |
N |
legislativeInfo->CreationDate |
date-time |
N |
Y |
N |
N |
legislativeInfo->EffectiveEndDate |
date |
N |
Y |
Y |
Y |
legislativeInfo->EffectiveStartDate |
date |
N |
Y |
Y |
Y |
legislativeInfo->Gender |
string |
N |
Y |
Y |
Y |
legislativeInfo->HighestEducationLevel |
string |
N |
Y |
Y |
Y |
legislativeInfo->LastUpdateDate |
date-time |
N |
Y |
N |
N |
legislativeInfo->LastUpdatedBy |
string |
N |
Y |
N |
N |
legislativeInfo->LegislationCode |
string |
N |
Y |
Y |
Y |
legislativeInfo->LegislativeInfoUID |
string |
N |
Y |
Y |
Y |
legislativeInfo->MaritalStatus |
string |
N |
Y |
Y |
Y |
legislativeInfo->MaritalStatusChangeDate |
date |
N |
Y |
Y |
Y |
legislativeInfo->PersonLegislativeId |
string |
N |
Y |
Y |
Y |
Worker Name Attributes |
|||||
names->CreatedBy |
string |
N |
Y |
N |
N |
names->CreationDate |
date-time |
N |
Y |
N |
N |
names->DisplayName |
string |
N |
Y |
Y |
Y |
names->EffectiveEndDate |
date |
N |
Y |
Y |
Y |
names->EffectiveStartDate |
date |
N |
Y |
Y |
Y |
names->FirstName |
string |
N |
Y |
Y |
Y |
names->FullName |
string |
N |
Y |
Y |
Y |
names->KnownAs |
string |
N |
Y |
Y |
Y |
names->LastName |
string |
N |
Y |
Y |
Y |
names->LastUpdateDate |
date-time |
N |
Y |
N |
N |
names->LastUpdatedBy |
string |
N |
Y |
N |
N |
names->LegislationCode |
string |
N |
Y |
Y |
Y |
names->ListName |
string |
N |
Y |
Y |
Y |
names->LocalCreatedBy |
string |
N |
Y |
N |
N |
names->LocalCreationDate |
date-time |
N |
Y |
N |
N |
names->LocalDisplayName |
string |
N |
Y |
Y |
Y |
names->LocalEffectiveEndDate |
date |
N |
Y |
Y |
Y |
names->LocalEffectiveStartDate |
date |
N |
Y |
Y |
Y |
names->LocalFirstName |
string |
N |
Y |
Y |
Y |
names->LocalFullName |
string |
N |
Y |
Y |
Y |
names->LocalKnownAs |
string |
N |
Y |
Y |
Y |
names->LocalLastName |
string |
N |
Y |
Y |
Y |
names->LocalLastUpdateDate |
date-time |
N |
Y |
N |
N |
names->LocalLastUpdatedBy |
string |
N |
Y |
N |
N |
names->LocalLegislationCode |
string |
N |
Y |
Y |
Y |
names->LocalListName |
string |
N |
Y |
Y |
Y |
names->LocalMiddleNames |
string |
N |
Y |
Y |
Y |
names->LocalNameLanguage |
string |
N |
Y |
Y |
Y |
names->LocalOrderName |
string |
N |
Y |
Y |
Y |
names->LocalPersonNameId |
string |
N |
Y |
Y |
Y |
names->LocalPreNameAdjunct |
string |
N |
Y |
Y |
Y |
names->LocalSuffix |
string |
N |
Y |
Y |
Y |
names->MiddleNames |
string |
N |
Y |
Y |
Y |
names->NameLanguage |
string |
N |
Y |
Y |
Y |
names->NameUID |
string |
N |
Y |
Y |
Y |
names->OrderName |
string |
N |
Y |
Y |
Y |
names->PersonNameId |
string |
N |
Y |
Y |
Y |
names->PreNameAdjunct |
string |
N |
Y |
Y |
Y |
names->Suffix |
string |
N |
Y |
Y |
Y |
names->Title |
string |
N |
Y |
Y |
Y |
Worker Other Communication Accounts Attributes |
|||||
otherCommunicationAccounts->AccountName |
string |
N |
Y |
N |
N |
otherCommunicationAccounts->CreatedBy |
string |
N |
Y |
N |
N |
otherCommunicationAccounts->CreationDate |
date-time |
N |
Y |
N |
N |
otherCommunicationAccounts->DeliveryMethodId |
string |
N |
Y |
N |
N |
otherCommunicationAccounts->EndDate |
date |
N |
Y |
N |
N |
otherCommunicationAccounts->LastUpdateDate |
date-time |
N |
Y |
N |
N |
otherCommunicationAccounts->LastUpdatedBy |
string |
N |
Y |
N |
N |
otherCommunicationAccounts->OtherCommunicationAccountUID |
string |
N |
Y |
N |
N |
otherCommunicationAccounts->Provider |
string |
N |
Y |
N |
N |
otherCommunicationAccounts->StartDate |
date |
N |
Y |
N |
N |
Worker Phone Attributes |
|||||
phones->AreaCode |
string |
N |
Y |
Y |
Y |
phones->CountryCodeNumber |
string |
N |
Y |
Y |
Y |
phones->CreatedBy |
string |
N |
Y |
N |
N |
phones->CreationDate |
date-time |
N |
Y |
N |
N |
phones->Extension |
string |
N |
Y |
Y |
Y |
phones->FromDate |
date |
N |
Y |
Y |
Y |
phones->LastUpdateDate |
date-time |
N |
Y |
N |
N |
phones->LastUpdatedBy |
string |
N |
Y |
N |
N |
phones->LegislationCode |
string |
N |
Y |
Y |
Y |
phones->PhoneId |
string |
N |
Y |
Y |
Y |
phones->PhoneNumber |
string |
N |
Y |
Y |
Y |
phones->PhoneType |
string |
N |
Y |
Y |
Y |
phones->PhoneUID |
string |
N |
Y |
Y |
Y |
phones->PrimaryFlag |
string |
N |
Y |
Y |
Y |
phones->ToDate |
date |
N |
Y |
Y |
Y |
Worker Religion Attributes |
|||||
religions->CreatedBy |
string |
N |
Y |
N |
N |
religions->CreationDate |
date-time |
N |
Y |
N |
N |
religions->LastUpdateDate |
date-time |
N |
Y |
N |
N |
religions->LastUpdatedBy |
string |
N |
Y |
N |
N |
religions->LegislationCode |
string |
N |
Y |
N |
N |
religions->PrimaryFlag |
string |
N |
Y |
N |
N |
religions->Religion |
string |
N |
Y |
N |
N |
religions->ReligionId |
string |
N |
Y |
N |
N |
religions->ReligionUID |
string |
N |
Y |
N |
N |
Worker VISA Permit Attributes |
|||||
visasPermits->CreatedBy |
string |
N |
Y |
N |
N |
visasPermits->CreationDate |
date-time |
N |
Y |
N |
N |
visasPermits->EffectiveEndDate |
date |
N |
Y |
N |
N |
visasPermits->EffectiveStartDate |
date |
N |
Y |
N |
N |
visasPermits->EntryDate |
date |
N |
Y |
N |
N |
visasPermits->ExpirationDate |
date |
N |
Y |
N |
N |
visasPermits->IssueDate |
date |
N |
Y |
N |
N |
visasPermits->IssuingAuthority |
string |
N |
Y |
N |
N |
visasPermits->IssuingCountry |
string |
N |
Y |
N |
N |
visasPermits->IssuingLocation |
string |
N |
Y |
N |
N |
visasPermits->LastUpdateDate |
date-time |
N |
Y |
N |
N |
visasPermits->LastUpdatedBy |
string |
N |
Y |
N |
N |
visasPermits->Profession |
string |
N |
Y |
N |
N |
visasPermits->VisaPermitCategory |
string |
N |
Y |
N |
N |
visasPermits->VisaPermitId |
string |
N |
Y |
N |
N |
visasPermits->VisaPermitNumber |
string |
N |
Y |
N |
N |
visasPermits->VisaPermitStatus |
string |
N |
Y |
N |
N |
visasPermits->VisaPermitStatusDate |
date |
N |
Y |
N |
N |
visasPermits->VisaPermitType |
string |
N |
Y |
N |
N |
visasPermits->VisasPermitUID |
string |
N |
Y |
N |
N |
Worker Descriptive Flexfields |
|||||
workersDFF->__FLEX_Context |
string |
N |
Y |
N |
N |
workersDFF->__FLEX_Context_DisplayValue |
string |
N |
Y |
N |
N |
workersDFF->PersonId |
string |
N |
Y |
N |
N |
workersDFF->WorkersDFFUID |
string |
N |
Y |
N |
N |
workersEFF->CategoryCode |
string |
N |
Y |
N |
N |
workersEFF->PersonId |
string |
N |
Y |
N |
N |
workersEFF->WorkersEFFUID |
string |
N |
Y |
N |
N |
Worker Work Relationships Attributes |
|||||
workRelationships->assignments->ActionCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentCategory |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentName |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentNumber |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentStatusType |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentStatusTypeCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentStatusTypeId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentType |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->AssignmentUID |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->BargainingUnitCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->BusinessUnitId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->BusinessUnitName |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->CollectiveAgreementId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->CollectiveAgreementName |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->CreatedBy |
string |
N |
Y |
N |
N |
workRelationships->assignments->CreationDate |
date-time |
N |
Y |
N |
N |
workRelationships->assignments->DefaultExpenseAccount |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->DepartmentId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->DepartmentName |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->EffectiveEndDate |
date |
N |
Y |
Y |
Y |
workRelationships->assignments->EffectiveLatestChange |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->EffectiveSequence |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->EffectiveStartDate |
date |
N |
Y |
Y |
Y |
workRelationships->assignments->EndTime |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ExpenseCheckSendToAddress |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->Frequency |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->FullPartTime |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->GradeCeilingStep |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->GradeCeilingStepId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->GradeCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->GradeId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->GradeLadderId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->GradeLadderName |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->GradeStepEligibilityFlag |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->HourlySalariedCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->InternalBuilding |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->InternalFloor |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->InternalMailstop |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->InternalOfficeNumber |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->JobCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->JobId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->LabourUnionMemberFlag |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->LastUpdateDate |
date-time |
N |
Y |
N |
N |
workRelationships->assignments->LastUpdatedBy |
string |
N |
Y |
N |
N |
workRelationships->assignments->LocationCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->LocationId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ManagerFlag |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->NormalHours |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->NoticePeriod |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->NoticePeriodUOM |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->PeopleGroup |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->PermanentTemporary |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->PositionCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->PositionId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->PrimaryAssignmentFlag |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->PrimaryFlag |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ProbationEndDate |
date |
N |
Y |
Y |
Y |
workRelationships->assignments->ProbationPeriod |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ProbationPeriodUnit |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ProjectedEndDate |
date |
N |
Y |
Y |
Y |
workRelationships->assignments->ProjectedStartDate |
date |
N |
Y |
Y |
Y |
workRelationships->assignments->ProposedUserPersonType |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ProposedUserPersonTypeId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ReasonCode |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ReportingEstablishmentId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->ReportingEstablishmentName |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->RetirementAge |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->RetirementDate |
date |
N |
Y |
Y |
Y |
workRelationships->assignments->SeniorityBasis |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->StartTime |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->SynchronizeFromPositionFlag |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->SystemPersonType |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->UnionId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->UnionName |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->UserPersonType |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->UserPersonTypeId |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->WorkAtHomeFlag |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->WorkerCategory |
string |
N |
Y |
Y |
Y |
workRelationships->assignments->WorkTaxAddressId |
string |
N |
Y |
Y |
Y |
workRelationships->CreatedBy |
string |
N |
Y |
N |
N |
workRelationships->CreationDate |
date-time |
N |
Y |
N |
N |
workRelationships->EnterpriseSeniorityDate |
date |
N |
Y |
Y |
Y |
workRelationships->LastUpdateDate |
date-time |
N |
Y |
N |
N |
workRelationships->LastUpdatedBy |
string |
N |
Y |
N |
N |
workRelationships->LastWorkingDate |
date |
N |
Y |
Y |
Y |
workRelationships->LegalEmployerName |
string |
N |
Y |
Y |
Y |
workRelationships->LegalEmployerSeniorityDate |
date |
N |
Y |
Y |
Y |
workRelationships->LegalEntityId |
string |
N |
Y |
Y |
Y |
workRelationships->LegislationCode |
string |
N |
Y |
Y |
Y |
workRelationships->NotificationDate |
date |
N |
Y |
Y |
Y |
workRelationships->OnMilitaryServiceFlag |
string |
N |
Y |
Y |
Y |
workRelationships->PeriodOfServiceId |
string |
N |
Y |
Y |
Y |
workRelationships->PrimaryFlag |
string |
N |
Y |
Y |
Y |
workRelationships->ReadyToConvertFlag |
string |
N |
Y |
Y |
Y |
workRelationships->RecommendationAuthorizedByPersonId |
string |
N |
Y |
Y |
Y |
workRelationships->RecommendationReason |
string |
N |
Y |
Y |
Y |
workRelationships->RecommendedForRehire |
string |
N |
Y |
Y |
Y |
workRelationships->RevokeUserAccess |
string |
N |
Y |
Y |
Y |
workRelationships->StartDate |
date |
N |
Y |
Y |
Y |
workRelationships->TerminationDate |
date |
N |
Y |
Y |
Y |
workRelationships->WorkerNumber |
string |
N |
Y |
Y |
Y |
workRelationships->WorkerType |
string |
N |
Y |
Y |
Y |
workRelationships->WorkRelationshipUID |
string |
N |
Y |
Y |
Y |
National Id Support
Expor, Lookup and Import of National Id attributes are not supported by default in the Oracle HCM connector. This is done to make sure that National Id attributes management is not enabled by default in a Provisioning server hosted in the cloud. On-Premise customers can enable this feature by doing the below steps.
Add JVM Parameter
First step is to provide a JVM parameter with the name ORACLE_HCM_NATIONAL_ID_ENABLED and a value of true when the Provisioning server is started.
This can done by editing tomcat catalina.bat and providing the below line.
set "JAVA_OPTS=%JAVA_OPTS% -DORACLE_HCM_NATIONAL_ID_ENABLED=true"
If tomcat is to be run as a service, this has to be configured before installing the tomcat service. Adding the below line in service.bat before installing the tomcat service will include this JVM parameter when tomcat service is started.
set "JvmArgs=%JvmArgs%-DORACLE_HCM_NATIONAL_ID_ENABLED=true"
Enable National Id Support at Connected System Level
Once the JVM parameter is added and restarted Provisioning server and Studio, there will be the Enable National Id Support connected system parameter to turn on this feature.
National Id Attributes
Following are the National Id attributes in Employee data format.
Name |
Type |
MV |
Export |
Add |
Modify |
National Id Attributes |
|||||
NationalId |
string |
N |
Y |
Y |
Y |
NationalIdCountry |
string |
N |
Y |
Y |
Y |
NationalIdExpirationDate |
date |
N |
Y |
Y |
Y |
NationalIdType |
string |
N |
Y |
Y |
Y |
Passport Attributes |
|||||
PassportExpirationDate |
date |
N |
Y |
Y |
Y |
PassportId |
string |
N |
Y |
Y |
Y |
PassportIssueDate |
date |
N |
Y |
Y |
Y |
PassportIssuingCountry |
string |
N |
Y |
Y |
Y |
PassportNumber |
string |
N |
Y |
Y |
Y |
Following are the National Id attributes in Worker data format.
Name |
Type |
MV |
Export |
Add |
Modify |
National Id Attributes |
|||||
nationalIdentifiers->CreatedBy |
string |
N |
Y |
N |
N |
nationalIdentifiers->CreationDate |
date |
N |
Y |
N |
N |
nationalIdentifiers->ExpirationDate |
date |
N |
Y |
N |
N |
nationalIdentifiers->IssueDate |
date |
N |
Y |
N |
N |
nationalIdentifiers->LastUpdateDate |
date |
N |
Y |
N |
N |
nationalIdentifiers->LastUpdatedBy |
string |
N |
Y |
N |
N |
nationalIdentifiers->LegislationCode |
string |
N |
Y |
N |
N |
nationalIdentifiers->NationalIdentifierId |
string |
N |
Y |
N |
N |
nationalIdentifiers->NationalIdentifierNumber |
string |
N |
Y |
N |
N |
nationalIdentifiers->NationalIdentifierType |
string |
N |
Y |
N |
N |
nationalIdentifiers->NationalIdentifierUID |
string |
N |
Y |
N |
N |
nationalIdentifiers->PlaceOfIssue |
string |
N |
Y |
N |
N |
nationalIdentifiers->PrimaryFlag |
string |
N |
Y |
N |
N |
Passport Attributes |
|||||
passports->CreatedBy |
string |
N |
Y |
N |
N |
passports->CreationDate |
date |
N |
Y |
N |
N |
passports->ExpirationDate |
date |
N |
Y |
N |
N |
passports->IssueDate |
date |
N |
Y |
N |
N |
passports->IssuingAuthority |
string |
N |
Y |
N |
N |
passports->IssuingCountry |
string |
N |
Y |
N |
N |
passports->IssuingLocation |
string |
N |
Y |
N |
N |
passports->LastUpdateDate |
date |
N |
Y |
N |
N |
passports->LastUpdatedBy |
string |
N |
Y |
N |
N |
passports->PassportId |
string |
N |
Y |
N |
N |
passports->PassportNumber |
string |
N |
Y |
N |
N |
passports->PassportType |
string |
N |
Y |
N |
N |
passports->PassportUID |
string |
N |
Y |
N |
N |
passports->Profession |
string |
N |
Y |
N |
N |
Entitlement Support
This connector supports static entitlements in the form of Roles and Attributes. Entitlements are configured from the Admin UI ► Server ► Resources. See the Resource Management chapter in the Identity Suite Administration Guide for details on resources.
To configure entitlements:
- On the Resource Detail page, under Entitlement Options, click Add Static Entitlement and select the Type (Role or Attribute) for the entitlement.
-
Enter a desired Name, Value (existing Role or Attribute within the OracleHCM system), and a Description, for example:
To view entitlements that have been provisioned for existing users
- From the Admin UI ► Users ► Search Users to Modify ► Profile View for a user ► User Access View page, expand the plus sign for an OracleHCM account. All entitlements associated for the user are listedLog in to the Workflow and Connectivity Studio and double-click the Data Mapper object on the Design The Configure Data Mapper window displays.
Lookup Data
To lookup data from Oracle HCM, use the Data Mapper rule Lookup Data.
-
Log in to the Workflow and Connectivity Studio and double-click the Data Mapper object on the Design The Configure Data Mapper window displays.
-
Select the Lookup Data rule under the Mapping Rule column, and then click the Source Value. The Configure Lookup window displays.
-
Select the Oracle HCM system from the Select System drop-down list:
- In the Enter Lookup Prefix field, enter the prefix to be added to the Lookup fields.
- Select the Lookup Type from the drop-down list.
-
For Employee lookup, select By Employee UID or By Filter option.
For Employee By Employee UID lookup, click the Employee UID Pick button to select the Employee ID input attribute and click OK.
-
For Employee By Filter lookup, click the Build button along the Filter and build a filter to use for lookup and click OK.
- Click the Fields Pick button to select the attributes to be fetched after a successful lookup.
- Select the Exit as Mapper Task Failed on Lookup Failure check box to exit the task with Failed status on lookup failure. It will not process the succeeding entries and will ignore the already processed entries and will not return any data. This is selected by default.
Click OK.