SITE_VISIT_ID

bigint

No

Identifier; primary key.

START_TIMESTAMP

timestamp

Yes

The date and time that the HTTP session started.

START_DAY_ID

varchar

40

No

Day the session began. Foreign key to ARF_TIME_DAY.ID column.

START_TIME_ID

integer

No

Time the session began. Foreign key to ARF_TOD.ID column.

END_DAY_ID

integer

No

Day on which the session ended. Foreign key to ARF_TIME_DAY.ID column.

END_TIME_ID

integer

No

Time at which the session ended. Foreign key to ARF_TIME_TOD.ID column.

START_VISIT_TIMESTAMP

timestamp

Yes

The date and time that the site visit started.

SITE_VISIT_START_DAY_ID

varchar

40

No

Day the site visit began. Foreign key to ARF_TIME_DAY.ID column.

SITE_VISIT_START_TIME_ID

integer

No

Time the site visit began. Foreign key to ARF_TOD.ID column.

SITE_VISIT_END_DAY_ID

varchar

40

No

Day on which the site visit ended. Foreign key to ARF_TIME_DAY.ID column.

SITE_VISIT_END_TIME_ID

integer

40

No

Time at which the site visit ended. Foreign key to ARF_TIME_TOD.ID column.

VISIT_END_TIME_ID

integer

No

Time at which the user made the last HTTP request in the session. This is different from END_TIME_ID when the session ends by timing out. Foreign key to ARF_TIME_TOD.ID column.

VISITOR_ID

integer

No

User ID of visitor. Foreign key to ARF_USER.ID column.

If visitor is anonymous, this is set to Unspecified User.

STIMGRP_ID

smallint

No

Stimulus group associated with the visit. Foreign key to ARF_STIMGRP.ID column.

DEMOGRAPHIC_ID

smallint

No

Demographic which represents the demographic profile of this site visit. Foreign key to ARF_DEMOGRAPHIC.ID.

SITE_ID

smallint

No

The site at which the visit took place. Foreign key to ARF_SITE.ID.

ENTRY_SITE_ID

smallint

No

The first site visited during the HTTP session in which this site visit occurred. Foreign key to ARF_SITE.ID.

EXIT_SITE_ID

smallint

No

The last site visited during the HTTP session in which this site visit occurred. Foreign key to ARF_SITE.ID.

REFERRING_SITE_ID

smallint

No

The previous site visited during the HTTP session in which this site visit occurred. Foreign key to ARF_SITE.ID.

SEQUENCE_NUM

tinyint

No

The rank order in which this site visit took place during an HTTP session.

USER_AGENT_ID

smallint

No

The record in ARF_USER_AGENT that is associated with the site visit.

REFERRER_ID

smallint

No

The record in ARF_REFERRER that is associated with the site visit.

SESSION_ID

varchar

128

No

The identifier of the HTTP session in which the visit occurred. The session identifier is assigned by the application server.

NUM_PAGE_VIEWS

smallint

No

Number of pages the visitor viewed during the visit.

DURATION_SECONDS

smallint

No

Duration of the HTTP session in seconds. See DURATION_SECONDS.

TOTAL_ELAPSED_DURATION_SECONDS

integer

No

The number of seconds that pass between the first and last HTTP requests in the HTTP session. See TOTAL_ELAPSED_DURATION_SECONDS.

SITE_VISIT_DURATION_SECONDS

integer

No

The number of seconds that pass between the first and last HTTP requests in the site visit. See SITE_VISIT_DURATION_SECONDS.

RESOURCE_DURATION_SECONDS

integer

No

The total number of seconds that a user spends visiting one site during an HTTP session. See RESOURCE_DURATION_SECONDS.