# `act_id_group`（视图）


- **是否可更新：** NO
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `ID_` | `varchar(255)` | NO |
| 2 | `REV_` | `binary(0)` | YES |
| 3 | `NAME_` | `varchar(255)` | NO |
| 4 | `TYPE_` | `varchar(10)` | NO |

## 定义

```sql
select `r`.`sName` AS `ID_`,NULL AS `REV_`,`r`.`sName` AS `NAME_`,'assignment' AS `TYPE_` from `xlyweberp_saas_ai`.`sisjurisdictionclassify` `r` where (`r`.`bLogininfoShow` = 0) group by `r`.`sId`
```

## 说明

_暂无人工说明。_