dbo.ATT_FTAttNextDecisionMaker

SQL_TABLE_VALUED_FUNCTION

Created 2026-04-14T23:20:42.897 · modified 2026-04-14T23:20:42.897 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@uid_AttestationCase`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
	ATT_VAttDecisionPerson_I		OBJECT_OR_COLUMN
	AttestationCase		OBJECT_OR_COLUMN
	QER_YPWONextDecisionMaker		TYPE
	QERWorkingStep		OBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1create function dbo.ATT_FTAttNextDecisionMaker (@uid_AttestationCase varchar(38)) returns @erg table ( Ordernumber int , UID_AttestationHelper varchar(38
2) collate database_default , UID_PersonHead varchar(38) collate database_default , UID_PWODecisionRule varchar(38) collate database_default , LevelNumber
3 int , SubLevelNumber int , UID_QERWorkingStep varchar(38) collate database_default , RulerLevel int ) as begin declare @CurrentLevel int declare @uid_QERWorkingMethod
4 varchar(38) declare @lauf int = 1 declare @work QER_YPWONextDecisionMaker select top 1 @CurrentLevel = decisionlevel from AttestationCase where uid_AttestationCase
5 = @uid_AttestationCase  select top 1 @uid_QERWorkingMethod = pwo.UID_QERWorkingMethod from AttestationCase pwo where pwo.uid_AttestationCase = @uid_AttestationCase;
6   insert into @work (UID_QERWorkingStep, LevelNumber, positivesteps, Ordernumber) select ws.UID_QERWorkingStep, LevelNumber, positivesteps, 1 as Ordernumber
7 from QERWorkingStep ws where ws.UID_QERWorkingMethod = @uid_QERWorkingMethod and ws.levelnumber = @CurrentLevel    while @Lauf > 0 begin insert into @work
8 (UID_QERWorkingStep, LevelNumber, positivesteps, Ordernumber) select distinct a.UID_QERWorkingStep, a.LevelNumber, a.positivesteps, h.ordernumber +1 from
9 QERWorkingStep a join @work h on a.levelnumber = h.levelnumber + h.positiveSteps where a.UID_QERWorkingMethod = @UID_QERWorkingMethod and h.positiveSteps
10 <> 0 and not exists (select top 1 1 from @work w where w.UID_QERWorkingStep = a.UID_QERWorkingStep ) select @lauf = @@rowcount end insert into @erg ( 
11Ordernumber, UID_AttestationHelper, UID_PersonHead, UID_PWODecisionRule, LevelNumber, SubLevelNumber, UID_QERWorkingStep , RulerLevel) select distinct 
12sNext.Ordernumber, hNext.UID_AttestationHelper, hNext.UID_PersonHead, hNext.UID_PWODecisionRule, hNext.LevelNumber, hNext.SubLevelNumber, hNext.UID_QERWorkingStep
13 , hNext.RulerLevel from (select UID_QERWorkingStep, LevelNumber, positivesteps , ordernumber from @work ) as sNext  join ATT_VAttDecisionPerson_I hNext
14 on hNext.uid_AttestationCase = @uid_AttestationCase and sNext.levelnumber = hNext.Levelnumber and sNext.UID_QERWorkingStep = hNext.UID_QERWorkingStep 
15return end 
16

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:42.897

None extracted.

Summary: writes INSERT into; reads/joins AttestationCase, QERWorkingStep, ATT_VAttDecisionPerson_I

Declared parameters

Parameter	Type	Direction
`@uid_AttestationCase`	`varchar(38)`	input

DML targets

INSERT into

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 @erg @CurrentLevel @uid_QERWorkingMethod @lauf @work @Lauf @UID_QERWorkingMethod @rowcount

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.

No reverse dependencies extracted.