PKMETWR

Park Water Meter Reading/Consumption History

Field Name

Caption

Mask

Description

Field Type

MW_APRAC

April Actual Consumption in inches

nnnnnnnn.nn

April Actual Consumption in inches

Double

MW_APRACC

April Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

April Actual Consumption in Ccf (100 cf)

Double

MW_APRAE

April Actual Expenses

nnnnnnnn.nn

April Actual Expenses

Double

MW_APRAG

April Actual Gallons

nnnnnnnn.nn

April Actual Gallons

Double

MW_APRLW

April Local Weather Station Estimate in inches

nnnnnnnn.nn

April Local Weather Station Estimate in inches

Double

MW_APRTADC

April Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

April Target/Actual Difference in Ccf (100 cf)

Double

MW_APRTADD

April Target/Actual Difference in Dollars

nnnnnnnn.nn

April Target/Actual Difference in Dollars

Double

MW_APRTADI

April Target/Actual Consumption Difference in inches

nnnnnnnn.nn

April Target/Actual Consumption Difference in inches

Double

MW_APRTADG

April Target/Actual Difference in Gallons

nnnnnnnn.nn

April Target/Actual Difference in Gallons

Double

MW_APRTB

April Target Budget

nnnnnnnn.nn

April Target Budget

Double

MW_APRTC

April Target Consumption in inches

nnnnnnnn.nn

April Target Consumption in inches

Double

MW_APRTCC

April Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

April Target Consumption in Ccf (100 cf)

Double

MW_APRTG

April Target Gallons

nnnnnnnn.nn

April Target Gallons

Double

MW_AUGAC

August Actual Consumption in inches

nnnnnnnn.nn

August Actual Consumption in inches

Double

MW_AUGACC

August Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

August Actual Consumption in Ccf (100 cf)

Double

MW_AUGAE

August Actual Expenses

nnnnnnnn.nn

August Actual Expenses

Double

MW_AUGAG

August Actual Gallons

nnnnnnnn.nn

August Actual Gallons

Double

MW_AUGLW

August Local Weather Station Estimate in inches

nnnnnnnn.nn

August Local Weather Station Estimate in inches

Double

MW_AUGTADC

August Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

August Target/Actual Difference in Ccf (100 cf)

Double

MW_AUGTADD

August Target/Actual Difference in Dollars

nnnnnnnn.nn

August Target/Actual Difference in Dollars

Double

MW_AUGTADG

August Target/Actual Difference in Gallons

nnnnnnnn.nn

August Target/Actual Difference in Gallons

Double

MW_AUGTADI

August Target/Actual Consumption Difference in inches

nnnnnnnn.nn

August Target/Actual Consumption Difference in inches

Double

MW_AUGTB

August Target Budget

nnnnnnnn.nn

August Target Budget

Double

MW_AUGTC

August Target Consumption in inches

nnnnnnnn.nn

August Target Consumption in inches

Double

MW_AUGTCC

August Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

August Target Consumption in Ccf (100 cf)

Double

MW_AUGTG

August Target Gallons

nnnnnnnn.nn

August Target Gallons

Double

MW_CRT_BY

Created By

25x

Created By

String

MW_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

MW_DECAC

December Actual Consumption in inches

nnnnnnnn.nn

December Actual Consumption in inches

Double

MW_DECACC

December Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

December Actual Consumption in Ccf (100 cf)

Double

MW_DECAE

December Actual Expenses

nnnnnnnn.nn

December Actual Expenses

Double

MW_DECAG

December Actual Gallons

nnnnnnnn.nn

December Actual Gallons

Double

MW_DECLW

December Local Weather Station Estimate in inches

nnnnnnnn.nn

December Local Weather Station Estimate in inches

Double

MW_DECTADC

December Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

December Target/Actual Difference in Ccf (100 cf)

Double

MW_DECTADD

December Target/Actual Difference in Dollars

nnnnnnnn.nn

December Target/Actual Difference in Dollars

Double

MW_DECTADI

December Target/Actual Consumption Difference in inches

nnnnnnnn.nn

December Target/Actual Consumption Difference in inches

Double

MW_DECTADG

December Target/Actual Difference in Gallons

nnnnnnnn.nn

December Target/Actual Difference in Gallons

Double

MW_DECTB

December Target Budget

nnnnnnnn.nn

December Target Budget

Double

MW_DECTC

December Target Consumption in inches

nnnnnnnn.nn

December Target Consumption in inches

Double

MW_DECTCC

December Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

December Target Consumption in Ccf (100 cf)

Double

MW_DECTG

December Target Gallons

nnnnnnnn.nn

December Target Gallons

Double

MW_DOC_FLG

Document Available

 

Document Available

Boolean

MW_FEBAC

February Actual Consumption in inches

nnnnnnnn.nn

February Actual Consumption in inches

Double

MW_FEBACC

February Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

February Actual Consumption in Ccf (100 cf)

Double

MW_FEBAE

February Actual Expenses

nnnnnnnn.nn

February Actual Expenses

Double

MW_FEBAG

February Actual Gallons

nnnnnnnn.nn

February Actual Gallons

Double

MW_FEBLW

February Local Weather Station Estimate in inches

nnnnnnnn.nn

February Local Weather Station Estimate in inches

Double

MW_FEBTADC

February Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

February Target/Actual Difference in Ccf (100 cf)

Double

MW_FEBTADD

February Target/Actual Difference in Dollars

nnnnnnnn.nn

February Target/Actual Difference in Dollars

Double

MW_FEBTADG

February Target/Actual Difference in Gallons

nnnnnnnn.nn

February Target/Actual Difference in Gallons

Double

MW_FEBTADI

February Target/Actual Consumption Difference in inches

nnnnnnnn.nn

February Target/Actual Consumption Difference in inches

Double

MW_FEBTB

February Target Budget

nnnnnnnn.nn

February Target Budget

Double

MW_FEBTC

February Target Consumption in inches

nnnnnnnn.nn

February Target Consumption in inches

Double

MW_FEBTCC

February Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

February Target Consumption in Ccf (100 cf)

Double

MW_FEBTG

February Target Gallons

nnnnnnnn.nn

February Target Gallons

Double

MW_ID

 

nnnnnnnn

Water Meter Consumption History Rec #

Long Integer

MW_JANAC

January Actual Consumption in inches

nnnnnnnn.nn

January Actual Consumption in inches

Double

MW_JANACC

January Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

January Actual Consumption in Ccf (100 cf)

Double

MW_JANAE

January Actual Expenses

nnnnnnnn.nn

January Actual Expenses

Double

MW_JANAG

January Actual Gallons

nnnnnnnn.nn

January Actual Gallons

Double

MW_JANLW

January Local Weather Station Estimate in inches

nnnnnnnn.nn

January Local Weather Station Estimate in inches

Double

MW_JANTADC

January Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

January Target/Actual Difference in Ccf (100 cf)

Double

MW_JANTADD

January Target/Actual Difference in Dollars

nnnnnnnn.nn

January Target/Actual Difference in Dollars

Double

MW_JANTADG

January Target/Actual Difference in Gallons

nnnnnnnn.nn

January Target/Actual Difference in Gallons

Double

MW_JANTADI

January Target/Actual Consumption Difference in inches

nnnnnnnn.nn

January Target/Actual Consumption Difference in inches

Double

MW_JANTB

January Target Budget

nnnnnnnn.nn

January Target Budget

Double

MW_JANTC

January Target Consumption in inches

nnnnnnnn.nn

January Target Consumption in inches

Double

MW_JANTCC

January Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

January Target Consumption in Ccf (100 cf)

Double

MW_JANTG

January Target Gallons

nnnnnnnn.nn

January Target Gallons

Double

MW_JULAC

July Actual Consumption in inches

nnnnnnnn.nn

July Actual Consumption in inches

Double

MW_JULACC

July Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

July Actual Consumption in Ccf (100 cf)

Double

MW_JULAE

July Actual Expenses

nnnnnnnn.nn

July Actual Expenses

Double

MW_JULAG

July Actual Gallons

nnnnnnnn.nn

July Actual Gallons

Double

MW_JULLW

July Local Weather Station Estimate in inches

nnnnnnnn.nn

July Local Weather Station Estimate in inches

Double

MW_JULTADC

July Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

July Target/Actual Difference in Ccf (100 cf)

Double

MW_JULTADD

July Target/Actual Difference in Dollars

nnnnnnnn.nn

July Target/Actual Difference in Dollars

Double

MW_JULTADG

July Target/Actual Difference in Gallons

nnnnnnnn.nn

July Target/Actual Difference in Gallons

Double

MW_JULTADI

July Target/Actual Consumption Difference in inches

nnnnnnnn.nn

July Target/Actual Consumption Difference in inches

Double

MW_JULTB

July Target Budget

nnnnnnnn.nn

July Target Budget

Double

MW_JULTC

July Target Consumption in inches

nnnnnnnn.nn

July Target Consumption in inches

Double

MW_JULTCC

July Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

July Target Consumption in Ccf (100 cf)

Double

MW_JULTG

July Target Gallons

nnnnnnnn.nn

July Target Gallons

Double

MW_JUNAC

June Actual Consumption in inches

nnnnnnnn.nn

June Actual Consumption in inches

Double

MW_JUNACC

June Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

June Actual Consumption in Ccf (100 cf)

Double

MW_JUNAE

June Actual Expenses

nnnnnnnn.nn

June Actual Expenses

Double

MW_JUNAG

June Actual Gallons

nnnnnnnn.nn

June Actual Gallons

Double

MW_JUNLW

June Local Weather Station Estimate in inches

nnnnnnnn.nn

June Local Weather Station Estimate in inches

Double

MW_JUNTADC

June Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

June Target/Actual Difference in Ccf (100 cf)

Double

MW_JUNTADD

June Target/Actual Difference in Dollars

nnnnnnnn.nn

June Target/Actual Difference in Dollars

Double

MW_JUNTADG

June Target/Actual Difference in Gallons

nnnnnnnn.nn

June Target/Actual Difference in Gallons

Double

MW_JUNTADI

June Target/Actual Consumption Difference in inches

nnnnnnnn.nn

June Target/Actual Consumption Difference in inches

Double

MW_JUNTB

June Target Budget

nnnnnnnn.nn

June Target Budget

Double

MW_JUNTC

June Target Consumption in inches

nnnnnnnn.nn

June Target Consumption in inches

Double

MW_JUNTCC

June Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

June Target Consumption in Ccf (100 cf)

Double

MW_JUNTG

June Target Gallons

nnnnnnnn.nn

June Target Gallons

Double

MW_MARAC

March Actual Consumption in inches

nnnnnnnn.nn

March Actual Consumption in inches

Double

MW_MARACC

March Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

March Actual Consumption in Ccf (100 cf)

Double

MW_MARAE

March Actual Expenses

nnnnnnnn.nn

March Actual Expenses

Double

MW_MARAG

March Actual Gallons

nnnnnnnn.nn

March Actual Gallons

Double

MW_MARLW

March Local Weather Station Estimate in inches

nnnnnnnn.nn

March Local Weather Station Estimate in inches

Double

MW_MARTADC

March Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

March Target/Actual Difference in Ccf (100 cf)

Double

MW_MARTADD

March Target/Actual Difference in Dollars

nnnnnnnn.nn

March Target/Actual Difference in Dollars

Double

MW_MARTADG

March Target/Actual Difference in Gallons

nnnnnnnn.nn

March Target/Actual Difference in Gallons

Double

MW_MARTADI

March Target/Actual Consumption Difference in inches

nnnnnnnn.nn

March Target/Actual Consumption Difference in inches

Double

MW_MARTB

March Target Budget

nnnnnnnn.nn

March Target Budget

Double

MW_MARTC

March Target Consumption in inches

nnnnnnnn.nn

March Target Consumption in inches

Double

MW_MARTCC

March Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

March Target Consumption in Ccf (100 cf)

Double

MW_MARTG

March Target Gallons

nnnnnnnn.nn

March Target Gallons

Double

MW_MAYAC

May Actual Consumption in inches

nnnnnnnn.nn

May Actual Consumption in inches

Double

MW_MAYACC

May Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

May Actual Consumption in Ccf (100 cf)

Double

MW_MAYAE

May Actual Expenses

nnnnnnnn.nn

May Actual Expenses

Double

MW_MAYAG

May Actual Gallons

nnnnnnnn.nn

May Actual Gallons

Double

MW_MAYLW

May Local Weather Station Estimate in inches

nnnnnnnn.nn

May Local Weather Station Estimate in inches

Double

MW_MAYTADC

May Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

May Target/Actual Difference in Ccf (100 cf)

Double

MW_MAYTADD

May Target/Actual Difference in Dollars

nnnnnnnn.nn

May Target/Actual Difference in Dollars

Double

MW_MAYTADG

May Target/Actual Difference in Gallons

nnnnnnnn.nn

May Target/Actual Difference in Gallons

Double

MW_MAYTADI

May Target/Actual Consumption Difference in inches

nnnnnnnn.nn

May Target/Actual Consumption Difference in inches

Double

MW_MAYTB

May Target Budget

nnnnnnnn.nn

May Target Budget

Double

MW_MAYTC

May Target Consumption in inches

nnnnnnnn.nn

May Target Consumption in inches

Double

MW_MAYTCC

May Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

May Target Consumption in Ccf (100 cf)

Double

MW_MAYTG

May Target Gallons

nnnnnnnn.nn

May Target Gallons

Double

MW_MOD_BY

Last Modified By

25x

Last Modified By

String

MW_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

MW_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

MW_MT_ID

Meter Rec #

nnnnnnnn

Link to PKMETER.MT_ID

Long Integer

MW_NOVAC

November Actual Consumption in inches

nnnnnnnn.nn

November Actual Consumption in inches

Double

MW_NOVACC

November Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

November Actual Consumption in Ccf (100 cf)

Double

MW_NOVAE

November Actual Expenses

nnnnnnnn.nn

November Actual Expenses

Double

MW_NOVAG

November Actual Gallons

nnnnnnnn.nn

November Actual Gallons

Double

MW_NOVLW

November Local Weather Station Estimate in inches

nnnnnnnn.nn

November Local Weather Station Estimate in inches

Double

MW_NOVTADC

November Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

November Target/Actual Difference in Ccf (100 cf)

Double

MW_NOVTADD

November Target/Actual Difference in Dollars

nnnnnnnn.nn

November Target/Actual Difference in Dollars

Double

MW_NOVTADG

November Target/Actual Difference in Gallons

nnnnnnnn.nn

November Target/Actual Difference in Gallons

Double

MW_NOVTADI

November Target/Actual Consumption Difference in inches

nnnnnnnn.nn

November Target/Actual Consumption Difference in inches

Double

MW_NOVTB

November Target Budget

nnnnnnnn.nn

November Target Budget

Double

MW_NOVTC

November Target Consumption in inches

nnnnnnnn.nn

November Target Consumption in inches

Double

MW_NOVTCC

November Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

November Target Consumption in Ccf (100 cf)

Double

MW_NOVTG

November Target Gallons

nnnnnnnn.nn

November Target Gallons

Double

MW_OCTAC

October Actual Consumption in inches

nnnnnnnn.nn

October Actual Consumption in inches

Double

MW_OCTACC

October Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

October Actual Consumption in Ccf (100 cf)

Double

MW_OCTAE

October Actual Expenses

nnnnnnnn.nn

October Actual Expenses

Double

MW_OCTAG

October Actual Gallons

nnnnnnnn.nn

October Actual Gallons

Double

MW_OCTLW

October Local Weather Station Estimate in inches

nnnnnnnn.nn

October Local Weather Station Estimate in inches

Double

MW_OCTTADC

October Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

October Target/Actual Difference in Ccf (100 cf)

Double

MW_OCTTADD

October Target/Actual Difference in Dollars

nnnnnnnn.nn

October Target/Actual Difference in Dollars

Double

MW_OCTTADG

October Target/Actual Difference in Gallons

nnnnnnnn.nn

October Target/Actual Difference in Gallons

Double

MW_OCTTADI

October Target/Actual Consumption Difference in inches

nnnnnnnn.nn

October Target/Actual Consumption Difference in inches

Double

MW_OCTTB

October Target Budget

nnnnnnnn.nn

October Target Budget

Double

MW_OCTTC

October Target Consumption in inches

nnnnnnnn.nn

October Target Consumption in inches

Double

MW_OCTTCC

October Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

October Target Consumption in Ccf (100 cf)

Double

MW_OCTTG

October Target Gallons

nnnnnnnn.nn

October Target Gallons

Double

MW_RATE

Water Rate

nnnnnnnn.nn

Water Rate

Double

MW_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

MW_SEPAC

September Actual Consumption in inches

nnnnnnnn.nn

September Actual Consumption in inches

Double

MW_SEPACC

September Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

September Actual Consumption in Ccf (100 cf)

Double

MW_SEPAE

September Actual Expenses

nnnnnnnn.nn

September Actual Expenses

Double

MW_SEPAG

September Actual Gallons

nnnnnnnn.nn

September Actual Gallons

Double

MW_SEPLW

September Local Weather Station Estimate in inches

nnnnnnnn.nn

September Local Weather Station Estimate in inches

Double

MW_SEPTADC

September Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

September Target/Actual Difference in Ccf (100 cf)

Double

MW_SEPTADD

September Target/Actual Difference in Dollars

nnnnnnnn.nn

September Target/Actual Difference in Dollars

Double

MW_SEPTADG

September Target/Actual Difference in Gallons

nnnnnnnn.nn

September Target/Actual Difference in Gallons

Double

MW_SEPTADI

September Target/Actual Consumption Difference in inches

nnnnnnnn.nn

September Target/Actual Consumption Difference in inches

Double

MW_SEPTB

September Target Budget

nnnnnnnn.nn

September Target Budget

Double

MW_SEPTC

September Target Consumption in inches

nnnnnnnn.nn

September Target Consumption in inches

Double

MW_SEPTCC

September Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

September Target Consumption in Ccf (100 cf)

Double

MW_SEPTG

September Target Gallons

nnnnnnnn.nn

September Target Gallons

Double

MW_YEAC

Year End Actual Consumption in inches

nnnnnnnn.nn

Year End Actual Consumption in inches

Double

MW_YEACC

Year End Actual Consumption in Ccf (100 cf)

nnnnnnnn.nn

Year End Actual Consumption in Ccf (100 cf)

Double

MW_YEAE

Year End Actual Expenses

nnnnnnnn.nn

Year End Actual Expenses

Double

MW_YEAG

Year End Actual Gallons

nnnnnnnn.nn

Year End Actual Gallons

Double

MW_YEAR

Year

nnn

Year

Integer

MW_YELW

Year End Local Weather Station Estimate in inches

nnnnnnnn.nn

Year End Local Weather Station Estimate in inches

Double

MW_YETADC

Year End Target/Actual Difference in Ccf (100 cf)

nnnnnnnn.nn

Year End Target/Actual Difference in Ccf (100 cf)

Double

MW_YETADD

Year End Target/Actual Difference in Dollars

nnnnnnnn.nn

Year End Target/Actual Difference in Dollars

Double

MW_YETADG

Year End Target/Actual Difference in Gallons

nnnnnnnn.nn

Year End Target/Actual Difference in Gallons

Double

MW_YETADI

Year End Target/Actual Consumption Difference in inches

nnnnnnnn.nn

Year End Target/Actual Consumption Difference in inches

Double

MW_YETB

Year End Target Budget

nnnnnnnn.nn

Year End Target Budget

Double

MW_YETC

Year End Target Consumption in inches

nnnnnnnn.nn

Year End Target Consumption in inches

Double

MW_YETCC

Year End Target Consumption in Ccf (100 cf)

nnnnnnnn.nn

Year End Target Consumption in Ccf (100 cf)

Double

MW_YETG

Year End Target Gallons

nnnnnnnn.nn

Year End Target Gallons

Double