Example of Loading Costing of Jobs

Use HCM Data Loader to define payroll costs based upon the job category, such as cost centers or project funds. Let's assume that you want to compare cost results for jobs in different cost centers.

Then, you allocate costs at the job level to generate the cost results based on the job.

You can load cost account segments to override those segments defined at other levels. If you divide costs among accounts, you can specify the percentage each account receives of the cost. If the total allocation isn't 100 percent, then the application places the costs that aren't allocated to a default account.

Example

Assume that you want to cost accounts to store expenses and employer liabilities and charges for the job Senior Manager.

This table shows the job details that you want to cost for the employee.

Parameter

Value

Percentage

100

Fund (Segment1)

Pooled Cash Fund: 0900

Appropriation (Segment2)

1001

Use these dat files to load the cost segments for the job Senior Manager:

METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType|JobCode|SetCode|LegislativeDataGroupName
MERGE|CostAllocationV3|4712/12/31|2010/01/01|JOB|Senior Manager|COMMON|Vision Corp
METADATA|CostAllocationAccountV3|SourceType|JobCode|SetCode|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|Segment1|Segment2
MERGE|CostAllocationAccountV3|JOB|Senior Manager|COMMON|Vision Corp|2010/0101|COST|1|0900|1001