Platform ERD
Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved.
Legal Notices
ATG Data Warehouse Guide
Documentation Home
Feedback
Highlighting
Prev
Up
Next
Contents
Search
Introduction
Data Model for Oracle Business Intelligence
Key to Column Data Type Names
Common Database Tables
Time Tables
ARF_CAL_MOY
ARF_CAL_DOW
ARF_CAL_QOY
ARF_TIME_YEAR
ARF_TIME_QTR
ARF_TIME_MONTH
ARF_TIME_WEEK
ARF_TIME_DAY
ARF_TIME_HOUR
ARF_TIME_TOD
ARF_TIME_INTERVAL
Time Loaders
Time Jobs
Time Dimension Handlers
Internal User Directory Tables
ARF_IU_USER
ARF_IU_ORG
ARF_IU_DIR_LVL
Internal User Loaders
Internal User Jobs
Internal User Dimension Handlers
External User Tables
ARF_USER
ARF_ORGANIZATION
ARF_USER_AGENT
Demographic Tables
ARF_GENDER
ARF_AGE_GROUP
ARF_LANGUAGE
ARF_MARITAL_STATUS
ARF_GEO_COUNTRY
ARF_GEO_REGION
ARF_DEMOGRAPHIC
Segment Tables
ARF_SEGMENT
ARF_SEGCLSTR
ARF_SEGCLTR_MBRS
Stimulus Group Tables
ARF_STIMULUS
ARF_STIMGRP
ARF_STIMGRP_MBRS
Question Tables
ARF_QUESTION_TYPE
ARF_QUESTION_TYPE_GROUP
ARF_QUESTION_TYPE_GROUP_MBRS
ARF_QUESTION
ARF_SEARCH_NUMBER
ARF_SEARCH_NUMBER_GROUP
ARF_SEARCH_NUMBER_GRP_MBRS
Site Table
ARF_SITE
Unregistered Sites in Oracle ATG Web Commerce Business Intelligence
Site Visit Table
Site Visit Durations
DURATION_SECONDS
TOTAL_ELAPSED_DURATION_SECONDS
SITE_VISIT_DURATION_SECONDS
RESOURCE_DURATION_SECONDS
Currency Table
Referrer Table
Registration Table
Platform ERD
Commerce Database Tables
ARF_CURRENCY_CONV
ARF_CATEGORY
ARF_COUPON
ARF_PRODUCT
ARF_SKU
ARF_PROMOTION
ARF_PROMOTION_USAGE
ARF_PROMOGRP
ARF_PROMOGRP_MBRS
ARF_SALES_CHANNEL
ARF_LINE_ITEM
ARF_RET_REASON_DISPOSITION
ARF_RETURN_ITEM
Commerce ERD
Commerce Service Center Database Tables
ARF_CALL
Commerce Service Center ERD
Search Database Tables
ARF_SEARCH_PROJECT
ARF_SEARCH_ENVIRONMENT
ARF_QUERY_TYPE
ARF_CONTENT
ARF_SEARCH_TOPIC
ARF_TOPIC_GROUP
ARF_TOPIC_GROUP_MBRS
ARF_WORD
ARF_WORD_GROUP
ARF_WORD_GROUP_MBRS
ARF_DICTIONARY_ADAPTER
ARF_CUSTOM_TERM
ARF_CUSTTRM_GRP
ARF_CUSTTRM_GRP_MBRS
ARF_FINDER_TERM
ARF_FINDTRM_GRP
ARF_FINDTRM_GRP_MBRS
ARF_NULL_TERM
ARF_NULLTRM_GRP
ARF_NULLTRM_GRP_MBRS
ARF_NULX_TERM
ARF_NULXTRM_GRP
ARF_NULXTRM_GRP_MBRS
ARF_PROFILE_TYPE
ARF_SEARCH_CONFIG
ARF_SEARCH_RULE_TYPE
ARF_SEARCH_RULE
ARF_SEARCH_RULE_GRP
ARF_SEARCH_RULE_GRP_MBRS
ARF_SRCH_SITE_CONSTR
ARF_SRCH_SITE_CONSTR_MBRS
ARF_QUERY
ARF_VIEW_CONTENT
ARF_SEARCH_SITE_VISIT
Search ERD
Aggregated Data
Aggregated Data Tables
ARF_SITE_VISIT_MV
ARF_SITE_VISIT_MV_HOUR
ARF_SITE_VISIT_MV_VISITOR
ARF_REGISTRATION_MV
ARF_LINE_ITEM_MV_PRODUCT
ARF_LINE_ITEM_MV_SUPPL_ORDERS
ARF_LINE_ITEM_MV_UNIQUE_ORDERS
ARF_QUERY_MV_HOUR
ARF_QUERY_MV_QUESTION
ARF_QUERY_MV_TYPE
ARF_QUERY_MV_VISIT
ARF_PROMOTION_USAGE_MV
ARF_CALL_MV
Refreshing Aggregated Data
Refreshing Individual Views
Search Terms