dbo.QER_FTAccountInheritFromOrg_L
SQL_INLINE_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:20:36.067 · modified 2026-04-14T23:20:36.067 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@PersonList | QBM_YSingleGUID | no |
@UID_BaseTreeAssignToUse | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | BaseTree | OBJECT_OR_COLUMN | |
| dbo | BaseTree | UID_Org | OBJECT_OR_COLUMN |
| dbo | BaseTree | UID_OrgRoot | OBJECT_OR_COLUMN |
| dbo | BaseTree | IsNoInheriteToPerson | OBJECT_OR_COLUMN |
| dbo | HelperPersonOrg | OBJECT_OR_COLUMN | |
| dbo | HelperPersonOrg | UID_Person | OBJECT_OR_COLUMN |
| dbo | HelperPersonOrg | UID_Org | OBJECT_OR_COLUMN |
| dbo | OrgRootAssign | OBJECT_OR_COLUMN | |
| dbo | OrgRootAssign | UID_OrgRoot | OBJECT_OR_COLUMN |
| dbo | OrgRootAssign | UID_BaseTreeAssign | OBJECT_OR_COLUMN |
| dbo | OrgRootAssign | IsAssignmentAllowed | OBJECT_OR_COLUMN |
| dbo | Person | OBJECT_OR_COLUMN | |
| dbo | Person | UID_Person | OBJECT_OR_COLUMN |
| dbo | Person | IsSecurityIncident | OBJECT_OR_COLUMN |
| dbo | Person | IsNoInherite | OBJECT_OR_COLUMN |
| dbo | PersonInBaseTree | OBJECT_OR_COLUMN | |
| dbo | PersonInBaseTree | UID_Person | OBJECT_OR_COLUMN |
| dbo | PersonInBaseTree | UID_Org | OBJECT_OR_COLUMN |
| dbo | QBM_YSingleGUID | TYPE |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1create function dbo.QER_FTAccountInheritFromOrg_L( @PersonList dbo.QBM_YSingleGUID readonly , @UID_BaseTreeAssignToUse varchar(38) ) returns table with 2 schemabinding as return( select po.UID_Person as UID_Person , po.UID_Org as UID_Org , po.IsSecurityIncident as IsSecurityIncident from ( select hpo.UID_Person 3, hpo.UID_Org, p.IsSecurityIncident from @PersonList l join dbo.Person p on l.UID_SingleGuid = p.UID_Person and p.IsNoInherite = 0 join dbo.HelperPersonOrg 4 hpo on p.UID_Person = hpo.UID_Person union select hpo.UID_Person, hpo.UID_Org, p.IsSecurityIncident from @PersonList l join dbo.Person p on l.UID_SingleGuid 5 = p.UID_Person and p.IsNoInherite = 0 join dbo.PersonInBaseTree hpo on p.UID_Person = hpo.UID_Person ) as po join dbo.BaseTree b on po.UID_Org = b.UID_Org 6 and b.IsNoInheriteToPerson = 0 join dbo.OrgRootAssign oa on oa.UID_OrgRoot = b.UID_OrgRoot and oa.IsAssignmentAllowed = 1 and oa.UID_BaseTreeAssign = 7@UID_BaseTreeAssignToUse ) 8
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:36.067
None extracted.
Summary: reads/joins Person, HelperPersonOrg, PersonInBaseTree, BaseTree, OrgRootAssign
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@PersonList | qbm_ysingleguid | input |
@UID_BaseTreeAssignToUse | varchar(38) | 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: @PersonList @UID_BaseTreeAssignToUse
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.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 |
| dbo.ADS_ZAccountInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZContactInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZAccountInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | source text reference | has TRY/CATCH error handling |