Example of Loading Costing Eligibility on Assignment Attributes

Use the HCM Data Loader to assign costing information at the costing eligibility on assignment attributes. Use this functionality to create the cost account information for payroll relationship elements using assignment attributes criteria, such as department, people group, or job.

Before loading the costing eligibility on assignment attributes for an element, it must have the costing defined on regular element with distributed costing type.

Example

Let's say, the Payroll Manager of the Vision Corp organization wants to set up costing for the Employer Union Pension Charges element, which is defined at payroll relationship level, to be costed to Natural Account 2601 for Payroll department and 2602 for Production department. Since the Department eligibility criteria isn't available for payroll relationship elements, you must use Costing Eligibility on Assignment Attributes functionality to create the costing information. Before you load the costing information on assignment attributes, you must first define or load the regular costing eligibility with no criteria (open link) and distributed costing type.

Note: The cost account is only applicable for costing eligibility on assignment attributes. The offset account is used from the regular costing eligibility defined with distributed costing.

Use the Element Eligibility object with CostingLinkFlag set to Y to load the costing eligibility on assignment attributes.

Parameter	Value
Element Eligibility Name	Employer_Union_Pension_Charges_CostingEligib_PAYR
Department Code	UTILITIES_DEPT

Parameter	Value
Element Eligibility Name	Employer_Union_Pension_Charges_CostingEligib_PROD
Department Code	PRODUCTION_DEPT

METADATA|ElementEligibility|ElementId|ElementLinkId|EffectiveStartDate|EffectiveEndDate|CalculationFormulaId|LegislativeDataGroupId|ElementEligibilityName|ValidationFormulaId|DefaultingFormulaId|AutomaticEntryFlag|EmploymentCategory|BargainingUnitCode|LabourUnionMemberFlag|AllPayrollsEligibleFlag|ElementCode|LegislativeDataGroupName|CollectiveAgreementIdCode|DepartmentCode|RelationshipTypeCode|CalculationFormulaCode|ValidationFormulaCode|JobCode|DefaultingFormulaCode|GradeCode|PayrollStatUnitCode|LegalEmployerCode|LocationCode|PayrollCode|PositionCode|JobSetCode|GradeSetCode|LocationSetCode|JobId|GradeId|LocationId|PayrollId|PayrollStatUnitId|LegalEmployerId|PositionId|SourceSystemOwner|SourceSystemId|GUID|RelationshipTypeId|CollectiveAgreementId|OrganizationId|PeopleGroup|CostingLinkFlag
MERGE|ElementEligibility|||2014/01/01|4712/12/31|||Employer_Union_Pension_Charges_CostingEligib_PAYR||Employer Union Pension Charges|CRFL RRF LDG US1||UTILITIES_DEPT|Y
MERGE|ElementEligibility|||2014/01/01|4712/12/31|||Employer_Union_Pension_Charges_CostingEligib_PROD||Employer Union Pension Charges|CRFL RRF LDG US1||PRODUCTION_DEPT||Y

Load these cost account values for segments for the element eligibility on costing attributes.

Parameter	Value
Element Eligibility	Employer_Union_Pension_Charges_CostingEligib_PAYR
Account (Segment 4)	2601

Parameter	Value
Element Eligibility	Employer_Union_Pension_Charges_CostingEligib_PROD
Account (Segment 4)	2602

Here's the sample dat file to load Cost Allocation.

METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType|ElementEligibilityName|DepartmentName|JobCode|PositionCode|SetCode|PayrollCode|PaymentSourceCode|Name|AssignmentNumber|PayrollRelationshipNumber|TermNumber|ElementCode|MultipleEntryCount|LegislativeDataGroupName|GUID|SourceSystemId|SourceSystemOwner|AssignmentId(SourceSystemId)|PayrollId(SourceSystemId)|PaymentMethodId(SourceSystemId)|ElementEntryId(SourceSystemId)|ElementLinkId(SourceSystemId)|OrganizationId(SourceSystemId)|JobId(SourceSystemId)|PositionId(SourceSystemId)|OrganizationPaymentMethodCode|BusinessUnitName|EntryType
MERGE|CostAllocationV3|4712/12/31|2014/01/01|EL|Employer_Union_Pension_Charges_CostingEligib_PAYR||Employer Union Pension Charges||CRFL RRF LDG US1||
MERGE|CostAllocationV3|4712/12/31|2014/01/01|EL|Employer_Union_Pension_Charges_CostingEligib_PROD||Employer Union Pension Charges||CRFL RRF LDG US1||

Here's the sample dat file to load Cost Allocation Account.

METADATA|CostAllocationAccountV3|SourceType|ElementEligibilityName|DepartmentName|JobCode|PositionCode|SetCode|PaymentSourceCode|PayrollCode|Name|AssignmentNumber|PayrollRelationshipNumber|TermNumber|ElementCode|MultipleEntryCount|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment|Segment1|Segment2|Segment3|Segment4|Segment5|GUID|SourceSystemId|SourceSystemOwner|AssignmentId(SourceSystemId)|PayrollId(SourceSystemId)|PaymentMethodId(SourceSystemId)|ElementEntryId(SourceSystemId)|ElementLinkId(SourceSystemId)|OrganizationId(SourceSystemId)|JobId(SourceSystemId)|PositionId(SourceSystemId)|OrganizationPaymentMethodCode|BusinessUnitName|EntryType
MERGE|CostAllocationAccountV3|EL|Employer_Union_Pension_Charges_CostingEligib_PAYR||Employer Union Pension Charges||CRFL RRF LDG US1|2014/01/31|COST|1|1|||2601||
MERGE|CostAllocationAccountV3|EL|Employer_Union_Pension_Charges_CostingEligib_PROD||Employer Union Pension Charges||CRFL RRF LDG US1|2014/01/31|COST|1|1|||2602||