fct_incidents

The unique ID of the incident, i.e. 14.

The associated ticket ID of the incident, i.e. 59.

The profile ID that reported the incident, i.e. 10.

The profile ID of the subject of the incident, i.e. 3283.

Whether the incident is open or closed.

When the incident occured at (in UTC), e.g. 2021-03-02 00:12:59.996101.

When the incident occured at (in UTC), e.g. 2021-03-02 00:12:59.996101.

When the incident was created by the staffer (in UTC), e.g. 2021-03-02 00:12:59.996101.

When the incident was last updated (in UTC), e.g. 2021-03-02 00:12:59.996101.

The main category the incident was categorised as. These 22 categories were set by lookout. E.g. abuse_emotional.

Any other relevant categories for the incident. It contains all values in the primary_category plus a few others. Multiple can be selected. E.g. {fall, injury}

This is selected by the lookout decision support tool, and selects the level based on what the primary category is. It is based of the SIRS framework. One of 3 values: non_reportable, priority_one, priority_two.

The level that is selected by the staffer who is overlooking the incident. One of 4 values non_reportable, reportable, priority_one, priority_two.

Whether this incident caused or could reasonably expect to have caused physical, or psychological injury or discomfort that requires treatment. E.g. True or False

Whether there is reasonable grounds to notify the police or not. E.g. True or False

Whether unlawful sexual conduct or inappropriate sexual conduct has occured. E.g. True or Fals.e

Whether an unexpected death has occured or the client has an unexplained absence during the incident. E.g. True or False

What is the persons cognitive status? One of 4 possible values: none: No cognitive impairment mild: Mild cognitive impairment moderate: Moderate cognitive impairment severe: Severe cognitive impairment

When the incident category was created at (in UTC), e.g. 2021-03-02 00:12:59.99610.1

When the incident category was updated at (in UTC), e.g. 2021-03-02 00:12:59.99610.1

The company ID, e.g.: 345.

Where the incident took place, one of 5 values: client_home, outisde_home, hospital, respite, other.

The ID of the membership associated with the incident, e.g. 1989.