| Field Name |
Name |
Type |
Description |
Fixed Values |
| ACCIDENT_NO |
Accident Number |
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. |
|
| 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. |
|
| VEHICLE_ID |
Vehicle ID |
CHAR(1) |
VEHCILE_ID is a character field that uniquely identifies each vehicle involved in the accident. Vehicles have a letter value assigned to them |
|
| SEX |
Sex |
CHAR(1) |
This indicates the driver's sex and is a user editable field. |
Code Description M Male F Female U Not known |
| AGE_GROUP |
Age Group |
VARCHAR(7) |
The age grouping of the person involved in the crash |
|
| INJ_LEVEL |
Injury Level |
CHAR(1) |
This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident. It is calculated field using inj_police_level and taken_hospital. This field cannot contain NULL values. |
Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured |
| INJ_LEVEL_DESC |
Injury Level Desc |
VARCHAR(100) |
This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident |
Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured |
| SEATING_POSITION |
Seating Position |
CHAR(2) |
This is a character field indicates where the person was located on the vehicle. This field cannot contain NULL values. |
Code Description CF Centre-front CR Centre-rear D Driver or rider LF Left-front LR Left-rear NA Not applicable NK Not known OR Other-rear PL Pillion passenger PS Motorcycle sidecar passenger RR Right-rear |
| HELMET_BELT_WORN |
Seat Belt/Helmet Worn |
CHAR(1) |
This is a character field indicates whether or not the person was wearing a helmet or seatbelt at the time of the accident. This field cannot contain NULL values. |
Code Description 1 Seatbelt worn 2 Seatbelt not worn 3 Child restraint worn 4 Child restraint not worn 5 Seatbelt/restraint not fitted 6 Crash helmet worn 7 Crash helmet not worn 8 Not appropriate 9 Not known |
| ROAD_USER_TYPE |
Road User Type |
CHAR(2) |
ROAD_USER_TYPE is a character field indicates what the role of the person was at the time of the accident. It is calculated field using person_status and vehicle_type from vehicle table. This field cannot contain NULL values. |
Code Description 1 Pedestrian 2 Driver (of V-type 1-9 17 60-63 70-71) 3 Passenger (of V-type 1-9 17 60-63 70-71) 4 Motorcyclist 5 Pillion Passenger 6 Bicyclist (incl. passengers) 7 Other driver (V-type 14-16 99) 8 Other passenger (V-type 14-16 99) 9 Not known |
| ROAD_USER_TYPE_DESC |
Road User Type Desc |
VARCHAR(100) |
ROAD_USER_TYPE is a descriptive field indicates what the role of the person was at the time of the accident. It is calculated field using person_status and vehicle_type from vehicle table. |
Code Description 1 Pedestrian 2 Driver (of V-type 1-9 17 60-63 70-71) 3 Passenger (of V-type 1-9 17 60-63 70-71) 4 Motorcyclist 5 Pillion Passenger 6 Bicyclist (incl. passengers) 7 Other driver (V-type 14-16 99) 8 Other passenger (V-type 14-16 99) 9 Not known |
| LICENCE_STATE |
Licence State |
CHAR(1) |
This is a character field indicates the state of issue of the person s driver license. This field cannot contain NULL values. |
A Australian Capital Territory B Commonwealth D Northern Territory N New South Wales O Overseas Q Queensland S South Australia T Tasmania V Victoria W Western Australia Z Not known _ Not available (Blank value entered) |
| TAKEN_HOSPITAL |
Taken to hospital |
CHAR(1) |
This is a character field indicates whether or not the person was taken to hospital. This field cannot contain NULL values. |
Y Yes N No _ Not Known |
| EJECTED_CODE |
Ejected Code |
CHAR(1) |
This is a character field indicates whether or not the person was ejected or thrown out of the vehicle. This field cannot contain NULL values. |
Code Description 0 Not applicable 1 Total ejected 2 Partially ejected 3 Partial ejection involving extraction _ Not known |
