USP_STANDARDASKLADDER_ADDSMARTFIELD

create procedure dbo.USP_STANDARDASKLADDER_ADDSMARTFIELD(
  @CHANGEAGENTID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier
)

  as
    set nocount on;

    declare @ID uniqueidentifier
    declare @SMARTFIELDCATALOGID uniqueidentifier
    declare @SMARTFIELDDATAFORMITEM xml
    declare @SMARTFIELDVALUEGROUPS xml
    declare @NAME nvarchar(100)
    declare @USEVALUEGROUP bit
    declare @SYSTEMFIELD bit
    declare @DATAFORMINSTANCECATALOGID uniqueidentifier
    declare @DATEVALUEGROUPUNITCODE tinyint
    declare @SOURCEQUERYVIEWCATALOGID uniqueidentifier
    declare @SITESSELECTED xml
    declare @SITEFILTERENABLEDFORINSTANCE bit
    declare @DESCRIPTION nvarchar(4000)
    declare @FEATURETYPE tinyint

    begin try
      if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    set @ID = null
    select @SMARTFIELDCATALOGID = ID from dbo.SMARTFIELDCATALOG where PROCEDURENAME = 'USP_SMARTFIELD_AGGREGATEREVENUEAMOUNTS'
    set @SMARTFIELDDATAFORMITEM = '<DataFormItem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="bb_appfx_dataforms"><Values><fv ID="CAMPAIGNS" /><fv ID="STARTDATERECENTDATEUNITCODE"><Value xsi:type="xsd:string"  >0</Value></fv><fv ID="DATETYPECODE"><Value xsi:type="xsd:unsignedByte"  >0</Value></fv><fv ID="ENDDATE" /><fv ID="CALCULATIONTYPE"><Value xsi:type="xsd:string"  >12</Value></fv><fv ID="STARTDATERECENTDATEINTERVAL" /><fv ID="STARTDATE" /><fv ID="DESIGNATIONS" /><fv ID="TYPECODES"><Value xsi:type="DataFormItemArrayValue"  ><Items><DataFormItem><Values><fv ID="TYPECODEID"><Value xsi:type="xsd:string">0</Value></fv></Values></DataFormItem></Items></Value></fv><fv ID="INCLUDESOFTCREDITS"><Value xsi:type="xsd:boolean"  >false</Value></fv></Values></DataFormItem>'
    set @SMARTFIELDVALUEGROUPS = ''
    set @NAME = 'Standard ask ladder-latest gift amount'
    set @USEVALUEGROUP = 0
    set @SYSTEMFIELD = 0
    select @DATAFORMINSTANCECATALOGID = ID from dbo.DATAFORMINSTANCECATALOG where FORMNAME = 'Smart Field Add Form'
    set @DATEVALUEGROUPUNITCODE = 0
    set @SOURCEQUERYVIEWCATALOGID = null
    set @SITESSELECTED = '<SITESSELECTED />'
    set @SITEFILTERENABLEDFORINSTANCE = 0
    set @DESCRIPTION = ''
    set @FEATURETYPE = 1

    exec dbo.USP_SMARTFIELD_ADDINSTANCE @ID, @CHANGEAGENTID, @SMARTFIELDCATALOGID, @SMARTFIELDDATAFORMITEM, @SMARTFIELDVALUEGROUPS, @NAME, 
      @USEVALUEGROUP, @SYSTEMFIELD, @CURRENTAPPUSERID, @DATAFORMINSTANCECATALOGID, @DATEVALUEGROUPUNITCODE, @SOURCEQUERYVIEWCATALOGID,
      @SITESSELECTED, @SITEFILTERENABLEDFORINSTANCE, @DESCRIPTION, @DATAFORMINSTANCECATALOGID, @FEATURETYPE
    end try

        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch

    return 0;