MNT_FFS_PUBLISH_INT
This is the interface table that receives the scheduling recommendation from the field service schedule optimization engine. This data published will be consumed by the maintenance work order.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
MNT_FFS_PUBLISH_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of the published data from Fusion Field Service. Its value is an application generated unique id. | |
| RUN_ID | NUMBER | 18 | Yes | Represents the run control identifier. This is used to identify publish data set in the run. | |
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Yes | Represents the progress of the interface processing with statuses such as ready for processing or currently in process as well as the various flavors of completion statuses. Valid values exist in the lookup with lookup type = ORA_CSE_INTERFACE_STATUS. | |
| PUBLISH_TYPE_CODE | VARCHAR2 | 30 | Yes | A code used to indicate what action the system should perform on the detail entity. Valid values exist in the lookup with lookup type = ORA_MNT_FFS_ASSIGN_PUB_TYPE. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Represents the internal identifier of the maintenance organization where the maintenance work is performed. | |
| ASSET_ID | NUMBER | 18 | Yes | Represents the internal identifier of the asset on a maintenance work order. | |
| WORK_ORDER_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order. | |
| WO_OPERATION_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order operation. | |
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | Represents the internal identifier of the work order operation resource. | ||
| WO_OP_RESOURCE_INSTANCE_ID | NUMBER | 18 | Represents the internal identifier of the work order operation resource instance. | ||
| LABOR_INSTANCE_ID | NUMBER | 18 | Represents the internal identifier of the labor resource instance. | ||
| FFS_RESOURCE_ID | NUMBER | 18 | Represents the internal identifier of the field service resource entity. | ||
| PERSON_ID | NUMBER | 18 | Represents the internal identifier of the person. | ||
| EQUIPMENT_INSTANCE_ID | NUMBER | 18 | Represents the internal identifier of the equipment resource instance. | ||
| BLOCK_ASSIGNMENT_ID | NUMBER | 18 | Represents the internal identifier of the labor instance block assignment. | ||
| SHIFT_ID | NUMBER | 18 | Represents the foreign key to the shift identifier from the field service calendar. | ||
| START_DATE | TIMESTAMP | Yes | Date when the resource instance is planned to start within the operation to which it is assigned. | ||
| END_DATE | TIMESTAMP | Yes | Date when the resource instance is planned to complete within the operation to which it is assigned. | ||
| PARTITION_NUMBER | NUMBER | The partitioning number for multi-threading. | |||
| ERROR_TEXT | VARCHAR2 | 2000 | Interface Error Text. This will be a translated error text when the error that is captured is from another application's api call. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | This column is used when loading data from the csv file to the interface table using the central ESS program. This is the request id for the job that did the move from UCM to the interface table. | ||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MNT_FFS_PUBLISH_INT_N01 | Non Unique | Default | RUN_ID, INTERFACE_STATUS_CODE |
| MNT_FFS_PUBLISH_INT_U01 | Unique | Default | INTERFACE_ROW_ID |