FSO Core Insurance tables

This section explains the insurance tables in FSO Core and how they handle insurance data.

Insurance tables installed

Table 1. Financial Services Operations Core tables

Label	Table name	Description
Business Owners Policy	sn_bom_bo_ins_policy	Insurance Policy
Claim Base	sn_bom_claim_base	Claim base is the table from which all the insurance app specific claim case types are extended. This table contains all the common attributes which can be used across insurance claims case types.
Commercial Auto Policy	sn_bom_ca_ins_policy	Insurance commercial auto policy table extended from insurance policy.
Commercial Property Policy	sn_bom_cp_ins_policy	Insurance commercial property policy table extended from insurance policy.
Commercial Travel Policy	sn_bom_ct_ins_policy	Stores information about a commercial travel policy issued to a policy holder. Extends Insurance Policy [sn_bom_ins_policy].
Commercial Umbrella Policy	sn_bom_cu_ins_policy	Insurance commercial umbrella policy table extended from insurance policy.
Condo Policy	sn_bom_condo_ins_policy	Insurance personal condo policy table extended from insurance policy.
Farm Ranch Policy	sn_bom_fr_ins_policy	Insurance commercial farm ranch policy table extended from insurance policy.
General Liability Policy	sn_bom_gl_ins_policy	Insurance general liability policy table extended from insurance policy.
Group Disability Insurance Policy	sn_bom_group_disability_ins_policy	Insurance group disability policy table extended from insurance policy.
Group Life Insurance Policy	sn_bom_group_life_ins_policy	Insurance group life policy table extended from insurance policy.
Homeowner Policy	sn_bom_homeowner_ins_policy	Insurance homeowners policy table extended from insurance policy.
Individual Disability Policy	sn_bom_indiv_disab_policy	Insurance individual disability policy table extended from insurance policy.
Individual Life Policy	sn_bom_indiv_life_policy	Insurance individual life policy table extended from insurance policy.
Insurance Policy	sn_bom_ins_policy	Stores all insurance policy account records. Extends the Sold Product [sn_install_base_sold_product] table.
Insured Property	sn_bom_insured_property	Insured property table references customer property and will contain the properties of a customer which are covered by an insurance policy.
Landlord Policy	sn_bom_landlord_ins_policy	Insurance landlord policy table extended from insurance policy.
Personal Auto Policy	sn_bom_auto_ins_policy	Insurance personal auto policy table extended from insurance policy.
Personal Travel Policy	sn_bom_pt_ins_policy	Stores information about a personal travel policy issued to a policy holder. Extends Insurance Policy [sn_bom_ins_policy].
Personal Umbrella Policy	sn_bom_pu_ins_policy	Insurance personal umbrella policy table extended of insurance policy.
Policy Coverage	sn_bom_policy_coverage	Policy coverage table will contain the defined coverages on the insurance policy.
Policy Participant	sn_bom_policy_participant	Policy participant table will contain the defined participants on the insurance policy.
Policy Participant Role	sn_bom_policy_participant_insured_property	Policy participant role table will contain the roles played by the participants who have been defined on the insurance policy.
Renters Policy	sn_bom_renters_ins_policy	Insurance personal renters policy table extended from insurance policy.
Transaction	sn_bom_ins_policy_transaction	Stores all policy transaction records. Extends the Financial Transaction [sn_bom_transaction] table.