Water Loss
Field Name |
Caption |
Mask |
Description |
Field Type |
WL_ADDR1 |
Address 1 |
40x |
Address 1 |
Text |
WL_ADDR2 |
Address 2 |
40x |
Address 2 |
Text |
WL_ADDR3 |
Address 3 |
40x |
Address 3 |
Text |
WL_ADR_B2 |
Street Post Bldg No |
8x |
Street Post Building No |
Text |
WL_ADR_BDG |
Address |
nnnnnn |
Address: Building number |
Long Integer |
WL_ADR_DIR |
Street Direction |
2x |
Street Direction |
Text |
WL_ADR_PT |
Street Prefix Type |
5x |
Street Prefix |
Text |
WL_ADR_SFX |
Street Suffix |
5x |
Street Suffix |
Text |
WL_ADR_STR |
Street Name |
50x |
Street Name |
Text |
WL_ADR_TY |
Street Type |
5x |
Street Type |
Text |
WL_ADR2B2 |
Street Post Bldg No 2 |
8x |
Street Post Building No 2 |
Text |
WL_ADR2BDG |
Cross Street |
nnnnnn |
Address 2 |
Long Integer |
WL_ADR2DIR |
Street Dir 2 |
2x |
Street Direction 2 |
Text |
WL_ADR2PT |
Street Prefix 2 |
5x |
Street Prefix 2 |
Text |
WL_ADR2SFX |
Street Suffix 2 |
5x |
Street Suffix 2 |
Text |
WL_ADR2STR |
Street Name 2 |
50x |
Street Name 2 |
Text |
WL_ADR2TY |
Street Type 2 |
5x |
Street Type 2 |
Text |
WL_AGF_CD |
AutoGenerated From |
nnn |
AutoGenerated From |
Integer |
WL_AGF_TY |
AutoGenerated From Text |
25x |
1-Hydrant Flush, 2-Additional Hydrant Flush, 3-Hydrant Test, 4-Water Main Break, 5-WO Water Loss |
String |
WL_AMT_DUE |
Amount Due |
nnnnnnnn.nn |
Amount Due |
Double |
WL_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
WL_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
WL_BADDR1 |
Bill Address 1 |
40x |
Billing Address 1 |
Text |
WL_BADDR2 |
Bill Address 2 |
40x |
Biling Address 2 |
Text |
WL_BADDR3 |
Bill Address 3 |
40x |
Billing Address 3 |
Text |
WL_BILLWO |
Billable WO |
|
Billable WO |
Boolean |
WL_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
WL_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
WL_CARLIC |
Car Plate # |
30x |
License Plate # |
Text |
WL_CARMAKE |
Make of Car |
30x |
Make of Car |
Text |
WL_CAUS_CD |
Cause |
nnn |
Cause |
Integer |
WL_CAUS_TY |
Cause Text |
25x |
Cause Text |
Text |
WL_COMPANY |
Company |
30x |
Company Name |
Text |
WL_CPHONE |
Cell Phone |
20x |
Cell Phone |
Text |
WL_CRT_BY |
Created By |
25x |
Created By |
Text |
WL_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
WL_DAMAGE |
Damage |
|
Damage |
Boolean |
WL_DECH_CD |
DeChlorination |
nnn |
DeChlorination |
Integer |
WL_DECH_TY |
DeChlorination Text |
25x |
DeChlorination Text |
Text |
WL_DIST_CD |
District |
nnn |
District |
Integer |
WL_DIST_TY |
District Text |
25x |
District Text |
Text |
WL_DOC_FLG |
Document Available |
|
Doc Available |
Boolean |
WL_DRLIC |
Driver's Lic # |
30x |
Driver's License # |
Text |
WL_EDN_CD |
Erosion DS |
nnn |
Erosion Downstream |
Integer |
WL_EDN_TY |
Erosion DS Text |
25x |
Erosion Downstream Text |
Text |
WL_EMPL |
Employee |
30x |
Employee |
Text |
WL_ESTLOSS |
Est Water Loss |
nnnnnnnn. |
Est Water Loss |
Double |
WL_EUP_CD |
Erosion US |
nnn |
Erosion Upstream |
Integer |
WL_EUP_TY |
Erosion US Text |
25x |
Erosion Upstream Text |
Text |
WL_FLOW |
Flow |
nnnnnnnn. |
Flow |
Double |
WL_HPHONE |
Home Phone |
20x |
Home Phone |
Text |
WL_ID |
Water Loss Rec # |
nnnnnnnn |
|
Long Integer |
WL_INMAP |
|
|
In Map Flag |
Boolean |
WL_LOCAT |
Location |
80x |
Location |
Text |
WL_LOCATE |
Locate Needed |
|
Locate Requested |
Boolean |
WL_LOSS_DT |
Date |
mm/dd/yyyy |
Date |
Date/Time |
WL_LOSS_TM |
Time |
hh:mm am |
Time |
Date/Time |
WL_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
WL_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Date Modified |
Date/Time |
WL_MOD_TM |
Last Modified Time |
hh:mm am |
Last Time Modified |
Date/Time |
WL_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
WL_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
WL_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
WL_NUMBER |
Loss Number |
50x |
Number |
Text |
WL_OFFICER |
Officer's Name |
30x |
Officer's Name |
Text |
WL_PH |
pH |
nn.n |
pH |
Double |
WL_POLI_CD |
Police Agency |
nnn |
Police Agency |
Integer |
WL_POLI_TY |
Police Agency Text |
25x |
Police Agency Text |
Text |
WL_POLREPT |
Police Report # |
30x |
Police Report # |
Text |
WL_REAS_CD |
Reason |
nnn |
Reason |
Integer |
WL_REAS_TY |
Reason Text |
25x |
Reason Text |
Text |
WL_RESPON |
Party Responsible |
30x |
Responsible Person |
Text |
WL_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
WL_SDN_CD |
Sedimentation DS |
nnn |
Sedimentation Downstream |
Integer |
WL_SDN_TY |
Sedimentation DS Text |
25x |
Sedimentation Downstream Text |
Text |
WL_STDRAIN |
Storm Location |
80x |
Storm Drain Location |
Text |
WL_STYPE_CD |
GIS SubType |
nnn |
GIS SubType |
Integer |
WL_STYPE_TY |
GIS SubType Text |
25X |
GIS SubType Text |
Text |
WL_SUP_CD |
Sedimentation US |
nnn |
Sedimentation Upstream |
Integer |
WL_SUP_TY |
Sedimentation US Text |
25x |
Sedimentation Upstream Text |
Text |
WL_TDN_CD |
Turbidity DS |
nnn |
Turbidity Downstream |
Integer |
WL_TDN_TY |
Turbidity DS Text |
25x |
Turbidity Downstream Text |
Text |
WL_TDS |
Total Dissolved Solids |
nnn.n |
Total Dissolved Solids |
Double |
WL_TEMP |
Water Temperature |
-nnn.n |
Water Temperature |
Double |
WL_TRC |
Total Chlorine |
nnn.n |
Total Residual Chlorine |
Double |
WL_TUP_CD |
Turbidity US |
nnn |
Turbidity Upstream |
Integer |
WL_TUP_TY |
Turbidity US Text |
25x |
Turbidity Upstream Text |
Text |
WL_TYPE_CD |
Loss Type |
nnn |
Loss Type |
Integer |
WL_TYPE_TY |
Loss Type Text |
25x |
Loss Type Text |
Text |
WL_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
WL_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
WL_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
WL_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
WL_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
WL_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
WL_USER4 |
User 4 |
30x |
User 4 |
Text |
WL_USER5 |
User 5 |
30x |
User 5 |
Text |
WL_USER6 |
User 6 |
30x |
User 6 |
Text |
WL_USER7 |
User 7 |
-nnnnnnnnn.nn |
User 7 |
Double |
WL_USER8 |
User 8 |
-nnnnnnnnn.nn |
User 8 |
Double |
WL_USER9 |
User 9 |
-nnnnnnnnn.nn |
User 9 |
Double |
WL_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
WL_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
WL_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
WL_USER13 |
User 13 |
|
User 13 |
Boolean |
WL_USER14 |
User 14 |
|
User 14 |
Boolean |
WL_USER15 |
User 15 |
|
User 15 |
Boolean |
WL_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
WL_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
WL_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
WL_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
WL_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
WL_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
WL_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
WL_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
WL_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
WL_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
WL_USER21 |
User 21 |
50x |
User 21 |
String |
WL_USER22 |
User 22 |
50x |
User 22 |
String |
WL_USER23 |
User 23 |
50x |
User 23 |
String |
WL_USER24 |
User 24 |
50x |
User 24 |
String |
WL_USER25 |
User 25 |
50x |
User 25 |
String |
WL_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
WL_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
WL_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
WL_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
WL_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
WL_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
WL_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
WL_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
WL_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
WL_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
WL_USER36 |
User 36 |
|
User 36 |
Boolean |
WL_USER37 |
User 37 |
|
User 37 |
Boolean |
WL_USER38 |
User 38 |
|
User 38 |
Boolean |
WL_USER39 |
User 39 |
|
User 39 |
Boolean |
WL_USER40 |
User 40 |
|
User 40 |
Boolean |
WL_WO_NUMBER |
WO Rec Number |
25x |
Work Order Number |
Text |
WL_WPHONE |
Work Phone |
20x |
Work Phone |
Text |