EDR_SIGNATURE_OUTCOMES

This table is used to store the child task identifiers related to a root task of the human task flow and the corresponding status.

Details

• Schema: FUSION

• Object owner: EDR

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
EDR_SIGNATURE_OUTCOMES_PK	TASK_ID

Columns

Name	Datatype	Length	Not-null	Comments
TASK_ID	VARCHAR2	64	Yes	Unique identifier of the task associated with the signature process for an approver of transaction who is stamping his consent of Electronic Signature.
OAM_LAST_REAUTHENTICATION_TIME	TIMESTAMP			Stores the value of last reauthentication time set by the Access Manager in the OAM_LAST_REAUTHENTICATION_TIME HTTP header.
SIGNER_NAME	VARCHAR2	64	Yes	Indicates the username of the signer.
OAM_IDENTITY_DOMAIN	VARCHAR2	100		Stores the name of the identity domain that was in effect during reauthentication process.
OAM_REMOTE_USER	VARCHAR2	64		Stores the name of the user for whom reauthentication process was carried out.
STATUS	VARCHAR2	20		The status of a task could either be Approve or Reject.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
EDR_SIGNATURE_OUTCOMES_U1	Unique	Default	TASK_ID