dbo.CPL_FTComplianceSubRulePersonR

SQL_INLINE_TABLE_VALUED_FUNCTION

Created 2026-04-14T23:18:41.603 · modified 2026-04-14T23:18:41.603 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@UID_ComplianceRule`	varchar	no
`@PersonsPossible`	QBM_YParameterList	no

Referenced objects

Schema	Object	Class
	QBM_YParameterList	TYPE
dbo	ComplianceRule	OBJECT_OR_COLUMN
dbo	ComplianceSubRulePerson	OBJECT_OR_COLUMN

Source excerpt

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

Open full formatted source

1create function dbo.CPL_FTComplianceSubRulePersonR (@UID_ComplianceRule varchar(38) , @PersonsPossible QBM_YParameterList readonly  ) returns table as 
2return(  select csp.UID_Person from dbo.ComplianceSubRulePerson csp join dbo.ComplianceRule r on csp.UID_ComplianceRule = r.UID_ComplianceRule join @PersonsPossible
3 pp on csp.UID_Person = pp.Parameter1 where r.UID_ComplianceRule = @UID_ComplianceRule and r.IsPersonStoreInverted = 0  and r.IsInActive = 0 and r.IsWorkingCopy
4 = 0  union all  select p.Parameter1 as UID_Person from @PersonsPossible p cross join dbo.ComplianceRule r left outer join dbo.ComplianceSubRulePerson 
5csp on p.Parameter1 = csp.UID_Person and csp.UID_ComplianceRule = r.UID_ComplianceRule where csp.UID_Person is null and r.UID_ComplianceRule = @UID_ComplianceRule
6 and r.IsPersonStoreInverted = 1  and r.IsInActive = 0 and r.IsWorkingCopy = 0  ) 
7

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:18:41.603

None extracted.

Summary: reads/joins ComplianceSubRulePerson, ComplianceRule

Declared parameters

Parameter	Type	Direction
`@UID_ComplianceRule`	`varchar(38)`	input
`@PersonsPossible`	`qbm_yparameterlist`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_ComplianceRule @PersonsPossible

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.

No reverse dependencies extracted.