PSC_TS_INFLIGHT_MIG_SCHEDULE
This table tracks the inflight workflow migration schedule for application groups which contain applications associated with structured process instances that are due for migration from current workflow version to the latest configured workflow version for each application.
Details
-
Schema: FUSION
-
Object owner: PSC_TS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_TS_INFLIGHT_MIG_SCHED_PK |
INFLIGHT_MIG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INFLIGHT_MIG_ID | NUMBER | 18 | Yes | Auto-generated value for Inflight Migration ID. | |
| RECORD_TYPE_ID | VARCHAR2 | 100 | Yes | PSCR Application Record Type ID. | |
| RECORD_TYPE | VARCHAR2 | 100 | Yes | PSCR Application Record Type Name. | |
| CLASSIFICATION | VARCHAR2 | 50 | PSCR Application Classification. | ||
| SUB_CLASSIFICATION | VARCHAR2 | 100 | PSCR Application Sub-Classification. | ||
| APP_VERSION_TYPE | VARCHAR2 | 50 | PSCR Application Version Type. | ||
| WF_APP_NAME | VARCHAR2 | 500 | Yes | OPA Workflow Application Name. | |
| PROCESS_DEFN_NAME | VARCHAR2 | 100 | Process Definition Name in the OPA Workflow Application. | ||
| CURRENT_WF_APP_VER | VARCHAR2 | 50 | OPA Workflow Application Version associated with the PSCR Application Group before migration. | ||
| TARGET_WF_APP_VER | VARCHAR2 | 50 | OPA Workflow Application Version associated with the PSCR Application Group after migration. | ||
| MIG_FROM_GEN_VERSION | VARCHAR2 | 10 | OPA Generation version migrated from. | ||
| MIG_TO_GEN_VERSION | VARCHAR2 | 10 | OPA Generation version migrated to. | ||
| INFLIGHT_MIG_STATUS | VARCHAR2 | 30 | Indicates migration status of the applications in the application group. | ||
| TOTAL_APPS_COUNT | NUMBER | 9 | Total number of PSCR Applications belonging to the Application Group. | ||
| SELECTED_APPS_COUNT | NUMBER | 9 | No. of PSCR Applications in the Application Group that have been selected for Inflight Migration. | ||
| SUCCESS_MIG_COUNT | NUMBER | 9 | No. of PSCR Applications in the Application Group that have been successfully migrated. | ||
| FAILED_MIG_COUNT | NUMBER | 9 | No. of PSCR Applications in the Application Group that have failed migration. | ||
| PENDING_MIG_COUNT | NUMBER | 9 | No. of PSCR Applications in the Application Group that are pending migration. | ||
| MIG_JOB_ID | NUMBER | 9 | ESS Job ID of the Inflight Migration Job that executes the Migration for the Application Group. | ||
| EXEC_START_DATE | TIMESTAMP | Date/Time when the Inflight Migration execution started for the Application Group. | |||
| EXEC_END_DATE | TIMESTAMP | Date/Time when the Inflight Migration execution finished for the Application Group. | |||
| EXEC_DURATION | NUMBER | 22 | Actual duration in Hours / Minutes / Seconds indicating how long it took for the Inflight Migration of all PSCR Applications in the Application Group to finish. | ||
| ERROR_DETAILS | VARCHAR2 | 2000 | Contains details on the errors encountered if any when doing the migration on the Application Group. | ||
| 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. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_TS_INFLIGHT_MIG_SCHED_N1 | Non Unique | Default | RECORD_TYPE |
| PSC_TS_INFLIGHT_MIG_SCHED_N10 | Non Unique | Default | RECORD_TYPE_ID |
| PSC_TS_INFLIGHT_MIG_SCHED_N2 | Non Unique | Default | CLASSIFICATION |
| PSC_TS_INFLIGHT_MIG_SCHED_N3 | Non Unique | Default | SUB_CLASSIFICATION |
| PSC_TS_INFLIGHT_MIG_SCHED_N4 | Non Unique | Default | APP_VERSION_TYPE |
| PSC_TS_INFLIGHT_MIG_SCHED_N5 | Non Unique | Default | WF_APP_NAME |
| PSC_TS_INFLIGHT_MIG_SCHED_N6 | Non Unique | Default | PROCESS_DEFN_NAME |
| PSC_TS_INFLIGHT_MIG_SCHED_N7 | Non Unique | Default | CURRENT_WF_APP_VER |
| PSC_TS_INFLIGHT_MIG_SCHED_N8 | Non Unique | Default | TARGET_WF_APP_VER |
| PSC_TS_INFLIGHT_MIG_SCHED_N9 | Non Unique | Default | INFLIGHT_MIG_STATUS |
| PSC_TS_INFLIGHT_MIG_SCHED_PK | Unique | Default | INFLIGHT_MIG_ID |