FND_CA_DEVICE_FACT
The device metrics provide visibility into our users devices and clients, such as device type, browser type, operating system, and screen resolution. We capture these at an app level, and count in terms of sessions.
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: FND_CA_DEVICE_FACT
Primary Key
| Name | Columns |
|---|---|
|
FND_CA_DEVICE_FACT_PK |
SEQ_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SEQ_ID | NUMBER | 18 | Yes | SEQ_ID | |
| TIMELINE_ID | VARCHAR2 | 256 | Yes | TIMELINE_ID | |
| PAGE_GROUPING_ID | VARCHAR2 | 256 | Yes | PAGE_GROUPING_ID | |
| ENV_ID | VARCHAR2 | 256 | Yes | ENV_ID | |
| DEVICE_ID | VARCHAR2 | 256 | Yes | DEVICE_ID | |
| DEVICE_PAGE_VIEWS | NUMBER | 30 | DEVICE_PAGE_VIEWS | ||
| 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 |
|---|---|---|---|
| FND_CA_DEVICE_FACT_U1 | Unique | FND_CA_DEVICE_FACT_U1 | SEQ_ID |