Accident Data Table
Field Name |
Caption |
Mask |
Description |
Field Type |
AC_AC_CD |
Accident Class |
nnn |
Accident Class:Accident Class - Code |
Integer |
AC_AC_TY |
Accident Class Text |
25x |
Accident Class Text:Accident Class - Type |
Text |
AC_ACC_FLG |
Invalid Accident Typ |
|
Invalid Collision For Description Flag |
Boolean |
AC_ACCD_DT |
Date |
mm/dd/yyyy |
Accident Date |
Date/Time |
AC_AD_CD |
Coll. Diagram |
nnn |
Accident Assign:Accident Diagram Assignment - Code |
Integer |
AC_AD_TY |
Coll. Diagram Text |
25x |
Accident Assign Text:Accident Diagram Assignment - Type |
Text |
AC_AF1_CD |
Additional Factor 1 |
nnn |
Additional Factor 1 |
Integer |
AC_AF1_TY |
Additional Factor 1 Text |
25x |
Additional Factor 1 Text |
String |
AC_AF2_CD |
Additional Factor 2 |
nnn |
Additional Factor 2 |
Integer |
AC_AF2_TY |
Additional Factor 2 Text |
25x |
Additional Factor 2 Text |
String |
AC_AF3_CD |
Additional Factor 3 |
nnn |
Additional Factor 3 |
Integer |
AC_AF3_TY |
Additional Factor 3 Text |
25x |
Additional Factor 3 Text |
String |
AC_AF4_CD |
Additional Factor 4 |
nnn |
Additional Factor 4 |
Integer |
AC_AF4_TY |
Additional Factor 4 Text |
25x |
Additional Factor 4 Text |
String |
AC_AF5_CD |
Additional Factor 5 |
nnn |
Additional Factor 5 |
Integer |
AC_AF5_TY |
Additional Factor 5 Text |
25x |
Additional Factor 5 Text |
String |
AC_AF6_CD |
Additional Factor 6 |
nnn |
Additional Factor 6 |
Integer |
AC_AF6_TY |
Additional Factor 6 Text |
25x |
Additional Factor 6 Text |
String |
AC_AF7_CD |
Additional Factor 7 |
nnn |
Additional Factor 7 |
Integer |
AC_AF7_TY |
Additional Factor 7 Text |
25x |
Additional Factor 7 Text |
String |
AC_AF8_CD |
Additional Factor 8 |
nnn |
Additional Factor 8 |
Integer |
AC_AF8_TY |
Additional Factor 8 Text |
25x |
Additional Factor 8 Text |
String |
AC_AL_CD |
Accident Loc. |
nnn |
Accident Location |
Integer |
AC_AL_TY |
Accident Loc. Text |
30x |
Accident Location Text |
Text |
AC_AR_CD |
Arrived Day Code |
nnn |
Day Arrived Code |
7 |
AC_AR_TY |
Arrived Day |
3x |
Day Arrived |
Text |
AC_ARRV_TM |
Time Arrived |
hh:mm am |
Time Arrived |
Date/Time |
AC_BR_CD |
|
10x |
Default Category Code |
Text |
AC_BR_TY |
|
60x |
Default Category Text |
Text |
AC_CASE_NO |
Local Case # |
24x |
Local Case # |
Text |
AC_CITY_CD |
City |
nnn |
City |
Integer |
AC_CITY_TY |
City Text |
50x |
City Text |
Text |
AC_COM_ID |
Segment ID |
20x |
Street Segment Common ID |
Text |
AC_COM_NID |
Node ID |
20x |
Intersection Common ID |
Text |
AC_COUNTY |
County |
15x |
County |
Text |
AC_CRT_BY |
Created By |
25x |
Created By |
Text |
AC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AC_CS |
Curr Station |
nnnnnnnn.nnn |
Current Stationing |
Double |
AC_CZ_CD |
On Const/Maint |
nnn |
On Const/Maint Zone:On Road Const/Maint. Zone - Code |
Integer |
AC_CZ_TY |
On Const/Maint Text |
25x |
On Const/Maint Zone Text:On Road Const/Maint. Zone - Type |
Text |
AC_CZ2_CD |
At Const/Maint |
nnn |
At Const/Maint Zone:At Road Const/Maint. Zone - Code |
Integer |
AC_CZ2_TY |
At Const/Maint Text |
25x |
At Const/Maint Zone Text:At Road Const/Maint. Zone - Type |
Text |
AC_DAY_CD |
Occured Day Code |
nnn |
Occurred Day Code |
7 |
AC_DAY_TY |
Occured Day |
3x |
Day Occurred |
Text |
AC_DGR_LOC |
Coll. Diag. Loc. |
nnn |
Accident Diagram Location |
Integer |
AC_DIR_CD |
Direction |
nnn |
Direction Code |
7 |
AC_DIR_TY |
Direction Text |
2x |
Direction |
Text |
AC_DIST |
Distance |
nnnn |
Distance |
Integer |
AC_DIST_CD |
Dist Units |
nnn |
Units Code |
7 |
AC_DIST_TY |
Dist Units Text |
2x |
Distance - Type (Ft/Mi) |
Text |
AC_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
AC_FDIR1_CD |
Forced V1 Dir Code |
nnn |
Forced Direction Vehicle 1 |
Integer |
AC_FDIR1_TY |
Forced V1 Direction |
2x |
Forced Direction Vehicle 1 |
Text |
AC_FDIR2_CD |
Forced V2 Dir Code |
nnn |
Forced Direction Vehicle 2 |
Integer |
AC_FDIR2_TY |
Forced V2 Direction |
2x |
Forced Direction Vehicle 2 |
Text |
AC_FO_CD |
Fixed Object |
nnn |
Fixed Object:Fixed Object Type - Code |
Integer |
AC_FO_TY |
Fixed Object Text |
25x |
Fixed Object Text:Fixed Object Type - Type |
Text |
AC_FOR_FLG |
Inval Dir For Forced |
|
Invalid Directions For Forced Valid Flag |
Boolean |
AC_FST_SID |
Street Name Rec # |
nnnnnnnn |
From Street - Street ID (Street Name List) |
Long Integer |
AC_FSTR_PT |
From Street Prefix |
5x |
From Street Prefix |
Text |
AC_FSTR_SL |
At Street Speed Lmt. |
nn |
From Street Speed Limit |
Integer |
AC_FSTR_TY |
At Street Type |
4x |
From Street Type |
Text |
AC_FSTRDIR |
At/Cross Str |
2x |
From Street Dir. |
Text |
AC_FSTRSFX |
At Street Sfx. |
5x |
From Street Suffix |
Text |
AC_FSTRSTR |
At Street Name |
50x |
From Street Name |
Text |
AC_FSTRSTR |
At Street Name |
50x |
From Street Name |
Text |
AC_HANDR |
Hit and Run |
|
Hit and Run |
Boolean |
AC_ID |
Accident Rec # |
nnnnnnnn |
Unique Accident ID (AutoNumber) |
Long Integer |
AC_IN_NID |
Intersection Rec # |
nnnnnnnn |
Long Integer |
|
AC_INMAP |
In Map? |
|
|
Boolean |
AC_INT_FLG |
Invalid Node |
|
Invalid Intersection Flag |
Boolean |
AC_INV_DPT |
Investigating Dept. |
25x |
Department |
Text |
AC_INV_OFC |
Inv. Officer/Badge # |
20x |
Officer |
Text |
AC_KDT_CZ |
Construct. Zone |
|
Construction Zone |
Boolean |
AC_KDT_PDO |
Property Damage |
|
Property Damage |
Boolean |
AC_LGHT_CD |
Light |
nnn |
Light:Light - Code |
Integer |
AC_LGHT_TY |
Light Text |
25x |
Light Text: Light - Type |
Text |
AC_LOC_CD |
Location |
nnn |
Loc. Assign |
Integer |
AC_LOC_TY |
Location Text |
25x |
Loc. Assign Text |
Text |
AC_MILEPST |
Milepost |
nnnn.n |
Milepost |
Double |
AC_MOD_BY |
Last Modified By |
25x |
Last user to modify the record |
Text |
AC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Date record last modified |
Date/Time |
AC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AC_NOT_TM |
Time Notified |
hh:mm am |
Time Notified |
Date/Time |
AC_NT_CD |
Notified Day Code |
nnn |
Notified Day Code |
7 |
AC_NT_TY |
Notified Day |
3x |
Day Notified |
Text |
AC_OBJ_DAM |
Object Damaged |
50x |
Object Damaged |
Text |
AC_OBJ_OWN |
Object Owner |
50x |
Object Owner |
Text |
AC_OCCR_TM |
Time Occured |
hh:mm am |
Time Notified |
Date/Time |
AC_OMV_CD |
Collision |
nnn |
Collision with OMV:Collision with OMV - Code |
Integer |
AC_OMV_TY |
Collision Text |
25x |
Collision w OMV Text:Collision with OMV - Type |
Text |
AC_OS |
Org. Station |
nnnnnnnn.nnn |
Original Stationing |
Double |
AC_PHOT_BY |
Photos By |
7x |
Photos By |
Text |
AC_RC_CD |
On Rd. Charact. |
nnn |
On Road Charact:On Road Characteristics - Code |
Integer |
AC_RC_TY |
On Rd. Charact. Text |
25x |
On Road Charact Text:On Road Characteristics - Type |
Text |
AC_RC2_CD |
At Rd. Charact. |
nnn |
At Road Charact:At Road Characteristics - Code |
Integer |
AC_RC2_TY |
At Rd. Charact. Text |
25x |
At Road Charact Text:At Road Characteristics - Type |
Text |
AC_REV_BY |
Reviewed By |
12x |
Reviewed By |
Text |
AC_RH_ID |
Road Rec # |
nnnnnnnn |
Long Integer |
|
AC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
AC_RP |
Ref Post |
nnnnnnnn.nnn |
Reference Post |
Double |
AC_RSF1_CD |
Special Features 1 |
nnn |
Road Special Features 1 |
Integer |
AC_RSF1_TY |
Special Features 1 Text |
25x |
Road Special Features 1 Text |
Text |
AC_RSF2_CD |
Special Features 2 |
nnn |
Road Special Features 2 |
Integer |
AC_RSF2_TY |
Special Features 2 Text |
25x |
Road Special Features 2 Text |
Text |
AC_RSF3_CD |
Special Features 3 |
nnn |
Road Special Features 3 |
Integer |
AC_RSF3_TY |
Special Features 3 Text |
25x |
Road Special Features 3 Text |
Text |
AC_SC_CD |
On Surface Cond. |
nnn |
On Surface Cond:On Surface Condition - Code |
Integer |
AC_SC_TY |
On Surface Cond Text |
25x |
On Surface Cond Text:On Surface Condition - Type |
Text |
AC_SC2_CD |
At Surface Cond. |
nnn |
At Surface Cond:At Surface Condition - Code |
Integer |
AC_SC2_TY |
At Surface Cond Text |
25x |
At Surface Cond Text:At Surface Condition - Type |
Text |
AC_SEV_CD |
Severity |
nnn |
Severity |
Integer |
AC_SEV_TY |
Severity Text |
25x |
Severity Text |
Text |
AC_SN_ID |
Segment Rec # |
nnnnnnnn |
Long Integer |
|
AC_ST_CD |
On Surface Type |
nnn |
On Surface:On Surface Type - Code |
Integer |
AC_ST_TY |
On Surface Type Text |
25x |
On Surface Text:On Surface Type - Type |
Text |
AC_ST2_CD |
At Surface Type |
nnn |
At Surface:At Surface Type - Code |
Integer |
AC_ST2_TY |
At Surface Type Text |
25x |
At Surface Text:At Surface Type - Type |
Text |
AC_STR_DIR |
On Street |
2x |
On Street Direction |
Text |
AC_STR_FLG |
Invalid Segment |
|
Invalid Street Segment Flag |
Boolean |
AC_STR_PT |
On Street Prefix |
5x |
On Street Prefix |
Text |
AC_STR_SFX |
On Street Sfx. |
5x |
On Street Suffix |
Text |
AC_STR_SID |
Street Name Rec # |
nnnnnnnn |
On Street - Link to STREETLIST |
Long Integer |
AC_STR_SL |
On Street Speed Lmt. |
nn |
On Street Speed Limit |
Integer |
AC_STR_STR |
On Street Name |
50x |
On Street Name |
Text |
AC_STR_STR |
On Street Name |
50x |
On Street Name |
Text |
AC_STR_TY |
On Street Type |
4x |
On Street Type |
Text |
AC_TC_FUN1 |
TC Functional 1 |
|
Traffic Controls OK or Non Functional |
Boolean |
AC_TC_FUN2 |
TC Functional 2 |
|
Traffic Controls OK or Non Functional |
Boolean |
AC_TC_FUN3 |
TC Functional 3 |
|
Traffic Controls OK or Non Functional |
Boolean |
AC_TC_FUN4 |
TC Functional 4 |
|
Traffic Controls OK or Non Functional |
Boolean |
AC_TC_FUN5 |
TC Functional 5 |
|
Traffic Controls OK or Non Functional |
Boolean |
AC_TC1_CD |
Traffic Control 1 |
nnn |
Traffic Controls - Code |
Integer |
AC_TC1_TY |
Traffic Control 1 Text |
25x |
Traffic Controls - Type |
Text |
AC_TC2_CD |
Traffic Control 2 |
nnn |
Traffic Controls - Code |
Integer |
AC_TC2_TY |
Traffic Control 2 Text |
25x |
Traffic Controls - Type |
Text |
AC_TC3_CD |
Traffic Control 3 |
nnn |
Traffic Controls - Code |
Integer |
AC_TC3_TY |
Traffic Control 3 Text |
25x |
Traffic Controls - Type |
Text |
AC_TC4_CD |
Traffic Control 4 |
nnn |
Traffic Controls - Code |
Integer |
AC_TC4_TY |
Traffic Control 4 Text |
25x |
Traffic Controls - Type |
Text |
AC_TC5_CD |
Traffic Control 5 |
nnn |
Traffic Controls - Code |
Integer |
AC_TC5_TY |
Traffic Control 5 Text |
25x |
Traffic Controls - Type |
Text |
AC_TCLC1 |
TC On Street 1 |
|
Traffic Controls On or At Road |
Boolean |
AC_TCLC2 |
TC On Street 2 |
|
Traffic Controls On or At Road |
Boolean |
AC_TCLC3 |
TC On Street 3 |
|
Traffic Controls On or At Road |
Boolean |
AC_TCLC4 |
TC On Street 4 |
|
Traffic Controls On or At Road |
Boolean |
AC_TCLC5 |
TC On Street 5 |
|
Traffic Controls On or At Road |
Boolean |
AC_UNT_TOT |
# of Units |
nnn |
Number of Units:Number of units involved |
Integer |
AC_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
AC_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
AC_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
AC_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
AC_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
AC_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
AC_USER4 |
User 4 |
30x |
User 4 |
Text |
AC_USER5 |
User 5 |
30x |
User 5 |
Text |
AC_USER6 |
User 6 |
30x |
User 6 |
Text |
AC_USER7 |
User 7 |
nnnnnnnn.nn |
User 7 |
Double |
AC_USER8 |
User 8 |
nnnnnnnn.nn |
User 8 |
Double |
AC_USER9 |
User 9 |
nnnnnnnn.nn |
User 9 |
Double |
AC_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
AC_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
AC_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
AC_USER13 |
User 13 |
|
User 13 |
Boolean |
AC_USER14 |
User 14 |
|
User 14 |
Boolean |
AC_USER15 |
User 15 |
|
User 15 |
Boolean |
AC_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
AC_USER16TY |
User 16 Text |
25x |
User 16 Text |
String |
AC_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
AC_USER17TY |
User 17 Text |
25x |
User 17 Text |
String |
AC_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
AC_USER18TY |
User 18 Text |
25x |
User 18 Text |
String |
AC_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
AC_USER19TY |
User 19 Text |
25x |
User 19 Text |
String |
AC_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
AC_USER20TY |
User 20 Text |
25x |
User 20 Text |
String |
AC_USER21CD |
User 21 |
nnn |
User 21 |
Integer |
AC_USER21TY |
User 21 Text |
25x |
User 21 Text |
String |
AC_USER22 |
User 22 |
50x |
User 22 |
String |
AC_USER23 |
User 23 |
50x |
User 23 |
String |
AC_USER24 |
User 24 |
50x |
User 24 |
String |
AC_USER25 |
User 25 |
50x |
User 25 |
String |
AC_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
AC_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
AC_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
AC_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
AC_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
AC_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
AC_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
AC_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
AC_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
AC_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
AC_USER36 |
User 36 |
|
User 36 |
Boolean |
AC_USER37 |
User 37 |
|
User 37 |
Boolean |
AC_USER38 |
User 38 |
|
User 38 |
Boolean |
AC_USER39 |
User 39 |
|
User 39 |
Boolean |
AC_USER40 |
User 40 |
|
User 40 |
Boolean |
AC_USER41CD |
User 41 |
nnn |
User 41 |
Integer |
AC_USER41TY |
User 41 Text |
50x |
User 41 Text |
String |
AC_USER42CD |
User 42 |
nnn |
User 42 |
Integer |
AC_USER42TY |
User 42 Text |
50x |
User 42 Text |
String |
AC_USER43CD |
User 43 |
nnn |
User 43 |
Integer |
AC_USER43TY |
User 43 Text |
50x |
User 43 Text |
String |
AC_USER44CD |
User 44 |
nnn |
User 44 |
Integer |
AC_USER44TY |
User 44 Text |
50x |
User 44 Text |
String |
AC_USER45CD |
User 45 |
nnn |
User 45 |
Integer |
AC_USER45TY |
User 45 Text |
50x |
User 45 Text |
String |
AC_USER46 |
User 46 |
50x |
User 46 |
String |
AC_VALD_CD |
Validation |
nnn |
Validation Code |
Integer |
AC_VALD_TY |
Validation Text |
25x |
Validation Type |
Text |
AC_VI_CD |
|
4x |
Visible ID Code |
Text |
AC_VI_ID |
|
4x |
Visible ID |
Text |
AC_WTHR_CD |
Weather |
nnn |
Weather:Weather - Code |
Integer |
AC_WTHR_TY |
Weather Text |
25x |
Weather Text:Weather - Type |
Text |
AC_X_COORD |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
AC_XC |
X Coord |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
AC_Y_COORD |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |
AC_YC |
Y Coord |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |