SADBPVBIJLVWLNG

(SQL View)
 Index Back

Bijlage tabel

SADBPVBIJLVWLNG is the related language recordfor the record SAD_BPV_NBL_NLD

SELECT DISTINCT A.HEGIS_CODE , A.SAD_APPENDIX_NLD , G.OPRID , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_SADBPVNBLNLDLNG A , PS_SSR_HEGISCD_NLD B , PS_ACAD_PROG_TBL C , PS_SCRTY_TBL_PROG G WHERE A.HEGIS_CODE= B.HEGIS_CODE AND B.SSR_FINAL_QUAL_NLD = 'Y' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_SSR_HEGISCD_NLD B_ED WHERE B.HEGIS_CODE = B_ED.HEGIS_CODE AND B_ED.EFFDT <= %CurrentDateIn) AND B.HEGIS_CODE = C.HEGIS_CODE AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_ACAD_PROG_TBL C_ED WHERE C.INSTITUTION = C_ED.INSTITUTION AND C.ACAD_PROG = C_ED.ACAD_PROG AND C_ED.EFFDT <= %CurrentDateIn) AND C.INSTITUTION = G.INSTITUTION AND G.ACCESS_CD = 'Y' AND C.ACAD_CAREER = G.ACAD_CAREER AND (C.ACAD_PROG = G.ACAD_PROG OR G.ACAD_PROG = 'ALL') AND NOT EXISTS ( SELECT 'X' FROM ps_scrty_tbl_prog g1 WHERE g1.access_cd = 'N' AND g1.oprid = g.oprid AND g1.institution = g.institution AND g1.acad_career = g.acad_career AND g1.acad_prog = C.ACAD_PROG) UNION SELECT DISTINCT NL.HEGIS_CODE , A.SAD_APPENDIX_NLD , %OperatorId , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_SADBPVNBLNLDLNG A , PS_SAD_BPV_NBL_NLD A1 , PS_SSR_HEGISCD_NLD NL WHERE A.HEGIS_CODE = NL.HEGIS_CODE AND A.HEGIS_CODE= A.HEGIS_CODE AND A1.HEGIS_CODE= A.HEGIS_CODE AND NL.SCC_HEGIS_TYPE_NLD ='K' AND A.EFFDT = NL.EFFDT AND A.EFFDT = ( SELECT MAX(C_ED1.EFFDT) FROM PS_HEGIS_CODE_TBL C_ED1 WHERE C_ED1.HEGIS_CODE = A.HEGIS_CODE AND C_ED1.EFFDT <= %CurrentDateIn)

  • Related Language Record for SAD_BPV_BIJL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
    2 SAD_APPENDIX_NLD Character(12) VARCHAR2(12) NOT NULL Appendix reference id (name of appendix)

    Prompt Table: SAD_BPV_NBL_NLD

    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description