dbo.TSB_FTAttCasesForManager

SQL_TABLE_VALUED_FUNCTION

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

Open formatted source/search result

Parameters

NameTypeOutput
@UID_PersonHeadvarcharno

Referenced objects

SchemaObjectColumn/minorClass
AttestationCaseOBJECT_OR_COLUMN
HelperHeadOrgOBJECT_OR_COLUMN
HelperHeadPersonOBJECT_OR_COLUMN
HelperPersonOrgOBJECT_OR_COLUMN
PersonInBaseTreeOBJECT_OR_COLUMN
UNSAccountOBJECT_OR_COLUMN
UNSAccountInUNSGroupOBJECT_OR_COLUMN
dboQBM_FGISessionContextOBJECT_OR_COLUMN

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

uses session context values

Summary: writes INSERT into; reads/joins HelperPersonOrg, HelperHeadOrg, PersonInBaseTree, HelperHeadPerson, UNSAccount…; uses session context ATTCaseAccessAsManagerReduced

Declared parameters

ParameterTypeDirection
@UID_PersonHeadvarchar(38)input

DML targets

INSERT into

Called routines

None extracted.

Config/session

Config: None extracted.

Session: ATTCaseAccessAsManagerReduced

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_PersonHead @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.

No reverse dependencies extracted.