OPSIncidentAncillary
Name: OPS Incident Ancillary Tables
Type: Ancillary
Description: This table has entries for all Incident Ancillary Screens.
| Field | Documentation |
| AncillaryGroupId | Unique identifier for an ancillary group. Represents the type of data that the group of tables holds. (1 = Agency System Types, 2 = Visibility Conditions, 3 = Vehicle Motion Types, 4 = Traffic Signal Types, 5 = Road Signage, 6 = Vehicle Damage Location, 7 = Incident Occurred On/At, 8 = Vehicle Floor Condition, 9 = Bus Steps Condition, 10 = Bus Stop Proximity, 11 = Trip Event Types, 12 = Vehicle Door Types, 13 = Other Vehicle Direction, 14 = Vehicle Speed Ranges, 15 = Other Parties Condition, 16 = Other Parties Was, 17 = Other Parties Activity Type, 18 = Other Parties Location, 19 = Stairs Location, 20 = Stairs Shelter Details, 21 = Stairs Condition, 22 = Stairs Flight, 23 = Stairs Party Action, 24 = Escalator Direction, 25 = Escalator Condition, 26 = Platform Type, 27 = Rail Track Condition, 28 = Rail Track Type, 29 = Interior Lighting Condition, 30 = Rail Train Stop Type, 31 = Rail Grade Crossing Motion Type, 32 = Rail Derailment Type, 33 = Reportable Flag, 34 = Reportable Classification, 35 = Reported To, 36 = Injury Types, 37 = OP Authority Types, 38 = Interview Types, 39 = Manager Decisions, 40 = Employee Condition-Balance, 41 = Employee Condition-Walking, 42 = Employee Condition-Speech, 43 = Employee Condition-Bahaviour, 44 = Employee Condition-Eyes, 45 = Employee Condition-Body Odor, 46 = Parties Involved Types, 47 = System Rules Violated, 48 = SOPs Violated, 49 = General Rules Violated, 50 = Weather Conditions, 51 = Lighting Conditions, 52 = Road Conditions, 53 = Occurred, 54 = Rail Location, 55 = Safety Violations, 56 = Rail Line, 57 = Rail Branch). |
| IncidentAncillaryAbbr | Abbreviated name of the ancillary group. |
| Abbreviation | Abbreviated name of the ancillary group. |
| Description.OPSIncidentAncillary | Description of the ancillary group. |
| IsInjured | Only applicable if the ancillary group is 'Injury Types'. Indicates whether the employee was injured. |
| IsFatality | Only applicable if the ancillary group is 'Injury Types'. Indicates whether the employee's injury resulted in a fatality. |
| InternalFlag | Only applicable if the ancillary group is 'OPS Authority Types'. |
| Supervisor | Only applicable if the ancillary group is 'OPS Authority Types'. |
| Comments | Comments about the record. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| ModAction | Last action performed on the record. |