Interface: 1
Frequency: Daily
Description: History of a member's salary record.
On payroll, the latest salary will be display even if all salaries contained in the file are prior to current cycle. All backdated salaries will be processed directly to core.
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
NO HEADER
DATA
|
Field |
Position |
Length |
Type |
Group SAP Fields |
Comments |
|
SALHIST.MEMBNO |
1 – 8 |
8 |
N |
PA0053-PENUM |
Right justified with leading zeros |
|
SALHIST.STARTDTE |
9 – 18 |
10 |
D |
PCL4-AEDAT |
dd/mm/ccyy |
|
SALHIST.SAL1 |
19 – 30 |
12 |
N (8,2) |
PA0008-ANSAL |
|
|
SALHIST.SHFTPAY |
31 – 42 |
12 |
N (8,2) |
PA0014-BETRG Wage type 1229 |
|
|
SALHIST.SHIFTPC |
43 – 54 |
12 |
N (8,2) |
PA0014-ANZHL Wage type 1254/1255 |
|
|
SALHIST.RECSTERL |
55 – 66 |
12 |
N (8,2) |
PA0008-ANSAL for subtype 2 |
|
|
SALHIST.BPBALL |
67 - 78 |
12 |
N (8,2) |
PA0014-BETRG Wage type 1275 |
|
|
Type |
79-88 |
10 |
X |
|
Req 46 & 51 |
|
Amount |
89-100 |
12 |
N8.2 |
|
Req 46 & 51 |
NO TRAILER