Page History
...
PW_WWPL_PAGE_LOOKUP
List of pages.
| Column Name | Column Description |
|---|---|
WWPL_URL_ID | The URL ID. |
WWPL_WWDO_ID | The domain ID. |
WWPL_PROTOCOL | Protocol. The data transfer standard (HTTP, HTTPS). |
WWPL_PATH_PART | The part of the path inside the URL. |
WWPL_SPLITTER | The character(s) used to separate the path and the parameters. |
WWPL_PARM_PART | The parameters. For example: a=1&b=2&c=3. |
WWPL_URL_FILE_EXT | File extension. For example: html, htm, asp, jsp. |
WWPL_TITLE | Page title. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
WWPL_PATH_PART||WWPL_SPLITTER||WWPL_PARM_PART | WWPL_PATH_PART+WWPL_SPLITTER+WWPL_PARM_PART | Page URL. |
PW_WWUL_URL_LOOKUP
List of URLs.
| Column Name | Column Description |
|---|---|
WWUL_URL_ID | The URL ID. |
WWUL_WWDO_ID | The domain ID. |
WWUL_PROTOCOL | Protocol. The data transfer standard (HTTP, HTTPS). |
WWUL_PATH_PART | The part of the path inside the URL. |
WWUL_SPLITTER | The character(s) used to separate the path and the parameters. |
WWUL_PARM_PART | The parameters. For example: a=1&b=2&c=3. |
WWUL_URL_FILE_EXT | File extension. For example: html, htm, asp, jsp. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
WWUL_PATH_PART||WWUL_SPLITTER||WWUL_PARM_PART | WWUL_PATH_PART+WWUL_SPLITTER+WWUL_PARM_PART | Page URL. |
PW_WWDO_DOMAIN
List of domains.
| Column Name | Column Description |
|---|---|
WWDO_NAME | Name of the domain. |
PW_WWCO_COUNTRY
List of countries from where users are surfing.
| Column Name | Column Description |
|---|---|
WWCO_INITIAL | The country initials from where the user is surfing. For example: IL - Israel. |
WWCO_NAME | The country from where the user is surfing. There are two special values:
Internal means that the user is surfing from within the IP range of the company. |
PW_WWST_STATE
List of states from where users are surfing.
| Column Name | Column Description |
|---|---|
WWST_INITIAL | The state initials from where the user is surfing. For example: TX - Texas. |
WWST_NAME | The state from where the user is surfing. There are two special values:
Internal means that the user is surfing from within the IP range of the company. |
PW_WWCI_CITY
List of cities from where users are surfing.
| Column Name | Column Description |
|---|---|
WWCI_NAME | The city from where the user is surfing. There are two special values:
Internal means that the user is surfing from within the IP range of the company. |
PW_WWCL_CLIENT
List of user client machines.
| Column Name | Column Description |
|---|---|
WWCL_CLIENT | The client machine name. |
PW_WWAU_APPLICATION_USER
List of the application users. This is the user name for entering PeopleSoft.
| Column Name | Column Description |
|---|---|
WWAU_NAME | The application user login name. |
PW_WWLO_LOGIN
List of user logins.
| Column Name | Column Description |
|---|---|
WWLO_LOGIN | The login name of the user. |
PW_WWCR_COUNTER
List of instance statistics counters.
| Column Name | Column Description |
|---|---|
WWCR_NAME | The instance statistic counter name. |
PW_WWBT_BUSINESS_TRAN_GRP_VIEW
Basic transaction grouping view.
| Column Name | Column Description |
|---|---|
INGD_NAME | The business transaction group name. |
WWPL_NAME | The page URL. |