Interface: 2
Frequency: Daily
Description: Provides the contribution amounts or rates to SAP that are deducted from the monthly salary.
Note:
If it is an amount, the value in position 121 should be A and for a rate it should be P irrespective of whether this is member defined or income rule based.
NO HEADER
DATA
|
Field |
Position |
Length |
Type |
Group SAP Fields |
Comments |
|
Barclays Staff Number |
1 – 12 |
12 |
X |
|
Right justified with leading zeros |
|
Log Field Name |
13 – 25 |
13 |
X |
|
POS87SCHAVCEE, POS97SCHMTCEE, POS97SCHMTCER, etc. |
|
Log Date/Time |
26- 44 |
19 |
X |
|
DD/MM/CCYY hh:mm:ss |
|
Log Value |
45 – 78 |
34 |
X |
|
This field contains the actual value to be interfaced.
Right justified numeric, with decimal point and two decimal places and leading spaces |
|
Log Adjustment Type |
79 – 79 |
1 |
X |
|
A (add) |
|
Log Keys |
80 - 120 |
41 |
X |
|
Contribution start date of original instruction (both new and close/end).
Left justified, blank filled to end of position (i.e. padded with white spaces)
STARTDTE = dd/mm/ccyy |
|
Indicator |
121 |
1 |
X |
|
Req 58 - Indicator against each row to denote whether the contribution is being made on a percentage basis P or a flat amount basis A. |
OUTPUT TRAILER RECORD
|
Field |
Position |
Length |
Type |
Group SAP Fields |
Comments |
|
Identifier |
1 – 4 |
4 |
X |
|
TR01 |
|
Record Count |
5 – 12 |
8 |
X |
|
A count of the number of records supplied in the file, excluding the trailer record. |
|
Filler |
13 – 42 |
30 |
X |
|
Blanks |
|
Checksum |
43 – 76 |
34 |
X |
|
The total of all contribution rates and contribution amount i.e. the sum of all data positions 45 - 78. Note: This is a meaningless number, as it is only to be used for checking the file has been transferred correctly. |
|
Filler |
77 - 118 |
42 |
X |
|
Blanks |