dbo.QER_FTEntitlementSourceWhy

SQL_TABLE_VALUED_FUNCTION

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

Open formatted source/search result

Parameters

Name	Type	Output
`@UID_Person`	varchar	no
`@ObjectKeyToInspect`	varchar	no

Referenced objects

Schema	Object	Class
dbo	GEN_FTEY0122181C230044398280FE	OBJECT_OR_COLUMN
dbo	GEN_FTEY01FB8D175B472AFAC4FBBD	OBJECT_OR_COLUMN
dbo	GEN_FTEY04ACC922CE0D679BFBDF68	OBJECT_OR_COLUMN
dbo	GEN_FTEY06423E1553D20332D88F9A	OBJECT_OR_COLUMN
dbo	GEN_FTEY08F52C68A60DA875F2F6BB	OBJECT_OR_COLUMN
dbo	GEN_FTEY0BA325EDC97A6511B77954	OBJECT_OR_COLUMN
dbo	GEN_FTEY0BAF2057553029E6B0BFCD	OBJECT_OR_COLUMN
dbo	GEN_FTEY0BCBB74461782A260ACBBA	OBJECT_OR_COLUMN
dbo	GEN_FTEY0D204A0FA588A619EB3F7B	OBJECT_OR_COLUMN
dbo	GEN_FTEY0F8CCEAC5542AB58BC6783	OBJECT_OR_COLUMN
dbo	GEN_FTEY11C75B4ECD9BB22D2D748B	OBJECT_OR_COLUMN
dbo	GEN_FTEY1259C3D6106F88D3FE81C1	OBJECT_OR_COLUMN
dbo	GEN_FTEY15CB642D7F87E41BF86FE8	OBJECT_OR_COLUMN
dbo	GEN_FTEY1651DF0943C389DD296ADE	OBJECT_OR_COLUMN
dbo	GEN_FTEY16F46EAC98E87C927E087B	OBJECT_OR_COLUMN
dbo	GEN_FTEY197EC6A22EFCA0F37E16F8	OBJECT_OR_COLUMN
dbo	GEN_FTEY19AE465A1AEDCAF37D47AC	OBJECT_OR_COLUMN
dbo	GEN_FTEY1C7461F2680F62B272D390	OBJECT_OR_COLUMN
dbo	GEN_FTEY3119E9B9D28BDAB8DBBB2F	OBJECT_OR_COLUMN
dbo	GEN_FTEY32246AB0D1EBEA0EF689F3	OBJECT_OR_COLUMN
dbo	GEN_FTEY3252DCA9E44227685CE446	OBJECT_OR_COLUMN
dbo	GEN_FTEY334AF4B7AAF5D1C1085331	OBJECT_OR_COLUMN
dbo	GEN_FTEY3503043CCF5F62E3FC1EC7	OBJECT_OR_COLUMN
dbo	GEN_FTEY362F968B4687C8212EF4EF	OBJECT_OR_COLUMN
dbo	GEN_FTEY3652C1025CCBFA75922279	OBJECT_OR_COLUMN
dbo	GEN_FTEY365A3E48EE0118A0F8B4E2	OBJECT_OR_COLUMN
dbo	GEN_FTEY3660BE5A72C51D09E109D2	OBJECT_OR_COLUMN
dbo	GEN_FTEY41843567E57D1397868D56	OBJECT_OR_COLUMN
dbo	GEN_FTEY44E94D0D92A82BFECD72B7	OBJECT_OR_COLUMN
dbo	GEN_FTEY46244768898D6B348324B5	OBJECT_OR_COLUMN
dbo	GEN_FTEY4855C755CA9487EA21B72A	OBJECT_OR_COLUMN
dbo	GEN_FTEY4926D9B896C39764C9EF8F	OBJECT_OR_COLUMN
dbo	GEN_FTEY5082C636ECA32E1D797C16	OBJECT_OR_COLUMN
dbo	GEN_FTEY510EB2AF297B8F844C83DA	OBJECT_OR_COLUMN
dbo	GEN_FTEY53D8D792B6515142C31909	OBJECT_OR_COLUMN
dbo	GEN_FTEY54D7FCA2E89FC59ACF04B8	OBJECT_OR_COLUMN
dbo	GEN_FTEY57C35E74C42BCE83936653	OBJECT_OR_COLUMN
dbo	GEN_FTEY57D0C486EFB83A7F90C10D	OBJECT_OR_COLUMN
dbo	GEN_FTEY5A3D5445A31314E3C80820	OBJECT_OR_COLUMN
dbo	GEN_FTEY5F7DBF32525FD5E76002A3	OBJECT_OR_COLUMN
dbo	GEN_FTEY603E46E7D17851CEECD074	OBJECT_OR_COLUMN
dbo	GEN_FTEY60473E8B8DB38BF7C1CCE3	OBJECT_OR_COLUMN
dbo	GEN_FTEY625B5F1743A4CD81DB1A7A	OBJECT_OR_COLUMN
dbo	GEN_FTEY63E94516858277C9BB4F5A	OBJECT_OR_COLUMN
dbo	GEN_FTEY63EBFB5F389C2C71565877	OBJECT_OR_COLUMN
dbo	GEN_FTEY654CCD699AC827FB59CD22	OBJECT_OR_COLUMN
dbo	GEN_FTEY680B289738F51B38B41A7B	OBJECT_OR_COLUMN
dbo	GEN_FTEY6899BC09F309C000CB6007	OBJECT_OR_COLUMN
dbo	GEN_FTEY68B364EED5084A7D5D23F3	OBJECT_OR_COLUMN
dbo	GEN_FTEY6A01F15B07CC9CBEDA919D	OBJECT_OR_COLUMN
dbo	GEN_FTEY6A4C3C6E502E007685003B	OBJECT_OR_COLUMN
dbo	GEN_FTEY6CBBED4521EDE5C5B61A02	OBJECT_OR_COLUMN
dbo	GEN_FTEY6CF75B30295FEFA8CD3709	OBJECT_OR_COLUMN
dbo	GEN_FTEY703F1F5EE8D64B7DB79B18	OBJECT_OR_COLUMN
dbo	GEN_FTEY714650F04D0D2C9ADFD428	OBJECT_OR_COLUMN
dbo	GEN_FTEY7166BBF7E8B4003DCA4B3D	OBJECT_OR_COLUMN
dbo	GEN_FTEY73F83A16FCB3159A7F6DF1	OBJECT_OR_COLUMN
dbo	GEN_FTEY75C7B00B32C74FA8C734A8	OBJECT_OR_COLUMN
dbo	GEN_FTEY7705EAA3F767C86779D0BD	OBJECT_OR_COLUMN
dbo	GEN_FTEY780D32B60508B96FB55733	OBJECT_OR_COLUMN
dbo	GEN_FTEY7C0A8CD265F459125E08F4	OBJECT_OR_COLUMN
dbo	GEN_FTEY7E63AC104BE0F8468C3926	OBJECT_OR_COLUMN
dbo	GEN_FTEY7FBACBED2AE88C3A9756AD	OBJECT_OR_COLUMN
dbo	GEN_FTEY802A83C3E07BD2831C4DF1	OBJECT_OR_COLUMN
dbo	GEN_FTEY81C940D082F32291EFCE78	OBJECT_OR_COLUMN
dbo	GEN_FTEY87AE45C88F8A7904BD9510	OBJECT_OR_COLUMN
dbo	GEN_FTEY896E146F4F840E422CCBA3	OBJECT_OR_COLUMN
dbo	GEN_FTEY8B9BB6E0E5756FA8FC6CBF	OBJECT_OR_COLUMN
dbo	GEN_FTEY8BF540F72028620D497ABE	OBJECT_OR_COLUMN
dbo	GEN_FTEY8C8C8E4B72714983D306FB	OBJECT_OR_COLUMN
dbo	GEN_FTEY8D93A3D46765A5490FA4FC	OBJECT_OR_COLUMN
dbo	GEN_FTEY8E0532B844467344E61179	OBJECT_OR_COLUMN
dbo	GEN_FTEY8FEF93B7440FEF03F2412C	OBJECT_OR_COLUMN
dbo	GEN_FTEY921BCCEECC644676A5E2D4	OBJECT_OR_COLUMN
dbo	GEN_FTEY93C83068790E482B9BC48A	OBJECT_OR_COLUMN
dbo	GEN_FTEY94A1455D19630D9B5E3446	OBJECT_OR_COLUMN
dbo	GEN_FTEY959435F6DBCCA9EB3EB28D	OBJECT_OR_COLUMN
dbo	GEN_FTEY95A0CB3F5C230BAF81B16E	OBJECT_OR_COLUMN
dbo	GEN_FTEY95BE8166C29BD1FD6991CC	OBJECT_OR_COLUMN
dbo	GEN_FTEY9AA9267513A52C463DBAB1	OBJECT_OR_COLUMN
dbo	GEN_FTEY9C537565E770C30AA1EC81	OBJECT_OR_COLUMN
dbo	GEN_FTEY9C5A940806B98C76B45A28	OBJECT_OR_COLUMN
dbo	GEN_FTEY9D970CBAA569CA4712CE1A	OBJECT_OR_COLUMN
dbo	GEN_FTEY9E3743EF4FD0926C4FD5DE	OBJECT_OR_COLUMN
dbo	GEN_FTEYA0EB22774E297DA91E86F4	OBJECT_OR_COLUMN
dbo	GEN_FTEYA17794B9D95EE8DD144E94	OBJECT_OR_COLUMN
dbo	GEN_FTEYA5065182EC53F911A8AB59	OBJECT_OR_COLUMN
dbo	GEN_FTEYA60CCE102C52A5B0014C2D	OBJECT_OR_COLUMN
dbo	GEN_FTEYA98DB5E80EFE54297AA0A8	OBJECT_OR_COLUMN
dbo	GEN_FTEYAC13F21E0D4DB4DD55310E	OBJECT_OR_COLUMN
dbo	GEN_FTEYACAC5700ABF0D42F65529A	OBJECT_OR_COLUMN
dbo	GEN_FTEYAD3637368C48BBEA6B8D71	OBJECT_OR_COLUMN
dbo	GEN_FTEYAD6AB0B9B040433F113D36	OBJECT_OR_COLUMN
dbo	GEN_FTEYAF3582CAD04010AC5744C9	OBJECT_OR_COLUMN
dbo	GEN_FTEYAFC2B1B0AA231EB7202E0A	OBJECT_OR_COLUMN
dbo	GEN_FTEYB5B79D3FB317B463216F71	OBJECT_OR_COLUMN
dbo	GEN_FTEYB5C2BEFDF41A038B6E4E8F	OBJECT_OR_COLUMN
dbo	GEN_FTEYB7D9F2A88D2BEE2704FF81	OBJECT_OR_COLUMN
dbo	GEN_FTEYB84C3B21509F1AA07885F7	OBJECT_OR_COLUMN
dbo	GEN_FTEYB8BBCF8E8E26BBED8671F5	OBJECT_OR_COLUMN
dbo	GEN_FTEYBC1B1E1153DA0887D6F11C	OBJECT_OR_COLUMN
dbo	GEN_FTEYBE4C4D5B55E47B4A37030F	OBJECT_OR_COLUMN
dbo	GEN_FTEYC455A197F1F99E91DE3119	OBJECT_OR_COLUMN
dbo	GEN_FTEYC50E4CC8188C7D5B7DCD71	OBJECT_OR_COLUMN
dbo	GEN_FTEYCACD53376979AEB4951686	OBJECT_OR_COLUMN
dbo	GEN_FTEYCB57F36D8B554BDAEF804B	OBJECT_OR_COLUMN
dbo	GEN_FTEYCECC6DB926BCF9648F456B	OBJECT_OR_COLUMN
dbo	GEN_FTEYD067DDDE01113A49AB7F4F	OBJECT_OR_COLUMN
dbo	GEN_FTEYD1337EF6C6FC4CB197D0D2	OBJECT_OR_COLUMN
dbo	GEN_FTEYD1570666C15F0F46905354	OBJECT_OR_COLUMN
dbo	GEN_FTEYD1C52DE6CB749CD02A401C	OBJECT_OR_COLUMN
dbo	GEN_FTEYD1FF94E385FADA2276090E	OBJECT_OR_COLUMN
dbo	GEN_FTEYD5D72E6FA335696FA50D11	OBJECT_OR_COLUMN
dbo	GEN_FTEYD9E45B5BA3CF3011E79360	OBJECT_OR_COLUMN
dbo	GEN_FTEYD9F80E09EE41CB3418962A	OBJECT_OR_COLUMN
dbo	GEN_FTEYDAF6E4727A8EAE717E59D7	OBJECT_OR_COLUMN
dbo	GEN_FTEYDE839AC5FDDF3A157A16AF	OBJECT_OR_COLUMN
dbo	GEN_FTEYDEBA0F85E016415BA14437	OBJECT_OR_COLUMN
dbo	GEN_FTEYE3300D332EFDFCD61A0A1F	OBJECT_OR_COLUMN
dbo	GEN_FTEYE5C106C07A55319D2D1F4C	OBJECT_OR_COLUMN
dbo	GEN_FTEYE80DDBCEAAA13F1979E711	OBJECT_OR_COLUMN
dbo	GEN_FTEYEB1C7B5195AE3821552788	OBJECT_OR_COLUMN
dbo	GEN_FTEYECAD876E5948B1A0FEF889	OBJECT_OR_COLUMN
dbo	GEN_FTEYED8E405E523D8D627BD65F	OBJECT_OR_COLUMN
dbo	GEN_FTEYF021722B8C41E69A21F5BA	OBJECT_OR_COLUMN
dbo	GEN_FTEYF1D845A502E28AB8F8B8FA	OBJECT_OR_COLUMN
dbo	GEN_FTEYF4FA37E77329315C33C8D5	OBJECT_OR_COLUMN
dbo	GEN_FTEYF56DD909CB94BEEC756652	OBJECT_OR_COLUMN
dbo	GEN_FTEYF61C4144CE8FABBC866272	OBJECT_OR_COLUMN
dbo	GEN_FTEYF634ACF893A3AC13026A99	OBJECT_OR_COLUMN
dbo	GEN_FTEYF710376B9619AA2464A2B2	OBJECT_OR_COLUMN
dbo	GEN_FTEYF7783E5B8726C9CAE353D8	OBJECT_OR_COLUMN
dbo	GEN_FTEYF919254F951A7A5DF6B821	OBJECT_OR_COLUMN
dbo	GEN_FTEYF9571F25A9F1882987B829	OBJECT_OR_COLUMN
dbo	GEN_FTEYF9B5B0718078CC8E220CB4	OBJECT_OR_COLUMN
dbo	GEN_FTEYFA544B1011E4A042348A0E	OBJECT_OR_COLUMN
dbo	GEN_FTEYFAEF8CACEA5085E028D489	OBJECT_OR_COLUMN
dbo	GEN_FTEYFCC9AEDF028F5733EA1762	OBJECT_OR_COLUMN
dbo	GEN_FTEYFECC3EA95617D69C0478E1	OBJECT_OR_COLUMN
dbo	GEN_FTEYFED8D3214C9C1DAFEE2EB0	OBJECT_OR_COLUMN
dbo	GEN_FTEYFF99B6B069C342288C6BA9	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_FTEntitlementSourceWhy(
2											@UID_Person varchar(38) 
3											, @ObjectKeyToInspect varchar(138)
4											)
5	returns @erg table (
6						ObjectKeyReason1 varchar(138) collate database_default
7						, ObjectKeyReason2 varchar(138) collate database_default
8						)
9 as
10begin
11
12	if @ObjectKeyToInspect like '<Key><T>ADSAccount</T>%'
13	 begin
14	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
15	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
16	   from dbo.GEN_FTEY04ACC922CE0D679BFBDF68 (@uid_person, @ObjectKeyToInspect) as xx
17
18	   goto EndLabel
19
20	 end -- ADSAccount
21
22	if @ObjectKeyToInspect like '<Key><T>ADSAccountInADSGroup</T>%'
23	 begin
24	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
25	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
26	   from dbo.GEN_FTEYBC1B1E1153DA0887D6F11C (@uid_person, @ObjectKeyToInspect) as xx
27
28	   goto EndLabel
29
30	 end -- ADSAccountInADSGroup
31
32	if @ObjectKeyToInspect like '<Key><T>ADSContact</T>%'
33	 begin
34	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
35	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
36	   from dbo.GEN_FTEYAFC2B1B0AA231EB7202E0A (@uid_person, @ObjectKeyToInspect) as xx
37
38	   goto EndLabel
39
40	 end -- ADSContact
41
42	if @ObjectKeyToInspect like '<Key><T>ADSContactInADSGroup</T>%'
43	 begin
44	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
45	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
46	   from dbo.GEN_FTEY6CF75B30295FEFA8CD3709 (@uid_person, @ObjectKeyToInspect) as xx
47
48	   goto EndLabel
49
50	 end -- ADSContactInADSGroup
51
52	if @ObjectKeyToInspect like '<Key><T>ADSContainer</T>%'
53	 begin
54	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
55	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
56	   from dbo.GEN_FTEYD067DDDE01113A49AB7F4F (@uid_person, @ObjectKeyToInspect) as xx
57
58	   goto EndLabel
59
60	 end -- ADSContainer
61
62	if @ObjectKeyToInspect like '<Key><T>ADSDomain</T>%'
63	 begin
64	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
65	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
66	   from dbo.GEN_FTEYD1FF94E385FADA2276090E (@uid_person, @ObjectKeyToInspect) as xx
67
68	   goto EndLabel
69
70	 end -- ADSDomain
71
72	if @ObjectKeyToInspect like '<Key><T>ADSGroup</T>%'
73	 begin
74	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
75	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
76	   from dbo.GEN_FTEYEB1C7B5195AE3821552788 (@uid_person, @ObjectKeyToInspect) as xx
77
78	   goto EndLabel
79
80	 end -- ADSGroup

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

None extracted.

Summary: writes INSERT into; reads/joins GEN_FTEY04ACC922CE0D679BFBDF68, GEN_FTEYBC1B1E1153DA0887D6F11C, GEN_FTEYAFC2B1B0AA231EB7202E0A, GEN_FTEY6CF75B30295FEFA8CD3709, GEN_FTEYD067DDDE01113A49AB7F4F…

Declared parameters

Parameter	Type	Direction
`@UID_Person`	`varchar(38)`	input
`@ObjectKeyToInspect`	`varchar(138)`	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 @ObjectKeyToInspect @erg @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.