PSPMCSOLOG_VW

index back

Concurrent Signon View

The is a view that combines related signon and signoff rows into a single row.
SELECT a.PM_METRIC_VALUE7 , a.PM_CONTEXT_VALUE2 , a.PM_AGENT_STRT_DTTM , b.PM_AGENT_STRT_DTTM , '1' , %Substring(%NumToChar(b.PM_METRIC_VALUE1),1,1) FROM PSPMTRANSHIST a , PSPMTRANSHIST b WHERE a.PM_CONTEXT_VALUE1 = b.PM_CONTEXT_VALUE1 AND b.PM_TRANS_DEFN_ID = 108 AND a.PM_TRANS_DEFN_ID = 109 UNION SELECT a.PM_METRIC_VALUE7 , a.PM_CONTEXT_VALUE2 , a.PM_AGENT_STRT_DTTM , a.PM_AGENT_STRT_DTTM , '1' , '0' FROM PSPMTRANSHIST a WHERE a.PM_CONTEXT_VALUE1 NOT IN ( SELECT PM_CONTEXT_VALUE1 FROM PSPMTRANSHIST WHERE PM_TRANS_DEFN_ID = 108) AND a.PM_TRANS_DEFN_ID = 109

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
LOGIPADDRESS Character(40) VARCHAR2(40) NOT NULL Client name / IP Address
LOGINDTTM DateTime(26) TIMESTAMP Log In Time
LOGOUTDTTM DateTime(26) TIMESTAMP Log Out Time
PM_SIGNON_TYPE Character(3) VARCHAR2(3) NOT NULL PeopleSoft SIgnon Source
0=Miscellaneous
1=PIA

Default: 0

PM_SIGNOFF_TYPE Character(3) VARCHAR2(3) NOT NULL PIA Signoff Tpye
0=Unknown
1=Logged Off
2=Session Expired
3=Session Exception
4=Session Abandoned
9=Still Signed On

Default: 0

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19