# `act_id_group` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `ID_` | `varchar(255)` | NO |
| 2 | `REV_` | `binary(0)` | YES |
| 3 | `NAME_` | `varchar(255)` | NO |
| 4 | `TYPE_` | `varchar(10)` | NO |

## Definition

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

## Narrative

_No human-written narrative yet._
