USP_WPBIOGRAPHICALHHMEMBER_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@WPBIOGRAPHICALDEMOGRAPHICID	uniqueidentifier	IN
@FULLNAME	nvarchar(500)	IN
@FIRSTNAME	nvarchar(100)	IN
@MIDDLENAME	nvarchar(100)	IN
@LASTNAME	nvarchar(100)	IN
@SUFFIXCODEID	uniqueidentifier	IN
@BIRTHDATE	UDT_FUZZYDATE	IN
@MARITALSTATUSCODEID	uniqueidentifier	IN
@OCCUPATION	nvarchar(100)	IN
@TITLECODEID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SEQUENCE	int	IN

Definition

Copy



CREATE procedure dbo.USP_WPBIOGRAPHICALHHMEMBER_ADD (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
        @WPBIOGRAPHICALDEMOGRAPHICID uniqueidentifier,
        @FULLNAME nvarchar(500) = '',
        @FIRSTNAME nvarchar(100) = '',
        @MIDDLENAME nvarchar(100) = '',
        @LASTNAME nvarchar(100) = '',
        @SUFFIXCODEID uniqueidentifier = null,
        @BIRTHDATE dbo.UDT_FUZZYDATE = '00000000',
        @MARITALSTATUSCODEID uniqueidentifier = null,
        @OCCUPATION nvarchar(100) = '',
        @TITLECODEID uniqueidentifier = null,
        @CURRENTAPPUSERID uniqueidentifier = null,
        @SEQUENCE int = 0
)
as begin
                set nocount on;

        declare @CURRENTDATE datetime;

        set @CURRENTDATE = getdate();
                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            if @TITLECODEID = '00000000-0000-0000-0000-000000000000'
              set @TITLECODEID = null;
            if @SUFFIXCODEID = '00000000-0000-0000-0000-000000000000'
              set @SUFFIXCODEID = null;
            if @MARITALSTATUSCODEID = '00000000-0000-0000-0000-000000000000'
              set @MARITALSTATUSCODEID = null;

        set @ID = newid();

        insert into dbo.WPBIOGRAPHICALHHMEMBER (
          ID, 
          WPBIOGRAPHICALDEMOGRAPHICID,
          FULLNAME,
          FIRSTNAME, 
          MIDDLENAME, 
          LASTNAME, 
          SUFFIXCODEID,
          TITLECODEID,
          BIRTHDATE, 
          MARITALSTATUSCODEID, 
          OCCUPATION, 
          ADDEDBYID, 
          CHANGEDBYID, 
          DATEADDED, 
          DATECHANGED,
          SEQUENCE)
        VALUES (
          @ID, 
          @WPBIOGRAPHICALDEMOGRAPHICID,
          @FULLNAME,
          @FIRSTNAME, 
          @MIDDLENAME, 
          @LASTNAME, 
          @SUFFIXCODEID, 
          @TITLECODEID,
          @BIRTHDATE, 
          @MARITALSTATUSCODEID, 
          @OCCUPATION, 
          @CHANGEAGENTID, 
          @CHANGEAGENTID,
          @CURRENTDATE, 
          @CURRENTDATE,
          @SEQUENCE)
end