Position and pay data file format

Check transaction rules

When taking on employee position and pay data, we recommend you check the settings on the following two transaction rules to understand what happens in EmpowerHR.

Information The rules are located at Administration > Screen Management > Transaction Rules > Rules By Frame/Function.
Information Cost code shown in the following table is an example.  These rules cover other items.
When the transaction rules...
are set to...
this happens...

Default from previous movement

n

EmpowerHR expects a cost code in the take-on table

If the cost code is split, EmpowerHR expects splits in the take-on table

Display Only
n
Default from previous movement
y
EmpowerHR defaults the cost code and splits from the position, but overrides it if there is a non-blank code in the take-on table
Display Only
n
Default from previous movement
y
EmpowerHR defaults the cost code and splits from the position and ignores anything in the take-on tables
Display Only
y
Default from previous movement
n
No cost code is taken on as this is an invalid combination

Display Onlyy

What file do I need to prepare?

You need to create a tab-delimited (.txt) file containing the required data. 

Information

Remember to exclude column headings from the files.

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

Column >
A*
B*C*
D
E*
F
GHI

Employee Code

Position Number

Date the position was held

Date the position was held up to 

Award Code

Cost Centre

Agency/ Location

Program Activity/ Job Number

Section Code

Characters >
10
10


8
164164



Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy







Column >
J
K
L
MNOP*
Q*R

Duty Code

Location Code

Authorising Officer

Employment Type

Employment Condition

Probation Period

Work Pattern Code

Public Holiday Code

Contract Reason

Characters >
4
4
4
4
4
12
6
4
4


Column >
S
T
U
VWX*Y*
Z*AA*

Contract Expiry Date

Contract Signed

User Field 4

User Field 5

User Narrative

Award Level

Pay Basis

Hours Per Period

Hours Per Week

Characters >

1
8
8
180
2
1
10 including 2 decimal places
10 including 2 decimal places

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy





If hourly paid position, enter level.

Otherwise, leave blank.

h = hourly

s = salary




Column >
AB*
AC
AD
AEAF
AGAH
AI
AJ*

FTE %

Base Salary

Hourly Rate

Variation %

Variation Amount

Salary Maintain

Salary Barrier Level

Increment Date

Auto Increment

Characters >
10 including 2 decimal places
10
12 including 6 decimal places
10
1012
1


If salary paid position, enter salary.

Otherwise, leave blank.






Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

y = yes

n = no

d = schools functionality


Column >
AK*
AL*
AM*AN
AO

Pay By Exception

Pay

Pay Start Date

Employee Remuneration Narrative

Deleted Flag

Characters >
1
1

100
1

y = yes

n = no

d = schools functionality

y = yes

n = no


Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy


Must be blank.

Employee cost code splits

Column >
A*
B*
C*

Employee Code

Cost Code

Split Percentage

Characters >
10
16
2



Next topic

Payment instructions data file format


 

© 2023 Fusion5. All rights reserved.