USP_DATAFORMTEMPLATE_VIEW_PROGRAMPAGEDATA

The load procedure used by the view dataform template "Program Page Data Parameters"

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.
@NAME	nvarchar(100)	INOUT	NAME
@DESCRIPTION	nvarchar(500)	INOUT	DESCRIPTION
@ISACTIVE	bit	INOUT	ISACTIVE
@ISDAILYADMISSION	bit	INOUT	ISDAILYADMISSION
@HASCONFLICTS	bit	INOUT	HASCONFLICTS
@HASGLMAPPING	bit	INOUT	HASGLMAPPING
@ISPREREGISTERED	bit	INOUT	ISPREREGISTERED

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PROGRAMPAGEDATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(500) = null output,
                    @ISACTIVE bit = null output,
                    @ISDAILYADMISSION bit = null output,
                    @HASCONFLICTS bit = null output,
                    @HASGLMAPPING bit = null output,
                    @ISPREREGISTERED bit = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select @DATALOADED = 1,
                        @NAME = NAME,
                        @DESCRIPTION = DESCRIPTION,
                        @ISACTIVE = ISACTIVE,
                        @ISDAILYADMISSION = ISDAILYADMISSION,
                        @HASCONFLICTS=dbo.UFN_PROGRAM_HASCONFLICTS(@ID),
                        @ISPREREGISTERED = ISPREREGISTERED
                    from dbo.PROGRAM
                    where ID = @ID;


                    --if exists(select ID from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = '4AB6C85F-1395-4C4F-B49A-03D1C6EFBE9E')

                    --    set @HASGLMAPPING = 1


                    if (select count(ID) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = '4AB6C85F-1395-4C4F-B49A-03D1C6EFBE9E') = 1 
                        set @HASGLMAPPING = 1


                return 0;