Share this page
td.SUBMISSION Table
Description
Information about Submission for Approval
Columns
| Column Name | Description | Datatype | Length | Allow Null | Default | Formula |
|---|---|---|---|---|---|---|
| SM_ID | Submission ID | int | 4 | FALSE | ||
| SM_REVISION_ID | Revision ID | int | 4 | TRUE | ||
| SM_APPROVAL_POLICY_CONFIG_ID | Approval Policy Config Id | VARCHAR2 | 255 | TRUE | ||
| SM_APPROVAL_RULE_ID | Approval Rule ID | int | 4 | TRUE | ||
| SM_CREATION_TIME | Submission Creation time | DATE | 4 | TRUE | ||
| SM_CLOSING_TIME | Submission closing time | DATE | 4 | TRUE | ||
| SM_IN_PROCESS | Is Submission in process | VARCHAR2 | 1 | TRUE | ||
| SM_ENTITY | Entity type | VARCHAR2 | 200 | TRUE | ||
| SM_SUB_TYPE_FIELD | Subtype field of an entity | VARCHAR2 | 255 | TRUE | ||
| SM_ENTITY_SUB_TYPE | Entity Subtype | VARCHAR2 | 255 | TRUE | ||
| SM_ROUTING_TYPE_FIELD | Routing type field | VARCHAR2 | 255 | TRUE | ||
| SM_ENTITY_ROUTING_TYPE | Entity Routing Type | VARCHAR2 | 255 | TRUE | ||
| SM_ENTITY_ID | Entity Type | int | 4 | TRUE | ||
| SM_TYPE | Submission Type | VARCHAR2 | 200 | TRUE | ||
| SM_APPROVAL_FIELD | Approval Field | VARCHAR2 | 255 | TRUE | ||
| SM_INIT_PHASE_VALUE | Entity Init Phase Value | VARCHAR2 | 2000 | TRUE | ||
| SM_OLD_VALUE | Entity Old Value | VARCHAR2 | 2000 | TRUE | ||
| SM_NEW_VALUE | Entity New Value | VARCHAR2 | 2000 | TRUE | ||
| SM_NEW_VALUE_DECLINED | Entity Declined Value | VARCHAR2 | 2000 | TRUE | ||
| SM_LEVEL | Submission Level | int | 4 | TRUE | ||
| SM_ACTIVATE_LEVEL | Active Level in Submission | int | 4 | TRUE | ||
| SM_APPROVAL_RESULT | Approval Result | VARCHAR2 | 255 | TRUE | ||
| SM_APPROVAL_REQUIRED | Approval required or not | VARCHAR2 | 1 | TRUE | ||
| SM_SIGN_ATTACHMENT | Sign Attachment | VARCHAR2 | 1 | TRUE | ||
| SM_APPROVER_EXCLUSIVE | Approver Exclusive or not | VARCHAR2 | 1 | TRUE | ||
| SM_APPROVAL_REQUESTER_SIGN_REQUIRED | Approver requester sign | VARCHAR2 | 1 | TRUE | ||
| SM_APPROVAL_REQUESTER_REAUTH_REQUIRED | Approver Reauth | VARCHAR2 | 1 | TRUE | ||
| SM_APPROVAL_REQUESTER_SIGN_MEANING | Sign Meaning | VARCHAR2 | 4000 | TRUE | ||
| SM_SIGN_INTEGRITY_FIELDS | Sign Integrity fields | CLOB | 4000 | TRUE | ||
| SM_TEAMS_ALLOWED | Teams allowed | CLOB | 4000 | TRUE | ||
| SM_SIGNATURE_ID | Signature Id | int | 4 | TRUE | ||
| SM_COMMENTS | Comments | CLOB | 4000 | TRUE | ||
| SM_WITHDRAW_COMMENTS | Withdraw action comments | CLOB | 4000 | TRUE | ||
| SM_USER | Submission User | VARCHAR2 | 255 | TRUE | ||
| SM_WITHDRAW_USER | Submission Withdraw User | VARCHAR2 | 255 | TRUE | ||
| SM_VTS | Version | VARCHAR2 | 20 | TRUE | ||
| SM_WITHDRAW_SUBMISSION_ID | Withdraw action comments | int | 4 | TRUE |
Indexes
| Index Name | Description | Primary | Unique |
|---|---|---|---|
| SM_PRIMARYKEY Index | Yes | Yes | |
| SM_ESIGN_ENTITY_IDX | |||
| SM_IN_PROCESS_IDX | |||
| SM_VTS_IDX |
