WebCOBRA.com Community Message Boards

kippfeldt
Posts: 18
Since: 02/08/2007

Hello,

I am trying to duplicate a report out of WebCobra called "Attributable ARRA Subsidy Based on Entry Date of Premium Payment from QB" I am using the Relational API downloaded data and cannot seem to duplicate the results that I get within WebCobra. The report is almost complete but I need to add some additional information (SSD, addresss, etc...), but I cannot seem to get the reports to match up. Any query help would be great.

Thanks,
Kipp

sszelei
Posts: 53
Since: 09/02/2009

Kipp,

You will need to link to the SystemInformationLinkTable like so:
",Addresses a
inner join SystemInformationLinkTable on SystemInformationLinkTable.TableLin kIdent = a.AddressID
and SystemInformationLinkTable.ModuleTy peID = 3 and SystemInformationLinkTable.InformationTypeID = 1"

with a where clause having
"AND a.AddressTypeID = 1"

Regs,

Steven

kippfeldt
Posts: 18
Since: 02/08/2007

Sorry for any confusion, but I know how to get the extra info (SSN, address, etc...). What I don't know how to get is the exact payment information and details that are generated from the "Attributable ARRA Subsidy Based on Entry Date of Premium Payment from QB" webcobra report. I can find the payment information and the ARRA details but am not getting same payment results (totals, records, etc...) that the webCobra report generates.

Thanks again for any help,
Kipp

sszelei
Posts: 53
Since: 09/02/2009

Try looking in the accounting register and see if that has the infromation you are looking for.

Regs,

Steven