USP_SIMPLEDATALIST_GIVINGLEVELSMARTFIELD

            CREATE procedure dbo.USP_SIMPLEDATALIST_GIVINGLEVELSMARTFIELD
            as
                begin
                    set nocount on;

                    select SF.ID as VALUE, 
                        SF.NAME as LABEL
                    from dbo.SMARTFIELD SF
                        inner join dbo.SMARTFIELDCATALOG SFC on SF.SMARTFIELDCATALOGID = SFC.ID
                        inner join dbo.RECORDTYPE RT on SFC.RECORDTYPEID = RT.ID
                        where DATATYPECODE = 3 and RT.BASETABLENAME = 'CONSTITUENT'
                end