Share this page
td_APPROVAL_POLICY Table
Description
Information about Approval policy
Columns
| Column Name | Description | Datatype | Length | Allow Null | Default | Formula |
|---|---|---|---|---|---|---|
| APT_ID | The Approval policy ID | int | 4 | FALSE | ||
| APT_APPROVER_EXCLUSIVE | Approver exclusive | VARCHAR2 | 1 | FALSE | ||
| APT_APPROVER_REAUTH_REQUIRED | Reauth required for the record | VARCHAR2 | 1 | FALSE | ||
| APT_REQUESTER_REAUTH_REQUIRED | Submitter re-auth required for the record | VARCHAR2 | 1 | FALSE | ||
| APT_SIGN_ATTACHMENT | Signature attachment of the record | VARCHAR2 | 1 | FALSE | ||
| APT_SIGN_INTEGRITY_FIELDS | Sign integrity fields | CLOB | 4000 | TRUE | ||
| APT_DEFAULT_ROUTE_ID | Default Route ID | int | 4 | TRUE | ||
| APT_APPROVAL_ROUTES_CONDITIONS | Route conditions | CLOB | 4000 | TRUE | ||
| APT_IS_ACTIVE | Policy is active or not | VARCHAR2 | 1 | FALSE | ||
| APT_CREATED_BY | Approval policy created by | VARCHAR2 | 250 | TRUE | ||
| APT_CREATION_TIME | Creation time of the policy | DATE | 4 | TRUE | ||
| APT_MODIFIED_BY | Policy modified by | VARCHAR2 | 250 | TRUE | ||
| APT_LAST_MODIFIED_TIME | Last modification time | DATE | 4 | TRUE | ||
| APT_VERSION_STAMP | Version | int | 4 | TRUE |
Indexes
| Index Name | Description | Primary | Unique |
|---|---|---|---|
| APPROVAL_POLICY_PK | Yes | Yes | |
| APT_IS_ACTIVE_IDX |
