Date
Attendees
- Peter Antley
- Lori Dreaver Munn (Deactivated)
- Reggie Scarpa
- Jefferson Braswell
- Dale Harris
- Brian Hoffman
- Kevin Petruzielo
- Chudwick, Susan R
- Jenny Tornquist
- Ash Naik
This is a weekly series for The Regulatory Reporting Data Model Working Group. The RRDMWG is a collaborative group of insurers, regulators and other insurance industry innovators dedicated to the development of data models that will support regulatory reporting through an openIDL node. The data models to be developed will reflect a greater synchronization of data for insurer statistical and financial data and a consistent methodology that insurers and regulators can leverage to modernize the data reporting environment. The models developed will be reported to the Regulatory Reporting Steering Committee for approval for publication as an open-source data model.
openIDL Community is inviting you to a scheduled Zoom meeting.
Join Zoom Meeting
https://zoom.us/j/98908804279?pwd=Q1FGcFhUQk5RMEpkaVlFTWtXb09jQT09
Meeting ID: 989 0880 4279
Passcode: 740215
One tap mobile
+16699006833,,98908804279# US (San Jose)
+12532158782,,98908804279# US (Tacoma)
Dial by your location
+1 669 900 6833 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 929 205 6099 US (New York)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
888 788 0099 US Toll-free
877 853 5247 US Toll-free
Meeting ID: 989 0880 4279
Find your local number: https://zoom.us/u/aAqJFpt9B
PA - Recap
Shift from Mongo to PostgreSQL
Calculated EP - EP came out to same values that Mr. Harris made
Next hurdle with PostgreSQL - working with the loss records. Records have been loaded
First big milestone: producing outstanding records - i.e., how much money is outstanding. Records usu. put out quarterly, most important ones are the most recent
'Valid records' - most recent record wrt occurrence also paired with covg.
'Stale record' - an older record repl. with a newer one
PA: split groups up correctly, same # of valid & stale records
Some minor concerns wrt query #s - it appears this has been worked out via data engineer
Code updated wrt precision. tables have been updated to accommodate camel case
we are using 2 schemas in database - master scheme (openidl_base - raw transaction. records) + transaction schema (openidl_EP).
PA: will finalize some of granular details with Mr. Harris in the coming week. We're seeing a smooth transition to postgreSQL
PA - questions: none presented.
Looking ahead:
(Table) PA has finished EP column, working on car years. Working on breaking out additional columns
Has worked out bodily injury, property damage, earned premium, car years. Will be refining and producing reports accordingly.
Goals
Discussion items
| Time | Item | Who | Notes |
|---|---|---|---|