spLoadRecord_FundraiserSolicitorContactAction

            CREATE     PROCEDURE [dbo].[spLoadRecord_FundraiserSolicitorContactAction]
            (            
                @PKID int
            )
            AS

            SELECT     
                frsca.[ID], 
                frsca.[FundraiserSolicitorContactID], 
                frsca.[AddressbookContactsID], 
                frsca.[FundraiserSolicitorsID], 
                frsca.[CreateDate], 
                frsca.[UpdateDate], 
                frsca.[Deleted],
                frsca.[Type], 
                frsca.[Status], 
                frsca.[StatusReport],
                frsca.[FundRaiserDonationsID],
                frsca.[FundRaiserSolicitorEmailID],
                isnull(frsca.[EmailJobRecipientID], dbo.fnEmailJobRecipientIDByEmailRecipientID(frsca.EmailRecipientID)) EmailJobRecipientID,
                frsca.[EmailRecipientID],
                frsca.[ForwardEmailJobRecipientID],
                frsca.[ForwardingContactActionID],
                isnull(ejr.[Opened], ejr2.[Opened]) [Opened],
                isnull(ejr.[OpenedDate], ejr2.[OpenedDate]) [OpenedDate], 
                isnull(frd.[IsAthon], 0) [IsAthon],
                isnull(frd.Amount, 0) [Amount],
                [Children] = (SELECT COUNT(a2.ID)
                        FROM emailjob_recipient r 
                        inner join FundraiserSolicitorContactAction a2 on r.ID = isnull(a2.EmailJobRecipientID, a2.ForwardEmailJobRecipientID)
                        WHERE frsca.EmailJobRecipientID is null and r.EmailRecipientID = frsca.EmailRecipientID)

            FROM FundraiserSolicitorContactAction frsca
            LEFT JOIN EmailJob_Recipient ejr ON isnull(frsca.EmailJobRecipientID, [dbo].[fnEmailJobRecipientIDByEmailRecipientID](frsca.EmailRecipientID)) = ejr.ID 
            LEFT JOIN EmailJob_Recipient ejr2 ON frsca.ForwardEmailJobRecipientID = ejr2.ID
            LEFT JOIN FundRaiserDonations frd on frd.ID = frsca.FundRaiserDonationsID
            WHERE frsca.ID = @PKID