RX_HAZARD_ASSIGN_HISTORY

Field Name

Description

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.

QR code for this page

Was this helpful?