Pavement Field Inspections
Field Name |
Caption |
Mask |
Description |
Field Type |
FD_COND_CD |
Condition |
nnn |
Condition |
Integer |
FD_COND_TY |
Condition Text |
50x |
Condition Text |
Text |
FD_CPRIOR |
Calculated Priority |
nnnnnnn.n |
Calculated Priority |
Double |
FD_CREW |
Inspection Crew |
30x |
Inspection Crew |
Text |
FD_CRT_BY |
Created By |
25x |
Created By |
Text |
FD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FD_CUR_PCI |
Current PCI |
nnn.n |
Current PCI |
Double |
FD_D_R |
Initial Distress PCI |
nnn.n |
Distress PCI Rating before WF Multiple |
Double |
FD_DATE |
Inventory Date |
mm/dd/yyyy |
Inventory Date |
Date/Time |
FD_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
FD_DWF |
Distress WF |
nnn.n |
Distress Weighting Factor |
Double |
FD_ESFV |
Environmental Factor |
nnnnn.nn |
Environmental Distress Factor |
Double |
FD_FSTREET |
From Street |
75x |
From Street |
Text |
FD_ID |
Field Rec # |
nnnnnnnn |
|
Long Integer |
FD_INMAP |
In Map |
|
|
Boolean |
FD_INSP_TM |
Inspection Time |
mm/dd/yyyy hh:mm am |
Inspection Time |
DateTime |
FD_IRI |
IRI Value |
nn.n |
International Roughness Index |
Double |
FD_LSFV |
Load Factor |
nnnnn.nn |
Load Distress Factor |
Double |
FD_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
FD_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
FD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FD_MST_REC |
Most Recent Insp. |
|
Most Recent Inspection Flag |
Boolean |
FD_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
FD_NE_CEST |
Replace Est NW |
nnnnn.n |
Replace Est. (L.F.) |
Double |
FD_NE_CONCD |
Curb Cond NW |
nnn |
Condition |
Integer |
FD_NE_CONTY |
Curb Cond Text NW |
25x |
Curb Condition Text |
Text |
FD_NE_DW_E |
DW Rpl Est NW |
nnn |
Replacement Est. |
Integer |
FD_NE_SW_E |
SW Rpl Est NW |
nnnnn.n |
Replacement Est. (L.F.) |
Double |
FD_NE_SWCCD |
Sdwlk Cond NW |
nnn |
Condition |
Integer |
FD_NE_SWCTY |
Sidwlk Cond Txt NW |
25x |
SW Condition Text |
Text |
FD_NLSFV |
Non-Load Factor |
nnnnn.nn |
Non-Load Distress Factor |
Double |
FD_OPCI |
Override PCI |
nnn.n |
Override PCI |
Double |
FD_OPCI_DT |
Override PCI Date |
mm/dd/yyyy |
Override PCI Date |
Date/Time |
FD_OSTREET |
On Street |
75x |
On Street |
Text |
FD_PATCH |
Patching Est (SY) |
nnnn. |
Patch. Est. (S.Y.) |
Double |
FD_PCI |
Inventory PCI |
nnn.n |
PCI - Sum of FD_PCI_D FD_PCI_S FD_PCI_R |
Double |
FD_PCI_D |
Final Distress PCI |
nnn.n |
Final Distress PCI after WF multiple |
Double |
FD_PCI_R |
Final Roughness PCI |
nnn.n |
Final Roughness PCI after WF multiple |
Double |
FD_PCI_S |
Final Structural PCI |
nnn.n |
Final Structural PCI after WF multiple |
Double |
FD_R_FD |
Roughness Final Deduct |
nn.n |
Roughness Final Deduct as of 674 no longer used |
Double |
FD_R_R |
Initial Roughness PCI |
nnn.n |
Roughness PCI Rating before WF multiple |
Double |
FD_RDF |
Roughness Factor |
nnnnn.nn |
Roughness Distress Factor |
Double |
FD_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FD_RS_ID |
Road Segment Rec # |
nnnnnnnn |
Long Integer |
|
FD_RWF |
Roughness WF |
nn.n |
Roughness Weighting Factor |
Double |
FD_S_FD |
Strength Final Deduct |
-nn.n |
Strength Final Deduct - as of 674 no longer used |
Double |
FD_S_R |
Initial Strength PCI |
nnn.n |
Structural PCI Rating before WF multiple |
Double |
FD_SB_ID |
Subsegment Rec # |
nnnnnnnn |
Long Integer |
|
FD_SDF |
Structural Factor |
nnnnn.nn |
Structural Distress Factor |
Double |
FD_SLOCK |
Strength Lock |
|
Strength Lock |
Boolean |
FD_STRE_CD |
Pavement Strength |
nnn |
Pavement Strength |
Integer |
FD_STRE_TY |
Pavement Strength Text |
25x |
Pavement Strength Type |
Text |
FD_STRINDX |
Structural Index |
nn.nn |
Structural Index |
Double |
FD_SURF_CD |
Pavement Type |
nnn |
Surface Type |
Integer |
FD_SURF_TY |
Pavement Type Text |
25x |
Surface Type Text |
Text |
FD_SUSER1 |
Shared User 1 |
30x |
Shared User 1 |
Text |
FD_SUSER2 |
Shared User 2 |
30x |
Shared User 2 |
Text |
FD_SUSER3 |
Shared User 3 |
30x |
Shared User 3 |
Text |
FD_SUSER4 |
Shared User 4 |
nnnnnnnnn.nn |
Shared User 4 |
Double |
FD_SUSER5 |
Shared User 5 |
nnnnnnnnn.nn |
Shared User 5 |
Double |
FD_SUSER6 |
Shared User 6 |
nnnnnnnnn.nn |
Shared User 6 |
Double |
FD_SUSER7 |
Shared User 7 |
|
Shared User 7 |
Boolean |
FD_SUSER8 |
Shared User 8 |
|
Shared User 8 |
Boolean |
FD_SUSER9 |
Shared User 9 |
|
Shared User 9 |
Boolean |
FD_SW_CEST |
Replace Est SE |
nnnnn.n |
Replace Est. (L.F.) |
Double |
FD_SW_CONCD |
Curb Cond SE |
nnn |
Condition |
Integer |
FD_SW_CONTY |
Curb Cond Text SE |
25x |
Curb Condition Text |
Text |
FD_SW_DW_E |
DW Rpl Est SE |
nnn |
Replacement Est. |
Integer |
FD_SW_SW_E |
SW Rpl Est SE |
nnnnn.n |
Replacement Est. (L.F.) |
Double |
FD_SW_SWCCD |
Sdwlk Cond SE |
nnn |
Condition |
Integer |
FD_SW_SWCTY |
Sidwlk Cond Txt SE |
25x |
SW Condition Text |
Text |
FD_SWF |
Strength WF |
nn.n |
Strength Weighting Factor |
Double |
FD_TRET_CD |
Surface Type |
nnn |
Surf. Treatment |
Integer |
FD_TRET_TY |
Surface Type Text |
50x |
Surf. Treatment Text |
Text |
FD_TSTREET |
To Street |
75x |
To Street |
Text |
FD_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
FD_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
FD_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
FD_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
FD_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
FD_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
FD_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 |
Double |
FD_USER5 |
User 5 |
30x |
User 5 |
Text |
FD_USER6 |
User 6 |
|
User 6 |
Boolean |
FD_USER7 |
User 7 |
|
User 7 |
Boolean |
FD_USER8 |
User 8 |
|
User 8 |
Boolean |
FD_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
FD_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
FD_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
FD_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
FD_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
FD_USER14 |
User 14 |
30x |
User 14 |
Text |
FD_USER15 |
User 15 |
30x |
User 15 |
Text |
FD_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
FD_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
FD_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
FD_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
FD_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
FD_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
FD_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
FD_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
FD_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
FD_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
FD_USER21 |
User 21 |
50x |
User 21 |
String |
FD_USER22 |
User 22 |
50x |
User 22 |
String |
FD_USER23 |
User 23 |
50x |
User 23 |
String |
FD_USER24 |
User 24 |
50x |
User 24 |
String |
FD_USER25 |
User 25 |
50x |
User 25 |
String |
FD_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
FD_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
FD_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
FD_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
FD_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
FD_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
FD_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
FD_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
FD_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
FD_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
FD_USER36 |
User 36 |
|
User 36 |
Boolean |
FD_USER37 |
User 37 |
|
User 37 |
Boolean |
FD_USER38 |
User 38 |
|
User 38 |
Boolean |
FD_USER39 |
User 39 |
|
User 39 |
Boolean |
FD_USER40 |
User 40 |
|
User 40 |
Boolean |
FD_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
FD_WR |
Weighted Rating |
nnnnnnnn.n |
Weighted Rating (Priority WF*(100-Current PCI)) |
Double |