USP_DATAFORMTEMPLATE_VIEW_PHONEDATAREVIEWAUDIT

The load procedure used by the view dataform template "Phone Data Review Audit 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.
@AUDITTYPECODE	tinyint	INOUT	AUDITTYPECODE
@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_PHONEDATAREVIEWAUDIT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @AUDITTYPECODE tinyint = null 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 = PHONEAUDIT.NUMBER,
        @PRIMARY = PHONEAUDIT.ISPRIMARY,
        @DONOTCALL = PHONEAUDIT.DONOTCALL,
        @STARTTIME = PHONEAUDIT.STARTTIME,
        @ENDTIME = PHONEAUDIT.ENDTIME,
        @STARTDATE = PHONEAUDIT.STARTDATE,
        @ENDDATE = PHONEAUDIT.ENDDATE,
        @SEASONALSTARTDATE = PHONEAUDIT.SEASONALSTARTDATE,
        @SEASONALENDDATE = PHONEAUDIT.SEASONALENDDATE,
        @DONOTTEXT = PHONEAUDIT.DONOTTEXT
    from dbo.PHONEAUDIT
    left join dbo.PHONETYPECODE on PHONETYPECODE.ID = PHONEAUDIT.PHONETYPECODEID
    where PHONEAUDIT.AUDITKEY = @ID
    and PHONEAUDIT.AUDITTYPECODE = 1;

    select 
        @DATALOADED = 1,
        @BEFORE_PHONETYPE = PHONETYPECODE.DESCRIPTION,
        @BEFORE_NUMBER = PHONEAUDIT.NUMBER,
        @BEFORE_PRIMARY = PHONEAUDIT.ISPRIMARY,
        @BEFORE_DONOTCALL = PHONEAUDIT.DONOTCALL,
        @BEFORE_STARTTIME = PHONEAUDIT.STARTTIME,
        @BEFORE_ENDTIME = PHONEAUDIT.ENDTIME,
        @BEFORE_STARTDATE = PHONEAUDIT.STARTDATE,
        @BEFORE_ENDDATE = PHONEAUDIT.ENDDATE,
        @BEFORE_SEASONALSTARTDATE = PHONEAUDIT.SEASONALSTARTDATE,
        @BEFORE_SEASONALENDDATE = PHONEAUDIT.SEASONALENDDATE,
        @AUDITTYPECODE = PHONEAUDIT.AUDITTYPECODE,
        @BEFORE_DONOTTEXT = PHONEAUDIT.DONOTTEXT
    from PHONEAUDIT
    left join dbo.PHONETYPECODE on PHONETYPECODE.ID = PHONEAUDIT.PHONETYPECODEID
    where PHONEAUDIT.AUDITKEY = @ID
    and PHONEAUDIT.AUDITTYPECODE in (0, 2);

    return 0;