# `viw_kpimaster` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sUserName` | `varchar(255)` | NO |
| 2 | `tCreateDate` | `datetime` | NO |
| 3 | `iTodayOk` | `decimal(32,0)` | YES |
| 4 | `iTodayNo` | `decimal(32,0)` | YES |
| 5 | `iTodayTotal` | `decimal(32,0)` | YES |
| 6 | `iTodayStandard` | `decimal(32,0)` | YES |
| 7 | `iStandardRate` | `decimal(39,4)` | YES |
| 8 | `dCompRate` | `decimal(39,4)` | YES |
| 9 | `sId` | `varchar(255)` | NO |
| 10 | `sBrandsId` | `varchar(255)` | NO |
| 11 | `sSubsidiaryId` | `varchar(255)` | NO |
| 12 | `sSlaveId` | `varchar(255)` | NO |
| 13 | `drewardMoney` | `decimal(18,6)` | NO |
| 14 | `dpunishmentMoney` | `decimal(18,6)` | NO |
| 15 | `sUnTaskFromId` | `varchar(255)` | NO |

## Definition

```sql
select `sftlogininfo`.`sUserName` AS `sUserName`,`kpimaster`.`tCreateDate` AS `tCreateDate`,sum(`kpimaster`.`iTodayOk`) AS `iTodayOk`,sum(`kpimaster`.`iTodayNo`) AS `iTodayNo`,sum(`kpimaster`.`iTodayTotal`) AS `iTodayTotal`,sum(`kpimaster`.`iTodayStandard`) AS `iTodayStandard`,((100 * sum(`kpimaster`.`iTodayStandard`)) / sum(`kpimaster`.`iTodayTotal`)) AS `iStandardRate`,((100 * sum(`kpimaster`.`iTodayOk`)) / sum(`kpimaster`.`iTodayTotal`)) AS `dCompRate`,`kpimaster`.`sId` AS `sId`,`kpimaster`.`sBrandsId` AS `sBrandsId`,`kpimaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`kpimaster`.`sId` AS `sSlaveId`,`kpimaster`.`drewardMoney` AS `drewardMoney`,`kpimaster`.`dpunishmentMoney` AS `dpunishmentMoney`,`kpimaster`.`sUnTaskFromId` AS `sUnTaskFromId` from (`kpimaster` join `sftlogininfo` on((`kpimaster`.`sMakePerson` = `sftlogininfo`.`sId`))) group by `kpimaster`.`sMakePerson`,`kpimaster`.`tCreateDate`
```

## Narrative

_No human-written narrative yet._