Intersection Network Table
Field Name |
Caption |
Mask |
Description |
Field Type |
IN_ADT_DT |
TV ADT Date |
mm/dd/yyyy |
Count Date |
Date/Time |
IN_AGR |
Ann. Growth Rate |
-nnn.nn |
Calculated Annual Growth Rate |
Double |
IN_ATT_X |
Attri X Offset (ft) |
-nnnn.nn |
Attri X Offset (ft) |
Double |
IN_ATT_Y |
Attri Y Offset (ft) |
-nnnn.nn |
Attri Y Offset (ft) |
Double |
IN_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
IN_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
IN_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
IN_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
IN_CITY_CD |
City/Facility |
nnn |
City/Facility |
Integer |
IN_CITY_TY |
City/Facility Text |
50x |
City/Facility Text |
Text |
IN_COF |
Consequence of Failure |
nnnn. |
Consequence of Failure |
Double |
IN_COM_NID |
Intersection ID |
20x |
Node ID |
Text |
IN_COMM |
Comments |
|
Comments |
Long Integer |
IN_CRT_BY |
Created By |
25x |
Created By |
Text |
IN_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
IN_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
IN_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
IN_IFREQ |
Inspection Freq |
|
Inspection Freq |
Small Integer |
IN_IFRQ_CD |
Inspection Freq Units |
|
Inspection Freq Units |
Small Integer |
IN_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
IN_GPS |
GPS Flag |
|
GPS Flag |
Boolean |
IN_IADT |
ADT Volume |
nnnnnnnn |
ADT Volume |
Long Integer |
IN_IADT_DT |
ADT Date |
mm/dd/yyyy |
ADT Date |
Date/Time |
IN_IMG_FLG |
|
|
Image Available |
Boolean |
IN_INMAP |
In Map? |
|
|
Boolean |
IN_INSP_DT |
Inspection Date |
mm/dd/yyyy hh:mm am |
Inspection Date |
DateTime |
IN_LOCK |
Intersection Lock |
|
Intersection Lock |
Boolean |
IN_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
IN_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
IN_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
IN_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
IN_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
IN_MOV_FLG |
|
|
Movie Available |
Boolean |
IN_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
IN_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
IN_NAME |
Intersection Name |
100x |
Intersection Name |
Text |
IN_NID |
Intersection Rec # |
nnnnnnnn |
Internal Node ID |
Long Integer |
IN_NINSP_DT |
Next Inspection Date: |
mm/dd/yyyy hh:mm am |
Next Inspection Date: |
DateTime |
IN_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
IN_OCOND_CD |
Overall Cond |
|
Overall Cond |
Small Integer |
IN_OCOND_TY |
Overall Cond Text |
25x |
Overall Cond Text |
String |
IN_POF |
Probability of Failure |
nnn.nn |
Probability of Failure |
Double |
IN_PVALUE |
Present Value |
nnnnnnnnn.nn |
Present Value |
Double |
IN_RCOST |
Replacement Cost |
nnnnn.nn |
Replacement Cost |
Double |
IN_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
IN_RISK |
Risk |
nnnn. |
Risk - COF * POF |
Double |
IN_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
IN_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
IN_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
IN_SGNL_CD |
Traffic Control |
nnn |
Traffic Control |
Integer |
IN_SGNL_TY |
Traffic Control Text |
25x |
Traffic Control Text |
Text |
IN_ST1_DIR |
Street 1 Name-Direct |
2x |
Street 1 Name-Direct |
Text |
IN_ST1_PT |
Street 1 Prefix Type |
5x |
Intersection Prefix:Street 1 Name-Prefix Type |
Text |
IN_ST1_SFX |
Street 1 Name-Suffix |
5x |
Street 1 Name-Suffix |
Text |
IN_ST1_SID |
Street Name 1 Rec # |
nnnnnnnn |
Street 1 ID (Street |
Long Integer |
IN_ST1_STR |
Street 1 Name |
50x |
Street 1 Name-Name |
Text |
IN_ST1_TY |
Street 1 Name-Type |
5x |
Street 1 Name-Type |
Text |
IN_ST2_DIR |
Street 2 Name-Direct |
2x |
Street 2 Name-Direct |
Text |
IN_ST2_PT |
Street 2 Prefix Type |
5x |
Street 2 Name-Prefix Type |
Text |
IN_ST2_SFX |
Street 2 Name-Suffix |
5x |
Street 2 Name-Suffix |
Text |
IN_ST2_SID |
Street Name 2 Rec # |
nnnnnnnn |
Street 2 ID (Street |
Long Integer |
IN_ST2_STR |
Street 2 Name |
50x |
Street 2 Name-Name |
Text |
IN_ST2_TY |
Street 2 Name-Type |
5x |
Street 2 Name-Type |
Text |
IN_ST3_DIR |
Street 3 Name-Direct |
2x |
Street 3 Name-Direct |
Text |
IN_ST3_PT |
Street 3 Prefix Type |
5x |
Street 3 Name-Prefix Type |
Text |
IN_ST3_SFX |
Street 3 Name-Suffix |
5x |
Street 3 Name-Suffix |
Text |
IN_ST3_SID |
Street Name 3 Rec # |
nnnnnnnn |
Street 3 ID (Street |
Long Integer |
IN_ST3_STR |
Street 3 Name |
50x |
Street 3 Name-Name |
Text |
IN_ST3_TY |
Street 3 Name-Type |
5x |
Street 3 Name-Type |
Text |
IN_ST4_DIR |
Street 4 Name-Direct |
2x |
Street 4 Name-Direct |
Text |
IN_ST4_PT |
Street 4 Prefix Type |
5x |
Street 4 Name-Prefix Type |
Text |
IN_ST4_SFX |
Street 4 Name-Suffix |
5x |
Street 4 Name-Suffix |
Text |
IN_ST4_SID |
Street Name 4 Rec # |
nnnnnnnn |
Street 4 ID (Street |
Long Integer |
IN_ST4_STR |
Street 4 Name |
50x |
Street 4 Name-Name |
Text |
IN_ST4_TY |
Street 4 Name-Type |
5x |
Street 4 Name-Type |
Text |
IN_STAT_CD |
Status |
nnn |
Status |
Integer |
IN_STAT_TY |
Status Text |
25x |
Status Text |
Text |
IN_STYPE_CD |
Subtype |
nnn |
|
Integer |
IN_STYPE_TY |
Subtype Text |
25x |
|
Text |
IN_TOT_ADT |
Total ADT |
nnnnnnnn |
Total ADT |
Long Integer |
IN_TYPE_CD |
Intersection Type |
nnn |
Intersection Type |
Integer |
IN_TYPE_TY |
Intersec. Type-Text |
25x |
Intersec. Type-Text |
Text |
IN_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
IN_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
IN_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
IN_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
IN_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
IN_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
IN_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 |
Double |
IN_USER5 |
User 5 |
30x |
User 5 |
Text |
IN_USER6 |
User 6 |
|
User 6 |
Boolean |
IN_USER7 |
User 7 |
|
User 7 |
Boolean |
IN_USER8 |
User 8 |
|
User 8 |
Boolean |
IN_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
IN_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
IN_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
IN_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
IN_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
IN_USER14 |
User 14 |
30x |
User 14 |
Text |
IN_USER15 |
User 15 |
30x |
User 15 |
Text |
IN_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
IN_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
IN_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
IN_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
IN_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
IN_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
IN_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
IN_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
IN_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
IN_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
IN_USER21 |
User 21 |
50x |
User 21 |
String |
IN_USER22 |
User 22 |
50x |
User 22 |
String |
IN_USER23 |
User 23 |
50x |
User 23 |
String |
IN_USER24 |
User 24 |
50x |
User 24 |
String |
IN_USER25 |
User 25 |
50x |
User 25 |
String |
IN_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
IN_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
IN_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
IN_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
IN_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
IN_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
IN_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
IN_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
IN_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
IN_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
IN_USER36 |
User 36 |
|
User 36 |
Boolean |
IN_USER37 |
User 37 |
|
User 37 |
Boolean |
IN_USER38 |
User 38 |
|
User 38 |
Boolean |
IN_USER39 |
User 39 |
|
User 39 |
Boolean |
IN_USER40 |
User 40 |
|
User 40 |
Boolean |
IN_WO_COMM |
WO Comment |
255x |
This short comment gets copied to work orders |
Text |
IN_X_COORD |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
IN_Y_COORD |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |