PKPATHCOND

Path Condition

Field Name

Caption

Mask

Description

Field Type

PC_CRT_BY

Created By

25x

Created By

Text

PC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

PC_DIST

Distance

nnnnn.nn

Distance

Double

PC_DOC_FLG

Document Available

 

Document Available

Boolean

PC_ELEV

Elevation

nnnnn.nn

Elevation

Double

PC_GPS

GPS Flag

 

GPS Flag

Boolean

PC_ID

Path Condition Rec #

nnnnnnnn

Path Problem No.

Long Integer

PC_IMG_FLG

 

 

Image Available

Boolean

PC_INMAP

In Map Flag

 

In Map Flag

Boolean

PC_MAIN_CD

Recom Maint

nnn

Recom Maint

Integer

PC_MAIN_TY

Recom Maint Text

25x

Recom Maint Text

Text

PC_MOD_BY

Last Modified By

25x

Last Modified By

Text

PC_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

PC_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

PC_MOV_FLG

 

 

Movie Available

Boolean

PC_PI_ID

Path Insp Rec #

nnnnnnnn

Link to PKPATH.PI_ID

Long Integer

PC_PROB_CD

Problem

nnn

Problem

Integer

PC_PROB_TY

Problem Text

25x

Problem Text

Text

PC_RAT_CD

Rating

nnn

Rating

Integer

PC_RAT_TY

Rating Text

25x

Rating Text

Text

PC_REC_NO

Record No

nnnn

Record No.

Integer

PC_REPAIR

Repaired

 

Repaired

Boolean

PC_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

PC_STYPE_CD

Sub Type

nnn

Sub Type

Integer

PC_STYPE_TY

GIS Sub Type

25x

Sub Type Text

Text

PC_X

X Coordinate

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

PC_Y

Y Coordinate

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double