Installed Base Asset Meter
The Installed Base Asset Meter view object contains information about the meters for asset that are used throughout the asset lifecycle management. A meter template holds all the physical attributes of the instantiated meter.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseMeterExtractPVO
Primary Keys : MeterId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActiveEndDate | Active end date and time when the user end dated the meter template record. |
| ActiveStartDate | Active start date and time when the user created the meter template record. |
| AllowInMaintProgramFlag | Indicates whether any meter created from this template can be included in the maintenance program to be able to specify a usage based forecast generation. |
| AttributeCategory | Context name for the meter template descriptive flexfield. |
| AvgDailyUtilizationRate | The average daily utilization rate that's computed at the capture of every reading. |
| CorpCurrencyCode | Indicates the corporate currency code for extensibility. |
| CreatedBy | User who created the meter template record. |
| CreationDate | Date and time when the user created the meter template record. |
| CurcyConvRateType | Currency conversion rate type use for extensibility. |
| CurrencyCode | Indicates the currency code use for the extensibility |
| DailyUtilizationRate | Daily utilization rate for the meter. This is the use value the application uses for forecasting the maintenance program. |
| DerivedAssetId | Derived asset identifier for the meter template name. |
| ExtnAttributeChar001 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar002 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar003 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar004 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar005 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar006 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar007 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar008 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar009 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar010 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar011 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar012 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar013 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar014 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar015 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar016 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar017 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar018 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar019 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar020 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar021 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar022 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar023 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar024 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar025 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar026 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar027 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar028 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar029 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar030 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar031 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar032 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar033 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar034 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar035 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar036 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar037 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar038 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar039 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar040 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar041 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar042 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar043 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar044 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar045 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar046 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar047 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar048 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar049 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar050 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar051 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar052 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar053 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar054 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar055 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar056 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar057 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar058 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar059 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar060 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar061 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar062 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar063 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar064 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar065 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar066 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar067 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar068 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar069 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar070 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar071 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar072 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar073 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar074 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar075 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar076 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar077 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar078 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar079 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar080 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar081 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar082 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar083 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar084 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar085 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar086 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar087 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar088 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar089 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar090 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar091 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar092 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar093 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar094 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar095 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar096 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar097 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar098 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar099 | Character segment for the Meter Flexfield. |
| ExtnAttributeChar100 | Character segment for the Meter Flexfield. |
| ExtnAttributeClob001 | CLOB segment for the Meter Flexfield. |
| ExtnAttributeClob002 | CLOB segment for the Meter Flexfield. |
| ExtnAttributeClob003 | CLOB segment for the Meter Flexfield. |
| ExtnAttributeClob004 | CLOB segment for the Meter Flexfield. |
| ExtnAttributeClob005 | CLOB segment for the Meter Flexfield. |
| ExtnAttributeNumber001 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber002 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber003 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber004 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber005 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber006 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber007 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber008 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber009 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber010 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber011 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber012 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber013 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber014 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber015 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber016 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber017 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber018 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber019 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber020 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber021 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber022 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber023 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber024 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber025 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber026 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber027 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber028 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber029 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber030 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber031 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber032 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber033 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber034 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber035 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber036 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber037 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber038 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber039 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber040 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber041 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber042 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber043 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber044 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber045 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber046 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber047 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber048 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber049 | Number segment for the Meter Flexfield. |
| ExtnAttributeNumber050 | Number segment for the Meter Flexfield. |
| ExtnAttributeTimestamp001 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp002 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp003 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp004 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp005 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp006 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp007 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp008 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp009 | Date and Time segment for the Meter Flexfield. |
| ExtnAttributeTimestamp010 | Date and Time segment for the Meter Flexfield. |
| InitialReadingValue | The meter has this reading value when it's activated. This is the initial value the meter reading displays on the meter reading history. |
| JobDefinitionName | Name of the job that created or most recently updated the row for the meter template 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 template record. This is populated through Enterprise Service Scheduler. |
| LastUpdateDate | Date and time when the user most recently updated the meter template record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the meter template record. |
| LastUpdatedBy | User who most recently updated the meter template record. |
| MeterDefinitionId | Multiple meters are instantiated for a meter definition. This is a foreign key to the Meter Definition view object. |
| MeterId | Value that uniquely identifies the Meter Template. This is a primary key to the Installed Base Asset Meter view object. |
| MeterObjectId | This value depends on the meter usage code value. This could be either an asset_id reference or a contract_line_id reference. |
| MeterUsageCode | Indicates whether the meter template is instantiated the meter references by an asset or contract line. Valid values are ORA_ASSET and ORA_CONTRACT_LINE. |
| ObjectVersionNumber | Number of times the object row has been 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. |
| ReadingLockDate | Date when the meter reading template is most recently locked. A future lock can be applied only above this date. |
| RecordAtWoComplCode | Indicates whether the reading capture at work order completion is a mandatory or optional requirement. |
| RequestId | Request Identifier of the job that created or most recently updated the row. This is populated through Enterprise Service Scheduler. |
| UtilizationRateComputedAt | Number of readings at which the utilization rate should be computed at for the meter template. |