Validasi Nilai Mahasiswa

=================================================
= Query validasi mahasiswa yang nilainya kosong =
=      == SIAKAD-PDDIKTI Feeder 2015 ==         =
=================================================


SELECT rpd.id_reg_pd, rpd.nipd, rpd.nm_pd, pr.nm_lemb, matkul.kode_mk, matkul.nm_mk, kelas.nm_kls, kelas.id_smt,
    (CASE WHEN nilai.nilai_angka IS NULL THEN '0' ELSE nilai.nilai_angka END) AS NA,
    (CASE WHEN nilai.nilai_huruf IS NULL THEN '0' ELSE nilai.nilai_huruf END) AS NH,
    (CASE WHEN nilai.nilai_indeks IS NULL THEN '0' ELSE nilai.nilai_indeks END) AS NI
FROM nilai_mhs AS nilai
    LEFT JOIN kelas_kuliah AS kelas ON nilai.id_kls=kelas.id_kls
    LEFT JOIN mata_kuliah AS matkul ON kelas.id_mk=matkul.id_mk
    LEFT JOIN ms_mhs AS rpd ON nilai.id_reg_pd=rpd.id_reg_pd
    LEFT JOIN sms AS pr ON rpd.id_sms=pr.id_sms
WHERE ((nilai.nilai_angka IS NULL) OR (nilai.nilai_huruf='') OR (nilai.nilai_indeks IS NULL))
    AND (kelas.id_smt='20142')
    AND (nilai.soft_delete=0)