EDR_RECORD_ACTION_DETAILS

This table stores the actions performed by an individual against an e-record, like download, print.

Details

• Schema: FUSION

• Object owner: EDR

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
EDR_RECORD_ACTION_DETAILS_PK	ACTION_DETAIL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACTION_DETAIL_ID	NUMBER		18	Yes	This is the primary key and its value is an application generated unique id. It is used to uniquely identify the action details for an e-record.
RECORD_ID	NUMBER		18	Yes	Represents foreign key to EDR_RECORDS table. It is used to uniquely identify the e-record for an ERES transaction.
ACTION_CODE	VARCHAR2	30		Yes	Identifies the controlled action performed on the electronic record output. Source: lookup type ORA_EDR_ACTION_TYPE_CODE. Valid values are defined by ORA_EDR_ACTION_TYPE_CODE; current examples include DOWNLOAD = downloaded record and PRINT = printed record.
ACTION_COMPLETED_FLAG	VARCHAR2	1		Yes	Indicates whether the requested electronic record action completed successfully. Valid values: Y = the action completed; N = the action did not complete or was not completed.
FND_ATTACHMENT_ID	NUMBER		18		Identifies the FND attachment record for the output affected by the action. This may reference either a collated combined electronic record output or a single electronic record output, depending on the action execution context.
ACTION_GROUP_ID	NUMBER		18		Identifies the action execution group used to associate multiple electronic records with the same print or download operation. Rows with the same action group represent records processed together in a single grouped action.
RECORD_SEQUENCE_NUMBER	NUMBER		9		Indicates the sequence of the electronic record within an action group. Used to preserve ordering when multiple records are processed together as part of a collated or grouped print or download action.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
EDR_RECORD_ACTION_DETAILS	edr_records	RECORD_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EDR_RECORD_ACTION_DETAILS_N01	Non Unique	Default	RECORD_ID
EDR_RECORD_ACTION_DETAILS_N02	Non Unique	Default	ACTION_GROUP_ID
EDR_RECORD_ACTION_DETAILS_U01	Unique	Default	ACTION_DETAIL_ID