Life Risk - editing in SQL Server

To edit Life Risk data, open Microsoft SQL Server Management Studio and connect to your database.

Navigate to these tables and double-click on any entry to edit.

There are a number of tables in the database which relate to Life Risk Analysis as follows:

Main Types

Opens the Life Risk Main Types table tblLifeRiskMainTypes to populate the drop-down for Life Risks.

Opens the Life Risk Sub Types table tblLifeRiskSubTypes to populate the drop-down for Life Risks.

Opens the Life Risks table tblLifeRisks to enter the combinations of types which are to be treated as Life Risks.

Opens the Life Risk Categories table tblLifeRiskCategories to enter risk bands, e.g. High, Medium, Low.

Opens the Life Risks table tblLifeRiskResponseTimes to enter the targets, e.g. High, 1st appliance in 5 minutes, etc.

The mapping of area name onto risk, e.g. Yarm = Low