Subsegment Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
SB_AAREA |
Additional Area |
-nnnnnn.nn |
Additional Area |
Double |
SB_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
SB_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
SB_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
SB_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
SB_C_D_S |
CDS Diameter |
nnn.n |
CDS Diam. |
Double |
SB_CBR_DT |
CBR Date |
mm/dd/yyyy |
CBR Date (or Date of Subsurface Strength Testing) |
Date/Time |
SB_CODE |
Subsegment Code |
30x |
Unique Subsegment Code |
Text |
SB_COND_CD |
Condition |
nnn |
Condition |
Integer |
SB_COND_TY |
Condition Text |
50x |
Condition Text |
Text |
SB_CPCI |
Last Control PCI |
nnn.n |
Last Controlling PCI |
Double |
SB_CPRIOR |
Calculated Priority |
nnnnnnn.n |
Calculated Priority |
Double |
SB_CRT_BY |
Created By |
25x |
Created By |
Text |
SB_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
SB_CUR_PCI |
Current PCI |
nnn.n |
Current PCI |
Double |
SB_D_R |
Initial Distress PCI |
nnn.n |
Initial Distress PCI |
Double |
SB_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
SB_EB_CD |
Base Course Type |
nnn |
Base Course Type |
Integer |
SB_EB_THIC |
Base Thickness |
nnn. |
Base Thickness |
Double |
SB_EB_TY |
Base Course Text |
25x |
Base Course Text |
Text |
SB_END |
Ending Desc |
100x |
Ending Point |
Text |
SB_ENDPT |
End Station |
nnnnn.n |
End Station |
Double |
SB_ES_CD |
Surf. Course Type |
nnn |
Surf. Course Type |
Integer |
SB_ES_THIC |
Surf. Thickness |
nnn. |
Surf. Course Thick. |
Double |
SB_ES_TY |
Surf. Course Text |
25x |
Surf. Course Text |
Text |
SB_ESFV |
Envir Factor |
nnnnn.nn |
Environmental Stress Factor |
Double |
SB_FPERC |
From Percentage |
nnn.n |
From Percentage |
Double |
SB_FSTREET |
From Street |
75x |
From Street |
Text |
SB_GRP_NO |
Group Number |
25x |
Group Number |
Text |
SB_ID |
Subsegment Rec # |
nnnnnnnn |
Internal Subseg ID |
Long Integer |
SB_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
SB_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
SB_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
SB_INFO_CD |
Info. Source |
nnn |
Information Source |
Integer |
SB_INFO_DT |
Info. Date |
mm/dd/yyyy |
Date of Information |
Date/Time |
SB_INFO_TY |
Info. Source Text |
25x |
Inform. Source Text |
Text |
SB_INMAP |
In Map? |
|
|
Boolean |
SB_INSP_DT |
Last Date |
mm/dd/yyyy |
Last Date |
Date/Time |
SB_LANES |
# of Lanes |
nnn |
# Lanes |
Integer |
SB_LENGTH |
Length |
nnnnn.n |
Length |
Double |
SB_LSFV |
Load Factor |
nnnnn.nn |
Load Stress Factor |
Double |
SB_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
SB_MED_WID |
Median Width |
nnn.n |
Median Width |
Double |
SB_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
SB_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
SB_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
SB_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
SB_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
SB_NEXT_DT |
Next Inspection |
mm/dd/yyyy hh:mm am |
Next Inspection |
DateTime |
SB_NE_C_CD |
Curb/Gutter Type NW |
nnn |
Curb/Gutter Type |
Integer |
SB_NE_C_H |
Curb Height NW |
nnn.n |
Curb Height (in.) |
Double |
SB_NE_C_TY |
Curb/Gutter Type NW Text |
25x |
Curb/Gutter Type Txt |
Text |
SB_NE_C_W |
Curb Width NW |
nnn.n |
Width (in.) |
Double |
SB_NE_CLIP |
Depth Above Lip NW |
nnn.n |
Inches Above Lip |
Double |
SB_NE_D_CD |
Drainage Type NW |
nnn |
Drainage Type |
Integer |
SB_NE_D_TY |
Drainage Type NW Text |
25x |
Drainage Type Text |
Text |
SB_NE_DW_N |
# of Units NW |
nnn |
Number of Units |
Integer |
SB_NE_IN_CD |
Inlets Present NW |
nnn |
Inlets Present |
Integer |
SB_NE_IN_TY |
Inlets Present NW Text |
25x |
Inlets Present Text |
Text |
SB_NE_OV_CD |
Curb Overlaid NW |
nnn |
Overlaid |
Integer |
SB_NE_OV_TY |
Curb Overlaid NW Text |
25x |
Overlaid Text |
Text |
SB_NE_SW_CD |
Sidewalk Type NW |
nnn |
Sidewalk Type |
Integer |
SB_NE_SW_L |
Sidewalk Length NW |
nnnn.n |
N/W Sidewalk Length |
Double |
SB_NE_SW_TY |
Sidewalk Type NW Text |
25x |
Sidewalk Type Text |
Text |
SB_NE_SW_W |
Sidewalk Width NW |
nnn.n |
Width |
Double |
SB_NE_SWD_CD |
Dist from Curb NW |
nnn |
Distance From Curb |
Integer |
SB_NE_SWD_TY |
Dist from Curb NW Text |
25x |
Dist From Curb Text |
Text |
SB_NLSFV |
Non-Load Factor |
nnnnn.nn |
Non-Load Stress Factor |
Double |
SB_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
SB_OB_CD |
Orig. Base Type |
nnn |
Orig. Base Type |
Integer |
SB_OB_THIC |
Base Thickness |
nnn. |
Orig. Base Thickness |
Double |
SB_OB_TY |
Orig. Base Type Text |
25x |
Orig. Base Type Text |
Text |
SB_OPCI |
Override PCI |
nnn.n |
Override PCI |
Double |
SB_OPCI_DT |
Override PCI Date |
mm/dd/yyyy |
Override PCI Date |
Date/Time |
SB_ORDER |
Order Number |
nnn |
Order Number |
Integer |
SB_OS_CD |
Orig. Surf. Type |
nnn |
Orig. Surface Type |
Integer |
SB_OS_THIC |
Orig. Surf Thick. |
nnn. |
Orig. Surf Thickness |
Double |
SB_OS_TY |
Orig. Surf. Type Text |
25x |
Orig. Surf Type Text |
Text |
SB_OSTREET |
On Street |
75x |
On Street |
Text |
SB_PROJ_NO |
Project Number |
20x |
Project Number |
Text |
SB_R_O_W |
ROW Width |
nnn.nn |
Right-of-Way Width |
Double |
SB_REHB_CD |
Last Rehab |
nnn |
Last Maintenance based on Pavement Maintenance Module |
Integer |
SB_REHB_DT |
Last Maint Date |
mm/dd/yyyy |
Last Maintenance Date based on Pavement Maintenance Module |
Date/Time |
SB_REHB_TY |
Last Rehab Text |
30x |
Last Maintenance Description based on Pavement Maintenance Module |
Text |
SB_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
SB_RSFV |
Roughness Factor |
nnnn.nn |
Roughness Factor |
Double |
SB_SBSEGCD |
Subsegment Code |
nnn |
SubSegment Code |
Integer |
SB_SLPE_CD |
Cross Slope |
nnn |
Cross Slope |
Integer |
SB_SLPE_PC |
Cross Slope % |
nnn.n |
Ave. Cross Slope % |
Double |
SB_SLPE_TY |
Cross Slope Text |
25x |
Cross Slope Text |
Text |
SB_SN_ID |
Segment Rec # |
nnnnnnnn |
Long Integer |
|
SB_SP_ID |
Superseg Rec # |
nnnnnnnn |
Long Integer |
|
SB_SRC_CD |
Info. Source |
nnn |
Information Source |
Integer |
SB_SRC_TY |
Info. Source Text |
25x |
Inform. Source Text |
Text |
SB_SSFV |
Structural Factor |
nn.nn |
Structural Factor |
Double |
SB_START |
Starting Desc |
100x |
Starting Point |
Text |
SB_STARTPT |
Start Station |
nnnnn.n |
Start Station |
Double |
SB_STRE_CD |
Pavement Strength |
nnn |
Pavement Strength |
Integer |
SB_STRE_TY |
Pavement Strength Text |
25x |
Pavement Strength Type |
Text |
SB_SUB_STR |
CBR Value |
nnn. |
Subsurface Strength |
Double |
SB_SURF_CD |
Pavement Type |
nnn |
Surface Type |
Integer |
SB_SURF_TY |
Pavement Type Text |
25x |
Surface Type Text |
Text |
SB_SUSER1 |
Shared User 1 |
30x |
Shared User 1 |
Text |
SB_SUSER2 |
Shared User 2 |
30x |
Shared User 2 |
Text |
SB_SUSER3 |
Shared User 3 |
30x |
Shared User 3 |
Text |
SB_SUSER4 |
Shared User 4 |
nnnnnnnnn.nn |
Shared User 4 |
Double |
SB_SUSER5 |
Shared User 5 |
nnnnnnnnn.nn |
Shared User 5 |
Double |
SB_SUSER6 |
Shared User 6 |
nnnnnnnnn.nn |
Shared User 6 |
Double |
SB_SUSER7 |
Shared User 7 |
|
Shared User 7 |
Boolean |
SB_SUSER8 |
Shared User 8 |
|
Shared User 8 |
Boolean |
SB_SUSER9 |
Shared User 9 |
|
Shared User 9 |
Boolean |
SB_SW_C_CD |
Curb/Gutter Type SE |
nnn |
Curb/Gutter Type |
Integer |
SB_SW_C_H |
Curb Height SE |
nnn.n |
Curb Height (in.) |
Double |
SB_SW_C_TY |
Curb/Gutter Type SE Text |
25x |
Curb/Gutter Type Txt |
Text |
SB_SW_C_W |
Curb Width SE |
nnn.n |
Width (in.) |
Double |
SB_SW_CLIP |
Depth Above Lip SE |
nnn.n |
Inches Above Lip |
Double |
SB_SW_D_CD |
Drainage Type SE |
nnn |
Drainage Type |
Integer |
SB_SW_D_TY |
Drainage Type SE Text |
25x |
Drainage Type Text |
Text |
SB_SW_DW_N |
# of Units SE |
nnn |
Number of Units |
Integer |
SB_SW_IN_CD |
Inlets Present SE |
nnn |
Inlets Present |
Integer |
SB_SW_IN_TY |
Inlets Present SE Text |
25x |
Inlets Present Text |
Text |
SB_SW_OV_CD |
Curb Overlaid SE |
nnn |
Overlaid |
Integer |
SB_SW_OV_TY |
Curb Overlaid SE Text |
25x |
Overlaid Text |
Text |
SB_SW_SW_CD |
Sidewalk Type SE |
nnn |
Sidewalk Type |
Integer |
SB_SW_SW_L |
Sidewalk Length SE |
nnnn.n |
S/E Sidewalk Length |
Double |
SB_SW_SW_TY |
Sidewalk Type SE Text |
25x |
Sidewalk Type Text |
Text |
SB_SW_SW_W |
Sidewalk Width SE |
nnn.n |
Width |
Double |
SB_SW_SWD_CD |
Dist from Curb SE |
nnn |
Distance From Curb |
Integer |
SB_SW_SWD_TY |
Dist from Curb SE Text |
25x |
Dist From Curb Text |
Text |
SB_SY |
Pave Area (SY) |
nnnnnnnnn.nn |
Square Yardage |
Double |
SB_TAREA |
Total Area |
nnnnnn.nn |
Total Area |
Double |
SB_TPERC |
To Percentage |
nnn.n |
To Percentage |
Double |
SB_TRET_CD |
Surface Type |
nnn |
Surf. Treatment |
Integer |
SB_TRET_TY |
Surface Type Text |
50x |
Surf. Treatment Text |
Text |
SB_TSTREET |
To Street |
75x |
To Street |
Text |
SB_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
SB_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
SB_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
SB_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
SB_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
SB_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
SB_USER4 |
User 4 |
-nnnnnnnnn.nn |
User 4 |
Double |
SB_USER5 |
User 5 |
30x |
User 5 |
Text |
SB_USER6 |
User 6 |
|
User 6 |
Boolean |
SB_USER7 |
User 7 |
|
User 7 |
Boolean |
SB_USER8 |
User 8 |
|
User 8 |
Boolean |
SB_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
SB_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
SB_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
SB_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
SB_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
SB_USER14 |
User 14 |
30x |
User 14 |
Text |
SB_USER15 |
User 15 |
30x |
User 15 |
Text |
SB_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
SB_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
SB_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
SB_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
SB_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
SB_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
SB_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
SB_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
SB_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
SB_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
SB_USER21 |
User 21 |
50x |
User 21 |
String |
SB_USER22 |
User 22 |
50x |
User 22 |
String |
SB_USER23 |
User 23 |
50x |
User 23 |
String |
SB_USER24 |
User 24 |
50x |
User 24 |
String |
SB_USER25 |
User 25 |
50x |
User 25 |
String |
SB_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
SB_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
SB_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
SB_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
SB_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
SB_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
SB_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
SB_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
SB_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
SB_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
SB_USER36 |
User 36 |
|
User 36 |
Boolean |
SB_USER37 |
User 37 |
|
User 37 |
Boolean |
SB_USER38 |
User 38 |
|
User 38 |
Boolean |
SB_USER39 |
User 39 |
|
User 39 |
Boolean |
SB_USER40 |
User 40 |
|
User 40 |
Boolean |
SB_WIDTH |
Width |
nnn.n |
Width |
Double |
SB_WO_COMM |
WO Comment |
255x |
This short comment gets copied to work orders |
Text |
SB_X |
X Coordinate |
nnnnnnnn.nn |
X Coordinate |
Double |
SB_YR_CONS |
Orig. Const. Year |
nnnn |
Original Const. Year |
Integer |
SB_Y |
Y Coordinate |
nnnnnnnn.nn |
Y Coordinate |
Double |