Skip to content

Quote Requirements - Workmen Compensation (WC)

Overview

Based on 2,555 policies from Premia UAT database for product 5030.

Core Policy Information

Mandatory Fields

Field Database Column Description
Product Code POL_PROD_CODE Must be '5030'
Policy Start Date POL_FM_DT Coverage start date
Policy End Date POL_TO_DT Coverage end date (typically 1 year)
Sum Insured PRAI_SI_FC Total annual wage roll
Premium POL_FC_PREM Calculated premium amount

Key Business Data

Employee Information Required

  1. Annual Wage Roll
  2. Total annual wages for all employees
  3. Stored in: PRAI_SI_FC field
  4. Range: AED 2,000 - AED 50,000,000

  5. Average: AED 804,662

  6. Employee Categories

  7. Number of employees by category
  8. Occupation classifications
  9. Skilled vs unskilled breakdown

  10. Administrative vs operational staff

  11. Industry Classification

  12. Type of business
  13. Industry risk category
  14. Occupation hazard level

Additional Risk Information

Fields typically required (specific PRAI field mapping to be determined):

  1. Business Information
  2. Company trade license
  3. Business activity description
  4. Number of employees

  5. Location of operations

  6. Wage Details

  7. Skilled workers wages
  8. Unskilled workers wages
  9. Administrative staff wages

  10. Management wages

  11. Coverage Periods

  12. Policy period: Typically 1 year
  13. Average from data: 365 days

Coverage Selection

Standard Coverages

  1. Workmens Compensation (503001) - Mandatory
  2. Primary employee injury coverage
  3. Used in 2,912 instances

  4. Average SI: AED 706,014

  5. Employer's Liability (503002) - Optional

  6. Additional employer protection
  7. Used in 19 instances
  8. Average SI: AED 894,737

Optional Adjustments

  1. General Discount (1001) - Available
  2. Applied to 1,617 policies

  3. Reduces final premium

  4. Fixed Discount (1002) - Available

  5. Applied to 1,617 policies

  6. Fixed amount or percentage reduction

  7. Loading (2001) - Risk-based

  8. Applied to 1,617 policies
  9. Increases premium for higher risk

Quote Process

Step 1: Collect Information

  • Company details and trade license
  • Total annual wage roll
  • Number of employees by category
  • Industry classification

Step 2: Calculate Premium

  • Determine occupational rate based on industry
  • Apply rate to total wage roll
  • Add any loadings for high-risk factors
  • Apply discounts if eligible

Step 3: Generate Quote

  • Policy period: Typically 1 year
  • Coverage amounts
  • Final premium
  • Payment terms

Validation Rules

Based on actual data patterns:

  1. Sum Insured Range
  2. Minimum: AED 2,000
  3. Maximum: AED 50,000,000

  4. Must match declared annual wage roll

  5. Premium Reasonability

  6. Rate typically: 0.0044% to 139.93%
  7. Average: 0.93%

  8. Median: 0.46%

  9. Policy Period

  10. Typically 1 year
  11. Can be shorter for specific needs
  12. Must align with business fiscal year

Database Structure

Main Tables

  • PGIT_POLICY - Policy master
  • PGIT_POL_RISK_ADDL_INFO - Employee and wage details
  • PGIT_POL_RISK_COVER - Coverage selections
  • PGIT_PREM_COLL - Premium collection details

Key Relationships

PGIT_POLICY (1) ──→ (Many) PGIT_POL_RISK_ADDL_INFO
PGIT_POLICY (1) ──→ (Many) PGIT_POL_RISK_COVER
PGIT_POLICY (1) ──→ (Many) PGIT_PREM_COLL

Integration Points

When creating a quote through API/middleware:

  1. Validate business license
  2. Collect complete wage roll data
  3. Determine industry classification
  4. Calculate appropriate rate
  5. Apply discounts/loadings
  6. Generate quote document

Data Source: Based on analysis of 2,555 actual WC policies from Premia UAT database. Field requirements derived from actual usage patterns.