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. |