STCON

Street Construction Records

Field Name

Caption

Mask

Description

Field Type

ZS_CIP

Cap Imp Proj #

30x

Cap Imp Proj #

Text

ZS_CONS_C

Construction Cost

nnnnnnnn.nn

Construction cost

Double

ZS_CONS_DT

Construction Date

mm/dd/yyyy

Date

Date/Time

ZS_CONTRCT

Contractor

30x

Contractor

Text

ZS_CRT_BY

Created By

25x

Created By

Text

ZS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

ZS_DESIGN

Designer

30x

Designer

Text

ZS_DESN_C

Design Cost

nnnnnnnn.nn

Design cost

Double

ZS_DIST_CD

Council District

nnn

Council District

Integer

ZS_DIST_TY

Council District Text

25x

Council District Text

Text

ZS_DOC_FLG

Document Available

 

Document Available

Boolean

ZS_DT1_DT

Date 1

mm/dd/yyyy

Date 1

Date/Time

ZS_DT10_DT

Date 10

mm/dd/yyyy

Date 10

Date/Time

ZS_DT2_DT

Date 2

mm/dd/yyyy

Date 2

Date/Time

ZS_DT3_DT

Date 3

mm/dd/yyyy

Date 3

Date/Time

ZS_DT4_DT

Date 4

mm/dd/yyyy

Date 4

Date/Time

ZS_DT5_DT

Date 5

mm/dd/yyyy

Date 5

Date/Time

ZS_DT6_DT

Date 6

mm/dd/yyyy

Date 6

Date/Time

ZS_DT7_DT

Date 7

mm/dd/yyyy

Date 7

Date/Time

ZS_DT8_DT

Date 8

mm/dd/yyyy

Date 8

Date/Time

ZS_DT9_DT

Date 9

mm/dd/yyyy

Date 9

Date/Time

ZS_ID

Rec #

nnnnnnnn

Const Record AutoID

Long Integer

ZS_INDEX

Index Number

30x

Index Number

Text

ZS_INSP_C

Inspection Cost

nnnnnnnn.nn

Inspection Cost

Double

ZS_INSPECT

Inspector

30x

Inspector

Text

ZS_MAP1

Map 1

30x

Map 1

Text

ZS_MAP2

Map 2

30x

Map 2

Text

ZS_MOD_BY

Last Modified By

25x

Last Modified By

Text

ZS_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

ZS_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

ZS_PJ_ID

Work Project Rec #

nnnnnnnn

Link to WKPROJ.PJ_ID

Long Integer

ZS_PRJ_DES

Proj Description

100x

Proj Description

Text

ZS_PRJ_NO

Project Number

25x

Project Number

Text

ZS_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

ZS_TOTAL_C

Total Cost

nnnnnnnn.nn

Total Cost

Double

ZS_UNITS

Project Units

nnnnnnnn.nn

Project Units

Double

ZS_UNT_CST

Project Unit Cost

nnnnnnnn.nn

Project Unit Cost

Double

ZS_UOM_CD

Project UOM

5x

Project Unit of Measure

Text

ZS_UOM_TY

Project UOM Text

25x

Project Unit of Measure Text

Text

ZS_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

ZS_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

ZS_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

ZS_USER13

User 13

 

User 13

Boolean

ZS_USER14

User 14

 

User 14

Boolean

ZS_USER15

User 15

 

User 15

Boolean

ZS_USER1CD

User 1

nnn

User 1

Integer

ZS_USER1TY

User 1 Text

25x

User 1 Text

Text

ZS_USER2CD

User 2

nnn

User 2

Integer

ZS_USER2TY

User 2 Text

25x

User 2 Text

Text

ZS_USER3CD

User 3

nnn

User 3

Integer

ZS_USER3TY

User 3 Text

25x

User 3 Text

Text

ZS_USER4

User 4

30x

User 4

Text

ZS_USER5

User 5

30x

User 5

Text

ZS_USER6

User 6

30x

User 6

Text

ZS_USER7

User 7

nnnnnnnn.nn

User 7

Double

ZS_USER8

User 8

nnnnnnnn.nn

User 8

Double

ZS_USER9

User 9

nnnnnnnn.nn

User 9

Double