SSR_RI_EPSVWNLD

(SQL View)
 Index Back

RIO EP Suspend WC View


SELECT A.SSR_BR_INDEX_ID ,A.SSR_BR_MSGUUID ,A.INSTITUTION ,A.SSR_RI_EDU_GOV_NLD ,A.ACAD_ORG ,A.SSR_RI_EPV_COD_NLD , A.SSR_BR_TRANS_DTTM ,( SELECT COUNT(*) FROM %Table(SSR_RI_ER_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_RI_MUT_TYP_NLD FROM %Table(SSR_RI_EPV_NLD) A WHERE A.SSR_BR_TRANS_STAT IN ('S' ,'T') AND NOT EXISTS ( SELECT 'X' FROM %Table(SSR_RI_EREP_NLD) B WHERE B.SSR_BR_INDEX_ID=A.SSR_BR_INDEX_ID AND B.SSR_BR_MSGUUID=A.SSR_BR_MSGUUID AND B.ACAD_ORG =A.ACAD_ORG AND B.SSR_RI_EDU_GOV_NLD=A.SSR_RI_EDU_GOV_NLD AND B.INSTITUTION=A.INSTITUTION AND B.REJECT_FLAG='S' ) AND A.SSR_BR_TRANS_DTTM = ( SELECT MAX(C.SSR_BR_TRANS_DTTM) FROM %Table(SSR_RI_EPV_NLD) C WHERE C.ACAD_ORG =A.ACAD_ORG AND C.SSR_RI_EDU_GOV_NLD=A.SSR_RI_EDU_GOV_NLD AND C.INSTITUTION=A.INSTITUTION ) AND A.SSR_RI_MUT_TYP_NLD = ' ' GROUP BY A.SSR_BR_INDEX_ID, A.SSR_BR_MSGUUID, A.INSTITUTION, A.ACAD_ORG ,A.SSR_RI_EDU_GOV_NLD, A.SSR_RI_EPV_COD_NLD, A.SSR_BR_TRANS_DTTM,A.SSR_RI_MUT_TYP_NLD

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
4 SSR_RI_EDU_GOV_NLD Character(20) VARCHAR2(20) NOT NULL Educational Board Code
5 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
6 SSR_RI_EPV_COD_NLD Character(12) VARCHAR2(12) NOT NULL Educational Provider Code
7 SSR_BR_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
8 SSR_RI_ERRORS_NLD Character(30) VARCHAR2(30) NOT NULL Errors
9 SSR_RI_MUT_TYP_NLD Character(4) VARCHAR2(4) NOT NULL Mutation Type
T=Addition
V=Removal
W=Change