RX_CREW_SUB_ASSIGNMENTS_ARCHIVE

Field Name

Description

SUB_ASSIGNMENT_ID

Internal database field used as foreign key during crew assignment.

INCIDENT_ID

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

CREW_ARCHIVE_ID

Crew ID when archived.

CREW_NAME

The name of the crew.

INCIDENT_CHILD_TYPE

The type of feature to which the crew record was associated.

FCID

Feature class ID of the feature.

OID

Object ID of the feature

FACILITY_ID

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

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.