Example of Loading Non-Recurring Element Entries
You can use HCM Data Loader to load non-recurring element entries. The application creates the non-recurring element entries for a specific period, usually the payroll period.
When you create element entry for non-recurring elements,
you must increment the value of MultipleEntryCount for each entry of the same assignment and element.
Example: Lynda Jones with assignment number E3141464
already has an element entry for Transportation Allowance of $30 in
the semi-monthly payroll period 01-Oct-2020 to 15-Oct-2020. The MultipleEntryCount for this entry is 1.
If you load the Transportation Allowance for Lynda,
you need to increment the MultipleEntryCount for the next records.
Let's consider this scenario. Lynda Jones has traveled from corporate office to project site on 10-Oct-2020 and 12-Oct-2020. She must be paid a transportation allowance of $40 and $50 respectively.
Note that the two dates 10-Oct-2020 and 12-Oct-2020 fall within the same payroll period from 01-Oct-2020 to 15-Oct-2020.
Load the element entry details for 10-Oct-2020, as shown in this table:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
10-Oct-2020 |
|
MultipleEntryCount |
2 |
Load the element entry values for 10-Oct-2020, as shown in these tables:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
10-Oct-2020 |
|
Input Value Name |
Amount |
|
Screen Entry Value |
40 |
Load the element entry details for 12-Oct-2020, as shown in this table:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
10-Oct-2020 |
|
MultipleEntryCount |
3 |
Load the element entry values for 12-Oct-2020, as shown in these tables:
|
Attribute |
Value |
|---|---|
|
Legislative Data Group |
Vision Corp |
|
Element Name |
Transportation Allowance |
|
Assignment Number |
E3141464 |
|
Start Date |
12-Oct-2020 |
|
Input Value Name |
Amount |
|
Screen Entry Value |
50 |
The ElementEntry.dat file creates the element entry values.
METADATA|ElementEntry|CreatorType|EffectiveStartDate|ElementName|LegislativeDataGroupName|EntryType|AssignmentNumber|MultipleEntryCount
MERGE|ElementEntry|F|2020/10/10|Transportation Allowance|Vision Corp|E|E3141464|2
MERGE|ElementEntry|F|2020/10/12|Transportation Allowance|Vision Corp|E|E3141464|3
METADATA|ElementEntryValue|EffectiveStartDate|ElementName|LegislativeDataGroupName|InputValueName|ScreenEntryValue|AssignmentNumber|MultipleEntryCount|EntryType
MERGE|ElementEntryValue|2020/10/10|Transportation Allowance|Vision Corp|Overridden Pay Value|40|E3141464|2|E
MERGE|ElementEntryValue|2020/10/12|Transportation Allowance|Vision Corp|Overridden Pay Value|50|E3141464|3|E