WebCOBRA.com Community Message Boards

jsfrench
Posts: 7
Since: 10/23/2009

I am attempting to build a chronological status history for QB Groups that shows what status a QB Group was in at any particular time, based on effective dates (not datestamps or transaction dates). For example

1/1/2010 - 1/31/2010: status 3
2/1/2010 - 2/15/2020: status 4
2/16/2010 - 2/28/1010: status 5

The QBGroupStatusHistory table does not show the effective date ranges, that dates seem to be based on the dates status changes were transacted. For example, if a QB Group is in status 4 enrolled from 1/1/2010 to 2/28/2010, and then on 3/15/2010 the group is terminated effective 1/31/2010, the status history record shows a range of 1/1/2010 to 3/15/2010. I need to know the 'NET' resulting history.

qheinicken
Posts: 4
Since: 10/09/2009

Currently we do not store effective dates of Status changes in QBGroupStatusHistory or QBHistoryDetail. You could request that we begin doing so as an enhancement if you wish it to show effective dates.

Thanks,
Quad Heinicken
Software Developer
Travis Software

jsfrench
Posts: 7
Since: 10/23/2009

Are there any other tables aside from the status history table that contain sufficient information to derive a status history based on effective dates rather than transaction dates?

Thanks,
Jim

qheinicken
Posts: 4
Since: 10/09/2009

No, this information is not stored in the system at this time.