PTADSVLDINST_VW

index back

SELECT PTSESSIONID , PTADSNAME , PTADSCONTENTID , PROJECTNAME , COMPARETYPE , PTKEYHASH , MAX(CASE WHEN PTADSMSGSEVERITY = 'E' THEN PTADSMESSAGECOUNT ELSE 0 END) AS PTADSMSGCOUNT_E , MAX(CASE WHEN PTADSMSGSEVERITY = 'M' THEN PTADSMESSAGECOUNT ELSE 0 END) AS PTADSMSGCOUNT_I , MAX(CASE WHEN PTADSMSGSEVERITY = 'W' THEN PTADSMESSAGECOUNT ELSE 0 END) AS PTADSMSGCOUNT_W FROM PSADSVALINSTST GROUP BY PTSESSIONID , PTADSNAME , PTADSCONTENTID , PROJECTNAME , COMPARETYPE , PTKEYHASH

PeopleSoft Field Name Field Type Column Type Description
PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).
PTADSCONTENTID Number(6,0) INTEGER NOT NULL ADS Content Identifier
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
COMPARETYPE Number(5,0) INTEGER NOT NULL Compare Type
PTKEYHASH Character(28) VARCHAR2(28) NOT NULL
PTADSMSGCOUNT_E Number(10,0) DECIMAL(10) NOT NULL Error Messages

Default: 0

PTADSMSGCOUNT_I Number(10,0) DECIMAL(10) NOT NULL Informational Messages

Default: 0

PTADSMSGCOUNT_W Number(10,0) DECIMAL(10) NOT NULL Warning Messages

Default: 0

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19