Certificate of Existence (System Reports)

This report extracts a list of annuitant identity numbers for all relevant schemes. 

 

This report provides for the extract and printing of certificates of existence (COE).

 

This report is available with a template to print COE certificates so that they can be posted to the members. 

For more information refer to

Supplements

Tags

Certificate of Existence

 

The member in turn takes the certificate to a Commissioner of Oaths to obtain a signature as proof that they are still alive.

 

The member then sends the signed COE certificates back to the Administrator.

When the returned certificate is received back, the Administrator will capture the COE return date on the JU4DD Membership Payment Details record.

 

If the signed certificate is not received back within the grace period, (or you have not captured the COE Return Date within the grace period), the system will automatically suspend the Payment Detail Record with an appropriate message.

 

When the grace period is checked in the Annuity/Living Annuity payment run to determine if the Membership Payment record must be suspended, the system will read the Scheme Parameter with a Type of COE GRACEPERIOD.  If not found, the system will read the Territory Parameter with a Type of COE GRACEPERIOD and if not found, will read the Global Parameter with a Type of COE GRACEPERIOD.

Only the records for which the grace period has been exceeded will be suspended if the Type of Confirmation is CERTIFICATE.

 

The report is produced in two stages:

-          input the selection criteria and submit the job
Note:
The reports are not displayed automatically.

-          view the completed reports.

 

Note:

This report is also available to be run for a selected scheme.

For more information refer to

Processes

Regular Payments

Reports

Certificate of Existence

 

From the Audit menu, select Certificate of Existence from the sub-menu on the left.

 

 

Additional options will be displayed.

 

 

New

Click New below Certificate of Existence.  A screen will be displayed, allowing for the capture of report criteria.

 

 

Select the required EFFECTIVE DATE (mandatory) and ANNUITANT TYPE and specify the GRACE PERIOD FOR RETURN OF CERTIFICATE OF EXISTENCE (optional).

 

Click SUBMIT.

 

View

Click View below Certificate of Existence.  The Certificate of Existence screen will be displayed with details of the details of the extracts.

 

 

The following columns are displayed:

-          Scheme code

-          Date effective run

-          Grace period

-          Date extracted

-          User ID

-          Action

 

To select a report, click on the hyperlinked display in the Action column alongside the appropriate report.

 

The Certificate of Existence screen will be displayed. 

 

 

The following columns are displayed, per tax year:

-          Scheme code

-          Reference number

-          Surname

-          Initials

-          Date of birth

-          ID number

-          First name

-          Unique ID

-          Status

-          Postal code

-          Timestamp

 

To create a file for viewing, click CREATE BULK PDF - File

 

A confirmation message will be displayed.

 

Do you want to save this bulk print to a file?

 

 

Click OK.  The Certificate of Existence screen will be re-displayed, and a message will confirm that the job has been submitted successfully.

 

Processing

The system will read the Document Template linked to each Scheme in the file with a PDF Process Type of CERT EXISTENCE and with a value for Language equal to the Language on the Natural Person record to which the Annuity record is linked and create the PDF document based on the Document Template found for the applicable Scheme.

If a Document Template is not found with a value for Language then the system will find the latest Document Template with a PDF Process Type of CERT EXISTENCE linked to the Scheme.

 

If no value for Language is found for the Annuitant the Document Template will be used with a value for Language of ENGLISH.

 

If a Document Template is not found for the Scheme, the system will find a Document Template with a PDF Process Type of CERT EXISTENCE that is not linked to a Scheme with a value for Language equal to the Language on the Natural Person record to which the Annuity record is linked.

 

If a Document Template is not found with a value for Language then the system will find the latest Document Template with a PDF Process Type of CERT EXISTENCE that is not linked to a Scheme.

 

If no value for Language is found for the Annuitant the Document Template will be used with a value for Language of ENGLISH

 

List

Click List below Certificate of Existence.  A list of bulk PDF files that have been created will be displayed for selection.

 

To view bulk PDF files that have been created, click on a hyperlinked file name in the File Name column. 

 

 

The file will be displayed in PDF format. 

 

The following is an example of a certificate of existence.