DBE Enquiry

[Mar Rainsby]

Hello

 

I was hoping you might be able to help. I need to run a dbe query to get all data since 01-06-2016 for a migration. That's all I have been provided with. 

I know DBE is a bit limited - does anyone know what parameters I could use that will give me everything including clients, policies and claims. 

 

Thanks 

 

[Mark Sollis]

Hi Mar

 

Is this an extract from your server - or as a migration from another OGI system, ONTO your server?

[Mar Rainsby]

It is an extract from our server as we are moving data from one branch to another one 

[Mark Sollis]

OK - But you do have InfoCentre?

 

That would be my tool of choice. Any reason why you need to use DBE?

[Mar Rainsby]

OGI have advised that is the process they will take 

 

[Mark Sollis]

Ouch - so Open GI want it in DBE but wont tell you how to get it!?  I presume you are paying them for the Transfer service  

 

Not sure I can help easily - it depends on lots of things - why you are doing this, what are you trying to achieve, what happens to the data you can't / don't bring across, what about accounts, risk, diary, operator trails, prospects, histories etc etc etc etc. Is it policies live after 2016 but taken out in 2015 - or just NB from 2016 etc?. Sooooooo many unknowns to give you a proper answer.

 

You really need to be guided by the business need and their scope / requirements and, then ask OGI to deliver the service / solution to you.

 

Looking back - the DBE "how to" is probably the easiest part in this. The "why" and the "what" are the more difficult questions to be addressed imho - but maybe that's just me being me 

 

I / we here can help with the DBE parameters as and when / if needed (if OGI can't / won't) 

[karl]

On 31/01/2022 at 18:24, Mark Sollis said:

Ouch - so Open GI want it in DBE but wont tell you how to get it!?  I presume you are paying them for the Transfer service  

 

Not sure I can help easily - it depends on lots of things - why you are doing this, what are you trying to achieve, what happens to the data you can't / don't bring across, what about accounts, risk, diary, operator trails, prospects, histories etc etc etc etc. Is it policies live after 2016 but taken out in 2015 - or just NB from 2016 etc?. Sooooooo many unknowns to give you a proper answer.

 

You really need to be guided by the business need and their scope / requirements and, then ask OGI to deliver the service / solution to you.

 

Looking back - the DBE "how to" is probably the easiest part in this. The "why" and the "what" are the more difficult questions to be addressed imho - but maybe that's just me being me 

 

I / we here can help with the DBE parameters as and when / if needed (if OGI can't / won't) 

Exactly. Been a long while since I participated in an OGI data migration utilising DBE to supply the source data but the key question is the criteria (as Mark said) - live only or include terminated, client & policy detail only or also claims/diary/ledger etc.?  If you need more than just base policy info using  DBE you are talking multiple enquiries….