Side Walk Inspection Problems
Field Name |
Caption |
Mask |
Description |
Field Type |
WP_CRT_BY |
Created By |
25x |
Created By |
Text |
WP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
WP_DIST |
Distance |
nnnnn.n |
Distance |
Double |
WP_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
WP_ID |
Sidewalk Prob Rec # |
nnnnnnnn |
AutoID |
Long Integer |
WP_IMG_FLG |
|
|
Image Available |
Boolean |
WP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
WP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
WP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
WP_MOV_FLG |
|
|
Movie Available |
Boolean |
WP_NOTE |
Note |
200x |
Comment |
Text |
WP_PROB_CD |
Problem |
nnn |
Problem |
Integer |
WP_PROB_TY |
Problem Text |
25x |
Problem Text |
Text |
WP_RATING |
Rating |
nn |
Rating |
Integer |
WP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
WP_SK_ID |
SW Inspec Rec # |
nnnnnnnn |
Long Integer |
|
WP_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
WP_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |