1.40 Contribution File Upload (CFU) Upload

This topic explains the systematic instructions on Contribution File Upload (CFU) Upload.

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

Table 1-156 Contribution File Upload (CFU) Upload

Field name	Description	Datatype	Length	Table Name
SEGMENTID	Segmentid	VARCHAR2	20	PATB_CFUP-LOADHDR
PROCESSID	Processid	VARCHAR2	50	PATB_CFUP-LOADHDR
BULKCLIENT-CODE	Bulkclientcode	VARCHAR2	12	PATB_CFUP-LOADHDR
UPLOADMODE	Uploadmode	VARCHAR2	1	PATB_CFUP-LOADHDR
BATCHREFNUM-BER	Batchrefnumber	VARCHAR2	16	PATB_CFUP-LOADHDR
EMPLOYER-CODE	Employercode	VARCHAR2	12	PATB_CFUP-LOADHDR
EARNINGSST-PERIOD	Earningsstperiod	VARCHAR2	11	PATB_CFUP-LOADHDR
EARNINGSEND-PERIOD	Earningsend-period	VARCHAR2	11	PATB_CFUP-LOADHDR
CONTRIBU-TIONCCY	Contributionccy	VARCHAR2	3	PATB_CFUP-LOADHDR
TOTALCONTRI-BUTIONAMT	Totalcontribution-amt	NUMBER	30	PATB_CFUP-LOADHDR
SETTLEMEN-TREQ	Settlementreq	VARCHAR2	1	PATB_CFUP-LOADHDR
PAYMENTMODE	Payment Mode	VARCHAR2	2	PATB_CFUP-LOADHDR
BATCHSTATUS	Batch Status	VARCHAR2	1	PATB_CFUP-LOADHDR
SEGMENTID	Segmentid	VARCHAR2	20	PATB_CFUP-LOADDETAIL
SEQUENCE-NUMBER	Sequencenumber	NUMBER	10	PATB_CFUP-LOADDETAIL
PROCESSID	Processid	VARCHAR2	50	PATB_CFUP-LOADDETAIL
EMPLOYEE-CODE	Employeecode	VARCHAR2	12	PATB_CFUP-LOADDETAIL
EMPLOYERMAN-DATORY	Employermanda-tory	NUMBER	30	PATB_CFUP-LOADDETAIL
EMPLOYEEMAN-DATORY	Employeemanda-tory	NUMBER	30	PATB_CFUP-LOADDETAIL
EMPLOYERVOL-UNTARY	Employervolun-tary	NUMBER	30	PATB_CFUP-LOADDETAIL
EMPLOYEEVOL-UNTARY	Employeevolun-tary	NUMBER	30	PATB_CFUP-LOADDETAIL
REMARKS	Remarks	VARCHAR2	255	PATB_CFUP-LOADDETAIL
BASICPAY	Basic Pay	NUMBER	30	PATB_CFUP-LOADDETAIL
EXITDATE	Exit Date	DATE	7	PATB_CFUP-LOADDETAIL
REASONCODE	Reason Code	NUMBER	1	PATB_CFUP-LOADDETAIL
RECORDSTATUS	Record Status	VARCHAR2	1	PATB_CFUP-LOADDETAIL