SSR_BR_DP_R_VW

(SQL View)
 Index Back

Diplomas Received WC View

/* 31-03-2021 fix for bug 31903755 */

SELECT A.SSR_BR_INDEX_ID ,A.SSR_BR_MSGUUID ,A.SSR_BR_RESL_SQ_NLD ,A.HEGIS_CODE ,A.EMPLID , A.SSR_BR_TRANS_DTTM FROM PS_SSR_BR_DPBO_NLD A , PS_SSR_BR_INTS_NLD B WHERE A.SSR_BR_TRANS_STAT = 'R' AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_BR_ERDP_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_SQ_NLD=A.SSR_BR_RESL_SQ_NLD AND B.HEGIS_CODE=A.HEGIS_CODE AND B.EMPLID=A.EMPLID AND B.REJECT_FLAG='R' ) AND A.SSR_BR_TRANS_DTTM = ( SELECT MAX(C.SSR_BR_TRANS_DTTM) FROM PS_SSR_BR_DPBO_NLD C WHERE C.EMPLID=A.EMPLID AND C.SSR_BR_RESL_SQ_NLD=A.SSR_BR_RESL_SQ_NLD AND C.HEGIS_CODE=A.HEGIS_CODE) AND A.SSR_BR_TRANS_DTTM < %TimeAdd(%CurrentDateTimeIn, -(B.SSR_BR_HRS_RECEIVE*(60))) GROUP BY A.SSR_BR_INDEX_ID,A.SSR_BR_MSGUUID, A.SSR_BR_RESL_SQ_NLD ,A.HEGIS_CODE ,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_SQ_NLD Character(20) VARCHAR2(20) NOT NULL Result Sequence Number
4 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 SSR_BR_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime