PSPMCSOCHRT_VW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 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.

2 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

3 PM_CHART_TYP_CNT Number(15,0) DECIMAL(15) NOT NULL Concurrent Signon Data Count by Signoff Type

4 PM_CHART_TOT_CNT Number(15,0) DECIMAL(15) NOT NULL Concurrent Signon total Count by DateTime

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	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
3	PM_CHART_TYP_CNT	Number(15,0)	DECIMAL(15) NOT NULL	Concurrent Signon Data Count by Signoff Type
4	PM_CHART_TOT_CNT	Number(15,0)	DECIMAL(15) NOT NULL	Concurrent Signon total Count by DateTime
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description