dbo.DPR_FGIProjectionRootRunning
SQL_SCALAR_FUNCTION
Created 2025-06-27T18:01:03.047 · modified 2026-04-14T23:20:35.483 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| bit | yes |
@BaseTableName | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| DialogConfigParm | OBJECT_OR_COLUMN | ||
| DialogTable | OBJECT_OR_COLUMN | ||
| DPRProjectionConfigStep | OBJECT_OR_COLUMN | ||
| DPRProjectionStartInfo | OBJECT_OR_COLUMN | ||
| DPRRootObjConnectionInfo | OBJECT_OR_COLUMN | ||
| JobQueue | OBJECT_OR_COLUMN | ||
| QBM_YParameterList | TYPE | ||
| dbo | QBM_FCVStringToInt | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIConfigparmValue | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIUTCDate | 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.DPR_FGIProjectionRootRunning ( @BaseTableName varchar(30) ) returns bit AS begin declare @erg bit = 0 declare @MaxFSDuration 2 int declare @MaxFSDurationDefault int = 720 declare @Fullpath nvarchar(1000) = null declare @RunningSyncs QBM_YParameterList select top 1 @Fullpath = 3 cp.FullPath , @MaxFSDuration = dbo.QBM_FCVStringToInt(right(dbo.QBM_FGIConfigparmValue(cp.FullPath),6), @MaxFSDurationDefault) from DialogTable t join 4 DialogConfigParm cp on LEFT(t.UID_DialogTable, 3) = LEFT(cp.UID_ConfigParm, 3) where t.TableName = @BaseTableName and cp.FullPath like 'TargetSystem\%\MaxFullsyncDuration' 5 if isnull(@Fullpath, '') = '' begin select @MaxFSDuration = @MaxFSDurationDefault end if @MaxFSDuration > 10080 begin select @MaxFSDuration = 10080 end 6 insert into @RunningSyncs (Parameter1) select distinct si.XObjectKey from DPRRootObjConnectionInfo ci with (readpast) join DPRProjectionStartInfo si 7with (readpast) on ci.UID_DPRRootObjConnectionInfo = si.UID_DPRRootObjConnectionInfo where ci.ObjectKeyRoot like '<Key><T>' + @BaseTableName + '</T>%' 8and (exists ( select top 1 1 from DPRProjectionConfigStep cs where cs.UID_DPRProjectionConfig = si.UID_DPRProjectionConfig and cs.UID_LeftDPRSystemConnection 9 = ci.UID_DPRSystemConnection ) or exists ( select top 1 1 from DPRProjectionConfigStep cs where cs.UID_DPRProjectionConfig = si.UID_DPRProjectionConfig 10 and cs.UID_RightDPRSystemConnection = ci.UID_DPRSystemConnection ) ) and dateadd(mi, @MaxFSDuration, isnull(si.LastStart , '1899-12-30')) > dbo.QBM_FGIUTCDate 11() if @@ROWCOUNT > 0 begin if exists ( select top 1 1 from JobQueue Q with (readpast) join @RunningSyncs I on Q.BasisObjectKey = I.Parameter1 and q.JobChainName 12 = 'DPR_DPRProjectionStartInfo_Run_Synchronization' and Q.Ready2EXE in (N'TRUE', N'LOADED', N'PROCESSING') ) begin select @erg = 1 end end endLabel: return 13 (@erg) end 14
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:35.483
None extracted.
Summary: writes INSERT into; reads/joins DialogTable, DialogConfigParm, DPRRootObjConnectionInfo, DPRProjectionStartInfo, DPRProjectionConfigStep…; uses config TargetSystem\%\MaxFullsyncDuration
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| bit | OUTPUT |
@BaseTableName | varchar(30) | input |
DML targets
INSERT intoCalled routines
None extracted.
Read/join references
SQL dependency metadata
Config/session
Config: TargetSystem\%\MaxFullsyncDuration
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @BaseTableName @erg @MaxFSDuration @MaxFSDurationDefault @Fullpath @RunningSyncs @ROWCOUNT
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 object | Relation | Evidence |
|---|---|---|
| dbo.ADS_RAccountInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_RADSMachineInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_RContactInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_RGroupInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZAccountInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZADSMachineInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZContactInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_RAccountInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_RLDPMachineInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZAccountInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBHasUNSItemB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB1 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB2 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB3 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB1InUNSGroupB1 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB2InUNSGroupB2 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB3InUNSGroupB3 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupBHasUNSItemB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupBInUNSGroupB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |