MNT_WR_METERS
This table stores the meters that are used in the computation of the forcast for the planning of the usage based work requirement planning.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MNT_WR_METERS_PK |
REQUIREMENT_METER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
REQUIREMENT_METER_ID | NUMBER | 18 | Yes | The unique system generated system identifier. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that 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. | |
REQUIREMENT_ID | NUMBER | 18 | Yes | Foreign key reference to the work requirement. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier. This is the maintenance organization in which the maintenance program is authored. | |
METER_DEFINITION_ID | NUMBER | 18 | The meter template identifier. This column will be populated instead of the meter id, when the requirement type is of the item. So meter templates applicable for the item, can be used in the computation of forecasts for assets that belong to the item. | ||
METER_ID | NUMBER | 18 | Asset Meter Identifier. The meter id of the asset for which readings are to be used in the usage based requirement. | ||
BASE_INTERVAL | NUMBER | The base inteval at which the readings are to be used for this requirement. | |||
NEXT_FORECAST_DUE_BY_CODE | VARCHAR2 | 30 | Yes | Whether the next forecast is to be generated based on "Base Interval" specified in the requirement or "Reading History". | |
DISABLED_FLAG | VARCHAR2 | 1 | Flag indicating that the meter association to the work requirement is no longer active. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MNT_WR_METERS_N01 | Non Unique | Default | REQUIREMENT_ID, DISABLED_FLAG |
MNT_WR_METERS_U01 | Unique | Default | REQUIREMENT_METER_ID |