PKARTINS

Park Art Inspections

Field Name

Caption

Mask

Description

Field Type

AT_AR_ID

Art Record #

nnnnnnnn

Link to PKART.AR_ID

Long Integer

AT_BASE_CD

Base Condition Code

nnn

Base Condition Code

Integer

AT_BASE_TY

Base Condition Text

25x

Base Condition Text

String

AT_COND_CD

General Condition Code

nnn

General Condition Code

Integer

AT_COND_TY

General Condition Text

25x

General Condition Text

String

AT_CREW

Inspection Crew

30x

Inspection Crew

String

AT_CRT_BY

Created By

25x

Created By

String

AT_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

AT_DOC_FLG

Document Flag

 

Document Flag

Boolean

AT_ID

AutoNumber

nnnnnnnn

AutoNumber

Long Integer

AT_INSP_CD

Inspected By

5x

Inspected By

String

AT_INSP_DT

Inspection Date

mm/dd/yyyy hh:mm am

Inspection Date

DateTime

AT_INSP_TM

Inspection Time

mm/dd/yyyy hh:mm am

Inspection Time

DateTime

AT_INSP_TY

Inspected By Text

30x

Inspected By Text

String

AT_LATEST

Most Recent Inspection

 

Most Recent Inspection

Boolean

AT_LITE_CD

Lighting Condition Code

nnn

Lighting Condition Code

Integer

AT_LITE_TY

Lighting Condition Text

25x

Lighting Condition Text

String

AT_MAINTREQ

Maint Requested

 

Maintenance Requested

Boolean

AT_MOD_BY

Last Modified By

25x

Last Modified By

String

AT_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

AT_MOD_TM

Last Modified Time

mm/dd/yyyy hh:mm am

Last Modified Time

DateTime

AT_NEEDREP

Needs Repair

 

Needs Repair

Boolean

AT_NEXTDT

Next Inspection Date

mm/dd/yyyy hh:mm am

Next Inspection Date

DateTime

AT_OTH1_CD

Other 1 Condition Code

nnn

Other 1 Condition Code

Integer

AT_OTH1_TY

Other 1 Condition Text

25x

Other 1 Condition Text

String

AT_OTH2_CD

Other 2 Condition Code

nnn

Other 2 Condition Code

Integer

AT_OTH2_TY

Other 2 Condition Text

25x

Other 2 Condition Text

String

AT_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

AT_RQ_ID

Link to Request

nnnnnnnn

Link to WKREQ.RQ_ID

Long Integer

AT_USER1CD

User 1

nnn

User 1

Integer

AT_USER1TY

User 1 Text

50x

User 1 Text

String

AT_USER2CD

User 2

nnn

User 2

Integer

AT_USER2TY

User 2 Text

50x

User 2 Text

String

AT_USER3CD

User 3

nnn

User 3

Integer

AT_USER3TY

User 3 Text

50x

User 3 Text

String

AT_USER4CD

User 4

nnn

User 4

Integer

AT_USER4TY

User 4 Text

50x

User 4 Text

String

AT_USER5CD

User 5

nnn

User 5

Integer

AT_USER5TY

User 5 Text

50x

User 5 Text

String

AT_USER6

User 6

50x

User 6

String

AT_USER7

User 7

50x

User 7

String

AT_USER8

User 8

50x

User 8

String

AT_USER9

User 9

50x

User 9

String

AT_USER10

User 10

50x

User 10

String

AT_USER11

User 11

nnnnnnnn.nn

User 11

Double

AT_USER12

User 12

nnnnnnnn.nn

User 12

Double

AT_USER13

User 13

nnnnnnnn.nn

User 13

Double

AT_USER14

User 14

nnnnnnnn.nn

User 14

Double

AT_USER15

User 15

nnnnnnnn.nn

User 15

Double

AT_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

AT_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

AT_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

AT_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

AT_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

AT_USER21

User 21

 

User 21

Boolean

AT_USER22

User 22

 

User 22

Boolean

AT_USER23

User 23

 

User 23

Boolean

AT_USER24

User 24

 

User 24

Boolean

AT_USER25

User 25

 

User 25

Boolean

AT_USER26CD

User 26

nnn

User 26

Integer

AT_USER26TY

User 26 Text

50x

User 26 Text

String

AT_USER27CD

User 27

nnn

User 27

Integer

AT_USER27TY

User 27 Text

50x

User 27 Text

String

AT_USER28CD

User 28

nnn

User 28

Integer

AT_USER28TY

User 28 Text

50x

User 28 Text

String

AT_USER29CD

User 29

nnn

User 29

Integer

AT_USER29TY

User 29 Text

50x

User 29 Text

String

AT_USER30CD

User 30

nnn

User 30

Integer

AT_USER30TY

User 30 Text

50x

User 30 Text

String

AT_USER31

User 31

50x

User 31

String

AT_USER32

User 32

50x

User 32

String

AT_USER33

User 33

50x

User 33

String

AT_USER34

User 34

50x

User 34

String

AT_USER35

User 35

50x

User 35

String

AT_USER36

User 36

nnnnnnnn.nn

User 36

Double

AT_USER37

User 37

nnnnnnnn.nn

User 37

Double

AT_USER38

User 38

nnnnnnnn.nn

User 38

Double

AT_USER39

User 39

nnnnnnnn.nn

User 39

Double

AT_USER40

User 40

nnnnnnnn.nn

User 40

Double

AT_USER41

User 41

mm/dd/yyyy hh:mm am

User 41

DateTime

AT_USER42

User 42

mm/dd/yyyy hh:mm am

User 42

DateTime

AT_USER43

User 43

mm/dd/yyyy hh:mm am

User 43

DateTime

AT_USER44

User 44

mm/dd/yyyy hh:mm am

User 44

DateTime

AT_USER45

User 45

mm/dd/yyyy hh:mm am

User 45

DateTime

AT_USER46

User 46

 

User 46

Boolean

AT_USER47

User 47

 

User 47

Boolean

AT_USER48

User 48

 

User 48

Boolean

AT_USER49

User 49

 

User 49

Boolean

AT_USER50

User 50

 

User 50

Boolean

AT_VISI_CD

Visibility Condition

nnn

Visibility Condition Code

Integer

AT_VISI_TY

Visibility Condition Text

25x

Visibility Condition Text

String

AT_WO_ID

WO Rec #

nnnnnnnn

Link to WKORDER.WO_ID

Long Integer