dbo.QER_FGITimeZoneForPerson
SQL_SCALAR_FUNCTION
Created 2025-06-27T17:59:27.250 · modified 2026-04-14T23:20:36.220 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| varchar | yes |
@UID_Person | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | BaseTree | OBJECT_OR_COLUMN | |
| dbo | BaseTree | UID_Org | OBJECT_OR_COLUMN |
| dbo | BaseTree | UID_DialogState | OBJECT_OR_COLUMN |
| dbo | BaseTree | UID_DialogCountry | OBJECT_OR_COLUMN |
| dbo | DialogCountry | OBJECT_OR_COLUMN | |
| dbo | DialogCountry | UID_DialogCountry | OBJECT_OR_COLUMN |
| dbo | DialogCountryHasTimeZone | OBJECT_OR_COLUMN | |
| dbo | DialogCountryHasTimeZone | UID_DialogTimeZone | OBJECT_OR_COLUMN |
| dbo | DialogCountryHasTimeZone | UID_DialogCountry | OBJECT_OR_COLUMN |
| dbo | DialogDatabase | OBJECT_OR_COLUMN | |
| dbo | DialogDatabase | IsMainDatabase | OBJECT_OR_COLUMN |
| dbo | DialogDatabase | UID_DialogCountryDefault | OBJECT_OR_COLUMN |
| dbo | DialogState | OBJECT_OR_COLUMN | |
| dbo | DialogState | UID_DialogState | OBJECT_OR_COLUMN |
| dbo | DialogState | UID_DialogCountry | OBJECT_OR_COLUMN |
| dbo | DialogStateHasTimeZone | OBJECT_OR_COLUMN | |
| dbo | DialogStateHasTimeZone | UID_DialogTimeZone | OBJECT_OR_COLUMN |
| dbo | DialogStateHasTimeZone | UID_DialogState | OBJECT_OR_COLUMN |
| dbo | Person | OBJECT_OR_COLUMN | |
| dbo | Person | UID_Person | OBJECT_OR_COLUMN |
| dbo | Person | UID_DialogState | OBJECT_OR_COLUMN |
| dbo | Person | UID_DialogCountry | OBJECT_OR_COLUMN |
| dbo | Person | UID_Locality | 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_FGITimeZoneForPerson ( @UID_Person varchar(38) ) returns varchar(38) with schemabinding as begin return ( select 2top 1 isnull(z1.UID_DialogTimeZone , isnull (z3.UID_DialogTimeZone , isnull(z2.UID_DialogTimeZone , isnull(z4.UID_DialogTimeZone, isnull(z5.UID_DialogTimeZone 3 , 'QBM-FA50BC3A1B8FC82E9DCFCCF81AA0D275' ) ) ) ) ) as UID_DialogTimeZone from dbo.Person p join dbo.DialogDatabase db on db.IsMainDatabase 4 = 1 left outer join dbo.DialogState s1 on p.UID_DialogState = s1.UID_DialogState left outer join dbo.DialogStateHasTimeZone z1 on s1.UID_DialogState = 5 z1.UID_DialogState left outer join dbo.DialogCountry c1 on c1.UID_DialogCountry = case when s1.UID_DialogCountry is null then p.UID_DialogCountry else 6 s1.UID_DialogCountry end left outer join dbo.DialogCountryHasTimeZone z2 on c1.UID_DialogCountry = z2.UID_DialogCountry left outer join dbo.BaseTree l 7 on p.UID_Locality = l.UID_Org left outer join dbo.DialogState s2 on l.UID_DialogState = s2.UID_DialogState left outer join dbo.DialogStateHasTimeZone 8z3 on s2.UID_DialogState = z3.UID_DialogState left outer join dbo.DialogCountry c2 on c2.UID_DialogCountry = case when s2.UID_DialogCountry is null then 9 l.UID_DialogCountry else s2.UID_DialogCountry end left outer join dbo.DialogCountryHasTimeZone z4 on c2.UID_DialogCountry = z4.UID_DialogCountry left 10outer join dbo.DialogCountryHasTimeZone z5 on db.UID_DialogCountryDefault = z5.UID_DialogCountry where p.UID_Person = @UID_Person ) end 11
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.220
None extracted.
Summary: reads/joins Person, DialogDatabase, DialogState, DialogStateHasTimeZone, DialogCountry…
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| varchar(38) | OUTPUT |
@UID_Person | varchar(38) | 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_Person
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.