Chapter 21: Scholarship, Freeship & Government DBT Management

This chapter covers the complete configuration and administration of Government Scholarships, Freeships, Institutional Concessions, and Direct Benefit Transfer (DBT) workflows in Uttercode School ERP.

The platform provides an end-to-end bridge between state/central welfare portals (such as MahaDBT, NSP - National Scholarship Portal, and Social Welfare Departments) and your institutional fee ledgers.

1. System Architecture & DBT Workflow

Uttercode School ERP unifies student social profiles, dynamic scheme rules, document scrutiny, automated eligibility checking, fee counter concessions, and government bank reconciliation in a single automated lifecycle:

┌──────────────────────────────────────────────────────────────────────────────────────────┐
│                             SCHOLARSHIP & DBT LIFECYCLE                                  │
└──────────────────────────────────────────────────────────────────────────────────────────┘

 1. Scheme Setup & GR Rules       2. Student Scholarship Profile      3. Automated Eligibility
   - Social Justice / Tribal        - Caste & Validity Certs            - Income Limit Check
   - OBC / VJNT / EBC / Minority    - Income & Domicile Validations     - Min 75% Attendance Check
   - Fee Waiver % by Head           - Aadhaar & NPCI Bank Seeding       - 1-Click Batch Evaluator
                 │                                │                                │
                 └────────────────────────────────┼────────────────────────────────┘
                                                  ▼
                                 4. Scrutiny & Verification Desk
                                   - Split-screen Document Viewer
                                   - 1-Click Deficiency SMS Alerts
                                   - Principal Digital Sign-off
                                                  │
                                                  ▼
                                 5. State / Central Portal Export
                                   - MahaDBT / NSP Upload Format
                                   - Sanction Order Tracking
                                                  │
                                                  ▼
                          ┌───────────────────────┴───────────────────────┐
                          ▼                                               ▼
         6. Student Direct Allowance (DBT)               7. Institute Fee Reimbursement
           - Credited directly to student's                - Credited to School Bank Account
             Aadhaar-linked NPCI bank A/c                  - Auto-settled in Student Fee Ledger
           - Hostel / Mess / Maintenance                   - Counter POS Concession Voucher

2. Scholarship Schemes Master & GR Rules Engine

Navigate to Scholarships & DBT → Scheme Master (index.php?page=scholarship_master).

A. Registering Welfare Schemes

Institutional administrators can configure unlimited state, central, institutional, or private trust schemes:

Scheme Code	Scheme Name	Welfare Department	Funding Type	Target Portal
`OBC_PMS`	Post-Matric Scholarship to OBC Students	OBC, VJNT & SBC Welfare Dept	State Govt	MahaDBT
`SC_PMS`	Post-Matric Scholarship to SC Students	Social Justice & Special Assistance	Central / State	MahaDBT / NSP
`ST_PMS`	Post-Matric Scholarship to ST Students	Tribal Development Department	State Govt	MahaDBT
`EBC_RCSM`	Rajarshi Chhatrapati Shahu Maharaj Shikshan Shulkh	Higher & Technical / School Education	State Govt	MahaDBT
`MINORITY_PMS`	State / Central Minority Scholarship	Minority Development Dept	Central Govt	NSP / MahaDBT
`TRUST_CONC`	Institutional Trust Merit-cum-Means Concession	School Foundation / Trust	Institutional	In-House

B. Session Versioning & Government Resolutions (GR)

Every scheme can be versioned per academic session (e.g. 2026-2027) with statutory Government Resolution tracking:

GR Number: e.g., EBC-2026/C.R.42/T.E.-2.
GR Date & Effective Validity Dates.
GR Document Upload: Store official government gazette / circular PDFs for audit reference.

C. Dynamic JSON Eligibility Rule Engine

Schemes enforce multi-parameter eligibility criteria evaluated in real time:

Income Ceiling: e.g., Family Annual Income $\le$ ₹8,00,000 for OBC/EBC, $\le$ ₹2,50,000 for SC/ST.
Eligible Social Categories: Multi-select tags (SC, ST, OBC, VJNT-A, VJNT-B, VJNT-C, VJNT-D, SBC, SEBC, EWS, OPEN, MINORITY, PWD).
Gender Applicability: ALL, Male, Female (e.g., Savitribai Phule special girl student concessions).
Minimum Attendance Threshold: Configurable percentage (e.g., $\ge$ 75% biometric/daily classroom attendance).
Previous Academic Passing Standard: Minimum qualifying percentage in last term examination.
CAP Admission Verification: Validates whether the student was admitted through the Centralized Admission Process.

D. Fee Head Waiver Rules Matrix

Configure exact reimbursement percentages or capped monetary limits per fee head:

{
  "tuition_fee": { "benefit_type": "PERCENTAGE", "benefit_value": 100.00 },
  "exam_fee": { "benefit_type": "PERCENTAGE", "benefit_value": 100.00 },
  "gymkhana_fee": { "benefit_type": "PERCENTAGE", "benefit_value": 50.00 },
  "development_fee": { "benefit_type": "FIXED_AMOUNT", "benefit_value": 2500.00 }
}

3. Student Scholarship Profile & Aadhaar / NPCI Seeding

Navigate to Scholarships & DBT → Student Profiles (index.php?page=student_scholarship_profile).

Every student profile holds statutory verification parameters:

Category & Sub-Caste: Standard classification with sub-caste nomenclature.
Caste Certificate: Certificate Number, Issuing Tahsil/Sub-Divisional Magistrate (SDM), and Issuance Date.
Caste Validity Certificate: Certificate Number, Scrutiny Committee Name, and Date of Issue.
Non-Creamy Layer (NCL) Certificate: Required for OBC/VJNT/SBC; includes certificate number and Valid Upto Date.
Income Certificate: Competent Revenue Authority (Tahsil/Collector) Certificate Number, Annual Income Amount, and Expiry Date.
Domicile State: Resident proof verification.

Aadhaar & NPCI Direct Benefit Transfer (DBT) Seeding

To ensure successful direct allowance credit without bank rejection:

Aadhaar Number: Encrypted vault storage with last 4 digits displayed (XXXX-XXXX-1234).
Bank Details: Bank Name, Branch, Account Number, and IFSC Code.
NPCI Seeding Status:
Seeded: Confirmed active mapping with National Payments Corporation of India (NPCI) mapper.
Not Seeded: Flagged for urgent bank account linking.
Pending Verification: Under automated bank validation.

[!IMPORTANT] Students marked Not Seeded are highlighted with warning badges on both student profiles and fee collection desks, enabling staff to guide parents to link Aadhaar with their primary bank account.

4. Automated 1-Click Eligibility Evaluation Engine

Navigate to Scholarships & DBT → Eligibility Check (index.php?page=scholarship_eligibility).

Instead of manual spreadsheet filtering, Uttercode School ERP provides an Automated Eligibility Engine:

Select the Academic Session and click Run Batch Eligibility Check.
The system executes comprehensive rule matrices against all enrolled students:

Compares student annual income against scheme ceiling.
Matches caste category and verified document statuses.
Evaluates real-time attendance percentage from Chapter 5.
Verifies previous exam passing status from Chapter 7.

Transparent Reason Logger:

Eligible: Green badge with estimated entitlement amount.
Ineligible: Red badge with explicit diagnostic breakdown:
“Income ₹8,50,000 exceeds scheme limit of ₹8,00,000.”
“Class attendance (71.2%) is below statutory 75% requirement.”
“Non-Creamy Layer (NCL) certificate expired on 31-03-2026.”

Click Generate Draft Applications to batch-create application records for all eligible students.

5. Application Lifecycle & Document Scrutiny Desk

Navigate to Scholarships & DBT → Verification Desk (index.php?page=scholarship_verification).

The 8-Stage Workflow Lifecycle

[DRAFT]
   │
   ▼
[SUBMITTED BY STUDENT / CLERK]
   │
   ▼
[UNDER CLERK VERIFICATION] ──► (Deficiency Found) ──► [DEFICIENCY RAISED]
   │                                                         │
   │ (All Documents Verified)                                │ (Student Re-uploads)
   ▼                                                         │
[INSTITUTE VERIFIED] ◄───────────────────────────────────────┘
   │
   ▼
[PRINCIPAL APPROVED & DIGITAL SIGN]
   │
   ▼
[FORWARDED TO GOVT PORTAL (MahaDBT / NSP)]
   │
   ▼
[GOVERNMENT SANCTIONED]
   │
   ▼
[DISBURSED & RECONCILED]

Split-Screen Scrutiny & 1-Click Deficiency Raising

The Scrutiny Desk allows scholarship clerks to verify applications with speed:

Left Panel: Student bio, category, income, and claimed fee heads.
Right Panel: Built-in high-resolution document viewer (Income Cert, Caste Cert, Caste Validity, Ration Card, Marksheet).
1-Click Deficiency Raiser:

Select deficiency category (e.g. Blurry Document, Expired NCL, Name Mismatch, Income Proof Expired).
Type corrective instructions.
Click Raise Deficiency & Notify Student.
An automated SMS and WhatsApp notification is immediately dispatched to the student and parent with a direct re-upload link.

Institute Approval: Once verified, the Principal can batch-approve applications with one master confirmation.

6. Fee Counter POS Integration & Concessions

Navigate to Finance & Fees → Collect Fees (POS) (index.php?page=fee_collection).

Uttercode School ERP completely prevents financial friction between scholarship disbursements and fee collections:

┌─────────────────────────────────────────────────────────────┐
│                 STUDENT FEE LEDGER (POS DESK)               │
├─────────────────────────────────────────────────────────────┤
│ Total Standard Class Fee:                         ₹ 45,000  │
│ Expected Government Scholarship (Tuition/Exam): - ₹ 35,000  │
│ ─────────────────────────────────────────────────────────── │
│ Net Student Payable Share (Activity, Library):    ₹ 10,000  │
│ Status: [ELIGIBLE FOR OBC_PMS - GOVT RECEIVABLE HELD]       │
└─────────────────────────────────────────────────────────────┘

Key POS Fee Features for Scholarship Students:

Automated Govt Receivable Deduction: The counter POS displays the expected government reimbursement alongside the student's personal payable share.
Partial Collection Without Penalty: Cashiers can collect only the student payable share without marking the student as a fee defaulter.
Scholarship Concession Vouchers: Generates an audit voucher linked to the student's admission number.
Defaulter Exclusions: Verified scholarship applicants awaiting government treasury disbursement are automatically excluded from hostile fee recovery SMS lists.

7. Government DBT & Bank Reconciliation Desk

Navigate to Scholarships & DBT → DBT Reconciliation (index.php?page=scholarship_reconciliation).

When the state government or central ministry issues treasury disbursements:

A. Logging Government Sanction Orders

Click + New Sanction Batch.
Enter Sanction Order Number, Sanction Date, and Issuing Welfare Department.
Map the batch to the academic session and scheme (e.g. MahaDBT SC_PMS Installment 1).
Enter total treasury sanctioned amount and credit bank reference number.

B. Dual-Stream Reconciliation

The system automatically segregates and reconciles the two streams of government disbursement:

Disbursement Stream	Destination	ERP Action
Institute Fee Reimbursement	School Bank Account	Automatically credited against pending student fee ledgers; settles outstanding receivables.
Direct Student Allowance (DBT)	Student's Aadhaar Bank Account	Logged in student scholarship history; tracks maintenance, book grant, and hostel allowance disbursement.

C. Anomaly Tracking & Failed Transactions

Flags students whose DBT failed due to inactive bank accounts or NPCI unlinking.
Generates a Bank DBT Failure Report for immediate follow-up.

8. Audit-Ready MIS Reports & Portal Exports

Navigate to Scholarships & DBT → Reports (index.php?page=scholarship_reports).

Uttercode School ERP includes pre-configured MIS reports designed for government inspection and trust audits:

1. MahaDBT / NSP Upload Pre-Formatted CSV

Formatted with exact column sequences, field encodings, and headers required by government scholarship portals for 1-click batch application uploading.

2. Department-Wise Sanction vs. Realization Statement

Comprehensive accounting summary showing:
Total Claimed Amount
Total Sanctioned Amount
Total Treasury Disbursed
Unclaimed / Disallowed Dues
Net Outstanding Government Receivables

Detailed statutory register categorized by SC, ST, OBC, VJNT, SBC, EBC, and Minority quotas.
Displays student name, roll number, caste certificate validity ID, family income, sanctioned fee waiver, and DBT credit date.

1-Click generation of publication-ready A4 PDF bundles containing verified student rosters, principal declarations, and sanction receipts ready for annual government audits.

[!TIP] Need help configuring custom state welfare schemes or local municipal education grants? Contact the Uttercode implementation team at support@uttercode.com or consult the Uttercode ERP Knowledge Base.