Annuity Payment Detail Changes Upload (Annuity)

Overview

This file is for loading payment detail update for ad-hoc payment / ad-hoc increases

This is an upload program that enables Clients to load bulk updates to annuitant payment details records.

The business from time to time receives a request from Pensions Funds and Employers to grant ad-hoc payment or to increase pensions, but not in accordance to a specific scale. These values could be based upon a combination of years of service, current value of monthly pensions and if it is being paid to a main members or a beneficiary. As Clients are not able to clearly define this into a product or increase type, it is easier for them to have the facility to upload these payment detail changes in a bulk format.

The required fields are marked as either “M” = mandatory or “C” = conditional.

The fields 1 to 8, 10 and 57 are used to identify the Member and Annuity record to which the new Payment detail records will be connected. The rest of the mandatory or conditional fields are required to store the new record.

Input file layout

Detail record

	Field Name	Field Size	DEC	ATTR	O/M	Start	End	Description / Value
1	File indicator	4		Char	M	1	4	AB78
2	FundNumber	7		Char	M	5	11	Scheme code
3	MemberNumber	20		Char	M	12	31	Member reference number
4	Surname	30		Char	M	32	61	Surname
5	Initials	5		Char	M	62	66	Initials
6	DOB	8		Num	M	67	74	CCYYMMDD - Date of Birth
7	IDnumber	15		Char	M	75	89	ID number
8	Status	15		Char	M	90	104	ANNUITANT LIVING ANNUITNT SPOUSE DEPENDANT DISABLED DEPDNT
9	Purchase Amount	11	2	Num		105	115	Not Required
10	Payment Type	15		Char	M	116	130	Type of payment. TAX RECOVERY TAX REFUND ANNUITY EX GRATIA LOAN SUBSIDY HOUSING SUBSIDY MED AID SUBSIDY MED AID ER CONT ANN LOAN DEDUCTIONS MED SHORTFALL MEDICAL AID RA CONTRIBUTION
11	Payment Start Date	8		Num		131	138	Not Required. Zero fill
12	EFFECTIVE_DATE	8		Num	M	139	146	CCYYMMDD - the effective date from which the payments must start.
13	DATE_OF_LAST_ PAYMENT	8		Num		147	154	Not Required. Zero fill
14	AMOUNT_OF_ REGULAR_ PAYMENT	11	2	Num	M	155	165	The amount of the payment to be made regularly.
15	C_UDPV_ FREQUENCY	15		Char	M	166	180	The frequency of the payment. ANNUALLY BI-ANNUAL MONTHLY ONCE OFF QUARTERLY
16	C_UDPV_ ANNUITANT_ STATUS	15		Char	M	181	195	ACTIVE This is the only value allowed.
17	PAYMENT_ REVIEW_DATE	8		Num		196	203	Not Required. Zero fill
18	PERCENTAGE	7	4	Num		204	210	Not Required. Zero fill
19	COE_DATE_SENT	8		Num		211	218	Not Required. Zero fill
20	COE_DATE_ RECEIVED	8		Num		219	226	Not Required. Zero fill
21	PRIORITY_OF_ DEDUCTION	4		Num	C	227	230	A number to denote the priority that must be placed on a payment. The lowest number indicates the highest priority. /this applies to deductions if there is a specific priority order.
22	TAX_RELIEF	1		Char	C	231	231	Indicates whether or not this Deduction qualifies for tax relief. Y N
23	END_DATE	8		Num		232	239	Not Required. Zero fill
24	C_UDPV_ PAYMENT_ METHOD	15		Char	M	240	254	BANK TRANSFER CHEQUE EFT FOREIGN DRAFT
25	TAX_RELIEF_ PERCENTAGE	7	4	Num	C	255	261	The percentage allowed for tax relief by the tax authority. Required if the member’s Tax Relief value is “Y”
26	GN18_ INDICATOR	1		Char	M	262	262	Per General Note 18 issued by SARS. Y = annuity purchased by the member (member owned annuity) N = annuity not purchased by the member
27	DISINVEST_ LIVING_ANNUITY_RATE	7	4	Num		263	269	Not Required. Zero fill
28	TAX_DIRECTIVE_ PERCENTAGE	7	4	Num	C	270	276	If the member has a Tax Directive Tax rate percentage for a pension payment that a member or beneficiary has applied for, and for which a tax directive has been received.
29	TAX_DIRECTIVE_ START_DATE	8		Num	C	277	284	If the member has a Tax Directive CCYYMMDD - the start date of a tax rate percentage, for which a tax directive has been received.
30	TAX_DIRECTIVE_ END_DATE	8		Num	C	285	292	If the member has a Tax Directive CCYYMMDD - the end date of a tax rate percentage, for which a tax directive has been received.
31	INCREASE_ PARTICIPATION	1		Char		293	293	Not Required. Space fill
32	CO_INCOME_ DATE_SENT	8		Num		294	301	Not Required. Zero fill
33	CO_INCOME_ DATE_RECEIVED	8		Num		302	309	Not Required. Zero fill.
34	CO_MEDICAL_ DATE_SENT	8		Num	C	310	317	CCYYMMDD - the date on which a request for medical evidence of health for the member was sent.
35	CO_MEDICAL_ DATE_RECEIVED	8		Num	C	318	325	CCYYMMDD - the date on which a request for medical evidence of health for the member was received.
36	CO_EDUCATION_ DATE_SENT	8		Num	C	326	333	CCYYMMDD - the date on which a request for education certification documents for the member was sent.
37	CO_EDUCATION_ DATE_RECEIVED	8		Num	C	334	341	CCYYMMDD - the date on which a request for education certification documents for the member was received.
38	C_UDPV_ AMENDMENT_ TYPE	15		Char	M	342	356	“BULK UPDATE”
39	Organization Code	6		Char		357	362	Not Required. Space fill
40	FIRST_NAME	20		Char		363	382	Not Required. Space fill
41	MIN_PENSION_ PERCENTAGE	7	4	Num		383	389	Not Required. Zero fill
42	YEAR_TO_DATE_ AMOUNT	15	2	Num		390	404	Not Required. Zero fill
43	UNIQUE_ID_FROM_ORIG_SYSTEM	8		Char		405	412	Not Required. Space fill
44	CLIENT_ RELATIONSHIP_ COID	15		Num		413	427	Not Required. Zero fill
45	TOTAL_AMOUNT_REPAID	15	2	Num		428	442	Not Required. Zero fill
46	TOTAL_AMOUNT_OUTSTANDING	15	2	Num		443	457	Not Required. Zero fill
47	TYPE_OF_ ANNUITY	15		Char		458	472	Not Required. Space fill
48	DATE_OF_RETIREMENT	8		Num		473	480	Not Required. Zero fill
49	GUARANTEED_ DATE	8		Num		481	488	Not Required. Zero fill
50	SALARY_AT_RETIREMENT	15	2	Num		489	503	Not Required. Zero fill
51	APPLY_RULE_IND	1		Char		504	504	Not Required. Space fill
52	COMMUTATION_AMOUNT	15	2	Num		505	519	Not Required. Zero fill
53	BONUS_PARTICIPATION	1		Char	M	520	520	Bonus participation indicator “Y” or “N”
54	CONFIRMATION_ TYPE	15		Char	C	521	535	For home affairs report. Values “HOME AFFAIRS”, “NONE”
55	YEARLY_REVIEW_DATE	8		Num	C	536	543	CCYYMMDD – this is for Living Annuitants
56	CESSATION_REASON	15		Char		544	558	Not Required. Space fill
57	BENEFIT_TYPE	4		Char	M	559	562	Eg. SCHD, INKT, BONT,etc
58	CURRENCY	15		Char	M	563	577	The currency where payment is made
59	TOTAL_PENSION	11	2	Num		578	588	Not Required. Zero fill
60	COMMUTED_PENSION	15	2	Num		589	603	Not Required. Zero fill
61	TAX_TYPE	11		Char		604	614	Not Required. Space fill
62	BASE_CURRENCY	15		Char		615	629	Not Required. Space fill
63	INCREASE_TYPE	15		Char	M	630	644	Eg. SCHEDULED
64	INCREASE_MONTH	2		Num		645	646	Not Required. Zero fill
65	INCREASE_PERC	7		Num		647	653	Not Required. Zero fill
66	PRO_RATA_INCREASE_TYPE	15		Char		654	668	Not Required. Space fill
67	PURCHASE_PRICE_RATE	7		Num		669	675	Not Required. Zero fill
68	POLICY_NUMBER	50		Char		676	725	Not Required. Space fill
69	TAX_DIRECTIVE_AMOUNT	15		Num	C	726	740	If the member has a Tax Directive
70	TAX_DIRECTIVE_NUMBER	15		Char	C	741	755	If the member has a Tax Directive
71	TAX_DIRECTIVE_ISSUE_DATE	8		Num	C	756	763	If the member has a Tax Directive. CCYYMMDD
72	C_UDPV_ AMENDMENT_ REASON	15		Char		764	778	ADHOC This is the only value allowed.

O = Optional field

C = Conditional field

M = Mandatory field

The Input File requires no Header or Trailer record but an EOF record must be provided.

Processing

The processing requirement for this batch program is as follows:

- This program allows payment detail changes for SPOUSE; DEPENDANT; DISABLED DEPDNT; ANNUITANT; LIVING ANNUITN. Records with any other status will be rejected with an appropriate error message.

- The program will not change the annuity record details as seen on screen JU4DC Membership Payment Maintain.

- The changes are for the Payment Detail records only, on screen JU4DD Payment Detail Maintain only.

- New Payment detail records for all Payment Types except for YTD records are allowed to be stored by this program. To identify YTD records, these will always have “YTD” as the last 4 characters of the name.

- The Program will only allow Payment Detail records with status of “ACTIVE” or “ADHOC” to be created.

- Changes for suspended Payment detail records will not be allowed by this program. (Status = “SUSPENDED”)

- The records will be stored with an Amendment reason: “Bulk Change”. This amendment reason will work in the same manner as the “Salary Increase” amendment reason. In other words, it will not be rejected by the Payment run because it has an amendment reason.

- The “Last Payment Date” will not be carried over from the existing “ACTIVE” payment detail records.

- The records will be created with the start dates provided in the input file.

- If an “Ad-Hoc” record must be stored for a non-monthly frequency case, then the start date of the new record must be the date when the next payment is due. If the date supplied in the input file does not match to the expected, then the record will be rejected and an error message will be issued.

- If an “Active” record is stored for a non-monthly frequency case, then:

- The start date of the new record must be the first of the month of the Last Payment Date on the existing record. If no Last Payment date exists, then start date equal to the existing active record will be used. If the date supplied in the input file does not match to the expected, then this record will be rejected and an error message will be issued.

- The existing “Active” record must be end-dated, 1 day earlier than the start date of the new “Active” record.

Member data load

When the BJU3EG and BJU5AA batch jobs run to load Annuity Member Payment Detail changes, i.e. the File Indicator value is AB78, the system will create a Membership Payment Detail History record with all of the details on the Membership Payment Detail record after the update of the changes and with the Date and Timestamp the record is created.

Note:

The Membership Payment record cannot be updated via a file upload, only the Membership Payment Detail record is updated and a new Membership Payment Detail record is actually created and the previous record for the same Payment Type is end dated

Error handling

The standard error handling is used with error messages displayed in the Error Log. The following scenarios will result in rejection with an error message:

Scenario

When encountering an input record with an invalid status

When encountering an input record for any of the YTD payment types

When encountering an input record for a Payment type that exists but omit the Benefit Type.

When encountering an input record for a Payment type that does not exist for a specific person

When encountering an input record for a member that do not exist

When encountering an input record for “ADHOC” and “ACTIVE” non-monthly frequencies with incorrect dates as specified in the processing section of this doc.

When encountering an input record with a status = “SUSPENDED”

When no EOF Record is provided.

Refer to

Supplements

Processes

Data Take On Process For Pensioners

For information on annuity payments to the principal member, or each dependant, and for each deduction to be paid to a third party, refer to

Processes

File Transfer

File Layouts

Annuity Payment

For information on annuity change reports refer to

Reports

Annuity

Payment Details Audit

System Reports

Audit

Payment Details Audit