Key Assignment |
c01 is primary key. |
c02 is ACTive or INActive or DEFault. |
c03 is site code such as TRM for training motor. Every WLR record c03='ALL'. |
c04 is customer (MCU) as motor driver or policy holder. |
c05 is extra motor driver (MDR). |
c06 is zero and reserved for 3rd level customer contact names. |
c07 is zero and reserved for scheme identifier when multiple schemes are in use. |
c08 is asset as vehicle (MVE). |
c09 is policy (MPO). |
c10 is finance (MFI) and claim (MMC). |
c11 is claimant (MTC). |
c12 is note (M*N) as workflow. |
c13 is zero and reserved for note topic chain. |
Key Performance Indicators |
MCU-COUNT count customer MCU records. |
MDR-COUNT count driver MDR records in mcu1. |
MAS-COUNT count vehicle MAS records. |
MPO-COUNT count policy MPO records. |
MFI-COUNT count finance MFI records. |
MMC-COUNT count claim MMC records. |
MTC-COUNT count claimant MTC records. |
MCN-COUNT count customer notes MCN records in mwf1. |
MDN-COUNT count driver notes MDN records in mwf1. |
MVN-COUNT count vehicle notes MVN records in mwf1. |
MPN-COUNT count policy notes MPN records in mwf1. |
MFN-COUNT count finance notes MFN records in mwf1. |
MMN-COUNT count claim notes MMN records in mwf1. |
MTN-COUNT count claimant notes MTN records in mwf1. |
MPO-SUM sum value of policy MPO records. |
MFI-SUM sum value of finance MFI records. |