Share this page
td_APPROVAL_POLICY_CONFIG Table
Description
Information about Approval policy
Columns
| Column Name | Description | Datatype | Length | Allow Null | Default | Formula |
|---|---|---|---|---|---|---|
| APC_ID | The Approval policy config Id | int | 4 | FALSE | ||
| APC_APPROVAL_POLICY_ID | Approval policy Id | int | 4 | FALSE | ||
| APC_METADATA_CONFIG_ID | Meta data config Id | int | 4 | FALSE | ||
| APC_ENTITY | Entity type | VARCHAR2 | 100 | FALSE | ||
| APC_NAME | Policy Name | VARCHAR2 | 255 | FALSE | ||
| APC_DESCRIPTION | Description | CLOB | 4000 | TRUE | ||
| APC_SUB_TYPE | Subtype of the entity | CLOB | 4000 | FALSE | ||
| APC_PROJECT_TYPE | Project Type of the entity | CLOB | 4000 | FALSE | ||
| APC_FROM_STATE | From state | VARCHAR2 | 255 | FALSE | ||
| APC_TO_STATE | To state | VARCHAR2 | 255 | FALSE | ||
| APC_REJECTED_STATE | Rejected state | VARCHAR2 | 255 | FALSE | ||
| APC_PENDING_APPROVAL_STATE | Pending Approval state | VARCHAR2 | 255 | FALSE | ||
| APC_IS_ACTIVE | Is active policy or not | VARCHAR2 | 1 | FALSE | ||
| APC_CREATED_BY | Approval policy created by | VARCHAR2 | 250 | TRUE | ||
| APC_CREATION_TIME | Creation time of the policy | DATE | 4 | TRUE | ||
| APC_MODIFIED_BY | Who modified the policy | VARCHAR2 | 250 | TRUE | ||
| APC_LAST_MODIFIED_TIME | Last modification time | DATE | 4 | TRUE | ||
| APC_VERSION_STAMP | Version | int | 4 | TRUE |
Indexes
| Index Name | Description | Primary | Unique |
|---|---|---|---|
| APPROVAL_POLICY_CONFIG_PK | Yes | Yes | |
| APC_POLICY_ID_IDX | |||
| APC_IS_ACTIVE_IDX |
