USP_DATAFORMTEMPLATE_ADD_FEPPROCESS_PRELOAD

The load procedure used by the edit dataform template "FEP Process Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site required
@ORGANIZATIONNAME	nvarchar(50)	INOUT	Organization name
@COUNTRYID	uniqueidentifier	INOUT	Country
@POSTCODE	nvarchar(12)	INOUT	ZIP Code
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FEPPROCESS_PRELOAD
(
    @CURRENTAPPUSERID uniqueidentifier,
    @SITEREQUIRED bit = null output,
    @ORGANIZATIONNAME nvarchar(50) = null output,
    @COUNTRYID uniqueidentifier = null output,
    @POSTCODE nvarchar(12) = null output,
    @SITEID uniqueidentifier = null output
)
as
    set nocount on;

    select @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
    set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

    select
        @ORGANIZATIONNAME = left(NAME, 50),
        @POSTCODE = POSTCODE,
        @COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT()
    from dbo.ORGANIZATIONINFORMATION

    if len(@ORGANIZATIONNAME) = 0
        select
            @ORGANIZATIONNAME = INSTALLATIONNAME        
        from dbo.INSTALLATIONINFO

    return 0;