# `act_id_group` (view) > VIEW - **Updatable:** NO - **Definer:** `xlyprint@%` ## 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 `xlyweberp_saas_ai`.`sisjurisdictionclassify` `r` where (`r`.`bLogininfoShow` = 0) group by `r`.`sId` ``` ## Narrative _No human-written narrative yet._