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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
LOGIPADDRESSCharacter(40)VARCHAR2(40) NOT NULLClient name / IP Address
LOGINDTTMDateTime(26)TIMESTAMPLog In Time
LOGOUTDTTMDateTime(26)TIMESTAMPLog Out Time
PM_SIGNON_TYPECharacter(3)VARCHAR2(3) NOT NULLPeopleSoft SIgnon Source
0=Miscellaneous
1=PIA

Default: 0

PM_SIGNOFF_TYPECharacter(3)VARCHAR2(3) NOT NULLPIA 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19