External User Tables
This section describes the tables that hold information about the external users of your sites.
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
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
Search Terms
