[Home] [Help] [Dependency Information]
Object Name: | IBW_PAGE_VIEWS |
---|---|
Object Type: | TABLE |
Owner: | IBW |
Subobject Name: | |
Status: | VALID |
Stores the page view related information. Every page view is associated with one page instance and one visit. This table also stores page view sequence number, next page view id and previous page id to get the navigation related information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBW_PAGE_VIEWS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PAGE_VIEW_ID |
IBW_PAGE_VIEWS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VISIT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAGE_VIEW_ID | NUMBER | (15) | Yes | Page view identifier |
PAGE_VIEW_SEQ_NUM | NUMBER | (10) | Yes | Page view sequence number |
PAGE_INSTANCE_ID | NUMBER | (15) | Yes | Web Page instance identifier |
VISIT_ID | NUMBER | (15) | Yes | Visit identifier |
PAGE_VIEW_START_TIME | DATE | Yes | Web Page view start time | |
PAGE_VIEW_DURATION | NUMBER | (10) | Yes | Web Page view duration |
TRACKED_APPLICATION_CONTEXT | VARCHAR2 | (30) | Application context associated to Web Page | |
TRACKED_SITE_CODE | VARCHAR2 | (30) | Code to track Web Sites | |
TRACKED_PAGE_CODE | VARCHAR2 | (30) | Code to track Web Pages | |
TRACKED_PAGE_NAME | VARCHAR2 | (360) | Webpage name | |
TRACKED_PAGE_URL | VARCHAR2 | (4000) | Yes | Web Page URL |
SEARCH_RESULT_SIZE | NUMBER | (10) | Number of results from a web search | |
SEARCH_PHRASE | VARCHAR2 | (240) | Search Phrase from a web search | |
EXACT_RESULT_SIZE_FLAG | VARCHAR2 | (1) | Indicates if number of results from a web search is exact or an estimate | |
SITE_ID | NUMBER | (15) | Yes | Web Site identifier |
PAGE_ID | NUMBER | (15) | Yes | Web Page identifier |
BUSINESS_CONTEXT_VALUE | VARCHAR2 | (240) | Business context identifier | |
BUSINESS_CONTEXT | VARCHAR2 | (30) | Business object displayed within a Web Page. Valid values are PRODUCT and SECTION | |
PARTY_ID | NUMBER | (15) | Party identifier | |
VISITOR_ID | NUMBER | (15) | Visitor Identifier | |
VISITANT_ID | VARCHAR2 | (256) | Yes | Identifier used in calculation of unique visitors |
EVNT_TYPE | VARCHAR2 | (30) | Event type associated with page. Valid values are CART for carts, XCHKOUT for Express Checkout, ORDER for Order, USRREG for User Registration, SRCH for Search, INVINQ, invocie inquiry, PMTINQ for Payment Inquiry and ORDINQ for Order Inquiry. | |
EVNT_ID | VARCHAR2 | (240) | Event Identifier | |
CAMPAIGN_SOURCE_CODE_ID | NUMBER | (15) | Source code identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
REFERRAL_URL | VARCHAR2 | (4000) | Referral URL associated with a visit | |
IP_ADDRESS | VARCHAR2 | (30) | Visitor IP address | |
BROWSER_OS_INFO | VARCHAR2 | (240) | Browser and operating system related information | |
USER_ID | NUMBER | (15) | Application user identifier | |
USER_GUID | VARCHAR2 | (256) | SSO user identifier | |
PARTY_RELATIONSHIP_ID | NUMBER | (15) | Party Identifier where PARTY_TYPE is Relationship | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
PROGRAM_ID | NUMBER | Concurrent program identifier | ||
PROGRAM_LOGIN_ID | NUMBER | Oracle Application Concurrent Program Login identifier | ||
PROGRAM_APPLICATION_ID | NUMBER | Oracle Application identifier | ||
REQUEST_ID | NUMBER | Concurrent request instance identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PAGE_VIEW_ID
, PAGE_VIEW_SEQ_NUM
, PAGE_INSTANCE_ID
, VISIT_ID
, PAGE_VIEW_START_TIME
, PAGE_VIEW_DURATION
, TRACKED_APPLICATION_CONTEXT
, TRACKED_SITE_CODE
, TRACKED_PAGE_CODE
, TRACKED_PAGE_NAME
, TRACKED_PAGE_URL
, SEARCH_RESULT_SIZE
, SEARCH_PHRASE
, EXACT_RESULT_SIZE_FLAG
, SITE_ID
, PAGE_ID
, BUSINESS_CONTEXT_VALUE
, BUSINESS_CONTEXT
, PARTY_ID
, VISITOR_ID
, VISITANT_ID
, EVNT_TYPE
, EVNT_ID
, CAMPAIGN_SOURCE_CODE_ID
, OBJECT_VERSION_NUMBER
, REFERRAL_URL
, IP_ADDRESS
, BROWSER_OS_INFO
, USER_ID
, USER_GUID
, PARTY_RELATIONSHIP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM IBW.IBW_PAGE_VIEWS;
IBW.IBW_PAGE_VIEWS does not reference any database object
IBW.IBW_PAGE_VIEWS is referenced by following:
|
|
|