MGA Data Standard
Standard Data Model for Policy Administration Systems
Core Policy Data Fields
This document defines the standard data model for MGA policy administration systems. Use this specification when building custom integrations or evaluating PAS platforms.
| Field Name | Data Type | Required | Description | Example |
|---|---|---|---|---|
policy_number |
String (50) | Yes | Unique policy identifier | "POL-2025-001234" |
inception_date |
Date | Yes | Policy start date (YYYY-MM-DD) | "2025-01-15" |
expiry_date |
Date | Yes | Policy end date (YYYY-MM-DD) | "2026-01-14" |
insured_name |
String (200) | Yes | Full legal name of insured | "ABC Manufacturing Ltd" |
premium |
Decimal(12,2) | Yes | Total premium amount | 12500.00 |
commission_rate |
Decimal(5,2) | Yes | Commission percentage | 15.00 |
limit |
Decimal(15,2) | Yes | Policy limit amount | 1000000.00 |
deductible |
Decimal(12,2) | Yes | Deductible amount | 5000.00 |
class_of_business |
String (50) | Yes | Insurance class code | "Property", "Liability" |
binder_id |
String (50) | Yes | Binder/authority identifier | "BIND-2024-001" |
status |
Enum | Yes | Policy status | "Active", "Cancelled", "Expired" |
Risk Level Data Fields
| Field Name | Data Type | Required | Description |
|---|---|---|---|
address_line_1 |
String (200) | Yes | Primary address |
postcode |
String (20) | Yes | Postal/ZIP code |
construction_type |
String (50) | No | "Frame", "Masonry", "Concrete" |
occupancy_type |
String (50) | No | "Office", "Warehouse", "Retail" |
annual_revenue |
Decimal(15,2) | No | Business annual revenue |
risk_score |
Decimal(5,2) | No | Calculated risk score (0-100) |
Data Type Definitions
- String(n)
- Text field with maximum length n characters. UTF-8 encoding.
- Decimal(p,s)
- Numeric field with precision p (total digits) and scale s (decimal places). Example: Decimal(12,2) = 9999999999.99
- Date
- Date value in ISO 8601 format: YYYY-MM-DD
- DateTime
- Date and time in ISO 8601 format: YYYY-MM-DDTHH:MM:SSZ
- Boolean
- True/false value. Represented as 1/0 or true/false
- Enum
- Predefined list of allowed values. Must match exactly.
Standard Rating Logic Example
IF construction_type == "Wood Frame" THEN
base_rate_multiplier = 1.2
ELSE IF construction_type == "Masonry" THEN
base_rate_multiplier = 1.0
ELSE IF construction_type == "Concrete" THEN
base_rate_multiplier = 0.9
END IF
IF occupancy_type == "Warehouse" THEN
occupancy_multiplier = 1.15
ELSE IF occupancy_type == "Office" THEN
occupancy_multiplier = 1.0
END IF
base_premium = limit / 1000 * base_rate
final_premium = base_premium * base_rate_multiplier * occupancy_multiplier
IF final_premium > referral_threshold THEN
status = "Referral Required"
ELSE
status = "Auto-Bind Eligible"
END IFNote: FacioMGA uses this logic structure natively, allowing business users to configure rating rules without code.