[Home] [Help] [Dependency Information]
Object Name: | JTF_PF_SESSION_SUMM# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DAY | DATE | Yes | ||
SEQID | NUMBER | Yes | ||
SESSIONID | NUMBER | |||
USER_NAME | VARCHAR2 | (100) | ||
USERID | NUMBER | |||
SUM_EXECT_JTF | NUMBER | |||
SUM_THINKT_JTF | NUMBER | |||
CNT_PAGES_JTF | NUMBER | |||
SUM_EXECT_OAF | NUMBER | |||
SUM_THINKT_OAF | NUMBER | |||
CNT_PAGES_OAF | NUMBER | |||
SUM_EXECT_FORM | NUMBER | |||
SUM_THINKT_FORM | NUMBER | |||
CNT_PAGES_FORM | NUMBER | |||
CNT_PAGES_ALL | NUMBER | |||
UCNT_PAGES | NUMBER | |||
UCNT_FLOWS | NUMBER | |||
UCNT_USERS | NUMBER | |||
UCNT_APPS | NUMBER | |||
UCNT_RESPS | NUMBER | |||
UCNT_LANGS | NUMBER | |||
STARTT | NUMBER | Yes | ||
ENDT | NUMBER | Yes | ||
CNT_FAIL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DAY
, SEQID
, SESSIONID
, USER_NAME
, USERID
, SUM_EXECT_JTF
, SUM_THINKT_JTF
, CNT_PAGES_JTF
, SUM_EXECT_OAF
, SUM_THINKT_OAF
, CNT_PAGES_OAF
, SUM_EXECT_FORM
, SUM_THINKT_FORM
, CNT_PAGES_FORM
, CNT_PAGES_ALL
, UCNT_PAGES
, UCNT_FLOWS
, UCNT_USERS
, UCNT_APPS
, UCNT_RESPS
, UCNT_LANGS
, STARTT
, ENDT
, CNT_FAIL
FROM JTF.JTF_PF_SESSION_SUMM#;
|
|
|