WEB HITS DETAIL Table
View exposing web hits detail data including web access logs, page views, session information, and access timestamps used for warehouse portal usage monitoring and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_DATE |
Date associated with access. |
DATE |
|
AFS_LOCKER |
Afs locker associated with the record. |
VARCHAR2 |
100 |
BROWSER |
Browser associated with the record. |
VARCHAR2 |
100 |
BROWSER_VERSION |
Browser version associated with the record. |
VARCHAR2 |
12 |
COUNTER |
Counter associated with the record. |
NUMBER |
10 |
IS_ACCESS_FROM_MIT |
Indicator identifying whether access from mit (Y/N). |
VARCHAR2 |
1 |
LOCKER_KEY |
Surrogate key identifying the locker. |
VARCHAR2 |
104 |
OPERATING_SYSTEM |
Operating system associated with the record. |
VARCHAR2 |
40 |
TOP_LEVEL_DOMAIN_KEY |
Surrogate key identifying the top level domain. |
VARCHAR2 |
6 |
URL_ACCESSED |
Url accessed associated with the record. |
VARCHAR2 |
500 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |