ZCH_REVIEW_REQUESTS

Details

Schema: FUSION
Object owner: ZCH
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
ZCH_REVIEW_REQUESTS_PK	REVIEW_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REVIEW_REQUEST_ID	NUMBER		18	Yes	The primary identifier for the request.
REVIEW_REQUEST_NUMBER	VARCHAR2	30		Yes	Unique request number generated for the request.
REVIEW_REQUEST_NAME	VARCHAR2	128			The name or title of the request.
INPUT_TEXT	CLOB				Raw input payload provided when the request was created.
REQUEST_DETAIL	BLOB				Detailed request payload and metadata used during processing.
REQUEST_SOURCE	VARCHAR2	30			Source system or channel from which the request originated.
PROCESS_CODE	VARCHAR2	30		Yes	Code identifying process for this request.
PROCESS_ID	NUMBER		18		Internal identifier of the process instance handling this request.
STATUS	VARCHAR2	30		Yes	Current lifecycle status of the request processing.
ERROR_TEXT	CLOB				Detailed technical error diagnostics captured during processing.
ERROR_MESSAGE	VARCHAR2	4000			User-readable error message associated with a failed request.
RECORD_ID	NUMBER		18		Identifier of the target object record associated with this request.
OBJECT_CODE	VARCHAR2	50			Code of the object type being processed.
APPROVAL_REQUEST_DATE	TIMESTAMP				Date and time when approval was requested.
APPROVAL_REQUEST_TEXT	CLOB				Approval request message or payload sent to approvers.
APPROVAL_DATE	TIMESTAMP				Date and time when the approval decision was recorded.
APPROVAL_TEXT	CLOB				Approval decision notes or response details.
WORKFLOW_TRACE_ID	VARCHAR2	128			Correlation identifier used to trace workflow execution.
WORKFLOW_DEFINITION	VARCHAR2	128			Name or identifier of the workflow definition used.
REQUESTED_BY	VARCHAR2	64			User who initiated or submitted the request.
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
ZCH_REVIEW_REQUESTS_N1	Non Unique	Default	PROCESS_CODE, PROCESS_ID
ZCH_REVIEW_REQUESTS_N2	Non Unique	Default	STATUS, REQUESTED_BY
ZCH_REVIEW_REQUESTS_N3	Non Unique	Default	OBJECT_CODE, RECORD_ID
ZCH_REVIEW_REQUESTS_PK	Unique	Default	REVIEW_REQUEST_ID
ZCH_REVIEW_REQUESTS_U1	Unique	Default	REVIEW_REQUEST_NUMBER