WKPERMITE

Permit Enforcement

Field Name

Caption

Mask

Description

Field Type

IE_ADDR1

Address 1

75x

Address 1

Text

IE_ADDR2

Address 2

75x

Address 2

Text

IE_BUSIN

Business

50x

Business

Text

IE_CITY_CD

City

nnn

City

Integer

IE_CITY_TY

City Text

50x

City Text

Text

IE_COUN_CD

County

nnn

County

Integer

IE_COUN_TY

County Text

25x

County Text

Text

IE_CPHONE

Cell Phone

30x

Celll Phone

Text

IE_CRT_BY

Created By

25x

Created By

Text

IE_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

IE_DOC_FLG

Document Available

 

Document Available

Boolean

IE_EMAIL

Email Address

150x

Email Address

Text

IE_FPHONE

Fax Phone

30x

Fax Phone

Text

IE_ID

Permit Enforcement Rec #

nnnnnnnn

Enforcement ID

Long Integer

IE_MOD_BY

Last Modified By

25x

Last Modified By

Text

IE_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

IE_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

IE_NAME

Name

50x

Name

Text

IE_PHONE

Phone

30x

Phone

Text

IE_POSTAL

Zip Code

15x

Zip Code

Text

IE_PP_ID

Permit Rec #

nnnnnnnn

Link to WKPERMIT.PP_ID

Long Integer

IE_REC_DT

Date Recorded

mm/dd/yyyy

Date Recorded

Date/Time

IE_REC_TM

Time Recorded

hh:mm am

Time Recorded

Date/Time

IE_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

IE_STATE

State

30x

Zip Code

Text

IE_TITLE

Title

30x

Title

Text