ZPS_CLIENT_USAGE_DETAILS
This table stores the detailed usage data(Action and Page View counts) of Office365 Client for Oracle Engagement Cloud. The data stored in this table would be used to analyze the Client usage.
Details
-
Schema: FUSION
-
Object owner: ZPS_365
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZPS_CLIENT_USAGE_DETAILS_PK |
USAGE_DETAILS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USAGE_DETAILS_ID | NUMBER | 18 | Yes | Primary key of the table | |
| USAGE_ID | NUMBER | 18 | Yes | Foreign key to table ZPS_CLIENT_USAGES | |
| OBJECT_NAME | VARCHAR2 | 100 | Yes | Name of OEC Object for which we track the Actions and Page Views. | |
| ACTION_TYPE | VARCHAR2 | 60 | Action Type of the Object, this field is to store the custom action types. | ||
| VIEW_TYPE | VARCHAR2 | 60 | View Type of the Object, this field is to store the custom view types. | ||
| ACT_READ_COUNT | NUMBER | 4 | Number of Read Actions per Object | ||
| ACT_READ_SUCCESS_COUNT | NUMBER | 4 | Number of Successful Read Actions per Object | ||
| ACT_CREATE_COUNT | NUMBER | 4 | Number of Create Actions per Object | ||
| ACT_CREATE_SUCCESS_COUNT | NUMBER | 4 | Number of Successful Create Actions per Object | ||
| ACT_EDIT_COUNT | NUMBER | 4 | Number of Update Actions per Object | ||
| ACT_EDIT_SUCCESS_COUNT | NUMBER | 4 | Number of Successful Update Actions per Object | ||
| ACT_DELETE_COUNT | NUMBER | 4 | Number of Delete Actions per Object | ||
| ACT_DELETE_SUCCESS_COUNT | NUMBER | 4 | Number of Successful Delete Actions per Object | ||
| PV_LIST_COUNT | NUMBER | 4 | Number of list page view count per Object | ||
| PV_DETAIL_COUNT | NUMBER | 4 | Number of Detail page view count per Object | ||
| PV_EDIT_COUNT | NUMBER | 4 | Number of Edit page view count per Object | ||
| PV_PICKER_COUNT | NUMBER | 4 | Number of Picker page view count per Object | ||
| 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. | ||
| 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 |
|---|---|---|---|
| ZPS_CLIENT_USAGE_DETAILS_U1 | Unique | Default | USAGE_DETAILS_ID |
| ZPS_CLIENT_USAGE_DETAILS_U2 | Unique | Default | USAGE_ID, OBJECT_NAME, ACTION_TYPE, VIEW_TYPE |