File Layout: HRSHIST

Interface:           1

Frequency:          Daily

Description:         History of a member's hours records.

 

On payroll, the latest Hours will be display even if all hours contained in the file are prior to current cycle. 

 

Once all format errors have been checked – corrected or ignored, all members with changes are listed under the Daily Confirm menu items.

 

Once these members are confirmed, the BJU3AR batch job will be triggered.

 

Basic file:

The following criteria are used to check if a member is a duplicate:

 

-       First check      Member reference number

-       Second check   Company reference number, Surname, Initials, DOB (Alt Key)

-       Third check      NI Number

 

File layout

NO HEADER

 

DATA

Field

Position

Length

Type

Group SAP Fields

Comments

HRSHIST.MEMBNO

1 – 8

8

N

PA0053-PENUM

Right justified with leading zeros

HRSHIST.STARTDTE

9 – 18

10

D

PA0007-BEGDA

dd/mm/yyyy

HRSHIST.PTHRS

19 – 27

9

N (6.2)

Derive from PA0007-WOSTD and specific absence types

Right justified
Includes decimal point and 2 decimal places

HRSHIST.FTHRS

28 – 36

9

N (6.2)

PA****-*****
Table constant

Right justified
Includes decimal point and 2 decimal places

 

NO TRAILER