DBQueue route matrix

Source-derived matrix of insert routine calls by task-family prefix observed in the same SQL module.

31routesroutine × family

6insert routinesQBM_PDBQueueInsert*

13familiestask prefixes

640caller modulessource-derived

Filter routine, family, task, or module

Matrix

Insert routine	QBM	QER	TSB	ADS	LDP	ATT	unknown	CPL	RMS	RPS	POL	DPR
QBM_PDBQueueInsert_Bulk	142 61 tasks	120 52 tasks	92 21 tasks	46 8 tasks	38 7 tasks	26 11 tasks	12 0 tasks	13 8 tasks	16 7 tasks	12 6 tasks	4 2 tasks	3 1 tasks
QBM_PDBQueueInsert_Single	132 56 tasks	29 34 tasks	6 5 tasks	4 5 tasks	3 2 tasks	7 7 tasks	1 0 tasks	3 4 tasks	—	1 1 tasks	—	—
QBM_PDBQueueInsert_bulk	4 5 tasks	7 3 tasks	—	—	—	3 1 tasks	—	—	—	—	—	—
QBM_PDBQueueInsert_WaitForComp	7 12 tasks	—	—	—	—	—	3 0 tasks	—	—	—	—	—
QBM_PDBQueueInsert_single	3 1 tasks	1 2 tasks	—	—	—	—	1 0 tasks	—	—	—	—	—
QBM_PDBQueueInsert_Int	—	—	—	—	—	—	3 0 tasks	—	—	—	—	—

QBM_PDBQueueInsert_Bulk → QBM 142 callers

61 task markers · 39 DML target patterns · 8 config refs

Tasks: QBM-K-All, QBM-K-BaseMigrationReady, QBM-K-BufferTProcessDelete, QBM-K-BufferTProcessTable, QBM-K-BufferTProcessTablePU, QBM-K-CommonCountryUTCOffset, QBM-K-CommonDashboard, QBM-K-CommonDashboardDef

dbo.QBM_PJobUpdateState_Bulk SQL_STORED_PROCEDURE · score 278.081
dbo.ADS_TUAdsGroup SQL_TRIGGER · score 257.541
dbo.QER_TUBaseTree SQL_TRIGGER · score 252.619
dbo.QER_ZAllForPersonInBaseTree SQL_STORED_PROCEDURE · score 216.715
dbo.QBM_ZPrePropTable SQL_STORED_PROCEDURE · score 203.719
dbo.QER_TUPerson SQL_TRIGGER · score 198.058

QBM_PDBQueueInsert_Single → QBM 132 callers

56 task markers · 35 DML target patterns · 9 config refs

Tasks: QBM-K-All, QBM-K-BaseMigrationReady, QBM-K-BufferTProcessDelete, QBM-K-BufferTProcessModule, QBM-K-BufferTProcessModulePU, QBM-K-BufferTProcessTable, QBM-K-BufferTProcessTablePU, QBM-K-CheckRIAll

dbo.ADS_TUAdsGroup SQL_TRIGGER · score 257.541
dbo.QER_TUBaseTree SQL_TRIGGER · score 252.619
dbo.QER_ZAllForPersonInBaseTree SQL_STORED_PROCEDURE · score 216.715
dbo.QER_TUPerson SQL_TRIGGER · score 198.058
dbo.QBM_PDBQueueInsert_Int SQL_STORED_PROCEDURE · score 159.795
dbo.QBM_PTableReload SQL_STORED_PROCEDURE · score 158.903

QBM_PDBQueueInsert_Bulk → QER 120 callers

52 task markers · 33 DML target patterns · 18 config refs

Tasks: QER-K-AccProductGroupCollection, QER-K-AllChildrenOfOrg, QER-K-AllForOneHardware, QER-K-AllForOneOrg, QER-K-AllForOnePerson, QER-K-AllForOneWorkdesk, QER-K-AllForPersonInBaseTree, QER-K-BaseTreeCollectionF

dbo.QER_PITShopHelperFill_bulk SQL_STORED_PROCEDURE · score 340.779
dbo.QER_TUPersonWantsOrg SQL_TRIGGER · score 252.836
dbo.QER_TUBaseTree SQL_TRIGGER · score 252.619
dbo.QER_ZITShopCheckDecision SQL_STORED_PROCEDURE · score 248.726
dbo.QER_ZAllForPersonInBaseTree SQL_STORED_PROCEDURE · score 216.715
dbo.QER_TUPerson SQL_TRIGGER · score 198.058

QBM_PDBQueueInsert_Bulk → TSB 92 callers

21 task markers · 6 DML target patterns · 3 config refs

Tasks: TSB-K-BaseTreeHasObject, TSB-K-BaseTreeOwnsObject, TSB-K-OrgHasTSBAccountDef, TSB-K-OrgHasUNSGroupB, TSB-K-OrgHasUNSGroupB1, TSB-K-OrgHasUNSGroupB2, TSB-K-OrgHasUNSGroupB3, TSB-K-PERSONHASTSBAccountDef

dbo.TSB_TUDPRNameSpace SQL_TRIGGER · score 125.172
dbo.TSB_TUUNSGroupB1 SQL_TRIGGER · score 122.72
dbo.TSB_TUUNSGroupB2 SQL_TRIGGER · score 122.72
dbo.TSB_TUUNSGroupB3 SQL_TRIGGER · score 122.72
dbo.TSB_TUUNSGroupB SQL_TRIGGER · score 122.689
dbo.TSB_TUTSBAccountDef SQL_TRIGGER · score 121.322

QBM_PDBQueueInsert_Bulk → ADS 46 callers

8 task markers · 14 DML target patterns · 4 config refs

Tasks: ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSGroupInADSGroup, ADS-K-ADSMachineInADSGroup, ADS-K-BaseTreeHasObject, ADS-K-BaseTreeOwnsObject, ADS-K-OrgHasADSGroup, ADS-K-PersonHasObject

dbo.ADS_TUAdsGroup SQL_TRIGGER · score 257.541
dbo.ADS_TIBaseTreeHasADSGroup SQL_TRIGGER · score 123.865
dbo.ADS_ZOrgHasADSGroup SQL_STORED_PROCEDURE · score 115.885
dbo.ADS_TUBaseTreeHasADSGroup SQL_TRIGGER · score 113.573
dbo.ADS_TUADSAccount SQL_TRIGGER · score 93.785
dbo.ADS_TIADSGroupExclusion SQL_TRIGGER · score 91.411

QBM_PDBQueueInsert_Bulk → LDP 38 callers

7 task markers · 10 DML target patterns · 4 config refs

Tasks: LDP-K-BaseTreeHasObject, LDP-K-BaseTreeOwnsObject, LDP-K-LDAPAccountInLDAPGroup, LDP-K-LDAPGroupInLDAPGroup, LDP-K-LDPMachineInLDAPGroup, LDP-K-OrgHasLDAPGroup, LDP-K-PersonHasObject

dbo.LDP_TULDAPGroup SQL_TRIGGER · score 164.164
dbo.LDP_ZOrgHasLDAPGroup SQL_STORED_PROCEDURE · score 117.963
dbo.LDP_TIBaseTreeHasLDAPGroup SQL_TRIGGER · score 114.553
dbo.LDP_TUBaseTreeHasLDAPGroup SQL_TRIGGER · score 103.954
dbo.LDP_TILDAPGroupExclusion SQL_TRIGGER · score 81.869
dbo.LDP_TULDAPAccountInLDAPGroup SQL_TRIGGER · score 75.27

QBM_PDBQueueInsert_Single → QER 29 callers

34 task markers · 18 DML target patterns · 12 config refs

dbo.QER_TUBaseTree SQL_TRIGGER · score 252.619
dbo.QER_ZAllForPersonInBaseTree SQL_STORED_PROCEDURE · score 216.715
dbo.QER_TUPerson SQL_TRIGGER · score 198.058
dbo.QER_PAfterMigrationTasks SQL_STORED_PROCEDURE · score 155.764
dbo.QER_TUHelperHeadOrg SQL_TRIGGER · score 154.457
dbo.QER_ZITShopDeleteClosed SQL_STORED_PROCEDURE · score 138.747

QBM_PDBQueueInsert_Bulk → ATT 26 callers

11 task markers · 8 DML target patterns · 4 config refs

Tasks: ATT-K-Attestation-ABORT, ATT-K-Attestation-RESET, ATT-K-AttestationCheckValid, ATT-K-AttestationHelper, ATT-K-AttestationHelper-Cfg, ATT-K-AttestationHelperNewLevel, ATT-K-AttestationMakeDecisionEX, ATT-K-AttestationReminder

dbo.ATT_ZAttestationCheckValid SQL_STORED_PROCEDURE · score 157.942
dbo.ATT_TUPerson SQL_TRIGGER · score 110.357
dbo.ATT_TUAttestationCase SQL_TRIGGER · score 107.815
dbo.ATT_ZAttestationReset SQL_STORED_PROCEDURE · score 101.871
dbo.ATT_TUAttestationPolicy SQL_TRIGGER · score 96.831
dbo.ATT_ZAllForPersonInBaseTree SQL_STORED_PROCEDURE · score 88.403

QBM_PDBQueueInsert_Bulk → RMS 16 callers

7 task markers · 7 DML target patterns · 1 config refs

Tasks: RMS-K-BaseTreeHasObject, RMS-K-ESetCollection, RMS-K-ESetHasEntitlement, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-PersonHasObject, RMS-K-WorkdeskHasESet

dbo.RMS_ZESetCollection SQL_STORED_PROCEDURE · score 157.123
dbo.RMS_TUESet SQL_TRIGGER · score 155.504
dbo.RMS_TIESetHasEntitlement SQL_TRIGGER · score 121.398
dbo.RMS_TIBaseTreeHasESet SQL_TRIGGER · score 118.553
dbo.RMS_TUESetHasEntitlement SQL_TRIGGER · score 110.845
dbo.RMS_TUBaseTreeHasESet SQL_TRIGGER · score 107.535

QBM_PDBQueueInsert_Bulk → CPL 13 callers

8 task markers · 12 DML target patterns · 8 config refs

Tasks: CPL-K-ComplianceCheckForPerson, CPL-K-ComplianceCheckForRule, CPL-K-ComplianceCheckMakeProc, CPL-K-ComplianceSubRuleFillObject, CPL-K-ComplianceSubRuleFillPerson, CPL-K-ComplianceSubRuleFillPersonS, CPL-K-ShoppingRackMakeDecisionOC, CPL-K-ShoppingRackMakeDecisionOH

dbo.QER_PITShopHelperFill_bulk SQL_STORED_PROCEDURE · score 340.779
dbo.CPL_TUComplianceRule SQL_TRIGGER · score 101.7
dbo.CPL_TDComplianceRule SQL_TRIGGER · score 71.782
dbo.CPL_TUPerson SQL_TRIGGER · score 64.204
dbo.CPL_TIComplianceRule SQL_TRIGGER · score 56.706
dbo.CPL_PAfterMigrationTasks SQL_STORED_PROCEDURE · score 56.61

QBM_PDBQueueInsert_Bulk → RPS 12 callers

6 task markers · 5 DML target patterns · 1 config refs

Tasks: RPS-K-AllForOneRPSReport, RPS-K-BaseTreeHasObject, RPS-K-OrgHasRPSReport, RPS-K-PersonHasObject, RPS-K-PersonHasRPSReport, RPS-K-PrepropRPSReport

dbo.RPS_TURPSReport SQL_TRIGGER · score 114.914
dbo.RPS_ZOrgHasRPSReport SQL_STORED_PROCEDURE · score 104.234
dbo.RPS_TIBaseTreeHasRPSReport SQL_TRIGGER · score 88.218
dbo.RPS_TUBaseTreeHasRPSReport SQL_TRIGGER · score 77.459
dbo.RPS_TIPersonHasRPSReport SQL_TRIGGER · score 63.119
dbo.RPS_ZAllForOneRPSReport SQL_STORED_PROCEDURE · score 62.725

QBM_PDBQueueInsert_Bulk → unknown 12 callers

0 task markers · 14 DML target patterns · 7 config refs

Tasks: n/a

dbo.QBM_PDBQCS_SlotRunner SQL_STORED_PROCEDURE · score 189.771
dbo.QBM_PDBQueueCalculateDelta SQL_STORED_PROCEDURE · score 176.2
dbo.QBM_FSQFKCheckFix SQL_SCALAR_FUNCTION · score 140.873
dbo.QER_ZITShopHelperFill_Recalc SQL_STORED_PROCEDURE · score 88.642
dbo.QER_PPersonHasObjectPostProc SQL_STORED_PROCEDURE · score 86.491
dbo.ATT_ZAttHelperFill_Recalc SQL_STORED_PROCEDURE · score 82.394

QBM_PDBQueueInsert_bulk → QER 7 callers

3 task markers · 4 DML target patterns · 0 config refs

Tasks: QER-K-OrgROOT, QER-K-PWODecisionRuleMakeProc, QER-K-PWOHelperFillMakeProc

dbo.QER_TUPWODecisionRuleRulerDete SQL_TRIGGER · score 63.988
dbo.QER_TIPWODecisionRuleRulerDete SQL_TRIGGER · score 59.593
dbo.QER_TUOrgRoot SQL_TRIGGER · score 50.88
dbo.QER_TDPWODecisionRuleRulerDete SQL_TRIGGER · score 42.919
dbo.QER_TUPWODecisionRule SQL_TRIGGER · score 37.683
dbo.QER_TIPWODecisionRule SQL_TRIGGER · score 35.636

QBM_PDBQueueInsert_Single → ATT 7 callers

7 task markers · 7 DML target patterns · 2 config refs

Tasks: ATT-K-AttestationCheckValid, ATT-K-AttestationHelper, ATT-K-AttestationHelper-Cfg, ATT-K-AttestationRunDeleteOld, ATT-K-HelperAttestationPolicy, ATT-K-PrepropAttestationObject, ATT-K-PrepropAttestationWizardParm

dbo.ATT_PAttestationHelperFill SQL_STORED_PROCEDURE · score 232.157
dbo.ATT_TUPerson SQL_TRIGGER · score 110.357
dbo.ATT_ZAllForPersonInBaseTree SQL_STORED_PROCEDURE · score 88.403
dbo.ATT_PAfterMigrationTasks SQL_STORED_PROCEDURE · score 75.817
dbo.ATT_PAttestationCaseDeleteOld SQL_STORED_PROCEDURE · score 53.814
dbo.ATT_TUDialogConfigParm SQL_TRIGGER · score 42.914

QBM_PDBQueueInsert_WaitForComp → QBM 7 callers

12 task markers · 8 DML target patterns · 1 config refs

Tasks: QBM-K-CommonMakeWatchtrigger, QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropColumnFK, QBM-K-CommonPrepropJob, QBM-K-CommonPrepropJobChain, QBM-K-CommonPrepropObject, QBM-K-CommonPrepropSheet, QBM-K-CommonPrepropTable

dbo.QBM_ZPrePropTable SQL_STORED_PROCEDURE · score 203.719
dbo.QBM_ZPrePropColumn SQL_STORED_PROCEDURE · score 98.089
dbo.QBM_ZPrePropTree SQL_STORED_PROCEDURE · score 88.194
dbo.QBM_ZPrePropObject SQL_STORED_PROCEDURE · score 84.971
dbo.QBM_ZPrePropTreeResult SQL_STORED_PROCEDURE · score 78.085
dbo.QBM_ZPrePropJobChain SQL_STORED_PROCEDURE · score 73.375

QBM_PDBQueueInsert_Single → TSB 6 callers

5 task markers · 13 DML target patterns · 0 config refs

Tasks: TSB-K-BaseTreeOwnsObject, TSB-K-UNSGroupB1InUNSGroupB1-C, TSB-K-UNSGroupB2InUNSGroupB2-C, TSB-K-UNSGroupB3InUNSGroupB3-C, TSB-K-UNSGroupBInUNSGroupB-C

dbo.TSB_ZUNSGroupB1InUNSGroupB1 SQL_STORED_PROCEDURE · score 117.058
dbo.TSB_ZUNSGroupB2InUNSGroupB2 SQL_STORED_PROCEDURE · score 117.058
dbo.TSB_ZUNSGroupB3InUNSGroupB3 SQL_STORED_PROCEDURE · score 117.058
dbo.TSB_ZUNSGroupBInUNSGroupB SQL_STORED_PROCEDURE · score 117.017
dbo.TSB_ZBaseTreeOwnsObjectPrepair SQL_STORED_PROCEDURE · score 44.078
dbo.TSB_PAfterMigrationTasks SQL_STORED_PROCEDURE · score 41.985

QBM_PDBQueueInsert_bulk → QBM 4 callers

5 task markers · 3 DML target patterns · 1 config refs

Tasks: QBM-K-CommonConfigParm, QBM-K-CommonReCalculate, QBM-K-CommonStateUTCOffset2, QBM-K-PrepropGenerateFunction, QBM-K-ScriptAssemblyReset

dbo.QBM_TUDialogConfigParm SQL_TRIGGER · score 66.824
dbo.QBM_ZStateUTCOffset SQL_STORED_PROCEDURE · score 59.263
dbo.QBM_TUAssembly_DialogScript SQL_TRIGGER · score 39.883
dbo.QBM_ZScheduleStartTask SQL_STORED_PROCEDURE · score 34.869

QBM_PDBQueueInsert_Bulk → POL 4 callers

2 task markers · 4 DML target patterns · 0 config refs

Tasks: POL-K-QERPolicyFill, POL-K-QERPolicyMakeProc

dbo.POL_TUQERPolicy SQL_TRIGGER · score 74.143
dbo.POL_TIQERPolicy SQL_TRIGGER · score 51.16
dbo.POL_TDQERPolicy SQL_TRIGGER · score 41.859
dbo.POL_ZScheduleStart SQL_STORED_PROCEDURE · score 34.682

QBM_PDBQueueInsert_Single → ADS 4 callers

5 task markers · 14 DML target patterns · 0 config refs

Tasks: ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSGroupInADSGroup-Circ, ADS-K-ADSMachineInADSGroup, ADS-K-BaseTreeOwnsObject

dbo.ADS_TUAdsGroup SQL_TRIGGER · score 257.541
dbo.ADS_ZGroupInADSGroup SQL_STORED_PROCEDURE · score 114.805
dbo.ADS_ZBaseTreeOwnsObjectPrepair SQL_STORED_PROCEDURE · score 44.076
dbo.ADS_PAfterMigrationTasks SQL_STORED_PROCEDURE · score 43.985

QBM_PDBQueueInsert_bulk → ATT 3 callers

1 task markers · 4 DML target patterns · 0 config refs

Tasks: ATT-K-AttHelperFillMakeProc

dbo.ATT_TUPWODecisionRuleRulerDete SQL_TRIGGER · score 37.711
dbo.ATT_TIPWODecisionRuleRulerDete SQL_TRIGGER · score 35.664
dbo.ATT_TDPWODecisionRuleRulerDete SQL_TRIGGER · score 35.658

QBM_PDBQueueInsert_Bulk → DPR 3 callers

1 task markers · 5 DML target patterns · 0 config refs

Tasks: DPR-K-TriggerCreateMembership

dbo.DPR_TUDPRNameSpaceHasDialogTab SQL_TRIGGER · score 68.987
dbo.DPR_TIDPRNameSpaceHasDialogTab SQL_TRIGGER · score 59.434
dbo.DPR_TDDPRNameSpaceHasDialogTab SQL_TRIGGER · score 35.692

QBM_PDBQueueInsert_Bulk → RMB 3 callers

3 task markers · 2 DML target patterns · 0 config refs

Tasks: RMB-K-HelperHardwareOrg, RMB-K-HelperPersonOrg, RMB-K-HelperWorkdeskOrg

dbo.RMB_TUPerson SQL_TRIGGER · score 50.211
dbo.RMB_TUHardware SQL_TRIGGER · score 47.958
dbo.RMB_TUWorkDesk SQL_TRIGGER · score 40.078

QBM_PDBQueueInsert_Int → unknown 3 callers

0 task markers · 2 DML target patterns · 0 config refs

Tasks: n/a

dbo.QBM_PDBQueueInsert_Bulk SQL_STORED_PROCEDURE · score 71.839
dbo.QBM_P40B0C8AE71E45BA9C883A96_ SQL_STORED_PROCEDURE · score 25.596
dbo.QBM_P1B7262FC192C886D0EB9F74_ SQL_STORED_PROCEDURE · score 17.415

QBM_PDBQueueInsert_single → QBM 3 callers

1 task markers · 3 DML target patterns · 0 config refs

Tasks: QBM-K-CommonIncSemaphor

dbo.QBM_TUDialogMultiLanguage SQL_TRIGGER · score 39.515
dbo.QBM_TIDialogMultiLanguage SQL_TRIGGER · score 32.76
dbo.QBM_TDDialogMultiLanguage SQL_TRIGGER · score 30.671

QBM_PDBQueueInsert_Single → CPL 3 callers

4 task markers · 2 DML target patterns · 0 config refs

Tasks: CPL-K-ComplianceCheckForRule, CPL-K-ComplianceCheckMakeProc, CPL-K-ComplianceSubRuleFillObject, CPL-K-ComplianceSubRuleFillPerson

dbo.CPL_PAfterMigrationTasks SQL_STORED_PROCEDURE · score 56.61
dbo.CPL_TUDialogConfigParm SQL_TRIGGER · score 37.802
dbo.CPL_ZComplianceCheckMakeProc SQL_STORED_PROCEDURE · score 37.701

QBM_PDBQueueInsert_Single → LDP 3 callers

2 task markers · 4 DML target patterns · 0 config refs

Tasks: LDP-K-BaseTreeOwnsObject, LDP-K-LDAPGroupInLDAPGroup-Circ

dbo.LDP_ZGroupInLDAPGroup SQL_STORED_PROCEDURE · score 114.837
dbo.LDP_ZBaseTreeOwnsObjectPrepair SQL_STORED_PROCEDURE · score 44.078
dbo.LDP_PAfterMigrationTasks SQL_STORED_PROCEDURE · score 44.057

QBM_PDBQueueInsert_WaitForComp → unknown 3 callers

0 task markers · 4 DML target patterns · 0 config refs

Tasks: n/a

dbo.QBM_ZPrePropSheet SQL_STORED_PROCEDURE · score 72.665
dbo.QBM_ZPrePropReport SQL_STORED_PROCEDURE · score 60.189
dbo.QBM_ZScriptAssemblyReset SQL_STORED_PROCEDURE · score 45.029

QBM_PDBQueueInsert_single → QER 1 callers

2 task markers · 1 DML target patterns · 0 config refs

Tasks: QER-K-OrgROOT, QER-K-OrgSubTree

dbo.QER_ZOrgInherite SQL_STORED_PROCEDURE · score 82.032

QBM_PDBQueueInsert_single → unknown 1 callers

0 task markers · 1 DML target patterns · 0 config refs

Tasks: n/a

dbo.QER_PITShopHelperFill_Recalc SQL_STORED_PROCEDURE · score 26.115

QBM_PDBQueueInsert_Single → RPS 1 callers

1 task markers · 1 DML target patterns · 0 config refs

Tasks: RPS-K-PrepropRPSReport

dbo.RPS_TUDialogConfigParm SQL_TRIGGER · score 37.795

QBM_PDBQueueInsert_Single → unknown 1 callers

0 task markers · 2 DML target patterns · 0 config refs

Tasks: n/a

dbo.QBM_PDBQCS_CurrentRestore SQL_STORED_PROCEDURE · score 149.37