openIDL Navigation
...
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.
Time | Item | Who | Notes |
---|---|---|---|
...