USP_DATAFORMTEMPLATE_VIEW_PROSPECTSFUNCTIONALAREAPAGEEXPRESSIONS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PROSPECTSFUNCTIONALAREAPAGEEXPRESSIONS
(
  @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @RE7SECURITYFEATURESGRANTED bit = null output,
    @RE7CONFIGUREDFORUSER bit = null output,
  @WEALTHPOINTREGISTERED bit = null output,
  @PROSPECTCONSTITUENCYNAME nvarchar(100) = null output
)
as
    set nocount on;

  set @RE7CONFIGUREDFORUSER = 0;

    if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or
        (dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID ,'c81183fd-78df-4ebf-8855-b3dcc0b0be33')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID ,'505760bd-3e81-4c4f-8f21-f59edfd5562d')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID ,'49675912-2d9a-415b-8f03-ccf9c564796d')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_DATALIST_IN_SYSTEMROLE(@CURRENTAPPUSERID,'ab0e06c4-dcea-414a-bf29-0b0758a3934b')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'8DABE43F-6848-40EB-8638-8E4B6311CE72')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'1A5D63F0-4DDD-4DD3-A4E6-FB1E9FE17FE2')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'41B32DCD-4CFE-4FAC-83DA-FA9A3F893B71')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'437cd7d8-e49c-4591-9574-572f5f15fd3a')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'E1560C48-F5E0-4E4E-B9EF-9EE4CCE644F4')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'08F40ECE-26B9-4e11-B53D-1FA5BAFC038A')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'33EE2022-238B-4400-81F5-F81F19C9F755')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'38B7BE1C-6F54-4951-94C5-EE53C688CBBA')=1 and
         dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'2dbf2cc3-958c-4454-b169-7eb1e656044e')=1 )
        set @RE7SECURITYFEATURESGRANTED = 1;
    else
        set @RE7SECURITYFEATURESGRANTED = 0;    

  select top 1 @RE7CONFIGUREDFORUSER = 1
  from dbo.RE7INTEGRATIONCREDENTIALS
  where ID = @CURRENTAPPUSERID;


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

  --Get the display name for major giving prospect
  declare @PROSPECTCONSTITUENCYID uniqueidentifier = '00E748FB-940D-4A7D-A133-C148B29410A8'

  select
      @PROSPECTCONSTITUENCYNAME = DESCRIPTION
  from dbo.CONSTITUENCYSYSTEMNAME
  where ID = @PROSPECTCONSTITUENCYID

  if @PROSPECTCONSTITUENCYNAME is null
      select
        @PROSPECTCONSTITUENCYNAME = DESCRIPTION
      from dbo.CONSTITUENCYCODE
      where ID = @PROSPECTCONSTITUENCYID

  set @DATALOADED = 1;

    return 0;