2022-10-31 Architecture WG Meeting Notes

Owned by Nathan Southern
Last updated: Dec 21, 2022

Date

ZOOM Meeting Information:

Monday, October 31st at  9am PT/12pm ET


Attendees:

Nathan Southern 

Peter Antley 

Dale Harris 

Ken Sayers 

Faheem

James Madison 

Jefferson Braswell

Brian Hoffman

Tsvetan Georgiev




Join Zoom Meeting

https://zoom.us/j/7904999331

Meeting ID: 790 499 9331

Attendees:

Agenda:


HDS

  1. Created
    1. au_premium: Github
    2. func datediff: Github
    3. earned premium query (WIP): Github
    4. earned premium function (WIP): Github
    5. car years function (WIP): Github
    6. ETL (WIP/TODO + Loss): Github
    7. Premium Record (JSON): Github
  2. Questions/Observations
    1. Date data type appears to autoload HH:MM:SS 
    2. Numeric is returning a lot of decimal places
    3. function names, table names, columns, do not appear to be case sensitive. recommend the use of underscores. 
  3. Test Data set
    1. Mongo/Excel outstanding loss +=1.4% variation
    2. Postgres/Excel - Loss records in progress
    3. Only 5000 Premium Records
    4. Min Record 2000-01-01
    5. Max Record 2000-03-01
    6. Max/Min present issue, it is not possible to effectively test all 4 groups: Lucid

Notes:


  •  Notes included in Architecture Definition Workspace doc


TimeItemWhoNotes




Documentation:

Notes: (Notes taken live in Requirements document)

Recording: