[Home] [Help] [Dependency Information]
Object Name: | JTF_PF_SES_ACTIVITY# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQID | NUMBER | Yes | ||
DAY | DATE | Yes | ||
TIMESTAMP | DATE | Yes | ||
SERVERNAME | VARCHAR2 | (300) | ||
SERVERPORT | NUMBER | |||
JSERVPORT | NUMBER | |||
FLOWID | NUMBER | |||
SESSIONID | NUMBER | Yes | ||
USERID | NUMBER | Yes | ||
APPID | NUMBER | Yes | ||
RESPID | NUMBER | Yes | ||
LANGID | VARCHAR2 | (20) | Yes | |
STARTT | NUMBER | Yes | ||
PAGENAME | VARCHAR2 | (300) | Yes | |
STATUSCODE | NUMBER | Yes | ||
EXECT | NUMBER | Yes | ||
THINKT | NUMBER | |||
PO | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SECURITY_GROUP_ID | NUMBER | |||
TECH_STACK | VARCHAR2 | (20) | Yes | |
PROXYID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SEQID
, DAY
, TIMESTAMP
, SERVERNAME
, SERVERPORT
, JSERVPORT
, FLOWID
, SESSIONID
, USERID
, APPID
, RESPID
, LANGID
, STARTT
, PAGENAME
, STATUSCODE
, EXECT
, THINKT
, PO
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, TECH_STACK
, PROXYID
FROM JTF.JTF_PF_SES_ACTIVITY#;
|
|
|