Contribution Updates

This file layout enables the bulk updating of contributions for existing members.

Note:

This layout is also used for the loading of a history of contributions or the bulk load of individual Retirement Annuity Fund member contribution amounts via the CONH layout. For more information, refer to

Processes

File Transfer

File Layouts

Contribution History

Processes

File Transfer

File Layouts

Retirement Annuity Fund Contributions

The following mask is used by Batch Job BJU3RN:

	Field Name	Field Size	DEC	Start	End	ATTR	O/M	Description / Value
1	File indicator	4		1	4	Char	M	CONH
2	Scheme code	7		5	11	Char	M	Scheme code
3	Member number	20		12	31	Char	M	Member reference number
4	Start date	8		32	39	Char	M	CCYYMMDD
5	Contribution type	15		40	54	Char	M	Basic, PSD (PSD = Pensionable Service Date backdated)
6	Monetary amount	11		55	65	Num	M	Actual Contribution Amount
7	Filler	1		66	66		M	Space
8	Increase Type	15		67	81	Char	O	ANN ESCALATION Type of Increase on Membership Payment Detail.
9	Increase Percentage	7	2	82	88	Num	O	Annual increase percentage. Percentage on Membership Payment Detail.
10	Payment Day	2	0	89	90	Num	O	Day of the month on which the member’s contribution is to be collected. Payment Day on Membership Payment.
11	Date of last payment	8		91	98	Char	O	Day last contribution was collected
12	Date of Retirement	8		99	106	Char	O	Member’s normal retirement date
13	Income Type	4		107	110	Char	O	Income Type REC FEEP
14	Frequency	15		111	125	Char	O	MONTHLY QUARTERLY ANNUAL

The system will take action as follows:

Detail Record

Field Name	Action
File indicator	Must be CONH for contribution updates.
Scheme code	If not the same as in the Header record, reject the record with an error message to the error log
Member number	If not a valid member number, reject the record with an error message to the error log
Start date	The Start Date must be a valid date (i.e. CCYYMMDD), the Contribution Type must be one that is used by the scheme on the Start Date, and the Monetary amount must be numeric. If not, reject the record with an error message to the error log.
Payment type	If the member has no contribution records of type Contribution Type, create a new contribution record of that type, with the Start Date and Monetary amount provided, unless the monetary amount is zero, in which case reject the record with an error message to the error log.
Monetary amount	If the member has contribution records of type Contribution Type, check that the Start Date is later than the Start Date of the last contribution of that type. If it is not, reject the record with an error message to the error log. If it is, end-date that contribution with a date one day prior to Start Date, and create a new contribution record of that type, with the Start Date and Monetary amount provided, unless the Monetary Amount is zero, in which case do not create a new record.
Increase Type	If there is a value for Increase Type, the system will update the Type of Increase on the Membership Payment Detail record.
Increase Percentage	If there is a value for Increase Percentage, the system will update the Percentage on the Membership Payment Detail record.
Payment Day	If there is a value for payment Day, the system will update the Payment Day on the Membership Payment record.
Date of last payment	If there is a value for Date of Last Payment, the system will update the Date of Last Payment on the Membership Payment Detail record.
Date of Retirement	If there is a value for Date of Retirement, the system will update the Date of Retirement on the Membership Payment record.
Income Type	If there is a value for Income Type, the system will update the Income Type (Inst_ID_JUF03) on the Membership Payment record.
Frequency	If there is a value for Frequency, the system will update the Frequency on the Membership Payment Detail record. If no value for Frequency is supplied, the system will default the value to MONTHLY as per the current functionality.