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

1. In the Setup and Maintenance work area, navigate to:

   • Offering: Workforce Deployment

   • Functional Area: Organization Structures

   • Task: Manage Extensible Flexfields

2. Search for the Organization Information EFF and click Edit.

3. Click Manage Contexts.

4. Click Create and create two contexts: HCM_CN_TRU_TERMINATION_INFO and HRX_CN_PSU_TERMINATION_INFO.

5. For each context, create two segments: LEAVE_COMPENSATION_FACTOR and MONTHLY_SALARY_PAID_DAYS.

6. Deploy the flexfield.

Submit the Generate Flexfield Database Process

1. In the Payroll Checklists or Payroll Administration work area, select the Submit a Process or Report task.

2. 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.

3. Click Next and skip the Enter Interaction page.

4. Click Next and skip the Schedule page.

5. Click Next and review the submitted parameters on the Review page.

6. 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

1. 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.