dbo.QER_FTOrgRulerHighest
SQL_INLINE_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:20:36.120 · modified 2026-04-14T23:20:36.120 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@uid_org | varchar | no |
@uid_personinserted | varchar | no |
@uid_personordered | varchar | no |
@WithFallBackRoot | bit | no |
@UseRulerContainerIT | int | no |
@IgnoreNoDecideForPerson | bit | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| BaseTree | OBJECT_OR_COLUMN | ||
| BaseTreeCollection | OBJECT_OR_COLUMN | ||
| OrgRoot | OBJECT_OR_COLUMN | ||
| PersonInBaseTree | OBJECT_OR_COLUMN | ||
| PersonWantsOrg | OBJECT_OR_COLUMN | ||
| QER_VPersonsAreMe | OBJECT_OR_COLUMN | ||
| dbo | QBM_FGIConfigparmValue | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1create function dbo.QER_FTOrgRulerHighest (@uid_org varchar(38) , @uid_personinserted varchar(38) , @uid_personordered varchar(38) , @WithFallBackRoot 2 bit , @UseRulerContainerIT int , @IgnoreNoDecideForPerson bit ) returns table as return ( select pib.UID_Org, pib.UID_Person, pwo.UID_PersonWantsOrg 3 as UID_PWORulerOrigin from ( select top 1 z.UID_Org from (select b.treelevel + 1 as treelevel, case @UseRulerContainerIT when 1 then b.UID_RulerContainerIT 4 when -1 then b.UID_Org else b.UID_RulerContainer end as UID_Org from BaseTreeCollection co join BaseTree b on co.UID_Org = @uid_org and co.UID_ParentOrg 5 = b.UID_Org union all select 0, r.UID_OrgAttestator as uid_org from OrgRoot r join BaseTree b on b.UID_OrgRoot = r.UID_OrgRoot and b.UID_Org = @uid_org 6 where @WithFallBackRoot = 1 ) as z join PersonInBaseTree pio on z.UID_Org = pio.UID_Org and pio.XOrigin > 0 left outer join QER_VPersonsAreMe api on pio.UID_Person 7 = api.UID_PersonAlsoMe and api.UID_PersonOrigin = case when @uid_personinserted > ' ' and @IgnoreNoDecideForPerson = 0 and dbo.QBM_FGIConfigparmValue( 8'QER\ITShop\PersonInsertedNoDecide') = '1' then @uid_personinserted else null end left outer join QER_VPersonsAreMe apo on pio.UID_Person = apo.UID_PersonAlsoMe 9 and apo.UID_PersonOrigin = case when @uid_personordered > ' ' and @IgnoreNoDecideForPerson = 0 and dbo.QBM_FGIConfigparmValue('QER\ITShop\PersonOrderedNoDecide' 10) = '1' then @uid_personordered else null end group by z.treelevel, z.UID_Org having min(isnull(api.UID_PersonAlsoMe, '') ) = '' and min(isnull(apo.UID_PersonAlsoMe 11, '') ) = '' order by z.treelevel desc ) as oo join PersonInBaseTree pib on oo.UID_Org = pib.UID_Org left outer join PersonWantsOrg pwo on pwo.ObjectKeyAssignment 12 = pib.XObjectKey and pib.XOrigin > 0 and pwo.OrderState in ('Assigned', 'OrderProlongate', 'OrderUnsubscribe' ) left outer join QER_VPersonsAreMe api 13on pib.UID_Person = api.UID_PersonAlsoMe and api.UID_PersonOrigin = case when @uid_personinserted > ' ' and @IgnoreNoDecideForPerson = 0 and dbo.QBM_FGIConfigparmValue 14('QER\ITShop\PersonInsertedNoDecide') = '1' then @uid_personinserted else null end left outer join QER_VPersonsAreMe apo on pib.UID_Person = apo.UID_PersonAlsoMe 15 and apo.UID_PersonOrigin = case when @uid_personordered > ' ' and @IgnoreNoDecideForPerson = 0 and dbo.QBM_FGIConfigparmValue('QER\ITShop\PersonOrderedNoDecide' 16) = '1' then @uid_personordered else null end where api.UID_PersonAlsoMe is null and apo.UID_PersonAlsoMe is null ) 17
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.120
None extracted.
Summary: reads/joins BaseTreeCollection, BaseTree, OrgRoot, PersonInBaseTree, QER_VPersonsAreMe…; uses config QER\ITShop\PersonInsertedNoDecide, QER\ITShop\PersonOrderedNoDecide
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@uid_org | varchar(38) | input |
@uid_personinserted | varchar(38) | input |
@uid_personordered | varchar(38) | input |
@WithFallBackRoot | bit | input |
@UseRulerContainerIT | int | input |
@IgnoreNoDecideForPerson | bit | input |
DML targets
None extracted.Called routines
None extracted.
Read/join references
SQL dependency metadata
Config/session
Config: QER\ITShop\PersonInsertedNoDecide QER\ITShop\PersonOrderedNoDecide
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @uid_org @uid_personinserted @uid_personordered @WithFallBackRoot @UseRulerContainerIT @IgnoreNoDecideForPerson
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.GEN_FT032C01FB0E597D2C49C9AA2B | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT1093A1F0406D5754E767A32A | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT34816235C513399D9EC4B5F8 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT474E0610FF6A5DEAACC51165 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT61E9B94DD675AEA640904E7A | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT6A2C0DF51691F8246FF36409 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT6BE605DBC013D4424FB2A91A | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT7D2F97BFC21ABB2179BCC834 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT875A2A9B553B575E8AD6791C | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT94D9103F05436CEA1C011366 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FT97DC0B0241148F62753FCDF5 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_FTF87E7DEA381CD3F5FFD8544F | SQL expression dependency | dbo · OBJECT_OR_COLUMN |