v_incident_report_people_insurance

v_incident_report_people_insurance

Purpose

  1. Insurance information for incident-involved people.

Relationships

  • v_incident_report_people: Many-to-One (N:1)

    • Many insurance records link to one person

    • Referenced through incident_report_people_id

  • v_personnel: Many-to-One (N:1)

    • Many insurance records created by one personnel

    • Referenced through created_by



Table


Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

incident_report_people_id

integer

Person reference

person_policy_holder

boolean

Policy holder flag

policy_holder_name

varchar(255)

Policy holder name

insurance_company_name

varchar(255)

Insurance company

policy_type

integer

Policy type

policy_number

varchar(255)

Policy number

address

varchar(255)

Insurance address

unit

varchar(80)

Unit/suite

city

varchar(255)

City

state_code

varchar(3)

State code

zip

varchar(15)

ZIP code

insurance_phone_number

varchar(255)

Contact phone

insurance_phone_number_extension

varchar(8)

Phone extension

created_by

integer

Creator reference

created_at

timestamp

Creation time





    • Related Articles

    • v_incident_report_people

      Purpose People involved in incidents. Relationships v_incident_report: Many-to-One (N:1) Many people link to one incident Referenced through incident_report_id v_incident_report_people_address: One-to-Many (1:N) One person can have many addresses ...

    • NERIS Documentation - People Involved General Information

      Purpose The purpose of this article is to demonstrate the General Information section when documenting People Involved in a Fire report. Video Directions 1. From within a Fire report select on the People Involved section and select the People ...

    • v_incident_report_people_address

      Purpose Address records for incident-involved people. Relationships v_incident_report_people: Many-to-One (N:1) Many addresses link to one person Referenced through incident_report_people_id v_personnel: Many-to-One (N:1) Many addresses created by ...

    • v_incident_report_question

      Purpose Incident report question responses. Relationships v_incident_report: Many-to-One (N:1) Many questions link to one incident Referenced through incident_report_id v_incident_report_apparatus: Many-to-One (N:1) Many questions link to one ...

    • v_incident_report_apparatus

      Purpose Apparatus response details for incidents. Relationships v_incident_report: Many-to-One (N:1) Many apparatus responses link to one incident Referenced through incident_report_id v_apparatus: Many-to-One (N:1) Many responses link to one ...