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 NameField TypeColumn TypeDescription
PTSESSIONIDCharacter(36)VARCHAR2(36) NOT NULLCompare Session Id
PTADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name (see PSADSDEFN).
PTADSCONTENTIDNumber(6,0)INTEGER NOT NULLADS Content Identifier
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
COMPARETYPENumber(5,0)INTEGER NOT NULLCompare Type
PTKEYHASHCharacter(28)VARCHAR2(28) NOT NULL
PTADSMSGCOUNT_ENumber(10,0)DECIMAL(10) NOT NULLError Messages

Default: 0

PTADSMSGCOUNT_INumber(10,0)DECIMAL(10) NOT NULLInformational Messages

Default: 0

PTADSMSGCOUNT_WNumber(10,0)DECIMAL(10) NOT NULLWarning Messages

Default: 0

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