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