Back to OIM Explorer

dbo.TSB_FGIUserInGroupValid_OVR_Ke

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 2.670 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.TSB_FGIUserInGroupValid source text reference
  • references source dbo.TSB_FGIUserInGroupValid_OVR source text reference

References

Referenced By

Complete Source

SQL142 lines
1CREATE FUNCTION dbo.TSB_FGIUserInGroupValid_OVR_Ke(2  @P_isinactive BIT,3  @P_IsTemporaryDeactivated BIT,4  @P_XMarkedForDeletion int,5  @R_PFDInheriteGroup BIT,6  @R_PTDInheriteGroup BIT,7  @R_PMDInheriteGroup BIT,8  @IsDirectAssignment BIT,9  @P_IsSecurityIncident BIT,10  @R_PSIInheriteGroup BIT,11  @A_IsAccountDisabled BIT,12  @R_ADAInheriteGroup BIT,13  @OVR_PFD int,14  @OVR_PTD int,15  @OVR_PSI int,16  @OVR_PMD int,17  @OVR_ADA int,18  @PMDKeepMembershipsOfLinkedAccount varchar(16)19) RETURNS int20  WITH SCHEMABINDING21AS22BEGIN23  DECLARE @erg_PFD int24  DECLARE @erg_PTD int25  DECLARE @erg_PMD int26  DECLARE @erg_PSI int27  DECLARE @erg_ADA int28  DECLARE @erg int29  DECLARE @QBM_BitPatternXMarkedForDel_Delay int = 0x0130  IF @R_PFDInheriteGroup IS NULL AND @R_PTDInheriteGroup IS NULL AND @R_PMDInheriteGroup IS NULL AND @R_PSIInheriteGroup IS NULL AND @R_ADAInheriteGroup31  IS NULL AND isnull(@P_XMarkedForDeletion,32  0) & @QBM_BitPatternXMarkedForDel_Delay = 0 AND @OVR_PFD IS NULL AND @OVR_PMD IS NULL AND @OVR_PSI IS NULL AND @OVR_PTD IS NULL33  BEGIN34    SELECT @erg = 135    GOTO endLabel36  END37  IF(isnull(@P_IsInActive, 0) = 0)38  BEGIN39    SELECT @erg_PFD = 140  END41  ELSE42  BEGIN43    SELECT @erg_PFD = CASE44    WHEN @OVR_PFD = 1 THEN45    146    WHEN @OVR_PFD = -1 THEN47    048    WHEN @OVR_PFD = 0 AND @R_PFDInheriteGroup IS NULL THEN49    150    ELSE isnull(@R_PFDInheriteGroup,51    0)52    END53  END54  IF(isnull(@P_IsTemporaryDeactivated, 0) = 0)55  BEGIN56    SELECT @erg_PTD = 157  END58  ELSE59  BEGIN60    SELECT @erg_PTD = CASE61    WHEN @OVR_PTD = 1 THEN62    163    WHEN @OVR_PTD = -1 THEN64    065    WHEN @OVR_PTD = 0 AND @R_PTDInheriteGroup IS NULL THEN66    167    ELSE isnull(@R_PTDInheriteGroup,68    0)69    END70  END71  IF isnull(@P_XMarkedForDeletion,72  0) & @QBM_BitPatternXMarkedForDel_Delay = 073  BEGIN74    SELECT @erg_PMD = 175  END76  ELSE77  BEGIN78    SELECT @erg_PMD = CASE @OVR_PMD79    WHEN 1 THEN80    181    WHEN -1 THEN82    083    ELSE CASE @R_PMDInheriteGroup84    WHEN 1 THEN85    186    WHEN 0 THEN87    088    ELSE CASE89    WHEN @PMDKeepMembershipsOfLinkedAccount = 'ALL' THEN90    191    WHEN @PMDKeepMembershipsOfLinkedAccount = 'DIRECT' AND @IsDirectAssignment = 1 THEN92    193    ELSE 094    END95    END96    END97  END98  IF(isnull(@P_IsSecurityIncident, 0) = 0)99  BEGIN100    SELECT @erg_PSI = 1101  END102  ELSE103  BEGIN104    SELECT @erg_PSI = CASE105    WHEN @OVR_PSI = 1 THEN106    1107    WHEN @OVR_PSI = -1 THEN108    0109    WHEN @OVR_PSI = 0 AND @R_PSIInheriteGroup IS NULL THEN110    1111    ELSE isnull(@R_PSIInheriteGroup,112    0)113    END114  END115  IF(isnull(@A_IsAccountDisabled, 0) = 0)116  BEGIN117    SELECT @erg_ADA = 1118  END119  ELSE120  BEGIN121    SELECT @erg_ADA = CASE122    WHEN @OVR_ADA = 1 THEN123    1124    WHEN @OVR_ADA = -1 THEN125    0126    WHEN @OVR_ADA = 0 AND @R_ADAInheriteGroup IS NULL THEN127    1128    ELSE isnull(@R_ADAInheriteGroup,129    0)130    END131  END132  IF @erg_PFD + @erg_PTD + @erg_PMD + @erg_PSI + @erg_ADA = 5133  BEGIN134    SELECT @erg = 1135  END136  ELSE137  BEGIN138    SELECT @erg = 0139  END140  endLabel:141  RETURN(@erg)142END
Open raw exported source
SQL ยท Raw19 lines
1   create   function dbo.TSB_FGIUserInGroupValid_OVR_Ke  ( @P_isinactive bit , @P_IsTemporaryDeactivated bit, @P_XMarkedForDeletion int, @R_PFDInheriteGroup2 bit, @R_PTDInheriteGroup bit, @R_PMDInheriteGroup bit, @IsDirectAssignment bit, @P_IsSecurityIncident bit, @R_PSIInheriteGroup bit, @A_IsAccountDisabled3 bit, @R_ADAInheriteGroup bit  , @OVR_PFD int , @OVR_PTD int , @OVR_PSI int , @OVR_PMD int , @OVR_ADA int  , @PMDKeepMembershipsOfLinkedAccount varchar4(16) ) returns int with SCHEMABINDING as begin declare @erg_PFD int declare @erg_PTD int declare @erg_PMD int declare @erg_PSI int declare @erg_ADA int5 declare @erg int declare @QBM_BitPatternXMarkedForDel_Delay int = 0x01   if @R_PFDInheriteGroup is null and @R_PTDInheriteGroup is null and @R_PMDInheriteGroup6 is null and @R_PSIInheriteGroup is null and @R_ADAInheriteGroup is null  and isnull(@P_XMarkedForDeletion,0) & @QBM_BitPatternXMarkedForDel_Delay = 0 7 and @OVR_PFD is null and @OVR_PMD is null and @OVR_PSI is null and @OVR_PTD is null begin select @erg = 1 goto endLabel end  if (isnull(@P_IsInActive,08) = 0 ) begin select @erg_PFD = 1 end else begin select @erg_PFD = case when @OVR_PFD = 1 then 1 when @OVR_PFD = -1 then 0 when @OVR_PFD = 0 and @R_PFDInheriteGroup9 is null then 1 else isnull(@R_PFDInheriteGroup,0) end end if (isnull(@P_IsTemporaryDeactivated,0) = 0 ) begin select @erg_PTD = 1 end else begin select10 @erg_PTD = case when @OVR_PTD = 1 then 1 when @OVR_PTD = -1 then 0 when @OVR_PTD = 0 and @R_PTDInheriteGroup is null then 1 else isnull(@R_PTDInheriteGroup11 ,0) end end if isnull(@P_XMarkedForDeletion, 0) & @QBM_BitPatternXMarkedForDel_Delay = 0 begin select @erg_PMD = 1 end else begin select @erg_PMD = case12 @OVR_PMD when 1 then 1 when -1 then 0 else  case @R_PMDInheriteGroup when 1 then 1 when 0 then 0 else  case when @PMDKeepMembershipsOfLinkedAccount = 13'ALL' then 1 when @PMDKeepMembershipsOfLinkedAccount = 'DIRECT' and @IsDirectAssignment = 1 then 1 else 0    end end end end if (isnull(@P_IsSecurityIncident14,0) = 0 ) begin select @erg_PSI = 1 end else begin select @erg_PSI = case when @OVR_PSI = 1 then 1 when @OVR_PSI = -1 then 0 when @OVR_PSI = 0 and @R_PSIInheriteGroup15 is null then 1 else isnull(@R_PSIInheriteGroup,0) end end  if (isnull(@A_IsAccountDisabled,0) = 0 ) begin select @erg_ADA = 1 end else begin select @erg_ADA16 = case when @OVR_ADA = 1 then 1 when @OVR_ADA = -1 then 0 when @OVR_ADA = 0 and @R_ADAInheriteGroup is null then 1 else isnull(@R_ADAInheriteGroup,0) 17end end  if @erg_PFD + @erg_PTD + @erg_PMD + @erg_PSI + @erg_ADA = 5 begin select @erg = 1 end else begin select @erg = 0 end endLabel: return(@erg) end18 19