dbo.QER_FGIPWODecisionPossible
SQL_SCALAR_FUNCTION
Created 2025-06-27T17:59:27.140 · modified 2026-04-14T23:17:27.567 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| int | yes |
@UID_personWantsOrg | varchar | no |
@LevelNumber | int | no |
@SubLevelNumber | int | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | PWOHelperPWO | OBJECT_OR_COLUMN | |
| dbo | PWOHelperPWO | UID_PersonWantsOrg | OBJECT_OR_COLUMN |
| dbo | PWOHelperPWO | LevelNumber | OBJECT_OR_COLUMN |
| dbo | PWOHelperPWO | SubLevelNumber | OBJECT_OR_COLUMN |
| dbo | PWOHelperPWO | Decision | OBJECT_OR_COLUMN |
| dbo | PWOHelperPWO | RulerLevel | OBJECT_OR_COLUMN |
| dbo | PWOHelperPWO | UID_QERWorkingStep | OBJECT_OR_COLUMN |
| dbo | QERWorkingStep | OBJECT_OR_COLUMN | |
| dbo | QERWorkingStep | UID_QERWorkingStep | OBJECT_OR_COLUMN |
| dbo | QERWorkingStep | CountApprover | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create function dbo.QER_FGIPWODecisionPossible(@UID_personWantsOrg varchar(38) , @LevelNumber int , @SubLevelNumber int ) returns int with 2 schemabinding as begin declare @erg int select top 1 @erg = case MIN(w.LevelResult) when 1 then 0 when 0 then 1 else -1 end from ( select case when 3 z.CountDeciderAvailable < z.CountDeciderMinimum then -1 when z.CountDecided >= z.CountDeciderMinimum OR z.IsDenied = 1 then 1 when z.CountDeciderAvailable 4 >= z.CountDeciderMinimum and z.CountDecided < z.CountDeciderMinimum and z.IsDenied = 0 then 0 else -1 end as LevelResult , z.IsDenied from ( select 5case when y.RulerLevel > 0 then 1 when y.CountDeciderMinimum = -1 then case when y.CountDeciderAvailable < 1 then 1 else y.CountDeciderAvailable end else 6 y.CountDeciderMinimum end as CountDeciderMinimum , y.CountDecided , y.CountDeciderAvailable , y.IsDenied from ( select x.uid_personwantsorg, x.levelnumber 7, x.sublevelnumber, x.uid_QERWorkingStep , isnull(x.CountApprover, 1) as CountDeciderMinimum , isnull(SUM (x.isDecided), 0) as CountDecided , isnull(COUNT 8(*), 0) as CountDeciderAvailable , isnull(MIN(x.RulerLevel),0) as RulerLevel , ISNULL(max(x.IsDenied), 0) as IsDenied from ( select h1.uid_personwantsorg 9, h1.levelnumber, h1.sublevelnumber, s.uid_QERWorkingStep , case s.CountApprover when null then 1 when 0 then 1 else s.CountApprover end as CountApprover 10 , case when isnull(h1.decision, '') in('P', 'N', 'R', '+') then 1 else 0 end as IsDecided , h1.RulerLevel , case when isnull(h1.decision, '') in('N') 11then 1 else 0 end as IsDenied from dbo.PWOHelperPWO h1 join dbo.QERWorkingStep s on h1.uid_QERWorkingStep = s.uid_QERWorkingStep where h1.uid_personwantsorg 12 = @UID_personWantsOrg and h1.levelnumber = @LevelNumber and h1.sublevelnumber = case when @SubLevelNumber IS null then h1.SubLevelNumber else @SubLevelNumber 13 end ) as x group by x.uid_personwantsorg, x.levelnumber, x.sublevelnumber, x.UID_QERWorkingStep, x.CountApprover ) as y ) as z ) as w endLabel: return 14(@erg) end 15
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:17:27.567
None extracted.
Summary: reads/joins PWOHelperPWO, QERWorkingStep
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| int | OUTPUT |
@UID_personWantsOrg | varchar(38) | input |
@LevelNumber | int | input |
@SubLevelNumber | int | 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_personWantsOrg @LevelNumber @SubLevelNumber @erg
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_ZITShopCheckDecision | SQL expression dependency | dbo · OBJECT_OR_COLUMN |