XERPIUM EDU — K-12 School Information System

Summary

K-12 School Information System Ecosystem

XERPIUM EDU is a complete ERP solution for K-12 schools (elementary/junior high/senior high/vocational) — covering new admissions, academic data, attendance, assessment & report cards, student affairs, academic calendar, Xendit payment gateway, student & parent portal, and AI for question & lesson plan generation.

📝

PPDB

New Student Admissions

📈

GRADES

Assessment & Report Cards

👥

STUDENT AFFAIRS

Transfers & Graduation

🌐

PORTAL

Students & Parents

PPDB

New Student Admissions

📝

Receiving Process

New Admission (PSB) Process — Admission definition per academic year, with waves & capacity
Prospective Students — NISN, NIS, place/date of birth, gender, blood type, religion, ethnicity
Parents — Father/mother/guardian data: education, occupation, income, status
Address — Province, city, district, village, postal code — tree selection
Documents — Upload file, document type (ID card, family card, certificates, diploma, photo, etc.)
Hobbies & Economy — Student hobbies, economic condition (poor/underprivileged/well-off)

📈

Placement & Selection

New Admission Score — 5 custom value fields (names configurable per process), test values
Donations — 2 custom donation fields per process
Group — Admission waves with capacity & filled count
Placement — Draft → Open → Done: filter passing students, place into destination classes
Students Passed/Not Yet Passed — View automatically based on graduation status
Active Students — Placement done → siswa_kelas created → academic data active

Academic

Curriculum, Attendance & Assessment

📚 Curriculum & Subjects

Subject — Mandatory/additional subjects, code, linked to teacher & report card grades
Subject Teacher — Teacher + subject assignment per semester, decree (SK), effective date
RPP — Learning program plan with weights per level & semester
KKM — Minimum Completion Criteria (KKM) per subject, level, academic year
Test Type — Midterm, final, quiz, assignment, practical — per subject
Assessment Aspects — Affective, cognitive, concept understanding, psychomotor, practice
AI RPP — Generate draft RPP via GPT model (deepseek-chat)

📄 Assessment & Report Cards

Assessment — Draft → Open → Done: enter grades per student, per lesson plan, multiple test types
Grade Details — Weight, date, notes per entry — average value automatic
Weight — Calculation rules: quiz/assignment/practical/midterm/final with % weight, draft→verified
Grading — A 90-100, B 80-89, C 70-79, D 60-69, E 0-59 — configurable
Report Card Grades — Draft → Open → Done: compute final numeric + letter grade automatically
Comments — Subject & attitude (spiritual/social) comments with predicate & score range
AI Questions — Generate questions via GPT, link to survey for online exams

📋 Attendance

Class Attendance — Draft → Open → Done: per month, per class, status present/sick/excused/absent/leave
Subject Attendance — Per session: per subject, per teacher, period, material, teacher notes
Detail — Recap per student: present, sick, excused, absent, leave counts — computed automatically
Number of Active Days — Automatically calculate effective school days per month
Manual / Auto — Search students button → auto-populates all students in the class

📅 Calendar & Schedule

Academic Calendar — Events per date: national holidays, exams, report card distribution
Jam Belajar — Definition of period 1 to N with start & end times
Class Schedule — Day + time + subject + teacher per class — complete scheduling
Teacher Schedule — View per teacher: subject, class, day, time — automatic recap
Teacher Schedule Recap — Draft → Open → Close: calculate total teaching hours per teacher
Day — Monday to Saturday, configurable

Student Affairs

Student Affairs & Portal

👥 Student Affairs

Class Transfer — Draft → Open → Done: select students, origin to destination, bulk move
Grade Promotion — Draft → Open → Done: filter promoted/retained students, auto placement
Student Transfers — Draft → Done: expelled, resigned, deceased, school transfer
Graduation — Draft → Open → Done: determine pass/fail, print transcript
Transcript of Grades — Draft → Open → Done: total grade, average, per semester
Mail Thread — All processes are logged in the chatter for audit trail

💰 Payments & Xendit

Payment Gateway — Xendit integration: public key, secret key, webhook token
Invoice Creation — Create invoice via Xendit API v2, payment redirect URL
Webhook — PAID → done + auto-reconcile + email; PENDING → pending; EXPIRED/FAILED → cancel
Transaction — Link ke account.move, invoice URL di form
Recurring — Monthly tuition, education fees, re-registration
Multi-Payment — QRIS, virtual account, credit card via Xendit

🌐 Student Portal

Home — Student dashboard: schedule, latest grades, announcements
Academic — View class schedule, attendance, grades
Tasks — Task list from teachers, upload answers
Grade — Grade history per subject, online report card
Attendance — Attendance recap per month
Pesan — Communication with teachers & homeroom teacher

👥 Parent Portal

Home — Dashboard: child's schedule, attendance, invoices
Schedule — View the child's daily class schedule
Attendance — Attendance recap: present, sick, excused, absent
Grade — Child's grades & report card per semester
Invoices — Tuition invoice & payment list, pay online via Xendit
Statistik — Chart of grade & attendance progress
Prospective Students — Register for new admissions (PPDB) for siblings/other children
Pesan — Chat with teachers & school

Teacher

Teacher & Education Staff Data

👥 Teacher Data

Employee Extended — From hr.employee: NIP, NUPTK, NRG, front/back titles, nickname
Gender — Male/female, place/date of birth, marital status, ID number
Religion & Ethnicity — Religion and ethnicity from master data
Bagian — Department/division: subject teachers, part-timers, assistants, administration, etc.
Teacher Status — Subject teachers, part-timers, assistants — configurable
Start Date — Start date of work, notes

📈 Teaching Load

Subject Teacher — Assignment per semester: teacher + subject + decree (SK)
Teacher Schedule — View schedule per teacher: class, day, time, subject
Hours Recap — Total teaching, assistance, additional hours per period
Subject Attendance — Teacher attendance per session, notes, hours count
RPP — Learning program plan per teacher & subject

Comparison

Why XERPIUM EDU?

Aspect	Manual System / Books	XERPIUM EDU
PPDB	Paper forms, Excel recap	✓ Online, automatic placement, document upload
Attendance	Paper attendance book	✓ Digital per class & per subject, auto recap
Grades & Report Cards	Grade book, manual report cards	✓ Grade entry, auto grading calculation, report card printing
Schedule	Sticky notes	✓ Class & teacher schedules, automatic hours recap
Student Affairs	Master ledger	✓ Transfers, grade promotion, graduation, transcripts
Payments	Cash book, manual	✓ Xendit gateway, auto-invoice, webhook
Portal	✗ None	✓ Students & parents: grades, attendance, invoices
AI	✗ None	✓ Generate lesson plans & questions via AI