Active Session
Tables (5)
PT_DB_INSTANCE
- INSTANCE_ID — SB8 — Primary key
- INSTANCE_NAME — SCHR(33)
- DB_TYPE — UB1
PT_ORG
- PTO_ID — SB8 — Primary key
- ORG_0_PTO_ID — SB8
- ORG_1_PTO_ID — SB8
- ORG_2_PTO_ID — SB8
- ORG_3_PTO_ID — SB8
- ORG_4_PTO_ID — SB8
- ORG_5_PTO_ID — SB8
- ORG_6_PTO_ID — SB8
- ORG_7_PTO_ID — SB8
- ORG_8_PTO_ID — SB8
- ORG_9_PTO_ID — SB8
- SECURITY_LEVEL — UB2
- ACTIVE_FLAG — SB1
- ORG_ITEM_DEPTH — UB1
- STATUS — UB1
- ORG_0_NAME — SCHR(33)
- ORG_1_NAME — SCHR(33)
- ORG_2_NAME — SCHR(33)
- ORG_3_NAME — SCHR(33)
- ORG_4_NAME — SCHR(33)
- ORG_5_NAME — SCHR(33)
- ORG_6_NAME — SCHR(33)
- ORG_7_NAME — SCHR(33)
- ORG_8_NAME — SCHR(33)
- ORG_9_NAME — SCHR(33)
- ORG_ITEM_NAME — SCHR(33)
PT_SESS_STAT
- SID — SB8 — Primary key
- PSU_ID — SB8 — Foreign key → PT_SESS_USER.PSU_ID
- CURRENT_DBID — SB8
- SESS_CONTROL_ID — SB8
- SERVICE_ID — SB8
- N_QUERY — SB8
- N_RTN_ROWS — SB8
- N_DELETE — SB8
- N_DCL — UB4
- N_DDL — UB4
- N_PLS — UB4
- START_TIME — UB4
- END_TIME — UB4
- CLIENT_PID — UB4
- SERVER_PID — UB4
- DB_SESS_ID1 — UB4
- DB_SESS_ID2 — UB4
- SERVER_PORT — UB2
- RELAY_MODE — UB1
- TEST_FLAG — SB1
- STATUS — UB1
- BYPASS_FLAG — UB1
- SERVER_IP — SCHR(65)
- CLIENT_MACHINE — SCHR(65)
- CLIENT_TERMINAL — SCHR(65)
- INSTANCE_NAME — SCHR(65)
- CURRENT_SCHEMA — SCHR(33)
- N_INSERT — SB8
- N_UPDATE — SB8
PT_SESS_USER
- PSU_ID — SB8 — Primary key
- INSTANCE_ID — SB8 — Foreign key → PT_DB_INSTANCE.INSTANCE_ID
- PTU_ID — SB8 — Foreign key → PT_USER.PTU_ID
- ACCESS_PROTOCOL — UB1
- AUTH_USER — SCHR(65)
- CLIENT_IP — SCHR(65)
- CLIENT_MAC — SCHR(65)
- CLIENT_PROGRAM — SCHR(129)
- DB_SESS_USER — SCHR(33)
- OS_USER — SCHR(33)
PT_USER
- PTU_ID — SB8 — Primary key
- PTO_ID — SB8 — Foreign key → PT_ORG.PTO_ID
- ORG_UID — SCHR(33) — NOT NULL
- LAST_UPDATE — SB8
- SECURITY_LEVEL — UB1
- WORK_TYPE — UB1
- ACTIVE_FLAG — UB2
- STATUS — UB1
- NAME — SHCR(33)
- TITLE — SCHR(33)
- ROLE — SCHR(33)
- PHONE — SCHR(33)
- EMAIL — SCHR(33)
- MOBILE — SCHR(33)