WKPROJFI

Final Inspection for Project

Field Name

Caption

Mask

Description

Field Type

ZU_COMMENT1

Long Note

 

Long Note

Memo

ZU_CONT_CD

Contractor

10x

Contractor

Text

ZU_CONT_TY

Contractor Text

60x

Contractor Text

Text

ZU_CRT_BY

Created By

25x

Created By

Text

ZU_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

ZU_DOC_FLG

Document Available

 

Document Available

Boolean

ZU_ID

Final Project Insp Rec #

nnnnnnnn

Final Project Insp Rec # AutoID

Long Integer

ZU_INBY_CD

Inspected By

nnn

Inspected By

Integer

ZU_INBY_TY

Inspected By Text

100x

Inspected By Text

Text

ZU_INSP_DT

Inspection Date (required field)

mm/dd/yyyy hh:mm am

Inspection Date (required field)

DateTime

ZU_INSP_TM

Inspection Time (allows for more than one Record per Day)

mm/dd/yyyy hh:mm am

Inspection Time (allows for more than one Record per Day)

DateTime

ZU_LATEST

Most Recent Inspection

 

Most Recent Inspection

Boolean

ZU_MOD_BY

Last Modified By

25x

Last Modified By

Text

ZU_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

ZU_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

ZU_PDAY

Permit Day

nnn

Permit Day

Integer

ZU_PDAYS

Total Permitted Days

nnn

Total Permitted Days

Integer

ZU_PJ_ID

Project Rec # - Link to WKPROJ table

nnnnnnnn

Project Rec # - Link to WKPROJ

Long Integer

ZU_POTHER

Other Permit

 

Other Permit

Boolean

ZU_PRINS_CD

Contract Inspector

20x

Contract Inspector

Text

ZU_PRINS_TY

Contract Inspector Text

40x

Contract Inspector Text

Text

ZU_PSEWER

Sewer Permit

 

Sewer Permit

Boolean

ZU_PSTORM

Stormwater Permit

 

Stormwater Permit

Boolean

ZU_PTRANS

Transportation Permit

 

Transportation Permit

Boolean

ZU_PWATER

Water Permit

 

Water Permit

Boolean

ZU_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

ZU_SCOM_DT

Substantially Complete Date

mm/dd/yyyy hh:mm am

Substantially Complete Date

DateTime

ZU_SUPER

Superintendant Name

50x

Superintendant Name

Text

ZU_USER10CD

User 10

20x

User 10

Text

ZU_USER10TY

User 10 Text

100x

User 10 Text

Text

ZU_USER11

User 11

250x

User 11

Text

ZU_USER12

User 12

250x

User 12

Text

ZU_USER13

User 13

250x

User 13

Text

ZU_USER14

User 14

250x

User 14

Text

ZU_USER15

User 15

250x

User 15

Text

ZU_USER16

User 16

nnnnnnnn.nn

User 16

Double

ZU_USER17

User 17

nnnnnnnn.nn

User 17

Double

ZU_USER18

User 18

nnnnnnnn.nn

User 18

Double

ZU_USER19

User 19

nnnnnnnn.nn

User 19

Double

ZU_USER1CD

User 1

nnn

User 1

Integer

ZU_USER1TY

User 1 Text

100x

User 1 Text

Text

ZU_USER20

User 20

nnnnnnnn.nn

User 20

Double

ZU_USER21

User 21

mm/dd/yyyy hh:mm am

User 21

DateTime

ZU_USER22

User 22

mm/dd/yyyy hh:mm am

User 22

DateTime

ZU_USER23

User 23

mm/dd/yyyy hh:mm am

User 23

DateTime

ZU_USER24

User 24

mm/dd/yyyy hh:mm am

User 24

DateTime

ZU_USER25

User 25

mm/dd/yyyy hh:mm am

User 25

DateTime

ZU_USER26

User 26

 

User 26

Boolean

ZU_USER27

User 27

 

User 27

Boolean

ZU_USER28

User 28

 

User 28

Boolean

ZU_USER29

User 29

 

User 29

Boolean

ZU_USER2CD

User 2

nnn

User 2

Integer

ZU_USER2TY

User 2 Text

100x

User 2 Text

Text

ZU_USER30

User 30

 

User 30

Boolean

ZU_USER31CD

User 31

nnn

User 31

Integer

ZU_USER31TY

User 31 Text

100x

User 31 Text

Text

ZU_USER32CD

User 32

nnn

User 32

Integer

ZU_USER32TY

User 32 Text

100x

User 32 Text

Text

ZU_USER33CD

User 33

nnn

User 33

Integer

ZU_USER33TY

User 33 Text

100x

User 33 Text

Text

ZU_USER34CD

User 34

nnn

User 34

Integer

ZU_USER34TY

User 34 Text

100x

User 34 Text

Text

ZU_USER35CD

User 35

nnn

User 35

Integer

ZU_USER35TY

User 35 Text

100x

User 35 Text

Text

ZU_USER36CD

User 36

20x

User 36

Text

ZU_USER36TY

User 36 Text

100x

User 36 Text

Text

ZU_USER37CD

User 37

20x

User 37

Text

ZU_USER37TY

User 37 Text

100x

User 37 Text

Text

ZU_USER38CD

User 38

20x

User 38

Text

ZU_USER38TY

User 38 Text

100x

User 38 Text

Text

ZU_USER39CD

User 39

20x

User 39

Text

ZU_USER39TY

User 39 Text

100x

User 39 Text

Text

ZU_USER3CD

User 3

nnn

User 3

Integer

ZU_USER3TY

User 3 Text

100x

User 3 Text

Text

ZU_USER40CD

User 40

20x

User 40

Text

ZU_USER40TY

User 40 Text

100x

User 40 Text

Text

ZU_USER41

User 41

250x

User 41

Text

ZU_USER42

User 42

250x

User 42

Text

ZU_USER43

User 43

250x

User 43

Text

ZU_USER44

User 44

250x

User 44

Text

ZU_USER45

User 45

250x

User 45

Text

ZU_USER46

User 46

nnnnnnnn.nn

User 46

Double

ZU_USER47

User 47

nnnnnnnn.nn

User 47

Double

ZU_USER48

User 48

nnnnnnnn.nn

User 48

Double

ZU_USER49

User 49

nnnnnnnn.nn

User 49

Double

ZU_USER4CD

User 4

nnn

User 4

Integer

ZU_USER4TY

User 4 Text

100x

User 4 Text

Text

ZU_USER50

User 50

nnnnnnnn.nn

User 50

Double

ZU_USER51

User 51

mm/dd/yyyy hh:mm am

User 51

DateTime

ZU_USER52

User 52

mm/dd/yyyy hh:mm am

User 52

DateTime

ZU_USER53

User 53

mm/dd/yyyy hh:mm am

User 53

DateTime

ZU_USER54

User 54

mm/dd/yyyy hh:mm am

User 54

DateTime

ZU_USER55

User 55

mm/dd/yyyy hh:mm am

User 55

DateTime

ZU_USER56

User 56

 

User 56

Boolean

ZU_USER57

User 57

 

User 57

Boolean

ZU_USER58

User 58

 

User 58

Boolean

ZU_USER59

User 59

 

User 59

Boolean

ZU_USER5CD

User 5

nnn

User 5

Integer

ZU_USER5TY

User 5 Text

100x

User 5 Text

Text

ZU_USER60

User 60

 

User 60

Boolean

ZU_USER6CD

User 6

20x

User 6

Text

ZU_USER6TY

User 6 Text

100x

User 6 Text

Text

ZU_USER7CD

User 7

20x

User 7

Text

ZU_USER7TY

User 7 Text

100x

User 7 Text

Text

ZU_USER8CD

User 8

20x

User 8

Text

ZU_USER8TY

User 8 Text

100x

User 8 Text

Text

ZU_USER9CD

User 9

20x

User 9

Text

ZU_USER9TY

User 9 Text

100x

User 9 Text

Text