Example of Loading Multiple Occurrences of the Same Element Entry in the Same Time Period
Bob traveled from his work location to client's office on 04-Jun-2019 and 11-Jun-2019 for meetings with clients. He is reimbursed 40 and 50 respectively as Transport Fare along with his salary on 15-Jun-2019.
The first reimbursement of 40 should go to the cost center 100 and the second reimbursement of 50 should go to the cost center 200. He is a as part of the semi-monthly payroll processing cycle.
Using HCM Data Loader, load these element entry values. This is the first occurrence of the element entry and the CreateEntrySequence attribute will have value 1.
This table shows the first element entry value along with costing details:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
04-Jun-2019 |
|
End Date |
04-Jun-2019 |
|
Cost Center |
100 |
This table shows the element entry values to load:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
04-Jun-2019 |
|
End Date |
04-Jun-2019 |
|
Input Value Name |
Amount |
|
Screen Entry Value |
40 |
This table shows the second element entry value along with costing details:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
11-Jun-2019 |
|
End Date |
11-Jun-2019 |
|
Cost Center |
200 |
This table shows the element entry values to load:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
11-Jun-2019 |
|
End Date |
11-Jun-2019 |
|
Input Value Name |
Amount |
|
Screen Entry Value |
50 |
This ElementEntryWithCosting.dat file creates multiple element entries, entry values along with the costing information.
METADATA|ElementEntryWithCosting|EffectiveEndDate|EffectiveStartDate|ElementEntryId|ElementTypeId|ElementName|AssignmentId(SourceSystemId)|AssignmentNumber|Reason|Subpriority|EntryType|CreateEntrySequence|SourceSystemOwner|SourceSystemId|InputValueName1|InputValueName2|InputValueName3|InputValueName4|InputValueName5|ScreenEntryValue1|ScreenEntryValue2|ScreenEntryValue3|ScreenEntryValue4|ScreenEntryValue5|Segment1|Segment2|Segment3|Segment4|Segment5|Segment6|Segment7|Segment8
MERGE|ElementEntryWithCosting|2019/06/04|2019/06/04|||Transportation Allowance||E3141464|||E|1|||Amount|||||40||||||||100||||
MERGE|ElementEntryWithCosting|2019/06/11|2019/06/11|||Transportation Allowance||E3141464|||E|2|||Amount|||||50||||||||200||||