Work Water Loss
Field Name |
Caption |
Mask |
Description |
Field Type |
LO_AREA_CD |
Area |
|
Area |
Small Integer |
LO_AREA_TY |
Area Text |
30x |
Area Text |
String |
LO_BMP_CD |
BMP Type |
nnn |
BMP Type |
Integer |
LO_BMP_TY |
BMP Type Text |
25x |
BMP Type Text |
Text |
LO_COMMENT1 |
Long Note |
|
Long Note |
Memo |
LO_CRT_BY |
Created By |
25x |
Created By |
Text |
LO_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
LO_DADDR1 |
Driver Addr 1 |
75x |
Driver Address 1 |
Text |
LO_DADDR2 |
Driver Addr 2 |
75x |
Driver Address 2 |
Text |
LO_DCCOLOR |
Car Color |
30x |
Driver Car Color |
Text |
LO_DCHL_CD |
DeChlorination |
nnn |
DeChlorination |
Integer |
LO_DCHL_TY |
DeChlorination Text |
30x |
DeChlorination Text |
Text |
LO_DCMAKE |
Car Make |
50x |
Driver Car Make |
Text |
LO_DCMODEL |
Car Model |
50x |
Driver Car Model |
Text |
LO_DCOMP |
Driver Company |
75x |
Driver Company |
Text |
LO_DCYEAR |
Car Year |
4x |
Driver Car Year |
Text |
LO_DEMAIL |
Driver email |
150x |
Driver email |
Text |
LO_DIST_CD |
District |
nnn |
District |
Integer |
LO_DIST_TY |
District Text |
25x |
District Text |
Text |
LO_DLIC_ST |
Driver License State |
2x |
Driver License State |
Text |
LO_DLICENSE |
Driver License # |
30x |
Driver License # |
Text |
LO_DNAME |
Driver's Name |
40x |
Driver Contact Name |
Text |
LO_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
LO_DPHONE1 |
Driver Phone 1 |
20x |
Driver Phone 1 |
Text |
LO_DPHONE2 |
Driver Phone 2 |
20x |
Driver Phone 2 |
Text |
LO_EMP_CD |
Employee |
20x |
Employee |
Text |
LO_EMP_TY |
Employee Text |
40x |
Employee Text |
Text |
LO_EXPI_DT |
Expiration Date |
mm/dd/yyyy |
License Expiration Date |
Date/Time |
LO_GPD |
GPD |
-nnnnnnnn.nn |
Gallons Per Day |
Double |
LO_IADDR1 |
Insur Addr 1 |
75x |
Insurance Address 1 |
Text |
LO_IADDR2 |
Insur Addr 2 |
75x |
Insurance Address 2 |
Text |
LO_ICOMP |
Insurance Comp |
75x |
Insurance Company |
Text |
LO_ID |
Water Loss Rec # |
nnnnnnnn |
Water Loss Rec ID |
Long Integer |
LO_IEMAIL |
Insur email |
150x |
Insurance email |
Text |
LO_INAME |
Insur Contact Name |
40x |
Insurance Contact Name |
Text |
LO_INCI_DT |
Incident Date |
mm/dd/yyyy |
Incident Date |
Date/Time |
LO_INCI_TM |
Incident Time |
hh:mm am |
Incident Time |
Date/Time |
LO_IPHONE1 |
Insur Phone 1 |
20x |
Insurance Phone 1 |
Text |
LO_IPHONE2 |
Insur Phone 2 |
20x |
Insurance Phone 2 |
Text |
LO_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
LO_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
LO_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
LO_NUM |
Water Loss Number |
20x |
Water Loss Number |
Text |
LO_PADDR1 |
Police Addr 1 |
75x |
Police Address 1 |
Text |
LO_PADDR2 |
Police Addr 2 |
75x |
Police Address 2 |
Text |
LO_PAGE_CD |
Police Agency |
nnn |
Police Agency |
Integer |
LO_PAGE_TY |
Police Agency Text |
25x |
Police Agency Text |
Text |
LO_PBADGE |
Badge Number |
30x |
Police Officer Badge Number |
Text |
LO_PEMAIL |
Police email |
150x |
Police Email |
Text |
LO_PH |
pH Unit |
-nnnnnnnn.nn |
pH Unit |
Double |
LO_PINCID |
Incident Report # |
30x |
Police Incident Report # |
Text |
LO_PLATE |
Car Plate |
15x |
Car Plate |
Text |
LO_POFFICR |
Police Officer |
40x |
Police Officer |
Text |
LO_PPHONE1 |
Police Phone 1 |
20x |
Police Phone 1 |
Text |
LO_PPHONE2 |
Police Phone 2 |
20x |
Police Phone 2 |
Text |
LO_PPHONE3 |
Police Phone 3 |
20x |
Police Phone3 |
Text |
LO_RECYC |
Recycled System |
|
Recycled Water System |
Boolean |
LO_REPORTR |
Other Reporter |
40x |
Other Reporter |
Text |
LO_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
LO_STORM |
Storm Drain |
40x |
Storm Drain |
Text |
LO_TCHLOR |
Total Chlorine |
-nnnnnnnn.nn |
Total Chlorine |
Double |
LO_TDS |
TDS |
-nnnnnnnn.nn |
Total Dissolved Solids |
Double |
LO_TYPE_CD |
Loss Type |
|
Loss Type |
Small Integer |
LO_TYPE_TY |
Loss Type Text |
30x |
Loss Type Text |
String |
LO_US16_DT |
User 16 |
mm/dd/yyyy |
User 16 Date |
Date/Time |
LO_US17_DT |
User 17 |
mm/dd/yyyy |
User 17 Date |
Date/Time |
LO_US18_DT |
User 18 |
mm/dd/yyyy |
User 18 Date |
Date/Time |
LO_US19_DT |
User 19 |
mm/dd/yyyy |
User 19 Date |
Date/Time |
LO_US19_TM |
User 19 Time |
hh:mm am |
User 19 Time |
Date/Time |
LO_US20_DT |
User 20 |
mm/dd/yyyy |
User 20 Date |
Date/Time |
LO_US20_TM |
User 20 Time |
hh:mm am |
User 20 Time |
Date/Time |
LO_USER10 |
User 10 |
30x |
User 10 |
Text |
LO_USER11 |
User 11 |
-nnnnnnnn.nn |
User 11 |
Double |
LO_USER12 |
User 12 |
-nnnnnnnn.nn |
User 12 |
Double |
LO_USER13 |
User 13 |
-nnnnnnnn.nn |
User 13 |
Double |
LO_USER14 |
User 14 |
-nnnnnnnn.nn |
User 14 |
Double |
LO_USER15 |
User 15 |
-nnnnnnnn.nn |
User 15 |
Double |
LO_USER21 |
User 21 |
|
User 21 |
Boolean |
LO_USER22 |
User 22 |
|
User 22 |
Boolean |
LO_USER23 |
User 23 |
|
User 23 |
Boolean |
LO_USER24 |
User 24 |
|
User 24 |
Boolean |
LO_USER25 |
User 25 |
|
User 25 |
Boolean |
LO_USER26 |
User 26 |
|
User 26 |
Boolean |
LO_USER27 |
User 27 |
|
User 27 |
Boolean |
LO_USER28 |
User 28 |
|
User 28 |
Boolean |
LO_USER6 |
User 6 |
30x |
User 6 |
Text |
LO_USER7 |
User 7 |
30x |
User 7 |
Text |
LO_USER8 |
User 8 |
30x |
User 8 |
Text |
LO_USER9 |
User 9 |
30x |
User 9 |
Text |
LO_USR1_CD |
User 1 |
nnn |
User 1 |
Integer |
LO_USR1_TY |
User 1 Text |
25x |
User 1 Text |
Text |
LO_USR2_CD |
User 2 |
nnn |
User 2 |
Integer |
LO_USR2_TY |
User 2 Text |
25x |
User 2 Text |
Text |
LO_USR3_CD |
User 3 |
nnn |
User 3 |
Integer |
LO_USR3_TY |
User 3 Text |
25x |
User 3 Text |
Text |
LO_USR4_CD |
User 4 |
nnn |
User 4 |
Integer |
LO_USR4_TY |
User 4 Text |
25x |
User 4 Text |
Text |
LO_USR5_CD |
User 5 |
nnn |
User 5 |
Integer |
LO_USR5_TY |
User 5 Text |
25x |
User 5 Text |
Text |
LO_WADDR1 |
Witness Addr 1 |
75x |
Witness Address 1 |
Text |
LO_WADDR2 |
Witness Addr 2 |
75x |
Witness Address 2 |
Text |
LO_WCOMP |
Witness Company |
75x |
Witness Company |
Text |
LO_WEMAIL |
Witness email |
150x |
Witness email |
Text |
LO_WLOSS |
Water Loss (gallons) |
-nnnnnnnn.nn |
Water Loss (gallons) |
Double |
LO_WL_ID |
Water Loss Record Number |
nnnnnnnn |
Long Integer |
|
LO_WNAME |
Witness's Name |
40x |
Witness Contact Name |
Text |
LO_WPHONE1 |
Witness Phone 1 |
20x |
Witness Phone 1 |
Text |
LO_WPHONE2 |
Witness Phone 2 |
20x |
Witness Phone 2 |
Text |
LO_WTEMP |
Water Temp |
-nnnnnnnn.nn |
Water Temperature |
Double |