RX_HAZARDS_ARCHIVE

HAZARD_ID

ID associated with the hazard. Corresponds to the ID field in the RX_HAZARDS table.

INCIDENT_ID

The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS table.

CALL_ID

The unique identifier associated with the call. This field corresponds with the ID field in the RX_CALLS table.

FCID

Feature class ID of the feature associated with the tag.

OID

Object ID of the feature associated with the tag.

SUBID

The unique ID of each segment of a complex edge.

FACILITY_ID

The Facility ID of the incident device as defined in the geodatabase.

REGION

The region in which the tag or ground is located. This field uses the REGION domain.

X

The x-coordinate of the incident device.

Y

The y-coordinate of the incident device.

DAMAGE_TYPE

This is the hazard type. This field uses the HAZARD_TYPE domain.

STATUS

Indicates the status of the hazard. This field uses the STATUS domain.

WIRE_OWNER

The owner of the "wires down" hazard. This field uses the HAZARD_TYPE_OWNER domain.

TIME_CREATED

The time the hazard incident was created.

TIME_SECURED

Indicates the time that the hazard was made secure.

TIME_COMPLETED

Indicates the time that the hazard was fixed.

TIME_PUBLIC_SAFETY_ARR

The time a public safety official arrived at the hazard scene.

TIME_PUBLIC_SAFETY_REL

The time a public safety official was relieved from the hazard scene.

REMARKS

Notes from the operator or dispatcher.

USER_CREATED

The name of the user who created the record. This field is populated automatically by Responder.

USER_UPDATED

The name of the user who updated the record. This field is populated automatically by Responder.

CHANGE_DATE

The time and date an operation was performed on the record.

OPERATION

The operation (e.g., insert, delete, update) performed on the record.

USER_UPDATED_ARCH

This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who updated the record.

CANCEL_REASON

Reason the hazard was cancelled.

FEATURE_CLASS_NAME

The name of the Feature Class on which the incident occurred, as it was configured/named when the Incident was archived.

ADDRESS

The address where the incident is located