dbo.ATT_FGIATTDecisionPossible
SQL_SCALAR_FUNCTION
Created 2025-06-27T17:59:42.273 · modified 2026-04-14T23:18:05.797 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| int | yes |
@UID_AttestationCase | varchar | no |
@LevelNumber | int | no |
@SubLevelNumber | int | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | AttestationHelper | OBJECT_OR_COLUMN | |
| dbo | AttestationHelper | UID_AttestationCase | OBJECT_OR_COLUMN |
| dbo | AttestationHelper | LevelNumber | OBJECT_OR_COLUMN |
| dbo | AttestationHelper | SubLevelNumber | OBJECT_OR_COLUMN |
| dbo | AttestationHelper | Decision | OBJECT_OR_COLUMN |
| dbo | AttestationHelper | RulerLevel | OBJECT_OR_COLUMN |
| dbo | AttestationHelper | 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.ATT_FGIATTDecisionPossible(@UID_AttestationCase 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_AttestationCase, 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_AttestationCase 9, h1.levelnumber, h1.sublevelnumber, ws.uid_QERWorkingStep , case ws.CountApprover when null then 1 when 0 then 1 else ws.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.AttestationHelper h1 join dbo.QERWorkingStep ws on h1.uid_QERWorkingStep = ws.uid_QERWorkingStep where h1.UID_AttestationCase 12 = @UID_AttestationCase 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_AttestationCase, x.levelnumber, x.sublevelnumber, x.uid_QERWorkingStep, x.CountApprover ) as y ) as z ) as w option (recompile 14) endLabel: return(@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:18:05.797
None extracted.
Summary: reads/joins AttestationHelper, QERWorkingStep
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| int | OUTPUT |
@UID_AttestationCase | 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_AttestationCase @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.ATT_ZAttestationReminder | SQL expression dependency | dbo · OBJECT_OR_COLUMN |