ATG Customer Intelligence Data Warehouse Guide
.
Documentation Home
Feedback
Highlighting
Prev
Up
Next
Platform 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
Platform 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
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_CURRENCY
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
User Table
Site Visit Table
Platform ERD
Commerce Database Tables
ARF_CURRENCY_CONV
ARF_CATEGORY
ARF_PRODUCT
ARF_SKU
ARF_PROMOTION
ARF_PROMOGRP
ARF_PROMOGRP_MBRS
ARF_LINE_ITEM
DCS_PROF_PROD_PURCH_FACT
DCS_PROF_BRAND_PURCH_FACT
DCS_PROF_CAT_PURCH_FACT
DCS_PROF_PRICE_FACT
DCS_PROD_AFF_FACT
DCS_PROD_AFF_GLOBAL_FACT
DCS_CAT_AFF_FACT
DCS_CAT_AFF_GLOBAL_FACT
DCS_AFF_EXT_STATUS
DCS_AFF_EXT_STATUS_DAYS
Commerce 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
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_QUESTION_TYPE
ARF_QUESTION_TYPE_GROUP
ARF_QUESTION_TYPE_GROUP_MBRS
ARF_QUESTION
ARF_CONTENT
ARF_SEARCH_NUMBER
ARF_SEARCH_NUMBER_GROUP
ARF_SEARCH_NUMBER_GRP_MBRS
ARF_SEARCH_TOPIC
ARF_TOPIC_GROUP
ARF_TOPIC_GROUP_MBRS
ARF_WORD
ARF_WORD_GROUP
ARF_WORD_GROUP_MBRS
ARF_PROFILE_TYPE
ARF_QUERY
ARF_VIEW_CONTENT
ARF_SEARCH_SITE_VISIT
Search ERD
Platform Metadata Model
Platform Action Logs
Time Metadata
Gender Metadata
Age Group Metadata
Language Metadata
Marital Status Metadata
Demographic Metadata
Currency Metadata
Country and Region Metadata
Segment Metadata
Stimulus Metadata
User Metadata
Site Visit Metadata
Internal User Directory Metadata
Internal User Action Logs
Internal User Directory Model View
Internal User Directory Dimensional View
Commerce Metadata Model
Catalog Metadata
Order Metadata
Affinity Metadata
Aggregate Affinity Facts
Personal Affinity Facts
Knowledge Metadata Model
Knowledge Action Logs
Knowledge Model View
Knowledge Dimensional View
Outreach Metadata Model
Outreach Model View
Email Recipient Lists
Audit Trail Facts
Email Facts
Participation Facts
Outreach Dimensional View
Search Metadata Model
Search Model View
Search Dimensional View
Glossary