dbo.TSB_FGIUserInGroupValid_OVR_Ke

SQL_SCALAR_FUNCTION

Created 2025-06-27T18:01:20.663 · modified 2026-04-14T23:20:46.333 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	int	yes
`@P_isinactive`	bit	no
`@P_IsTemporaryDeactivated`	bit	no
`@P_XMarkedForDeletion`	int	no
`@R_PFDInheriteGroup`	bit	no
`@R_PTDInheriteGroup`	bit	no
`@R_PMDInheriteGroup`	bit	no
`@IsDirectAssignment`	bit	no
`@P_IsSecurityIncident`	bit	no
`@R_PSIInheriteGroup`	bit	no
`@A_IsAccountDisabled`	bit	no
`@R_ADAInheriteGroup`	bit	no
`@OVR_PFD`	int	no
`@OVR_PTD`	int	no
`@OVR_PSI`	int	no
`@OVR_PMD`	int	no
`@OVR_ADA`	int	no
`@PMDKeepMembershipsOfLinkedAccount`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
No SQL expression dependencies in snapshot.

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1   create   function dbo.TSB_FGIUserInGroupValid_OVR_Ke  ( @P_isinactive bit , @P_IsTemporaryDeactivated bit, @P_XMarkedForDeletion int, @R_PFDInheriteGroup
2 bit, @R_PTDInheriteGroup bit, @R_PMDInheriteGroup bit, @IsDirectAssignment bit, @P_IsSecurityIncident bit, @R_PSIInheriteGroup bit, @A_IsAccountDisabled
3 bit, @R_ADAInheriteGroup bit  , @OVR_PFD int , @OVR_PTD int , @OVR_PSI int , @OVR_PMD int , @OVR_ADA int  , @PMDKeepMembershipsOfLinkedAccount varchar
4(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 int
5 declare @erg int declare @QBM_BitPatternXMarkedForDel_Delay int = 0x01   if @R_PFDInheriteGroup is null and @R_PTDInheriteGroup is null and @R_PMDInheriteGroup
6 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,0
8) = 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_PFDInheriteGroup
9 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 select
10 @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_PTDInheriteGroup
11 ,0) end end if isnull(@P_XMarkedForDeletion, 0) & @QBM_BitPatternXMarkedForDel_Delay = 0 begin select @erg_PMD = 1 end else begin select @erg_PMD = case
12 @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_IsSecurityIncident
14,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_PSIInheriteGroup
15 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_ADA
16 = 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) end
18 
19

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:46.333

None extracted.

Summary: No calls/DML/dependency patterns extracted by the current parser.

Declared parameters

Parameter	Type	Direction
	`int`	OUTPUT
`@P_isinactive`	`bit`	input
`@P_IsTemporaryDeactivated`	`bit`	input
`@P_XMarkedForDeletion`	`int`	input
`@R_PFDInheriteGroup`	`bit`	input
`@R_PTDInheriteGroup`	`bit`	input
`@R_PMDInheriteGroup`	`bit`	input
`@IsDirectAssignment`	`bit`	input
`@P_IsSecurityIncident`	`bit`	input
`@R_PSIInheriteGroup`	`bit`	input
`@A_IsAccountDisabled`	`bit`	input
`@R_ADAInheriteGroup`	`bit`	input
`@OVR_PFD`	`int`	input
`@OVR_PTD`	`int`	input
`@OVR_PSI`	`int`	input
`@OVR_PMD`	`int`	input
`@OVR_ADA`	`int`	input
`@PMDKeepMembershipsOfLinkedAccount`	`varchar(16)`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

None extracted.

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @P_isinactive @P_IsTemporaryDeactivated @P_XMarkedForDeletion @R_PFDInheriteGroup @R_PTDInheriteGroup @R_PMDInheriteGroup @IsDirectAssignment @P_IsSecurityIncident @R_PSIInheriteGroup @A_IsAccountDisabled @R_ADAInheriteGroup @OVR_PFD @OVR_PTD @OVR_PSI @OVR_PMD @OVR_ADA @PMDKeepMembershipsOfLinkedAccount @erg_PFD @erg_PTD @erg_PMD @erg_PSI @erg_ADA @erg @QBM_BitPatternXMarkedForDel_Delay @P_IsInActive

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

Referencing object	Relation	Evidence
dbo.TSB_FGIUserInGroupValid	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_FGIUserInGroupValid_OVR	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZAccountInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZContactInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_ZAccountInLDAPGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB1_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB2_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB3_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN