Example of Loading Person Costing at Payroll Relationship Level

Let's consider this example where you cost Vijay's elements to the Special Revenue Fund. When you define the costs at the payroll relationship level, you need not define the costs at each element level for these segments.

Load these details to allocate costs for Vijay (Payroll Relationship Number: 12345678) at the payroll relationship level.

Parameter

Value

Percentage

100

Fund (Segment1)

Special Revenue Fund (1100)

Appropriation (Segment2)

Salary Appropriation (1002)

Funding Source (Segment3)

2000

Department (Segment4)

2000

Organization (Segment5)

Payroll (1003)

This example dat file loads the costing details for the person at the payroll relationship level.

METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType|PayrollRelationshipNumber|LegislativeDataGroupName
MERGE|CostAllocationV3|4712/12/31|2010/01/01|PREL|12345678|Vision Corp
METADATA|CostAllocationAccountV3|SourceType|PayrollRelationshipNumber|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|Segment1|Segment2|Segment3|Segment4|Segment5
MERGE|CostAllocationAccountV3|PREL|12345678|Vision Corp|2010/01/01|COST|1|1|1100|1002|2000|2000|1003