The Exit Values report is extracted for benefit payments with a Date of Exit that falls within the From Transaction Date and To Transaction Date specified for the report.
The purpose of this report is to display the details of the Benefit Payable Creditors (outstanding balances). This report displays various amount breakdowns from the Benefit Payable account, as at a specific point in time for a specific exit date range.
The amount fields on the report are taken directly from the member accounts. If the Benefit Payable account balance is zero, the payable gross benefit amount will be the amount that has been calculated on the web site.
This report will include members for whom an exit date has been captured on a closed payroll cycle, but for whom a claim has not yet been initiated under benefit administration.
If this report is to be made available on the employer web site, it must be authorized. Refer to Authorise below.
When a batch run is scheduled and the scheme selected is a Main Umbrella scheme, then the data will be extracted per Sub-Umbrella scheme linked to the Main Umbrella scheme, thereby grouping the information per Sub-Umbrella scheme, in one report.
This report is generated by a batch run. The process involves four distinct steps:
- schedule the batch run
- submit the batch run job
- monitor the progress of the batch run
- view the report
These steps are described elsewhere in the manual. For details, refer to Batch Runs.
For information on scheduling and submission of the batch run for this report, refer to
Infrastructure
Batch
Create a new batch run, or change the parameters of an existing batch run.
For information on scheduling a batch run, refer to Schedule a batch run under
Infrastructure
Batch
Maintain Batch Schedule
From the JAJU Batch Structure screen, select the batch group named EXIT VALUES.
Specify the FROM TRANSACTION DATE and TO TRANSACTION DATE values.
Note:
Transaction Date
- The transaction dates are used to determine which payments in the benefit payable account must be included in the amounts paid column. This only includes actual member payment accounting activities (such as BENPAYAMNT, BENTRANSFER, etc.), but excludes accounting activity BENALPAYE. If the payment date (transaction) does not fall within the period, the payment amount is excluded. If no FROM TRANSACTION DATE is coded, the scheme commencement date is used.
Exit Date
- All members with an exit date within the period specified will be included.
Quotes
- For DB benefits (FAS) products, the amount will be zero.
- The quoted settlement amount is the settlement amount captured.
- The quoted benefit tax amount is the amount captured under the tax directive benefit update type.
Other Claims
- In the payable account, the accounting data from the benefits payable account is extracted.
Quoted Indicators
- P = an amount is in the payable account, but realisation has not yet been finalised.
- Q = no amount is in the payable account.
- Space = an amount is in the payable account, and realisation has been finalised.
Note:
For a DB benefit, if there is an amount in the payable account, the quoted indicator will be spaces.
Specify the Report Criteria that must be used for this report.
Refer to Submit a batch run job and Monitor progress of the batch run under
Reports
Batch Runs
The following is the batch job to be submitted.
|
BATCHJOB41 |
Exit Values |
JU4AD_EXVAL\BJU4ADO0.BAT |
Once the batch run has taken place, the report will become available.
Refer to
Reports
Accessing the Reports
From the Exits menu, click alongside Exit Values on the sub-menu on the left. Additional options will be displayed.
Click View below Exit Values. The Report Selection screen will be displayed.
The following columns are displayed:
- Scheme Code
- Timestamp
- Date captured
- Report Type
- Report Seq No
- Action
To select a report, click on the hyperlinked display in the Action column alongside the appropriate report.
The Report Selection screen will be displayed.
The following columns are displayed:
- Paycentre
- Reference
- Co Reference
- Surname
- Initials
- Date of Birth
- Ben Category
- Date of Exit
- Event Category
- Status
- Quote
- Quoted Gross Benefit
- Quoted Liabilities
- Quoted Benefit tax
- Payable Gross Benefit
- Payable Adjustments
- Benefit Tax
- Amounts Paid
- Outstanding Amount
- Type of Event
- Branch
- Tax Amount Paid
- Tax Payment Date
- Request No
When the report is exported to a CSV file, the report will include the Benefit Request Number.
Main Umbrella Schemes
If the Report is for a Main Umbrella Scheme, the data will be extracted per Sub Umbrella Scheme linked to the Main Umbrella Scheme, and displayed in one report.
The same information as per the Sub Umbrella reports is displayed and the information is grouped per Sub Umbrella scheme, and sorted per Scheme code as follows:
- Numeric codes Ascending order
- Alpha codes Alphabetical order
- Combination codes Alphabetical order
When a report is selected, the same report is displayed on the Report Selection screen.
Click Authorise below Exit Values. The Report Selection screen will be displayed.
The following columns are displayed:
- Scheme Code
- Timestamp
- Date captured
- Report Type
- Report Seq No
- Action
To authorize a report, click on the hyperlinked Authorise in the Action column alongside the appropriate report. The Authorise Reports screen will be displayed.
A message will confirm that the report has been authorized.