EGP_TEMP_DATA
This table is to store filter query applied in Batch Edit page, so that we can apply the same filter while opening the Excel, in order to show only filter records in Excel.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
EGP_TEMP_DATA_PK |
CONTENT_UNIQUE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CONTENT_UNIQUE_ID | NUMBER | 18 | Yes | Content unique identifier on table | |
CONTENT_TYPE | VARCHAR2 | 100 | Type of the content used in data | ||
CONTENT_PK1_VALUE | VARCHAR2 | 100 | First unique identifier of the object | ||
CONTENT_PK2_VALUE | VARCHAR2 | 100 | Second unique identifier of the object | ||
CONTENT_PK3_VALUE | VARCHAR2 | 100 | Third unique identifier of the object | ||
CONTENT_PK4_VALUE | VARCHAR2 | 100 | Fourth unique identifier of the object | ||
CONTENT_PK5_VALUE | VARCHAR2 | 100 | Fifth unique identifier of the object | ||
CONTENT_CLOB | CLOB | Clause used in the user interface | |||
LAST_ACCESSED_DATE | DATE | Date when the clause is last used | |||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who 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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
EGP_TEMP_DATA_U1 | Unique | Default | CONTENT_UNIQUE_ID |