FSO Core Insurance tables
This section explains the insurance tables in FSO Core and how they handle insurance data.
Insurance tables installed
| 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. |
Parent Topic:Financial Services Operations Core