PSADSVALINST_VW

index back

SELECT PTSESSIONID , PTADSNAME , PTADSCONTENTID , PROJECTNAME , PTKEYHASH , MAX(CASE WHEN COMPARETYPE = 4 THEN CASE WHEN PTADSMSGSEVERITY = 'E' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTPREMSGCOUNT_E , MAX(CASE WHEN COMPARETYPE = 4 THEN CASE WHEN PTADSMSGSEVERITY = 'M' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTPREMSGCOUNT_I , MAX(CASE WHEN COMPARETYPE = 4 THEN CASE WHEN PTADSMSGSEVERITY = 'W' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTPREMSGCOUNT_W , MAX(CASE WHEN COMPARETYPE = 1 THEN CASE WHEN PTADSMSGSEVERITY = 'E' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTPOSTMSGCOUNT_E , MAX(CASE WHEN COMPARETYPE = 1 THEN CASE WHEN PTADSMSGSEVERITY = 'M' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTPOSTMSGCOUNT_I , MAX(CASE WHEN COMPARETYPE = 1 THEN CASE WHEN PTADSMSGSEVERITY = 'W' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTPOSTMSGCOUNT_W , MAX(CASE WHEN COMPARETYPE = 6 THEN CASE WHEN PTADSMSGSEVERITY = 'E' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTADSINTMSGCONT_E , MAX(CASE WHEN COMPARETYPE = 6 THEN CASE WHEN PTADSMSGSEVERITY = 'M' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTADSINTMSGCONT_I , MAX(CASE WHEN COMPARETYPE = 6 THEN CASE WHEN PTADSMSGSEVERITY = 'W' THEN PTADSMESSAGECOUNT ELSE 0 END ELSE 0 END) AS PTADSINTMSGCONT_W FROM PSADSVALINSTST GROUP BY PTSESSIONID , PTADSNAME , PTADSCONTENTID , PROJECTNAME , 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).
PTKEYHASHCharacter(28)VARCHAR2(28) NOT NULL
PTPREMSGCOUNT_ENumber(10,0)DECIMAL(10) NOT NULLPre-Merge Errors

Default: 0

PTPREMSGCOUNT_INumber(10,0)DECIMAL(10) NOT NULLPre-Merge Messages

Default: 0

PTPREMSGCOUNT_WNumber(10,0)DECIMAL(10) NOT NULLPre-Merge Warnings

Default: 0

PTPOSTMSGCOUNT_ENumber(10,0)DECIMAL(10) NOT NULLPost-Merge Errors

Default: 0

PTPOSTMSGCOUNT_INumber(10,0)DECIMAL(10) NOT NULLPost-Merge Messages

Default: 0

PTPOSTMSGCOUNT_WNumber(10,0)DECIMAL(10) NOT NULLPost-Merge Warnings

Default: 0

PTADSINTMSGCONT_ENumber(10,0)DECIMAL(10) NOT NULLIntegrity Errors
PTADSINTMSGCONT_INumber(10,0)DECIMAL(10) NOT NULLIntegrity Messages
PTADSINTMSGCONT_WNumber(10,0)DECIMAL(10) NOT NULLIntegrity Warnings
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19