viw_kpimaster.md
1.71 KB
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
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.