Side Walk Inspection Problems
Field Name |
Caption |
Mask |
Description |
Field Type |
CQ_CR_ID |
SW Inspec Rec # |
nnnnnnnn |
Link to STCURBINSP.CR_ID |
Long Integer |
CQ_CRT_BY |
Created By |
25x |
Created By |
Text |
CQ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CQ_DIST |
Distance |
nnnnn.n |
Distance |
Double |
CQ_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
CQ_ID |
Curb Prob Rec # |
nnnnnnnn |
AutoID |
Long Integer |
CQ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CQ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CQ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CQ_NOTE |
Note |
200x |
Comment |
Text |
CQ_PROB_CD |
Problem |
nnn |
Problem |
Integer |
CQ_PROB_TY |
Problem Text |
25x |
Problem Text |
Text |
CQ_RATING |
Rating |
nn |
Rating |
Integer |
CQ_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CQ_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
CQ_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |