SSR_BR_RSSVWNLD

(SQL View)
 Index Back

Results Suspend WC View

2019-08-08 Changes for bug 30014996 2020-04-15 fix for bug 25889243

SELECT A.SSR_BR_INDEX_ID ,A.SSR_BR_MSGUUID ,A.SSR_BR_RESL_SQ2NLD ,A.HEGIS_CODE ,A.SSR_BR_GEN_TST_NLD ,A.SSR_BR_ELC_TST_NLD ,A.SSR_BR_CERT_CD_NLD ,A.EMPLID , A.SSR_BR_TRANS_DTTM ,( SELECT MAX(B.SSR_BR_MSG_SEQ) FROM PS_SSR_BR_IDER_NLD B WHERE A.SSR_BR_INDEX_ID =B.SSR_BR_INDEX_ID AND A.SSR_BR_MSGUUID=B.SSR_BR_MSGUUID )"ERRORS" FROM PS_SSR_BR_RSBO_NLD A WHERE A.SSR_BR_TRANS_STAT='S' AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_BR_ERRS_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_BR_RESL_SQ2NLD=A.SSR_BR_RESL_SQ2NLD AND B.HEGIS_CODE=A.HEGIS_CODE AND (B.SSR_BR_GEN_TST_NLD %Concat B.SSR_BR_ELC_TST_NLD %Concat B.SSR_BR_CERT_CD_NLD = A.SSR_BR_GEN_TST_NLD %Concat A.SSR_BR_ELC_TST_NLD %Concat A.SSR_BR_CERT_CD_NLD ) AND B.EMPLID=A.EMPLID AND B.REJECT_FLAG='S' ) AND A.SSR_BR_TRANS_DTTM = ( SELECT MAX(C.SSR_BR_TRANS_DTTM) FROM PS_SSR_BR_RSBO_NLD C WHERE C.EMPLID=A.EMPLID AND C.SSR_BR_RESL_SQ2NLD=A.SSR_BR_RESL_SQ2NLD AND C.HEGIS_CODE=A.HEGIS_CODE AND (C.SSR_BR_GEN_TST_NLD %Concat C.SSR_BR_ELC_TST_NLD %Concat C.SSR_BR_CERT_CD_NLD = A.SSR_BR_GEN_TST_NLD %Concat A.SSR_BR_ELC_TST_NLD %Concat A.SSR_BR_CERT_CD_NLD )) GROUP BY A.SSR_BR_INDEX_ID,A.SSR_BR_MSGUUID ,A.SSR_BR_RESL_SQ2NLD ,A.HEGIS_CODE ,A.SSR_BR_GEN_TST_NLD ,A.SSR_BR_ELC_TST_NLD ,A.SSR_BR_CERT_CD_NLD ,A.EMPLID, A.SSR_BR_TRANS_DTTM

# 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 SSR_BR_RESL_SQ2NLD Character(20) VARCHAR2(20) NOT NULL Result Sequence
4 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
5 SSR_BR_GEN_TST_NLD Character(4) VARCHAR2(4) NOT NULL Generic Test
6 SSR_BR_ELC_TST_NLD Character(5) VARCHAR2(5) NOT NULL Elective Test
7 SSR_BR_CERT_CD_NLD Character(5) VARCHAR2(5) NOT NULL AMvB Certificate Code
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 SSR_BR_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description