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 NameField TypeColumn TypeDescription
DTTM_STAMPDateTime(26)TIMESTAMPSpecifies 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_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
PM_CHART_TYP_CNTNumber(15,0)DECIMAL(15) NOT NULLConcurrent Signon Data Count by Signoff Type
PM_CHART_TOT_CNTNumber(15,0)DECIMAL(15) NOT NULLConcurrent Signon total Count by DateTime
DESCRSHORTCharacter(10)VARCHAR2(10) NOT NULLShort Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19