[Home] [Help] [Dependency Information]
Object Name: | JTF_PF_SES_ACTIVITY |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_PF_SES_ACTIVITY |
Subobject Name: | |
Status: | VALID |
Activities that do fall under some session
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_PF_SES_ACTIVITY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SEQID |
JTF_PF_SES_ACTIVITY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DAY |
JTF_PF_SES_ACTIVITY_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SESSIONID |
JTF_PF_SES_ACTIVITY_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STATUSCODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQID | NUMBER | Yes | Sequence Id | |
DAY | DATE | Yes | Day of request | |
TIMESTAMP | DATE | Yes | Timestamp | |
SERVERNAME | VARCHAR2 | (300) | Apache Name | |
SERVERPORT | NUMBER | Apache port | ||
JSERVPORT | NUMBER | Jserv port | ||
FLOWID | NUMBER | DPF Flow ID | ||
SESSIONID | NUMBER | Yes | session id | |
USERID | NUMBER | Yes | user id | |
APPID | NUMBER | Yes | app id | |
RESPID | NUMBER | Yes | resp id | |
LANGID | VARCHAR2 | (20) | Yes | language id |
STARTT | NUMBER | Yes | start time | |
PAGENAME | VARCHAR2 | (300) | Yes | name of accessed page |
STATUSCODE | NUMBER | Yes | status code of request (whether it succeeded / failed etc) | |
EXECT | NUMBER | Yes | Exceution time | |
THINKT | NUMBER | Think time. Time between last request for this session and the current request | ||
PO | NUMBER | Yes | Link to Page Object | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard who col | |
CREATED_BY | NUMBER | (15) | Yes | Standard who col |
CREATION_DATE | DATE | Yes | Standard who col | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who col |
LAST_UPDATE_DATE | DATE | Yes | Standard who col | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who col | |
SECURITY_GROUP_ID | NUMBER | Standard who col | ||
TECH_STACK | VARCHAR2 | (20) | Yes | Tech Stack |
PROXYID | NUMBER | Proxy ID |
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;
JTF.JTF_PF_SES_ACTIVITY does not reference any database object
JTF.JTF_PF_SES_ACTIVITY is referenced by following:
|
|
|