Specify New Database Search Criteria


To specify new ORPS database search criteria:

  1. Select the Specify New Database Search Criteria link from the Search and Reports main menu.

    The ORPS Search Criteria screen will be displayed, as shown below:

    ORPS Search Criteria Screen
    ORPS Search Criteria Page

    Note: To obtain online help on an item, click the question mark by the field name.

  2. The ORPS Search Criteria screen allows you to make selections from the following scrolling lists:

    Identification: Contains general report identification fields, including OR Number, Report Type, Report Year, Facility, etc. Select one or more by clicking with the left mouse button. To select more than one, press the Ctrl. key as you click.

    Chronology: Contains report date and time fields, including Last Modification, Discovery, Notifications, etc. Select one or more by clicking with the left mouse button. To select more than one, press the Ctrl key as you click.

    Narrative: Contains narrative fields, including descriptions, evaluations, etc. Select one or more by clicking with the left mouse button. To select more than one, press the Ctrl key as you click.

    Note: A thorough understanding of the data and the Occurrence Reporting process will greatly enhance your ability to formulate meaningful search profiles. For example, if you want to include in your search profile all “open” reports, you need to specify Notification Report (N), Update Report (U), or Update/Final Report (X) from the Report Type search field.

    The default in the selection boxes is No Selection. This section indicates that you are searching the entire database - you have not narrowed your search by making a selection.

    By default, fields selected from the selection boxes have the Boolean operator AND applied between selection boxes. You may use the Boolean Logic Specification edit box to specify the 'OR' or 'NOT' operators (or a combination of all three operators) between fields.

  3. To exclude certain types of data from your report, select any or all of the following checkboxes: UCNI, Canceled, or USEC. Clicking a checkbox excludes the selected data from your report.

    The following fields were added during the ORPS Redesign and do not apply to data entered prior to the ORPS redesign:

    Reporting Criteria (Identification). The new Reporting Criteria field is substantially different from the old Nature of Occurrence field, and so may not be applied to data entered prior to the transition to the redesigned ORPS.

    Cause Codes: The Causal Analysis Tree is provided here in PDF form, and replaces the Direct, Root, and Contributing cause designators.

    Significance Category (Identification): Available Significance Categories include OE (Operating Emergency), 1, 2, R, 3, and 4. The Significance Category defines the severity of the occurrence. Significance categories E and 1 are the highest in severity and category 4 is the lowest. Each Nature of Occurrence has a significance category assigned to it. When the user selects a Nature of Occurrence, the Significance Category associated with that NOC is automatically selected. If more than one NOC is selected for an occurrence, the highest Significance Category is assigned to the occurrence.

    ISM Codes (Identification): ISM Codes (Integrated Safety Management Codes) – these codes are assigned to an occurrence report as required. Currently ISM codes include the following: 1 – Define Scope of Work; 2 – Analyze the Hazards; 3 – Develop and Implement Hazard Controls; 4 – Perform Work Within Controls; and 5 – Provide Feedback and Continuous Improvement. Additional ISM codes will be added as required.

    Subcontractor Involved (Identification list): This field defines whether or not a subcontractor was involved in the occurrence.

    Subcontractor Name (Narrative list): This field identifies the name of the subcontractor.

To refine your search and specify values for your selections:

  1. After choosing the search criteria, click the Refine Search and Specify Values button at the bottom of the screen. The selected fields will be expanded and displayed, as shown in the image below. Note the legend above the search fields. Fields that are marked with (B) pertain to data entered using the old ORPS interface prior to the 2003 redesign. Fields marked with (A) pertain to data entered on or after the ORPS redesign using the new interface. Fields labeled (B/A) pertain to all ORPS data, before and after the redesign. When a B/A field is expanded, you will two columns. The left column contains field values of the ORPS system prior to the redesign. The right column contains ORPS field values on or after the redesign. Both columns default to Any. In other words, if you make no selections, you are searching through the entire database.

    In the example below, the user wanted to search the new database only and find all reports with Significance Category OE or 1, and Reporting Criteria 1 - Operational Emergency. In the left column, the user selected Search Significance Category Only and Search RC Only.

    Warning: Making these selections effectively eliminates all records in the old database!

    Refine Search and Specify Values
    Refine Search and Specify Values

  2. Choose one or more options from the selection boxes provided for each expanded field. To make more than one selection, hold down the Ctrl key while you click.

    Values specified within selection boxes always have the Boolean operator OR applied. Values specified between selection boxes have the Boolean operator AND applied.

To review individual records from result set:

  1. Click the Review Individual Records from Result Set command button.

    The search result set will be displayed as shown below:

    Review Individual Records From Result Set
    Review individual records from result set

  2. Click the Exclude or Include radio button to tell the system either to include your selected records in your report, or to exclude them from your report. For example, if all reports are to be included except for a select few, it is more convenient to choose the Exclude radio button.

  3. To view a record, select the link corresponding to the desired report.

  4. To select a subset of search results to be included in a report, click the checkboxes beside the records to be included.

  5. To generate a report from the selected search criteria, click the Finished Searching, go to Report Options button from the button bar at the bottom of the screen. If the button bar is not visible on your screen, use the screen's scrolling arrows to bring it into view.

  6. To save the search criteria as a profile for later use, click the Save my Search Criteria as a Profile button from the button bar.


    ORPS Help Table of Contents ORPS Help Index