Interface: 1
Frequency: Daily
Description: Details of exits relating to redundancy and retirements.
Exits relating to redundancy and retirements to be interfaced to UK Pension Administration as soon as they're added to SAP so that we can start processing them in advance.
Group SAP sends this info in a separate file which is sent daily along with the interface 1 files.
The file will be automatically uploaded to Vision so that it follows a similar process to exits that come in via interface 1 and therefore shows on the data capture summary and automatically creates the relevant exit SR on Filenet.
Member's who are extracted to this file will also get extracted to the basic interface 1 file when the exit date becomes effective, this duplicate information should be ignored by Vision and must not create format or rule and validation errors that need investigating. It will however be reported in the error log in a way similar to the existing interface 1 validations where duplicate exit notifications are reported.
HEADER (EXT)
|
Field |
Description |
Length |
Type |
Infotype and Data Element on SAP |
Format on SAP |
Comments |
|
Identification |
Record Id |
8 |
X |
Value ‘HEADER’ |
|
|
|
Effective Date |
Date of extract from SAP |
10 |
D |
PNPENDDA |
DATS 8 |
Date format DD/MM/YYYY |
|
Previous Effective Date |
Effective Date of last Interface Run |
10 |
D |
YHRPENICON-YYHREDATE for previous run of interface |
DATS 8 |
Date format DD/MM/YYYY |
|
Date Generated |
Date of extract from SAP |
10 |
D |
System date of extract. |
DATS 8 |
Date format DD/MM/YYYY |
|
Time generated |
Time the control file is generated on SAP |
8 |
X |
System time of creation of control file in format HH:MM:SS |
TIME 6 |
|
|
Rejection Run Count |
To be used by Vision |
2 |
X |
Default value ‘00’ |
|
Same as old PEN1 See Note below |
Note:
Infotype 0041, Date Type “ZE” (Migrated to Vision) will be checked during the migration from PenServer phase. Employees rejected because they do not have this date maintained will result in this count being incremented. Each will be written to the Spool Output if an optional switch on the selection screen is ticked.
DETAIL (one per data file) (EXT)
|
Field |
Description |
Length |
Type |
Infotype and Data Element on SAP |
Format on SAP |
Comments |
|
Identification |
Record Id |
8 |
X |
Value |
|
|
|
Rejection Run Count |
Used by Vision |
2 |
X |
Default value ‘00’ |
|
|
|
Record Count |
Number of records on file |
8 |
X |
Total number of records on file accumulated in extract program. |
|
|
BASIC DATA (NE)
|
Field |
Description |
Length |
Type |
Infotype and Data Element on SAP |
Format on SAP |
Comments |
|
DATA.MEMBNO |
Pension Member Number |
8 |
N |
P0053-PENUM |
CHAR 20 |
Right justified with leading zeros |
|
DATA.ALTKEY |
Employee Number |
12 |
X |
P0002-PERNR |
NUMC 8 |
|
|
DATA.BLDATE |
Termination Date |
10 |
D |
Calculate = P0000-BEGDA – 1 day for actions ‘Z3’ (exit bank employee) or ‘ZS’ (retirement) |
DATS 8 |
Date format DD/MM/YYYY |
|
DATA.BLMODE |
Leaving Method, e.g. retirement |
2 |
X |
Map from P0000-MASSG for action types ‘Z3’ or ‘ZS’ |
CHAR 2 |
|
Note:
For employee number, 8 digit number format prefixed with leading zeroes will be sent by SAP.
All leading zeros must be removed from the Staff Number / Employee Number before use on Vision.
All validations currently applied to exit records received in the existing interface 1 file must be applied to the exit records received in this file.