Bulk Load Individual Earnings/Deductions {FPRI-10}

This option may be used to load Individual Earnings/Deductions {FPRI-2} from a comma-delimited file.

This program allows the importing of Individual Transactions with Calculation Methods 3 (Advised amount), 8 (Qty x Amount) and E (Overtime hours)

  Calculation Method 3 (Advised Amount)

·       Column 10 (Mandatory), the value (amount), written to Field 1

·       Column 11, null

·       Column 12, null

Calculation Method 8 (Qty x Amount)

·       Column 10 (Mandatory), the rate/amount (that will multiplied by the Quantity), written to Field 1

·       Column 11, null

·       Column 12 (Mandatory), the quantity, written to Field 5

Calculation Method E

·       Column 10 (Optional, required if maximum overtime rate is to be used by defining a threshold), written to Field 1

·       Column 11 (Optional, Reference Salary level)

·       Column 12 (Mandatory), the quantity, written to Field 5

·       Please Note: The population of Field 6 (Rate %), is retrieved from the ED Code definition {FPRG-6}

• The file should not have column headings.
• Each Individual Earning/Deduction should be on a single row.
• The columns, in order, of the comma delimited file is as follows
• All columns are mandatory even if the value is null

Output:

• Procedures 
• None