Asset Meter Reading History

The Asset Meter Reading History view object contains information about the meters for asset that are used throughout the asset life cycle management. The meters reading contains information to define the maintenance forecast for assets.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseMeterReadingExtractPVO

Primary Keys : MeterReadingId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AttributeCategory Context name for the meter reading descriptive flexfield.
CanceledFlag Value the indicates that the meter reading is canceled. A meter reading may be auto canceled when the user is trying to correct an earlier reading.
Comments This column is reserved for the user to enter free form comments. The field used to capture any notes while the reading is being captured.
CorpCurrencyCode This is the corporate currency code for the extensibility of the meter reading.
CreatedBy User who created the meter reading record.
CreationDate Date and time when the user created the meter reading record.
CurcyConvRateType The currency conversion rate type for extensibility of the meter reading.
CurrencyCode The currency code for the extensibility of the meter reading.
DisabledFlag Value that indicates whether the meter reading is disabled by a functional user.
DisplayedValue Numeric reading value displayed in the user interface after computing the value the user entered.
ExtnAttributeChar001 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar002 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar003 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar004 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar005 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar006 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar007 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar008 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar009 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar010 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar011 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar012 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar013 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar014 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar015 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar016 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar017 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar018 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar019 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar020 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar021 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar022 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar023 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar024 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar025 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar026 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar027 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar028 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar029 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar030 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar031 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar032 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar033 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar034 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar035 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar036 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar037 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar038 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar039 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar040 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar041 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar042 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar043 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar044 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar045 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar046 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar047 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar048 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar049 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar050 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar051 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar052 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar053 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar054 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar055 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar056 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar057 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar058 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar059 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar060 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar061 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar062 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar063 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar064 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar065 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar066 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar067 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar068 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar069 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar070 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar071 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar072 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar073 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar074 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar075 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar076 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar077 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar078 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar079 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar080 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar081 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar082 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar083 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar084 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar085 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar086 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar087 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar088 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar089 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar090 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar091 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar092 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar093 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar094 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar095 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar096 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar097 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar098 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar099 Character segment for the Meter Reading Flexfield.
ExtnAttributeChar100 Character segment for the Meter Reading Flexfield.
ExtnAttributeClob001 CLOB segment for the Meter Reading Flexfield.
ExtnAttributeClob002 CLOB segment for the Meter Reading Flexfield.
ExtnAttributeClob003 CLOB segment for the Meter Reading Flexfield.
ExtnAttributeClob004 CLOB segment for the Meter Reading Flexfield.
ExtnAttributeClob005 CLOB segment for the Meter Reading Flexfield.
ExtnAttributeNumber001 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber002 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber003 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber004 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber005 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber006 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber007 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber008 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber009 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber010 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber011 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber012 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber013 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber014 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber015 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber016 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber017 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber018 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber019 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber020 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber021 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber022 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber023 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber024 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber025 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber026 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber027 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber028 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber029 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber030 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber031 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber032 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber033 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber034 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber035 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber036 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber037 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber038 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber039 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber040 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber041 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber042 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber043 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber044 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber045 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber046 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber047 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber048 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber049 Number segment for the Meter Reading Flexfield.
ExtnAttributeNumber050 Number segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp001 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp002 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp003 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp004 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp005 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp006 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp007 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp008 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp009 Date and Time segment for the Meter Reading Flexfield.
ExtnAttributeTimestamp010 Date and Time segment for the Meter Reading Flexfield.
InitialFlag Value that indicates if the reading entered is created automatically based on the initial reading value set at the meter instance or meter definition.
JobDefinitionName Name of the job that created or most recently updated the row for the meter reading record. This is populated through Enterprise Service Scheduler.
JobDefinitionPackage Package name of the job that created or most recently updated the row for the meter reading record. This is populated through Enterprise Service Scheduler.
LastUpdateDate Date and time when the user most recently updated the meter reading record.
LastUpdateLogin Session login associated with the user who most recently updated the meter reading record.
LastUpdatedBy User who most recently updated the meter reading record.
MeterId Value that uniquely identifies the Meter Record. This is a primary key for the Asset Meter Reading History View Object.
MeterReadingId Value that uniquely identifies the Meter Reading Record. This is a primary key for the Asset Meter Reading History view object.
ModifiedFlag Indicates whether or not the meter reading was edited by the user.
NetValue This is an application- generated value. This value will be equal to the new reading typically, plus the net of the most recent reading. In addition, there are some different formulas involved to compute this value too.
ObjectVersionNumber Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ReadingDate Reading date and time when the reading is captured for the meter reading record.
ReadingNetChange This is an application- generated value. The reading net change is equal to the new reading minus the net of the most recent reading typically. Additionally, there are different formulas involved to compute this value .
ReadingTypeCode This value is captured when the reading the meter that has the meter reading type of both absolute or change. Else the user must say whether the value is absolute or change at the time when the reading is captured.
ReadingValue This is the numeric reading value captured for the meter reading record.
ReferenceReadingId This value is generated when the readings are auto-created by the application based on a reading that's auto canceled. The auto-canceled reading reference identifier is persisted here.
RequestId Request Identifier of the job that created or most recently updated the row. This is populated through Enterprise Service Scheduler.
ResetFlag Value that indicates whether the reading was created as a result of a meter reset.
RolloverFlag Value that indicates whether the reading was created as a result of the rollover settings in the meter instance or meter definition.
WorkOrderId This value is the work order where this meter reading is captured upon completion of the work order.