SMS · UC-SMS-08

UC-SMS-08 — Ban can su / co van hoc tap

Ban can su / co van hoc tap 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-08.md · Sample data (fake VN)

S1 · Legacy `S13/S37`; remake advisor/BCS list

Legacy S13/S37; remake advisor/BCS list

Load class advisors and student class-officer assignments by term/class.

termCodeNHHKkeywordclassIdIDLopstudentIdsIDCVBCSIDCVHTIDNV

termCode	NHHK	keyword	classId	IDLop	studentIds
SV22010001	Nguyễn Văn An	CNTT-K18-01	Đang học	QĐ/2025/810	Mẫu-1
SV22010015	Trần Thị Bình	CNTT-K18-02	Tạm dừng	QĐ/2025/811	Mẫu-2
SV22010028	Lê Minh Châu	KT-K18-01	Đang học	QĐ/2025/812	Mẫu-3
SV22010042	Phạm Quốc Dũng	QTKD-K18-01	Nghỉ luôn	QĐ/2025/813	Mẫu-4
SV22010057	Hoàng Thu Hà	NN-K18-03	Đang học	QĐ/2025/814	Mẫu-5
SV22010063	Vũ Đức Khoa	CNTT-K18-01	Tốt nghiệp	QĐ/2025/815	Mẫu-6

API: `GET /student-advisors`. · DB:

`SCVSV.IDCVSV`, `IDSV`, `NHHK`, `IDLop`, `IDCVBCS`; `SDMCVBCS.IDCVBCS`, `MaCVBCS`, `TenCVBCS`, `HuyCVBCS`; `SGVCN.IDGVCN`, `IDLop`, `NHHK`, `IDNV`; `SSVHK.IDSV`

S2 · Legacy ban can su assignment; remake assign action

Legacy ban can su assignment; remake assign action

Assign or replace student class officer roles.

termCodestudentIdsclassIdIDCVBCS dryRun

API: `POST /student-advisors/assign`. · DB: `SCVSV.IDSV`, `NHHK`, `IDLop`, `IDCVBCS`, `NgayThem`, `MaUser`; validate `SDMCVBCS.IDCVBCS`.

S3 · Legacy `SaveGVCN` / `UpdateCoVanHT`; remake homeroom/advisor action

Legacy SaveGVCN / UpdateCoVanHT; remake homeroom/advisor action

Assign homeroom teacher/advisor for class and optionally propagate to roster.

classIdtermCodeIDNVIDCVHTstudentIdsGcGVCN dryRun

API: `PUT /classes/{classId}/homeroom-teacher`. · DB: `SGVCN.IDLop`, `NHHK`, `IDNV`, `GcGVCN`; `SSVHK.IDSVHK`, `IDLop`, `NHHK`, `IDCVHT` when updating CVHT on roster rows.

S4 · GAP - staff identity source

GAP - staff identity source

Current SMS docs expose `IDNV`/`IDCVHT` but not the full staff lookup table/API for teacher names.

keywordtermCode

Mã	Họ tên	Lớp/Ngành	Trạng thái	Ghi chú
SV22010001	Nguyễn Văn An	CNTT-K18-01	Đang học	QĐ/2025/810
SV22010015	Trần Thị Bình	CNTT-K18-02	Tạm dừng	QĐ/2025/811
SV22010028	Lê Minh Châu	KT-K18-01	Đang học	QĐ/2025/812
SV22010042	Phạm Quốc Dũng	QTKD-K18-01	Nghỉ luôn	QĐ/2025/813
SV22010057	Hoàng Thu Hà	NN-K18-03	Đang học	QĐ/2025/814
SV22010063	Vũ Đức Khoa	CNTT-K18-01	Tốt nghiệp	QĐ/2025/815

API: `GET /student-advisors`, `PUT /classes/{classId}/homeroom-teacher`. · DB: `SGVCN.IDNV`, `SSVHK.IDCVHT`; add staff catalog columns before full UI smoke.