SMS · UC-SMS-02

UC-SMS-02 — Danh sach sinh vien hoc ky

Danh sach sinh vien hoc ky 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-02.md · Sample data (fake VN)

S1 · Legacy `S01`; remake `semester-students` list

Legacy S01; remake semester-students list

Load semester student roster and compare row count/filter behavior.

termCodeNHHKclassIdIDLopkeywordHienDienSVIDDVPCIDSVHKMaSVTenDayDuMaLopTenLopTTSVHKGcSVHK

termCode	NHHK	classId	IDLop	keyword	HienDienSV
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 /semester-students`. · DB:

`SSVHK.IDSVHK`, `NHHK`, `IDSV`, `IDLop`, `HienDienSV`, `TTSVHK`, `GcSVHK`, `IDDVPC`; join `SDMSV.IDSV`, `MaSV`, `TenDayDu`; join `SDMLOP.IDLop`, `MaLop`, `TenLo

S2 · Legacy `S01` sync/save; remake semester sync action

Legacy S01 sync/save; remake semester sync action

Add/update semester membership from existing student hub rows.

termCodestudentIdsclassIdHienDienSVDienHocTapNguonKPhi dryRunnoteCheckSinhVienTrogHK

API: `POST /semester-students/sync`. · DB:

`SSVHK.NHHK`, `IDSV`, `IDLop`, `HienDienSV`, `DienHocTap`, `NguonKPhi`, `NgayThem`, `MaUser`; `SSVHKN2.NHHK`, `IDSV`, `IDLop`, `SVNganh` when second-major roste

S3 · Legacy `S01` delete/remove; remake row action

Legacy S01 delete/remove; remake row action

Remove or exclude a student from semester roster with conflict handling.

semesterStudentIdtermCodenote

API: `DELETE /semester-students/{semesterStudentId}`. · DB:

Target `SSVHK.IDSVHK`; verify row deletion/status strategy and no orphan references; for second-major rows verify `SSVHKN2.IDSVHKN2`.

S4 · GAP - full `S01` toolbar/grid contract

GAP - full S01 toolbar/grid contract

Current docs list methods and core tables but not every WinForms button, hidden column, or tenant-specific status filter in `S01`.

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 /semester-students`, `POST /semester-students/sync`, `DELETE /semester-students/{semesterStudentId}`. · DB: `SSVHK`/`SSVHKN2` core columns; add missing UI-only flags before full 1:1 sign-off.