MNT_WR_WORK_DEFINITIONS

Details

Schema: FUSION
Object owner: MNT
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
MNT_WR_WORK_DEFINITIONS_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 maintenance program work requirement work definitions 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 maintenance program work requirement work definitions level.
REQUIREMENT_WD_ID	NUMBER		18		The unique system generated system identifier.
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.
WORK_DEFINITION_CODE	VARCHAR2	30			Indicates the user defined maintenance work definition code.
WORK_DEFINITION_ID	NUMBER		18		The work definition identifier. This is what is finally going to be used in the creation of the work order from the projected forecasts.
DUE_AT_CYCLE_INTERVAL	NUMBER				The interval at which this work definition is applied to the forecast on a cycle based work requirement.
REPEATS_IN_CYCLE_FLAG	VARCHAR2	1			Denotes whether the work definition usage in the forecast repeats in the cycle when the due at cycle interval specified at the work definition is arrived.
DISABLED_FLAG	VARCHAR2	1			Flag indicating that the meter association to the work requirement is no longer active.
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_WORK_DEFINITIONS_INT_N1	Non Unique	Default	PARTITION_NUMBER
MNT_WR_WORK_DEFINITIONS_INT_N2	Non Unique	Default	INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, HEADER_NUMBER
MNT_WR_WORK_DEFINITIONS_INT_U1	Unique	Default	INTERFACE_ROW_ID