Tags for Annexures

ANNEXCLMNEW01  

Claim Dets New Claims - SR number

The Service Request number for the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW02  

Claim Dets New Claims - Process Name

The Process Name for the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW03  

Claim Dets New Claims - Activity status

The Activity Status of the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW04  

Claim Dets New Claims - Employer name

The Employer Name for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW05  

Claim Dets New Claims - Member number

The Member Number for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW06  

Claim Dets New Claims - Surname and initials  

The Surname and Initials for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW07  

Claim Dets New Claims - First name

The First Name for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW08  

Claim Dets New Claims - ID number  

The ID Number for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW09  

Claim Dets New Claims - Date of event

The Calculation Effective Date for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW10  

Claim Dets New Claims - Date initiated

The Notification Timestamp for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW11  

Claim Dets New Claims - Claim type

The Event Category for the Benefit Event on the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW12  

Claim Dets New Claims - Milestone

The Translation Value with a Translation Purpose of BENEFIT STATUS and with Source System Attributes of REQUEST STATUS/SCHEME where the Scheme Code equals the Scheme Code of the Scheme being processed and the BENEFIT STATUS equals the Benefit Request Status, where the Benefit Request Status is not CLIENT AUTH.  If not found, then the Translation Value for the Source System Attribute REQUEST STATUS.

The Translation Value with a Translation Purpose of BENEFIT STATUS and with Source System Attributes of BENEFIT UPDATE/SCHEME where the Scheme Code equals the Scheme Code of the Scheme being processed and the BENEFIT UPDATE is equal to the last processed Benefit Update Type, where the Benefit Request Status is CLIENT AUTH, TAX DIRECTIVE or PMT CHECKED.  If not found, then the Translation Value for the Source System Attribute BENEFIT UPDATE.

ANNEXCLMNEW13  

Claim Dets New Claims - Status

The Status on the Claim Details records for each Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMNEW14  

Claim Dets New Claims - Home loan

The value of the Settlement Amount field on the Membership Liability record with a Type of HOUSING LOAN for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMNEW15  

Claim Dets New Claims - Divorce order

The value of the Amount Liable field on the Membership Liability record with a Type of DIVORCE for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMNEW16  

Claim Dets New Claims - Maintenance order

The value of the Amount Liable field on the Membership Liability record with a Type of MAINTENANCE for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMNEW17  

Claim Dets New Claims - Comment

The text for the latest Notation record with a note type of BENEFIT PAYMENT linked to the member for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN or COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMPAID01

Claim Dets Paid Claims - SR number

The Service Request Number for the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is  COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID02

Claim Dets Paid Claims - Process Name

The Process Name of the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is  COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID03

Claim Dets Paid Claims - Activity status  

The Activity Status of the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is  COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID04

Claim Dets Paid Claims - Employer name

The Employer Name for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID05

Claim Dets Paid Claims - Member number

The Member Number for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID06

Claim Dets Paid Claims - Surname and initials

The Surname and Initials for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID07

Claim Dets Paid Claims - First name  

The First Name for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID08

Claim Dets Paid Claims - ID number  

The ID Number for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID09

Claim Dets Paid Claims - Date of event

ANNEXCLMPAID10

Claim Dets Paid Claims - Date initiated  

The Calculation Effective Date for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID11

Claim Dets Paid Claims - Claim type

The Event Category for the Benefit Event for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID12

Claim Dets Paid Claims - Date Paid

The Transaction Date of the last payment transaction for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID13

Claim Dets Paid Claims - Amount

The Gross Benefit Amount for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID14

Claim Dets Paid Claims - Tax

The Amount of the BENALPAYE business transaction for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

ANNEXCLMPAID15

Claim Dets Paid Claims - Net Amount  

ANNEXCLMPAID13 - ANNEXCLMPAID14

ANNEXCLMPAID16

Claim Dets Paid Claims - Payee

The Payee name on the Disposal Instructions for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.

All of the Payee Names are displayed if there is more than one Disposal Instruction other than the Tax Disposal Instruction. 

If The Payment Method is EFT, the bank account details (Account Number, Bank, Branch Name) are displayed.

ANNEXCLMPAID17

Claim Dets Paid Claims - Home Loan

The value of the Settlement Amount field on the membership Liability record with a Type of HOUSING LOAN for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMPAID18

Claim Dets Paid Claims - Divorce Order

The value of the Amount Liable field on the membership Liability record with a Type of DIVORCE for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMPAID19

Claim Dets Paid Claims - Maintenance Order

The value of the Amount Liable field on the membership Liability record with a Type of MAINTENANCE for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMPAID20

Claim Dets Paid Claims - Comment

The text for the latest Notation record with a note type of BENEFIT PAYMENT linked to the member for the Benefit Request linked to each Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is AUTHORISE BENEFIT and the Activity Status is COMPLETED and for which the Start Date is greater than or equal to the report From Date and less than or equal to the report To Date. 

ANNEXCLMOUTST01

Claim Dets Outstanding Claims - SR number

The Service Request Number for the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST02

Claim Dets Outstanding Claims - Process Name

The Process Name for the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST03

Claim Dets Outstanding Claims - Activity status

The Activity Status of the Service Requests for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST04

Claim Dets Outstanding Claims - Employer name

The Employer Name for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST05

Claim Dets Outstanding Claims - Member number

The Member Number for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST06

Claim Dets Outstanding Claims - Surname and initials

The Surname and Initials for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST07

Claim Dets Outstanding Claims - First name

The First Name for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST08

Claim Dets Outstanding Claims - ID number

The ID Number for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST09

Claim Dets Outstanding Claims - Date of event

The Calculation Effective Date for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST10

Claim Dets Outstanding Claims - Date initiated

The Notification Timestamp for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST11

Claim Dets Outstanding Claims - Claim type

The Event Category for the Benefit Event for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST12

Claim Dets Outstanding Claims - Date Paid

The Transaction Date of the last payment transaction for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST13

Claim Dets Outstanding Claims - Amount

The Gross Benefit Amount for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST14

Claim Dets Outstanding Claims - Tax

The Amount of the BENALPAYE business transaction for the Benefit Request linked to each Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCLMOUTST15

Claim Dets Outstanding Claims - Net Amount

ANNEXCLMOUTST13 - ANNEXCLMOUTST14

ANNEXCLMOUTST16

Claim Dets Outstanding Claims - Payee

The Payee name on the Disposal Instructions for the Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

All of the Payee Names are displayed if there is more than one Disposal Instruction other than the Tax Disposal Instruction.

If The Payment Method is EFT, the bank account details (Account Number, Bank, Branch Name) are displayed.

ANNEXCLMOUTST17

Claim Dets Outstanding Claims - Home Loan

The value of the Settlement Amount field on the membership Liability record with a Type of HOUSING LOAN for the Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMOUTST18

Claim Dets Outstanding Claims - Divorce Order

The value of the Amount Liable field on the membership Liability record with a Type of DIVORCE for the Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMOUTST19

Claim Dets Outstanding Claims - Maintenance Order

The value of the Amount Liable field on the membership Liability record with a Type of MAINTENANCE for the Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.  A Zero Value is displayed if no value is found.

ANNEXCLMOUTST20

Claim Dets Outstanding Claims - Comment

The text for the latest Notation record with a note type of BENEFIT PAYMENT linked to the member for the Benefit Request for which the Process is WITHDRAWAL, RETIRAL, DEATH, DISABILITY or PARTIAL WITHDRAWAL and the Activity Name is INITIATE EXIT, PROCESS EXIT, AUTHORISE BENEFIT and the Activity Status is OPEN and the Start Date is less than the report To Date.

ANNEXCASHFLOW01

Month 1 of cashflow period

ANNEXCASHFLOW02

Month 2 of cashflow period

ANNEXCASHFLOW03

Month 3 of cashflow period

ANNEXCASHFLOW04

Month 4 of cashflow period

ANNEXCASHFLOW05

Month 5 of cashflow period

ANNEXCASHFLOW06

Month 6 of cashflow period

ANNEXCASHFLOW07

Month 7 of cashflow period

ANNEXCASHFLOW08

Month 8 of cashflow period

ANNEXCASHFLOW09

Month 9 of cashflow period

ANNEXCASHFLOW10

Month 10 of cashflow period

ANNEXCASHFLOW11

Month 11 of cashflow period

ANNEXCASHFLOW12

Month 12 of cashflow period

ANNEXCASHFLOW13

Month 13 of cashflow period

ANNEXCASHFLOW14

Month 14 of cashflow period

ANNEXCASHFLOW15

Month 15 of cashflow period

ANNEXCASHFLOW16

Month 16 of cashflow period

ANNEXCASHFLOW17

Month 17 of cashflow period

ANNEXCASHFLOW18

Month 18 of cashflow period

OPENING BALANCE

Balance on the Scheme’s BANK account as at the start date of the month less 1 day i.e. the last day of the previous month.

INCOME

Contributions

Sum of the BT’s in the Scheme’s CONTRECVABLE account with an Accounting Activity equal to the Accounting Activities linked to the CONTRIBALLOC Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Fees

Sum of the BT’s in the Scheme’s FEERECVABLE account with an Accounting Activity equal to the Accounting Activities linked to the FEEALLOC Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Note: BT’s will only be found for this account if the fees are exclusive and not included in the contributions.

Risk Premiums

Sum of the BT’s in the Scheme’s PREMRECVABLE account with an Accounting Activity equal to the Accounting Activities linked to the PREMALLOC Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Note: BT’s will only be found for this account if the premiums are exclusive and not included in the contributions.

Section 14 Transfers

Sum of the BT’s in the Scheme’s CONTRECVABLE account with an Accounting Activity equal to the Accounting Activities linked to the TRFVALNET-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Unidentified Deposits

Sum of the BT’s in the Scheme’s UNKNOWNDEPOS account with an Accounting Activity equal to the Accounting Activities linked to the UNKNOWDEP-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Bank Interest

Sum of the BT’s in the Scheme’s BANKINTRECEI account with an Accounting Activity equal to the Accounting Activities linked to the BANKINTREC Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Other Income

Sum of the BT’s in the Scheme’s GENERALINCOM and SUNDRYINCOME accounts with an Accounting Activity equal to the Accounting Activities linked to the SUNDRY INCOME Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Include the Accounting Activity to which the other Accounting Activities are linked.

Reinsurance Proceeds

Sum of the BT’s in the Scheme’s COVERRECEIVA account with an Accounting Activity equal to the Accounting Activities linked to the DEPCOVERREC Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Disinvestments

Sum of the BT’s in the Scheme’s DISINVTRANST and INVESTMENT account with an Accounting Activity equal to the Accounting Activities linked to the DEPDISINV-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Note: In cases where Net Investment is used and transactions are not created in the DISINVTRANST account the disinvestment transactions must be retrieved from the INVESTMENT account.

TOTAL INCOME

Sum of INCOME values i.e. Contributions + Fees + Risk Premiums + Section 14 Transfers + Unidentified Deposits + Reinsurance Proceeds + Disinvestments

BENEFIT PAYMENTS

Death Claims

Sum of the BT’s in the Scheme’s BENPAYABLE and BENTRANSFER accounts with an Accounting Activity equal to the Accounting Activities linked to the BENPAYMENT Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Event Category is DEATH and the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Retirement Claims

Sum of the BT’s in the Scheme’s BENPAYABLE and BENTRANSFER accounts with an Accounting Activity equal to the Accounting Activities linked to the BENPAYMENT Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Event Category is RETIRAL and the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Withdrawal Claims

Sum of the BT’s in the Scheme’s BENPAYABLE and BENTRANSFER accounts with an Accounting Activity equal to the Accounting Activities linked to the BENPAYMENT Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Event Category is WITHDRAWAL and the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

Tax Directive Fees

SARS – PAYE

Sum of the BT’s in the Scheme’s PAYEPAYABLE account with an Accounting Activity equal to the Accounting Activities linked to the BENPAYEPAY-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

SARS – IT88

Sum of the BT’s in the Scheme’s BENPAYABLE account with an Accounting Activity equal to the Accounting Activities linked to the BENPAYMENT Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month and the Payee Name is SOUTH AFRICAN REVENUE SERVICES or SARS. Includes the Accounting Activity to which the other Accounting Activities are linked.

REINSURANCE PREMIUMS

The sub-heading name must be the Income Type Description.

Repeat for each Income Type retrieved.

Sum of the BT’s in the Scheme’s PREMPAYABLE account with an Accounting Activity equal to the Accounting Activities linked to the PREMPAYABL-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month per Income Type. Includes the Accounting Activity to which the other Accounting Activities are linked.

The BT’s are summed per Income Type and each row repeated for each Income Type.

FRONT OFFICE EXPENSES

The sub-heading name must be the Income Type Description.

Repeat for each Income Type retrieved.

Sum of the BT’s in the Scheme’s FO EXPENSES account with an Accounting Activity equal to the Accounting Activities linked to the FO EXPENSE-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month per Income Type. Includes the Accounting Activity to which the other Accounting Activities are linked.

The BT’s are summed per Income Type and the row repeated for each Income Type.

1

PRINCIPAL OFFICER EXPENSES

The sub-heading name must be the Income Type Description.

Repeat for each Income Type retrieved.

Sum of the BT’s in the Scheme’s PO EXPENSES account with an Accounting Activity equal to the Accounting Activities linked to the PO EXPENSE-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month per Income Type. Includes the Accounting Activity to which the other Accounting Activities are linked.

The BT’s are summed per Income Type and the row repeated for each Income Type.

2

TRUSTEE EXPENSES

The sub-heading name must be the Income Type Description.

Repeat for each Income Type retrieved.

Sum of the BT’s in the Scheme’s TRUSTEE EXP account with an Accounting Activity equal to the Accounting Activities linked to the TRUSTEEEXP-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month per Income Type. Includes the Accounting Activity to which the other Accounting Activities are linked.

The BT’s are summed per Income Type and the row repeated for each Income Type.

3

OPERATING EXPENSES

The sub-heading name must be the Income Type Description.

Repeat for each Income Type retrieved.

Sum of the BT’s in the Scheme’s GENERLEXPENS account with an Accounting Activity equal to the Accounting Activities linked to the GENRLEXPEN-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month per Income Type. Includes the Accounting Activity to which the other Accounting Activities are linked.

The BT’s are summed per Income Type and the row repeated for each Income Type.

INVESTMENTS

Sum of the BT’s in the Scheme’s INVESTTRANST and INVESTMENT accounts with an Accounting Activity equal to the Accounting Activities linked to the INVESTTRAN-A Accounting Activity on the Accounting Activity Association with a Type of CASH FLOW REP and for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month. Includes the Accounting Activity to which the other Accounting Activities are linked.

TOTAL EXPENSES

BENEFIT PAYMENTS (Death Claims + Retirement Claims + Withdrawal Claims + SARS PAYE + SARS IT88) + REINSURANCE PREMIUMS (Sum of Income Types)  + FRONT OFFICE EXPENSES (Sum of Income Types) + PRINCIPAL OFFICER EXPENSES (Sum of Income Types) + TRUSTEE EXPENSES (Sum of Income Types) + OPERATING EXPENSES (Sum of Income Types) + INVESTMENTS

CLOSING BALANCE AS PER CASHBOOK

OPENING BALANCE + TOTAL INCOME – TOTAL EXPENSES

CLOSING BALANCE AS PER BANK STATEMENT

Bank Statement balance as at the last day of the month

UNRECONCILED TRANSACTIONS

Sum of the BT’s in the Scheme’s BANK account for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month and for which the Reconciled Date is null minus the Sum of the Bank Statement transactions for which the Transaction Date is greater than or equal to the first day of the month and less than or equal to the last day of the month and for which the Reconciled Date is null and sum the amounts.