MNT_WR_AFFECTED_ASSETS_INT
The open interface entity that holds all the maintenance program work requirement affected assets informatoin.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
MNT_WR_AFFECTED_ASSETS_INT_PK |
INTERFACE_ROW_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_ROW_ID | NUMBER | 18 | Yes | Interface Row Identifier. The primary key column of this table. | |
INTERFACE_STATUS_CODE | VARCHAR2 | 30 | The status of the interface row. The processor heavily relies on this column to persist interim status of the row upon processing data in bulk. | ||
INTERFACE_BATCH_ID | NUMBER | 18 | Interface Batch Identifier. This is the foreign key to the Interface Batch entity. | ||
INTERFACE_BATCH_CODE | VARCHAR2 | 30 | The interface batch code. The user key to the interface batch entity. | ||
PARTITION_NUMBER | NUMBER | 18 | For parallel processing, the internal logic uses this column to stripe a set of work requirement affected assets in to a partition. | ||
HEADER_NUMBER | VARCHAR2 | 18 | Interface Record Number. This is the user key to link the child interface entities together. | ||
ACTION_CODE | VARCHAR2 | 30 | The various actions that can be performed via the import functionality at the work requirement affected assets level. | ||
INCLUSION_ID | NUMBER | 18 | Inclusion Identifier. The primary key of cse_wr_included_assets table. | ||
EXCLUSION_ID | NUMBER | 18 | Exclusion Identifier. The primary key of cse_wr_excluded_assets table. | ||
REQUIREMENT_NAME | VARCHAR2 | 120 | The unique name for the maintenance work requiremnt within the maintenance program. | ||
REQUIREMENT_ID | NUMBER | 18 | Foreign key reference to the work requirement. | ||
ORGANIZATION_ID | NUMBER | 18 | The organization identifier. This is the maintenance organization in which the maintenance program is authored. | ||
ITEM_ID | NUMBER | 18 | The foreign key to the inventory item identifier. | ||
ASSET_NUMBER | VARCHAR2 | 80 | An user identifier for the asset object. This is the user primary key for the asset. | ||
ASSET_ID | NUMBER | 18 | The foreign key reference to the asset business object. | ||
INCLUSION_EXCLUSION_CODE | VARCHAR2 | 30 | Indicates if the specified asset is included or excluded in the work requirement. | ||
HISTORY_SERVICE_DATE | DATE | Used for Asset based work requirements to indicate the last date in which the work was accomplished from an external system. This is just captured one time at the setting up of the work requirement for the first time for this asset. | |||
HISTORY_SERVICE_INTERVAL | NUMBER | Used for Asset based work requirements to indicate the last interval in a cycle which the work was accomplished from an external system. | |||
REQUIREMENT_START_DATE | DATE | When defined, it overrides the Work Requirment start date specifically for the Asset. | |||
CREATE_WORK_ORDER_OPTION_CODE | VARCHAR2 | 30 | The mode in which the work order is created from the forecast. Is it automatically or via a manual process. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Load Request Identifier. This is to support the loading of the interface records from the data files using the cloud framework. | ||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | 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_AFFECTED_ASSETS_INT_N1 | Non Unique | Default | PARTITION_NUMBER |
MNT_WR_AFFECTED_ASSETS_INT_N2 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, HEADER_NUMBER |
MNT_WR_AFFECTED_ASSETS_INT_U1 | Unique | Default | INTERFACE_ROW_ID |