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 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).
PTKEYHASH Character(28) VARCHAR2(28) NOT NULL
PTPREMSGCOUNT_E Number(10,0) DECIMAL(10) NOT NULL Pre-Merge Errors

Default: 0

PTPREMSGCOUNT_I Number(10,0) DECIMAL(10) NOT NULL Pre-Merge Messages

Default: 0

PTPREMSGCOUNT_W Number(10,0) DECIMAL(10) NOT NULL Pre-Merge Warnings

Default: 0

PTPOSTMSGCOUNT_E Number(10,0) DECIMAL(10) NOT NULL Post-Merge Errors

Default: 0

PTPOSTMSGCOUNT_I Number(10,0) DECIMAL(10) NOT NULL Post-Merge Messages

Default: 0

PTPOSTMSGCOUNT_W Number(10,0) DECIMAL(10) NOT NULL Post-Merge Warnings

Default: 0

PTADSINTMSGCONT_E Number(10,0) DECIMAL(10) NOT NULL Integrity Errors
PTADSINTMSGCONT_I Number(10,0) DECIMAL(10) NOT NULL Integrity Messages
PTADSINTMSGCONT_W Number(10,0) DECIMAL(10) NOT NULL Integrity Warnings
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20