CAIRS Ad Hoc Reports

CAIRS Ad Hoc Reports page

You can access the CAIRS Ad Hoc Reports page (shown below) from the CAIRS Search and Distribution page by selecting the Ad Hoc Reports hyperlink or from the Previous Selections page by clicking on the Use Query command button or from the CAIRS Search Selections page by selecting the End Selection command button. Any of the reports listed on this page can be generated using the current search selection. Report options include:

• Listing Reports
• User-Defined Reports
• Accident Costs Reports
• Injury/Illness Costs Reports

CAIRS Listing Page

The CAIRS Listing page is accessed from the CAIRS Ad Hoc Reports page by selecting the Listing hyperlink.

The CAIRS Listing page displays the report selection area (shown below). Within the selection area, you can choose the columns and summary options that will be reflected in the report generated by CAIRS. Case display options can also be specified.

• Data for the report is selected with the Display these columns check boxes and includes the following selections:

  Type of Accident

  Type of Investigation

  WDL: Days away from work

  WDLR: Days of restricted work duty

  LWD: Total lost workdays

  Death

  Dollar Losses: DOE Property or Vehicle Losses

  Description: One-line description of the accident

  Lag Days: The number of days between the accident date and the date the case was added to CAIRS.

  Add Date: The date the case was first added to CAIRS.

  (Note that system defaults are LWD, Dollar Losses, and Description.)

• Summary options (reporting organization, field office, year, and quarter) are selected with the Summary Options check boxes. The system default is summary by reporting organization. The Show all detail and Summary Only radio buttons allows you to specify the level of detail to be displayed. The system default is to show all detail.

• Case display options are selected with the Case Display Options radio buttons. Case numbers displayed on the report are hyperlinked to the individual cases. Clicking on the full report radio button will display hyperlinks to full reports, the front only radio button will display hyperlinks to the front of the reports, and back only will display hyperlinks to the back of the reports. The system default is hyperlinks to full reports.

REMEMBER THAT IF NO SELECTIONS ARE MADE, THE DEFAULTS WILL BE PROCESSED (i.e., display of total lost workdays, DOE dollar losses, and one-line descriptions, summarized by reporting organization, showing all detail, and hyperlinking to full reports).

Once selections are made, create the report (shown below) by clicking on the command button.

User-Defined Reports

The CAIRS User-Defined Reports page is accessed from the CAIRS Ad Hoc Reports page by selecting the User-Defined hyperlink. The CAIRS User-Defined Reports page displays the report selection area (partially shown below). Within the selection area, you can choose the fields to be included in the report and set report options.

• Any coded, date/time, narrative, and numeric search field can be selected for inclusion in the user-defined report. These can be selected in two ways:

  1. Click on one or more CAIRS User-Defined Reports check boxes to select the fields to be displayed in the report. The field numbers determine the order that the fields are displayed. Smaller numbers are displayed first.

  2. Enter the field numbers, separated by commas, into the CAIRS User-Defined Reports edit box. The order that the numbers are entered into the edit box determines the order that the fields are displayed.

  The system defaults for field selections are organization code, accident date, total days, and DOE dollar loss.

• Options include a Title edit box for entering the name of the report and database code radio buttons. The system default for database codes is to display the database codes.

• Case display options are selected with the Case Display Options radio buttons. The case number field is hyperlinked to the individual cases. Clicking on the full report radio button will display hyperlinks to full reports, the front only radio button will display hyperlinks to the front of the reports, and back only will display hyperlinks to the back of the reports. The system default is hyperlinks to full reports.

REMEMBER THAT IF NO SELECTIONS ARE MADE, THE DEFAULTS WILL BE PROCESSED (i.e., display of organization code, accident date, total days, and DOE dollar loss and display of codes rather than text). Note that the case number field is not a default field; therefore, hyperlinks to reports will not be available in the default report.

Once selections are made, created the report (shown below) by clicking on the command button.

Accident Costs Reports

The CAIRS Accident Costs page is accessed from the CAIRS Ad Hoc Reports page by selecting the Accident Costs hyperlink. Costs for these reports are determined in the following way:

• $1,000,000 per death
• $500,000 per termination
• $500,000 per transfer
• $2,000 per lost workday case
• $2,000 per non-fatal case without lost workdays
• $1,000 per day away from work
• $400 per restricted workday
• Reported DOE vehicle loss x 4
• Reported DOE property loss x 2

The CAIRS Accident Costs page displays the report selection area (shown below). Within the selection area, you can choose the report options, columns, and distribution options that will be reflected in the report generated by CAIRS

• There are three report options that the you can set:
  
  1. Sort. Radio buttons are used to select either a sort by costs or a sort by distribution category. The default for the sort option is sorting by costs.
  2. Use Costs for Deaths, Terminations, and Transfers. The default for this field is yes. To exclude the death, termination, and transfer costs from the report, change the default by clicking on the No radio button.
  3. Use Property/Vehicle Multipliers. The default for this field is yes. To exclude the effect of the multipliers and display real costs only, change the default by clicking on the No radio button.

• Report information is selected with the Display These Columns check boxes and the All Cases, Injury/Illness Cases, Property Damage Cases, and Vehicle Cases selection boxes and includes the following selections:
  Sum WDL
  Sum WDLR
  Average, Maximum, and Minimum Costs (All Cases)
  Injury/Illness Case Count
  Injury/Illness Costs
  Average, Maximum, and Minimum Injury/Illness Costs
  Property Damage Case Count
  Property Damage Costs (DOE Loss only)
  Average, Maximum, and Minimum Property Damage Costs
  Vehicle Case Count
  Vehicle Costs (DOE Loss only)
  Average, Maximum, and Minimum Vehicle Costs

  The system defaults for report information are Average Cost (All Cases), Injury/Illness Case Count, Injury/Illness Cost, Property Damage Case Count, Property Damage Costs, Vehicle Case Count, and Vehicle Costs.

• This report permits a distribution of report information by a user selected distribution field. The distribution field is selected with a radio button and includes the following selections:
  Area Office
  Operation Type
  Accident Place
  Accident Year
  Age
  On Premise
  Length of Employment
  Experience on Equipment
  Sex
  Occupation
  Activity
  Loss Producing Event
  Direct Cause
  Indirect Cause
  Other Equipment
  OSHA Code
  OSHA Type
  Body Part
  Injury/Illness Type
  PPE Used
  Source
  Property Loss Type
  Property Code (Upper Level Property Loss Types)
  Vehicle Type
  Vehicle Code(Upper Level Vehicle Types)
  Target

  The system default for the distribution field is accident year.

REMEMBER THAT IF NO SELECTIONS ARE MADE, THE DEFAULTS WILL BE PROCESSED (i.e., sort by costs, include costs for death, termination, and transfer and the property/vehicle multipliers, distribute by accident year, and display Average Cost (All Cases), Injury/Illness Case Count, Injury/Illness Cost, Property Damage Case Count, Property Damage Costs, Vehicle Case Count, and Vehicle Costs).

Once selections are made, the report is generated by clicking on the command button.

Injury/Illness Costs Reports

The CAIRS Injury/Illness Costs page is accessed from the CAIRS Ad Hoc Reports page by selecting the Injury/Illness Costs hyperlink. Costs for these reports are determined in the following way:

• $1,000,000 per death
• $500,000 per termination
• $500,000 per transfer
• $2,000 per lost workday case
• $2,000 per non-fatal case without lost workdays
• $1,000 per day away from work
• $400 per restricted workday

The CAIRS Injury/Illness Costs page displays the report selection area (shown below). Within the selection area, you can choose the report options, columns, and distribution options that will be reflected in the report generated by CAIRS

• There are two report options that the you can set:
  
  1. Sort. Radio buttons are used to select either a sort by costs or a sort by distribution category. The default for the sort option is sorting by costs.
  2. Use Costs for Deaths, Terminations, and Transfers. The default for this field is yes. To exclude the death, termination, and transfer costs from the report, change the default by clicking on the No radio button.

• Report information is selected with the Display These Columns check boxes and includes the following selections:
  Sum of WDL
  Sum of WDLR
  Sum of LWD
  Number of NFC: Nonfatal cases without day away or restricted workdays
  Number of Deaths
  Number of LWC: Lost workday cases (either days away or restricted workdays)
  Number of WDL Only: Lost workday cases with only days away from work
  Number of WDLR Only: Lost workday cases with only restricted workdays
  Term/Trans Count: The number of terminations and transfers
  Average and Maximum WDL
  Average and Maximum WDLR
  

  The system defaults for report information are all columns except Death, Term/Trans Count, and NFC.

• This report permits a distribution of report information by a user selected distribution field. The distribution field is selected with a radio button and includes the following selections:
  Area Office
  Operation Type
  Accident Place
  Accident Year
  Age
  On Premise
  Length of Employment
  Experience on Equipment
  Sex
  Occupation
  Activity
  Loss Producing Event
  Direct Cause
  Indirect Cause
  Other Equipment
  OSHA Code
  OSHA Type
  Body Part
  Injury/Illness Type
  PPE Used
  Source
  

  The system default for the distribution field is accident year.

REMEMBER THAT IF NO SELECTIONS ARE MADE, THE DEFAULTS WILL BE PROCESSED (i.e., sort by costs, include costs for death, termination, distribute by accident year, and display all columns except Death, Term/Trans Count, and NFC).

Once selections are made, the report (shown below) is generated by clicking on the command button.

CAIRS Help Table of Contents

CAIRS Help Index