VIEW: IBW.IBW_PAGE_VIEWS#

Source

View Text - Preformatted

select PAGE_VIEW_ID PAGE_VIEW_ID, PAGE_VIEW_SEQ_NUM PAGE_VIEW_SEQ_NUM, PAGE_INSTANCE_ID PAGE_INSTANCE_ID, VISIT_ID VISIT_ID, PAGE_VIEW_START_TIME PAGE_VIEW_START_TIME, PAGE_VIEW_DURATION PAGE_VIEW_DURATION, TRACKED_APPLICATION_CONTEXT TRACKED_APPLICATION_CONTEXT, TRACKED_SITE_CODE TRACKED_SITE_CODE, TRACKED_PAGE_CODE TRACKED_PAGE_CODE, TRACKED_PAGE_NAME TRACKED_PAGE_NAME, TRACKED_PAGE_URL TRACKED_PAGE_URL, SEARCH_RESULT_SIZE SEARCH_RESULT_SIZE, SEARCH_PHRASE SEARCH_PHRASE, EXACT_RESULT_SIZE_FLAG EXACT_RESULT_SIZE_FLAG, SITE_ID SITE_ID, PAGE_ID PAGE_ID, BUSINESS_CONTEXT_VALUE BUSINESS_CONTEXT_VALUE, BUSINESS_CONTEXT BUSINESS_CONTEXT, PARTY_ID PARTY_ID, VISITOR_ID VISITOR_ID, VISITANT_ID VISITANT_ID, EVNT_TYPE EVNT_TYPE, EVNT_ID EVNT_ID, CAMPAIGN_SOURCE_CODE_ID CAMPAIGN_SOURCE_CODE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REFERRAL_URL REFERRAL_URL, IP_ADDRESS IP_ADDRESS, BROWSER_OS_INFO BROWSER_OS_INFO, USER_ID USER_ID, USER_GUID USER_GUID, PARTY_RELATIONSHIP_ID PARTY_RELATIONSHIP_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "IBW"."IBW_PAGE_VIEWS"

View Text - HTML Formatted

SELECT PAGE_VIEW_ID PAGE_VIEW_ID
, PAGE_VIEW_SEQ_NUM PAGE_VIEW_SEQ_NUM
, PAGE_INSTANCE_ID PAGE_INSTANCE_ID
, VISIT_ID VISIT_ID
, PAGE_VIEW_START_TIME PAGE_VIEW_START_TIME
, PAGE_VIEW_DURATION PAGE_VIEW_DURATION
, TRACKED_APPLICATION_CONTEXT TRACKED_APPLICATION_CONTEXT
, TRACKED_SITE_CODE TRACKED_SITE_CODE
, TRACKED_PAGE_CODE TRACKED_PAGE_CODE
, TRACKED_PAGE_NAME TRACKED_PAGE_NAME
, TRACKED_PAGE_URL TRACKED_PAGE_URL
, SEARCH_RESULT_SIZE SEARCH_RESULT_SIZE
, SEARCH_PHRASE SEARCH_PHRASE
, EXACT_RESULT_SIZE_FLAG EXACT_RESULT_SIZE_FLAG
, SITE_ID SITE_ID
, PAGE_ID PAGE_ID
, BUSINESS_CONTEXT_VALUE BUSINESS_CONTEXT_VALUE
, BUSINESS_CONTEXT BUSINESS_CONTEXT
, PARTY_ID PARTY_ID
, VISITOR_ID VISITOR_ID
, VISITANT_ID VISITANT_ID
, EVNT_TYPE EVNT_TYPE
, EVNT_ID EVNT_ID
, CAMPAIGN_SOURCE_CODE_ID CAMPAIGN_SOURCE_CODE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REFERRAL_URL REFERRAL_URL
, IP_ADDRESS IP_ADDRESS
, BROWSER_OS_INFO BROWSER_OS_INFO
, USER_ID USER_ID
, USER_GUID USER_GUID
, PARTY_RELATIONSHIP_ID PARTY_RELATIONSHIP_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "IBW"."IBW_PAGE_VIEWS"