Example of Generating Flexfield Database Items
Let's look at an example that shows you how to add segments and contexts to a registered HCM flexfield, and how to generate database items for the flexfield for later use in formulas and extracts.
Here are the key decisions when deciding on the HCM flexfields and contexts that require database items.
Decisions to Consider |
In this Example |
---|---|
Which registered HCM flexfield requires database items? |
Organization Information flexfield |
What is the name of the flexfield code? |
PER_ORGANIZATION_INFORMATION_EFF |
How many contexts include segments that require database items? |
Two contexts: HCM_CN_PSU_TERMINATION_INFO, HRX_CN_TRU_TERMINATION_INFO |
Should I give all legislative data groups access to the generated database items, so that they can use them in their formulas and extracts? |
Yes |
In this example, Joe plans to create formulas for an implementation in China based on information captured in the organization information flexfield. Joe configures the flexfield to add the contexts and segments. He writes a formula to calculate severance pay that returns results for the leave compensation factor based on the tax reporting unit.
Configure the Flexfield
-
In the Setup and Maintenance work area, navigate to:
-
Offering: Workforce Deployment
-
Functional Area: Organization Structures
-
Task: Manage Extensible Flexfields
-
-
Search for the Organization Information EFF and click Edit.
-
Click Manage Contexts.
-
Click Create and create two contexts: HCM_CN_TRU_TERMINATION_INFO and HRX_CN_PSU_TERMINATION_INFO.
-
For each context, create two segments: LEAVE_COMPENSATION_FACTOR and MONTHLY_SALARY_PAID_DAYS.
-
Deploy the flexfield.
Submit the Generate Flexfield Database Process
-
In the Payroll Checklists or Payroll Administration work area, select the Submit a Process or Report task.
-
Complete the following parameters.
This table lists which parameters you can skip and those that you can complete, and where the parameter is displayed.Page
Parameter
Data
Select Flow Pattern
Legislative Data Group
Skip this parameter
Select Flow Pattern
Process or Report
Generate Flexfield Database Items
Enter Parameters
Payroll Flow
Organization flexfield database items
Enter Parameters
Name
PER_ORGANIZATION_INFORMATION_EFF
Enter Parameters
Context
Skip this field to generate database items for all contexts.
-
Click Next and skip the Enter Interaction page.
-
Click Next and skip the Schedule page.
-
Click Next and review the submitted parameters on the Review page.
-
Click Submit to create the payroll flow.
The submitted process creates database items for each context for the flexfield segments:
-
PER_ORGANIZATION_INFORMATION_HRX_CN_TRU_TERMINATION_LEAVE_COMPENSATION_FACTOR
-
PER_ORGANIZATION_INFORMATION_HRX_CN_TRU_TERMINATION_MONTHLY_SALARY_PAID_DAYS
-
PER_ORGANIZATION_INFORMATION_HRX_CN_PSU_TERMINATION_LEAVE_COMPENSATION_FACTOR
-
PER_ORGANIZATION_INFORMATION_HRX_CN_PSU_TERMINATION_MONTHLY_SALARY_PAID_DAYS
-
Create a Formula
-
Create a formula for calculating severance pay that returns a segment for LEAVE_COMPENSATION_FACTOR, if the context code is the one specified for the database item, HRX_CN_TRU_TERMINATION_INFO.