PSPMCSOCHRT_VW

 index back

SELECT A.DTTM_STAMP , A.PM_SIGNOFF_TYPE , A.PM_CHART_TYP_CNT , A.PM_CHART_TOT_CNT , X.XLATSHORTNAME FROM PSPMCSO_CHART A , PSPMCSOCHRTFLT B , PSXLATITEM X WHERE A.PM_CHART_DUP_FLAG = B.PM_CHART_DUP_FLAG AND A.PM_SIGNON_TYPE = B.PM_SIGNON_TYPE AND A.PM_SIGNOFF_TYPE = X.FIELDVALUE AND X.FIELDNAME = 'PM_SIGNOFF_TYPE' AND ((A.PM_CHART_TOT_CNT >= 2 AND B.PM_CHART_DUP_FLAG = 'Y') OR (A.PM_CHART_TOT_CNT >= B.PM_CHART_MIN_CNT AND B.PM_CHART_DUP_FLAG = 'N'))

PeopleSoft Field Name Field Type Column Type Description
DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
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
PM_CHART_TYP_CNT Number(15,0) DECIMAL(15) NOT NULL Concurrent Signon Data Count by Signoff Type
PM_CHART_TOT_CNT Number(15,0) DECIMAL(15) NOT NULL Concurrent Signon total Count by DateTime
DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20