USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITPHONENUMBERDATA

The load procedure used by the view dataform template "NetCommunity Constituent Phone Number Data View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PHONENUMBER	nvarchar(100)	INOUT	Phone number
@PHONETYPECODE	nvarchar(200)	INOUT	Phone type code
@ISPRIMARY	bit	INOUT	Is primary
@PHONESTARTDATE	date	INOUT	Start date
@PHONEENDDATE	date	INOUT	End Date
@PHONEDONOTCALL	bit	INOUT	Do not call

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITPHONENUMBERDATA
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @PHONENUMBER nvarchar(100) = null output,
    @PHONETYPECODE nvarchar(200) = null output,
    @ISPRIMARY bit = null output,
    @PHONESTARTDATE date = null output,
    @PHONEENDDATE date = null output,
    @PHONEDONOTCALL bit = null output
)
as
    set nocount on;
    set @DATALOADED = 0;        

    select
        @DATALOADED = 1,
        @PHONENUMBER = NUMBER,
        @PHONETYPECODE = dbo.UFN_PHONETYPECODE_GETDESCRIPTION(PHONETYPECODEID),
        @ISPRIMARY = ISPRIMARY,
        @PHONESTARTDATE = STARTDATE,
        @PHONEENDDATE = ENDDATE,
        @PHONEDONOTCALL = DONOTCALL
    from dbo.PHONE
    where ID = @ID;

    return 0;