STPLANADD

Streets Added per Year for Model Run

Field Name

Caption

Mask

Description

Field Type

AS_AREA

Area

nnnnnn.nn

Area

Double

AS_CLAS_CD

Classification

nnn

Classification Code

Integer

AS_CLAS_TY

Classification Text

25x

Classification Type

Text

AS_COST

Construction Cost

nnnnnnnnn.

Cost of Street Addition. Leave blank if you want the computer to determine the cost based on the Rehab type

Double

AS_CRT_BY

Created By

25x

Created By

Text

AS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

AS_DESC

Segment Name

40x

Add Segment - Street Name

Text

AS_FROM

From Segment

65x

Add Segment - Endpoint 1 Name

Text

AS_ID

Added Segment Rec #

nnnnnnnn

 

Long Integer

AS_LENGTH

Length

nnnnn.

Length

Double

AS_MOD_BY

Last Modified By

25x

Last Modified By

Text

AS_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

AS_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

AS_PAVE_CD

Pavement Type

nnn

Pavement Code

Integer

AS_PAVE_TY

Pavement Type Text

25x

Pavement Type

Text

AS_PT_ID

Planning Table Rec #

nnnnnnnn

Link to STPLAN.PT_ID

Long Integer

AS_REHB_CD

Pavement Rehab

nnn

Rehab

Integer

AS_REHB_TY

Pavement Rehab Text

30x

Rehab Description

Text

AS_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

AS_T_CURB

Curb Length

nnnnn.nn

Total Curb Length

Double

AS_T_DW

Driveway Units

nnnnn.nn

Total Number of Driveways

Double

AS_T_SW

Sidewalk Length

nnnnn.nn

Total Sidewalk Length

Double

AS_TO

To Segment

65x

Add Segment - Endpoint 2 Name

Text

AS_WIDTH

Width

nnn.

Width

Double

AS_YEAR

Year to Add

nnnn

Year to Add Segment

Integer