| 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.\nFirst 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": "7215", "name": "ACCIDENT_NO", "ref_number": "AT-7215"}, {"attribute_display_order_id": 2, "db_format": "INTEGER(10)", "db_name": "EVENT_SEQ_NO", "definition": "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.", "fixed_values": "", "id": "7221", "name": "SEQUENCE", "ref_number": "AT-7221"}, {"attribute_display_order_id": 3, "db_format": "CHAR(1)", "db_name": "EVENT_TYPE", "definition": "EVENT_TYPE is a character field indicates type of incident event. This field cannot contain NULL values.", "fixed_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", "id": "7217", "name": "EVENT TYPE", "ref_number": "AT-7217"}, {"attribute_display_order_id": 4, "db_format": "CHAR(1)", "db_name": "VEHICLE_1_ID", "definition": "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.", "fixed_values": "", "id": "7219", "name": "FIRST PARTICIPANT VEHICLE ID", "ref_number": "AT-7219"}, {"attribute_display_order_id": 5, "db_format": "CHAR(1)", "db_name": "VEHICLE_1_COLL_PT", "definition": "VEHICLE_1_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_values": "", "id": "7216", "name": "POINT OF COLLISION 1", "ref_number": "AT-7216"}, {"attribute_display_order_id": 6, "db_format": "CHAR(1)", "db_name": "VEHICLE_2_ID", "definition": "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", "fixed_values": "", "id": "7222", "name": "SECOND PARTICIPANT VEHICLE ID", "ref_number": "AT-7222"}, {"attribute_display_order_id": 7, "db_format": "CHAR(1)", "db_name": "VEHICLE_2_COLL_PT", "definition": "VEHICLE_2_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_values": "", "id": "7213", "name": "POINT OF COLLISION 2", "ref_number": "AT-7213"}, {"attribute_display_order_id": 8, "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": "7218", "name": "PERSON_ID", "ref_number": "AT-7218"}, {"attribute_display_order_id": 9, "db_format": "CHAR(2)", "db_name": "OBJECT_TYPE", "definition": "OBJECT_TYPE is a character field that identifies object involved in the specific accident event. This field cannot contain NULL values.", "fixed_values": "1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island", "id": "7214", "name": "OBJECT TYPE", "ref_number": "AT-7214"}, {"db_format": "VARCHAR(100)", "db_name": "EVENT_TYPE_DESC", "definition": "Is a descriptive field that indicates type of incident event. This field cannot contain NULL values.", "fixed_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", "id": "7473", "name": "EVENT TYPE DESC", "ref_number": "AT-7473"}, {"db_format": "VARCHAR(100)", "db_name": "VEHICLE 2 COLL PT DESC", "definition": "It's a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_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", "id": "7474", "name": "VEHICLE 2 COLL PT DESC", "ref_number": "AT-7474"}, {"db_format": "VARCHAR(100)", "db_name": "VEHICLE 1 COLL PT DESC", "definition": "Its a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values.", "fixed_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", "id": "7475", "name": "VEHICLE 1 COLL PT DESC", "ref_number": "AT-7475"}, {"db_format": "VARCHAR(100)", "db_name": "OBJECT_TYPE_DESC", "definition": "It's a descriptive field that identifies object involved in the specific accident event. This field cannot contain NULL values.", "fixed_values": "1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island", "id": "7476", "name": "OBJECT TYPE DESC", "ref_number": "AT-7476"}] |
|---|