RX_HAZARD_ASSIGN_HISTORY

HAZARD_ASSIGN_ID

The ID of the hazard assignment. This field serves as a foreign key to the RX_HAZARD_ASSIGNMENTS table.

HAZARD_ID

The ID of the hazard. This field serves as a foreign key to the RX_HAZARDS table.

CREW_ASSIGNMENT_ID

The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.

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 date an operation was performed on the hazard record.

OPERATION

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