spLoadRecord_GivingHistoryUsedFields

            CREATE PROCEDURE [dbo].[spLoadRecord_GivingHistoryUsedFields]
            (
                @SiteContentID int
            )
            AS
            BEGIN

                SELECT
                    gh.ID,
                    gh.FieldLocalizationGuid,
                    gh.TableName,
                    gh.ColumnName,
                    gh.DefaultName,
                    used.FieldID,
                    used.DisplayOrder,
                    gh.SortType
                FROM
                    [dbo].[GivingHistorySchemaFields] gh
                LEFT OUTER JOIN [dbo].[GivingHistoryUsedFields] used
                    ON
                    (
                        used.FieldID = gh.ID
                    AND
                        @SiteContentID = used.SiteContentID
                    )

            END