Total Catalog
15
71 Total Volumes (60 Available)
Books Issued
11
Active Unreturned Circulation
Overdue Books
3
Past 14-Day Borrowing Limit
Total Fines (SAR)
SAR 54.00
SAR 8.00 Settled · SAR 46.00 Pending
Executive Action Required
Rate: SAR 2.00 / Day
Overdue Defaulters & Fine Assessment Roll (3)
| Loan ID | Defaulter Member | Contact | Overdue Book | Issue → Due Date | Overdue Days | Accrued Fine (SAR) | Immediate Action |
|---|
Catalog Breakdown by Category
SQL GROUP BY Category aggregation
| Category | Unique Titles | Total Copies | Available |
|---|
Most Circulated Titles
Ranked by total borrow count across sessions
| Book Title | Category | Stock | Borrows |
|---|
All Active Circulation Loans (11)
Complete ledger of books currently checked out by students and staff
| Record | Book Title & Rack | Borrower | Issue Date | Due Date | Status | Quick Return |
|---|