ESLOffice Sync
Import the ESLOffice medical stop-loss database (SQL Server) into the standard reinsurance model, and export the model back to ESLOffice.
| ESLOffice | Model |
|---|---|
| carriers | Reinsurance/Cedent |
| treaties + specific layer quota share | Reinsurance/Treaty + Reinsurance/ModelledReinsuranceSection |
| stop-loss policies | Reinsurance/Acceptance |
| premium bordereaux, reimbursements | Reinsurance/Cashflow (per treaty and quarter) |
| specific and aggregate claims | Claims/Claim, the Claims/Register claims book |
| producers | Reinsurance/Broker |
| underwriting cases and quote options | Underwriting/Submission + option Reinsurance/Acceptance |
The mapping runs in the mesh, both directions (EslOfficeSync/Source); every field and every lossy spot is in the package's Mapping.md.
The rows are moved by the connector next to the database (ESLOffice/connector, esl-sync): extract writes the rows an import run maps,
apply runs the MERGE script an export run files. A connection names where its connection string lives (Key Vault secret, configuration key) —
never the value.
Re-running an import updates in place; an export touches only rows whose columns differ. The ESLOffice keys of every node are kept in {namespace}/EslKeys.