SLP Request for SQL of all S4-6 students OLE records and performance outside school

Dear all,

I want to extract from WebSAMS by SQL

1) all S4-6 OLE records.
2) all S4-6 performance outside school.

Thank you!

 

Please refer to here.

 

Sorry, what I want is the SQL really extracting
1) all S4-6 OLE records.
2) all S4-6 performance outside school.

in the module SLP, is it possible?

 

Pls try the below SQL, they extact data from SLP module only.

1)
SELECT
a.schyear,
a.classlvl,
a.CLASSCODE,
a.CLASSNO,
a.chname,
a.ENNAME,
b.STARTYR,
b.ENDYR,
b.PROG_ENG,
b.PROG_DESC_ENG,
b.ROLE_ENG,
b.ORG_ENG,
b.AWARD_ENG,
b.MAJOR_ENG,
c.seq
FROM TB_SLP_STU_OLE_FROMSLP b, VW_STU_LATESTSTUDENT a, TB_SLP_OLE_SEQ c
WHERE a.STUID = b.STUID and b.stuid = c.stuid and b.ole_id = c.code_id and c.tb_id = 'SLP' and a.schyear=?
ORDER BY 2,3,4

2)
select
d1.schyear,
d1.classlvl,
d1.classcode,
d1.classno,
d1.chname,
d1.enname,
c1.STARTYR,
c1.ENDYR,
c1.PROG,
c1.PROG_DES,
c1.ROLE,
c1.ORG,
c1.AWARD,
c1.SEQ
from TB_SLP_STU_PERFME_OUTSCH c1
join vw_stu_lateststudent d1
on c1.suid=d1.suid and c1.stuid=d1.stuid
where d1.schyear=?
order by 2,3,4