ZCH_DATA_MGMT_REVIEW_REQUESTS
Stores review request source data, workflow metadata, review information, object linkage and processing status.
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCH_DATA_MGMT_REV_REQ_PK |
REVIEW_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REVIEW_REQUEST_ID | NUMBER | 18 | Yes | Primary identifier for the review request record. | |
| REQUEST_NUMBER | VARCHAR2 | 30 | Yes | Business-facing request number used by APIs. | |
| REQUEST_NAME | VARCHAR2 | 128 | Yes | Request title or display name. | |
| REQUEST_TYPE | VARCHAR2 | 30 | Yes | Type of review request that defines the review process. | |
| REQUEST_CONTENT | CLOB | Yes | Review request details which can be updated during request processing. | ||
| SOURCE_DATA | CLOB | Yes | Initial review request details specified during request creation. | ||
| SOURCE_PROCESS_CODE | VARCHAR2 | 30 | Yes | Workflow or business process identifier for the submitted source request. | |
| SOURCE_PROCESS_ID | NUMBER | 18 | Internal process instance identifier, if assigned. | ||
| STATUS | VARCHAR2 | 30 | Yes | Current lifecycle state of the review request. | |
| REVIEW_REQUEST_DETAIL | CLOB | Description of the review required by the reviewer. | |||
| REVIEW_START_DATE | TIMESTAMP | Timestamp when review was requested. | |||
| REVIEW_NOTES | CLOB | Review notes or instructions captured from the reviewer. | |||
| REVIEW_COMPLETE_DATE | TIMESTAMP | Timestamp when review completion or rejection was recorded. | |||
| REVIEWED_BY | VARCHAR2 | 64 | User who approved or rejected the review request. | ||
| ERROR_CODE | VARCHAR2 | 100 | Error code associated with a failed request. | ||
| ERROR_DETAIL | CLOB | Detailed error content for request failures. | |||
| ERROR_MESSAGE | VARCHAR2 | 4000 | Short human-readable error message. | ||
| OBJECT_ID | NUMBER | 18 | Object instance that is the focus of this review. | ||
| OBJECT_CODE | VARCHAR2 | 50 | Type of object that is the focus of this review. | ||
| WORKFLOW_TRACE_ID | VARCHAR2 | 200 | Trace identifier of the workflow used for review request processing. | ||
| WORKFLOW_CODE | VARCHAR2 | 200 | Code of the workflow used for review request processing. | ||
| REQUESTED_BY | VARCHAR2 | 64 | User who created 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_DATA_MGMT_REV_REQ_N1 | Non Unique | Default | STATUS, SOURCE_PROCESS_CODE |
| ZCH_DATA_MGMT_REV_REQ_N2 | Non Unique | Default | REQUESTED_BY, STATUS |
| ZCH_DATA_MGMT_REV_REQ_PK | Unique | Default | REVIEW_REQUEST_ID |
| ZCH_DATA_MGMT_REV_REQ_U1 | Unique | Default | REQUEST_NUMBER |