MNT_EQR_INC_EXC_ASSETS
The list of assets that are either included or excluded based on the asset eligibility rule metioned in the qualification requirement. This only applies to non inspection plan based requirements.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MNT_EQR_INC_EXC_ASSETS_PK |
EQR_INC_EXC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EQR_INC_EXC_ID | NUMBER | 18 | Yes | The inclusion or exclusion identifier. This is the primary key of the entity. | |
| 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. | |
| EQP_QUAL_REQ_ID | NUMBER | 18 | Yes | The foreign key to the equipment qualification requirement. | |
| ASSET_ID | NUMBER | 18 | Yes | The foreign key to the asset. The asset that is to be excluded or included based on the applicability rule. | |
| ACTIVE_END_DATE | TIMESTAMP | The date when the association between the requirement and included or excluede asset is severed. | |||
| 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_EQR_INC_EXC_ASSETS_N01 | Non Unique | Default | EQP_QUAL_REQ_ID |
| MNT_EQR_INC_EXC_ASSETS_N02 | Non Unique | Default | ASSET_ID |
| MNT_EQR_INC_EXC_ASSETS_U01 | Unique | Default | EQR_INC_EXC_ID |