WEB HITS LOCKER Table
Master list of all AFS (Athena) lockers in which web pages are stored and which have web hits information in the warehouse. Used in the Web Hits reports to select locker name(s) for reporting. For example, if your web pages are at the adress "http://web.mit.edu/chemistry/" then the locker name you need to choose will be "chemistry". This is a dimension table and is designed to be joined to the WEB_HITS_DETAIL table via the LOCKER_KEY field.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
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 |
LOCKER_NAME |
AFS Locker Name (e.g. "warehouse", "admissions") |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |