image

Import Style #61 Lieu Days Taken

Import Style Specifications

image  Overview

image  Style #61 Alternative Days Taken

image  Basic Generic Import

image  Style #62 Public Holidays

image  Style #15 Add New Employee

image  Style #63 Bereavement Leave

image  Style #50 Hours Worked and Departments

image  Style #70 Holiday Pay

image  Style #51 Allowances and Deductions

image  Style #89 Delete File After Import

image  Style #52 Hours Worked & Pay Rate

image  Style #99 User Interface Customisation

image  Style #60 Sick and Special Leave

image  Inserting Comments

Style #61 Lieu Days Taken

When an employee takes days in lieu, there are four considerations. These are

    Entitlement - Does the employee have any lieu days owing to them? Amount Of Payment - An employee may be paid based in hours and an hourly
  • rate, a daily rate, or a specific amount decided by the user.
  • Reduction Of Entitlement - Having paid the employee for lieu days taken,
  • by how many days is their entitlement to be reduced?
  • Additional Details - Many users like to record a brief reason for lieu days
  • taken, and a field is provided for this reason.

When importing data from an external source for lieu days taken, each of the above is considered.



Lieu days taken may be imported to Ace Payroll by adding a line within the generic import file. The line contains a maximum of 8 fields, as follows

#61, Employee ID, Entitlement, Hours Paid, Hourly Rate, Amount Paid, Days Taken, Reason

The specification for lieu days taken is identical to that for sick and special leave, apart from fields 1 and 3.



Field 1. Style
For lieu days taken, this is always #61.

Field 2. Employee ID
Up to 5 characters identifying the employee, as identified by Ace Payroll. This field is always validated, and import will not proceed if this field does not identify a valid employee.

Field 3. Entitlement
Currently, this field is either left blank, or contains a zero. The data contained in the line is always imported irrespective of whether the employee has any lieu days owing.

The specifications for this field may be enhanced at a later date, to allow the importation of lieu days taken based on the employee eligibility, by the import file specifying a value other than zero or a null field.

The value of this field is currently not validated, but the field must exist. It must be either blank, or contain a zero.

Field 4. Hours Paid
This field is optional. If used, payment will be made to the employee based on the number of hours in the field, multiplied by an hourly rate.

Field 5. Hourly Rate
This field is optional, and is only relevant if a value exists in the previous field. If both fields exists, the employee is paid by multiplying the values together.

If this field is blank, and a value exists in the hours paid field, the employee is paid using the value of their first pay rate used.

Field 6. Amount Paid
This field is optional, and is only used if the hours paid field is either zero, or blank. If so, the amount in this field is paid as the total dollar amount.

Note: It is permissable for fields 4, 5 and 6 to all be blank. This is

done if the purpose of the import is to reduce an employee entitlement, without making specific payment for it. This could be done if an employee is paid by salary, and the user prefers to leave the salary payment untouched.

Field 7. Entitlement Reduction
This field is optional, and if used contains the number of days by which an employee's entitlement is to be reduced. Note that by leaving this field blank, it is possible to pay an employee for leave without reducing their entitlement.

Field 8. Reason
This field is optional, and contains up to 25 characters decribing the leave entry. If the field is either blank, or does not exist, the reason is shown as "imported data".

Examples

#61,JS,0,8 - this line pays employee JS for 8 hours leave, at the rate of their first pay rate used. No adjustment is made to the employee entitlement, and the reason is shown as "imported data".

#61,JS,0,8,12.75 - this line pays employee JS for 8 hours leave,

at the rate of $12.75 an hour. No adjustment is made to the employee entitlement, and the reason is shown as "imported data".

#61,JS,0,0,0,115.75 - this line pays employee JS $115.75 for leave

taken. No adjustment is made to the employee entitlement, and the reason is shown as "imported data".

#61,JS,0,0,0,115.75,1.25,"took easter days" - this line pays employee JS $115.75

for days in lieu taken, and reduces their entitlement by 1.25 days. The reason is shown as "took easter days".

#61,JS,0,0,0,0,1.25,"took easter days" - this line does not pay the employee any

amount, but reduces their entitlement by 1.25 days. The reason is shown as "took easter days".

#61,JS,0,22,0,0,2.75,"took easter days" - this line pays the employee 22 hours at

their first pay rate used, and reduces their entitlement by 2.75 days. The reason is shown as "took easter days".

Import Style Specifications

image  Overview

image  Style #61 Alternative Days Taken

image  Basic Generic Import

image  Style #62 Public Holidays

image  Style #15 Add New Employee

image  Style #63 Bereavement Leave

image  Style #50 Hours Worked and Departments

image  Style #70 Holiday Pay

image  Style #51 Allowances and Deductions

image  Style #89 Delete File After Import

image  Style #52 Hours Worked & Pay Rate

image  Style #99 User Interface Customisation

image  Style #60 Sick and Special Leave

image  Inserting Comments

Associated Documentation

image  System Information Utility

image  Importing Data Into Ace Payroll

Alphabetical Index   FAQ Questions   FAQ Contents Back to top