GPFR_DA_ERR_VW

(SQL View)
 Index Back

View to display Struct Err Lst

View to display Structure Error List

SELECT COUNT(*) , A.GPFR_DA_SNDREF , A.GPFR_DA_RECIP , A.GPFR_DA_STRUCT , B.MESSAGE_TEXT , A.GPFR_DA_DATST FROM PS_GPFR_DA_DAT_LOG A , PSMSGCATDEFN B ,PS_GPFR_DA_RECORD C WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR AND A.GPFR_DA_STRUCT=C.GPFR_DA_STRUCT AND A.GPFR_DA_RECORD=C.GPFR_DA_RECORD AND A.GPFR_DA_VAL_STATUS NOT IN ('P') AND C.GPFR_DA_OPTION NOT IN('I','D') GROUP BY A.GPFR_DA_STRUCT , A.GPFR_DA_SNDREF , A.GPFR_DA_RECIP, B.MESSAGE_TEXT , A.GPFR_DA_DATST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_DA_FREQ Number(12,0) DECIMAL(12) NOT NULL Frequency of errors for DADS
2 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field
3 GPFR_DA_RECIP Character(10) VARCHAR2(10) NOT NULL DADS related field
4 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
5 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
6 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning