USP_DATAFORMTEMPLATE_ADD_CHARGEINDIVIDUAL_PRELOAD

The load procedure used by the edit dataform template "Charge Add to Individual Form"

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHARGEDATE	date	INOUT	Charge date
@DUEDATE	date	INOUT	Due date
@POSTDATE	date	INOUT	Post date
@LOADEDINDIVIDUALNAME	nvarchar(200)	INOUT	Name

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CHARGEINDIVIDUAL_PRELOAD 
                (
                    @STUDENTID uniqueidentifier,
                    @CHARGEDATE date = null output,
                    @DUEDATE date = null output,
                    @POSTDATE date = null output,
                    @LOADEDINDIVIDUALNAME nvarchar(200) = null output
                ) as
                    set nocount on;

                    select @CHARGEDATE = getdate(),
                            @DUEDATE = dbo.UFN_CHARGE_GETDEFAULTDUEDATE(@CHARGEDATE),
                            @POSTDATE = @CHARGEDATE,
                            @LOADEDINDIVIDUALNAME = CONSTITUENT.NAME
                    from dbo.CONSTITUENT
                    where CONSTITUENT.ID = @STUDENTID;

                    return 0;