SMS · UC-SMS-11

UC-SMS-11 — Hoat dong sinh vien / CLB / doan the

Hoat dong sinh vien / CLB / doan the 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-11.md · Sample data (fake VN)

S1 · Legacy `S32/S52/S53`; remake activity dashboard

Legacy S32/S52/S53; remake activity dashboard

Load club, social activity, extracurricular and union records.

termCodeNHHKkeywordstudentIdsIDCLBSVIDHDXHIDDTuSV

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

`SDMCLBSV.IDCLBSV`, `MaCLBSV`, `TenCLBSV`; `SDKCLBSV.IDDKCLB`, `IDCLBSV`, `IDSV`, `NHHK`, `NgayTGCLB`; `SHDXH.IDHDXH`, `MaHDXH`, `TenHDXH`, `TuNgayHDXH`, `DenNg

S2 · Legacy CLB registration; remake club registration action

Legacy CLB registration; remake club registration action

studentIdstermCodeIDCLBSVNgayTGCLBGcDKCLB dryRun

API: `POST /clubs/registrations`. · DB:

`SDKCLBSV.IDDKCLB`, `IDCLBSV`, `IDSV`, `NHHK`, `NgayTGCLB`, `GcDKCLB`, `NgayThem`, `MaUser`; lookup `SDMCLBSV.IDCLBSV`, `TenCLBSV`.

S3 · Legacy doan the import; remake union import action

Legacy doan the import; remake union import action

Import or update student union/organization records.

termCodestudentIdsIDDTuSVSoDTUNoiDungDTUNgayNhanDTUNgayTraDTUTrangThaiDTUGhiChuDTU dryRun

API: `POST /student-unions/import`. · DB:

`SDSDTUSV.IDDSDTUSV`, `IDSV`, `NHHK`, `IDDTuSV`, `SoDTU`, `NoiDungDTU`, `NgayNhanDTU`, `NgayTraDTU`, `TrangThaiDTU`, `GhiChuDTU`, `IDDVXL`.

S4 · GAP - alumni source for `GET /alumni`

GAP - alumni source for GET /alumni

API index exposes `GET /alumni`, but current UC/database docs do not map alumni to a concrete UC-SMS-11 table.

DienThoai1TNEmailTNDiaChiTNTinhTrangViecLamMucTN

API: `GET /alumni`. · DB:

Candidate source is `SHSTN.IDSV`, `DienThoai1TN`, `EmailTN`, `DiaChiTN`, `TinhTrangViecLam`, `ViecLamHopLe`, `MucTN`, but this must be confirmed before implemen

S5 · GAP - activity category lookups

GAP - activity category lookups

Current docs include activity/club/union tables but not every lookup table for union type and activity category labels.

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-activities`, `POST /student-unions/import`. · DB: `SDSDTUSV.IDDTuSV`, `SHDNGKHOA.TenHDNgKhoa`, `SHDXH.TenHDXH`; add lookup schema before full UI parity.