dbo.QER_FGICultureForPerson

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:59:27.220 · modified 2026-04-14T23:20:36.173 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	varchar	yes
`@UID_Person`	varchar	no

Referenced objects

Schema	Object	Class
	BaseTree	OBJECT_OR_COLUMN
	dialogCountryhasCulture	OBJECT_OR_COLUMN
	dialogstatehasCulture	OBJECT_OR_COLUMN
	person	OBJECT_OR_COLUMN
	QBMCulture	OBJECT_OR_COLUMN
dbo	QBM_FGIConfigparmValue	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

1   create   function dbo.QER_FGICultureForPerson (@UID_Person varchar(38) ) returns varchar(38) as begin declare @uid_dialogcountry varchar(38) 
2declare @uid_dialogState varchar(38) declare @uid_locality varchar(38) declare @uid_department varchar(38) declare @uid_ProfitCenter varchar(38)  declare
3 @UID_DialogCulture varchar(38) select top 1 @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState , @uid_locality = uid_locality
4 , @uid_department = uid_department , @uid_ProfitCenter = uid_ProfitCenter  , @UID_DialogCulture = UID_DialogCulture from person where uid_person = @uid_person
5  if @UID_DialogCulture is null begin  select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState
6 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture
7 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end  end if @uid_locality > ' ' and @UID_DialogCulture is null begin select
8 top 1 @UID_DialogCulture = UID_DialogCulture, @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState from BaseTree where uid_org 
9= @uid_locality if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState
10 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture
11 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end end  end  if @uid_Department > ' ' and @UID_DialogCulture is null begin
12 select top 1 @UID_DialogCulture = UID_DialogCulture, @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState from BaseTree where uid_org
13 = @uid_Department if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState
14 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture
15 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end end  end  if @uid_ProfitCenter > ' ' and @UID_DialogCulture is null begin
16 select top 1 @UID_DialogCulture = UID_DialogCulture, @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState from BaseTree where uid_org
17 = @uid_ProfitCenter if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState
18 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture
19 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end end  end    if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture
20 = cu.UID_DialogCulture from QBMCulture cu where cu.Ident_DialogCulture = left(dbo.QBM_FGIConfigparmValue('Common\MailNotification\DefaultCulture'), 16
21) end if isnull(@UID_DialogCulture, '') = '' begin select @UID_DialogCulture = 'QBM-Cult-en-US' end  ende: return (@UID_DialogCulture) end 
22

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.173

None extracted.

Summary: reads/joins person, dialogstatehasCulture, dialogCountryhasCulture, BaseTree, QBMCulture; uses config Common\MailNotification\DefaultCulture

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: Common\MailNotification\DefaultCulture

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_Person @uid_dialogcountry @uid_dialogState @uid_locality @uid_department @uid_ProfitCenter @UID_DialogCulture @uid_person @uid_dialogCountry @uid_Department

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.