ATG Customer Intelligence Data Warehouse Guide
.
Documentation Home
Feedback
Highlighting
Prev
Up
Next
Search ERD
Contents
Search
Introduction
Audience
Document Conventions
More Information
Introduction to the ATG Data Warehouse
Introduction to the Metadata Model
Key to Column Data Type Names
Common Database Tables
Localizing Table Data
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
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
Currency Table
User Table
Site Visit Table
Platform ERD
Commerce Database Tables
ARF_CURRENCY_CONV
ARF_CATEGORY
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
SSVS_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_SEARCH_SITE
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_QUERY
ARF_VIEW_CONTENT
ARF_SEARCH_SITE_VISIT
Search ERD
Commerce Metadata Model
Commerce Metadata Overview
Site Visit Facts
Sales Facts
Promotions Facts
Return Facts
Time Metadata
Gender Metadata
Age Group Metadata
Marital Status Metadata
Demographic Metadata
Country and Region Metadata
Local Currency Metadata
Segment Cluster Metadata
Stimulus Group Metadata
Visitor and Customer Metadata
Site Visit Metadata
Catalog Metadata
Order Metadata
Promotion Group Metadata
Promotion Metadata
Promotion Usage Metadata
Sales Channel Metadata
Agent Metadata
Return Metadata
Commerce Search Metadata
Knowledge Metadata Model
Common Metadata
Knowledge Time Metadata
Knowledge Internal User Directory Metadata
Activity Metadata
Audience Metadata
Owning Group Metadata
Solution Status Metadata
Solution Class Metadata
Language Metadata
Solution Activity Metadata
Session Activity Peak Concurrency Metadata
Agent Activity Metadata
Best Bets Metadata
Use Counts Metadata
Author Metadata
Modified By Metadata
Topic Metadata
Solution Metadata
Self Service Metadata Model
Self Service Time Metadata
Self Service Metadata
Commerce Service Center Metadata Model
Call Facts Metadata
Received Time Metadata
Received Date Metadata
Customer Metadata
Agent Metadata
End Date Metadata
End Time Metadata
Outreach Metadata Model
Outreach Metadata Overview
Email Facts
Audit Trail Facts
Participation Facts
Campaign Structure Metadata
Time Metadata
Campaign Metadata
Campaign Stage Metadata
Campaign Action Type Metadata
Campaign Action Metadata
Campaign Event Metadata
Campaign Action Landing Pages Metadata
Campaign Audit Trail Fact Metadata
Campaign Entered Fact Metadata
Email Domain Metadata
Landing Page Metadata
Email Fact Type Metadata
Email Fact Metadata
Segment Cluster Metadata
Participant Metadata
Search Metadata Model
Search Metadata Overview
Query Facts
Viewed Content Facts
Search Site Visits Facts
Site Visit Facts
Time Metadata
Gender Metadata
Age Group Metadata
Marital Status Metadata
Demographic Metadata
Country and Region Metadata
Segment Cluster Metadata
Stimulus Group Metadata
Site Visit Metadata
Site Metadata
Query Metadata
Query Type Metadata
Language Metadata
External User Metadata
Internal User Metadata
Content Metadata
Profile Type Metadata
Project and Environment Metadata
Dictionary Adapter Metadata
Question Metadata
Query Facts Metadata
Search Site Visit Metadata
Viewed Content Facts Metadata
Search Groups Metadata
Search Configuration Metadata
Glossary