spLoadRecord_ClassYearNotesByOwnerID

            CREATE   procedure [dbo].[spLoadRecord_ClassYearNotesByOwnerID] (
                @OwnerID int 
            )
            as
                select cyn.ID, cyn.ClientClassYearsID, cyn.ClassNote, cyn.OwnerID, cyn.IsApproved, cyn.ApprovedByID, 
                cyn.ApprovedDate,    cyn.PublishDate, cyn.ModifiedDate, cyn.ExpireDate, cyn.DateLastChanged,
                ccy.[Name], ccy.Guid ClassYearsGuid, dbo.fnGetRaisersEdgeRecordIDFromPeopleID(cyn.BackOfficeSystemPeopleID) RaisersEdgeRecordID,
                cyn.FirstName, cyn.LastName
                from ClassYearNotes cyn
                inner join ClientClassYears ccy on ccy.ID = cyn.ClientClassYearsID
                where dbo.fnGetUserIDFromLinkedPeopleID(cyn.BackOfficeSystemPeopleID) = @OwnerID
                or cyn.OwnerID = @OwnerID