Long service leave data file format

What files do I need to prepare?

You need to create a tab-delimited (.txt) file for each type of required data. 

Information

Remember to exclude column headings from the files.

Here's the format to use.  An asterisk (*) shows which data is mandatory. 

LSL (days) file format

Column >
A*
B*C*
D*
E*
F*
G*H*I

Employee Code

LSL Type

LSL Code

Accrue LSL By Hours

Ignore Prior Deferrals

Start Date

Last Accrual Date

Original Last Accrual Date

Day to Accrue On

Characters >
10
4411


2




y = yes

n = no

y = yes

n = no

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Numeric characters


Column >
JK
L*
M
N
OPQ
R

Day and Month to Accrue

Accrual Date

Percentage Accrued

Days Accrued (Current)

Days Accrued (Non Current)

Fulltime Percentage

Number of Calendar Days

Reason Flag

Delete Flag

Characters >
5

12
12
12
12
5
4
1

Format:

ddMmm

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy







Must be blank.


LSL (hours) file format

Column >
A*
B*C*
D*
E*
F*
G*H*I*

Employee Code

LSL Type

LSL Code

Start Date

Last Accrual Date

Original Last Accrual Date

Rule Effective Date

Accrue by Hours Worked

Hours to Accrue per Day

Characters >
10
44



1

12




Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

y = yes

n = no

If Accrue by Hours Worked (column H):

= n, enter the number of hours

= y, enter 0.00


Column >
J*
K*L
M*
N
O
PQR

Hours to Accrue per Hour

Standard Hours per Day

Accrual Date

Percent Accrued

Average FTE %

Current Balance in Hours

Non-current Balance in Hours

Days in Accrued Period

Leave Reason

Characters >
12
12

12
12
12
12
12
4

If Accrue by Hours Worked (column H):

= n, enter 0.00

= y, enter the number of hours


Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy











Next topic

Regular transactions data file format


 

 





© 2023 Fusion5. All rights reserved.