EDR_SIGNATURE_DEFINITIONS_
Audit/history table for EDR signature definition setup. Preserves historical versions of signature definition configuration, including transaction type, signature organization, electronic record and signature enablement, signature mode, ad hoc signer scope, seed data source, and signature mode editability. Used for setup audit, troubleshooting, and internal audit framework processing; this is not the primary active signature definition setup table.
Details
-
Schema: FUSION
-
Object owner: EDR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
EDR_SIGNATURE_DEFINITIONS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, SIGNATURE_DEFINITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SIGNATURE_DEFINITION_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id.It is used to uniquely identify a signature definition for a transaction type and organization. | |
| ADHOC_SIGNER_SCOPE | VARCHAR2 | 20 | Indicates the permitted scope of ad hoc signer modifications for the transaction type and signature organization. Source: ORA_EDR_ADHOC_SIGNER_SCOPE Lookup type. Valid values: ORA_NONE = ad hoc signer modifications are not allowed; ORA_ADHOC = allowed to add or delete only signers added by the signature initiator; ORA_ALL = signer modifications are allowed for all applicable signer assignments, subject to setup and security rules. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| SIGNATURE_ORGANIZATION_ID | NUMBER | 18 | Refers to the organization for which the signature definition is set up. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | One of the supported ERES transaction types. | ||
| SIGNATURE_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether ERES signature is enabled for a given transaction type and organization. | ||
| SIGNATURE_MODE | VARCHAR2 | 30 | Identifies when electronic signatures are captured for this transaction type and signature organization. Source: lookup type ORA_EDR_SIGNATURE_MODE; defaulted from EDR_TRANSACTION_TYPES_B for the transaction type. Valid values are defined by ORA_EDR_SIGNATURE_MODE; current modes include INLINE = signatures are captured as part of the transaction flow and DEFERRED = signatures are captured after the transaction through a deferred signing task or workflow. | ||
| RECORD_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether ERES record is enabled for a particular signature definition. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | ||
| SIGNATURE_MODE_EDITABLE_FLAG | VARCHAR2 | 1 | Indicates whether the signature mode is editable for a given transaction type. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EDR_SIGNATURE_DEFINITIONS_U01_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, SIGNATURE_DEFINITION_ID |
| EDR_SIGNATURE_DEFINITIONS_U02_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, SIGNATURE_ORGANIZATION_ID, TRANSACTION_TYPE_CODE |
| EDR_SIGNATURE_DEFN_N1_ | Non Unique | Default | SIGNATURE_DEFINITION_ID, LAST_UPDATE_DATE |
| EDR_SIGNATURE_DEFN_N2_ | Non Unique | Default | AUDIT_ACTION_TYPE_ |