Meter Definition
The Meter Definition view object contains information about all the physical attributes of the meter template.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.MeterDefinitionExtractPVO
Primary Keys : MeterDefinitionId, MeterDefinitionTranslationLanguage, MeterDefinitionTranslationMeterDefinitionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActiveEndDate | Date when the meter template is end dated. |
| ActiveStartDate | Date when the meter template becomes active. |
| AllowInMaintProgramFlag | Value that indicates whether any meter created from this template can be included in the maintenance program. Based forecast generation should be specified for meters templates on this category. |
| AttributeCategory | Context name for the meter definitions descriptive flexfield. |
| CorpCurrencyCode | The corporate currency code for extensibility. |
| CreatedBy | User who created the meter definition record. |
| CreationDate | Date and time when the user created the meter definition record. |
| CurcyConvRateType | Currency conversion rate type for extensibility |
| CurrencyCode | Corporate currency code for extensibility. |
| DailyUtilizationRate | Daily utilization rate for the meter. This is a default value at the template level. |
| ExtnAttributeChar001 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar002 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar003 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar004 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar005 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar006 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar007 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar008 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar009 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar010 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar011 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar012 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar013 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar014 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar015 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar016 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar017 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar018 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar019 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar020 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar021 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar022 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar023 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar024 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar025 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar026 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar027 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar028 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar029 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar030 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar031 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar032 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar033 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar034 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar035 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar036 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar037 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar038 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar039 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar040 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar041 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar042 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar043 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar044 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar045 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar046 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar047 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar048 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar049 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar050 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar051 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar052 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar053 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar054 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar055 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar056 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar057 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar058 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar059 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar060 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar061 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar062 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar063 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar064 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar065 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar066 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar067 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar068 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar069 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar070 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar071 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar072 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar073 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar074 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar075 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar076 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar077 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar078 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar079 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar080 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar081 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar082 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar083 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar084 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar085 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar086 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar087 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar088 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar089 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar090 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar091 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar092 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar093 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar094 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar095 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar096 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar097 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar098 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar099 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeChar100 | Character segment for the Meter Definition Flexfield. |
| ExtnAttributeClob001 | CLOB segment for the Meter Definition Flexfield. |
| ExtnAttributeClob002 | CLOB segment for the Meter Definition Flexfield. |
| ExtnAttributeClob003 | CLOB segment for the Meter Definition Flexfield. |
| ExtnAttributeClob004 | CLOB segment for the Meter Definition Flexfield. |
| ExtnAttributeClob005 | CLOB segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber001 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber002 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber003 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber004 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber005 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber006 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber007 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber008 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber009 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber010 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber011 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber012 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber013 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber014 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber015 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber016 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber017 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber018 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber019 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber020 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber021 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber022 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber023 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber024 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber025 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber026 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber027 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber028 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber029 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber030 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber031 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber032 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber033 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber034 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber035 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber036 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber037 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber038 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber039 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber040 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber041 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber042 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber043 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber044 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber045 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber046 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber047 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber048 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber049 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeNumber050 | Number segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp001 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp002 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp003 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp004 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp005 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp006 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp007 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp008 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp009 | Date and Time segment for the Meter Definition Flexfield. |
| ExtnAttributeTimestamp010 | Date and Time segment for the Meter Definition Flexfield. |
| ForecastUsingDailyRateFlag | Value that indicates whether the forecast generation program can consider the daily utilization rate for the meter. This is to compute the forecasts for the assets on the maintenance program. |
| InitialReadingValue | This is set when the meter is defined, the readings as found in the device could be recorded optionally as an initial value. |
| JobDefinitionName | Name of the job that created or most recently updated the row for the meter definition 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 definition record. This is populated through Enterprise Service Scheduler. |
| Language | Code of the language into which the contents of the meter definition are translated. |
| LastUpdateDate | Date and time when the user most recently updated the meter definition record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the meter definition record. |
| LastUpdatedBy | User who most recently updated the meter definition record. |
| MeterCode | Value that uniquely identifies the code that the user enters for the meter. |
| MeterDefinitionId | Value that uniquely identifies the Meter. This is a primary key for the Meter Definition view object. |
| MeterDefinitionTranslationCreatedBy | User who created the meter definition translation record. |
| MeterDefinitionTranslationCreationDate | Date and time when the user created the meter definition translation record. |
| MeterDefinitionTranslationLanguage | Code of the language into which the meter definition transaction are translated. |
| MeterDefinitionTranslationLastUpdateDate | Date and time when the user most recently updated meter definition translation record. |
| MeterDefinitionTranslationLastUpdateLogin | Session login associated with the user who most recently updated the meter definition translation record. |
| MeterDefinitionTranslationLastUpdatedBy | User who most recently updated the meter definition translation record. |
| MeterDefinitionTranslationMeterDefinitionId | Value that uniquely identifies the meter definition. This is a primary key that the application generates when it creates meter definition translation record. |
| MeterDefinitionTranslationMeterDescription | The meter definition translation description associated to the meter definition record. |
| MeterDefinitionTranslationMeterName | The meter definition translation name associated to the meter definition record. |
| MeterDefinitionTranslationObjectVersionNumber | 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. |
| MeterDefinitionTranslationSourceLang | Code of the language in which the contents of the meter definition translation columns were originally created. |
| MeterTypeCode | Value that identifies the type of the meter. The values are continuous or gauge. |
| 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. |
| ReadingDirection | Value that indicates the direction the next value captured should be entered. The value enters could be in the ascending, descending or both directions forms are allowed. |
| ReadingMaxValue | The maximum value allowed to be captured in the meter reading. |
| ReadingMinValue | The minimum value allowed to be captured in the meter reading. |
| ReadingTypeCode | Type of reading that this meter is captured. These values could be either absolute or change. |
| RecordAtWoComplCode | Value that indicates whether the reading capture is mandatory or optionally required at work order completion. |
| RequestId | Request identifier of the job that created or most recently updated the row. This is populated through Enterprise Service Scheduler. |
| ResetAllowedFlag | Value that indicates whether the meter reading can be reset to the specified reset value. |
| ResetValue | Value to which the meter is reset. This happens when user resets the meter. |
| RolloverAllowedFlag | Value that indicates whether the meter reading automatically rolls over when it reaches its limit. |
| RolloverMaxValue | Value at which the meter automatically rolls over to the reset value. This happens when the meter is configured to rollover. |
| RolloverResetValue | Value to which the meter resets when the maximum rollover value is reached. This happens for the meter that's configured to rollover. |
| TemplateUsageCode | Value that indicates that the meter template can be created either to instantiate meters for the assets or for subscriptions. The lookup will be ORA_CSE_METER_TEMP_USAGE_CODE and the values passed will be ORA_ASSET or ORA_SUBSCRIPTION. |
| UomCode | Unit of measure in which meter readings should be captured. |
| UtilizationRateComputedAt | Value that indicates the number of reading at which the utilization rate should be computed at. |