Model Subsegment Results
Field Name |
Caption |
Mask |
Description |
Field Type |
SM_AREA |
Area |
nnnnnnnn. |
Area |
Double |
SM_BACKLOG |
Backlog |
|
Backlog |
Boolean |
SM_CLAS_CD |
Classification |
nnn |
Classification |
Integer |
SM_CLAS_TY |
Classification Text |
25x |
Classification Text |
Text |
SM_CODE |
Subsegment Code |
30x |
Subsegment Code |
Text |
SM_COND_CD |
Condition |
nnn |
Condition |
Integer |
SM_COND_TY |
Condition Text |
50x |
Condition Text |
Text |
SM_CRT_BY |
Created By |
25x |
Created By |
Text |
SM_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
SM_FSELECT |
Forced Selection |
|
Forced Selection (from Planning Table) or Linked Supersegment |
Boolean |
SM_FSKIP |
Forced Skip Selection |
|
Forced Skip Selection based on Year-to-Work Table |
Boolean |
SM_FSTREET |
From Street |
75x |
From Street |
Text |
SM_ID |
AutoNumber |
nnnnnnnn |
Auto Number |
Long Integer |
SM_LENGTH |
Length |
nnnnnnnnn. |
Length |
Double |
SM_MINLIFE |
Minimum Life |
nnn |
Minimum Life of Rehabilitation before the Supersegment can be selected again by the model |
Integer |
SM_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
SM_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
SM_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
SM_MP_DESC |
Model Description |
30x |
Model Description |
Text |
SM_MP_ID |
Model Run ID |
nnnnnnnn |
Long Integer |
|
SM_MY_ID |
Model Year ID |
nnnnnnnn |
Long Integer |
|
SM_MY_YEAR |
Model Year |
nnnn |
Model Year |
Integer |
SM_NWSF_CD |
Surface After Maint |
nnn |
Pavement Type - After Maintenance |
Integer |
SM_NWSF_TY |
Surface After Maint Text |
25x |
Pavement Type Text - After Maintenance |
Text |
SM_NXTYEAR |
Next Rehab Year |
nnnn |
Next Year Segment can be Selected for Rehab Method |
Integer |
SM_OSTREET |
On Street |
75x |
On Street |
Text |
SM_OSCZS |
Only Select Critical |
|
Only Select Critical Zone Street Segments based on Budget |
Boolean |
SM_REH_KZ |
Rehab Key Zone |
|
In Rehab Key Zone |
Boolean |
SM_REHB_AC |
Rehab Post Count |
nnn |
Rehab Post Count |
Integer |
SM_REHB_CD |
Rehab |
nnn |
Rehab |
Integer |
SM_REHB_PC |
Rehab Group |
nnn |
Rehab Pre Count |
Integer |
SM_REHB_TY |
Rehab Text |
30x |
Rehab Description |
Text |
SM_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
SM_SB_ID |
Subsegment Rec # |
nnnnnnnn |
Long Integer |
|
SM_SELECT |
Selected |
|
Selected for Repairs |
Boolean |
SM_SP_ID |
Supersegment Rec # |
nnnnnnnn |
Long Integer |
|
SM_STRE_CD |
Pavement Strength |
nnn |
Pavement Strength |
Integer |
SM_STRE_TY |
Pavement Strength Text |
25x |
Pavement Strength Type |
Text |
SM_SURF_CD |
Surface |
nnn |
Surface Type - Before Maintenance |
Integer |
SM_SURF_TY |
Surface Text |
25x |
Surface Type Text - Before Maintenance |
Text |
SM_TOT_CS |
Total Cost |
nnnnnnnnn. |
Distrubuted Total Cost |
Double |
SM_TSTREET |
To Street |
75x |
To Street |
Text |