# `viw_process_classify` (view)


- **Updatable:** NO

## 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 `eleprocess`.`sId` AS `sId`,`eleprocess`.`sParentId` AS `sParentId`,`eleprocess`.`sProcessName` AS `sProcessName`,`eleprocess`.`sBrandsId` AS `sBrandsId`,`eleprocess`.`sSubsidiaryId` AS `sSubsidiaryId`,`eleprocess`.`sMakePerson` AS `sMakePerson`,`eleprocess`.`tCreateDate` AS `tCreateDate`,`eleprocess`.`bInvalid` AS `bInvalid` from `eleprocess` union select `sisprocessclassify`.`sId` AS `sId`,`sisprocessclassify`.`sParentId` AS `sParentId`,`sisprocessclassify`.`sName` AS `sName`,`sisprocessclassify`.`sBrandsId` AS `sBrandsId`,`sisprocessclassify`.`sSubsidiaryId` AS `sSubsidiaryId`,`sisprocessclassify`.`sMakePerson` AS `sMakePerson`,`sisprocessclassify`.`tCreateDate` AS `tCreateDate`,`sisprocessclassify`.`bInvalid` AS `bInvalid` from `sisprocessclassify` where `sisprocessclassify`.`sId` in (select `eleprocess`.`sParentId` from `eleprocess`)
```

## Narrative

_No human-written narrative yet._
