SI Enhancement increases sum insured for active members on a policy via Excel upload (files.action = si_enhancement). The process recalculates premium from slab/rack rates and creates pending SI endorsements on employee_polices — SI and premium are not updated in place until endorsements are applied downstream.

Core logic: EmployeeServiceController::employeesSIEnhanceProcess. Premium math uses transform_si_excel_row_to_calculatable_format and premium_calculation_manager (see EB rack rate calculation).

Overview

flowchart LR A["Upload Excel action si_enhancement"] --> B["excelFileFormatValidation"] B --> C["excelFileDataValidation"] C --> D["employeesSIEnhanceProcess job"] D --> E["Recalc premium plus pending SI endorsements"] B -->|errors| F["files.status failed"] C -->|errors| F D -->|loop done| G["files.status success"]

In short:

Step 1 — Format: 5 columns (A–E); Augmented SI validated against slabs (check_si).
Step 2 — Data: Member must exist on active policy; code 10 if not found.
Step 3 — SI enhance: Picks rack rate by relationship, recalculates premium, inserts 3 pending endorsements per member.
One Excel row = one member SI change (not whole-family in one row).

Key files and routes

Area	Location
UI	`app/Views/employee_upload.php` — action SI Enhancement
Upload	`EmployeeController::employeesUplodWithEvents`
Validation	`excelFileFormatValidation`, `excelFileDataValidation`
SI process	`employeesSIEnhanceProcess`
Onboard SI path	`employeesSIEnhanceProcessWhileOnbboard` — SI during dependent addition onboard (not Excel)
Job	`employeesSIEnhanceProcess` in `JobWorker.php`
Helpers	`excel_util_helper.php` — `transform_si_excel_row_to_calculatable_format`, `premium_calculation_manager`

Routes (group /employee, authMVC):

GET /employee/upload — upload screen
POST /employee/upload — upload-action-type=si_enhancement
GET /employee/excel_error/{file_id} — validation errors

files.policy_id is the client policy id. Slab rates load via getPolicySlabRatesForEmpOnboard(policy_id, client_id).

Sync vs background jobs

Step	< 1 MB	≥ 1 MB
Format validation	Inline on upload	Job `excelFileFormatValidation`
Data validation	Job `excelFileDataValidation`	Same
SI enhance	Job `employeesSIEnhanceProcess`	Same

Step 1: excelFileFormatValidation

Uses $si_enhance_excel_columns — 5 columns (A–E).
Action code SI for mandatory rules.
Augmented SI (D): custom check_si against policy slabs (same helper as inception SI column).
Date of SI Enhancement (E): d-M-Y.
Policy must have slab/rack configuration or format step fails early (code 5).

Format error codes

Code	Meaning
1	Mandatory missing
2	Wrong format
3	Not in allowed list
4	Custom validation failed (e.g. invalid Augmented SI for slab)
5	File / policy / slab problem
6	Column headers wrong

Step 2: excelFileDataValidation

name_and_empid_check_in_db for si_enhancement:

Row must match active employee + active employee_polices on the policy.
Not found → error code 10 (“Record Not found”).

On success → queues employeesSIEnhanceProcess.

Step 3: employeesSIEnhanceProcess

flowchart TD A["Read row Augmented SI and date"] --> B["Match active employee and policy"] B --> C{"Pending SI on basic_cover_si?"} C -->|Yes| D["Skip row log error"] C -->|No| E["Resolve rack rate by relationship"] E --> F["premium_calculation_manager"] F --> G["Insert 3 pending endorsements actions si"]

Per row:

Strip number formatting from Augmented SI (removeNumberFormatting).
Load employee (emp code + name + branch) and active employee_polices row.
Find applicable slab/rack rate from member relationship (Son/Daughter → childrens, parents, etc.).
Build calculatable member payload via transform_si_excel_row_to_calculatable_format (uses family max age/count).
premium_calculation_manager → new premium for the augmented SI.
Insert pending endorsements on employee_polices (actions = si):

field_name	new_value source
`basic_cover_si`	Excel Augmented SI (column D)
`premium`	Recalculated premium from rack logic
`si_enhancement_date`	Excel Date of SI Enhancement (column E)

Sets files.status = success when the loop completes. Skipped rows (duplicate pending SI, missing member) are logged only — the file still succeeds.

SI Enhancement Excel columns

Col	Header	Required	Notes
A	S.No	Yes
B	EMP ID	Yes
C	NAME OF EMP/DEP	Yes	Must match DB
D	Augmented SI	Yes	New SI; validated via `check_si`
E	Date of SI Enhancement	Yes	`d-M-Y`

Row layout examples

Enhance Self SI — one row:

EMP ID	NAME	Augmented SI	Date of SI Enhancement
EMP001	Raj Kumar	1000000	19-May-2026

Enhance spouse only — separate row (premium uses that member’s relationship for rack selection):

EMP ID	NAME	Augmented SI	Date of SI Enhancement
EMP001	Priya Kumar	500000	19-May-2026

Developer steps

Confirm slab/rack rates exist for the client policy (same as inception).
Upload with upload-action-type=si_enhancement; note file_id.
On validation failure, check /employee/excel_error/{file_id} — codes 4 (SI/slab) or 10 (member missing).
After success, query emp_endorsement where file_id = upload id, actions = 'si', status = 'pending' — expect up to 3 rows per member (same group_key).
Compare new_value on basic_cover_si and premium to Excel and rack expectations.

Common pitfalls

Slab / rack not configured — format step or premium calc fails; relationship must map to a non-zero rack key.
Augmented SI vs slab — check_si in step 1 must pass before the job runs.
Pending SI already exists — duplicate upload for same member skipped until prior endorsement cleared.
Per-member rows — enhancing whole family requires one row per member (unlike deletion Self = whole family).
File success vs rows — files.status = success does not guarantee every row created endorsements.
Not live SI update — employee_polices.basic_cover_si changes after endorsement processing.