WEB HITS DETAIL Table
Detailed 'web hits' information. Provided for the MIT community to report on hits on their web pages. Information includes the URL accessed, the date of the access and various information about the accessor (for example the browser and operating system used to access the URL). The counter represents the number of hits on the web page on a given day from users with the same OS, browser, domain code etc.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
ACCESS_DATE |
Date a web page was accessed. |
DATE |
8 |
AFS_LOCKER |
Identifies a locker on AFS. For example, documents accessed at the URL "http://web.mit.edu/admissions/" are in the AFS locker "admissions". |
VARCHAR2 |
100 |
BROWSER |
Web Browser name. Used in web statistics reporting. Examples are 'Netscape' or 'MS Internet Explorer'. |
VARCHAR2 |
100 |
BROWSER_VERSION |
This is the version number of the Web Browser that generated a "web hit". For example if someone used Netscape Navigator 4 to view your web site, a web hit would be generated with a browser version of 4. |
VARCHAR2 |
12 |
COUNTER |
Numeric field used to count entries in a table. Can be summed on a report. Example - if this field appeared on a table of Person information, it could be used on reports to show headcounts. |
NUMBER |
1 |
IS_ACCESS_FROM_MIT |
Indicates whether a web page was accessed by a computer at MIT or outside MIT. Values are 'Y' (access from MIT) or 'N' (access from outside MIT). |
VARCHAR2 |
1 |
LOCKER_KEY |
Key used for joining the WEB_HITS_LOCKER and WEB_HITS_DETAIL tables together. This field should be used only for joining tables, and should not be placed on reports. |
VARCHAR2 |
100 |
OPERATING_SYSTEM |
Name of an Operating System category, used in web statistics reporting. Examples are 'Windows 95/98' and 'Macintosh'. |
VARCHAR2 |
40 |
TOP_LEVEL_DOMAIN_KEY |
Key used for joining the TOP_LEVEL_DOMAIN and WEB_HITS_DETAIL tables together. This field should be used only for joining tables, and should not be placed on reports. |
VARCHAR2 |
6 |
URL_ACCESSED |
URL of a web page accessed by a user. Used in web page statistics reporting. |
VARCHAR2 |
500 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |