SCH_REC_TASK_HISTORY
SCH_REC_TASK_HISTORY stores the history of tasks assigned to the product recall traceability headers or recall notice lines along with the task status and information on when the task is assigned and when it is completed. It also keeps a track of whether the notification has been sent for the assigned task. For each product traceability header or for each recall notice line, there can be multiple tasks depending on whether the task is a line level task or traceability level task. Tasks are pre-seeded with their own unique identifier and stored in a separate table called "SCH_REC_TASKS_B" and these tasks are used in this table as per the assignment done at line level and product traceability header level. ACTION_ID is the unique system generated primary key in this table.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
SCH_REC_TASK_HISTORY_PK |
ACTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ACTION_ID | NUMBER | 18 | Yes | Unique identifier for the task assignment at product recall traceability header level or recall notice line level. | |
RECALL_LINE_ID | NUMBER | 18 | Recall Notice Line unique identifier. | ||
PRODUCT_TRACE_ID | NUMBER | 18 | Product Recall Traceability Header Unique Identifier for which the task has been assigned. | ||
DISPOSITION_ORGANIZATION_ID | NUMBER | 18 | Inventory Organization unique identifier from where the disposition of recalled part happens. | ||
TASK_ID | NUMBER | 18 | Unique identifier of the Recall Task. | ||
NOTIFIED_FLAG | VARCHAR2 | 1 | Indicates whether the notification has been sent to the user for the task assigned to the product recall traceability header level or recall notice line level. | ||
TASK_STATUS | VARCHAR2 | 30 | Indicates the status of the task assigned to the product recall traceability header or recall notice line. | ||
START_DATE | DATE | Indicates the date on which the task has been assigned to the product recall traceability header or recall notice line. | |||
COMPLETION_DATE | DATE | Indicates the date on which the task assigned to the product recall traceability header or recall notice line gets completed. | |||
COMMENTS | VARCHAR2 | 2000 | Indicates the comments for completion or withdrawal of a task. | ||
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. | |
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. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
SCH_REC_TASK_HISTORY | sch_rec_tasks_b | TASK_ID |
SCH_REC_TASK_HISTORY | sch_rec_trace_status | PRODUCT_TRACE_ID |
sch_rec_disp_detail | sch_rec_task_history | ACTION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
SCH_REC_TASK_HISTORY_N1 | Non Unique | Default | TASK_ID |
SCH_REC_TASK_HISTORY_N2 | Non Unique | Default | PRODUCT_TRACE_ID |
SCH_REC_TASK_HISTORY_U1 | Unique | Default | ACTION_ID |