0 ? $fmt($count, 0) : '--'; } if ((int) $count <= 0 && (float) $amount <= 0) { return '--'; } return $fmt($amount); }; $cnt = static function ($n) use ($fmt): string { return ((int) $n) > 0 ? $fmt($n, 0) : '--'; }; $amt = static function ($n) use ($fmt): string { return ((float) $n) > 0 ? $fmt($n, 0) : '--'; }; $acs = static function ($n) use ($fmt): string { return ((float) $n) > 0 ? $fmt($n, 0) : '--'; }; $pct = static function ($n): string { if ($n === null || $n === '') { return '--'; } return ((int) $n) . '%'; }; $ageBands = ['00-05', '06-18', '19-25', '26-35', '36-45', '46-55', '56-65', '66-75', 'Above 75']; $relations = ['Self', 'Parents', 'Spouse', 'Children', 'Siblings', 'In Laws', 'Others']; ?>
| S.No. | Contents | Page No. |
|---|---|---|
| 1 | Portfolio Analysis | Page 2 |
| 2 | Enrollment Summary | Page 3 |
| 3 | Age Wise Analysis | Page 4 |
| 4 | Relation ACS | Page 5 |
| 5 | Amount Band-wise Analysis | Page 6 |
| 6 | SI Band-wise Analysis | Page 6 |
| 7 | IL Take Care | Page 7 |
| 8 | Disease-Analysis | Page 8 |
| 9 | Claim Utilization report | Page 9 |
| 10 | Top Hospitals | Page 10 |
| 11 | Top Cities | Page 11 |
| 12 | TAT Analysis | Page 12 |
| Premium | Earned Premium | Loss Amount Paid | Loss Amount O/S | Hit (LOSS) | Claim Cost | Gross Incurred Cost | Loss Ratio | As on |
|---|---|---|---|---|---|---|---|---|
| = esc($fmt($plr['premium'] ?? 0)) ?> | = esc($fmt($plr['earned_premium'] ?? 0)) ?> | = esc($fmt($plr['loss_amount_paid'] ?? 0)) ?> | = esc($fmt($plr['loss_amount_os'] ?? 0)) ?> | = esc($fmt($plr['hit_loss'] ?? 0)) ?> | = esc($fmt($plr['claim_cost'] ?? 0)) ?> | = esc($fmt($plr['gross_incurred_cost'] ?? 0)) ?> | = esc(($plr['loss_ratio'] ?? 0) . '%') ?> | = esc($plr['as_on'] ?? '') ?> |
| Status | Cashless | Reimbursement | Overall | ||||||
|---|---|---|---|---|---|---|---|---|---|
| No of Claims | Claims/OS Amount | Paid/OS Amt | No of Claims | Claims/OS Amount | Paid/OS Amt | No of Claims | Claims/OS Amount | Paid/OS Amt | |
| = esc($r['label'] ?? '') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['claimed'] ?? 0)) ?> | = $isReject ? '--' : esc($amt($c['paid'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['claimed'] ?? 0)) ?> | = $isReject ? '--' : esc($amt($rb['paid'] ?? 0)) ?> | = esc($cnt($o['count'] ?? 0)) ?> | = esc($amt($o['claimed'] ?? 0)) ?> | = $isReject ? '--' : esc($amt($o['paid'] ?? 0)) ?> |
| Total All | = esc($fmt($tc['count'] ?? 0, 0)) ?> | = esc($fmt($tc['claimed'] ?? 0)) ?> | = esc($fmt($tc['paid'] ?? 0)) ?> | = esc($fmt($tr['count'] ?? 0, 0)) ?> | = esc($fmt($tr['claimed'] ?? 0)) ?> | = esc($fmt($tr['paid'] ?? 0)) ?> | = esc($fmt($to['count'] ?? 0, 0)) ?> | = esc($fmt($to['claimed'] ?? 0)) ?> | = esc($fmt($to['paid'] ?? 0)) ?> |
| ILTC % | RI Intimations | ILTC Intimations | ILTC % |
|---|---|---|---|
| Intimations | = esc($fmt($iltc['ri'] ?? 0, 0)) ?> | = esc($fmt($iltc['iltc'] ?? 0, 0)) ?> | = esc(($iltc['pct'] ?? 0) . '%') ?> |
Notes:
|
Key Takeaways:
|
| Enrolled Lives | Claims | Claim Frequency |
|---|---|---|
| = esc($fmt($enr['lives'] ?? 0, 0)) ?> | = esc($fmt($enr['claims'] ?? 0, 0)) ?> | = esc(number_format((float) ($enr['frequency'] ?? 0), 2) . '%') ?> |
| Age Band | Relationship | Overall | ||||||
|---|---|---|---|---|---|---|---|---|
| = esc($rel) ?> | ||||||||
| = esc($band) ?> | = esc($cnt($row[$rel] ?? 0)) ?> | = esc($cnt($row['_total'] ?? 0)) ?> | ||||||
| Overall | = esc($cnt($colT[$rel] ?? 0)) ?> | = esc($fmt($grand, 0)) ?> | ||||||
| Percentage (%) | 0 ? (int) round((($colT[$rel] ?? 0) / $grand) * 100) : 0; ?>= ($colT[$rel] ?? 0) > 0 ? esc($p . '%') : '--' ?> | 100% | ||||||
| Age Band | Cashless | Reimbursement | Total | ||||||
|---|---|---|---|---|---|---|---|---|---|
| No of Claims | Amount | ACS | No of Claims | Amount | ACS | No of Claims | Amount | ACS | |
| = esc($r['label'] ?? '') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['amount'] ?? 0)) ?> | = esc($acs($c['acs'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['amount'] ?? 0)) ?> | = esc($acs($rb['acs'] ?? 0)) ?> | = esc($cnt($t['count'] ?? 0)) ?> | = esc($amt($t['amount'] ?? 0)) ?> | = esc($acs($t['acs'] ?? 0)) ?> |
| Overall | = esc(number_format((int) ($c['count'] ?? 0))) ?> | = esc(number_format((float) ($c['amount'] ?? 0))) ?> | = esc(number_format((float) ($c['acs'] ?? 0))) ?> | = esc(number_format((int) ($rb['count'] ?? 0))) ?> | = esc(number_format((float) ($rb['amount'] ?? 0))) ?> | = esc(number_format((float) ($rb['acs'] ?? 0))) ?> | = esc(number_format((int) ($t['count'] ?? 0))) ?> | = esc(number_format((float) ($t['amount'] ?? 0))) ?> | = esc(number_format((float) ($t['acs'] ?? 0))) ?> |
Key Takeaways:
|
Notes:
|
| Relation | Cashless | Reimbursement | Total | ||||||
|---|---|---|---|---|---|---|---|---|---|
| No of Claims | Amount | ACS | No of Claims | Amount | ACS | No of Claims | Amount | ACS | |
| = esc($r['label'] ?? '') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['amount'] ?? 0)) ?> | = esc($acs($c['acs'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['amount'] ?? 0)) ?> | = esc($acs($rb['acs'] ?? 0)) ?> | = esc($cnt($t['count'] ?? 0)) ?> | = esc($amt($t['amount'] ?? 0)) ?> | = esc($acs($t['acs'] ?? 0)) ?> |
| Overall | = esc(number_format((int) ($c['count'] ?? 0))) ?> | = esc(number_format((float) ($c['amount'] ?? 0))) ?> | = esc(number_format((float) ($c['acs'] ?? 0))) ?> | = esc(number_format((int) ($rb['count'] ?? 0))) ?> | = esc(number_format((float) ($rb['amount'] ?? 0))) ?> | = esc(number_format((float) ($rb['acs'] ?? 0))) ?> | = esc(number_format((int) ($t['count'] ?? 0))) ?> | = esc(number_format((float) ($t['amount'] ?? 0))) ?> | = esc(number_format((float) ($t['acs'] ?? 0))) ?> |
Key Takeaways:
|
Notes:
|
| Amount Band | Cashless | Reimbursement | Total | Percentage | ||||
|---|---|---|---|---|---|---|---|---|
| No of Claims | Amount | No of Claims | Amount | No of Claims | Amount | % Claims | % Value | |
| = esc($r['label'] ?? '') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['amount'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['amount'] ?? 0)) ?> | = esc($cnt($r['total_count'] ?? 0)) ?> | = esc($amt($r['total_amount'] ?? 0)) ?> | = ((int) ($r['total_count'] ?? 0)) > 0 ? esc(($r['pct_claims'] ?? 0) . '%') : '--' ?> | = ((float) ($r['total_amount'] ?? 0)) > 0 ? esc(($r['pct_value'] ?? 0) . '%') : '--' ?> |
| Overall | = esc(number_format((int) ($t['cashless']['count'] ?? 0))) ?> | = esc(number_format((float) ($t['cashless']['amount'] ?? 0))) ?> | = esc(number_format((int) ($t['reimb']['count'] ?? 0))) ?> | = esc(number_format((float) ($t['reimb']['amount'] ?? 0))) ?> | = esc(number_format((int) ($t['total_count'] ?? 0))) ?> | = esc(number_format((float) ($t['total_amount'] ?? 0))) ?> | 100% | 100% |
| SI Band | Cashless | Reimbursement | Total | Percentage | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| No of Claims | Amount | ACS | No of Claims | Amount | ACS | No of Claims | Amount | ACS | % Claims | % Value | |
| = esc($r['label'] ?? '') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['amount'] ?? 0)) ?> | = esc($acs($c['acs'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['amount'] ?? 0)) ?> | = esc($acs($rb['acs'] ?? 0)) ?> | = esc($cnt($tt['count'] ?? 0)) ?> | = esc($amt($tt['amount'] ?? 0)) ?> | = esc($acs($tt['acs'] ?? 0)) ?> | = ((int) ($tt['count'] ?? 0)) > 0 ? esc(($r['pct_claims'] ?? 0) . '%') : '--' ?> | = ((float) ($tt['amount'] ?? 0)) > 0 ? esc(($r['pct_value'] ?? 0) . '%') : '--' ?> |
| Overall | = esc(number_format((int) ($c['count'] ?? 0))) ?> | = esc(number_format((float) ($c['amount'] ?? 0))) ?> | = esc(number_format((float) ($c['acs'] ?? 0))) ?> | = esc(number_format((int) ($rb['count'] ?? 0))) ?> | = esc(number_format((float) ($rb['amount'] ?? 0))) ?> | = esc(number_format((float) ($rb['acs'] ?? 0))) ?> | = esc(number_format((int) ($tt['count'] ?? 0))) ?> | = esc(number_format((float) ($tt['amount'] ?? 0))) ?> | = esc(number_format((float) ($tt['acs'] ?? 0))) ?> | 100% | 100% |
| Month | No. of Self Lives | Active Users | IL Take Care App Download | App Download Ratio |
|---|---|---|---|---|
| = esc($m) ?> | = esc($eng['self_lives'] ?? '') ?> | = esc($eng['active_users'] ?? '') ?> | = esc($eng['downloads'] ?? '') ?> | = esc($eng['ratio'] ?? '0%') ?> |
| Month | E Card Download % | Face Scan Utilization % | ILHealth Blog Utilization % | Cross Sell Utilization % |
|---|---|---|---|---|
| = esc($m) ?> | = esc($feat['ecard'] ?? '') ?> | = esc($feat['face_scan'] ?? '0%') ?> | = esc($feat['blog'] ?? '0%') ?> | = esc($feat['cross_sell'] ?? '') ?> |
| Month | HAT Request | HAT Fulfillment | ILHD prescription | Expertise utilization | Health Claim Utilization |
|---|---|---|---|---|---|
| = esc($m) ?> | = esc($svc['hat_req'] ?? '') ?> | = esc($svc['hat_ful'] ?? '') ?> | = esc($svc['ilhd'] ?? '') ?> | = esc($svc['expertise'] ?? '0%') ?> | = esc($svc['health_claim'] ?? '') ?> |
| No of claims in current policy | No. of employees | Value (Rs) | % Claims | % Value |
|---|---|---|---|---|
| = esc($r['label'] ?? '') ?> | = esc($cnt($r['members'] ?? 0)) ?> | = esc($amt($r['amount'] ?? 0)) ?> | = ((int) ($r['members'] ?? 0)) > 0 ? esc(($r['pct_claims'] ?? 0) . '%') : '--' ?> | = ((float) ($r['amount'] ?? 0)) > 0 ? esc(($r['pct_value'] ?? 0) . '%') : '--' ?> |
| Total | = ((int) ($te['members'] ?? 0)) > 0 ? esc(number_format((int) $te['members'])) : '--' ?> | = ((float) ($te['amount'] ?? 0)) > 0 ? esc(number_format((float) $te['amount'])) : '--' ?> | 100% | 100% |
| No of claims in current policy | No. of employees | Value (Rs) | % Claims | % Value |
|---|---|---|---|---|
| = esc($r['label'] ?? '') ?> | = esc($cnt($r['members'] ?? 0)) ?> | = esc($amt($r['amount'] ?? 0)) ?> | = ((int) ($r['members'] ?? 0)) > 0 ? esc(($r['pct_claims'] ?? 0) . '%') : '--' ?> | = ((float) ($r['amount'] ?? 0)) > 0 ? esc(($r['pct_value'] ?? 0) . '%') : '--' ?> |
| Total | = esc(number_format((int) ($td['members'] ?? 0))) ?> | = esc(number_format((float) ($td['amount'] ?? 0))) ?> | 100% | 100% |
| Disease Category | Cashless | Reimbursement | Total | ||||||
|---|---|---|---|---|---|---|---|---|---|
| No of Claims | Amount | ACS | No of Claims | Amount | ACS | No of Claims | Amount | ACS | |
| = esc($r['label'] ?? '') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['amount'] ?? 0)) ?> | = esc($acs($c['acs'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['amount'] ?? 0)) ?> | = esc($acs($rb['acs'] ?? 0)) ?> | = esc($cnt($t['count'] ?? 0)) ?> | = esc($amt($t['amount'] ?? 0)) ?> | = esc($acs($t['acs'] ?? 0)) ?> |
| Overall | = esc(number_format((int) ($c['count'] ?? 0))) ?> | = esc(number_format((float) ($c['amount'] ?? 0))) ?> | = esc(number_format((float) ($c['acs'] ?? 0))) ?> | = esc(number_format((int) ($rb['count'] ?? 0))) ?> | = esc(number_format((float) ($rb['amount'] ?? 0))) ?> | = esc(number_format((float) ($rb['acs'] ?? 0))) ?> | = esc(number_format((int) ($t['count'] ?? 0))) ?> | = esc(number_format((float) ($t['amount'] ?? 0))) ?> | = esc(number_format((float) ($t['acs'] ?? 0))) ?> |
| No of claims in current policy | No. of employees | Value (Rs) | % Claims | % Value |
|---|---|---|---|---|
| = esc($r['label'] ?? '') ?> | = esc($cnt($r['members'] ?? 0)) ?> | = esc($amt($r['amount'] ?? 0)) ?> | = ((int) ($r['members'] ?? 0)) > 0 ? esc(($r['pct_claims'] ?? 0) . '%') : '--' ?> | = ((float) ($r['amount'] ?? 0)) > 0 ? esc(($r['pct_value'] ?? 0) . '%') : '--' ?> |
| Total | = ((int) ($te['members'] ?? 0)) > 0 ? esc(number_format((int) $te['members'])) : '--' ?> | = ((float) ($te['amount'] ?? 0)) > 0 ? esc(number_format((float) $te['amount'])) : '--' ?> | 100% | 100% |
| No of claims in current policy | No. of employees | Value (Rs) | % Claims | % Value |
|---|---|---|---|---|
| = esc($r['label'] ?? '') ?> | = esc($cnt($r['members'] ?? 0)) ?> | = esc($amt($r['amount'] ?? 0)) ?> | = ((int) ($r['members'] ?? 0)) > 0 ? esc(($r['pct_claims'] ?? 0) . '%') : '--' ?> | = ((float) ($r['amount'] ?? 0)) > 0 ? esc(($r['pct_value'] ?? 0) . '%') : '--' ?> |
| Total | = esc(number_format((int) ($td['members'] ?? 0))) ?> | = esc(number_format((float) ($td['amount'] ?? 0))) ?> | 100% | 100% |
| Hospital Name | City | Cashless | Reimbursement | Total | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| No of Claims | Amount | ACS | No of Claims | Amount | ACS | No of Claims | Amount | ACS | ||
| = esc($r['label'] ?? '') ?> | = esc($r['city'] ?? '--') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['amount'] ?? 0)) ?> | = esc($acs($c['acs'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['amount'] ?? 0)) ?> | = esc($acs($rb['acs'] ?? 0)) ?> | = esc($cnt($t['count'] ?? 0)) ?> | = esc($amt($t['amount'] ?? 0)) ?> | = esc($acs($t['acs'] ?? 0)) ?> |
| Overall | -- | = esc(number_format((int) ($c['count'] ?? 0))) ?> | = esc(number_format((float) ($c['amount'] ?? 0))) ?> | = esc(number_format((float) ($c['acs'] ?? 0))) ?> | = esc(number_format((int) ($rb['count'] ?? 0))) ?> | = esc(number_format((float) ($rb['amount'] ?? 0))) ?> | = esc(number_format((float) ($rb['acs'] ?? 0))) ?> | = esc(number_format((int) ($t['count'] ?? 0))) ?> | = esc(number_format((float) ($t['amount'] ?? 0))) ?> | = esc(number_format((float) ($t['acs'] ?? 0))) ?> |
| City | Cashless | Reimbursement | Total | ||||||
|---|---|---|---|---|---|---|---|---|---|
| No of Claims | Amount | ACS | No of Claims | Amount | ACS | No of Claims | Amount | ACS | |
| = esc($r['label'] ?? '') ?> | = esc($cnt($c['count'] ?? 0)) ?> | = esc($amt($c['amount'] ?? 0)) ?> | = esc($acs($c['acs'] ?? 0)) ?> | = esc($cnt($rb['count'] ?? 0)) ?> | = esc($amt($rb['amount'] ?? 0)) ?> | = esc($acs($rb['acs'] ?? 0)) ?> | = esc($cnt($t['count'] ?? 0)) ?> | = esc($amt($t['amount'] ?? 0)) ?> | = esc($acs($t['acs'] ?? 0)) ?> |
| Overall | = esc(number_format((int) ($c['count'] ?? 0))) ?> | = esc(number_format((float) ($c['amount'] ?? 0))) ?> | = esc(number_format((float) ($c['acs'] ?? 0))) ?> | = esc(number_format((int) ($rb['count'] ?? 0))) ?> | = esc(number_format((float) ($rb['amount'] ?? 0))) ?> | = esc(number_format((float) ($rb['acs'] ?? 0))) ?> | = esc(number_format((int) ($t['count'] ?? 0))) ?> | = esc(number_format((float) ($t['amount'] ?? 0))) ?> | = esc(number_format((float) ($t['acs'] ?? 0))) ?> |
| Month | Reimbursement (in Days) | Cashless (in Hrs) | |
|---|---|---|---|
| Fresh AL | Enhancement | ||
| = esc($r['month'] ?? '') ?> | = esc($r['reimb_days'] ?? '') ?> | = esc($r['fresh_al'] ?? '') ?> | = esc($r['enhancement'] ?? '') ?> |