USP_DATAFORMTEMPLATE_VIEW_CHARITYCLAIMREFERENCENUMBERNOSITE

The load procedure used by the view dataform template "Charity Claim Reference Number No Site View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CCRNID	uniqueidentifier	INOUT	ID
@REFERENCENUMBER	nvarchar(20)	INOUT	Reference number
@DESCRIPTION	nvarchar(50)	INOUT	Description
@CLASSIFICATION	nvarchar(7)	INOUT	Classification
@WAITINGPERIOD	smallint	INOUT	Days to wait after confirmation letter sent

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CHARITYCLAIMREFERENCENUMBERNOSITE
(
    @DATALOADED bit = 0 output,
    @CCRNID uniqueidentifier = null output,
    @REFERENCENUMBER nvarchar(20) = null output,
    @DESCRIPTION nvarchar(50) = null output,
    @CLASSIFICATION nvarchar(7) = null output,
    @WAITINGPERIOD smallint = null output
)
as
    set nocount on;


    select 
        @CCRNID = CHARITYCLAIMREFERENCENUMBER.ID,
        @REFERENCENUMBER = CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER,
        @DESCRIPTION = CHARITYCLAIMREFERENCENUMBER.DESCRIPTION,
        @CLASSIFICATION = CHARITYCLAIMREFERENCENUMBER.CLASSIFICATION,
        @WAITINGPERIOD = CHARITYCLAIMREFERENCENUMBER.WAITINGPERIOD
    from 
        CHARITYCLAIMREFERENCENUMBER
    left join
        CHARITYCLAIMREFERENCENUMBERSITE on CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBER.ID
    -- There should only be one ccrn without a site.

    where
        CHARITYCLAIMREFERENCENUMBERSITE.ID is null

    -- The record may not exist yet, but that's ok.

    set @DATALOADED = 1;

    return 0;