WebCOBRA.com Community Message Boards

Al_Kunz
Posts: 2
Since: 11/06/2009

My employer is preparing to convert from the Travis system to WebCobra. We currently prepare some reports and datafeeds from the data in Travis. It is our plan to use the Relational API as the data source for these once we convert. I've evaluated the data we use in the reports and believe I've found what I need for most in the Relational API. However there are a few I haven't been able to find. Could you point me in the right direction?

The fields are:

From the qual_mas table in Travis the field called STIMULUSVERIFIED which I've used to determine a person was receiving the stimulus subsidy and STIMULUSSTART which told me when the subsidy started.

From the premium table in Travis the field called PREM_END which indicated the date that payment paid a particular benefit up to. I know there is a column in the QBINFORMATIONCACHE table that appears to show that data at this point in time, but it isn't quite what I'm looking for since it could have been updated by a subsequent payment.

Thanks in advance for your help. I expect I'll have additional questions after I identify our data needs for the datafeeds.

PHorgan
Posts: 17
Since: 10/19/2009

Hello Al

In order to determine if a QB is ARRA Authorized, look at the QBDateTracking table. Records with a QBDateTypeID of 42 identify the QB as ARRA Authorized.



The date that ARRA Stimulus Started is not stored in WebCOBRA but is instead calculated based off of a QBs First Day After Loss of Coverage. If a QBs First Day After Loss of Coverage is prior to 03/01/2009 then their ARRA Stimulus will start 03/01/2009. If their First Day After Loss of Coverage is after 03/01/2009 then the date ARRA Stimulus Starts would equal their First Day After Loss of Coverage.



In order to determine the month a payment was for you will have to look at two tables.



The first table is called AccountingPayment. This will give you your payment and PaymentHistoryID



The second table is account AccountingRegister. Based off of the PaymentHistoryID from AccountingPayment you will be use the DueDate field from AccountingRegister to determine which month the payment affected.



Hope this helps

Peter

Al_Kunz
Posts: 2
Since: 11/06/2009

Can you point me the right direction for one more data element? I am looking for CO_BRCD from the QUAL_MAS table in Travis. Where would this be in and how would it link to a QB or QB Group?

bptillman
Posts: 22
Since: 12/21/2007

CO_BRCD in Travis Cobra refers to the Branch that a QB is assigned, and in WebCOBRA those are called Departments and are in the QBGroupAssociations table.

If you go to the following thread I have linked to below, and look at jwolgamott's post on 6/11/08 at 12:48 PM you will see a sample query you can use to pull QB's and the departments they are assigned to.

http://devcenter.webcobra.com/conve rsations/77.aspx