USP_DATAFORMTEMPLATE_VIEW_WEALTHPOINTACCOUNTSTATUS

                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WEALTHPOINTACCOUNTSTATUS
                    (
                    @DATALOADED bit = 0 output,
                    @WEALTHPOINTREGISTERED bit = null output,
                    @WEALTHPOINTACCOUNTTYPECODE integer = null output
                    )
                as
                begin
                    set nocount on

                    set @DATALOADED = 1;

                    --Get WealthPoint Account Information
                    select top 1
                        @WEALTHPOINTREGISTERED = REGISTERED,
                        @WEALTHPOINTACCOUNTTYPECODE = ACCOUNTTYPECODE
                    from
                        dbo.WEALTHPOINTCONFIGURATION

                    return 0
                end