A file containing member identity numbers is extracted quarterly from the System and sent to the Department of Home Affairs for processing. This file is written to a CD.
Home Affairs returns a CD with a file indicating if a member has died. The date of death and the cause of death are included as well as comments if the ID Number is not valid or if there is any other discrepancy.
The file that is returned is read into the System. When the JU4AJ_HOMAF batch job (Loading of Home Affairs Data) has been run, extracts are generated for Confirmed Deaths and Unconfirmed Deaths.
The JU3SR_HOME_AFFAIRS_VERIFY batch job will run daily to validate South African ID Numbers using the Home Affairs link. The system will then update the value for ID Number Confirmation on the Natural Person record to HOME AFFAIRS.
For more information, refer to Home Affairs Batch Job Processing below.
Log in to the system from the Logon page.
Click system reports.
The following selections are displayed on the top menu.
From the top menu, select Audit and then Home Affairs Full Extract.
The System will read all of the Membership Payment records across all Schemes for which the End Date is null and for which the Confirmation Type on the Membership Payment Details record is HOME AFFAIRS or H/A DO NOT SUSP.
If the Client Relationship Type is PAYS PENSION the System will find the Membership to which the Membership Payment record is linked. If the Client Relationship Type is SPOUSE, DEPENDANT or DISABLED DEPDNT the System will find the Beneficiary record to which the Membership Payment record is linked.
For all of these the ID Number will be read. An extract will be created with the ID Number for all of the records read.
The Home Affairs Full Extract screen will be displayed.
When EXPORT is selected, the COE Sent field will be updated on each of the current Membership Payment Detail records linked to the Membership Payment records for which the Payment Type is ANNUITANT or LIVING ANNUITY, for each of the members included in the extract, with the date of the extract.
The CD to be sent to Home Affairs is created from the exported file.
For more information, refer to
System Reports
Audit
Home Affairs Full Extract
The CD will be received back from Home Affairs with a text file containing the following information:
|
Information |
Description |
|
ID Number |
|
|
Comment |
e.g. PERSON DECEASED, RECORD DOES NOT EXIST ON FILE) |
|
Date of Death |
Year and month of death in format CCYYMM |
|
Cause of Death |
|
|
Comment |
e.g. invalid ID Number |
|
Surname |
|
|
First Names |
|
The format of the file received from Home Affairs is contained in the table below:
|
Field |
Length |
Start Position |
End Position |
Description |
|
ID Number |
13 |
1 |
13 |
|
|
Comment |
43 |
14 |
56 |
PERSON DECEASED RECORD DOES NOT EXIST ON FILE TEST DIGIT OF IDENTITY NUMBER INCORRECT |
|
Date of Death |
6 |
57 |
62 |
In format CCYYMM |
|
Cause of Death |
50 |
63 |
112 |
|
|
Surname |
45 |
113 |
157 |
|
|
First Names |
Variable |
158 |
variable |
The end of the row is denoted with a return (CRLF) |
This file must be uploaded via the File Transfer website.
Log in to the system from the Logon page.
Click processes then click file transfer.
Select a scheme from the list and select File Transfer from the top menu.
Select Batch File Upload from the sub-menu on the left.
The Batch File Upload screen will be displayed.
Select Home Affairs Load from the Batch Process drop-down list.
Use the BROWSE button to find the file to be uploaded, then click SUBMIT. For more information refer to
Processes
File Transfer
Conversion
Uploading Files and Documents
Log in to the system from the Logon page.
Click infrastructure.
Select Batch from the top menu.
Select Batch Jobs from the sub-menu on the left.
Select the JU4AJ_HOMAF Loading of Home Affairs Data on the Batch Job Submission screen and select the Submit hyperlink in the ACTION column.
When the batch job is submitted, the COE Received field on the current Membership Payment Detail records linked to the Membership Payment records for which the Payment Type is ANNUITANT or LIVING ANNUITY, will be updated for each of the Memberships.
If there is a value in the Date of Death field, the System will read the Confirmation Type on the current Membership Payment Detail records linked to the Membership. If the value is HOME AFFAIRS, the Amendment Reason on the Membership Payment Detail record will be updated to DECEASED. If the value is H/A DO NOT SUSPEND, the Amendment Reason will not be updated but include in the Confirmed Deaths extract.
For more details refer to
Auxiliary Activities
Submitting Batch Jobs
When the JU4AJ_HOMAF batch job has been run, the Confirmed Deaths and Unconfirmed Deaths extracts are generated.
If there is a value for Date of Death on the Home Affairs file, the Report table is updated with a Report Type of ANNUITY DEATHS. These members are displayed in the Confirmed Deaths extract.
If there is a value in the Date of Death field, the System will read the Confirmation Type on the current Membership Payment Detail records linked to the Membership. If the value is HOME AFFAIRS, the Amendment Reason on the Membership Payment Detail record will be updated to SUSPENDED. If the value is H/A DO NOT SUSPEND, the Amendment Reason will not be updated but the case will be included in the Confirmed Deaths extract.
For more details refer to Upload Files under
Processes
File Transfer
Conversion
Uploading Files and Documents
From the Audit menu, click 
alongside Home Affairs on the sub-menu on the left.
Additional options will be displayed.
Select the required extract.
For more information, refer to Confirmed Deaths and Unconfirmed Deaths under
Reports
Audit
Home Affairs
South African ID Numbers are validated using the Home Affairs link.
A batch is scheduled to run daily. When the JU3SR_HOME_AFFAIRS_VERIFY batch job runs, the system will read all of the Natural Person Records for which the value for Identity Type is SA ID and for which the value for ID Number Confirmed is not HOME AFFAIRS. The value for Identity Number will be extracted for all of the records and a file for submission to Home Affairs will be created.
When the file in the format below is received from Home Affairs, the system will find the Natural Person record with a value for Identification Number equal to the value for ID Number in the file and read the values for Surname and First Names on the Natural Person record.
If the values match the values for Surname and First Names in the Home Affairs file, the system will update the value for ID Number Confirmation on the Natural Person record to HOME AFFAIRS.
|
Field |
Length |
Start Position |
End Position |
Description |
|
ID Number |
13 |
1 |
13 |
|
|
Comment |
43 |
14 |
56 |
PERSON DECEASED RECORD DOES NOT EXIST ON FILE TEST DIGIT OF IDENTITY NUMBER INCORRECT |
|
Date of Death |
8 |
57 |
64 |
In format CCYYMMDD |
|
Cause of Death |
50 |
65 |
114 |
|
|
Surname |
45 |
115 |
159 |
|
|
First Names |
Variable |
160 |
variable |
The end of the row is denoted with a return (CRLF) |
Also refer to
System Reports
Audit
Home Affairs Verify