Cancellation Bulk Payment Association

Overview

The cancellation process makes use of the Bulk Payment Association table (Bulk Purpose of type BEN CANCELATION) to define the opposite/reversal accounting entry.

The cancellation code is divided into certain sections depending on the type of cancellation to be performed. Each of these cancellation types relate to a specific Sub Process on the association table (e.g. BENEFIT PAID, INSURED BENEFIT, PAYMENT).

Cancellation selections

The Reversal Activity will be created for those corresponding Source Activities found on the member account since the inception of the current Benefit Request timestamp. These cancellations sections are:

CANCEL NO REINVESTMENT LIVE PHI	Retrieves the transactions for each of the accounts configured on the Bulk Purpose Type of BEN CANCLE RULE (e.g. BENPAYABLE & TRF TO/F FND) with a Sub Process of PAYMENT.
	Retrieves the transactions for each of the accounts configured on the Bulk Purpose Type of BEN CANCLE RULE (e.g. COVERRECEIVA) with a Sub Process of INSURED BENEFIT
	For the matching transactions associated to the NO REINVESTMENT Sub Process, further processing the current BT is ignored when the cancellation type is NO REINVESTMENT
	Bonus Transactions are not reversed at current date. The Due date is set to the CAR end date and the Effective remains as is. The Sub Process of BONUS TRNSACTNS defines those transactions.
EXIT IN PROCESS	Retrieves the transactions for each of the accounts configured on the Bulk Purpose Type of BEN CANCLE RULE (e.g. BENPAYABLE & TRF TO/F FND) with a Sub Process of BENEFIT PAID
EXIT IN PROCESS	Retrieves the transactions for each of the accounts configured on the Bulk Purpose Type of BEN CANCLE RULE (e.g. COVERRECEIVA) with a Sub Process of INSURED BENEFIT

The list of activities against which the Financial Period Calendar checks are performed, make use of the FINAN CALENDAR Bulk Purpose with the Sub Process of PAYMENT. The Source and ‘Reversal’ Activities are retrieved from the association table and this list is used for selection purposes in the code.

BULK PURPOSE	SUB-PROCESS	SOURCE ACTIVITY	REVERSAL ACTIVITY
BEN CANCELATION	BENEFIT PAID	BENALLATEINT	BENLATEINTRV
BEN CANCELATION	BENEFIT PAID	BENALPAYE	BENALPAYEREV
BEN CANCELATION	BENEFIT PAID	BENPAYAMNT	BENPAYAMNTRV
BEN CANCELATION	BENEFIT PAID	BENTRANSFER	BENTRNSFERRV
BEN CANCELATION	BENEFIT PAID	BENTRANSFRGP	BENTRFGPREV
BEN CANCELATION	BENEFIT PAID	BULKPAYAMTGP	BPAYAMTGPRV
BEN CANCELATION	BENEFIT PAID	PURCHPENSION	PURCHPENREV
BEN CANCELATION	BONUS TRNSACTNS	MEMRLBONREV	MBONRLNEGREV
BEN CANCELATION	BONUS TRNSACTNS	MEMRLBONREV	MBONRLNEGREV
BEN CANCELATION	BONUS TRNSACTNS	MEMRLBONREV	MEMBENRLINV
BEN CANCELATION	INSURED BENEFIT	BENFETCHRISK	BENREVRISK
BEN CANCELATION	INSURED BENEFIT	BENINSUREFAM	BENINSUREFAMRV
BEN CANCELATION	INSURED BENEFIT	BENINSUREPBL	BENINSUREPBR
BEN CANCELATION	INSURED BENEFIT	RISKADJNEG	RISKADJNEGRV
BEN CANCELATION	INSURED BENEFIT	RISKADJPOS	RISKADJPOSRV
BEN CANCELATION	INSURED BENEFIT	RISKDEFICIT	RISKDEFICITR
BEN CANCELATION	INSURED BENEFIT	RISKSURPLUS	RISKSURPLUSR
BEN CANCELATION	NO REINVESTMENT	MEMBENRLBON	MBENRLBONNEG
BEN CANCELATION	NO REINVESTMENT	MEMBENRLBON	MEMBENRLUNT
BEN CANCELATION	NO REINVESTMENT	MEMBENRLBON	MEMBENRLINV
BEN CANCELATION	NO REINVESTMENT	MEMBENRLBON	REALDATEADJP
BEN CANCELATION	NO REINVESTMENT	MEMBENRLBON	REALDATEADJN
BEN CANCELATION	PAYMENT	ACTRESTREV	ACTUARIALRES
BEN CANCELATION	PAYMENT	ACTUARIALRES	ACTRESTREV
BEN CANCELATION	PAYMENT	BENADJNEG	BENADJNEGREV
BEN CANCELATION	PAYMENT	BENALPROFIT	BENPROFITREV
BEN CANCELATION	PAYMENT	BENDEFICIT	BENDEFICITRV
BEN CANCELATION	PAYMENT	BENENHANCE	REVBENHANCE
BEN CANCELATION	PAYMENT	BENEXITCONNG	BENEXCONNGRV
BEN CANCELATION	PAYMENT	BENEXITCONTR	BENEXITCONRV
BEN CANCELATION	PAYMENT	BENFETCHRISK	BENREVRISK
BEN CANCELATION	PAYMENT	BENINSUREFAM	BENINSUREFAMRV
BEN CANCELATION	PAYMENT	BENINSUREFAMRV	BENINSUREFAM
BEN CANCELATION	PAYMENT	BENINSUREPBL	BENINSUREPBR
BEN CANCELATION	PAYMENT	BENINSUREPBR	BENINSUREPBL
BEN CANCELATION	PAYMENT	BENSURPLUS	BENSURPLUSRV
BEN CANCELATION	PAYMENT	MBENRLBONNEG	MBONRLNEGREV
BEN CANCELATION	PAYMENT	MBENRLBONNEG	BPBLBONNGREV
BEN CANCELATION	PAYMENT	MEDSUBSIDY	MEDSUBSIDYREV
BEN CANCELATION	PAYMENT	MEDSUBSIDYREV	MEDSUBSIDY
BEN CANCELATION	PAYMENT	MEMBENRLBON	MEMRLBONREV
BEN CANCELATION	PAYMENT	MEMBENRLBON	BENPBLBONREV
BEN CANCELATION	PAYMENT	MEMBENRLINV	BENREALREV
BEN CANCELATION	PAYMENT	MEMBENRLUNT	BENREALREV
BEN CANCELATION	PAYMENT	MINBENADJNEG	MINBENADJNER
BEN CANCELATION	PAYMENT	MINBENADJNER	MINBENADJNEG
BEN CANCELATION	PAYMENT	MINBENADJPOR	MINBENADJPOS
BEN CANCELATION	PAYMENT	MINBENADJPOS	MINBENADJPOR
BEN CANCELATION	PAYMENT	MININDIVRES	MININDIVRESR
BEN CANCELATION	PAYMENT	MININDIVRESR	MININDIVRES
BEN CANCELATION	PAYMENT	PENCAPVALREV	PENCAPVALUE
BEN CANCELATION	PAYMENT	PENCAPVALUE	PENCAPVALREV
BEN CANCELATION	PAYMENT	PENSIONVALRV	PENSIONVALUE
BEN CANCELATION	PAYMENT	PENSIONVALUE	PENSIONVALRV
BEN CANCELATION	PAYMENT	REALDATEADJN	RLDTEADJNREV
BEN CANCELATION	PAYMENT	REALDATEADJP	RLDTEADJPREV
BEN CANCELATION	PAYMENT	REFNDCONTREV	REFUNDCONTRB
BEN CANCELATION	PAYMENT	REFUNDCONTRB	REFNDCONTREV
BEN CANCELATION	PAYMENT	TAXDIRFEEPBL	TAXDIRFEEREV
BEN CANCELATION	PAYMENT	TAXDIRFEEREV	TAXDIRFEEPBL
BEN CANCELATION	PAYMENT	TERMINATE FEE	TERMINATFEER
BEN CANCELATION	PAYMENT	TERMINATFEER	TERMINATE FEE
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENPAYBLEINV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENPAYBLEBON
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENPBLEBONNG
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENPBLBONREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BPBLBONNGREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENFETCHRISK
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENREVRISK
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENALPAYE
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENALPAYEREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	TAXDIRFEEPBL
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	TAXDIRFEEREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	TERMINATFEER
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	TERMINATE FEE
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENENHANCE
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	REVBENHANCE
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENADJNEG
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENADJNEGREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENALLATEINT
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENLATEINTRV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	RISKADJNEG
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	RISKADJPOS
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	RISKADJNEGRV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	RISKADJPOSRV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENALPROFIT
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENPROFITREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENDEFICIT
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENDEFICITRV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENSURPLUS
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENSURPLUSRV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	REFUNDCONTRB
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	REFNDCONTREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	ACTUARIALRES
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	ACTRESTREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	PENCAPVALUE
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	PENCAPVALREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	PENSIONVALRV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	PENSIONVALUE
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENINSUREPBL
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENINSUREPBR
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENINSUREFAM
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENINSUREFAMRV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	PURCHPENSION
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	PURCHPENREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENEXITCONTR
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENEXITCONNG
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MININDIVRES
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MININDIVRESR
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MINBENADJPOS
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MINBENADJNEG
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MINBENADJPOR
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MINBENADJNER
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	BENREALREV
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MEDSUBSIDY
FINAN CALENDAR	PAYMENT	BENPAYBLEUNT	MEDSUBSIDYREV

Summary

The follow cancellation types will reverse the accounting activities defined in the respective Sub Process Types:

CANCELLATION TYPE	SUB PROCESS	NOTES
CANCEL	PAYMENT	e.g. MEMBENRLUNT
NO REINVESTMENT	PAYMENT
NO REINVESTMENT	NO REINVESTMENT	Exclude these transactions
LIVE	PAYMENT
LIVE	BENEFIT PAID	e.g. BENPAYMENT, BENTRANSFER etc.
EXIT IN PROCESS	BENEFIT PAID
PHI	none	Request and Membership status updated only

The following default values will be set up for the BEN CANCEL RULE:

BULK PURPOSE	SUB PROCESS	ACCOUNT	ACTIVITY
BEN CANCEL RULE	INSURED BENEFIT	COVERRECEIVA	COVERREIVE
BEN CANCEL RULE	PAYMENT	BENPAYABLE	BENBENPAYTRN
BEN CANCEL RULE	PAYMENT	TRF TO/F FND	TRF TO/F FND

For the Sub Process of INSURED BENEFIT, the process retrieves the member transactions in the COVERRECEIVA account (using the COVERREIVE accounting activity to do this). The same process is followed for each of those accounts specified by the PAYMENT sub process.

When determining what transactions to write to the Income Transaction Detail record (JUF02), the current process retrieves all balances in the BENPAYABLE account for the member. In addition to the above, balances in the TRF TO/F FND are also read for the specific accounting activities defined within the TRNF2FND TRANS sub process for the Bulk Purpose of BEN CANCEL TRAN.

BULK PURPOSE	SUB PROCESS	ACCOUNT	ACTIVITY
BEN CANCEL TRAN	TRNF2FND TRANS		MEMBENMVUNIT
BEN CANCEL TRAN	TRNF2FND TRANS		MEMBENRLBON
BEN CANCEL TRAN	TRNF2FND TRANS		MEMBENRLBONM
BEN CANCEL TRAN	TRNF2FND TRANS		MEMBENRLINV
BEN CANCEL TRAN	TRNF2FND TRANS		MEMBENRLUNT

Changes made in October 2010

In addition to the Bulk Purpose Type of BEN CANCELATION that the program uses to identify the reversal accounting entry to create, a new Bulk Purpose type of BEN CANCEL RULE and Sub Process types of PAYMENT and INSURED BENEFIT have been created to dynamically identify from which account(s) to retrieve the member’s transactions.

The cancellation program had previously hard coded BENPAYBLE as the account for the PAYMENT Sub Process and COVERRECEIVA for the INSURED BENEFIT Sub Process. These accounts are now configurable under the BEN CANCEL RULE Bulk Purpose Type and the accounting activity defined with each account is used to identify the accounting rule to use to retrieve the transactions. The existing default values have been scripted and in addition, the TRF TO/F FND account has been added to the PAYMENT Sub Process.

When determining what transactions to write to the Income Transaction Detail record (used by BJU3AH to reinvest the monies), the current process retrieves all balances in the BENPAYABLE account for the member. In addition to the BENPAYABLE account balances, a Bulk Purpose Type of BEN CANCEL TRAN with a Sub Process of TRNF2FND TRANS has been created to define specific accounting activities from which balances also need to be extracted and written to the Income Transaction Detail record.

The following accounting activities have been scripted for this rule:

- MEMBENMVUNIT

- MEMBENRLBON

- MEMBENRLBONM

- MEMBENRLINV

- MEMBENRLUNT