WebCOBRA.com Community Message Boards

dschuyler
Posts: 5
Since: 03/25/2010

I'm trying to pull the QB address, and the qbid and the addressid are not equivalent. How does get the proper addressid?

I also need to get a qb's status on a plan. For example: John Doe is eligible for medical, dental and vision, but only elects medical. I can get his status as enrolled, but how do I drill down to the individual plans?

Many thanks

sszelei
Posts: 53
Since: 09/02/2009

To obtain address informaiton use somethig like

SELECT * FROM
QB qba,
Addresses a
inner join SystemInformationLinkTable on SystemInformationLinkTable.TableLin kIdent = a.AddressID
WHERE
SystemInformationLinkTable.ModuleId ent = qba.QBAutoID

To get plan information use the QBBenefitAssignment

Regs,

Steven

dschuyler
Posts: 5
Since: 03/25/2010

I am using the above with great success, but I'm finding some anomalies. Assuming you have access to the BPA web cobra system and the relational api, if I use the above and grab the info for qbautoid 1261, the resulting recordset shows 3 addresses, only one of which is correct. I've looked for the other addresses in web cobra under that qb, but I can't find them. (They actually belong to other qbs.) How do these get cross linked, how do I get rid of them, and how can I avoid this in the future?

Many thanks



David

PHorgan
Posts: 17
Since: 10/19/2009

Hello David

Please use this script

SELECT * FROM
QB , Addresses

inner join SystemInformationLinkTable ON SystemInformationLinkTable.TableLin kIdent = Addresses.AddressID

WHERE(SystemInformationLinkTable.Mo duleTypeID = 3) AND
(SystemInformationLinkTable.ModuleIdent = @QBAutoID ) AND
(SystemInformationLinkTable.InformationTypeID = 1) AND
(QB.QBAutoID = @QBAutoID)