PAY_FLOW_INSTANCES
Its an Instance table to capture Flow Instances
Details
-
Schema: FUSION
-
Object owner: PAY
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PAY_FLOW_INSTANCES_PK |
FLOW_INSTANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FLOW_INSTANCE_ID | NUMBER | 18 | Yes | FLOW_INSTANCE_ID | |
| SUBMISSION_CONTEXT | VARCHAR2 | 100 | SUBMISSION_CONTEXT | ||
| ROOT_FLOW_INSTANCE_ID | NUMBER | 18 | ROOT_FLOW_INSTANCE_ID | ||
| INSTANCE_NAME | VARCHAR2 | 200 | INSTANCE_NAME | ||
| LEGISLATIVE_DATA_GROUP_ID | NUMBER | 18 | Foreign key to PER_LEGISLATIVE_DATA_GROUPS. | ||
| LEGISLATION_CODE | VARCHAR2 | 30 | Foreign key to FND_TERRITORIES. | ||
| BASE_FLOW_ID | NUMBER | 18 | Yes | BASE_FLOW_ID | |
| FI_TASK_STATUS | VARCHAR2 | 20 | TASK_STATUS | ||
| FI_PAYROLL_ID | NUMBER | 20 | FI_PAYROLL_ID | ||
| FI_PAYROLL_PERIOD | NUMBER | 18 | FI_PAYROLL_PERIOD | ||
| FI_PROCESS_DATE | DATE | PROCESS_DATE | |||
| FI_TASK_TYPE | VARCHAR2 | 20 | TASK_TYPE | ||
| ERRORED | VARCHAR2 | 1 | ERRORED | ||
| MARKED_FOR_RETRY | VARCHAR2 | 1 | MARKED_FOR_RETRY | ||
| REVERSED | VARCHAR2 | 1 | REVERSED | ||
| NUMBER_OF_TASKS | NUMBER | 3 | NUMBER_OF_TASKS | ||
| FI_COMPLETED_TASKS | NUMBER | 3 | COMPLETED_TASKS | ||
| RECUR_SCH_FORMULA_ID | NUMBER | 18 | Formula to calculate a recurring schedule for flow instance | ||
| RECUR_TIME_COMPONENT | VARCHAR2 | 50 | RECUR_TIME_COMPONENT | ||
| PROGRESS | NUMBER | 9 | PROGRESS | ||
| ENTERPRISE_ID | NUMBER | 18 | Yes | Foreign key to PER_ENTERPRISES. | |
| 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. | |
| RUN_ID | NUMBER | 18 | RUN_ID | ||
| STATUS | VARCHAR2 | 30 | STATUS | ||
| RECUR_SCH_TIME_DEF_ID | NUMBER | 18 | TIME_DEFINITION_ID: Column used to capture TimeDefinitionId that will define the recurring schedule. | ||
| SCHEDULED_DATE | TIMESTAMP | Column capturing the scheduled execution date for the flow instance. | |||
| SCHEDULE_END_DATE | TIMESTAMP | Timestamp capturing end of the recurring schedule. | |||
| RECURRING_FLAG | VARCHAR2 | 1 | Flag indicating if the flow instance need to be submitted recurringly | ||
| FI_TASK_FLOW_FLAG | VARCHAR2 | 2 | Flag indicating whether the tasks belongs to a composite flow or not. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 200 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 200 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | ||
| INSTANTIATED_BY | VARCHAR2 | 100 | Yes | INSTANTIATED_BY | |
| 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. | ||
| EXECUTION_MODE | VARCHAR2 | 20 | EXECUTION_MODE | ||
| FI_TOTAL_COMPLETED | NUMBER | TOTAL_COMPLETED | |||
| FI_ROLLEDBACK | VARCHAR2 | 30 | RB_SUB_STATUS | ||
| FLOW_INSTANCE_NAME_UNIQUE | VARCHAR2 | 200 | FLOW_INSTANCE_NAME_UNIQUE | ||
| FLOW_INSTANCE_UNIQUE | VARCHAR2 | 200 | FLOW_INSTANCE_UNIQUE | ||
| IS_FULL_ROLLBACK | VARCHAR2 | 30 | To determine task level full rollback | ||
| IS_SKIPPED | VARCHAR2 | 30 | to determine task/flow level skip action | ||
| IS_INCOMPLETE | VARCHAR2 | 30 | to determine task level incomplete action | ||
| IS_EXTRACT | VARCHAR2 | 2 | IS_EXTRACT | ||
| IS_DATA_LOADER | VARCHAR2 | 2 | IS_DATA_LOADER | ||
| FLOW_ID | NUMBER | 18 | FLOW_ID | ||
| SUB_STATUS | VARCHAR2 | 40 | SUB_STATUS | ||
| OUTBOUND_ENABLED_FLAG | VARCHAR2 | 1 | OUTBOUND_ENABLED_FLAG |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PAY_FLOW_INSTANCES_N1 | Non Unique | Default | BASE_FLOW_ID, STATUS, CREATION_DATE |
| PAY_FLOW_INSTANCES_N2 | Non Unique | Default | STATUS |
| PAY_FLOW_INSTANCES_N3 | Non Unique | Default | INSTANCE_NAME |
| PAY_FLOW_INSTANCES_N5 | Non Unique | Default | CREATION_DATE, CREATED_BY, INSTANTIATED_BY |
| PAY_FLOW_INSTANCES_PK | Unique | Default | FLOW_INSTANCE_ID |
| PAY_FLOW_INSTANCES_U1 | Unique | Default | LEGISLATIVE_DATA_GROUP_ID, BASE_FLOW_ID, NVL("FLOW_INSTANCE_NAME_UNIQUE","FLOW_INSTANCE_ID") |