WebCOBRA.com Community Message Boards

blanier_webcobradev
Posts: 3
Since: 06/29/2009

What field can be used to query ARRA End Date? I need to identify QB's who lost the ARRA subsidy on 11/30/2009 and 12/31/2009.

Thank you in advance for your assistance.
Take care, Brooke

sszelei
Posts: 53
Since: 09/02/2009

Brooke,

ARRA End Date is calculated based on the event date of the Enrolled QB. You can use the QBGroupStatusId to see if they are enrolled To identify if the QB is receiving the stimulus you can again use the QBDateTracking table and Look for QA Stimulus Authorized. Then with QBBenefitAssignments you can get the FDLOC to calculate the ARRA End Date.

Regs,

Steven

evannielsen
Posts: 11
Since: 08/10/2008

And once you have all these dates what is the formula to calculate the End Date?

-Evan

sszelei
Posts: 53
Since: 09/02/2009

FDLOC + 15 months