Print this Page
How Does It Work
Motor Data Structure
Close this Page

4.5.10 Motor Data Structure
A simplified data model is employed with actual and future potential records.
Every motor logical racord and physical table has a "M" prefix.

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 codes
c01 means the primary key is replicated in this field as a unique identifier in the whole system.
cnn where nn is 04 to 13 means the current key value is replicated in this field as part of a hierarchy.

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.

WLR Data Structure for Motor App
CodeTablePurpose040506070809101112
MSCmsc1scheme (S)c0100000000
MCUmcu1customer (C)c0100000000
MCNmwf1customer notec040000000c01
MDRmcu1driver (D)c04c010000000
MDNmwf1driver notec04c05000000c01
MASmas1asset (A) c04000c010000
MANmwf1asset notec04000c08000c01
MPOmpo1policy order (P)c04000c08c01000
MPNmwf1policy notec04000c08c0900c01
MFImfi1finance (F)c04000c08c09c0100
MFNmwf1finance notec04000c08c09c100c01
MMCmmc1claim (M)c04000c08c09c0100
MNNmwf1claim notec04000c08c09c100c01
MTCmtc1claimant (T)c04000c08c09c10c010
MTNmwf1claimant notec04000c08c09c100c01
MTAmtc1claimant authorityc04000c08c09c100c01
MTSmtc1claimant insurerc04000c08c09c100c01
MTWmtc1claimant lawyerc04000c08c09c100c01

Reserved for Motor App
CodeTablePurpose040506070809101112
MUCmcu1contact (U)c04c05c01000000
MEQmeq1equipment (E) c04000c08c01000
MBAmba1Broker Agr (B)c04000c08c09c0100