Platform ERD

Oracle ATG Web Commerce

ATG Data Warehouse Guide

. Documentation HomeFeedbackHighlightingPrev Up Next
 
  • Contents
  • Search
loading table of contents...
  • 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
  • Knowledge Database Tables
    • KDW_CONTROL
    • KDW_SOLNCLASS_DIM
    • KDW_SOLNSTATUS_DIM
    • KDW_AUD_DIM
    • KDW_ACT_DIM
    • KDW_OWNGROUP_DIM
    • KDW_SOLN_DIM
    • KDW_SOLN_AUD
    • KDW_SOLN_TOPIC
    • KDW_SESSACTPK_FACT
    • KDW_PSESSACTPK
    • KDW_SACTTOTPK_FACT
    • KDW_PSACTTOTPK
    • KDW_AGENTACT_FACT
    • KDW_SOLNACT_FACT
    • Knowledge ERD
  • Self Service Database Tables
    • SSVC_CONTROL
    • SSVC_SESSINIT_FACT
    • SSVC_ESCATM_FACT
    • SSVC_DEESCATM_FACT
    • SSVC_ESCCMP_FACT
    • SSVC_DEESCSUC_FACT
    • SSVC_DEESCUNS_FACT
    • SSVC_SESSPROC
    • Self Service ERD
  • Outreach Database Tables
    • ARF_CAMPAIGN
    • ARF_CAMPAIGN_STAGE
    • ARF_CAMPAIGN_ACTION_TYPE
    • ARF_CAMPAIGN_ACTION
    • ARF_CAMPAIGN_EVENT
    • ARF_LANDING_PAGE
    • ARF_EMAIL_DOMAIN
    • ARF_CAMPAIGN_ENTERED_FACT
    • ARF_CAMPAIGN_ACTION_FACT_TYPE
    • ARF_CAMPAIGN_ACTION_FACT
    • ARF_CAMPAIGN_AUDIT_TRAIL_FACT
    • Outreach 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
  • Index