PKPOOLAI

Park Pool Appurtenance Inspection

Field Name

Caption

Mask

Description

Field Type

OU_ACT_CD

Action

nnn

Action

Integer

OU_ACT_TY

Action Text

25x

Action Text

Text

OU_AS_ID

Pool Appurtenance Rec #

nnnnnnnn

Link to PKPOOLA.AS_ID

Long Integer

OU_COND_CD

Overall Condition

nnn

Overall Condition

Integer

OU_COND_TY

Overall Condition Text

25x

Overall Condition Text

Text

OU_COND10

Condition 10

-nnnnnnnn.nn

Condition 10

Double

OU_COND11

Condition 11

 

Condition 11

Boolean

OU_COND12

Condition 12

 

Condition 12

Boolean

OU_COND13

Condition 13

 

Condition 13

Boolean

OU_COND14

Condition 14

 

Condition 14

Boolean

OU_COND15

Condition 15

 

Condition 15

Boolean

OU_COND1CD

Condition 1

nnn

Condition 1

Integer

OU_COND1TY

Condition 1 Text

25x

Condition 1 Text

Text

OU_COND2CD

Condition 2

nnn

Condition 2

Integer

OU_COND2TY

Condition 2 Text

25x

Condition 2 Text

Text

OU_COND3CD

Condition 3

nnn

Condition 3

Integer

OU_COND3TY

Condition 3 Text

25x

Condition 3 Text

Text

OU_COND4CD

Condition 4

nnn

Condition 4

Integer

OU_COND4TY

Condition 4 Text

25x

Condition 4 Text

Text

OU_COND5CD

Condition 5

nnn

Condition 5

Integer

OU_COND5TY

Condition 5 Text

25x

Condition 5 Text

Text

OU_COND6

Condition 6

-nnnnnnnn.nn

Condition 6

Double

OU_COND7

Condition 7

-nnnnnnnn.nn

Condition 7

Double

OU_COND8

Condition 8

-nnnnnnnn.nn

Condition 8

Double

OU_COND9

Condition 9

-nnnnnnnn.nn

Condition 9

Double

OU_CRT_BY

Created By

25x

Created By

Text

OU_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

OU_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

OU_ID

Pool Appurt Insp Rec #

nnnnnnnn

Pool Appurtenance Inspection Rec ID

Long Integer

OU_INSP_BY

Inspection By

30x

Inspection By

Text

OU_INSP_CD

Inspected By

5x

Inspected By

Text

OU_INSP_DT

Last Inspection

mm/dd/yyyy

Inspection Date

Date/Time

OU_INSP_TM

Last Inspection Time

hh:mm am

Inspection Time

Date/Time

OU_INSP_TY

Inspected By Text

30x

Inspected By Text

Text

OU_LATEST

Most Recent Inspection

 

Most Recent Inspection

Boolean

OU_MAINTREQ

Maint Requested

 

Maintenance Requested

Boolean

OU_MOD_BY

Last Modified By

25x

Last Modified By

Text

OU_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

OU_MOD_TM

Last Modified Time

hh:mm am

Last Modified Time

Date/Time

OU_NEEDREP

Needs Repair

 

Needs Repair

Boolean

OU_NEXT_DT

Next Inspection

mm/dd/yyyy

Next Inspection Date

Date/Time

OU_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

OU_RQ_ID

Link to Request

nnnnnnnn

Link to WKREQ.RQ_ID

Long Integer

OU_USER1CD

User 1

nnn

User 1

Integer

OU_USER1TY

User 1 Text

25x

User 1 Text

Text

OU_USER2CD

User 2

nnn

User 2

Integer

OU_USER2TY

User 2 Text

25x

User 2 Text

Text

OU_USER3CD

User 3

nnn

User 3

Integer

OU_USER3TY

User 3 Text

25x

User 3 Text

Text

OU_USER4CD

User 4

nnn

User 4

Integer

OU_USER4TY

User 4 Text

25x

User 4 Text

Text

OU_USER5CD

User 5

nnn

User 5

Integer

OU_USER5TY

User 5 Text

25x

User 5 Text

Text

OU_USER6

User 6

50x

User 6

Text

OU_USER7

User 7

50x

User 7

Text

OU_USER8

User 8

50x

User 8

Text

OU_USER9

User 9

50x

User 9

Text

OU_USER10

User 10

50x

User 10

Text

OU_USER11

User 11

-nnnnnnnn.nn

User 11

Double

OU_USER12

User 12

-nnnnnnnn.nn

User 12

Double

OU_USER13

User 13

-nnnnnnnn.nn

User 13

Double

OU_USER14

User 14

-nnnnnnnn.nn

User 14

Double

OU_USER15

User 15

-nnnnnnnn.nn

User 15

Double

OU_USER16

User 16

mm/dd/yyyy

User 16

Date/Time

OU_USER17

User 17

mm/dd/yyyy

User 17

Date/Time

OU_USER18

User 18

mm/dd/yyyy

User 18

Date/Time

OU_USER19

User 19

mm/dd/yyyy

User 19

Date/Time

OU_USER20

User 20

mm/dd/yyyy

User 20

Date/Time

OU_USER21

User 21

 

User 21

Boolean

OU_USER22

User 22

 

User 22

Boolean

OU_USER23

User 23

 

User 23

Boolean

OU_USER24

User 24

 

User 24

Boolean

OU_USER25

User 25

 

User 25

Boolean

OU_USER26CD

User 26

nnn

User 26

Integer

OU_USER26TY

User 26 Text

50x

User 26 Text

String

OU_USER27CD

User 27

nnn

User 27

Integer

OU_USER27TY

User 27 Text

50x

User 27 Text

String

OU_USER28CD

User 28

nnn

User 28

Integer

OU_USER28TY

User 28 Text

50x

User 28 Text

String

OU_USER29CD

User 29

nnn

User 29

Integer

OU_USER29TY

User 29 Text

50x

User 29 Text

String

OU_USER30CD

User 30

nnn

User 30

Integer

OU_USER30TY

User 30 Text

50x

User 30 Text

String

OU_USER31

User 31

50x

User 31

String

OU_USER32

User 32

50x

User 32

String

OU_USER33

User 33

50x

User 33

String

OU_USER34

User 34

50x

User 34

String

OU_USER35

User 35

50x

User 35

String

OU_USER36

User 36

nnnnnnnn.nn

User 36

Double

OU_USER37

User 37

nnnnnnnn.nn

User 37

Double

OU_USER38

User 38

nnnnnnnn.nn

User 38

Double

OU_USER39

User 39

nnnnnnnn.nn

User 39

Double

OU_USER40

User 40

nnnnnnnn.nn

User 40

Double

OU_USER41

User 41

mm/dd/yyyy hh:mm am

User 41

DateTime

OU_USER42

User 42

mm/dd/yyyy hh:mm am

User 42

DateTime

OU_USER43

User 43

mm/dd/yyyy hh:mm am

User 43

DateTime

OU_USER44

User 44

mm/dd/yyyy hh:mm am

User 44

DateTime

OU_USER45

User 45

mm/dd/yyyy hh:mm am

User 45

DateTime

OU_USER46

User 46

 

User 46

Boolean

OU_USER47

User 47

 

User 47

Boolean

OU_USER48

User 48

 

User 48

Boolean

OU_USER49

User 49

 

User 49

Boolean

OU_USER50

User 50

 

User 50

Boolean

OU_WO_ID

Work Order Rec #

nnnnnnnn

Link to WKORDER.WO_ID

Long Integer