WKPERMITDC

Correction List for Permits

Field Name

Caption

Mask

Description

Field Type

YH_ACCEPT

Accepted

 

Accepted

Boolean

YH_COMMENT1

Long Note

 

Long Note

Memo

YH_CORRECT

Correction

250x

Correction

String

YH_CRT_BY

Created By

25x

Created By

String

YH_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

YH_DOC_FLG

Document Available

 

Document Available

Boolean

YH_DUE_DT

Completion Due Date

mm/dd/yyyy hh:mm am

Completion Due Date

DateTime

YH_FIX_DT

Completion Reviewed Date

mm/dd/yyyy hh:mm am

Completion Reviewed Date

DateTime

YH_ID

Permit Inspection Corrections Rec #

nnnnnnnn

Permit Insp Corrections AutoID

Long Integer

YH_INSP_CD

Inspected By

nnn

Inspected By

integer

YH_INSP_TY

Inspected By Text

100x

Inspected By Text

String

YH_LITEM

Correction Line Item

nnn

Correction Line Item

integer

YH_MOD_BY

Last Modified By

25x

Last Modified By

String

YH_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

YH_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

YH_NOTE

Note

250x

Note

String

YH_PINS_CD

Permit Inspector

20x

Permit Inspector

String

YH_PINS_TY

Permit Inspector Text

40x

Permit Inspector Text

String

YH_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

YH_YI_ID

Permit Inspection Rec # - Link to WKPERMITD table

nnnnnnnn

Link to WKPERMITD.YI_ID

Long Integer