Page History

...

1. Peter's team has been building it out. 
2. 2 weeks ago - PA shared the list of files and data regarding particular files
3. Joseph pulled up his screen to illustrate where it stands today. Background: 
   1. There is a table now with stat data
   2. 1 column for each code on the stat record
   3. Around 100 records
   4. Just working with a small sample for the purposes of development.
   5. Wrt SDMA: they have added the ability to search and filter on columns.
   6. Some issues have arisen from trying to filter more than one column at a time. On this note: Peter verified that it is indeed a requirement. Those present: yes, it is.
   7. On this note Peter's team will find a way to make this happen.
   8. Clarification of which criteria are used to filter. Joseph: some data types may be different. Current components:
      1. Contains
      2. Equals
      3. Starts with 
      4. Ends with 
      5. Is Empty
      6. Is Not Empty
      7. Is Any of
   9. Should be sufficient for string values. Clarification among attendees: criteria need to be more specific - e.g., filtering against x error code for y amount, for z dollar range. Noted in meeting that the drop-downs can be used for this purpose. Currently set up per: Column/Operator/Value. 
   10. Noted that it isn't possible to filter out multiple column headings per excel. However it is possible to keep adding additional filters.
   11. Peter does intend to add numerical filters however to provide broader capability. 
   12. Decision: for now they will start with "And" and then add sublines. "Or" will probably not be needed. Many will be = or greater than or lesser than, or contains (to search for something in the middle of the string. Nulls and blanks as well, and ranges (combinations of less than and greater than). Operators can be easily built as general purpose selectors. 
   13. AAIS is trying very hard to make the application free. Most of the out of box grid components tables such as this give everything away for free except for the components used for enterprise settings. AAIS seeking a low to no cost open source solution for the table and Peter anticipates getting it worked out.
   14. Steps for Peter's team moving forward
       1. Get grid component worked out with multiple filtering
       2. Will get UI est'd for business users to prompt the application to do these things
       3. Running filters many times will be getting an updated data set from the database; this will need to be implemented as well.
       4. They will then explore displaying errors using the drools engine and will then get the error report for the post-validation stage. Seeking the same type of error report produced by excel from this application.

B. Recap on previous request for more documentation on data standards

1. Peter's team has all of the stat plans

2. The name of the auto one has been changed, and it's very close to being 'openIDL Personal Auto Stat Plan.'

3. The rest have a lot of AAIS words on them but the coding instructions are still valid for now.

4. Previous question: where do we put them and how can we share them? It was noted that they can be stored on the wiki and that this dovetails with the current broad revision of the wiki being undertaken by Sean Bohan. A section will be made on the wiki exclusively for this

C. The Escalation of including a policy effective date for some of the stat plans.

1. AAIS is in the planning stages of how they are going to get this out.
2. A separate internal project that they are working on - looking at line by line enhancements to existing stat plans, which would in turn enhance openIDL also. 
3. Originally they wanted to incorporate these into the openIDL rollout but now it's a question of using the current stat plans as they are 
4. Currently, most of lines of business don't have a policy effective date on the premium end loss layout records such as auto. This is a critical field for current and future purposes, handling any new carrier transitions coming in, and any issues related to runoff loss handling
5. The plan is to coordinate it with the openIDL world
6. It will take the form of a 4-digit field - 4 positions starting with 2 lines (priorities: auto and commercial fire - priorities).
7. This needs to be incorporated into stat plans in a 4 digit format
8. they will then look at moving this into other lines of business
9. Their current target ETA is Q1 2024

It was pointed out that this can open a broader discussion with the group about enhancements to the data model.

...