PSPMCSOLOG_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 LOGIPADDRESS Character(254) VARCHAR2(254) NOT NULL Client name / IP Address
3 LOGINDTTM DateTime(26) TIMESTAMP Log In Time
4 LOGOUTDTTM DateTime(26) TIMESTAMP Log Out Time
5 PM_SIGNON_TYPE Character(3) VARCHAR2(3) NOT NULL PeopleSoft SIgnon Source
0=Miscellaneous
1=PIA

Default Value: 0

6 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 Value: 0