SSR_BR_EASVWNLD

(SQL View)
 Index Back

EA Suspend WC View

/* 2020-04-15 fix for bug 28069030 */ /* 2021-02-08 fix for bug 32132814 */

SELECT A.SSR_BR_INDEX_ID ,A.SSR_BR_MSGUUID ,A.EMPLID ,A.SSR_EA_APL_ID_NLD , A.SSR_BR_TRANS_DTTM ,( SELECT COUNT(*) FROM PS_SSR_EA_IDER_NLD B WHERE A.SSR_BR_INDEX_ID =B.SSR_BR_INDEX_ID AND A.SSR_BR_MSGUUID=B.SSR_BR_MSGUUID )"ERRORS" ,A.SSR_EA_CA_INDEX FROM PS_SSR_EA_ADM_NLD A WHERE A.SSR_BR_TRANS_STAT IN ('S') AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_BR_EREA_NLD B WHERE B.SSR_BR_INDEX_ID=A.SSR_BR_INDEX_ID AND B.SSR_BR_MSGUUID=A.SSR_BR_MSGUUID AND B.SSR_EA_APL_ID_NLD =A.SSR_EA_APL_ID_NLD AND (B.SSR_EA_CA_INDEX = A.SSR_EA_CA_INDEX OR (B.SSR_EA_CA_INDEX = ' ' AND A.SSR_EA_CA_INDEX = ' ') ) AND B.EMPLID=A.EMPLID ) AND A.SSR_BR_TRANS_DTTM = ( SELECT MAX(C.SSR_BR_TRANS_DTTM) FROM PS_SSR_EA_ADM_NLD C WHERE C.EMPLID=A.EMPLID AND C.SSR_EA_APL_ID_NLD =A.SSR_EA_APL_ID_NLD AND (C.SSR_EA_CA_INDEX = A.SSR_EA_CA_INDEX OR (C.SSR_EA_CA_INDEX = ' ' AND A.SSR_EA_CA_INDEX = ' ') ) ) GROUP BY A.SSR_BR_INDEX_ID,A.SSR_BR_MSGUUID, A.SSR_EA_APL_ID_NLD ,A.EMPLID, A.SSR_BR_TRANS_DTTM,A.SSR_EA_CA_INDEX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_BR_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Transaction Index ID
2 SSR_BR_MSGUUID Character(50) VARCHAR2(50) NOT NULL Message ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 SSR_EA_APL_ID_NLD Character(15) VARCHAR2(15) NOT NULL Application ID
5 SSR_BR_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 SSR_EA_CA_INDEX Character(40) VARCHAR2(40) NOT NULL CA Application ID