PKLSICH

Park Landscape Inspection Checklist

Field Name

Caption

Mask

Description

Field Type

DF_COND_CD

Condition

nnn

Condition

Integer

DF_COND_TY

Condition Text

25x

Condition Text

String

DF_CRT_BY

Created By

25x

Created By

String

DF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

DF_ID

Autonumber ID

nnnnnnnn

Autonumber ID

Long Integer

DF_INSP_DT

Inspection Date

mm/dd/yyyy hh:mm am

Inspection Date

DateTime

DF_INSP_TM

Inspection Time

mm/dd/yyyy hh:mm am

Inspection Time

DateTime

DF_LSI_ID

 

nnnnnnnn

Link to PKLSINS.LSI_ID

Long Integer

DF_MOD_BY

Last Modified By

25x

Last Modified By

String

DF_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

DF_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

DF_NOTE

Note

255x

Note

String

DF_NUMBER

Line Number

nnnnnnnn

Line Number

Long Integer

DF_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

DF_TEXT

Checklist Instructions

100x

Checklist Instructions

String