Streets with Planned Work on a Specific Year
Field Name |
Caption |
Mask |
Description |
Field Type |
YW_CLAS_CD |
Classification |
nnn |
Classification |
Integer |
YW_CLAS_TY |
Classification Text |
25x |
Classification Text |
Text |
YW_COST |
Rehab Cost |
nnnnnnnnn. |
Cost of Street Improvement - leave blank if you want the computer model to determine the cost |
Double |
YW_CRT_BY |
Created By |
25x |
Created By |
Text |
YW_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
YW_ID |
Year To Work Rec # |
nnnnnnnn |
|
Long Integer |
YW_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
YW_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
YW_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
YW_NBEFOR |
No Rehab Before |
|
Flag for No Rehab Selected for this segment before this Rehab is complete |
Boolean |
YW_PAVE_CD |
Pavement Type |
nnn |
Pavement Type |
Integer |
YW_PAVE_TY |
Pavement Type Text |
25x |
Pavement Type Text |
Text |
YW_PT_ID |
Planning Table Rec # |
nnnnnnnn |
Long Integer |
|
YW_REHB_CD |
Pavement Rehab |
nnn |
Rehab |
Integer |
YW_REHB_TY |
Pavement Rehab Text |
30x |
Rehab Description |
Text |
YW_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
YW_RS_ALTID |
Alt Seg ID |
20x |
Road Segment Alt Asset ID |
Text |
YW_RS_BRP |
Beg Ref Post |
nnnnnnnn.nnn |
Road Segment Beginning Reference Post |
Double |
YW_RS_ID |
Road Segment Rec # |
nnnnnnnn |
Long Integer |
|
YW_SP_AREA |
Area |
nnnnnn.nn |
Area |
Double |
YW_SP_DESC |
Superseg Desc |
50x |
Supersegment Description |
Text |
YW_SP_ID |
Supersegment Rec # |
nnnnnnnn |
Long Integer |
|
YW_SP_UNIQ |
Superseg Code |
50x |
Unique Supersegment Code |
Text |
YW_YEAR |
Year to Work |
nnnn |
Year to Work |
Integer |