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