CA Actual Completion Date

This chronology field is the date when a corrective action was actually completed. This field will exist for all occurrence reports where corrective actions have been completed.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values command button. Specify the date using the CA Actual Completion selection boxes and check boxes shown in the image below. Select one or more of the < (less than), > (greater than), or = (equal to) check boxes to select a range of dates. The example below shows a search for all CA Actual Completion Dates less than or equal to May 5, 2002.

CA Actual Completion Date Selection Boxes


CA Date Justification

The CA Date Justification is a narrative field used by the Facility Manager to indicate the justification or reason for revising a corrective action target completion date.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Select the Refine Search and Specify Values command button. Specify the justification text using the CA Date Justification edit box shown in the image below. Within the edit box enter single words or words/phrases, combined with text operators. What you specify in this edit box will be used to search the CA Date Justification text.

CA Date Justification Edit Box


CA Revision Count

This identification field identifies the number of times that a corrective action target date has been revised. All corrective actions will have a default revision count of zero until the target date is revised. The count increments by one each time the target date is revised. An entry for this field will exist for all occurrence reports for which corrective actions exist. Note that the count is maintained at a corrective action level. For example, different corrective actions may have different revision counts for the same occurrence report.

To specify values for this field, select it on the Specify New Database Search Criteria page. Click the Refine Search Specify Values command button. Enter the number of revisions into the CA Revision Count edit box. To search for a range of revision numbers, click the < (less than), > (greater than), or = (equal to) checkboxes.

CA Revision Count search field


CA Target Completion Date

This chronology field is the latest date, either original or revised, when a corrective action is, or was, scheduled to be completed. This field will exist for all occurrence reports where corrective actions exist.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values field. Specify the date using the CA Target Completion selection boxes and check boxes shown in the image below. Select a year, month, and day from the selection boxes, and click the < (less than), > (greater than), or = (equal to) check boxes.

To perform an IS NULL search on a chronology field: Occasionally it may be necessary to find records that have no value in a selected chronology field - in other words, the field is blank. To retrieve a list of such records, make no selections in the date selection boxes - leave the default Any, and make no date range (>=<) selections. Click Refine Search and Specify Values. The search results will include all records with the selected chronology field blank.

To perform an IS NOT NULL search on a chronology field: An IS NOT NULL search shows all records that DO have a value in a selected chronology field - the field can have anything in it, but it is NOT blank. To retrieve a list of non-null records for a selected chronology field, make no date selection (leave the default Any), and select ALL range operators (>=<).

The criteria in the following example show a search for all reports with CA Target Completion Date greater than or equal to May 1, 2001.

CA Target Completion Date Selection Boxes


Categorization Date/Time

This chronology field is the date and time the occurrence was assigned a Significance Category. Categorization should occur within two hours of Discovery. This field is required for all notification, update, and final reports.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values field. Specify the date and time using the Categorization Date/Time selection boxes and check boxes shown in the image below. Select a year, month, and day from the selection boxes, and click the < (less than), > (greater than), or = (equal to) check boxes. The following example specifies a categorization date on or after May 1, 2001 (any time).

Categorization Date Selection Box


Cause Codes

This identification field defines the reasons for a particular occurrence - what made it happen. Note that in previous versions of ORPS, causes were categorized according to Root, Contributing, and Direct cause. For data entered on or after the ORPS Redesign, events will be assigned Cause Codes instead.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values command button. on the Direct-Contributing-Root/Cause Codes(s) selection box, select one or more cause codes from the selection box. To select more than one, hold down the Ctrl key as you make the selections. The full definition of each selected cause code will appear in the Full Description box.

Cause Codes Selection Boxes


Cause Description

This narrative field discusses the cause(s) of the occurrence and the corrective actions identified. Answers should be based on the Cause Code assigned to the occurrence. This field is required for all Final Occurrence Reports.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values command button. Specify the cause text using the Cause Description edit box shown in the image below. Within the edit box enter single words or words/phrases, combined with text operators. What you specify in this edit box will be used to search the Cause Narrative text.

Cause Description Edit Box


Chronology selection box

The Chronology selection box is located on the Specify New Database Search Criteria page. This box allows the user to specify the following fields for further search refinement:

  1. Current Report Date/Time
  2. Last Modification Date
  3. Discovery Date/Time
  4. Categorization Date/Time
  5. HQ EOC Notification Date/Time
  6. Other Notifications Date/Time
  7. Notification Report Date/Time
  8. Initial Update Report Date/Time
  9. Latest Update Report Date/Time
  10. Final Report Date/Time
  11. Rejected Date
  12. Further Evaluation Date
  13. FM Approval (Sign-off Date)
  14. FR Approval (Sign-off Date)
  15. PM Approval (Sign-off Date)
  16. CA Target Completion Date
  17. CA Actual Completion Date

Specifying chronology dates

A series of selection boxes and check boxes are used to set chronology dates and times, as shown in the figure below.

Discovery Date Selection Boxes

To specify a date range:

  1. Select a year, month, day, and (if applicable), hour and minute from the date selection boxes. The selection boxes default to Any, meaning that all dates are selected by default.

  2. Select a range operator - choices include "<" (less than), ">" (greater than), and "=" (equal to). You may also specify date ranges by specifying more than one date and using the internal OR logic within a selection box.

  3. Select the Refine Search and Specify Values command button at the bottom of the ORPS Search Criteria page.

    When the page is recreated, the number of results is displayed at the top of the page.

To perform an IS NULL search on a chronology field: Occasionally it may be necessary to find records that have no value in a selected chronology field - in other words, the field is blank. To retrieve a list of such records, make no selections in the date selection boxes - leave the default Any, and make no date range (>=<) selections. Click Refine Search and Specify Values. The search results will include all records with the selected chronology field blank.

To perform an IS NOT NULL search on a chronology field: An IS NOT NULL search shows all records that DO have a value in a selected chronology field - the field can have anything in it, but it is NOT blank. To retrieve a list of non-null records for a selected chronology field, make no date selection (leave the default Any), and select ALL range operators (>=<).

The example below shows a search that will yield all records with the current report date less than or equal to February 1, 2002, any time.

Current Report Date Selection Boxes


Codes / Stds Impact

Note: This field is used primarily for performing searches on data entered prior to the ORPS redesign.

This narrative field contains a statement regarding the adequacy of the codes or standards (if the occurrence affected the requirements of nationalcodes and standards, program standards or DOE orders), along with any recommended changes.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values command button. Specify the text using the Codes/Stds Impact edit box shown in the image below. Within the edit box enter single words or words/phrases, combined with text operators. What you specify in this edit box will be used to search the Narrative text.

Codes and Standards Impacts Edit Box


Contractor

This identification field identifies the contractor(s) who are associated with an event. Note that every occurrence report must have a contractor associated with it. Contractors may be associated with Area Offices and are always associated with a Operations / Field Office. The organizational hierarchy also includes Facilities. Occasionally contracting organizations change or a Contractor is reassigned to a different Field Office or Area Office.

To specify values for this field, highlight it on the Specify New Database Search Criteria or the ORPS Authority Search and Reports page. Click the Refine Search and Specify Values command button. Specify values for this field using the Contractor selection box. To select more than one option, hold down the Ctrl key while making the selections. Note that OR logic is always applied when there are multiple selections within a selection box.

Contractor Edit Box


Contributing Cause(s)

Note: The Contributing Cause identification field has been replaced by the new Cause Code field for all data entered on or after transition to the ORPS redesigned interface. For data entered prior to 7/1/2003, you may still perform searches using the Contributing Cause field.

Contributing Causes are causes that contributed to the occurrence but, that by themselves, would not have caused the occurrence. Every final occurrence report may have one to three contributing causes identified. Update occurrence reports and notification occurrence reports may also have one to three contributing causes identified.

IMPORTANT NOTE: You should be aware of potential problems if you choose to include update occurrence reports and notification occurrence reports in your search. These two types of reports may not have any contributing cause identified. If a contributing cause is identified, it is subject to change prior to approval of the final occurrence report.

Causes are classified into nine broad categories and various subcategories.

To specify values for this field, highlight Direct-Contributing-Root / Cause Code(s) on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values command button. Specify values for this field using the Contributing Cause(s) selection box shown in the image below. To select more than one Contributing Cause, hold down the Ctrl key while making the selections. Note that OR logic is always applied when there are multiple selections within a selection box.

Contributing Cause Selection Box


Corrective Action(s)

This narrative field lists all actions identified to correct the problem that, when completed, will prevent recurrence. In addition, actual or target completion dates are listed. For similar occurrences previously documented in an approved Final Report, the corrective action narrative should state: "The corrective actions are the same as those stated in the original approved Final Report" and provide the original approved Final Report number. This field is required for all Final Occurrence Reports.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Click the Refine Search and Specify Values command button. Specify the corrective action text using the Corrective Action(s) edit box shown in the image below. Within the edit box enter single words or words/phrases, combined with text operators. What you specify in this edit box will be used to search the Corrective Actions text.

Corrective Actions Edit Box


Current Report Date/Time

This chronology field is the date and time that the latest version of the occurrence report was made available to the ORPS General User. For an occurrence that is currently a notification or update report on the system, this is the date that the notification or update report was last transmitted. In the case of a final report, it is the date that the program manager signed off on the report.

To specify values for this field, highlight it on the Specify New Database Search Criteria page. Select the Refine Search and Specify Values command button. Specify the date and time using the Current Report selection boxes and check boxes shown in the image below. The example shown below shows a search for current reports with dates less than or equal to February 1, 2002.

Current Report Date/Time Selection Boxes

ORPS Help Table of Contents ORPS Help Index