Insurance Functions

Generate insurance and risk management data

Insurance Functions

Generate realistic insurance and risk management data for testing insurance applications.

Policy Management

generate_policy_number

Generate insurance policy numbers.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`insurance_type`	string	`auto`	`auto`, `home`, `life`, `health`, `commercial`, `umbrella`, `disability`, `workers_comp`

columns:
  - name: policy_number
    function: generate_policy_number
    parameters:
      insurance_type: home

Output: HO2412345678

generate_claim_number

Generate insurance claim numbers.

Category: Insurance Type: Generator Data Types: string

columns:
  - name: claim_number
    function: generate_claim_number

Output: CLM-20240315-ABC12345

generate_endorsement_number

Generate policy endorsement numbers.

Category: Insurance Type: Generator Data Types: string

columns:
  - name: endorsement_number
    function: generate_endorsement_number

Output: END-20240315-A1B2

Coverage & Pricing

generate_coverage_code

Generate insurance coverage type codes.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`insurance_type`	string	`auto`	`auto`, `home`, `life`, `health`, `commercial`

Coverage codes by type:

auto: BI, PD, COMP, COLL, UMBI, PIP
home: DWL, PERS, LIAB, FLOOD, FIRE
life: TERM, WHOLE, UNIV, VAR
health: MED, HOSP, DENT, VIS, PRES
commercial: GL, PROD, PROF, CYBER, EPL

columns:
  - name: coverage_type
    function: generate_coverage_code
    parameters:
      insurance_type: auto

generate_deductible_amount

Generate insurance deductible amounts.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`insurance_type`	string	`auto`	`auto`, `home`, `health`, `commercial`

columns:
  - name: deductible
    function: generate_deductible_amount
    parameters:
      insurance_type: home

Output: $1,000 or 2% of dwelling coverage

generate_premium_amount

Generate insurance premium amounts.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`insurance_type`	string	`auto`	`auto`, `home`, `life`, `health`, `umbrella`, `disability`, `commercial`
`period`	string	`annual`	`monthly`, `quarterly`, `semi_annual`, `annual`

columns:
  - name: annual_premium
    function: generate_premium_amount
    parameters:
      insurance_type: auto
      period: annual

Output: $1,500/year

Risk Assessment

generate_risk_score

Generate risk assessment scores.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`scale`	string	`1-10`	`1-10`, `1-100`, `letter`

columns:
  - name: risk_score
    function: generate_risk_score
    parameters:
      scale: "1-10"

Output: 7/10 (High)

generate_loss_ratio

Generate insurance loss ratios.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`insurance_type`	string	`auto`	`auto`, `home`, `health`, `commercial`, `workers_comp`

columns:
  - name: loss_ratio
    function: generate_loss_ratio

Output: 68.5%

Personnel

generate_adjuster_id

Generate claims adjuster IDs.

Category: Insurance Type: Generator Data Types: string

columns:
  - name: adjuster_id
    function: generate_adjuster_id

Output: ADJ-ABC123

generate_underwriter_id

Generate underwriter identification numbers.

Category: Insurance Type: Generator Data Types: string

columns:
  - name: underwriter_id
    function: generate_underwriter_id

Output: UW-XYZ789

generate_beneficiary_id

Generate beneficiary identification numbers.

Category: Insurance Type: Generator Data Types: string

columns:
  - name: beneficiary_id
    function: generate_beneficiary_id

Output: BEN-12345678

Specialized

generate_reinsurance_treaty

Generate reinsurance treaty numbers.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`treaty_type`	string	`quota_share`	`quota_share`, `surplus`, `excess_of_loss`, `catastrophe`, `stop_loss`, `facultative`

columns:
  - name: treaty_number
    function: generate_reinsurance_treaty
    parameters:
      treaty_type: catastrophe

Output: CAT-2024-ABC123

generate_catastrophe_code

Generate catastrophe event codes.

Category: Insurance Type: Generator Data Types: string

columns:
  - name: cat_code
    function: generate_catastrophe_code

Output: HU2024001 (Hurricane 2024, sequence 001)

generate_actuarial_table

Generate actuarial table references.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`table_type`	string	`mortality`	`mortality`, `morbidity`, `annuity`

columns:
  - name: actuarial_table
    function: generate_actuarial_table

Output: 2017 CSO Ultimate ANB

generate_exclusion_code

Generate policy exclusion codes.

Category: Insurance Type: Generator Data Types: string

Parameter	Type	Default	Description
`insurance_type`	string	`auto`	`auto`, `home`, `life`, `health`

columns:
  - name: exclusion_code
    function: generate_exclusion_code

Output: FLOOD, RACING, PREEXIST

Complete Policy Example

tables:
  - name: policies
    columns:
      - name: policy_number
        function: generate_policy_number
        parameters:
          insurance_type: auto
      - name: coverage_type
        function: generate_coverage_code
        parameters:
          insurance_type: auto
      - name: deductible
        function: generate_deductible_amount
        parameters:
          insurance_type: auto
      - name: annual_premium
        function: generate_premium_amount
      - name: risk_score
        function: generate_risk_score
      - name: underwriter_id
        function: generate_underwriter_id

Finance Functions - Financial data
Medical Functions - Healthcare data

Insurance Functions