SAD_BPV_BIJL_VW (SQL View)	Index Back
Bijlage tabel FS 03052004

SAD_BPV_BIJL_VW

(SQL View)

Bijlage tabel

FS 03052004

SELECT DISTINCT A.HEGIS_CODE , A.SAD_APPENDIX_NLD , G.OPRID , A.EFFDT , A.EFF_STATUS , A.DESCR FROM PS_SAD_BPV_NBL_NLD 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 HG.HEGIS_CODE , A.SAD_APPENDIX_NLD , %OperatorId , A.EFFDT , A.EFF_STATUS , A.DESCR FROM PS_HEGIS_CODE_TBL HG , PS_SAD_BPV_NBL_NLD A , PS_SSR_HEGISCD_NLD NL WHERE HG.HEGIS_CODE = NL.HEGIS_CODE AND A.HEGIS_CODE= HG.HEGIS_CODE AND NL.SCC_HEGIS_TYPE_NLD ='K' AND HG.EFFDT = NL.EFFDT AND HG.EFFDT = ( SELECT MAX(C_ED1.EFFDT) FROM PS_HEGIS_CODE_TBL C_ED1 WHERE C_ED1.HEGIS_CODE = HG.HEGIS_CODE AND C_ED1.EFFDT <= %CurrentDateIn)

Related Language Record: SADBPVBIJLVWLNG

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description