Student Scholarship
Sub Module / Aplikasi Student Scholarship digunakan untuk mahasiswa mendaftar beasiswa
Requirement
- Mahasiswa dapat mendaftar banyak beasiswa yang tersedia
- Mahasiswa hanya dapat diterima pada satu beasiswa
- Beasiswa Maksimum didapatkan Sampai Semester 8
- Penerimaan Beasiswa Dievaluasi Tiap Semester oleh Biro Akademik
- Biro Akademik request ke Biro Keuangan untuk mencairkan dana beasiswa tiap semester
- Dekan merekomendasikan mahasiswa yang diprioritaskan berdasarkan kebijaksanaan dekan
Daftar Role yang terlibat
ST00001 : Mahasiswa UIRBA21001 : Staff Sub Bagian Pengembangan Mahasiswa dan AlumniBK12001 : Staff Sub Bagian KasirFA00001 : Dekan FakultasZB00000 : Pewawancara Beasiswa
Use Case
`ST00001` : Mahasiswa UIR
- Melihat Panduan Pendaftaran Beasiswa
- Melihat dan Mendaftar Beasiswa yang Tersedia
- Melihat History Pendaftaran Beasiswa
`BA21001` : Staff Sub Bagian Pengembangan Mahasiswa dan Alumni
- Manage Data Master Kategori Beasiswa
- Manage Data Beasiswa
- Memvalidasi Berkas Beasiswa
- Mengatur Jadwal Interview
- Menentukan Hasil Akhir Penerima Beasiswa
- Mengevaluasi Penerima Beasiswa Tiap Semester
- Mengimport Data Penerima Beasiswa External
`FA00001` : Dekan Fakultas
- Mengajukan Rekomendasi Penerima Beasiswa
`ZB00000` : Pewawancara Beasiswa
- Menilai Interview Beasiswa
`BK12001` : Staff Sub Bagian Kasir
- Melakukan Pencairan Dana Beasiswa Tiap Semester
| Menu | Link | Authorize | Keterangan |
|---|
Home | / | ST00001 | Panduan Pendaftaran Beasiswa |
Register Beasiswa | /register | ST00001 | Menampilkan Daftar Beasiswa |
History | /history | ST00001 | Menampilkan History Pendaftaran Beasiswa |
Kategori Beasiswa | /master/categories | BA21001 | Mengatur Data Master Kategori Beasiswa |
Master Beasiswa | /master/scholarships | BA21001 | Mengatur Data Master Beasiswa |
Validasi Berkas | /validation/requirement | BA21001 | Validasi Berkas Beasiswa |
Jadwal Interview | /interview/schedule | BA21001 | Mengatur Jadwal Interview Beasiswa |
Penilaian Interview | /interview/score | ZB00000 | Penilaian Interview Beasiswa |
Ajukan Rekomendasi | /recommendation | FA00001 | Rekomendasi Peserta Beasiswa |
Final | /final | BA21001 | Hasil Akhir Penerimaan Beasiswa |
Evaluasi Beasiswa | /evaluation | BA21001 | Evaluasi Penerima Beasiswa Tiap Semester |
Pencairan Dana Beasiswa | /disbursement | BK12001 | Pencairan Dana Beasiswa Tiap Semester |
Import Beasiswa External | /import | BA21001 | Import Data Penerima Beasiswa External |
Database
Schema : student_scholarship
mt_category
| Key | Field Name | Data Type | Description |
|---|
| PK | c_category | varchar(15) | Kode Kategori Beasiswa |
| - | n_category | varchar(63) | Nama Kategori Beasiswa |
| - | e_category | varchar(255) | Deskripsi Kategori Beasiswa |
mt_scholarship
| Key | Field Name | Data Type | Description |
|---|
| PK | c_scholarship | varchar(15) | Kode Beasiswa |
| - | n_scholarship | varchar(63) | Nama Beasiswa |
| - | e_scholarship | varchar(255) | Deskripsi Beasiswa |
| FK | c_category | varchar(15) | Kode Kategori Beasiswa |
| FK | c_academic_level | varchar(15) | Kode Level Akademik |
mt_requirement
| Key | Field Name | Data Type | Description |
|---|
| PK | c_requirement | varchar(15) | Kode Persyaratan Beasiswa |
| - | n_requirement | varchar(63) | Nama Persyaratan Beasiswa |
| - | e_requirement | varchar(255) | Deskripsi Persyaratan Beasiswa |
tt_scholarship
| Key | Field Name | Data Type | Description |
|---|
| PK | i_scholarship | varchar(15) | ID Beasiswa |
| FK | c_scholarship | varchar(15) | Kode Beasiswa |
| - | n_period | varchar(15) | Periode Beasiswa |
| - | f_active | boolean | Flag Aktif |
| - | d_open | date | Date Dibuka |
| - | d_close | date | Date Ditutup |
| - | v_semester_min | int | Minimum Semester |
| - | v_semester_max | int | Maximum Semester |
| - | v_semester_stop | int | Stop Semester |
| - | q_grantee_max | int | Jumlah Maksimum Penerimaan |
tt_registration
| Key | Field Name | Data Type | Description |
|---|
| PK | i_registration | varchar(15) | ID Registrasi |
| FK | i_scholarship | varchar(15) | ID Beasiswa |
| FK | i_student | char(9) | ID Mahasiswa |
| enum | s_registration | varchar(15) | Status Registrasi |
tt_scholarship_requirement
| Key | Field Name | Data Type | Description |
|---|
| PK | i_scholarship_requirement | varchar(15) | ID Persyaratan Beasiswa |
| FK | i_scholarship | varchar(15) | ID Beasiswa |
| FK | c_requirement | varchar(15) | Kode Persyaratan beasiswa |
tt_file
| Key | Field Name | Data Type | Description |
|---|
| PK | i_file | varchar(15) | ID File |
| - | n_file | varchar(127) | Nama File |
| - | n_file_extention | varchar(15) | Extention File |
| FK | i_registration | varchar(15) | ID Registrasi |
| FK | i_scholarship_requirement | varchar(15) | ID Persyaratan Beasiswa |
| enum | s_file | varchar(15) | Status File |
| - | n_note | varchar(63) | Catatan |
tt_interview
| Key | Field Name | Data Type | Description |
|---|
| PK | i_interview | varchar(15) | ID Interview |
| FK | i_registration | varchar(15) | ID Registrasi |
| - | d_interview | date | Tanggal Interview |
| - | t_interview | time | Jam Interview |
| - | i_interviewer | varchar(15) | ID Interviewer |
tt_recommendation
| Key | Field Name | Data Type | Description |
|---|
| PK | i_recommendation | varchar(15) | ID Rekomendasi |
| FK | i_recommender | varchar(15) | ID Perekomendasi (NIK Dekan) |
| FK | i_registration | varchar(15) | Tanggal Interview |
tt_grantee
| Key | Field Name | Data Type | Description |
|---|
| PK | i_grantee | varchar(15) | ID Penerima |
| FK | i_registration | varchar(15) | ID Pendaftar |
| FK | i_semester | varchar(15) | ID Semester |
| enum | s_grantee | varchar(15) | Status Penerimaan / Pencairan Dana |
Status
Status Pendaftaran Beasiswa
open - Mahasiswa mendaftar beasiswa tertentu yang tersediasubmitted - Mahasiswa telah mengupload seluruh berkas beasiswa yang diperlukan dan dapat menekan Button Konfirmasi Berkasverified - Seluruh Requirement sudah diverifikasi dan valid, bersiap untuk tahapan selanjutnyaincomplete - Terdapat berkas yang belum sesuai dengan kebutuhan, Mahasiswa dapat mengupdate / mengupdate ulang file yang diberi catataninterviewed - Pendaftar Beasiswa Telah diwawancaraactive - Pendaftaran Beasiswa diterimafinish - Penerima Beasiswa Telah menyelesaikan penerimaan beasiswa sampai semester 8stop - Penerima Beasiswa Diberhentikan Beasiswanya dikarenakan gagal lolos evaluasi di semester tertentu
Status Berkas
uploaded - Berkas Telah diuplaodvalid - Berkas Validinvalid - Berkas Tidak Valid
Status Pencairan
request - Pencairan di Requestsuccess - Pencairan Berhasilfailed - Pencairan Gagal
Web Services /api/student-scholarship
| Method | End-Point | Authorize | Description |
|---|
| GET | /categories | - | GET CATEGORY |
| POST | /categories | BA21001 | POST CATEGORY |
| EDIT | /categories/:code | BA21001 | EDIT CATEGORY |
| DELETE | /categories/:code | BA21001 | DELETE CATEGORY |
| - | - | - | - |
| GET | /scholarship | - | GET SCHOLARSHIP |
| POST | /scholarship | BA21001 | POST SCHOLARSHIP |
| EDIT | /scholarship/:code | BA21001 | EDIT SCHOLARSHIP |
| DELETE | /scholarship/:code | BA21001 | DELETE SCHOLARSHIP |
| - | - | - | - |
| GET | /requirement | - | GET REQUIREMENT |
| POST | /requirement | BA21001 | POST REQUIREMENT |
| EDIT | /requirement/:code | BA21001 | EDIT REQUIREMENT |
| DELETE | /requirement/:code | BA21001 | DELETE REQUIREMENT |
| - | - | - | - |
| GET | /batch | - | GET SCHOLARSHIP BATCH |
| POST | /batch | BA21001 | POST SCHOLARSHIP BATCH |
| EDIT | /batch/:id | BA21001 | EDIT SCHOLARSHIP BATCH |
| DELETE | /batch/:id | BA21001 | DELETE SCHOLARSHIP BATCH |
| - | - | - | - |
| GET | /registration | - | GET SCHOLARSHIP REGISTRATION |
| POST | /registration | ST00001 BA21001 | POST SCHOLARSHIP REGISTRATION |
| EDIT | /registration/:id | ST00001 BA21001 | EDIT SCHOLARSHIP REGISTRATION |
| DELETE | /registration/:id | ST00001 BA21001 | DELETE SCHOLARSHIP REGISTRATION |
| - | - | - | - |
| GET | /scholarship-requirement | - | GET SCHOLARSHIP REQUIREMENT |
| POST | /scholarship-requirement | BA21001 | POST SCHOLARSHIP REQUIREMENT |
| EDIT | /scholarship-requirement/:id | BA21001 | EDIT SCHOLARSHIP REQUIREMENT |
| DELETE | /scholarship-requirement/:id | BA21001 | DELETE SCHOLARSHIP REQUIREMENT |
| - | - | - | - |
| GET | /file | - | GET REGISTRATION FILE |
| POST | /file | ST00001 BA21001 | POST REGISTRATION FILE |
| EDIT | /file/:id | ST00001 BA21001 | EDIT REGISTRATION FILE |
| DELETE | /file/:id | ST00001 BA21001 | DELETE REGISTRATION FILE |
| - | - | - | - |
| GET | /interview | - | GET INTERVIEW |
| POST | /interview | BA21001 | POST INTERVIEW |
| EDIT | /interview/:id | BA21001 | EDIT INTERVIEW |
| DELETE | /interview/:id | BA21001 | DELETE INTERVIEW |
| - | - | - | - |
| GET | /recommendation | - | GET RECOMMENDATION |
| POST | /recommendation | FA00001 | POST RECOMMENDATION |
| EDIT | /recommendation/:id | FA00001 | EDIT RECOMMENDATION |
| DELETE | /recommendation/:id | FA00001 | DELETE RECOMMENDATION |
| - | - | - | - |
| GET | /grantee | - | GET GRANTEE |
| POST | /grantee | BA21001 | POST GRANTEE |
| EDIT | /grantee/:id | BK12001 | EDIT GRANTEE |
| DELETE | /grantee/:id | BA21001 | DELETE GRANTEE |
Screen/View Routes /student-scholarship
| Screen/View Name | Path | Authorize | Keterangan |
|---|
StudentScholarshipHome | / | ST00001 | Panduan Pendaftaran Beasiswa |
StudentScholarshipRegister | /register | ST00001 | Menampilkan Daftar Beasiswa |
StudentScholarshipHistory | /history | ST00001 | Menampilkan History Pendaftaran Beasiswa |
StudentScholarshipMasterScholarshipCategory | /master/categories | BA21001 | Mengatur Data Master Kategori Beasiswa |
StudentScholarshipMasterScholarship | /master/scholarships | BA21001 | Mengatur Data Master Beasiswa |
StudentScholarshipValidation | /validation/requirement | BA21001 | Validasi Berkas Beasiswa |
StudentScholarshipInterviewSchedule | /interview/schedule | BA21001 | Mengatur Jadwal Interview Beasiswa |
StudentScholarshipInterviewScore | /interview/score | ZB00000 | Penilaian Interview Beasiswa |
StudentScholarshipRecommendation | /recommendation | FA00001 | Rekomendasi Peserta Beasiswa |
StudentScholarshipFinalDecision | /final | BA21001 | Hasil Akhir Penerimaan Beasiswa |
StudentScholarshipEvaluation | /evaluation | BA21001 | Evaluasi Penerima Beasiswa Tiap Semester |
StudentScholarshipDisburesment | /disbursement | BK12001 | Pencairan Dana Beasiswa Tiap Semester |
StudentScholarshipImport | /import | BA21001 | Import Data Penerima Beasiswa External |