# `viw_process_classify` (view)

> VIEW


- **Updatable:** NO
- **Definer:** `xlyprint@%`

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sId` | `varchar(50)` | YES |
| 2 | `sParentId` | `varchar(50)` | YES |
| 3 | `sProcessName` | `varchar(100)` | NO |
| 4 | `sBrandsId` | `varchar(50)` | YES |
| 5 | `sSubsidiaryId` | `varchar(50)` | YES |
| 6 | `sMakePerson` | `varchar(50)` | NO |
| 7 | `tCreateDate` | `datetime` | NO |
| 8 | `bInvalid` | `bit(1)` | NO |

## Definition

```sql
select `xlyweberp_saas_ai`.`eleprocess`.`sId` AS `sId`,`xlyweberp_saas_ai`.`eleprocess`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`eleprocess`.`sProcessName` AS `sProcessName`,`xlyweberp_saas_ai`.`eleprocess`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`eleprocess`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`eleprocess`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`eleprocess`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`eleprocess`.`bInvalid` AS `bInvalid` from `xlyweberp_saas_ai`.`eleprocess` union select `xlyweberp_saas_ai`.`sisprocessclassify`.`sId` AS `sId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sName` AS `sName`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`sisprocessclassify`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`sisprocessclassify`.`bInvalid` AS `bInvalid` from `xlyweberp_saas_ai`.`sisprocessclassify` where `xlyweberp_saas_ai`.`sisprocessclassify`.`sId` in (select `xlyweberp_saas_ai`.`eleprocess`.`sParentId` from `xlyweberp_saas_ai`.`eleprocess`)
```

## Narrative

_No human-written narrative yet._