dbo.QER_FTEntitlementSourceWhat

SQL_TABLE_VALUED_FUNCTION

Created 2026-04-14T23:17:26.423 · modified 2026-04-14T23:30:47.540 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@UID_Person`	varchar	no

Referenced objects

Schema	Object	Class
	QER_YEntitlementSource	TYPE
dbo	GEN_FTEA052C57FFC38328DEBA32A9	OBJECT_OR_COLUMN
dbo	GEN_FTEA0562242E3BC4136BCA1CE9	OBJECT_OR_COLUMN
dbo	GEN_FTEA0645E8C2F9B5D85DEBA328	OBJECT_OR_COLUMN
dbo	GEN_FTEA0903650603CEE51D0D8E99	OBJECT_OR_COLUMN
dbo	GEN_FTEA0AFEF484D24111A0AD05D7	OBJECT_OR_COLUMN
dbo	GEN_FTEA0D4ED3FA20B8B03D99F9EA	OBJECT_OR_COLUMN
dbo	GEN_FTEA0D9141B00DE6C703F65CD1	OBJECT_OR_COLUMN
dbo	GEN_FTEA0DC791D52212F3160F6126	OBJECT_OR_COLUMN
dbo	GEN_FTEA1216AC32F7DDFD2F28A5A0	OBJECT_OR_COLUMN
dbo	GEN_FTEA18204A66ECAA552D7FF404	OBJECT_OR_COLUMN
dbo	GEN_FTEA19278B9A1A963F887B7D68	OBJECT_OR_COLUMN
dbo	GEN_FTEA199E3E6A7A8E311D20E166	OBJECT_OR_COLUMN
dbo	GEN_FTEA1F4A4D596754E8C86BFEA9	OBJECT_OR_COLUMN
dbo	GEN_FTEA226D96A5F34CEF70AB82F9	OBJECT_OR_COLUMN
dbo	GEN_FTEA255A0285DD402BFAB93B25	OBJECT_OR_COLUMN
dbo	GEN_FTEA26AE8653CE34A60AD13BC5	OBJECT_OR_COLUMN
dbo	GEN_FTEA2BA18D91752F1D5C38D151	OBJECT_OR_COLUMN
dbo	GEN_FTEA310165B25E4563AF303EE0	OBJECT_OR_COLUMN
dbo	GEN_FTEA3506D39B51979D4C46E482	OBJECT_OR_COLUMN
dbo	GEN_FTEA36E3A728F88E62CF1CFB95	OBJECT_OR_COLUMN
dbo	GEN_FTEA370D1058470A9CD26BDA5D	OBJECT_OR_COLUMN
dbo	GEN_FTEA38B9ED76E7AC8770650C35	OBJECT_OR_COLUMN
dbo	GEN_FTEA39A8D48FB403F03563737A	OBJECT_OR_COLUMN
dbo	GEN_FTEA39F97BA14C3AF610AF805D	OBJECT_OR_COLUMN
dbo	GEN_FTEA3BA487D25E0B51EEA031BA	OBJECT_OR_COLUMN
dbo	GEN_FTEA4016135529BB929BEC7812	OBJECT_OR_COLUMN
dbo	GEN_FTEA40DAF2BBFD8F3E76465F07	OBJECT_OR_COLUMN
dbo	GEN_FTEA44C75AAD712A4B5352C267	OBJECT_OR_COLUMN
dbo	GEN_FTEA45A311C91FBA41355532B8	OBJECT_OR_COLUMN
dbo	GEN_FTEA46F00D80E21C1022CB5C08	OBJECT_OR_COLUMN
dbo	GEN_FTEA47E4D1BAE6544A9A61145D	OBJECT_OR_COLUMN
dbo	GEN_FTEA4A5469920A88A862DC456E	OBJECT_OR_COLUMN
dbo	GEN_FTEA4B00D2AD20943F16077A89	OBJECT_OR_COLUMN
dbo	GEN_FTEA4BD8D70C0473E3B5530A24	OBJECT_OR_COLUMN
dbo	GEN_FTEA4D3DEDD0A0680B32BDC19C	OBJECT_OR_COLUMN
dbo	GEN_FTEA4D4D5421CC31A2B100D047	OBJECT_OR_COLUMN
dbo	GEN_FTEA4EA5D15C763E3C3011039A	OBJECT_OR_COLUMN
dbo	GEN_FTEA5025B50316612A9FC934B6	OBJECT_OR_COLUMN
dbo	GEN_FTEA532B9A3E14A9D7429B5D48	OBJECT_OR_COLUMN
dbo	GEN_FTEA5422151F788E3664457CFE	OBJECT_OR_COLUMN
dbo	GEN_FTEA59458D9947154584635039	OBJECT_OR_COLUMN
dbo	GEN_FTEA5ACA6175D73BE289D55766	OBJECT_OR_COLUMN
dbo	GEN_FTEA5B82EF66EAC4FEF9A609A7	OBJECT_OR_COLUMN
dbo	GEN_FTEA5EA3EF0E9FC80233ADD9EE	OBJECT_OR_COLUMN
dbo	GEN_FTEA611AC9FE209B209D6BA5B6	OBJECT_OR_COLUMN
dbo	GEN_FTEA6366D8CFF73CE96E6798C9	OBJECT_OR_COLUMN
dbo	GEN_FTEA643EA6D1A37B3B2AB34742	OBJECT_OR_COLUMN
dbo	GEN_FTEA6634AAB5446A6F027C3DDD	OBJECT_OR_COLUMN
dbo	GEN_FTEA67C57A8217994EA861D49A	OBJECT_OR_COLUMN
dbo	GEN_FTEA68DE2FD4D90FC662383EB2	OBJECT_OR_COLUMN
dbo	GEN_FTEA69C7D693E3A511EB0EEF22	OBJECT_OR_COLUMN
dbo	GEN_FTEA6A68701D09FEC5A029AF12	OBJECT_OR_COLUMN
dbo	GEN_FTEA6A86F8A746859114FF8FEE	OBJECT_OR_COLUMN
dbo	GEN_FTEA6B0C73DBB737AB994BFB9E	OBJECT_OR_COLUMN
dbo	GEN_FTEA6DF38142688310E1CF5D0D	OBJECT_OR_COLUMN
dbo	GEN_FTEA6ED883FB726365FEE502C2	OBJECT_OR_COLUMN
dbo	GEN_FTEA6FF83AAA6C0196BAABFBA1	OBJECT_OR_COLUMN
dbo	GEN_FTEA717DA0B73310E9B176E430	OBJECT_OR_COLUMN
dbo	GEN_FTEA733D5A2F74AC441DC72FDA	OBJECT_OR_COLUMN
dbo	GEN_FTEA75D7AD4A6AC2166A58F18B	OBJECT_OR_COLUMN
dbo	GEN_FTEA76EA96C7866686065CF072	OBJECT_OR_COLUMN
dbo	GEN_FTEA7753660E27005EE52B37B7	OBJECT_OR_COLUMN
dbo	GEN_FTEA78C3BCC907CEF155050D0B	OBJECT_OR_COLUMN
dbo	GEN_FTEA78E3752AE40219C83E30A1	OBJECT_OR_COLUMN
dbo	GEN_FTEA79B4104C58AE0D64794CC5	OBJECT_OR_COLUMN
dbo	GEN_FTEA7D76E1B7A58049F385BDD1	OBJECT_OR_COLUMN
dbo	GEN_FTEA832B0D8B81E9925C62D16E	OBJECT_OR_COLUMN
dbo	GEN_FTEA84471BDD3A80C274B3CB95	OBJECT_OR_COLUMN
dbo	GEN_FTEA84A7FC7FA31458F2267433	OBJECT_OR_COLUMN
dbo	GEN_FTEA8AE88188E25DEB8FE0FEB9	OBJECT_OR_COLUMN
dbo	GEN_FTEA8AEAF9E5D09259EDA878DF	OBJECT_OR_COLUMN
dbo	GEN_FTEA90AFB2C2D494ADEEDA79F8	OBJECT_OR_COLUMN
dbo	GEN_FTEA927634F409219D76930307	OBJECT_OR_COLUMN
dbo	GEN_FTEA971064C4D84C7F5C831A38	OBJECT_OR_COLUMN
dbo	GEN_FTEA9CC8C922010CFFAA6F4D1C	OBJECT_OR_COLUMN
dbo	GEN_FTEA9D6B5B4563C99194FBEE76	OBJECT_OR_COLUMN
dbo	GEN_FTEA9E586A06923CD160E03E59	OBJECT_OR_COLUMN
dbo	GEN_FTEA9F694BE52B00F0CAD2C28C	OBJECT_OR_COLUMN
dbo	GEN_FTEAA6BEB2C92454EB95ADBFCE	OBJECT_OR_COLUMN
dbo	GEN_FTEAAB5A6D24DC44B6BA4A9D69	OBJECT_OR_COLUMN
dbo	GEN_FTEAAC15AF9D41DD5F69733C77	OBJECT_OR_COLUMN
dbo	GEN_FTEAAFB9EC93A3D280D5FE7BE4	OBJECT_OR_COLUMN
dbo	GEN_FTEAB1A242CBE16829A0713754	OBJECT_OR_COLUMN
dbo	GEN_FTEAB2CB5AD948E0645C782DA8	OBJECT_OR_COLUMN
dbo	GEN_FTEAB4B3FCC3F35FE97044F114	OBJECT_OR_COLUMN
dbo	GEN_FTEAB7DBF0F7F222EB264AEFE2	OBJECT_OR_COLUMN
dbo	GEN_FTEAB8A4C56A3BCAE4E1CC8CB9	OBJECT_OR_COLUMN
dbo	GEN_FTEAB9E86C9E57B65A3C36124A	OBJECT_OR_COLUMN
dbo	GEN_FTEABD70E8CEFB7F495A4BF5E8	OBJECT_OR_COLUMN
dbo	GEN_FTEABF977C3E8CA5B9E2A0D17C	OBJECT_OR_COLUMN
dbo	GEN_FTEAC00CD2AABC9A393205CAD7	OBJECT_OR_COLUMN
dbo	GEN_FTEAC30B841562FBB6AD83DD64	OBJECT_OR_COLUMN
dbo	GEN_FTEAC3ADCB5E377B40F83363AD	OBJECT_OR_COLUMN
dbo	GEN_FTEAC4C366EB5254B225BF5305	OBJECT_OR_COLUMN
dbo	GEN_FTEAC92179345E716BD560B0CF	OBJECT_OR_COLUMN
dbo	GEN_FTEACA40EFDEFD73519CB8686E	OBJECT_OR_COLUMN
dbo	GEN_FTEACC0A0F161C5139A85978D6	OBJECT_OR_COLUMN
dbo	GEN_FTEACE29B499D46B63085B019F	OBJECT_OR_COLUMN
dbo	GEN_FTEACE3DC70A9B100D72DAA13F	OBJECT_OR_COLUMN
dbo	GEN_FTEACEAEF6307F54578E77C1CB	OBJECT_OR_COLUMN
dbo	GEN_FTEACFBED7D30C98E347C66961	OBJECT_OR_COLUMN
dbo	GEN_FTEAD301F9FF7A083E43F9504C	OBJECT_OR_COLUMN
dbo	GEN_FTEAD390D8E019F927E8C5D7ED	OBJECT_OR_COLUMN
dbo	GEN_FTEAD3B3D4A4AAE3E77B7F745E	OBJECT_OR_COLUMN
dbo	GEN_FTEAD520395E68C42A43B324B0	OBJECT_OR_COLUMN
dbo	GEN_FTEAD6C8AFC6E23E46E496EAC8	OBJECT_OR_COLUMN
dbo	GEN_FTEAD6FE70DA25EEF93CA9D2B9	OBJECT_OR_COLUMN
dbo	GEN_FTEAD7000AD9C38ECA30590962	OBJECT_OR_COLUMN
dbo	GEN_FTEAD7441E90FFE1AE74985684	OBJECT_OR_COLUMN
dbo	GEN_FTEAD8BB649D76CAA69B89A966	OBJECT_OR_COLUMN
dbo	GEN_FTEADB0B0EC871449B1B49BEF1	OBJECT_OR_COLUMN
dbo	GEN_FTEADB5747C14BDA36B438D93E	OBJECT_OR_COLUMN
dbo	GEN_FTEADD732A0666B3CFF1F55F32	OBJECT_OR_COLUMN
dbo	GEN_FTEADDFFE62F7C862D8EFE9F7E	OBJECT_OR_COLUMN
dbo	GEN_FTEADE1E3A590507E281619BA6	OBJECT_OR_COLUMN
dbo	GEN_FTEADE4559DC2647E1BE849894	OBJECT_OR_COLUMN
dbo	GEN_FTEADE880E3AF4EE9AA85A729C	OBJECT_OR_COLUMN
dbo	GEN_FTEAE0243565BE6703FE18220D	OBJECT_OR_COLUMN
dbo	GEN_FTEAE19993A21305768BC67BA1	OBJECT_OR_COLUMN
dbo	GEN_FTEAE24C7689C983E5CB872211	OBJECT_OR_COLUMN
dbo	GEN_FTEAE3032C0FADEE6588E30677	OBJECT_OR_COLUMN
dbo	GEN_FTEAE471A89D763769CBFA1C40	OBJECT_OR_COLUMN
dbo	GEN_FTEAE4CB6083ECBBAB532F8C8D	OBJECT_OR_COLUMN
dbo	GEN_FTEAE6BFA2A0EEBD07BFB948B0	OBJECT_OR_COLUMN
dbo	GEN_FTEAE70F7C7DC007D2525BE642	OBJECT_OR_COLUMN
dbo	GEN_FTEAE7168DED6199B6A2FA6211	OBJECT_OR_COLUMN
dbo	GEN_FTEAE94A2AB5EF5E2BADE9B1BB	OBJECT_OR_COLUMN
dbo	GEN_FTEAE955BD06F7AE35BED30834	OBJECT_OR_COLUMN
dbo	GEN_FTEAEB1F7431C6117548A68D7D	OBJECT_OR_COLUMN
dbo	GEN_FTEAEF8461936F1EDDAA2786EE	OBJECT_OR_COLUMN
dbo	GEN_FTEAEFA354DB5BB55501D2E20F	OBJECT_OR_COLUMN
dbo	GEN_FTEAF07589AAAA0DEC628A9266	OBJECT_OR_COLUMN
dbo	GEN_FTEAF29EA2DA76C6EC02CFA694	OBJECT_OR_COLUMN
dbo	GEN_FTEAF2A8B3614E3CB9B9ACDB42	OBJECT_OR_COLUMN
dbo	GEN_FTEAF375C8DA6762C3F41D8CD0	OBJECT_OR_COLUMN
dbo	GEN_FTEAF53ED6416AEF3C9155D8DB	OBJECT_OR_COLUMN
dbo	GEN_FTEAF648DFCDF3FE983A928268	OBJECT_OR_COLUMN
dbo	GEN_FTEAF7C9B410A1B1C80C52DC2D	OBJECT_OR_COLUMN
dbo	GEN_FTEAF8A64AD7505FEFD6CA66F0	OBJECT_OR_COLUMN
dbo	GEN_FTEAFBEAF4BE6580A2C3226736	OBJECT_OR_COLUMN
dbo	GEN_FTEAFC326AB61853A5350E3D2C	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.QER_FTEntitlementSourceWhat(
2											@UID_Person varchar(38) 
3											)
4	returns @erg table (
5						ObjectKeyToInspect varchar(138) collate database_default
6						)
7 as
8begin
9
10declare @work QER_YEntitlementSource
11
12	  insert into @work(ObjectKeyToInspect)
13	  select xx.ObjectKeyToInspect
14	   from dbo.GEN_FTEA26AE8653CE34A60AD13BC5 (@UID_Person) as xx
15
16	  insert into @work(ObjectKeyToInspect)
17	  select xx.ObjectKeyToInspect
18	   from dbo.GEN_FTEA19278B9A1A963F887B7D68 (@UID_Person) as xx
19
20	  insert into @work(ObjectKeyToInspect)
21	  select xx.ObjectKeyToInspect
22	   from dbo.GEN_FTEAE0243565BE6703FE18220D (@UID_Person) as xx
23
24	  insert into @work(ObjectKeyToInspect)
25	  select xx.ObjectKeyToInspect
26	   from dbo.GEN_FTEA8AEAF9E5D09259EDA878DF (@UID_Person) as xx
27
28	  insert into @work(ObjectKeyToInspect)
29	  select xx.ObjectKeyToInspect
30	   from dbo.GEN_FTEAE19993A21305768BC67BA1 (@UID_Person) as xx
31
32	  insert into @work(ObjectKeyToInspect)
33	  select xx.ObjectKeyToInspect
34	   from dbo.GEN_FTEA69C7D693E3A511EB0EEF22 (@UID_Person) as xx
35
36	  insert into @work(ObjectKeyToInspect)
37	  select xx.ObjectKeyToInspect
38	   from dbo.GEN_FTEA255A0285DD402BFAB93B25 (@UID_Person) as xx
39
40	  insert into @work(ObjectKeyToInspect)
41	  select xx.ObjectKeyToInspect
42	   from dbo.GEN_FTEAEB1F7431C6117548A68D7D (@UID_Person) as xx
43
44	  insert into @work(ObjectKeyToInspect)
45	  select xx.ObjectKeyToInspect
46	   from dbo.GEN_FTEA78E3752AE40219C83E30A1 (@UID_Person) as xx
47
48	  insert into @work(ObjectKeyToInspect)
49	  select xx.ObjectKeyToInspect
50	   from dbo.GEN_FTEA4BD8D70C0473E3B5530A24 (@UID_Person) as xx
51
52	  insert into @work(ObjectKeyToInspect)
53	  select xx.ObjectKeyToInspect
54	   from dbo.GEN_FTEA6366D8CFF73CE96E6798C9 (@UID_Person) as xx
55
56	  insert into @work(ObjectKeyToInspect)
57	  select xx.ObjectKeyToInspect
58	   from dbo.GEN_FTEAC4C366EB5254B225BF5305 (@UID_Person) as xx
59
60	  insert into @work(ObjectKeyToInspect)
61	  select xx.ObjectKeyToInspect
62	   from dbo.GEN_FTEA6ED883FB726365FEE502C2 (@UID_Person) as xx
63
64	  insert into @work(ObjectKeyToInspect)
65	  select xx.ObjectKeyToInspect
66	   from dbo.GEN_FTEA40DAF2BBFD8F3E76465F07 (@UID_Person) as xx
67
68	  insert into @work(ObjectKeyToInspect)
69	  select xx.ObjectKeyToInspect
70	   from dbo.GEN_FTEA6634AAB5446A6F027C3DDD (@UID_Person) as xx
71
72	  insert into @work(ObjectKeyToInspect)
73	  select xx.ObjectKeyToInspect
74	   from dbo.GEN_FTEA717DA0B73310E9B176E430 (@UID_Person) as xx
75
76	  insert into @work(ObjectKeyToInspect)
77	  select xx.ObjectKeyToInspect
78	   from dbo.GEN_FTEA38B9ED76E7AC8770650C35 (@UID_Person) as xx
79
80	  insert into @work(ObjectKeyToInspect)

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:30:47.540

None extracted.

Summary: writes INSERT into; reads/joins GEN_FTEA26AE8653CE34A60AD13BC5, GEN_FTEA19278B9A1A963F887B7D68, GEN_FTEAE0243565BE6703FE18220D, GEN_FTEA8AEAF9E5D09259EDA878DF, GEN_FTEAE19993A21305768BC67BA1…

Declared parameters

Parameter	Type	Direction
`@UID_Person`	`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_Person @erg @work

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.