dbo.QER_FTPersonInheritFromOrg_L
SQL_INLINE_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:20:36.050 · modified 2026-04-14T23:20:36.050 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@DBQueueCurrent | QBM_YDBQueueCurrent | 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_YDBQueueCurrent | TYPE |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1create function dbo.QER_FTPersonInheritFromOrg_L( @DBQueueCurrent dbo.QBM_YDBQueueCurrent readonly , @UID_BaseTreeAssignToUse varchar(38) ) returns table 2 with schemabinding as return( select po.UID_Person as UID_Person , po.UID_Org as UID_Org , pe.IsSecurityIncident as IsSecurityIncident from ( select hpo.UID_Person 3, hpo.UID_Org from @DBQueueCurrent p join dbo.HelperPersonOrg hpo on p.UID_Parameter = hpo.UID_Person union select pio.UID_Person, pio.UID_Org from @DBQueueCurrent 4 p join dbo.PersonInBaseTree pio on p.UID_Parameter = pio.UID_Person ) as po join dbo.Person pe on po.UID_Person = pe.UID_Person and pe.IsNoInherite = 50 join dbo.BaseTree b on po.UID_Org = b.UID_Org and b.IsNoInheriteToPerson = 0 join dbo.OrgRootAssign oa on oa.UID_OrgRoot = b.UID_OrgRoot and oa.IsAssignmentAllowed 6 = 1 and oa.UID_BaseTreeAssign = @UID_BaseTreeAssignToUse ) 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:20:36.050
None extracted.
Summary: reads/joins HelperPersonOrg, PersonInBaseTree, Person, BaseTree, OrgRootAssign
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@DBQueueCurrent | qbm_ydbqueuecurrent | 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: @DBQueueCurrent @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.QER_ZPersonHasQERAssign | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERResource | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERReuse | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERReuseUS | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.RMS_ZPersonHasESet | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.RPS_ZPersonHasRPSReport | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasTSBAccountDef | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERAssign | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERResource | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERReuse | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERReuseUS | source text reference | has TRY/CATCH error handling |
| dbo.RMS_ZPersonHasESet | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZPersonHasRPSReport | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasTSBAccountDef | source text reference | has TRY/CATCH error handling |