| Attributes | [{"attribute_display_order_id": 1, "db_format": "CHAR(12)", "db_name": "ACCIDENT_NO", "definition": "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.", "fixed_values": "", "id": "7290", "name": "Accident Number", "ref_number": "AT-7290"}, {"attribute_display_order_id": 2, "db_format": "CHAR(2)", "db_name": "PERSON_ID", "definition": "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.", "fixed_values": "", "id": "7299", "name": "Person ID", "ref_number": "AT-7299"}, {"attribute_display_order_id": 3, "db_format": "CHAR(1)", "db_name": "VEHICLE_ID", "definition": "VEHCILE_ID is a character field that uniquely identifies each vehicle involved in the accident. Vehicles have a letter value assigned to them", "fixed_values": "", "id": "7298", "name": "Vehicle ID", "ref_number": "AT-7298"}, {"attribute_display_order_id": 4, "db_format": "CHAR(1)", "db_name": "SEX", "definition": "This indicates the driver's sex and is a user editable field.", "fixed_values": "Code Description M Male F Female U Not known", "id": "7245", "name": "Sex", "ref_number": "AT-7245"}, {"attribute_display_order_id": 5, "db_format": "VARCHAR(7)", "db_name": "AGE_GROUP", "definition": "The age grouping of the person involved in the crash", "fixed_values": "", "id": "7287", "name": "Age Group", "ref_number": "AT-7287"}, {"attribute_display_order_id": 6, "db_format": "CHAR(1)", "db_name": "INJ_LEVEL", "definition": "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.", "fixed_values": "Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured", "id": "7293", "name": "Injury Level", "ref_number": "AT-7293"}, {"attribute_display_order_id": 7, "db_format": "VARCHAR(100)", "db_name": "INJ_LEVEL_DESC", "definition": "This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident", "fixed_values": "Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured", "id": "7288", "name": "Injury Level Desc", "ref_number": "AT-7288"}, {"attribute_display_order_id": 8, "db_format": "CHAR(2)", "db_name": "SEATING_POSITION", "definition": "This is a character field indicates where the person was located on the vehicle. This field cannot contain NULL values.", "fixed_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", "id": "7295", "name": "Seating Position", "ref_number": "AT-7295"}, {"attribute_display_order_id": 9, "db_format": "CHAR(1)", "db_name": "HELMET_BELT_WORN", "definition": "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.", "fixed_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", "id": "7265", "name": "Seat Belt/Helmet Worn", "ref_number": "AT-7265"}, {"attribute_display_order_id": 10, "db_format": "CHAR(2)", "db_name": "ROAD_USER_TYPE", "definition": "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.", "fixed_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", "id": "7297", "name": "Road User Type", "ref_number": "AT-7297"}, {"attribute_display_order_id": 11, "db_format": "VARCHAR(100)", "db_name": "ROAD_USER_TYPE_DESC", "definition": "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.", "fixed_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", "id": "7291", "name": "Road User Type Desc", "ref_number": "AT-7291"}, {"attribute_display_order_id": 12, "db_format": "CHAR(1)", "db_name": "LICENCE_STATE", "definition": "This is a character field indicates the state of issue of the person s driver license. This field cannot contain NULL values.", "fixed_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)", "id": "7289", "name": "Licence State", "ref_number": "AT-7289"}, {"attribute_display_order_id": 13, "db_format": "CHAR(1)", "db_name": "TAKEN_HOSPITAL", "definition": "This is a character field indicates whether or not the person was taken to hospital. This field cannot contain NULL values.", "fixed_values": "Y Yes N No _ Not Known", "id": "7294", "name": "Taken to hospital", "ref_number": "AT-7294"}, {"attribute_display_order_id": 14, "db_format": "CHAR(1)", "db_name": "EJECTED_CODE", "definition": "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.", "fixed_values": "Code Description 0 Not applicable 1 Total ejected 2 Partially ejected 3 Partial ejection involving extraction _ Not known", "id": "7292", "name": "Ejected Code", "ref_number": "AT-7292"}] |
|---|