1.41.2 CFU Order Generation

This topic explains the systematic instructions on CFU Order Generation.

Table 1-158 CFU Order Generation

Field Name	Description	Datatype	Length	Table name
SEGMENTID	Segmentid	VARCHAR2	20	PATB_CFUPLOADHDR
PROCESSID	Processid	VARCHAR2	50	PATB_CFUPLOADHDR
BULKCLIENT-CODE	Bulkclient-code	VARCHAR2	12	PATB_CFUPLOADHDR
UPLOADMODE	Uploadmode	VARCHAR2	1	PATB_CFUPLOADHDR
BATCHREF-NUMBER	Batchref-number	VARCHAR2	16	PATB_CFUPLOADHDR
EMPLOYER-CODE	Employer-code	VARCHAR2	12	PATB_CFUPLOADHDR
EARNINGSST-PERIOD	Earningsst-period	VARCHAR2	11	PATB_CFUPLOADHDR
EARNINGSEND-PERIOD	Earn-ingsend-period	VARCHAR2	11	PATB_CFUPLOADHDR
CONTRIBU-TIONCCY	Contribu-tionccy	VARCHAR2	3	PATB_CFUPLOADHDR
TOTALCONTRI-BUTIONAMT	Totalcontri-butionamt	NUMBER	30	PATB_CFUPLOADHDR
SETTLEMEN-TREQ	Settlemen-treq	VARCHAR2	1	PATB_CFUPLOADHDR
SEGMENTID	Segmentid	VARCHAR2	20	PATB_CFUPLOADDE-TAIL
SEQUENCE-NUMBER	Sequence-number	NUMBER	10	PATB_CFUPLOADDE-TAIL
PROCESSID	Processid	VARCHAR2	50	PATB_CFUPLOADDE-TAIL
EMPLOYEE-CODE	Employee-code	VARCHAR2	12	PATB_CFUPLOADDE-TAIL
EMPLOYER-MANDATORY	Employer-mandatory	NUMBER	30	PATB_CFUPLOADDE-TAIL
EMPLOYEE-MANDATORY	Employee-mandatory	NUMBER	30	PATB_CFUPLOADDE-TAIL
EMPLOY-ERVOLUNTARY	Employ-ervoluntary	NUMBER	30	PATB_CFUPLOADDE-TAIL
EMPLOY-EEVOLUNTARY	Employ-eevoluntary	NUMBER	30	PATB_CFUPLOADDE-TAIL
REMARKS	Remarks	VARCHAR2	255	PATB_CFUPLOADDE-TAIL
BASICPAY	Basicpay	NUMBER	30	PATB_CFUPLOADDE-TAIL
EXITDATE	Exitdate	DATE	7	PATB_CFUPLOADDE-TAIL
REASONCODE	REASON-CODE	NUMBER	3	PATB_CFUPLOADDE-TAIL
PROCESSSTA-TUS	PRO-CESSSTA-TUS	VARCHAR2	1	PATB_CFUPLOADDE-TAIL

Table 1-159 Following validations will be common for both CFU Upload and CFU order generation uploads:

Error Codes	Error Messages	Use case
E-DUPBA-TREFNO	Duplicate batch reference num-ber	If same batch reference num- ber is used in upload file
E-CFUREASON	Reason code for contribution file not maintained	If all contributions are empty and reason code is blank sys- tem will display this error
E-NOACCOUNT	Pension account is not available for this employee	If investment account if the employee is not an active pen- sion account
E-DUPCONT	Contributions already processed for employee [Employeecode] for the period [Start period] and [End period]	If investments are already pro- cessed successfully for the employee for the uploaded contribution period
E-DECMEM	Contributions are not allowed for Deceased member	If employee is deceased and user tries to upload
E-NOCON-TRIEMP	Contribution amount missing for the employee	If Contribution amount is miss- ing
E-EMPLOMAN-CON	Employer mandatory contribution amount should be entered or rea-son should be provided	No employer mandatory and reason code also blank
E-EMPLYMAN-CON	Employee mandatory contribu- tion amount should be entered or reason should be provided	No employee mandatory and reason code is blank
E-EXITWOREAS	Employee exit date provided, without reason code	Exit date without reason code
E-INVREASON-CODE	Invalid reason code	Invalid reason code
E-EMPRCONT-MIS	Contribution amount not matching employee group limits	Contribution amount not matching employee group lim- its
E-EMPYCONT-MIS	Contribution amount not matching employee group limits	Contribution amount not matching employee group lim- its
E-INVEXITDATE	Exit Date cannot be lesser than employee’s Date of Joining	Exit Date cannot be lesser than employee’s Date of Join- ing
E-INVSTEND-PERIOD	Contribution period cannot be lesser than employees Date of Joining	Contribution period cannot be lesser than employees Date of Joining