dbo.QBM_FGIXOriginChanged_Effect

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:57:01.660 · modified 2026-04-14T23:14:10.553 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
bityes
@XOriginOldintno
@XOriginNewintno
@XIsInEffectOldbitno
@XIsInEffectNewbitno

Referenced objects

SchemaObjectColumn/minorClass
No SQL expression dependencies in snapshot.

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.QBM_FGIXOriginChanged_Effect (@XOriginOld int , @XOriginNew int , @XIsInEffectOld bit , @XIsInEffectNew bit ) returns
2 bit with SCHEMABINDING as begin return ( (sign(@XOriginOld) & sign(convert(int, @XIsInEffectOld))) ^ (sign(@XOriginNew) & sign(convert(int, @XIsInEffectNew
3))) ) end 
4

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:14:10.553

None extracted.

Summary: No calls/DML/dependency patterns extracted by the current parser.

Declared parameters

ParameterTypeDirection
bitOUTPUT
@XOriginOldintinput
@XOriginNewintinput
@XIsInEffectOldbitinput
@XIsInEffectNewbitinput

DML targets

None extracted.

Called routines

None extracted.

Read/join references

None extracted.

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @XOriginOld @XOriginNew @XIsInEffectOld @XIsInEffectNew

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.

Referencing objectRelationEvidence
dbo.ADS_TUADSAccountInADSGroupSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TUADSContactInADSGroupSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TUBaseTreeHasADSGroupSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TUHelperHeadOrgSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T502565353D4716D18CD190BF8SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T50FDADCCF5FF5953D3C5CDE3FSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T52819732AD9162A7E270A272ESQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5353FF58B0B2681FBC37AB5BESQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T53CD36EA9E5796F7797A46641SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5520BD220624D98637D86D5E3SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T553B9FB5AC14B225E0456AC15SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T55870560D013ECC8B97535914SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T56F3B6D6D79DDA47EF70C2DB2SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T577565B77F38638D05A8B603CSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T586345931225D1263A0DC4DB5SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5B2CFE3130A4D73386393DAC8SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5C8317E6E6DA290D604CB8F6DSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5CFD1B173A2279589C6E3B7ABSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5DEC3B8B413163D8D6070A959SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.LDP_TUBaseTreeHasLDAPGroupSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.LDP_TULDAPAccountInLDAPGroupSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERAssignSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERResourceSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERReuseSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERReuseUSSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUHardwareInBaseTreeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUHelperHeadOrgSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUHelperHeadPersonSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUPersonHasQERAssignSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUPersonHasQERResourceSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUPersonHasQERReuseSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUPersonHasQERReuseUSSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUPersonInBaseTreeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUWorkDeskInBaseTreeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RMS_TUBaseTreeHasESetSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RMS_TUESetHasEntitlementSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RMS_TUPersonHasESetSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RMS_TUWorkDeskHasESetSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RPS_TUBaseTreeHasRPSReportSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RPS_TUPersonHasRPSReportSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasTSBAccountDefSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupB1SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupB2SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupB3SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUPersonHasTSBAccountDefSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBHasUNSGroupBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBHasUNSGroupB1SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBHasUNSGroupB2SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBHasUNSGroupB3SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBInUNSGroupBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBInUNSGroupB1SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBInUNSGroupB2SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSAccountBInUNSGroupB3SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TUUNSGroupBHasUNSItemBSQL expression dependencydbo · OBJECT_OR_COLUMN