| Field Name |
Name |
Type |
Description |
Fixed Values |
| ACCIDENT_NO |
ACCIDENT_NO |
CHAR(12) |
ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.
First character T indicates TIS incident and characters 2-5 typically represent the year in which the accident created in TIS system and characters 6-11 are a numeric sequencing number |
|
| EVENT_SEQ_NO |
SEQUENCE |
INTEGER(10) |
EVENT_SEQ_NO is an integer field that starts with 1 and incremented for more than one event in the same accident. This field cannot contain NULL values. |
|
| EVENT_TYPE |
EVENT TYPE |
CHAR(1) |
EVENT_TYPE is a character field indicates type of incident event. This field cannot contain NULL values. |
0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision |
| EVENT_TYPE_DESC |
EVENT TYPE DESC |
VARCHAR(100) |
Is a descriptive field that indicates type of incident event. This field cannot contain NULL values. |
0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision |
| VEHICLE_1_ID |
FIRST PARTICIPANT VEHICLE ID |
CHAR(1) |
VEHICLE_1_ID is character field indicates first vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values. |
|
| VEHICLE_1_COLL_PT |
POINT OF COLLISION 1 |
CHAR(1) |
VEHICLE_1_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values. |
|
| VEHICLE 1 COLL PT DESC |
VEHICLE 1 COLL PT DESC |
VARCHAR(100) |
Its a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values. |
0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U Undercarriage |
| VEHICLE_2_ID |
SECOND PARTICIPANT VEHICLE ID |
CHAR(1) |
VEHICLE_2_ID is character field indicates second vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values |
|
| VEHICLE_2_COLL_PT |
POINT OF COLLISION 2 |
CHAR(1) |
VEHICLE_2_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values. |
|
| VEHICLE 2 COLL PT DESC |
VEHICLE 2 COLL PT DESC |
VARCHAR(100) |
It's a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values. |
0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U |
| PERSON_ID |
PERSON_ID |
CHAR(2) |
Uniquely identifies each person involved in the accident. Persons who are drivers of a vehicle have a letter value assigned to them and persons who are not drivers have a numerical value assigned to them. |
|
| OBJECT_TYPE |
OBJECT TYPE |
CHAR(2) |
OBJECT_TYPE is a character field that identifies object involved in the specific accident event. This field cannot contain NULL values. |
1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island |
| OBJECT_TYPE_DESC |
OBJECT TYPE DESC |
VARCHAR(100) |
It's a descriptive field that identifies object involved in the specific accident event. This field cannot contain NULL values. |
1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island |
