Batch Selection Criteria (Infrastructure Maintain Batch Schedule)

Adding batch selection criteria

Highlight a Batch Selection Criteria item, then click ADD.  Depending on the Batch Selection Criteria item selected, different screens may be displayed for the selection of the particular criteria to be applied.

 

Note:

More than one selection may usually be made.  In each case, select the same Batch Selection Criteria item, click ADD, then from the screen displayed, a different selection can be made.

 

The batch selection criteria are displayed in the lower section of the Report Criteria screen.

 

In some cases, the selected Batch Selection Criteria requires further selections to be made.  The following table lists all Batch Selection Criteria and indicates whether a further selection is required:

 

BATCH SELECTION CRITERIA

SELECT A VALUE FROM SCREEN

ANNUITNT STATUS

JALS Permitted Value List

ADDITIONAL INC

JALS Permitted Value List

B/DATED SRV DTE

None

BENEFICIARIES

None

BENEFIT EVENT

BIAB Benefit Event List

EXCL MEMBER STATUS

JALS Permitted Value List

EXCL PAY CENTRE

JU1DL Scheme Pay Centre List

Note:
This selection allows Debit Order Umbrella funds the option to exclude pay centres on the system when scheduling benefit statements.

EXCLUDE MEMBERS

JAJZ Select Members for Batch Run.

 

The Members selected will be excluded when the Benefit Statement batch job is run.

EXIT DATE

Batch Selection Exit Dates

EXIT STATUS

JAJV Exit Status Selection

EXPENSE TYPE

Scheme Global Type List

FLEXIBLE STMNT

None

Note:
When the Benefit Statement batch job runs and one of the criteria selected on the JAJV Schedule Scheme for Batch Run is FLEXIBLE STMNT, the system will read the Document Template with a Template Type of BEN STATEMENT linked to the Scheme and create the Benefit Statements as per the Template.

If FLEXIBLE STMNT is not selected, the system will create the Benefit Statements as per the existing template.

FORMAT

JAJW Benefit Statement Format

INCLUDE EXITS

None

INCLUDE MEMBERS

JAJZ Select Members for Batch Run.

 

The Members selected will be included when the Benefit Statement batch job is run.

INSURER

JU1AP Corporate Client

LIABILITIES

None

MEMBER DETAILS

None

MEMBER LEVEL

None

MEMBER STATUS

JALS Permitted Value List.

 

If a Membership Status was selected, the system will create Benefit Statements for the Members with the Membership Status selected, as at the Effective Date of the Benefit Statement.

MEMBERSHIP

JAJZ Select Members for Batch Run

MEMBERSHIP CATEGORY

JU1BR Scheme Membership Group List

MEMBERSHIP GRP

None

MS EXCEL FILE

None

PART (PARTICIPATING) EMPLOYER

JU1BW Scheme Participating Employers.

When the Benefit Statement batch job is run, if one or more Participating Employers were selected then the system will create Benefit Statements for the Members associated to a Pay Centre linked to the Participating Employer selected.

PAY CENTRE

JU1DL Scheme Pay Centre List

PDF DOCUMENT

None

PENS SERV DATE

None

PERSON DETAILS

None

PORTFOLIO

JU1BV Scheme Portfolio List

PROVISIONAL INT

None

PURPOSE

Benefit Statement Purpose Selection

SALARY

None

TEMP ABSENCE

None

TRAN (TRANSACTION) DATE

JAJV Batch Date Selection

 

Batch Selection Criteria = ANNUITNT STATUS

The JALS Permitted Value List screen will be displayed.

 

 

Select an annuitant status, then click SELECT.

 

The following statuses are available for selection:

A

Active as at the start of the reporting period and as at the end of the reporting period.

E

Annuity ceased during the reporting period.

N

Annuity commenced during the reporting period.

R

Annuity was suspended as at the start of the annuity period and was active as at the end of the reporting period.

S

Annuity was suspended as at the end of the reporting period.

 

Batch Selection Criteria = ADDITIONAL INC

The JALS Permitted Value List screen will be displayed.

 

 

Select a payment type, then click SELECT.

 

The following values are available for selection:

- EX GRATIA

- HOUSING SUBSIDY

- MED AID ER CONT

- MED AID SUBSIDY

- VOUCHER

 

Batch Selection Criteria = BENEFIT EVENT

The BIAB Benefit Event List screen will be displayed.

 

 

Select a benefit event, then click SELECT.

 

Batch Selection Criteria = EXCL MEMBER STATUS

The JALS Permitted Value List screen will be displayed.

 

 

Select a Membership Status and click SELECT.

 

Batch Selection Criteria = EXCL PAY CENTRE

The JU1DL Scheme Pay Centre List screen will be displayed.

 

 

Select a Pay Centre, then click SELECT.

 

 

Batch Selection Criteria = EXCLUDE MEMBERS

If INCLUDE MEMBERS has already been selected as a Batch Selection Criteria and then EXCLUDE MEMBERS is selected, the following message will be displayed:

 

Selection NOT allowed together with INCLUDE MEMBERS

 

 

Click OK to remove the message and consider changing the Batch Selection Criteria selection made for the inclusion / exclusion of members.

 

The following message will be displayed if large volumes of data are expected:

 

This function sorts large volumes of data and therefore response times may be slow.  Do you wish to continue?

 

 

To continue, click YES.  The JAJZ Select Members for Batch Run screen will be displayed.

 

 

To search for members to be excluded, click SEARCH.  The JAJZ Search Criteria screen will be displayed.

 

 

This screen enables you to select either a specific person, or to filter the memberships available for selection.

 

To select a specific member, enter the surname and / or initials, or enter the reference number, in the appropriate fields.

 

To list all members of a particular membership type, select the appropriate type from the MEMBERSHIP TYPE drop-down list.

 

To select only those members who have been reinstated, place a tick in the box alongside REINSTATED.

 

If no selections are made, a list of all members will be displayed.

 

Click OK.  The JAJZ Select Members for Batch Run screen will be displayed.

 

 

The Potential pane on the left displays all the members that are available for selection.  Highlight the required member and click INSERT to move it to the Selected pane on the right.  Repeat this process until all selections have been made.

 

 

To remove a member from the Selected pane, highlight the relevant member and click REMOVE.

 

To view details for a member, highlight the relevant member and click SELECT.  The JAJZ Personal and Membership Details screen will be displayed.

 

 

To return to the Select Members for Batch Run screen, click OK.

 

Once all selections have been made, select Close Batch Run Selection.

 

Batch Selection Criteria = EXIT DATE

The Batch Selection Exit Dates screen will be displayed.

 

 

 

Enter dates in the FROM EXIT DATE and TO EXIT DATE fields to define the period for which exits must be displayed, then click OK.

 

Batch Selection Criteria = EXIT STATUS

The JAJV Exit Status Selection screen will be displayed.

 

The Potential pane on the left displays all the exit statuses available for selection.  Highlight the required exit status and click INSERT to move it to the Selected pane on the right.  Repeat this process until all selections have been made, then click OK.

 

Batch Selection Criteria = EXPENSE TYPE

The Scheme Global Type List screen will be displayed.

 

 

Highlight the required global type, then click SELECT.

 

Batch Selection Criteria = FORMAT

The JAJW Benefit Statement Format screen will be displayed.

 

 

Select a benefit statement format, then click SELECT.

 

Batch Selection Criteria = INCLUDE MEMBERS

If EXCLUDE MEMBERS has already been selected as a Batch Selection Criteria and then INCLUDE MEMBERS is selected, the following message will be displayed:

 

Selection NOT allowed together with EXCLUDE MEMBERS

 

 

Click OK to remove the message and consider changing the Batch Selection Criteria selection made for the inclusion / exclusion of members.

 

The following message will be displayed if large volumes of data are expected:

 

This function sorts large volumes of data and therefore response times may be slow.  Do you wish to continue?

 

 

To continue, click YES.  The JAJZ Select Members for Batch Run screen will be displayed.

 

 

To search for members to be included, click SEARCH.  The JAJZ Search Criteria screen will be displayed.

 

 

This screen enables you to select either a specific person, or to filter the memberships available for selection.

 

To select a specific member, enter the surname and / or initials, or enter the reference number, in the appropriate fields.

 

To list all members of a particular membership type, select the appropriate type from the MEMBERSHIP TYPE drop-down list.

 

To select only those members who have been reinstated, place a tick in the box alongside REINSTATED.

 

If no selections are made, a list of all members will be displayed.

 

Click OK.  The JAJZ Select Members for Batch Run screen will be displayed.

 

 

The Potential pane on the left displays all the members that are available for selection.  Highlight the required member and click INSERT to move it to the Selected pane on the right.  Repeat this process until all selections have been made.

 

 

To remove a member from the Selected pane, highlight the relevant member and click REMOVE.

 

To view details for a member, highlight the relevant member and click SELECT.  The JAJZ Personal and Membership Details screen will be displayed.

 

 

To return to the Select Members for Batch Run screen, click OK.

 

Once all selections have been made, select Close Batch Run Selection.

 

Batch Selection Criteria = INSURER

The JU1AP Corporate Client screen will be displayed.

 

 

Select a Corporate Client, then click SELECT.

 

Batch Selection Criteria = MEMBER CATEGORY

The JU1BR Scheme Membership Group List screen will be displayed.

 

 

Select a membership group type from the drop-down box, then select the relevant membership group, then click SELECT.

 

Batch Selection Criteria = MEMBER LEVEL

The JAJV Member Level Transactions screen will be displayed.

 

 

Click the YES or NO radio buttons to indicate whether or not accounting transactions must be created at a member level.

 

Note:

This must only be used where the expense is not deducted from the member's contribution under Income Administration.  It would typically be used for risk premiums calculated using a rate per R1 000 of cover, or based on age.

 

Once a selection has been made, click OK.

 

Batch Selection Criteria = MEMBER STATUS

The JALS Permitted Value List screen will be displayed.

 

 

Select a member status, then click SELECT.

 

Note:

The following statuses are available for selection:

A (Active)

Members active as at the start and end date

E (Exited)

Members active as at the start date, and not active as at the end date

N (New)

Members not active as at the start date, and active as at the end date

NE (New/Exited)

Members active during the period, but not as at the start and end dates

 

Batch Selection Criteria =MEMBERSHIP

An Information message will be displayed.

 

This function sorts large volumes of data and therefore response times may be slow.  Do you wish to continue?

 

 

To continue, click YES.  The JAJZ Select Members for Batch Run screen will be displayed.

 

 

To search for members to be included, click SEARCH.  The JAJZ Search Criteria screen will be displayed.

 

 

This screen enables you to select either a specific person, or to filter the memberships available for selection.

 

To select a specific member, enter the surname and / or initials, or enter the reference number, in the appropriate fields.

 

To list all members of a particular membership type, select the appropriate type from the MEMBERSHIP TYPE drop-down list.

 

To select only those members who have been reinstated, place a tick in the box alongside REINSTATED.

 

If no selections are made, a list of all members will be displayed.

 

Click OK.  The JAJZ Select Members for Batch Run screen will be displayed.

 

 

The Potential pane on the left displays all the members that are available for selection.  Highlight the required member and click INSERT to move it to the Selected pane on the right.  Repeat this process until all selections have been made.

 

 

To remove a member from the Selected pane, highlight the relevant member and click REMOVE.

 

To view details for a member, highlight the relevant member and click SELECT.  The JAJZ Personal and Membership Details screen will be displayed.

 

 

To return to the Select Members for Batch Run screen, click OK.

 

Once all selections have been made, select Close Batch Run Selection.

 

Batch Selection Criteria = MEMBERSHIP CATEGORY

The JU1BR Scheme Membership Group List screen will be displayed.

 

 

Select a membership group type from the drop-down box, then select the relevant membership group, then click SELECT.

 

Batch Selection Criteria = PART (PARTICIPATING) EMPLOYER

The JU1BW Scheme Participating Employers screen will be displayed.

 

 

Highlight a Participating Employer and click SELECT.

 

Batch Selection Criteria = PAY CENTRE

The Scheme Pay Centre List screen will be displayed.

 

 

Select a pay centre, then click SELECT.

 

Batch Selection Criteria = PORTFOLIO

The JU1BV Scheme Portfolio List screen will be displayed.

 

 

Select a Portfolio, then click SELECT.

 

Batch Selection Criteria = PROVISIONAL INT

This item will be displayed in the lower section of the Report Criteria screen.  When the report is extracted, the interim bonus rate percentage for each of the portfolios will be used to calculate the benefit (STD only).  This rate will also be used to calculate the interest when calculating withdrawal profits and switch profits/losses.

 

Batch Selection Criteria = PURPOSE

The Benefit Statement Purpose Selection screen will be displayed.

 

 

Select ANNUAL or OTHER from the drop-down list and click OK.

 

Batch Selection Criteria = TRAN (TRANSACTION) DATE

The JAJV Batch Date Selection screen will be displayed.

 

 

Capture the From and / or To Dates and click OK.

 

From the Report Criteria screen, click CLOSE to return to the Schedule Scheme for Batch Run screen.

 

Once all of the parameters have been correctly set, click OK.  The batch run, and any additional criteria selected, is added to the list on theMaintain Batch Schedule screen.

 

Note:

The PROCESSED DATE field on the Maintain Batch Schedule screen will be blank, as the batch run still has to be processed.

 

Valuation batch groups

If the Batch Group selected is VALUATION, the system will check if there is an existing Batch Schedule for the same Scheme with a Batch Group of VALUATION.

 

If the Report Criteria selected are the same as the existing Batch Schedule, the system will check that the period for the new Batch Run does not overlap with the existing Batch Schedule i.e. the From Effective Date is not less than the To Effective Date of the existing Batch Schedule.  If it does, the following error message will be displayed:

 

A valuation report has been scheduled for this Scheme with the same criteria and for the same period and must either complete or be deleted before another one can be scheduled.

 

 

Click OK to remove the message.

 

Main umbrella schemes

If a batch job has been scheduled for a main umbrella scheme and jobs are already scheduled or currently running, the following warning message will be displayed:

 

The selected scheme is a main umbrella scheme and there are already jobs scheduled, or in a busy (B) status for the selected run type.  These jobs must be completed, cleared or set to E before a main umbrella scheme can be scheduled.  There may be jobs left in a status of B due to a previous incomplete run.  Would you like to clear any such jobs that are older than 48 hours and set the status to E?

 

 

Click YES to clear any jobs that are older than 48 hours.

 

If there are still other batch jobs that need to be cleared or completed, the following message will be displayed:

 

Jobs left in a status of B and older than 48 hours have been removed, however there are still other jobs that need to be cleared or completed.  Please address this before attempting to reselect this Batch Group.

 

 

Click OK to remove the message.  Clear the jobs that are still running and / or wait until other jobs have completed.

 

View existing batch selection criteria

To view the various selection criteria defined for a batch run, highlight the required batch run on the JAJV Maintain Batch Schedule screen and select Batch Selection Criteria from the sub-menu on the left.

 

 

The Batch Schedule Criteria screen will be displayed.

 

 

The screen displays the Batch Group and the Benefit Selection Criteria that have been selected.  The Captured Date field includes both the date captured as well as the Timestamp.  This allows multiple batch jobs to be run for the same Batch Group for the same effective date.