Page History

...

1. 1. AAIS progress on Auditing the math
      1. Whats been done
      2. Whats been left to do
   2. Review our plans for Homeowners
   3. Evaluate Health of Group overall
      1. Meeting time,
      2. Agenda
      3. How can we do more
      4. Should we do more?

Goals

Meeting Minutes

• PA
  • Took data, tried to have same data on both sides
  • of all data, 2 numbers coming out correctly
  • different processes and steps to go from stat record to this page
  • <link to Peter's doc>
  • SDMA table - converts records to table design 
  • Next action - make sure getting the same # of records starting with all the way thru system
  • plan on debugging car years first
• JM - where does data come from?
• PA - raw stat records
• JM - not surprising, goes back to where the difficulty is, discussion couple weeks ago: from requirements or million little things not in the spec, basically repro logic from 4 boxes
• PA - trying to come up with same end result, went over biz layer logic, doing everything at query time, very simple, was built (long time ago), lot of ETL jobs described graphicallly in ETL tool, cant just read progressive lines of code - lot of decoding, big thing wrap up events in quarters, want to copy that, lets just make it as easy as possible to load w/o mult stages - couple places doing stuff wrong, could be extracting select queries, might have less than = to, maybe greater thans, unpacking and figuring out where deviations are
• DH - consider w/in transmittal table, might want gross prem and incurred losses to see if they come out equal
• PA - woprking with andy to gfigure out various tables, fig out where going differently, expect more clarity
• JM - what I expect, everyone likes stat records, easy to load/und, also that record gets incredibly large, why need steps along the way, idea is that bunch of stuff "we dont want this in code", thinking reverse way back into reasonable number b/w stat records and...
• PA - making report, runnign alias on earned exposure column, lot of code used, start to look at 

Discussion items

...