prj hk afs handling for reinstated policies_utr(opening balance ) v1.0(1)
DESCRIPTION
Opening balance in insurance calculationTRANSCRIPT
Build Process
Build Process
Test Specification
Project Details
Application Name
Regional Life System (RLS)
Project No.
PRJ-2013-0001460
Project Name
PRJ HK AFS Handling for Reinstated Policies
Document Authorized By
Name
Firstname & Surname & TitleSignatureDate
Document Control
Version
Number
n.nIssued
On Date
YYYY/MM/DDAuthor(s)
Firstname & Surname
& TitleReviewer(s)
Firstname & Surname
& TitleChange Description
1.02014/01/051460 Talwar(TCS Consultant) Shashank Shekhar(TCS Consultant)
Document Creation
TABLE OF CONTENTS
31.OBJECTIVE .
2.SCOPE / Assumption32.1In Scope32.2Out of Scope32.3Assumptions33.Testing cycles / schedules34.TEST procedure / environment setup34.1Environment setup:34.2Test procedure:4TEST CASE55.TEST Results75.1Test Case Result 175.2Test Case Result 2155.3Test Case Result 315
1. OBJECTIVE.The requirement focuses to deliver all requirements, in which for reinstated policies, the unit-linked AFS will be able to display the correct opening balance.2. SCOPE / Assumption
2.1 In Scope
1. All unit-linked Anniversary Financial Statements (STA-C2)
2. 1G/2G and 3G policies are in scope for basic premium and total premium.
3. HK and Macau environment. 4. Only RLS system is in scope.
2.2 Out of Scope
1. All other region except HK and MA region.
2. All other letter types other than AFS (STA-C2).
3. ODS program is out of Scope for opening balance calculation and Net Change.
4. Any existing production bug.
2.3 Assumptions
1. No change in the structure of Annual financial statement.
2. No change in the logic for the generation of financial statement.
3. Basic premium, total premium will follow the existing system logic except in case of reinstatement.
3. Testing cycles / schedules
N/A
4. TEST procedure / environment setup
4.1 Environment setup:
CALL LBUHKUUTL1/IFLNITUAT4.2 Test procedure:
TEST CASE
No.Functions / ObjectivesDescription / ConditionsExpected / Actual ResultsResult
(/ )Retest Result / Date
1st (/ )2nd (/ )
1. To verify whether the Opening account balance is calculated correctly when-
1) 1st reinstatement is done on the policy
2) At least one AFS has been issued before 1st reinstatement (Active Case)PNO: 503-5814630Plan Code: PULF25Policy type : 2G
Lapse Date: Region :HKReinstatement Eff Date: 2012/11/28Policy effective date: 2012/01/12Anniversary Date: 2015/01/12AFS generation date/System date:
2014/12/15
Correct regular premium and Total premium is generated in AFS.
Regular premium doesnt include transaction generated during lapsation (transaction effective date = 0)
Refer to Test Case Result 1
Case 6To check net change is calculated correctly in AFS when - 1) Reinstatement is captured, reversed and captured again during the first year since policy issue.
PNO: 503-8094404Plan Code: PULF25Policy type : 2G
Lapse Date: 2013/09/14Region :HKReinstatement Effective Date: 2013/09/19
Policy effective date: 2013/12/20
Anniversary Date: 2014/12/20
AFS generation date/System date:
2014/12/19
Correct regular premium and Total premium is generated in AFS.
Regular premium doesnt include transaction generated during lapsation (transaction effective date = 0)
Refer to Test Case Result 2
Case 5To check net change is calculated correctly in AFS when - 1) 2 reinstatements is done.
2) 1 AFS is issued before the 1st reinstatement.
3) 1 AFS has is generated between the first and second reinstatements.
PNO: 503-5692101Plan Code: NOVA25Policy type : 2G
Lapse Date: Region :HKReinstatement Effective Date: 2013/09/19
Policy effective date: 2013/12/20
Anniversary Date: 2014/12/20
AFS generation date/System date:
2014/12/19
Correct regular premium and Total premium is generated in AFS.
Regular premium doesnt include transaction generated during lapsation (transaction effective date = 0)
Refer to Test Case Result 3
Case 5
2.
5. TEST Results
5.1 Test Case Result 1
Input FilesLFPPML :POLICY NO. ISSUE POLICY PAID-TO-DATE STATUS MAINT REINSTATEMENT REINSTATEMENT PLAN
DATE DATE CODE CODE EFF DATE TRAN DATE CODE
503-8091954 2013/10/31 2014/01/12 2015/03/18 1 2 2014/06/18 2014/09/24 PULF25
LFPCHGLF:
COMPANY POLICY NO. SOURCE CODE SUBMIT ISSUE POLICY STATUS MAINT REINSTATEMENT REINSTATEMENT
CODE DATE DATE DATE CODE CODE EFF DATE TRAN DATE
5 503-8091954 2013/09/24 2013/10/31 2013/09/18 4 4
5 503-8091954 2013/09/24 2013/10/31 2013/12/18 1 J 2014/06/18 2014/09/24
LFPSTMTR :
POLICY PLAN POLICY NOTICE ANNIVERSARY
NO CODE DATE DATE DATE 503-8091954 PULF25 20,140,112 20,150,111 20,150,112
LFPBILLR :
POLICY PLAN NUMERIC POLICY ISSUE ANNIVERSARY PAY
NO CODE CODE DATE DATE DATE METHOD
503-8091954 PULF25 180,104 20,140,112 20,131,031 20,150,112
LFPFNDBDA:
POLICY NO. YEAR & MONTH ACCOUNT CODE U/L FUND CODE FUND BALANCE ON UNIT BALANCE ON
RECORD RECORD
503-8091954 201312 AUA 36FAHYU .00 .0000
503-8091954 201312 IUA 36FAHYU 1,340.66 12.5939
503-8091954 201312 AUA 36JBLA1 .00 .0000
503-8091954 201312 IUA 36JBLA1 1,341.51 7.8546
503-8091954 201312 AUA 36MMMGA .00 .0000
503-8091954 201312 IUA 36MMMGA 1,350.96 3.5388
503-8091954 201312 AUA 36PGEDU .00 .0000
503-8091954 201312 IUA 36PGEDU 1,301.40 .5508
503-8091954 201312 AUA 36TPASG .00 .0000
503-8091954 201312 IUA 36TPASG 1,246.51 4.9601
FMPPRCH:
FUND ID PRICE PRICE DEALING DATE OFFER PRICE ISSUE PRICE BID PRICE VALUATION DATE
EFF. DATE EXPIRY DATE
36FAHYU 20,140,110 20,140,113 20,140,110 13.7300 13.7300 13.7300 20,140,110
Policy Issue Date: 2013/10/31
Policy Effective Date: 2014/01/12
Policy lapsed on: 2014/08/15
Policy Re-instate on: 2014/09/24
AFS will be printed on: 2015/01/12
Before Image:
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
608 5482AC Eval CLB = CLB + %XFOOT(ZLF252BFBR)
609 5482AC EVAL L_Idx = L_Idx +1
610 5482AC ENDDO
611 *
612 C ENDSR
613 *---------------------------------------------------------------
614 * $LDAOPNB - SUBROUTINE TO CALCULATE OPENING BALANCE FOR STAT
615 * This is the closing balance at the end of S_DATE
616 *---------------------------------------------------------------
617 *
618 C $LDAOPNB BEGSR
619 *
620 5482AC* MOVEL PNO ZLF252BPOL
621 C S_DATE IFLE PEFF
622 C Z-ADD PDOI S_DATE
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
PDOI = 20131031. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
638 5482AC Clear GDS_LF252B
639 5482AC MOVEL PNO ZLF252BPOL
640 * Day is correct
641 C ZLF063ARTN IFEQ *BLANKS
642 C Z-ADD ZLF063AODATE ZLF252BEFF
643 C ELSE
644 C Z-ADD S_DATE ZLF252BEFF
645 C ENDIF
646
647 5482A * Pass the account code to LF252B to retrieve corresponding valu
648 5482AC If L_3GIlp = 'N'
649 5482AC Eval ZLF252BACCT = *Blanks
650 5482AC ElseIf L_3GIlp = 'Y'
651 5482AC Eval ZLF252BACCT = LArr_Accd(L_Idx)
652 5482AC EndIf
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20131031.
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
653 C CALLP LF252B(GDS_LF252B)
654 C* Z-ADD ZLF252BFBR OPNB
655 5482AC* Eval OPNB = %XFOOT(ZLF252BFBR)
656 5482AC Eval OPNB= OPNB+ %XFOOT(ZLF252BFBR)
657 5482AC EVAL L_Idx = L_Idx +1
658 5482AC ENDDO
659 *
660 C ENDSR
661 *
662 ****************************************************************
663 C
664 C $ENDPGM BEGSR
665 C If %Open(LFPPML)
666 C CLOSE LFPPML
667 C EndIf
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
OPNB = 000000000000000.00
Spool Details:
Job . . . . . . . . : QPADEV001K File . . . . . . . . : LF232N1
User . . . . . . . : DPLFTEST Number . . . . . . : 000093
Number . . . . . . : 115936 Creation date . . . : 14/12/30
Job system name . . : HKAS02 Creation time . . . : 18:03:20
After Change:
Now here,
Start date is calculated as below
For 2G policies the start date =Anniversary date (20150112) - 1 year
END date = Anniversary date (20150112) - 1 day
So here start date = 20140112
End date = 20150111
Fund Balance On Record= Unit Balance On Record * Fund Price
=12.5939*13.7300 =172.914247
Rate= 0.12915Amount In Fund Currency = Fund Balance On Record / Rate = 172.914247 / 0.12915 = 1338.83
Similarly, amount for all funds is calculated. Total Opening Balance= 1337.72 + 1332.37 + 1336.17 + 1304.19 + 1242.64 = 6577.91 Output:Debug Screen:
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
642 5482AC* MOVEL PNO ZLF252BPOL
643 *
644 * Store Start date to Temporary variable
645 1460C EVAL T_DATE =S_DATE
646 C S_DATE IFLE PEFF
647 C Z-ADD PDOI S_DATE
648 C ENDIF
649 1460C*
650 1460C IF L_APLREGFLG = 'Y'
651 1460C PNO SETLL FMCHGLF
652 1460C PNO READE FMCHGLF
653 1460C DOW Not(%EOF)
654 1460C IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
655 1460C AND PTC = '4' AND DPEFF PEFF
656 1460C EVAL S_DATE =T_DATE
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys PDOI = 20131031.
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
644 * Store Start date to Temporary variable
645 1460C EVAL T_DATE =S_DATE
646 C S_DATE IFLE PEFF
647 C Z-ADD PDOI S_DATE
648 C ENDIF
649 1460C*
650 1460C IF L_APLREGFLG = 'Y'
651 1460C PNO SETLL FMCHGLF
652 1460C PNO READE FMCHGLF
653 1460C DOW Not(%EOF)
654 1460C IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
655 1460C AND PTC = '4' AND DPEFF PEFF
656 1460C EVAL S_DATE =T_DATE
657 1460C ENDIF
658 1460C PNO READE FMCHGLF
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20131220.
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
689 5482AC EndIf
690 C CALLP LF252B(GDS_LF252B)
691 C* Z-ADD ZLF252BFBR OPNB
692 5482AC* Eval OPNB = %XFOOT(ZLF252BFBR)
693 5482AC Eval OPNB= OPNB+ %XFOOT(ZLF252BFBR)
694 5482AC EVAL L_Idx = L_Idx +1
695 5482AC ENDDO
696 *
697 C ENDSR
698 *
699 ****************************************************************
700 C
701 C $ENDPGM BEGSR
702 C If %Open(LFPPML)
703 C CLOSE LFPPML
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
OPNB = 000000000006553.09 Spool Details:
Job . . . . . . . . : QPADEV001K File . . . . . . . . : LF232N1
User . . . . . . . : DPLFTEST Number . . . . . . : 000087
Number . . . . . . : 115936 Creation date . . . : 14/12/30
Job system name . . : HKAS02 Creation time . . . : 17:44:51 5.2 Test Case Result 2
Input FilesLFPPML :POLICY NO. ISSUE POLICY STATUS CURRENCY REINSTATEMENT PLAN
DATE DATE CODE EFF DATE CODE 503-8094404 2013/09/25 2013/12/20 1 USD 2013/11/19 PULF25
LFPCHGLF:
CPOLICY NO. ISSUE POLICY STATUS CURRENCY REINSTATEMENT PLAN MAINT
DATE DATE CODE EFF DATE CODE CODE 503-8094404 2013/09/25 2013/09/19 4 USD PULF25 4 LFPSTMTR :
POLICY PLAN POLICY NOTICE ANNIVERSARY
NO CODE DATE DATE DATE 503-8094404 PULF25 20,131,220 20,141,219 20,141,220
LFPBILLR :
COMPANY POLICY PLAN NUMERIC POLICY POLICY ANNIVERSARY
NO CODE CODE CCY DATE DATE 5 503-8094404 PULF25 180,104 USD 20,131,220 20,141,220
Display Data Area
System: HKAS02
Data area . . . . . . . : DADATE
Library . . . . . . . : QTEMP
Type . . . . . . . . . : *CHAR
Length . . . . . . . . : 60
Text . . . . . . . . . : System Date
Value
Offset *...+....1....+....2....+....3....+....4....+....5
0 '20141218201412192014122001013201409192014092200000'
50 ' '
Bottom
Press Enter to continue.
F3=Exit F12=Cancel
LFPFNDBDA:
POLICY NO. YEAR & MONTH ACCOUNT CODE U/L FUND CODE FUND BALANCE ON UNIT BALANCE ON
RECORD RECORD
503-8094404 201311 AUA 36MMCFU .00 .0000
503-8094404 201311 IUA 36MMCFU 1,164.37 88.6802
503-8094404 201311 AUA 36MMHSO .00 .0000
503-8094404 201311 IUA 36MMHSO 1,154.93 43.1752
503-8094404 201311 AUA 36MMMEN .00 .0000
503-8094404 201311 IUA 36MMMEN 1,111.44 45.4579
503-8094404 201311 AUA 36PPBRU .00 .0000
503-8094404 201311 IUA 36PPBRU 1,132.54 6.6032
503-8094404 201311 AUA 36TPGRA .00 .0000
503-8094404 201311 IUA 36TPGRA 6,665.74 229.3787
FMPPRCH:
FUND ID PRICE PRICE DEALING DATE OFFER PRICE ISSUE PRICE BID PRICE VALUATION DATE
EFF. DATE EXPIRY DATE
36MMCFU 20,131,220 20,131,223 20,131,220 12.5600 12.5600 12.5600 20,131,220 U/L FUND CODE FUND ID FUND CURRENCY U/L FUND U/L FUND
DESCRIPTION DESCRIPTION
- SHORT
36MMCFU 36MMCFU USD BlackRock Global Funds-China Fund BLACKROCK-CHINA FUND
Policy Issue Date: 2013/09/25 Policy Effective Date: 2013/12/20 Policy Anniversary date: 2014/12/20Policy lapsed on: 2013/10/01 Policy Re-instate on: 2013/11/19AFS will be printed on: 2013/12/19Now here,
Start date is calculated as below
For 2G policies the start date =Anniversary date (20141220) - 1 year
END date = Anniversary date (20141220) - 1 day
So here start date = 20130112
End date = 20141219
The opening balance will be calculated as the addition of the amount In Fund Currency of all the funds of the policiesFund Balance on Record= Unit Balance on Record * Fund Price
= 88.6802 * 12.5600 = 1113.82Now the Rate is calculated based on the Target currency, Base currency and also start date calculatedTarget currency = PCCY (from LFPPML) = USDBase currency = USD (from file LFPFNDTB based on Fund ID)
Start date = 20131220
Using these start date the File is SETGT to LFPCRSEXRT and also the pervious equal value is retrievedRate = 1
Amount in Fund Currency = Fund Balance on Record / Rate
= = 1113.82 / 1 = 1113.82Similarly, amount for all funds is calculated.
Before Change:Output:
Debug Screen:
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
614 * $LDAOPNB - SUBROUTINE TO CALCULATE OPENING BALANCE FOR STAT
615 * This is the closing balance at the end of S_DATE
616 *---------------------------------------------------------------
617 *
618 C $LDAOPNB BEGSR
619 *
620 5482AC* MOVEL PNO ZLF252BPOL
621 C S_DATE IFLE PEFF
622 C Z-ADD PDOI S_DATE
623 C ENDIF
624 *
625 * When retrive the opening balance, need to get the Account Bala
626 C Z-ADD S_DATE ZLF063AIDATE
627 C Z-ADD 1 ZLF063ANONPD
628 C MOVEL 'B' ZLF063AOPT
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20131220. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
614 * $LDAOPNB - SUBROUTINE TO CALCULATE OPENING BALANCE FOR STAT
615 * This is the closing balance at the end of S_DATE
616 *---------------------------------------------------------------
617 *
618 C $LDAOPNB BEGSR
619 *
620 5482AC* MOVEL PNO ZLF252BPOL
621 C S_DATE IFLE PEFF
622 C Z-ADD PDOI S_DATE
623 C ENDIF
624 *
625 * When retrive the opening balance, need to get the Account Bala
626 C Z-ADD S_DATE ZLF063AIDATE
627 C Z-ADD 1 ZLF063ANONPD
628 C MOVEL 'B' ZLF063AOPT
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20130925. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
652 5482AC EndIf
653 C CALLP LF252B(GDS_LF252B)
654 C* Z-ADD ZLF252BFBR OPNB
655 5482AC* Eval OPNB = %XFOOT(ZLF252BFBR)
656 5482AC Eval OPNB= OPNB+ %XFOOT(ZLF252BFBR)
657 5482AC EVAL L_Idx = L_Idx +1
658 5482AC ENDDO
659 *
660 C ENDSR
661 *
662 ****************************************************************
663 C
664 C $ENDPGM BEGSR
665 C If %Open(LFPPML)
666 C CLOSE LFPPML
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
OPNB = 000000000000000.00 Spool Snippet
Display Spooled File
File . . . . . : LF232N1 Page/Line 24/6
Control . . . . . Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+....3
Identifier : AXAXAGT Total FPD Balance : .00
Policy Statement Period Start Date: 20131220
Policy Statement Period End Date: 20141219
Policy Date : 20131220
Anniversary Date : 20141220 Guaranteed Maturity Amount: .00
Total Policy Value : .00
Special Investment Bonus : .00
Gain/Loss (Amount): 12,907.60- Total premium paid: 36,270.76
Gain/Loss (%): 1.10- Total Withdrawal: .00
Gain/Loss (Amount) From Inception: 12,907.60-
Gain/Loss (%) from inception : 1.10-
Openning balance .00 Opening balance date : 20131219
Is_GVFTDF12PY : N
Monthly Guaranteed Income : .00
Start of total premium paid
Plan code Attached to Packaged To Total premium paid
PULF25 7,000.00
End of total premium paid
ETI Date:
More...
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
Job Details
Job . . . . . . . . : QPADEV004M File . . . . . . . . : LF232N1
User . . . . . . . : DPLFTEST Number . . . . . . : 000041
Number . . . . . . : 116770 Creation date . . . : 14/12/31
Job system name . . : HKAS02 Creation time . . . : 20:41:20
After Change:
Total Opening Balance= 1113.82 + 1154.50 + 1107.80 + 1122.07 + 6686.38 = 11184.57Output:
Debug Screen:
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
713 1460 C* Z-ADD PDOI S_DATE
714 1460 C* ENDIF
715 1460 C* ENDIF
716 1460 C* ELSEIF L_APLREGFLG = ' '
717 C S_DATE IFLE PEFF
718 C Z-ADD PDOI S_DATE
719 1460 C* ENDIF
720 C ENDIF
721 RASHIC*
722 RASHIC IF L_APLREGFLG = 'Y'
723 RASHIC IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
PDOI = 20130925. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
713 1460 C* Z-ADD PDOI S_DATE
714 1460 C* ENDIF
715 1460 C* ENDIF
716 1460 C* ELSEIF L_APLREGFLG = ' '
717 C S_DATE IFLE PEFF
718 C Z-ADD PDOI S_DATE
719 1460 C* ENDIF
720 C ENDIF
721 RASHIC*
722 RASHIC IF L_APLREGFLG = 'Y'
723 RASHIC IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20130925. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
713 1460 C* Z-ADD PDOI S_DATE
714 1460 C* ENDIF
715 1460 C* ENDIF
716 1460 C* ELSEIF L_APLREGFLG = ' '
717 C S_DATE IFLE PEFF
718 C Z-ADD PDOI S_DATE
719 1460 C* ENDIF
720 C ENDIF
721 RASHIC*
722 RASHIC IF L_APLREGFLG = 'Y'
723 RASHIC IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
L_APLREGFLG = 'Y' and PTC = 4 Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
728 RASHIC EVAL S_DATE =T_DATE
729 C LEAVE
730 RASHIC ENDIF
731 RASHIC IF PTC = '4' AND DPEFF = PEFF
732 C LEAVE
733 C ENDIF
734 RASHIC PNO READE FMCHGLF
735 C ENDDO
736 RASHIC ENDIF
737 RASHIC ENDIF
738 *
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20131220.
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
766 5482AC EndIf
767 C CALLP LF252B(GDS_LF252B)
768 C* Z-ADD ZLF252BFBR OPNB
769 5482AC* Eval OPNB = %XFOOT(ZLF252BFBR)
770 5482AC Eval OPNB= OPNB+ %XFOOT(ZLF252BFBR)
771 5482AC EVAL L_Idx = L_Idx +1
772 5482AC ENDDO
773 *
774 C ENDSR
775 *
776 ****************************************************************
777 C
778 C $ENDPGM BEGSR
779 C If %Open(LFPPML)
780 C CLOSE LFPPML
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
OPNB = 000000000011184.57
Spool Snippet
Display Spooled File
File . . . . . : LF232N1 Page/Line 24/6
Control . . . . . Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+....3
Identifier : AXAXAGT Total FPD Balance : .00
Policy Statement Period Start Date: 20131220
Policy Statement Period End Date: 20141219
Policy Date : 20131220
Anniversary Date : 20141220 Guaranteed Maturity Amount: .00
Total Policy Value : .00
Special Investment Bonus : .00
Gain/Loss (Amount): 3,178.59 Total premium paid: 15,000.00
Gain/Loss (%): .18 Total Withdrawal: .00
Gain/Loss (Amount) From Inception: 8,363.16
Gain/Loss (%) from inception : .71
Openning balance 11,184.57 Opening balance date : 20131219
Is_GVFTDF12PY : N
Monthly Guaranteed Income : .00
Start of total premium paid
Plan code Attached to Packaged To Total premium paid
PULF25 7,000.00
End of total premium paid
ETI Date:
More...
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
Variable characters per inch or font size not supported.
Job Details
Job . . . . . . . . : QPADEV005Q File . . . . . . . . : LF232N1
User . . . . . . . : DPLFTEST Number . . . . . . : 000097
Number . . . . . . : 116013 Creation date . . . : 14/12/31
Job system name . . : HKAS02 Creation time . . . : 18:06:40
5.3 Test Case Result 3Input FilesLFPPML :POLICY NO. ISSUE POLICY STATUS CURRENCY REINSTATEMENT PLAN
DATE DATE CODE EFF DATE CODE 503-5692101 2011/01/25 2013/12/20 1 HKD 2013/10/12 NOVA25
LFPCHGLF:
POLICY NO. POLICY STATUS CURRENCY REINSTATEMENT PLAN
DATE CODE EFF DATE CODE 503-5692101 2013/12/20 1 HKD 2013/10/12 NOVA25
503-5692101 2012/11/01 1 HKD 2012/11/20 NOVA25
503-5692101 2011/02/01 1 HKD NOVA25
LFPSTMTR :
LFPBILLR :
LFPFNDBDA:
FMPPRCH:
Policy Issue Date: 2013/09/25 Policy Effective Date: 2013/12/20 Policy Anniversary date: 2014/12/20Policy lapsed on: 2013/10/01 Policy Re-instate on: 2013/11/19
AFS will be printed on: 2013/12/19Now here,
Start date is calculated as below
For 2G policies the start date =Anniversary date (20141220) - 1 year
END date = Anniversary date (20141220) - 1 day
So here start date = 20130112
End date = 20141219
The opening balance will be calculated as the addition of the amount In Fund Currency of all the funds of the policies
Fund Balance on Record= Unit Balance on Record * Fund Price
= 88.6802 * 12.5600 = 1113.82Now the Rate is calculated based on the Target currency, Base currency and also start date calculated
Target currency = PCCY (from LFPPML) = USDBase currency = USD (from file LFPFNDTB based on Fund ID)
Start date = 20131220
Using these start date the File is SETGT to LFPCRSEXRT and also the pervious equal value is retrieved
Rate = 1
Amount in Fund Currency = Fund Balance on Record / Rate
= = 1113.82 / 1 = 1113.82Similarly, amount for all funds is calculated.
Before Change:Output:
Debug Screen:
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
614 * $LDAOPNB - SUBROUTINE TO CALCULATE OPENING BALANCE FOR STAT
615 * This is the closing balance at the end of S_DATE
616 *---------------------------------------------------------------
617 *
618 C $LDAOPNB BEGSR
619 *
620 5482AC* MOVEL PNO ZLF252BPOL
621 C S_DATE IFLE PEFF
622 C Z-ADD PDOI S_DATE
623 C ENDIF
624 *
625 * When retrive the opening balance, need to get the Account Bala
626 C Z-ADD S_DATE ZLF063AIDATE
627 C Z-ADD 1 ZLF063ANONPD
628 C MOVEL 'B' ZLF063AOPT
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20131220. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
614 * $LDAOPNB - SUBROUTINE TO CALCULATE OPENING BALANCE FOR STAT
615 * This is the closing balance at the end of S_DATE
616 *---------------------------------------------------------------
617 *
618 C $LDAOPNB BEGSR
619 *
620 5482AC* MOVEL PNO ZLF252BPOL
621 C S_DATE IFLE PEFF
622 C Z-ADD PDOI S_DATE
623 C ENDIF
624 *
625 * When retrive the opening balance, need to get the Account Bala
626 C Z-ADD S_DATE ZLF063AIDATE
627 C Z-ADD 1 ZLF063ANONPD
628 C MOVEL 'B' ZLF063AOPT
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20130925. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
652 5482AC EndIf
653 C CALLP LF252B(GDS_LF252B)
654 C* Z-ADD ZLF252BFBR OPNB
655 5482AC* Eval OPNB = %XFOOT(ZLF252BFBR)
656 5482AC Eval OPNB= OPNB+ %XFOOT(ZLF252BFBR)
657 5482AC EVAL L_Idx = L_Idx +1
658 5482AC ENDDO
659 *
660 C ENDSR
661 *
662 ****************************************************************
663 C
664 C $ENDPGM BEGSR
665 C If %Open(LFPPML)
666 C CLOSE LFPPML
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
OPNB = 000000000000000.00 Spool Snippet
Display Spooled File
File . . . . . : LF232N1 Page/Line 24/6
Control . . . . . Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+....3
Identifier : AXAXAGT Total FPD Balance : .00
Policy Statement Period Start Date: 20131220
Policy Statement Period End Date: 20141219
Policy Date : 20131220
Anniversary Date : 20141220 Guaranteed Maturity Amount: .00
Total Policy Value : .00
Special Investment Bonus : .00
Gain/Loss (Amount): 12,907.60- Total premium paid: 36,270.76
Gain/Loss (%): 1.10- Total Withdrawal: .00
Gain/Loss (Amount) From Inception: 12,907.60-
Gain/Loss (%) from inception : 1.10-
Openning balance .00 Opening balance date : 20131219
Is_GVFTDF12PY : N
Monthly Guaranteed Income : .00
Start of total premium paid
Plan code Attached to Packaged To Total premium paid
PULF25 7,000.00
End of total premium paid
ETI Date:
More...
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
Job Details
Job . . . . . . . . : QPADEV004M File . . . . . . . . : LF232N1
User . . . . . . . : DPLFTEST Number . . . . . . : 000041
Number . . . . . . : 116770 Creation date . . . : 14/12/31
Job system name . . : HKAS02 Creation time . . . : 20:41:20
After Change:
Total Opening Balance= 1113.82 + 1154.50 + 1107.80 + 1122.07 + 6686.38 = 11184.57
Output:
Debug Screen:
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
713 1460 C* Z-ADD PDOI S_DATE
714 1460 C* ENDIF
715 1460 C* ENDIF
716 1460 C* ELSEIF L_APLREGFLG = ' '
717 C S_DATE IFLE PEFF
718 C Z-ADD PDOI S_DATE
719 1460 C* ENDIF
720 C ENDIF
721 RASHIC*
722 RASHIC IF L_APLREGFLG = 'Y'
723 RASHIC IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
PDOI = 20130925. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
713 1460 C* Z-ADD PDOI S_DATE
714 1460 C* ENDIF
715 1460 C* ENDIF
716 1460 C* ELSEIF L_APLREGFLG = ' '
717 C S_DATE IFLE PEFF
718 C Z-ADD PDOI S_DATE
719 1460 C* ENDIF
720 C ENDIF
721 RASHIC*
722 RASHIC IF L_APLREGFLG = 'Y'
723 RASHIC IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20130925. Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
713 1460 C* Z-ADD PDOI S_DATE
714 1460 C* ENDIF
715 1460 C* ENDIF
716 1460 C* ELSEIF L_APLREGFLG = ' '
717 C S_DATE IFLE PEFF
718 C Z-ADD PDOI S_DATE
719 1460 C* ENDIF
720 C ENDIF
721 RASHIC*
722 RASHIC IF L_APLREGFLG = 'Y'
723 RASHIC IF (L_3GIlp = 'Y' OR L_2GIlp = 'Y')
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
L_APLREGFLG = 'Y' and PTC = 4 Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
724 RASHIC PNO SETLL FMCHGLF
725 RASHIC PNO READE FMCHGLF
726 C DOW Not(%EOF)
727 RASHIC IF PTC = '4' AND DPEFF PEFF
728 RASHIC EVAL S_DATE =T_DATE
729 C LEAVE
730 RASHIC ENDIF
731 RASHIC IF PTC = '4' AND DPEFF = PEFF
732 C LEAVE
733 C ENDIF
734 RASHIC PNO READE FMCHGLF
735 C ENDDO
736 RASHIC ENDIF
737 RASHIC ENDIF
738 *
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
S_DATE = 20131220.
Display Module Source
Program: LF232T Library: QTEMP Module: LF232T
766 5482AC EndIf
767 C CALLP LF252B(GDS_LF252B)
768 C* Z-ADD ZLF252BFBR OPNB
769 5482AC* Eval OPNB = %XFOOT(ZLF252BFBR)
770 5482AC Eval OPNB= OPNB+ %XFOOT(ZLF252BFBR)
771 5482AC EVAL L_Idx = L_Idx +1
772 5482AC ENDDO
773 *
774 C ENDSR
775 *
776 ****************************************************************
777 C
778 C $ENDPGM BEGSR
779 C If %Open(LFPPML)
780 C CLOSE LFPPML
More...
Debug . . .
F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable
F12=Resume F17=Watch variable F18=Work with watch F24=More keys
OPNB = 000000000011184.57
Spool Snippet
Display Spooled File
File . . . . . : LF232N1 Page/Line 24/6
Control . . . . . Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+....3
Identifier : AXAXAGT Total FPD Balance : .00
Policy Statement Period Start Date: 20131220
Policy Statement Period End Date: 20141219
Policy Date : 20131220
Anniversary Date : 20141220 Guaranteed Maturity Amount: .00
Total Policy Value : .00
Special Investment Bonus : .00
Gain/Loss (Amount): 3,178.59 Total premium paid: 15,000.00
Gain/Loss (%): .18 Total Withdrawal: .00
Gain/Loss (Amount) From Inception: 8,363.16
Gain/Loss (%) from inception : .71
Openning balance 11,184.57 Opening balance date : 20131219
Is_GVFTDF12PY : N
Monthly Guaranteed Income : .00
Start of total premium paid
Plan code Attached to Packaged To Total premium paid
PULF25 7,000.00
End of total premium paid
ETI Date:
More...
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
Variable characters per inch or font size not supported.
Job Details
Job . . . . . . . . : QPADEV005Q File . . . . . . . . : LF232N1
User . . . . . . . : DPLFTEST Number . . . . . . : 000097
Number . . . . . . : 116013 Creation date . . . : 14/12/31
Job system name . . : HKAS02 Creation time . . . : 18:06:40
PRJ HK AFS Handling for Reinstated Policies_UTR (LFRCS232N) v1.0 Page 1 Uncontrolled when printed
AXA Asia Life Regional Centre IT Internal Use Only