Portal / SMS / UC-SMS-05
NHHK 2024–2025 HK1 Cán bộ demo
SMS · UC-SMS-05

UC-SMS-05 — Hoc bong / tro cap / vay von

Hoc bong / tro cap / vay von based on legacy SMS source. This UC assumes `SDMSV`/`SSVHK` hub data already exists and does not require QLTS runtime.

Nguồn: docs/modules/sms/use-cases/UC-SMS-05.md · Sample data (fake VN)
S1 · Legacy `S14/HOCBONG`; remake scholarship dashboard

Legacy S14/HOCBONG; remake scholarship dashboard

List plans, candidates and awarded scholarship rows by term.

API: `GET /scholarships`. · DB: `SDSKHHBHK.IDKHHBHK`, `MaKhHBHK`, `NHHK`, `TenKhHBHK`, `IsLockHB`, `HeDiemHB`, `STienKHHBHK`; `SDSHB.IDDSHB`, `NHHK`, `IDSV`, `IDKHHBHK`, `MucHB`, `DiemTBHB`, `
S2 · Legacy `TaoDSSVXetHB` / `XetHocBongTieuChuan`; remake selection action

Legacy TaoDSSVXetHB / XetHocBongTieuChuan; remake selection action

Build candidate list and validate scholarship threshold rules.

API: `POST /scholarships/selection`. · DB: `SSVXETHB.IDSVXETHB`, `NHHK`, `IDSV`, `IDKHHBHK`; `SKHHBHKCT.IDKHHBHKCT`, `IDKHHBHK`, `MucHB`, `NguongTB`, `NguongTBRL`, `SLHBGH`, `STHBGH`.
S3 · Legacy award/tinh tien; remake award action

Legacy award/tinh tien; remake award action

Commit scholarship amount and reason for selected students.

API: `POST /scholarships/{planId}/award`. · DB: `SDSHB.IDKHHBHK`, `IDSV`, `MucHB`, `PTramMG`, `TienHB`, `SoThangHB`, `LyDoHB`, `GcHBSV`, `NgayThem`, `MaUser`.
S4 · Legacy social support/vay von; remake import action

Legacy social support/vay von; remake import action

Import social-support and loan records without requiring HP runtime.

API: `POST /social-support/import`. · DB: `SDCSSVHK.IDSV`, `IDDCS`, `IsTroCapXaHoi`, `NHHK`, `TienTroCap`, `SoQDDCSSV`, `TuNgay`, `DenNgay`, `TrangThaiDuyetDCS`; `SDCSSVC.IDSV`, `IDDCS`, `NHHKBD`, `NHHK
S5 · GAP - tenant scholarship formulas

GAP - tenant scholarship formulas

Current docs identify threshold/amount columns but not every tenant-specific formula in `HocBongDA`.

MãHọ tênLớp/NgànhTrạng tháiGhi chú
SV22010001Nguyễn Văn AnCNTT-K18-01Đang họcQĐ/2025/810
SV22010015Trần Thị BìnhCNTT-K18-02Tạm dừngQĐ/2025/811
SV22010028Lê Minh ChâuKT-K18-01Đang họcQĐ/2025/812
SV22010042Phạm Quốc DũngQTKD-K18-01Nghỉ luônQĐ/2025/813
SV22010057Hoàng Thu HàNN-K18-03Đang họcQĐ/2025/814
SV22010063Vũ Đức KhoaCNTT-K18-01Tốt nghiệpQĐ/2025/815
API: `POST /scholarships/selection`, `POST /scholarships/{planId}/award`. · DB: Add formula-to-column map for `NguonTBHB`, `HeDiemHB`, `IsFlagTinhHB`, `IsFlagDTB`, and tenant flags before full 1:1 sign-off.