1. HCM Data Loading Business Objects
  2. Example of Loading Element Eligibility Costing

Example of Loading Element Eligibility Costing

Use HCM Data Loader to assign costing information at the element level. You cost the element's eligibility records when the results for the element affect net pay or employer liabilities.

When costing an element, you specify the values to cost, the type of costing to use, and then you offset the cost entries.

You can load the priority account that specifies the accounting at the element level. For example, your company funds the entire hourly earning element for work performed in a lab from a single account. In such a case, you can create a priority account and specify 100 for the percentage.

Let's suppose you cost a value for the same segment at higher levels in the costing hierarchy. In this case, though the value is defined at the element eligibility level, the application considers the higher segment value.

Example

The Payroll Manager of the Vision Corp organization wants to set up costing for the Employer Union Pension Expense element and distribute its costs to the earning elements of a distribution group.

Before You Begin

Before loading element costing, ensure that you do these steps:

  1. Set up the Cost Allocation key flexfield.

  2. Create costing for element eligibility records for each of the pensionable earnings elements, such as the regular wages and overtime wages.

  3. Create the distribution group, Pensionable Wages that carries the costs of the distributed element. This group includes the employee's wage elements.

After setting up these prerequisites, you cost the employer portion of the pension liability by creating an Employer Union Pension Expense element.

For Distributed costing types, the calculation for distributed costing starts with the values loaded in the element eligibility costing record. The calculation derives values for other segments from the costing values on the associated entries of the distribution group. Further, it generates one costing result for each entry in the distribution group. Finally, you transfer the costing entries for the payroll run results to the General Ledger.

This figure shows how you cost details for an element.

This figure shows you how to cost details for an element. You set up the cost allocation key flexfield, create costing for element eligibility records, and then create a distribution group. You create the element and later transfer costing entries to general ledger.

Load these details for the Employer Union Pension Expense element:

Parameter

Value

Costing Type

Distributed

Transfer to General Ledger

Yes

Distribution Group

Pensionable Wages

Costed Input Value

Pay Value

Costed

Yes

When you're loading costing details for element eligibility, you must specify the costed input values. 

METADATA|CostInfoV3|EffectiveEndDate|EffectiveStartDate|SourceType|ElementEligibilityName|ElementCode|LinkInputName|LegislativeDataGroupName|CostableType|CostedFlag|TransferToGlFlag
MERGE|CostInfoV3|4712/12/31|2015/01/01|EL|Employer Union Pension Expense|Employer Union Pension Expense||Vision_Corp_LDG|F||N
MERGE|CostInfoV3|4712/12/31|2015/01/01|LIV|Employer Union Pension Expense|Employer Union Pension Expense|Pay Value|Vision_Corp_LDG||Y|
METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType|ElementEligibilityName|ElementCode|LegislativeDataGroupName
MERGE|CostAllocationV3|4712/12/31|2015/01/01|EL|Employer Union Pension Expense|Employer Union Pension Expense|Vision_Corp_LDG

Load these cost account values for segments that you don't want the costing calculation to derive from distributed costing:

Parameter

Value

Fund (Segment3)

5220 Employer Union Pension Expense account

Appropriation (Segment 4)

1001

Funding Source (Segment 5)

1010

Load these values for segments in Offset Accounts. Here, the offset account is the payable liability account, and the balance sheet account numbers are for the Division and Department segments:

Parameter

Value

Division (Segment1)

00

Department (Segment2)

000

Natural Account (Segment6)

2152

 
METADATA|CostAllocationAccountV3|SourceType|ElementEligibilityName|ElementCode|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment|Segment3|Segment4|Segment5 MERGE|CostAllocationAccountV3|EL|Employer Union Pension Expense|Employer Union Pension Expense|Vision_Corp_LDG |2015/01/01|BAL|1|1|00.000....2152||| MERGE|CostAllocationAccountV3|EL|Employer Union Pension Expense|Employer Union Pension Expense|Vision_Corp_LDG |2015/01/01|COST|1|1||5220|1001|1010

Related Topics