Inception 24-04-2019 Claims Processed to 31/10/2019
Expiry 23-04-2020 Class VIP
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
1 04/2019 8,844 1,390 1,481,798.93 1,510,522.28 0 0.00 0.00
05/2019 8,849 5,451 5,277,674.00 5,398,082.71 0 0.00 0.00
06/2019 8,817 4,528 3,924,225.84 4,024,250.50 0 0.00 0.00
07/2019 8,821 5,509 5,294,859.51 5,430,547.20 0 0.00 0.00
08/2019 8,868 4,214 3,558,281.52 3,640,881.47 0 0.00 0.00
09/2019 8,900 5,734 5,458,328.10 5,578,056.16 0 0.00 0.00
10/2019 8,897 6,363 6,332,559.68 6,466,712.77 0 0.00 0.00
Inception 24-04-2019 Claims Processed to 31/10/2019
Expiry 23-04-2020 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
3 04/2019 108 1 195.00 195.00 0 0.00 0.00
05/2019 110 14 10,207.47 10,273.95 0 0.00 0.00
06/2019 108 20 17,788.91 18,007.71 0 0.00 0.00
07/2019 105 16 21,777.07 22,254.54 0 0.00 0.00
08/2019 105 16 14,805.47 14,880.79 0 0.00 0.00
09/2019 104 14 9,421.50 9,482.94 0 0.00 0.00
10/2019 102 20 9,926.21 10,196.71 0 0.00 0.00
Inception 24-04-2018 Claims Processed to 30/04/2019
Expiry 23-04-2019 Class VIP
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
1 04/2018 9,553 1,293 1,408,698.12 1,453,353.85 0 0.00 0.00
05/2018 9,476 6,085 5,935,579.58 6,123,737.45 0 0.00 0.00
06/2018 9,359 4,478 4,077,039.68 4,206,281.84 0 0.00 0.00
07/2018 9,293 5,332 5,912,087.23 6,099,500.40 0 0.00 0.00
08/2018 9,214 4,938 4,590,359.30 4,735,873.69 0 0.00 0.00
09/2018 9,157 6,030 5,752,388.11 5,934,738.81 0 0.00 0.00
10/2018 9,139 6,434 6,370,241.49 6,572,178.15 0 0.00 0.00
11/2018 9,093 6,161 4,944,852.33 5,101,604.15 0 0.00 0.00
12/2018 9,066 6,675 6,016,430.17 6,207,151.01 0 0.00 0.00
01/2019 9,058 6,874 6,569,605.81 6,777,862.31 0 0.00 0.00
02/2019 9,033 6,506 5,528,051.70 5,703,290.94 0 0.00 0.00
03/2019 9,045 6,852 5,498,071.03 5,634,522.80 0 0.00 0.00
04/2019 8,994 5,464 4,109,709.82 4,205,807.24 0 0.00 0.00
Inception 24-04-2018 Claims Processed to 30/04/2019
Expiry 23-04-2019 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
3 04/2018 110 0 0.00 0.00 0 0.00 0.00
05/2018 110 7 1,492.57 1,539.88 0 0.00 0.00
06/2018 108 7 2,755.39 2,842.74 0 0.00 0.00
07/2018 110 9 4,053.01 4,181.49 0 0.00 0.00
08/2018 109 8 3,482.11 3,592.49 0 0.00 0.00
09/2018 109 8 5,049.46 5,209.53 0 0.00 0.00
10/2018 111 11 3,918.53 4,042.75 0 0.00 0.00
11/2018 110 19 13,802.10 14,239.63 0 0.00 0.00
12/2018 107 30 72,516.80 74,815.58 0 0.00 0.00
01/2019 105 39 51,219.89 52,843.56 0 0.00 0.00
02/2019 104 29 34,440.04 35,531.79 0 0.00 0.00
03/2019 113 17 9,279.87 9,372.18 0 0.00 0.00
04/2019 111 20 113,392.86 117,583.11 0 0.00 0.00
Inception 24-04-2017 Claims Processed to 30/04/2018
Expiry 23-04-2018 Class VIP
Deductible 20 % OHN 20 OCN 20 MPN 20 Dental Limit 4,000.00 Optical Limit 400.00
Annual Limit 500000 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
(before VAT) (after VAT)
Claims (before VAT) (after VAT) Claims
Period
Last Policy Year
1 04/2017 10,257 1,848 1,982,142.74 1,982,142.74 0 0.00 0.00
05/2017 10,244 8,318 8,061,843.40 8,061,843.40 0 0.00 0.00
06/2017 10,240 5,855 5,276,833.05 5,276,833.05 0 0.00 0.00
07/2017 10,239 7,496 7,377,419.28 7,377,419.28 0 0.00 0.00
08/2017 10,258 7,258 7,259,396.55 7,259,396.55 0 0.00 0.00
09/2017 10,270 6,405 6,989,788.39 6,989,788.39 0 0.00 0.00
10/2017 10,316 8,341 7,317,028.12 7,317,028.12 0 0.00 0.00
11/2017 10,357 8,712 7,858,684.62 7,858,684.62 0 0.00 0.00
12/2017 10,363 8,631 7,870,948.90 7,870,948.90 0 0.00 0.00
01/2018 10,305 8,686 8,421,750.49 8,688,719.98 0 0.00 0.00
02/2018 10,160 8,334 7,281,329.36 7,512,147.50 0 0.00 0.00
03/2018 9,951 9,049 7,845,148.44 8,093,839.65 0 0.00 0.00
04/2018 9,855 6,903 6,057,094.47 6,249,104.36 0 0.00 0.00
Inception 24-04-2017 Claims Processed to 30/04/2018
Expiry 23-04-2018 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500000 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
(before VAT) (after VAT)
Claims (before VAT) (after VAT) Claims
Period
Last Policy Year
3 04/2017 63 1 3,831.85 3,831.85 0 0.00 0.00
05/2017 141 6 2,793.09 2,793.09 0 0.00 0.00
06/2017 142 4 2,516.46 2,516.46 0 0.00 0.00
07/2017 136 0 0.00 0.00 0 0.00 0.00
08/2017 135 4 6,105.00 6,105.00 0 0.00 0.00
09/2017 135 2 2,983.61 2,983.61 0 0.00 0.00
10/2017 134 3 2,237.10 2,237.10 0 0.00 0.00
11/2017 132 1 247.88 247.88 0 0.00 0.00
12/2017 131 9 7,919.93 7,919.93 0 0.00 0.00
01/2018 128 0 0.00 0.00 0 0.00 0.00
02/2018 129 0 0.00 0.00 0 0.00 0.00
03/2018 110 3 4,361.15 4,499.40 0 0.00 0.00
04/2018 105 0 0.00 0.00 0 0.00 0.00
Document
1
Int32
6
0
Combined
Text
ToNumber([_CurrentField_],'.')
ToNumber([_CurrentField_],'.')
C:\Users\161588\AppData\Local\Temp\Engine_9184_a8a994afaadd4951882032423387690c_\Engine_19816_f161c80f9cee47ce8a21bea8bd624e03_.yxdb
Single
Profile
Data
Data
ParseSimple
Field1_Matched
(\d+\W?\d*\W?\d*\W?\d*)
Substring the data starting at the word "Period"
Skip
1
Skip 1st 1
Document
Column
Int32
4
Empty
if Substring([Data],2,1) = "/" then 1 else [Row-1:Column]+1 endif
Assigning columns
if Substring([Data],2,1) = "/" then 1 else [Row-1:Column]+1 e...
"Data"
True
True
True
True
False
False
False
False
False
upper
,
UniqueValue
1
MM/yyyy
DateTime_Out
Convert 1 From:
Custom
Inception
Field1
ParseSimple
Field1_Matched
(\W?\w+\W?\w*\W?\w*)
First
2
First 2
"Field1"
True
True
True
True
False
False
False
False
False
upper
Horizontal
209_igorp