Field No

Field Type

Comments

Data Source

Character Position

1

A/N - 7

Employee Code

Employee.EmployeeCode

1 - 7

2

A - 4

Title

Employee.Title

8 - 11

3

A - 26

Last Name

Employee.LastName

12 - 37

4

A - 26

First Name

Employee.FirstNames

38 - 63

5

N - 10

Date of Birth

Employee.BirthDate

64 - 73

6

A - 6

Gender

If ‘M’ then output ‘Male’;

If ‘F’ then output ‘Female’;

Else output  NULL.

Employee.Gender

74 - 79

7

A/N - 30

Address 1 (street)

Employee.Address1

80 - 109

8

A/N - 30

Address 2 (street - second line)

Employee.Address2

110 - 139

9

A/N - 30

Address (suburb)

Employee.Address3

140 - 169

10

N - 4

Post Code

Employee.PostCode

170 - 173

11

A - 4

State

Employee.State

174 - 177

12

N - 16

Home Phone

Employee.HomePhone

178 - 193

13

N - 16

Work Phone

Employee.WorkPhone

194 - 209

14

N - 16

Mobile Phone

Employee.MobilePhone

210 - 225

15

N - 10

Start Date

(format = DD/MM/YYYY)

Employee.StartDate

226 - 235

16

N - 10

Termination Date

(format = DD/MM/YYYY)

Employee.TerminationDate

236 - 245

17

N - 10

Clock Card Number 1

Employee.ClockCard1

246 - 255

18

A/N - 30

Job Description

Employee.XEEPOSNDESC

256 - 285

19

A/N - 2

Location

Employee.LocationCode

286 - 287

20

A/N - 4

Department

Employee.DepartmentCode

288 - 291

21

A/N - 1

Pay Period

Employee.PayPeriodCode

292 - 292

22

A/N - 6

Division

Employee.Dim1Code

293 - 298

23

A/N - 3

Business Unit

Employee.Dim2Code

299 - 301

24

A/N - 4

SAC Code

Employee.Dim3Code

302 - 305

25

A/N - 4

Store Code

Employee.Dim4Code

306 - 309

26

A/N - 26

Contract

Employee.ContractCode

310 - 335

27

A/N - 3

Pay Rule Group

Employee.XEEPAYGRCODE

336 - 338

28

N - 11

Hourly Rate

(Display up to 4 decimal places)

Employee.XEEHOURRATE

339 - 349

29

A/N - 1

Employee Status

Employee.EmployeeStatusCode

350 - 350

30

A/N - 4

Holiday Group

Employee.HolidayGroupCode

351 - 354

31

N - 10

Annual Leave Balance

(Display up to 2 decimal places)

Employee.XEEALBalance

355 - 364

32

N - 10

Sick Leave Balance

(Display up to 2 decimal places)

Employee.XEESLBalance

365 - 374

33

N - 10

Long Service Leave Balance

(Display up to 2 decimal places)

Employee.XEELSBalance

375 - 384

34

A/N - 4

Employee Class

Employee.XEECLASSCODE

385 - 388

35

N - 1

ARU User

Employee.XEEAUREGUSR

389 - 389

36

A/N - 3

Company Number

Employee.XEECOMPNCODE

390 - 392

37

A - 1

Fifty-fifty Indicator

Employee.XEEFIFTY

393 - 393

38

N - 10

RDO Bank Balance

Employee.XEERDBALANCE

394 - 403

39

A - 1

Functional Area

Employee.XEEFAREACODE

404 - 404

40

N - 3

Base Hours

Employee.XEEAVGWKHRS

405 - 407

41

A/N - 4

Physical Store Number

Employee.XEEPHYSSCODE

408 - 411

42

A - 1

Export to Payroll

Employee.PREXPORT

412 - 412