USP_DATAFORMTEMPLATE_VIEW_BIOGRAPHICALDEMOGRAPHIC

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(500)	INOUT
@BIRTHDATE	UDT_FUZZYDATE	INOUT
@MARITALSTATUS	nvarchar(50)	INOUT
@OCCUPATION	nvarchar(100)	INOUT
@MOSAIC	nvarchar(100)	INOUT
@HOUSEHOLDINCOME	nvarchar(100)	INOUT
@DISCRETIONARYSPEND	nvarchar(100)	INOUT
@HHMEMBERS	xml	INOUT
@SOURCE	nvarchar(100)	INOUT
@MATCHCODE	nvarchar(100)	INOUT
@CNOTES	nvarchar(1024)	INOUT
@AGE	nvarchar(3)	INOUT
@ACCOUNTTYPECODE	int	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BIOGRAPHICALDEMOGRAPHIC
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(500) = null output,
    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
    @MARITALSTATUS nvarchar(50) = null output,
  @OCCUPATION nvarchar(100) = null output,
  @MOSAIC nvarchar(100) = null output,
  @HOUSEHOLDINCOME nvarchar(100) = null output,
  @DISCRETIONARYSPEND nvarchar(100) = null output,
  @HHMEMBERS xml = null output,
  @SOURCE nvarchar(100) = null output,
  @MATCHCODE nvarchar(100) = null output,
  @CNOTES nvarchar(1024) = null output,
  @AGE nvarchar(3) = null output,
  @ACCOUNTTYPECODE int = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.
    select @DATALOADED = 1,
           @NAME = FULLNAME,
           @BIRTHDATE = BIRTHDATE,
           @MARITALSTATUS = MARITALSTATUS,
       @OCCUPATION = OCCUPATION,
       @MOSAIC = HOUSEHOLD_MOSAIC,
       @HOUSEHOLDINCOME = HOUSEHOLD_INCOMECODEID,
       @DISCRETIONARYSPEND = DISCRETIONARY_SPEND,
       @HHMEMBERS = dbo.UFN_WPBIOGRAPHICAL_GETHHMEMBERS2_TOITEMLISTXML(ID),
       @SOURCE = SOURCE,
       @MATCHCODE = MC + ' - ' + dbo.UFN_WPMATCHCODE_DESCRIPTION(MC),
       @CNOTES = CNOTES,
       @AGE = case BIRTHDATE when '00000000' then '' else cast(AGE as nvarchar(3)) end
    from dbo.WPBIOGRAPHICALDEMOGRAPHIC
    where ID = @ID

    select @ACCOUNTTYPECODE = ACCOUNTTYPECODE
    from WEALTHPOINTCONFIGURATION

    return 0;