USP_DATAFORMTEMPLATE_VIEW_PHONEDATAREVIEWNEW

The load procedure used by the view dataform template "Phone Data Review New 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.
@PHONETYPE	nvarchar(100)	INOUT	Type
@NUMBER	nvarchar(100)	INOUT	Number
@PRIMARY	bit	INOUT	Primary
@DONOTCALL	bit	INOUT	Do not call
@STARTTIME	UDT_HOURMINUTE	INOUT	Call before
@ENDTIME	UDT_HOURMINUTE	INOUT	Call after
@STARTDATE	date	INOUT	Start date
@ENDDATE	date	INOUT	End date
@BEFORE_PHONETYPE	nvarchar(100)	INOUT	Type
@BEFORE_NUMBER	nvarchar(100)	INOUT	Number
@BEFORE_PRIMARY	bit	INOUT	Primary
@BEFORE_DONOTCALL	bit	INOUT	Do not call
@BEFORE_STARTTIME	UDT_HOURMINUTE	INOUT	Call before
@BEFORE_ENDTIME	UDT_HOURMINUTE	INOUT	Call after
@BEFORE_STARTDATE	date	INOUT	Start date
@BEFORE_ENDDATE	date	INOUT	End date
@SEASONALSTARTDATE	UDT_MONTHDAY	INOUT	Seasonal start
@SEASONALENDDATE	UDT_MONTHDAY	INOUT	Seasonal end
@BEFORE_SEASONALSTARTDATE	UDT_MONTHDAY	INOUT	Seasonal start
@BEFORE_SEASONALENDDATE	UDT_MONTHDAY	INOUT	Seasonal end
@DONOTTEXT	bit	INOUT
@BEFORE_DONOTTEXT	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PHONEDATAREVIEWNEW
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @PHONETYPE nvarchar(100) = null output,
    @NUMBER nvarchar(100) = null output,
    @PRIMARY bit = null output,
    @DONOTCALL bit = null output,
    @STARTTIME dbo.UDT_HOURMINUTE = null output,
    @ENDTIME dbo.UDT_HOURMINUTE = null output,
    @STARTDATE date = null output,
    @ENDDATE date = null output,
    @BEFORE_PHONETYPE nvarchar(100) = null output,
    @BEFORE_NUMBER nvarchar(100) = null output,
    @BEFORE_PRIMARY bit = null output,
    @BEFORE_DONOTCALL bit = null output,
    @BEFORE_STARTTIME dbo.UDT_HOURMINUTE = null output,
    @BEFORE_ENDTIME dbo.UDT_HOURMINUTE = null output,
    @BEFORE_STARTDATE date = null output,
    @BEFORE_ENDDATE date = null output,
    @SEASONALSTARTDATE dbo.UDT_MONTHDAY = null output,
    @SEASONALENDDATE dbo.UDT_MONTHDAY = null output,
    @BEFORE_SEASONALSTARTDATE dbo.UDT_MONTHDAY = null output,
    @BEFORE_SEASONALENDDATE dbo.UDT_MONTHDAY = null output,
    @DONOTTEXT bit = null output,
    @BEFORE_DONOTTEXT bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @PHONETYPE = PHONETYPECODE.DESCRIPTION,
        @NUMBER = PHONE.NUMBER,
        @PRIMARY = PHONE.ISPRIMARY,
        @DONOTCALL = PHONE.DONOTCALL,
        @STARTTIME = PHONE.STARTTIME,
        @ENDTIME = PHONE.ENDTIME,
        @STARTDATE = PHONE.STARTDATE,
        @ENDDATE = PHONE.ENDDATE,
        @SEASONALSTARTDATE = PHONE.SEASONALSTARTDATE,
        @SEASONALENDDATE = PHONE.SEASONALENDDATE,
        @DONOTTEXT = PHONE.DONOTTEXT
    from dbo.PHONE
    left join dbo.PHONETYPECODE on PHONETYPECODE.ID = PHONE.PHONETYPECODEID
    where PHONE.ID = @ID;

    return 0;