1.39 Payroll and Pension Data Interface Standard (PAPDIS) Upload

This topic explains the systematic instructions on Payroll and Pension Data Interface Standard (PAPDIS) Upload.

The DATE format for Payroll and Pension Data Interface Standard (PAPDIS) upload to be maintained as per the PAPDIS standard format which is YYYY-MM-DD. Format maintained at interface definition level will be overridden by this.

Note:

CFU and PAPDIS are the standard format, where we cannot have the audit fields in the upload template.

Contribution File Upload

Employer level portfolio mapping for the following portfolios mandatory for CFU/PAPDIS upload:

• EMPRMND
• EMPYMND
• EMPYVOL
• EMPRVOL – Not applicable for PAPDIS

Export path of one system should be import path for another system.

Table 1-155 Export path

Field name	Description	Datatype	Length
SEQUENCENUM-BER	Sequence number of the record	VARCHAR2	10
PROCESSID	Process ID of the record	VARCHAR2	50
BULKCLIENT-CODE	Bulk client code for the external system	VARCHAR2	12
UPLOADMODE	Mod e of upload(N,E,A,D)	VARCHAR2	1
IMPORTFILENAME	Name of the file	VARCHAR2	255
MODULEID	Module	VARCHAR2	30
PAPDISVERSION	Version	VARCHAR2	5
PENSIONPROVID-ERID	ID of the pension provider	VARCHAR2	35
EMPLOYERID	ID of the employer	VARCHAR2	40
GROUPCODE	Group code	VARCHAR2	40
SUBGROUP	Sub group	VARCHAR2	40
PAYPERIOD-STARTDATE	Start date of the pay period	VARCHAR2	10
PAYPERIODEND-DATE	End date of the pay period	VARCHAR2	10
CONTRIDEDUC-TIONDATE	Deduction date of the contri	VARCHAR2	10
FREQUENCY-CODE	Code of frequency	VARCHAR2	2
TAXPERIOD	Tax period	VARCHAR2	2
TITLE	Title	VARCHAR2	35
FORENAME1	Forename1	VARCHAR2	35
FORENAME2	Forename2	VARCHAR2	35
SURNAME	Surname	VARCHAR2	35
EMPLOYEEID	EmployeeID	VARCHAR2	35
BIRTHDATE	Birthdate	VARCHAR2	10
GENDER	Gender	VARCHAR2	1
NATIONALINSUR-ANCENO	Number of national insur-ance	VARCHAR2	9
ADDRESS1	Address1	VARCHAR2	35
ADDRESS2	Address2	VARCHAR2	35
ADDRESS3	Address3	VARCHAR2	35
ADDRESS4	Address4	VARCHAR2	35
POSTCODE	Post code	VARCHAR2	10
COUNTRY	Country	VARCHAR2	35
EMAILADDRESS	Emailaddress	VARCHAR2	75
EMPLOYMENT-STARTDATE	Employmentstartdate	VARCHAR2	10
EXITDATE	Exitdate	NUMBER	10
EXITREASON-CODE	Exitreasoncode	NUMBER	1
ASSESSMENT-CODE	Assessmentcode	NUMBER	1
EVENTCODE	Eventcode	VARCHAR2	1
EVENTDATE	Eventdate	VARCHAR2	10
DEFERRALDATE	Deferraldate	VARCHAR2	10
AEOPTOUTDATE	Aeoptoutdate	VARCHAR2	10
AEOPTOUTREF-ERENCE	Aeoptoutreference	VARCHAR2	35
ENROLMENT-COMMISSUEDDT	Enrolmentcommissueddt	NUMBER	10
EMPLOYERCON-TRIBUTIONSAMT	Employercontributionsamt	NUMBER	32
EMPLOYEECON-TRIBUTIONSAMT	Employeecontributionsamt	NUMBER	32
ADDITIONALVOL-UNTARYAMT	Additionalvoluntaryamt	NUMBER	32
ADDITIONALVOL-UNTARYPER	Additionalvoluntaryper	NUMBER	5
PENSIONA-BLEEARNING-SAMT	Pensionableearningsamt	NUMBER	32
EMPLOYERCON-TRIBUTIONSPER	Employercontributionsper	NUMBER	5
EMPLOYEECON-TRIBUTIONSPER	Employeecontributionsper	VARCHAR2	5
SALARYSACRIFI-CEINDICATOR	Salarysacrificeindicator	VARCHAR2	1
TOTALGROS-SEARNINGS	Totalgrossearnings	NUMBER	32
WORKEREXCLU-SIONCODE	Workerexclusioncode	VARCHAR2	2
STATUTORYLET-TERCODE	Statutorylettercode	VARCHAR2	3
ISINDALREADY-MEMBEROFQPS	Isindalreadymemberofqps	VARCHAR2	1
REENROL-MENTINDICATOR	Reenrolmentindicator	VARCHAR2	1
SECOND-ARYEMAILAD-DRESS	Secondaryemailaddress	VARCHAR2	75
STAGINGDATE	Stagingdate	VARCHAR2	10
CYCLICALREEN-ROLMENTDATE	Cyclicalreenrolmentdate	NUMBER	10
MESSAGEFUNC-TIONCODE	Messagefunctioncode	VARCHAR2	3
PAYREFERENCE-STARTDATE	Payreferencestartdate	VARCHAR2	10
PAYREFEREN-CEENDDATE	Payreferenceenddate	VARCHAR2	10
OPTOUTWIN-DOWENDDATE	Optoutwindowenddate	VARCHAR2	10