PKCON

Park Construction Records

Field Name

Caption

Mask

Description

Field Type

CS_CIP

Cap Imp Proj #

30x

Cap Imp Proj #

Text

CS_CONS_C

Construction Cost

nnnnnnnn.nn

Construction cost

Double

CS_CONS_DT

Construction Date

mm/dd/yyyy

Date

Date/Time

CS_CONTRCT

Contractor

30x

Contractor

Text

CS_CRT_BY

Created By

25x

Created By

Text

CS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CS_DESIGN

Designer

30x

Designer

Text

CS_DESN_C

Design Cost

nnnnnnnn.nn

Design cost

Double

CS_DIST_CD

Council District

nnn

Council District

Integer

CS_DIST_TY

Council District Text

25x

Council District Text

Text

CS_DOC_FLG

Document Available

 

Document Available

Boolean

CS_DT1_DT

Date 1

mm/dd/yyyy

Date 1

Date/Time

CS_DT10_DT

Date 10

mm/dd/yyyy

Date 10

Date/Time

CS_DT2_DT

Date 2

mm/dd/yyyy

Date 2

Date/Time

CS_DT3_DT

Date 3

mm/dd/yyyy

Date 3

Date/Time

CS_DT4_DT

Date 4

mm/dd/yyyy

Date 4

Date/Time

CS_DT5_DT

Date 5

mm/dd/yyyy

Date 5

Date/Time

CS_DT6_DT

Date 6

mm/dd/yyyy

Date 6

Date/Time

CS_DT7_DT

Date 7

mm/dd/yyyy

Date 7

Date/Time

CS_DT8_DT

Date 8

mm/dd/yyyy

Date 8

Date/Time

CS_DT9_DT

Date 9

mm/dd/yyyy

Date 9

Date/Time

CS_ID

Rec #

nnnnnnnn

Const Record AutoID

Long Integer

CS_INDEX

Index Number

30x

Index Number

Text

CS_INSP_C

Inspection Cost

nnnnnnnn.nn

Inspection Cost

Double

CS_INSPECT

Inspector

30x

Inspector

Text

CS_MAP1

Map 1

30x

Map 1

Text

CS_MAP2

Map 2

30x

Map 2

Text

CS_MOD_BY

Last Modified By

25x

Last Modified By

Text

CS_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

CS_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CS_PJ_ID

Link to Work Project Record #

nnnnnnnn

Link to WKPROJ.PJ_ID

Long Integer

CS_PRJ_DES

Proj Description

100x

Proj Description

Text

CS_PRJ_NO

Project Number

25x

Project Number

Text

CS_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

CS_TOTAL_C

Total Cost

nnnnnnnn.nn

Total Cost

Double

CS_UNITS

Project Units

nnnnnnnn.nn

Project Units

Double

CS_UNT_CST

Project Unit Cost

nnnnnnnn.nn

Project Unit Cost

Double

CS_UOM_CD

Project UOM

5x

Project Unit of Measure

Text

CS_UOM_TY

Project UOM Text

25x

Project Unit of Measure Text

Text

CS_USER1CD

User 1

nnn

User 1

Integer

CS_USER1TY

User 1 Text

25x

User 1 Text

Text

CS_USER2CD

User 2

nnn

User 2

Integer

CS_USER2TY

User 2 Text

25x

User 2 Text

Text

CS_USER3CD

User 3

nnn

User 3

Integer

CS_USER3TY

User 3 Text

25x

User 3 Text

Text

CS_USER4

User 4

30x

User 4

Text

CS_USER5

User 5

30x

User 5

Text

CS_USER6

User 6

30x

User 6

Text

CS_USER7

User 7

nnnnnnnn.nn

User 7

Double

CS_USER8

User 8

nnnnnnnn.nn

User 8

Double

CS_USER9

User 9

nnnnnnnn.nn

User 9

Double

CS_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

CS_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

CS_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

CS_USER13

User 13

 

User 13

Boolean

CS_USER14

User 14

 

User 14

Boolean

CS_USER15

User 15

 

User 15

Boolean