DML target index

Generated from assets/oim-module-insights.json, which parses exported SQL module definitions. The index records only observed INSERT, UPDATE, and DELETE target tokens; it does not infer business behavior or execution paths.

190 targets1,376 modules with DML2,337 DML refsinsert 1,502update 511delete 324

Most referenced DML targets

into 1,135 modules

insert × 1,137

  • INSERT dbo.DPR_FGIProjectionRootRunning · writes INSERT into; reads/joins DialogTable, DialogConfigParm, DPRRootObjConnectionInfo, DPRProjectionStartInfo, DPRProjectionConfigStep…; uses config TargetSystem\%\MaxFullsyncDuration
  • INSERT dbo.DPR_FSQTriggerWatchMemberShip · calls QBM_PFESimulationFill; writes INSERT DPRMemberShipAction, INSERT into, DELETE nix, DELETE DPRMemberShipAction; reads/joins DPRMemberShipAction, DialogTable, QBM_VQBMRelation, DPRNameSpaceHasDialogTable, DialogColumn…
  • INSERT dbo.QBM_FCVDatetimeToNextWork · writes INSERT into; reads/joins DialogDatabase, DialogCountry, DialogState, dialogState, dialogcalendar; uses config QBM\WorkingHours\IgnoreHoliday, QBM\WorkingHours\IgnoreWeekend
  • INSERT dbo.QBM_FCVFKDollarToRelationMVP · writes INSERT into; reads/joins string_split, QBM_VQBMRelation, DialogTable
  • INSERT dbo.QBM_FCVJobParamDeflate · writes INSERT into; reads/joins QBM_FCVJobParameterToList; uses config Common\ProcessState\JobHistory\TrimLongParameters
  • INSERT dbo.QBM_FCVListToStringeMerge · writes INSERT into; reads/joins QBM_FCVStringToListSplitted
  • INSERT dbo.QBM_FCVListToStringeMergeSort · writes INSERT into; reads/joins QBM_FCVStringToListSplitted
  • INSERT dbo.QBM_FCVRelationMVPToFKDollar · writes INSERT into; reads/joins string_split, QBM_VQBMRelation

not 624 modules

insert × 221, update × 247, delete × 156

  • UPDATE dbo.ADS_TATTUADSAccount · calls QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted
  • UPDATE dbo.ADS_TATTUADSContainer · calls QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, basetree
  • UPDATE dbo.ADS_TATTUADSGroup · calls QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, AccProduct
  • UPDATE dbo.ADS_TATTUDomain · calls QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, basetree
  • UPDATE dbo.ADS_TCPLUADSContainer · calls QER_PITShopHelperFillAll, QBM_PSessionErrorAdd; writes UPDATE not; reads/joins inserted, deleted
  • UPDATE dbo.ADS_TCPLUDomain · calls QER_PITShopHelperFillAll, QBM_PSessionErrorAdd; writes UPDATE not; reads/joins inserted, deleted
  • DELETE dbo.ADS_TDADSAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, DELETE not, DELETE Accounts; reads/joins deleted, PersonHasTSBAccountDef, ADSOtherSID
  • DELETE dbo.ADS_TDADSContact · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE Accounts; reads/joins deleted, PersonHasTSBAccountDef

DialogColumn 26 modules

insert × 2, update × 22, delete × 6

  • INSERT dbo.QBM_PColumnAdd · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogTable, INSERT DialogColumn, UPDATE DialogColumn; reads/joins QBM_VSchemaColumns, INFORMATION_SCHEMA, sys, DialogTable, DialogColumn
  • UPDATE dbo.QBM_PColumnAdd · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogTable, INSERT DialogColumn, UPDATE DialogColumn; reads/joins QBM_VSchemaColumns, INFORMATION_SCHEMA, sys, DialogTable, DialogColumn
  • UPDATE dbo.QBM_PColumnChangeDataType · calls QBM_PTriggerDrop, QBM_PIndexDrop, QBM_PConstraintFKDrop, sp_rename, QBM_PColumnDrop…; writes UPDATE DialogColumn; reads/joins sys, DialogColumn, DialogTable, INFORMATION_SCHEMA
  • UPDATE dbo.QBM_PColumnCheckBlobExternal · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, UPDATE dialogcolumn; reads/joins DialogTable, dialogcolumn, information_schema, dialogtable, DialogColumn; uses session context GenProcID
  • DELETE dbo.QBM_PColumnCustomRemove · calls QBM_PIndexDrop, QBM_PJournal, QBM_PWaitForSeconds, QBM_PSessionErrorAdd, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, DELETE QBMRelation, DELETE DialogValidDynamicRef, DELETE DialogColumnGroupRight, DELETE DialogColumn…; reads/joins DialogTable, DialogColumn, DialogDatabase, INFORMATION_SCHEMA, sys…
  • DELETE dbo.QBM_PColumnDrop · calls QBM_PExecuteSQLWithRetry_LLP, sp_unbindefault, QBM_PIndexDrop, QBM_PSessionErrorAdd; writes DELETE DialogColumnGroupRight, DELETE DialogColumn; reads/joins sys, information_schema, QBM_VSchemaColumns, DialogColumnGroupRight, DialogColumn…
  • UPDATE dbo.QBM_PColumnRename · calls sp_rename, QBM_PSessionErrorAdd; writes UPDATE DialogColumn; reads/joins QBM_VSchemaColumns, sys, DialogColumn, DialogTable
  • UPDATE dbo.QBM_PColumnSchemaDataTypeCorr · calls QBM_PSessionErrorAdd; writes UPDATE DialogColumn; reads/joins DialogColumn, DialogTable, INFORMATION_SCHEMA

JobQueue 19 modules

insert × 3, update × 17, delete × 2

  • INSERT dbo.ATT_PAttestationCaseCreate · calls QER_PGIQERWorkingMethod, ATT_PAttestationCaseCreate_i, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobQueue, INSERT QBMElementAffectedByJob, UPDATE AttestationRun; reads/joins AttestationPolicy, QBM_FTHexPattern, AttestationRun; uses session context XUser
  • INSERT dbo.QBM_PDBQCS_SlotRunner · calls QBM_PTransactionLevelCheck, QBM_PJournal, slot, QBM_PSessionErrorAdd, QBM_PSessionContextSet…; writes INSERT JobQueue, INSERT QBMElementAffectedByJob, INSERT into; reads/joins sys, QBMDBQueueCurrent, QBMDBQueueTaskMetric, QBMVSystemOverview, set; uses config QBM\DBQueue\KeepAlive, QBM\DBQueue\DefaultRuntime; uses session context TempQueue
  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • INSERT dbo.QBM_PJobCreate · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT jobqueue, INSERT QBMElementAffectedByJob; reads/joins QBMServerHasServerTag, QBMServer, QBMJobqueueOverview, QBM_FTJobCreateDBParameter, JobQueue…; uses config Common\DBJobCreateWithFreeze; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PJobQueueDelete · calls QBM_PWaitForSeconds, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobHistory, INSERT JobQueueStats, UPDATE JobQueue, DELETE Jobqueue; reads/joins JobQueue, JobTreeParamColl, JobHistory; uses config Common\JobQueueStats
  • DELETE dbo.QBM_PJobQueueDelete · calls QBM_PWaitForSeconds, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobHistory, INSERT JobQueueStats, UPDATE JobQueue, DELETE Jobqueue; reads/joins JobQueue, JobTreeParamColl, JobHistory; uses config Common\JobQueueStats
  • DELETE dbo.QBM_PJobQueueDelete_Bulk · calls QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobHistory, DELETE Jobqueue; reads/joins JobQueue, JobTreeParamColl, JobHistory; uses config Common\ProcessState\JobHistory
  • UPDATE dbo.QBM_PJobQueueInit_i · calls QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PJobQueueSetSameServer, QBM_PQBMServerHasJobService, QBM_PSessionErrorAdd; writes INSERT QBMServer, INSERT into, UPDATE QBMServer, UPDATE QBMJobqueueOverview, UPDATE jobqueue…; reads/joins QBMServer, QBMServerHasServerTag, QBMJobqueueOverview, DialogDatabase, JobQueue…; uses config Common\Jobservice\AutoCreateServerFromQueues; uses session context XUser, GenProcID

dialogdatabase 16 modules

insert × 1, update × 16

  • UPDATE dbo.QBM_PDatabasePrepare · calls QBM_PDialogDatabaseInitialInfo, QBM_PDatabasePrepareCheck1, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT QBMServerTag, INSERT QBMServerHasServerTag, INSERT QBMServer, UPDATE DialogConfigParm, UPDATE dialogdatabase…; reads/joins dialogdatabase, DialogDatabase, QBMServerTag, QBMModuleDef, QBMServerHasServerTag…; uses config 5, 20
  • UPDATE dbo.QBM_PDatabasePrepare · calls QBM_PDialogDatabaseInitialInfo, QBM_PDatabasePrepareCheck1, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT QBMServerTag, INSERT QBMServerHasServerTag, INSERT QBMServer, UPDATE DialogConfigParm, UPDATE dialogdatabase…; reads/joins dialogdatabase, DialogDatabase, QBMServerTag, QBMModuleDef, QBMServerHasServerTag…; uses config 5, 20
  • UPDATE dbo.QBM_PDBQueueActivityDisable · calls QBM_PSessionContextSet, QBM_PSessionErrorClean, QBM_PSessionErrorAdd; writes UPDATE DialogDatabase; reads/joins sys; uses session context INSERTEDINTODBQUEUE
  • UPDATE dbo.QBM_PDBQueueActivityEnable · calls QBM_PSessionErrorAdd; writes UPDATE DialogDatabase
  • UPDATE dbo.QBM_PDBQueueExternalTaskFire · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE DialogDatabase, DELETE DialogDBQueue; reads/joins DialogDatabase; uses session context INSERTEDINTODBQUEUE
  • UPDATE dbo.QBM_PDBQueueInsert_Int · calls QBM_PSessionContextSet, QBM_PJournal, QBM_PSessionErrorAdd, QBM_PDBQueueInsert_Single; writes INSERT into, INSERT DialogDBQueue, UPDATE DialogDatabase; reads/joins QBMDBQueueTaskMetric, QBMDBQueueTask, DialogDBQueue, DialogTable; uses config Common\ProcessState; uses session context XUser, GenProcID, INSERTEDINTODBQUEUE
  • INSERT dbo.QBM_PDialogDatabaseInitialInfo · calls QBM_PSessionErrorAdd; writes INSERT dialogdatabase; reads/joins dialogdatabase
  • UPDATE dbo.QBM_PFESimulationEnd · calls QBM_PSessionErrorAdd; writes UPDATE Dialogdatabase

DialogTable 12 modules

insert × 2, update × 8, delete × 4

  • INSERT dbo.QBM_PColumnAdd · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogTable, INSERT DialogColumn, UPDATE DialogColumn; reads/joins QBM_VSchemaColumns, INFORMATION_SCHEMA, sys, DialogTable, DialogColumn
  • DELETE dbo.QBM_PColumnCustomRemove · calls QBM_PIndexDrop, QBM_PJournal, QBM_PWaitForSeconds, QBM_PSessionErrorAdd, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, DELETE QBMRelation, DELETE DialogValidDynamicRef, DELETE DialogColumnGroupRight, DELETE DialogColumn…; reads/joins DialogTable, DialogColumn, DialogDatabase, INFORMATION_SCHEMA, sys…
  • UPDATE dbo.QBM_PDatabasePrepareCheck1 · calls QBM_PColumnSchemaDataTypeCorr, QBM_PDialogTablePKNameCorrect, QBM_PTableRevisionFill, QBM_PSessionErrorAdd; writes UPDATE DialogTable, UPDATE dialogcolumn, UPDATE DialogColumn; reads/joins DialogColumn, DialogTable, dialogcolumn, QBM_FTPrimaryKeyInfo_BTVP
  • UPDATE dbo.QBM_PDialogTablePKNameCorrect · calls QBM_PSessionErrorAdd; writes UPDATE DialogTable; reads/joins DialogTable, QBM_FTPrimaryKeyInfo_BT, QBM_FTPrimaryKeyInfo_BTV, QBM_FTPrimaryKeyInfo_BTVP, dialogtable…
  • DELETE dbo.QBM_PModuleRemove · calls QBM_PDBQueueActivityDisable, QBM_PWatchDogPrepare, QBM_PFunctionDrop, QBM_PProcedureDrop, QBM_PViewDrop…; writes INSERT into, DELETE does, DELETE module, DELETE list, DELETE them…; reads/joins QBM_FCVStringToList, QBMModuleDef, QBMModuleDepend, sys, DialogTable…
  • UPDATE dbo.QBM_PQBMRelationCheck · calls QBM_PSessionErrorAdd; writes UPDATE QBMRelation, UPDATE DialogColumn, UPDATE DialogTable, UPDATE dialogtable; reads/joins QBMRelation, DialogColumn, DialogTable, QBM_FTRelationValidationInfo, QBM_VQBMRelation…
  • UPDATE dbo.QBM_PQBMRelationCheck · calls QBM_PSessionErrorAdd; writes UPDATE QBMRelation, UPDATE DialogColumn, UPDATE DialogTable, UPDATE dialogtable; reads/joins QBMRelation, DialogColumn, DialogTable, QBM_FTRelationValidationInfo, QBM_VQBMRelation…
  • INSERT dbo.QBM_PTableAdd · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogTable; reads/joins sys, DialogTable

pwohelperpwo 10 modules

insert × 1, update × 5, delete × 7

  • UPDATE dbo.CPL_ZITShopMakeDecisionOC · calls QBM_PJobCreate_HOCallMethod, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, UPDATE pwohelperpwo; reads/joins QBMDBQueueCurrent, personwantsorg, pwohelperpwo, HelperPWOCompliance, ComplianceRule…; uses config Common\ProcessState\UseGenProcIDFromPWO; uses session context GenProcID
  • UPDATE dbo.CPL_ZITShopMakeDecisionOH · calls QBM_PJobCreate_HOCallMethod, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, UPDATE PWOHelperPWO; reads/joins QBMDBQueueCurrent, personwantsorg, PWOHelperPWO, HelperPWOCompliance, ComplianceRule…; uses config Common\ProcessState\UseGenProcIDFromPWO; uses session context GenProcID
  • INSERT dbo.QER_PITShopHelperFill_bulk · calls as, QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QER_P04F128DC257D2B3C236MAIL_, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWODecisionHistory, INSERT PWOHelperPWO, UPDATE PersonWantsOrg, UPDATE PWOHelperPWO…; reads/joins PersonWantsOrg, QERWorkingStep, PWOHelperPWO, HelperPWOCompliance, ComplianceRule…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\PersonOrderedNoDecide, QER\ITShop\PersonInsertedNoDecide…; uses session context XUser, GenProcID
  • UPDATE dbo.QER_PITShopHelperFill_bulk · calls as, QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QER_P04F128DC257D2B3C236MAIL_, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWODecisionHistory, INSERT PWOHelperPWO, UPDATE PersonWantsOrg, UPDATE PWOHelperPWO…; reads/joins PersonWantsOrg, QERWorkingStep, PWOHelperPWO, HelperPWOCompliance, ComplianceRule…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\PersonOrderedNoDecide, QER\ITShop\PersonInsertedNoDecide…; uses session context XUser, GenProcID
  • DELETE dbo.QER_PITShopHelperFill_bulk · calls as, QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QER_P04F128DC257D2B3C236MAIL_, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWODecisionHistory, INSERT PWOHelperPWO, UPDATE PersonWantsOrg, UPDATE PWOHelperPWO…; reads/joins PersonWantsOrg, QERWorkingStep, PWOHelperPWO, HelperPWOCompliance, ComplianceRule…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\PersonOrderedNoDecide, QER\ITShop\PersonInsertedNoDecide…; uses session context XUser, GenProcID
  • DELETE dbo.QER_PITShopOrderMove_bulk · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID
  • UPDATE dbo.QER_PITShopOrderResetOneLevel · calls QBM_PSessionErrorAdd, QBM_PSessionContextSet; writes UPDATE PWOHelperPWO, DELETE PWOHelperPWO; reads/joins PWOHelperPWO, QERWorkingStep, PWODecisionRule; uses session context XUser, GenProcID
  • DELETE dbo.QER_PITShopOrderResetOneLevel · calls QBM_PSessionErrorAdd, QBM_PSessionContextSet; writes UPDATE PWOHelperPWO, DELETE PWOHelperPWO; reads/joins PWOHelperPWO, QERWorkingStep, PWODecisionRule; uses session context XUser, GenProcID

ADSOtherSID 9 modules

insert × 6, delete × 6

  • INSERT dbo.ADS_TDADSAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, DELETE not, DELETE Accounts; reads/joins deleted, PersonHasTSBAccountDef, ADSOtherSID
  • INSERT dbo.ADS_TDAdsGroup · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, DELETE not; reads/joins deleted, ADSOtherSID, adsaccountinadsgroup, adsaccount, ADSContactInADSGroup…
  • INSERT dbo.ADS_TDADSMachine · calls QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, DELETE not; reads/joins deleted, ADSOtherSID
  • DELETE dbo.ADS_TIADSAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, DELETE ADSOtherSID; reads/joins inserted, ADSGroup, ADSOtherSID
  • DELETE dbo.ADS_TIAdsGroup · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, DELETE ADSOtherSID; reads/joins inserted, ADSOtherSID
  • DELETE dbo.ADS_TIADSMachine · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, DELETE ADSOtherSID; reads/joins inserted, ADSOtherSID
  • INSERT dbo.ADS_TUADSAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE ADSAccountInADSGroup, DELETE ADSOtherSID; reads/joins inserted, deleted, ADSGroup, ADSAccount, ADSAccountInADSGroup…; uses session context Fullsync
  • DELETE dbo.ADS_TUADSAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE ADSAccountInADSGroup, DELETE ADSOtherSID; reads/joins inserted, deleted, ADSGroup, ADSAccount, ADSAccountInADSGroup…; uses session context Fullsync

QBMRelation 9 modules

insert × 2, update × 8, delete × 2

  • UPDATE dbo.QBM_PCheckSameCase_38 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMRelation; reads/joins QBMRelation, QBM_VQBMRelation, DialogColumn, dialogtable, QBM_VSchemaColumns…
  • DELETE dbo.QBM_PColumnCustomRemove · calls QBM_PIndexDrop, QBM_PJournal, QBM_PWaitForSeconds, QBM_PSessionErrorAdd, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, DELETE QBMRelation, DELETE DialogValidDynamicRef, DELETE DialogColumnGroupRight, DELETE DialogColumn…; reads/joins DialogTable, DialogColumn, DialogDatabase, INFORMATION_SCHEMA, sys…
  • UPDATE dbo.QBM_PQBMRelationCheck · calls QBM_PSessionErrorAdd; writes UPDATE QBMRelation, UPDATE DialogColumn, UPDATE DialogTable, UPDATE dialogtable; reads/joins QBMRelation, DialogColumn, DialogTable, QBM_FTRelationValidationInfo, QBM_VQBMRelation…
  • INSERT dbo.QBM_PQBMRelationExpand_One · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMRelation; reads/joins QBM_VQBMRelation, DialogTable, DialogColumn, QBMRelation
  • UPDATE dbo.QBM_PQBMRelationUserChangeCorr · calls QBM_PSessionErrorAdd; writes UPDATE QBMRelation; reads/joins QBMBufferConfig, QBMRelation
  • INSERT dbo.QBM_PRelationshipDefineManual · writes INSERT QBMRelation, UPDATE QBMRelation, UPDATE Qbmrelation, UPDATE qbmrelation; reads/joins DialogTable, DialogColumn, QBMRelation, qbmrelation, dialogcolumn…
  • UPDATE dbo.QBM_PRelationshipDefineManual · writes INSERT QBMRelation, UPDATE QBMRelation, UPDATE Qbmrelation, UPDATE qbmrelation; reads/joins DialogTable, DialogColumn, QBMRelation, qbmrelation, dialogcolumn…
  • UPDATE dbo.QBM_PRelationshipDefineManual · writes INSERT QBMRelation, UPDATE QBMRelation, UPDATE Qbmrelation, UPDATE qbmrelation; reads/joins DialogTable, DialogColumn, QBMRelation, qbmrelation, dialogcolumn…

DialogProcess 10 modules

insert × 4, update × 7

  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • INSERT dbo.QBM_PDialogProcessShrink_fill · calls QBM_PSessionErrorAdd; writes INSERT dialogprocess, UPDATE dialogprocess; reads/joins DialogProcessSubstitute, DialogProcess, Dialogprocess, dialogprocess, DialogWatchOperation…
  • UPDATE dbo.QBM_PDialogProcessShrink_fill · calls QBM_PSessionErrorAdd; writes INSERT dialogprocess, UPDATE dialogprocess; reads/joins DialogProcessSubstitute, DialogProcess, Dialogprocess, dialogprocess, DialogWatchOperation…
  • INSERT dbo.QBM_PJobUpdateState_Bulk · calls QBM_PJournal, QBM_PWriteDialogJournal, QBM_PJobCreate_SendMail, QBM_PJobCreate_HOFireEvent, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, INSERT DialogProcess, UPDATE is, UPDATE JobQueue; reads/joins JobQueue, QBM_FTJobQueueSetSameServer, job, QBMServer, DialogProcess…; uses config Common\MailNotification, Common\ProcessState\JobHistory, Common\Jobservice\RedoDelayMinutes
  • INSERT dbo.QBM_PProcessCreate · calls QBM_PSessionErrorAdd; writes INSERT DialogProcess; reads/joins DialogProcess
  • UPDATE dbo.QBM_PProcessGroupCreate · calls QBM_PDialogProcessShrink_fill, QBM_PProcessGroupCreate_help, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess; reads/joins DialogProcess, DialogProcessSubstitute; uses config Common\ProcessState\ExportPolicy, Common\ProcessState\PackageSizeHDB
  • UPDATE dbo.QBM_PProcessGroupCreate_help · writes INSERT into, UPDATE DialogProcess; reads/joins DialogProcessSubstitute, DialogProcess
  • UPDATE dbo.QBM_PProcessGroupDelete · calls QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogWatchOperation, UPDATE DialogProcessChain, UPDATE JobHistory, UPDATE DialogProcessSubstitute…; reads/joins Dialogprocess, DialogWatchOperation, DialogProcessChain, JobHistory, DialogProcessSubstitute…

PersonWantsOrg 9 modules

insert × 1, update × 9, delete × 1

  • UPDATE dbo.QER_PITShopHelperFill_bulk · calls as, QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QER_P04F128DC257D2B3C236MAIL_, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWODecisionHistory, INSERT PWOHelperPWO, UPDATE PersonWantsOrg, UPDATE PWOHelperPWO…; reads/joins PersonWantsOrg, QERWorkingStep, PWOHelperPWO, HelperPWOCompliance, ComplianceRule…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\PersonOrderedNoDecide, QER\ITShop\PersonInsertedNoDecide…; uses session context XUser, GenProcID
  • UPDATE dbo.QER_PITShopOrderMove_bulk · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID
  • UPDATE dbo.QER_PITShopOrderMove_bulk · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID
  • UPDATE dbo.QER_PPersonDelete_GDPR · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod_L, QBM_PJobCreate_HODelete, QBM_PWaitForSeconds, QBM_PDeleteDeep…; writes INSERT into, UPDATE PersonWantsOrg, UPDATE AttestationCase, UPDATE TroubleWorkTimes, UPDATE PersonHasTSBAccountDef…; reads/joins Person, sys, person, AttestationCase, PersonWantsOrg…; uses session context GenProcID
  • DELETE dbo.QER_ZITShopDeleteClosed · calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes UPDATE DialogColumn, DELETE PersonWantsOrg, DELETE ShoppingCartOrder; reads/joins DialogColumn, DialogTable, PersonWantsOrg, ShoppingCartOrder, ShoppingCartItem; uses config QER\ITShop\DeleteClosed, QER\ITShop\DeleteShoppingCarts, QER\ITShop\DeleteClosed\Aborted…; uses session context GenProcID
  • UPDATE dbo.QER_ZITShopOrderReset · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QER_PITShopHelperFill_bulk, QER_PITShopPersonHasObjFill_b, QBM_PDBQueueInsert_Bulk…; writes INSERT into, INSERT PWODecisionHistory, UPDATE personwantsorg, DELETE HelperPWOCompliance, DELETE HelperPWOPersonhasObject…; reads/joins QBMDBQueueCurrent, PersonWantsOrg, BaseTree; uses config QER\ITShop\DecisionOnInsert; uses session context GenProcID
  • UPDATE dbo.QER_ZITShopRepairClosed · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE PersonWantsOrg, DELETE Delegation; reads/joins QER_VPWOPersonPropertyReset; uses config Common\ProcessState\UseGenProcIDFromPWO; uses session context GenProcID
  • UPDATE dbo.QER_TDDialogProcess · calls QBM_PSessionErrorAdd; writes UPDATE PersonWantsOrg, DELETE not; reads/joins deleted, PersonWantsOrg

AttestationHelper 6 modules

insert × 1, update × 5, delete × 4

  • INSERT dbo.ATT_PAttestationHelperFill · calls as, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, INSERT AttestationHelper, UPDATE AttestationHelper, UPDATE AttestationCase…; reads/joins attestationCase, AttestationCase, AttestationPolicy, AttestationHelper, QERWorkingStep…; uses config QER\Attestation\PersonToAttestNoDecide; uses session context XUser, GenProcID
  • UPDATE dbo.ATT_PAttestationHelperFill · calls as, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, INSERT AttestationHelper, UPDATE AttestationHelper, UPDATE AttestationCase…; reads/joins attestationCase, AttestationCase, AttestationPolicy, AttestationHelper, QERWorkingStep…; uses config QER\Attestation\PersonToAttestNoDecide; uses session context XUser, GenProcID
  • DELETE dbo.ATT_PAttestationHelperFill · calls as, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, INSERT AttestationHelper, UPDATE AttestationHelper, UPDATE AttestationCase…; reads/joins attestationCase, AttestationCase, AttestationPolicy, AttestationHelper, QERWorkingStep…; uses config QER\Attestation\PersonToAttestNoDecide; uses session context XUser, GenProcID
  • UPDATE dbo.ATT_PAttestationResetOneLevel · calls QBM_PSessionErrorAdd; writes UPDATE Attestationhelper, DELETE Attestationhelper; reads/joins AttestationHelper
  • DELETE dbo.ATT_PAttestationResetOneLevel · calls QBM_PSessionErrorAdd; writes UPDATE Attestationhelper, DELETE Attestationhelper; reads/joins AttestationHelper
  • UPDATE dbo.ATT_ZAttestationMakeDecisionEX · calls QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into, UPDATE AttestationHelper; reads/joins QBMDBQueueCurrent, AttestationCase, AttestationHelper, QERWorkingStep
  • UPDATE dbo.ATT_ZAttestationReminder · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod, QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into, UPDATE AttestationHelper; reads/joins QBMDBQueueCurrent, AttestationCase, QERWorkingStep, AttestationHelper, PWODecisionRule…; uses session context XUser, GenProcID
  • DELETE dbo.ATT_ZAttestationReset · calls QER_PGIQERWorkingMethod, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, UPDATE AttestationCase, DELETE AttestationHelper; reads/joins QBMDBQueueCurrent, AttestationCase, AttestationPolicy; uses session context GenProcID

PersonInBaseTree 5 modules

insert × 1, update × 5, delete × 4

  • UPDATE dbo.QER_PITShop_ShopMove · calls QBM_PJobCreate_HOTemplate_B, QER_PITShop_BoardMove, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT PersonInITShopOrg, INSERT DynamicGroup, INSERT into…; reads/joins Basetree, BaseTree, ITShopOrgHasPWODecisionMethod, PersonInITShopOrg, DynamicGroup…
  • DELETE dbo.QER_PITShop_ShopMove · calls QBM_PJobCreate_HOTemplate_B, QER_PITShop_BoardMove, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT PersonInITShopOrg, INSERT DynamicGroup, INSERT into…; reads/joins Basetree, BaseTree, ITShopOrgHasPWODecisionMethod, PersonInITShopOrg, DynamicGroup…
  • UPDATE dbo.QER_PITShopBoardPrepareDelete · calls QBM_PExecuteSQLMulti, QER_ZITShopProductNodeCheck, QBM_PSessionErrorAdd; writes INSERT into, UPDATE PersonInBaseTree, DELETE PersonInBaseTree; reads/joins BaseTree, BaseTreeAssign, DialogTable
  • DELETE dbo.QER_PITShopBoardPrepareDelete · calls QBM_PExecuteSQLMulti, QER_ZITShopProductNodeCheck, QBM_PSessionErrorAdd; writes INSERT into, UPDATE PersonInBaseTree, DELETE PersonInBaseTree; reads/joins BaseTree, BaseTreeAssign, DialogTable
  • INSERT dbo.QER_PITShopOrderMove_bulk · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID
  • UPDATE dbo.QER_PITShopOrderMove_bulk · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID
  • DELETE dbo.QER_PITShopOrderMove_bulk · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID
  • UPDATE dbo.CPL_TDComplianceRule · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE PersonInBaseTree, DELETE not, DELETE PersonInBaseTree, DELETE BaseTree; reads/joins deleted, personInBaseTree, BaseTree, ComplianceRule

BaseTree 6 modules

insert × 3, update × 2, delete × 4

  • INSERT dbo.QER_PITShop_BoardMove · calls QER_PITShopCheckMethodBO, QER_PITShop_PRNodesMove, QER_PITShopProductNodeCheck, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT into, DELETE Basetree; reads/joins BaseTree, Basetree, ITShopOrgHasPWODecisionMethod, ITShopOrg
  • DELETE dbo.QER_PITShop_BoardMove · calls QER_PITShopCheckMethodBO, QER_PITShop_PRNodesMove, QER_PITShopProductNodeCheck, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT into, DELETE Basetree; reads/joins BaseTree, Basetree, ITShopOrgHasPWODecisionMethod, ITShopOrg
  • INSERT dbo.QER_PITShop_ShopMove · calls QBM_PJobCreate_HOTemplate_B, QER_PITShop_BoardMove, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT PersonInITShopOrg, INSERT DynamicGroup, INSERT into…; reads/joins Basetree, BaseTree, ITShopOrgHasPWODecisionMethod, PersonInITShopOrg, DynamicGroup…
  • DELETE dbo.QER_PITShop_ShopMove · calls QBM_PJobCreate_HOTemplate_B, QER_PITShop_BoardMove, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT PersonInITShopOrg, INSERT DynamicGroup, INSERT into…; reads/joins Basetree, BaseTree, ITShopOrgHasPWODecisionMethod, PersonInITShopOrg, DynamicGroup…
  • INSERT dbo.QER_PITShopProductNodeCreate_b · calls QBM_PSessionContextSet, QBM_PFESimulationFill, QBM_PJobCreate_HOUpdate, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTree, INSERT BaseTreeHasObject, UPDATE ITShopOrg, DELETE BaseTree; reads/joins DialogTable, BaseTreeAssign, DialogColumn, QBM_VQBMRelation, BaseTree…; uses session context XUser, GenProcID
  • DELETE dbo.QER_PITShopProductNodeCreate_b · calls QBM_PSessionContextSet, QBM_PFESimulationFill, QBM_PJobCreate_HOUpdate, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTree, INSERT BaseTreeHasObject, UPDATE ITShopOrg, DELETE BaseTree; reads/joins DialogTable, BaseTreeAssign, DialogColumn, QBM_VQBMRelation, BaseTree…; uses session context XUser, GenProcID
  • UPDATE dbo.QER_ZITShopCheckMethodPR · calls QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE BaseTree; reads/joins QBMDBQueueCurrent, BaseTree, QER_FTMethodForPRNode
  • UPDATE dbo.QER_ZOrgTreeLevel · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE BaseTree; reads/joins QBMDBQueueCurrent, BaseTree

QBMCustomSQL 5 modules

insert × 1, update × 6, delete × 2

  • DELETE dbo.QBM_PCustomSQLCompile · calls QBM_PCustomSQLFill, QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean, QBM_PSessionErrorAdd, QBM_PJournal; writes INSERT into, DELETE QBMCustomSQL; reads/joins QBMCustomSQL
  • UPDATE dbo.QBM_PCustomSQLDependencyFill · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean, QBM_PSessionErrorAdd; writes INSERT into, UPDATE qbmCustomSQL, UPDATE QBMCustomSQl; reads/joins sys, QBMCustomSQL, qbmCustomsql, QBMCustomSQl
  • UPDATE dbo.QBM_PCustomSQLDependencyFill · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean, QBM_PSessionErrorAdd; writes INSERT into, UPDATE qbmCustomSQL, UPDATE QBMCustomSQl; reads/joins sys, QBMCustomSQL, qbmCustomsql, QBMCustomSQl
  • INSERT dbo.QBM_PCustomSQLFill · calls QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMCustomSQL, UPDATE QBMCustomSQL, DELETE QBMCustomSQL; reads/joins sys, QBMCustomSQL, QBMModuleDef, DialogTable, DialogColumn…
  • UPDATE dbo.QBM_PCustomSQLFill · calls QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMCustomSQL, UPDATE QBMCustomSQL, DELETE QBMCustomSQL; reads/joins sys, QBMCustomSQL, QBMModuleDef, DialogTable, DialogColumn…
  • DELETE dbo.QBM_PCustomSQLFill · calls QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMCustomSQL, UPDATE QBMCustomSQL, DELETE QBMCustomSQL; reads/joins sys, QBMCustomSQL, QBMModuleDef, DialogTable, DialogColumn…
  • UPDATE dbo.QBM_PCustomSQLPropagate · calls QBM_PCustomSQLPropagate_Cont, QBM_PViewBuild, QBM_PSQLCreate, QBM_PDatabasePrepareCheck1, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMCustomSQL; reads/joins sys, QBMCustomSQL
  • UPDATE dbo.QBM_PCustomSQLSort · calls QBM_PCustomSQLDependencyFill, QBM_PSessionErrorAdd; writes UPDATE QBMCustomsql, UPDATE QBMCustomSQL; reads/joins sys, QBMCustomSQL

AttestationCase 8 modules

insert × 1, update × 5, delete × 2

  • DELETE dbo.ATT_P47650F5671BCBA8B679125E_ · calls QBM_PSessionErrorAdd; writes INSERT into, DELETE AttestationCase; reads/joins AttestationCase
  • DELETE dbo.ATT_P600B8EB3A312074D1A10A4A_ · calls QBM_PSessionErrorAdd; writes INSERT into, DELETE AttestationCaseHasMControl, DELETE AttestationCase; reads/joins AttestationCase, AttestationCaseHasMControl
  • UPDATE dbo.ATT_PAfterMigrationTasks · calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOTemplate_B, QBM_PJobCreate_HOFireEvent, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE AttestationCase; reads/joins AttestationCase, AttestationPolicy
  • INSERT dbo.ATT_PAttestationCaseCreate_i · calls QBM_PJobCreate_HOCallMethod, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationCase
  • UPDATE dbo.ATT_PAttestationHelperFill · calls as, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, INSERT AttestationHelper, UPDATE AttestationHelper, UPDATE AttestationCase…; reads/joins attestationCase, AttestationCase, AttestationPolicy, AttestationHelper, QERWorkingStep…; uses config QER\Attestation\PersonToAttestNoDecide; uses session context XUser, GenProcID
  • UPDATE dbo.ATT_ZAttestationReset · calls QER_PGIQERWorkingMethod, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, UPDATE AttestationCase, DELETE AttestationHelper; reads/joins QBMDBQueueCurrent, AttestationCase, AttestationPolicy; uses session context GenProcID
  • UPDATE dbo.QER_PPersonDelete_GDPR · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod_L, QBM_PJobCreate_HODelete, QBM_PWaitForSeconds, QBM_PDeleteDeep…; writes INSERT into, UPDATE PersonWantsOrg, UPDATE AttestationCase, UPDATE TroubleWorkTimes, UPDATE PersonHasTSBAccountDef…; reads/joins Person, sys, person, AttestationCase, PersonWantsOrg…; uses session context GenProcID
  • UPDATE dbo.ATT_TUPerson · calls QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOUpdate_L, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, UPDATE not, UPDATE AttestationCase; reads/joins inserted, deleted, BaseTree, Person, AttestationCase…; uses config QER\Attestation\AutoCloseInactivePerson

DialogDBQueue 7 modules

insert × 2, update × 4, delete × 2

  • UPDATE dbo.QBM_PDBQCS_SlotFill · calls QBM_PJournal, QBM_PTransactionLevelCheck, QBM_PDBQCS_CurrentMoveSlot, QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean; writes INSERT into, INSERT QBMDBQueueCurrent, UPDATE DialogDBQueue; reads/joins QBMDBQueueTaskMetric, DialogDBQueue, QBMDBQueueCurrent
  • UPDATE dbo.QBM_PDBQCS_SlotFill_Range · calls QBM_PJournal, QBM_PTransactionLevelCheck, QBM_PDBQCS_CurrentMoveSlot, QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean; writes INSERT into, INSERT QBMDBQueueCurrent, UPDATE DialogDBQueue; reads/joins QBMDBQueueTaskMetric, DialogDBQueue, QBMDBQueueCurrent
  • INSERT dbo.QBM_PDBQueueCompress · calls QBM_PIndexDrop, QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogDBQueue; reads/joins sys, DialogDBQueue, QBMDBQueueTaskMetric; uses session context XUser, GenProcID
  • DELETE dbo.QBM_PDBQueueExternalTaskFire · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE DialogDatabase, DELETE DialogDBQueue; reads/joins DialogDatabase; uses session context INSERTEDINTODBQUEUE
  • INSERT dbo.QBM_PDBQueueInsert_Int · calls QBM_PSessionContextSet, QBM_PJournal, QBM_PSessionErrorAdd, QBM_PDBQueueInsert_Single; writes INSERT into, INSERT DialogDBQueue, UPDATE DialogDatabase; reads/joins QBMDBQueueTaskMetric, QBMDBQueueTask, DialogDBQueue, DialogTable; uses config Common\ProcessState; uses session context XUser, GenProcID, INSERTEDINTODBQUEUE
  • UPDATE dbo.QBM_PDialogDBQueueDelete · calls QBM_PWaitForSeconds, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogDBQueue, DELETE DialogDBQueue; reads/joins DialogDBQueue
  • DELETE dbo.QBM_PDialogDBQueueDelete · calls QBM_PWaitForSeconds, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogDBQueue, DELETE DialogDBQueue; reads/joins DialogDBQueue
  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute

QBMDBQueueCurrent 7 modules

insert × 3, update × 4, delete × 1

  • UPDATE dbo.QBM_PDBQCS_CurrentMoveSlot · calls QBM_PSessionErrorAdd, QBM_PWaitForSeconds, QBM_PSessionErrorClean, QBM_PJournal; writes INSERT into, UPDATE QBMDBQueueCurrent; reads/joins sys, QBMDBQueueCurrent
  • UPDATE dbo.QBM_PDBQCS_CurrentRestore · calls QBM_PJournal, QBM_PTransactionLevelCheck, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PDBQCS_CurrentMoveSlot…; writes INSERT into, UPDATE QBMDBQueueCurrent; reads/joins QBMDBQueueCurrent, QBMDBQueueTaskMetric, DialogDatabase, Current; uses session context XUser, GenProcID
  • INSERT dbo.QBM_PDBQCS_SlotFill · calls QBM_PJournal, QBM_PTransactionLevelCheck, QBM_PDBQCS_CurrentMoveSlot, QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean; writes INSERT into, INSERT QBMDBQueueCurrent, UPDATE DialogDBQueue; reads/joins QBMDBQueueTaskMetric, DialogDBQueue, QBMDBQueueCurrent
  • INSERT dbo.QBM_PDBQCS_SlotFill_Range · calls QBM_PJournal, QBM_PTransactionLevelCheck, QBM_PDBQCS_CurrentMoveSlot, QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean; writes INSERT into, INSERT QBMDBQueueCurrent, UPDATE DialogDBQueue; reads/joins QBMDBQueueTaskMetric, DialogDBQueue, QBMDBQueueCurrent
  • INSERT dbo.QBM_PDBQueueReplGenProcID · calls QBM_PDBQCS_CurrentMoveSlot, QBM_PSessionErrorAdd, QBM_PWaitForSeconds, QBM_PSessionErrorClean, QBM_PProcessCreate; writes INSERT into, INSERT QBMDBQueueCurrent, INSERT DialogProcessSubstitute; reads/joins QBMDBQueueCurrent, DialogProcessSubstitute; uses config QBM\DBQueue\GenProcIDReplaceLimit, Common\ProcessState
  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • UPDATE dbo.QBM_PQBMDBQueueCurrentDelete · calls QBM_PWaitForSeconds, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMDBQueueCurrent, DELETE QBMDBQueueCurrent; reads/joins QBMDBQueueCurrent
  • DELETE dbo.QBM_PQBMDBQueueCurrentDelete · calls QBM_PWaitForSeconds, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMDBQueueCurrent, DELETE QBMDBQueueCurrent; reads/joins QBMDBQueueCurrent

QBMBufferConfig 4 modules

insert × 2, update × 3, delete × 3

  • INSERT dbo.QBM_FSQBufferConfigSaveOrigin · writes INSERT QBMBufferConfig, DELETE QBMBufferConfig; reads/joins deleted, DialogDatabase, QBMBufferConfig, DialogColumn, DialogTable
  • DELETE dbo.QBM_FSQBufferConfigSaveOrigin · writes INSERT QBMBufferConfig, DELETE QBMBufferConfig; reads/joins deleted, DialogDatabase, QBMBufferConfig, DialogColumn, DialogTable
  • UPDATE dbo.QBM_PBufferC_ProcessOneColumn · calls QBM_PSessionErrorAdd; writes UPDATE QBMBufferConfig, DELETE QBMBufferConfig; reads/joins DialogColumn, DialogTable, QBMBufferConfig
  • DELETE dbo.QBM_PBufferC_ProcessOneColumn · calls QBM_PSessionErrorAdd; writes UPDATE QBMBufferConfig, DELETE QBMBufferConfig; reads/joins DialogColumn, DialogTable, QBMBufferConfig
  • UPDATE dbo.QBM_PBufferT_ProcessUpdate · calls QBM_PJournal, QBM_PSessionErrorAdd, QBM_PTriggersInactiveForTable; writes UPDATE QBMBufferConfig, DELETE QBMBufferConfig; reads/joins QBMBufferConfig, DialogColumn, DialogTable
  • DELETE dbo.QBM_PBufferT_ProcessUpdate · calls QBM_PJournal, QBM_PSessionErrorAdd, QBM_PTriggersInactiveForTable; writes UPDATE QBMBufferConfig, DELETE QBMBufferConfig; reads/joins QBMBufferConfig, DialogColumn, DialogTable
  • INSERT dbo.QBM_PDatabasePrepareCheck2 · calls QBM_PDatabasePrepareCheck1, QBM_P195C5572460EC8DDA27B3A3_1, QBM_PSessionErrorAdd; writes INSERT QBMBufferConfig, UPDATE dialogcolumn, UPDATE DialogColumn, UPDATE DialogConfigParm, UPDATE QBMBufferConfig…; reads/joins dialogcolumn, dialogtable, Dialogcolumn, QBMRelation, DialogColumn…; uses config declare @TableName varchar(30) =, declare @ColumnName varchar(30) =
  • UPDATE dbo.QBM_PDatabasePrepareCheck2 · calls QBM_PDatabasePrepareCheck1, QBM_P195C5572460EC8DDA27B3A3_1, QBM_PSessionErrorAdd; writes INSERT QBMBufferConfig, UPDATE dialogcolumn, UPDATE DialogColumn, UPDATE DialogConfigParm, UPDATE QBMBufferConfig…; reads/joins dialogcolumn, dialogtable, Dialogcolumn, QBMRelation, DialogColumn…; uses config declare @TableName varchar(30) =, declare @ColumnName varchar(30) =

dialogSemaphor 6 modules

update × 6

  • UPDATE dbo.QBM_ZDialogSemaphorIncAll · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE dialogSemaphor; uses session context GenProcID
  • UPDATE dbo.QBM_ZDialogSemaphorIncGlobal · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE dialogSemaphor; reads/joins DialogSemaphor; uses session context GenProcID
  • UPDATE dbo.QBM_ZSoftwareRevision · calls QBM_PSessionErrorAdd; writes UPDATE dialogSemaphor; reads/joins QBMFileRevision, QBMFileHasDeployTarget
  • UPDATE dbo.QBM_TDDialogScriptAssembly · calls QBM_PSessionErrorAdd; writes UPDATE dialogSemaphor, DELETE not; reads/joins deleted; uses session context XUser
  • UPDATE dbo.QBM_TIDialogScriptAssembly · calls QBM_PSessionErrorAdd; writes INSERT not, UPDATE dialogSemaphor; reads/joins inserted; uses session context XUser
  • UPDATE dbo.QBM_TUDialogScriptAssembly · calls QBM_PSessionErrorAdd; writes UPDATE not, UPDATE dialogSemaphor; reads/joins inserted, deleted; uses session context XUser

JobHistory 6 modules

insert × 2, update × 3, delete × 1

  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • UPDATE dbo.QBM_PF84975544A6AEABC94405E1_a · writes INSERT into, UPDATE JobHistory; reads/joins JobHistory, jobhistory
  • INSERT dbo.QBM_PJobQueueDelete · calls QBM_PWaitForSeconds, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobHistory, INSERT JobQueueStats, UPDATE JobQueue, DELETE Jobqueue; reads/joins JobQueue, JobTreeParamColl, JobHistory; uses config Common\JobQueueStats
  • INSERT dbo.QBM_PJobQueueDelete_Bulk · calls QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobHistory, DELETE Jobqueue; reads/joins JobQueue, JobTreeParamColl, JobHistory; uses config Common\ProcessState\JobHistory
  • UPDATE dbo.QBM_PProcessGroupDelete · calls QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogWatchOperation, UPDATE DialogProcessChain, UPDATE JobHistory, UPDATE DialogProcessSubstitute…; reads/joins Dialogprocess, DialogWatchOperation, DialogProcessChain, JobHistory, DialogProcessSubstitute…
  • DELETE dbo.QBM_PWorkHistoryDelete · calls QBM_PSessionContextSet, QBM_PDBQueueAgentInfoSet, QBM_PTransactionLevelCheck, QBM_PDeleteBulk, QBM_PSessionErrorAdd…; writes DELETE JobHistory; reads/joins sys, jobhistory, JobHistory; uses config Common\ProcessState\JobHistory\Delete\BulkCount, Common\ProcessState\JobHistory\Delete\TotalCount, Common\ProcessState\Delete\BulkCount…; uses session context XUser, GenProcID

DialogUser 4 modules

insert × 2, update × 3, delete × 1

  • INSERT dbo.QBM_PDynamicUserForPerson · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT user, INSERT DialogUser, INSERT useringroup, INSERT DialogUserInGroup…; reads/joins DialogGroup, DialogGroupInProductLimited, AERole, BaseTreeCollectionF, BaseTree…; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PDynamicUserForPerson · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT user, INSERT DialogUser, INSERT useringroup, INSERT DialogUserInGroup…; reads/joins DialogGroup, DialogGroupInProductLimited, AERole, BaseTreeCollectionF, BaseTree…; uses session context XUser, GenProcID
  • INSERT dbo.QBM_PUserDetectByGroupList · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT dialoguser, INSERT dialoguseringroup, UPDATE dialoguser; reads/joins DialogGroup, QBM_FCVStringToList, DialogGroupInProductLimited, dialogGroupCollection, dialoguseringroup…; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PUserDetectByGroupList · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT dialoguser, INSERT dialoguseringroup, UPDATE dialoguser; reads/joins DialogGroup, QBM_FCVStringToList, DialogGroupInProductLimited, dialogGroupCollection, dialoguseringroup…; uses session context XUser, GenProcID
  • DELETE dbo.QBM_ZDynamicUserShrink · calls QBM_PSessionErrorAdd; writes DELETE dialoguser; reads/joins dialoguser, DialogDeferredOperation; uses config Common\DynamicUserLifetime
  • UPDATE dbo.QBM_TIDialogUser · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, UPDATE DialogUser; reads/joins inserted, DialogUser

Delegation 5 modules

delete × 5

  • DELETE dbo.QER_ZITShopRepairClosed · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE PersonWantsOrg, DELETE Delegation; reads/joins QER_VPWOPersonPropertyReset; uses config Common\ProcessState\UseGenProcIDFromPWO; uses session context GenProcID
  • DELETE dbo.QER_TDPerson · calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE person, DELETE delegation; reads/joins deleted, QERUniversalSubstitute, delegation, PersonWantsOrg
  • DELETE dbo.QER_TUHelperHeadOrg · calls QBM_PJournal, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOCallMethod, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE trigger, DELETE Delegation; reads/joins deleted, inserted, HelperHeadOrg, Basetree, Delegation…; uses config Common\ProcessState\UseGenProcIDFromPWO
  • DELETE dbo.QER_TUHelperHeadPerson · calls QER_PITShopHelperFill_Recalc, QBM_PJobCreate_HOCallMethod, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, DELETE Delegation; reads/joins deleted, HelperHeadPerson, Person, Delegation, personwantsorg; uses config Common\ProcessState\UseGenProcIDFromPWO
  • DELETE dbo.QER_TUPersonInBaseTree · calls QBM_PJobCreate_HOCallMethod, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, DELETE Delegation; reads/joins deleted, inserted, PersonInBaseTree, Delegation, PersonWantsOrg; uses config Common\ProcessState\UseGenProcIDFromPWO

DialogConfigParm 5 modules

update × 5

  • UPDATE dbo.QBM_PDatabasePrepare · calls QBM_PDialogDatabaseInitialInfo, QBM_PDatabasePrepareCheck1, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT QBMServerTag, INSERT QBMServerHasServerTag, INSERT QBMServer, UPDATE DialogConfigParm, UPDATE dialogdatabase…; reads/joins dialogdatabase, DialogDatabase, QBMServerTag, QBMModuleDef, QBMServerHasServerTag…; uses config 5, 20
  • UPDATE dbo.QBM_PDatabasePrepareCheck2 · calls QBM_PDatabasePrepareCheck1, QBM_P195C5572460EC8DDA27B3A3_1, QBM_PSessionErrorAdd; writes INSERT QBMBufferConfig, UPDATE dialogcolumn, UPDATE DialogColumn, UPDATE DialogConfigParm, UPDATE QBMBufferConfig…; reads/joins dialogcolumn, dialogtable, Dialogcolumn, QBMRelation, DialogColumn…; uses config declare @TableName varchar(30) =, declare @ColumnName varchar(30) =
  • UPDATE dbo.QBM_ZConfigParmCheck · calls QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogConfigParm; reads/joins dialogconfigparm, DialogConfigParm
  • UPDATE dbo.QBM_ZGetServerProperties · calls sys, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogConfigParm; reads/joins QBM_VServerEngineProperties, sys, DialogConfigParm
  • UPDATE dbo.QBM_TUDialogDatabase · calls QBM_PDBQueueInsert_Single, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE not, UPDATE DialogConfigParm, UPDATE in; reads/joins inserted, deleted, DialogDatabase; uses config QBM\DBQueue\CountSlotsMax, QBM\DBQueue\KeepAlive; uses session context INSERTEDINTODBQUEUE

QBMElementAffectedByJob 5 modules

insert × 3, delete × 2

  • INSERT dbo.ATT_PAttestationCaseCreate · calls QER_PGIQERWorkingMethod, ATT_PAttestationCaseCreate_i, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobQueue, INSERT QBMElementAffectedByJob, UPDATE AttestationRun; reads/joins AttestationPolicy, QBM_FTHexPattern, AttestationRun; uses session context XUser
  • INSERT dbo.QBM_PDBQCS_SlotRunner · calls QBM_PTransactionLevelCheck, QBM_PJournal, slot, QBM_PSessionErrorAdd, QBM_PSessionContextSet…; writes INSERT JobQueue, INSERT QBMElementAffectedByJob, INSERT into; reads/joins sys, QBMDBQueueCurrent, QBMDBQueueTaskMetric, QBMVSystemOverview, set; uses config QBM\DBQueue\KeepAlive, QBM\DBQueue\DefaultRuntime; uses session context TempQueue
  • INSERT dbo.QBM_PJobCreate · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT jobqueue, INSERT QBMElementAffectedByJob; reads/joins QBMServerHasServerTag, QBMServer, QBMJobqueueOverview, QBM_FTJobCreateDBParameter, JobQueue…; uses config Common\DBJobCreateWithFreeze; uses session context XUser, GenProcID
  • DELETE dbo.QBM_PWorkJobQueueDelete · calls QBM_PSessionContextSet, QBM_PDBQueueAgentInfoSet, QBM_PTransactionLevelCheck, QBM_PJobQueueDelete, QBM_PSessionErrorAdd…; writes DELETE QBMElementAffectedByJob; reads/joins sys, QBMElementAffectedByJob, JobQueue; uses session context XUser, GenProcID
  • DELETE dbo.QBM_TDJobqueue · calls QBM_PJobQueueOverviewSetInv, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE QBMElementAffectedByJob, DELETE JobtreeParamColl; reads/joins deleted, QBMJobqueueOverview, QBMElementAffectedByJob, JobtreeParamColl

DialogUserInGroup 4 modules

insert × 3, delete × 2

  • INSERT dbo.QBM_PDialogUserInGroupCorrect · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT DialogUserInGroup, DELETE DialogUserInGroup; reads/joins DialogUser, DialogGroup, DialogUserInGroup, QBM_VSchemaColumns; uses session context XUser, XUSER, GenProcID
  • DELETE dbo.QBM_PDialogUserInGroupCorrect · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT DialogUserInGroup, DELETE DialogUserInGroup; reads/joins DialogUser, DialogGroup, DialogUserInGroup, QBM_VSchemaColumns; uses session context XUser, XUSER, GenProcID
  • INSERT dbo.QBM_PDynamicUserForPerson · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT user, INSERT DialogUser, INSERT useringroup, INSERT DialogUserInGroup…; reads/joins DialogGroup, DialogGroupInProductLimited, AERole, BaseTreeCollectionF, BaseTree…; uses session context XUser, GenProcID
  • INSERT dbo.QBM_PUserDetectByGroupList · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT dialoguser, INSERT dialoguseringroup, UPDATE dialoguser; reads/joins DialogGroup, QBM_FCVStringToList, DialogGroupInProductLimited, dialogGroupCollection, dialoguseringroup…; uses session context XUser, GenProcID
  • DELETE dbo.QBM_TUDialogUser · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, DELETE DialogUserInGroup; reads/joins inserted, deleted, dialogUser, DialogUserInGroup, DialogUser

QBMJobqueueOverview 4 modules

update × 3, delete × 2

  • UPDATE dbo.QBM_PJobQueueInit_i · calls QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PJobQueueSetSameServer, QBM_PQBMServerHasJobService, QBM_PSessionErrorAdd; writes INSERT QBMServer, INSERT into, UPDATE QBMServer, UPDATE QBMJobqueueOverview, UPDATE jobqueue…; reads/joins QBMServer, QBMServerHasServerTag, QBMJobqueueOverview, DialogDatabase, JobQueue…; uses config Common\Jobservice\AutoCreateServerFromQueues; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PJobqueueoverViewFill · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMJobqueueOverview, DELETE QBMJobqueueOverview; reads/joins QBMJobqueueOverview, JobQueue, QBMServer; uses session context XUser, GenProcID
  • DELETE dbo.QBM_PJobqueueoverViewFill · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMJobqueueOverview, DELETE QBMJobqueueOverview; reads/joins QBMJobqueueOverview, JobQueue, QBMServer; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PJobQueueOverviewSetInv · writes INSERT into, UPDATE QBMJobqueueOverview; reads/joins QBMJobqueueOverview
  • DELETE dbo.QBM_TDQBMServer · calls QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes DELETE not, DELETE QBMJobqueueOverview; reads/joins deleted, QBMJobqueueOverview

QBMServer 4 modules

insert × 2, update × 3

  • INSERT dbo.QBM_PDatabasePrepare · calls QBM_PDialogDatabaseInitialInfo, QBM_PDatabasePrepareCheck1, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT QBMServerTag, INSERT QBMServerHasServerTag, INSERT QBMServer, UPDATE DialogConfigParm, UPDATE dialogdatabase…; reads/joins dialogdatabase, DialogDatabase, QBMServerTag, QBMModuleDef, QBMServerHasServerTag…; uses config 5, 20
  • INSERT dbo.QBM_PJobQueueInit_i · calls QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PJobQueueSetSameServer, QBM_PQBMServerHasJobService, QBM_PSessionErrorAdd; writes INSERT QBMServer, INSERT into, UPDATE QBMServer, UPDATE QBMJobqueueOverview, UPDATE jobqueue…; reads/joins QBMServer, QBMServerHasServerTag, QBMJobqueueOverview, DialogDatabase, JobQueue…; uses config Common\Jobservice\AutoCreateServerFromQueues; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PJobQueueInit_i · calls QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PJobQueueSetSameServer, QBM_PQBMServerHasJobService, QBM_PSessionErrorAdd; writes INSERT QBMServer, INSERT into, UPDATE QBMServer, UPDATE QBMJobqueueOverview, UPDATE jobqueue…; reads/joins QBMServer, QBMServerHasServerTag, QBMJobqueueOverview, DialogDatabase, JobQueue…; uses config Common\Jobservice\AutoCreateServerFromQueues; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PJobQueueLoad · calls QBM_PSessionContextSet, QBM_PJobCreate_HOFireEvent_B, QBM_PQBMServerHasJobService, sys, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, INSERT JobQueueStats, UPDATE QBMServer, UPDATE jobqueue; reads/joins QBMServer, QBM_FCVStringToListSplitted, DialogDatabase, DialogScriptAssembly, QBMFileRevision…; uses config Common\Autoupdate, Common\Jobservice\LoadedJobsTimeOut, Common\JobQueueStats; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PQBMServerHasJobService · calls QBM_PSessionContextSet, QBM_PJobCreate_HOFireEvent, QBM_PSessionErrorAdd; writes UPDATE QBMServer; uses session context XUser, GenProcID

BaseTreeCollection 3 modules

insert × 3, delete × 2

  • INSERT dbo.QER_POrgSubTree · calls QBM_PJournal, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeCollection, DELETE BaseTreeCollection; reads/joins BaseTree, BaseTreeCollection
  • DELETE dbo.QER_POrgSubTree · calls QBM_PJournal, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeCollection, DELETE BaseTreeCollection; reads/joins BaseTree, BaseTreeCollection
  • INSERT dbo.QER_ZOrgRoot · calls QBM_PDBQueueCalculateDelta, QBM_PFESimulationFill, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeCollection, DELETE BaseTreeCollection; reads/joins orgroot, BaseTreeCollection, BaseTree
  • DELETE dbo.QER_ZOrgRoot · calls QBM_PDBQueueCalculateDelta, QBM_PFESimulationFill, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeCollection, DELETE BaseTreeCollection; reads/joins orgroot, BaseTreeCollection, BaseTree
  • INSERT dbo.QER_TIBaseTree · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT BaseTreeCollectionF, INSERT node, INSERT BaseTreecollection; reads/joins inserted, DialogGroup, BaseTreeCollectionF, BaseTree, OrgRoot…

BaseTreeHasObject 3 modules

insert × 3, update × 1, delete × 1

  • INSERT dbo.QER_PBasetreeHasObjectPostProc · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeHasObject, UPDATE BaseTreeHasObject, DELETE BaseTreeHasObject; reads/joins BaseTreeHasObject, BasetreeHasObject; uses session context GenProcID
  • UPDATE dbo.QER_PBasetreeHasObjectPostProc · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeHasObject, UPDATE BaseTreeHasObject, DELETE BaseTreeHasObject; reads/joins BaseTreeHasObject, BasetreeHasObject; uses session context GenProcID
  • DELETE dbo.QER_PBasetreeHasObjectPostProc · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeHasObject, UPDATE BaseTreeHasObject, DELETE BaseTreeHasObject; reads/joins BaseTreeHasObject, BasetreeHasObject; uses session context GenProcID
  • INSERT dbo.QER_PITShopProductNodeCreate_b · calls QBM_PSessionContextSet, QBM_PFESimulationFill, QBM_PJobCreate_HOUpdate, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTree, INSERT BaseTreeHasObject, UPDATE ITShopOrg, DELETE BaseTree; reads/joins DialogTable, BaseTreeAssign, DialogColumn, QBM_VQBMRelation, BaseTree…; uses session context XUser, GenProcID
  • INSERT dbo.QER_PITShopProductNodeMove · calls QBM_PJournal, QBM_PExecuteSQLWithRetry_LLP, QER_PITShopProductNodeCreate, QER_PITShopOrderMove_bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeHasObject; reads/joins BaseTree, BaseTreeHasObject, BaseTreeAssign, DialogTable, OrgRootAssign…

object 3 modules

insert × 2, update × 2, delete × 1

  • INSERT dbo.QBM_FSQFKCheckDynamic · writes INSERT object, INSERT into, UPDATE object, DELETE SET, DELETE RESTRICT; reads/joins QBM_VDialogValidDynamicRef_Exp, DialogColumn, DialogTable, deleted, inserted
  • UPDATE dbo.QBM_FSQFKCheckDynamic · writes INSERT object, INSERT into, UPDATE object, DELETE SET, DELETE RESTRICT; reads/joins QBM_VDialogValidDynamicRef_Exp, DialogColumn, DialogTable, deleted, inserted
  • INSERT dbo.QBM_FSQFKCheckFix · calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HODelete_B; writes INSERT object, INSERT into, UPDATE object, DELETE cascade, DELETE no…; reads/joins QBM_VQBMRelation, DialogColumn, deleted, inserted, PersonWantsOrg…
  • UPDATE dbo.QBM_FSQFKCheckFix · calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HODelete_B; writes INSERT object, INSERT into, UPDATE object, DELETE cascade, DELETE no…; reads/joins QBM_VQBMRelation, DialogColumn, deleted, inserted, PersonWantsOrg…
  • DELETE dbo.QBM_PTableDrop · calls QBM_PSchemaBindDisable, QBM_PConstraintFKDrop, QBM_PSessionErrorAdd; writes INSERT into, DELETE Object, DELETE Table, DELETE QBMRelation, DELETE DialogValidDynamicRef…; reads/joins sys, QBM_VQBMRelationALL, DialogTable, QBM_VQBMRelation, QBMRelation…

QBMSplittedLookup 3 modules

insert × 1, update × 1, delete × 3

  • DELETE dbo.QBM_FSQTriggerSplittedLookup · calls QBM_PSplittedElementProcess; writes INSERT into, DELETE QBMSplittedLookup; reads/joins DialogTable, DialogColumn, sys, QBM_FCVStringToList, QBM_VQBMRelation…
  • INSERT dbo.QBM_PSplittedElementProcess · writes INSERT into, INSERT QBMSplittedLookup, UPDATE QBMSplittedLookup, DELETE QBMSplittedLookup; reads/joins string_split, QBMSplittedLookup
  • UPDATE dbo.QBM_PSplittedElementProcess · writes INSERT into, INSERT QBMSplittedLookup, UPDATE QBMSplittedLookup, DELETE QBMSplittedLookup; reads/joins string_split, QBMSplittedLookup
  • DELETE dbo.QBM_PSplittedElementProcess · writes INSERT into, INSERT QBMSplittedLookup, UPDATE QBMSplittedLookup, DELETE QBMSplittedLookup; reads/joins string_split, QBMSplittedLookup
  • DELETE dbo.QBM_TUDialogColumn · calls QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE dialogcolumn, DELETE QBMSplittedLookup; reads/joins inserted, deleted, dialogColumn, dialogtable, dialogcolumn…

Accounts 4 modules

delete × 4

  • DELETE dbo.ADS_TDADSAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, DELETE not, DELETE Accounts; reads/joins deleted, PersonHasTSBAccountDef, ADSOtherSID
  • DELETE dbo.ADS_TDADSContact · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE Accounts; reads/joins deleted, PersonHasTSBAccountDef
  • DELETE dbo.LDP_TDLDAPAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE Accounts; reads/joins deleted, PersonHasTSBAccountDef, Deleted
  • DELETE dbo.TSB_TDUNSAccountB · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE Accounts; reads/joins deleted, PersonHasTSBAccountDef

DialogColumnGroupRight 4 modules

delete × 4

  • DELETE dbo.QBM_PColumnCustomRemove · calls QBM_PIndexDrop, QBM_PJournal, QBM_PWaitForSeconds, QBM_PSessionErrorAdd, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, DELETE QBMRelation, DELETE DialogValidDynamicRef, DELETE DialogColumnGroupRight, DELETE DialogColumn…; reads/joins DialogTable, DialogColumn, DialogDatabase, INFORMATION_SCHEMA, sys…
  • DELETE dbo.QBM_PColumnDrop · calls QBM_PExecuteSQLWithRetry_LLP, sp_unbindefault, QBM_PIndexDrop, QBM_PSessionErrorAdd; writes DELETE DialogColumnGroupRight, DELETE DialogColumn; reads/joins sys, information_schema, QBM_VSchemaColumns, DialogColumnGroupRight, DialogColumn…
  • DELETE dbo.QBM_PTableCustomRemove_RU · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, DELETE DialogColumnGroupRight, DELETE DialogColumn, DELETE DialogTable; reads/joins DialogTable, DialogDatabase, INFORMATION_SCHEMA, QBM_VQBMRelation, sys…
  • DELETE dbo.QBM_PTableDrop · calls QBM_PSchemaBindDisable, QBM_PConstraintFKDrop, QBM_PSessionErrorAdd; writes INSERT into, DELETE Object, DELETE Table, DELETE QBMRelation, DELETE DialogValidDynamicRef…; reads/joins sys, QBM_VQBMRelationALL, DialogTable, QBM_VQBMRelation, QBMRelation…

dialogGroup 4 modules

update × 4

  • UPDATE dbo.QBM_ZGroupNumber · calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes UPDATE dialogGroup; reads/joins DialogGroup, dialoggroup, dialogGroup; uses session context GenProcID
  • UPDATE dbo.QBM_ZGroupPattern · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE dialogGroup; reads/joins DialogGroup, dialogGroup; uses session context GenProcID
  • UPDATE dbo.QBM_ZPrePropGroup · calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogGroup; reads/joins QBMDBQueueCurrent, dialogGroup, DialogGroup; uses session context GenProcID
  • UPDATE dbo.QBM_TUDialogGroup · calls QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE dialoggroup; reads/joins inserted, deleted, DialogGroup, dialogGroup

DialogProcessChain 4 modules

update × 4

  • UPDATE dbo.QBM_P0443A4E1724A1CB3D52A2C2_a · writes INSERT into, UPDATE DialogProcessChain; reads/joins DialogProcessChain
  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • UPDATE dbo.QBM_PProcessGroupDelete · calls QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogWatchOperation, UPDATE DialogProcessChain, UPDATE JobHistory, UPDATE DialogProcessSubstitute…; reads/joins Dialogprocess, DialogWatchOperation, DialogProcessChain, JobHistory, DialogProcessSubstitute…
  • UPDATE dbo.QBM_ZProcessChainStateUpdate · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcessChain; reads/joins QBMDBQueueCurrent, DialogProcessChain, DialogProcessStep

DialogProcessSubstitute 4 modules

insert × 1, update × 3

  • INSERT dbo.QBM_PDBQueueReplGenProcID · calls QBM_PDBQCS_CurrentMoveSlot, QBM_PSessionErrorAdd, QBM_PWaitForSeconds, QBM_PSessionErrorClean, QBM_PProcessCreate; writes INSERT into, INSERT QBMDBQueueCurrent, INSERT DialogProcessSubstitute; reads/joins QBMDBQueueCurrent, DialogProcessSubstitute; uses config QBM\DBQueue\GenProcIDReplaceLimit, Common\ProcessState
  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • UPDATE dbo.QBM_PProcessGroupDelete · calls QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogWatchOperation, UPDATE DialogProcessChain, UPDATE JobHistory, UPDATE DialogProcessSubstitute…; reads/joins Dialogprocess, DialogWatchOperation, DialogProcessChain, JobHistory, DialogProcessSubstitute…
  • UPDATE dbo.QBM_PProcessShrink · calls QBM_PDialogProcessShrink_3, QBM_PDialogProcessShrink_mark, QBM_PSessionErrorAdd; writes UPDATE DialogProcessSubstitute; reads/joins DialogProcessSubstitute, dialogprocess

DialogSchedule 4 modules

update × 4

  • UPDATE dbo.QBM_PScheduleCheck · calls QBM_PJournal, QBM_PWaitForSeconds, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogSchedule; reads/joins DialogDatabase, DialogScriptAssembly, DialogSchedule, DialogTimeZone, dialogSchedule; uses config QBM\Schedules; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_TIDialogSchedule · calls QBM_PSessionErrorAdd; writes INSERT not, UPDATE DialogSchedule; reads/joins inserted, DialogSchedule, DialogTimeZone
  • UPDATE dbo.QBM_TUDialogSchedule · calls QBM_PSessionErrorAdd; writes UPDATE not, UPDATE DialogSchedule; reads/joins inserted, DialogSchedule, deleted, DialogTimeZone
  • UPDATE dbo.QBM_TUJobAutoStart · calls QBM_PSQLCheckExecutable, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE DialogSchedule; reads/joins inserted, QBMEvent, DialogTable

DialogWatchOperation 4 modules

insert × 1, update × 3

  • INSERT dbo.QBM_FSQTriggerWatchTable · writes INSERT into, INSERT DialogWatchProperty, INSERT DialogWatchOperation; reads/joins QBM_FTColumnsToWatch, inserted, DialogTable, DialogColumn
  • UPDATE dbo.QBM_PA164BD06A63979BC96DA633_a · writes INSERT into, UPDATE DialogWatchOperation; reads/joins DialogWatchOperation
  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • UPDATE dbo.QBM_PProcessGroupDelete · calls QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogWatchOperation, UPDATE DialogProcessChain, UPDATE JobHistory, UPDATE DialogProcessSubstitute…; reads/joins Dialogprocess, DialogWatchOperation, DialogProcessChain, JobHistory, DialogProcessSubstitute…

ist 4 modules

insert × 4

  • INSERT dbo.TSB_TIUNSGroupB · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT ist, INSERT into; reads/joins inserted, UNSRootB
  • INSERT dbo.TSB_TIUNSGroupB1 · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT ist, INSERT into; reads/joins inserted, UNSRootB
  • INSERT dbo.TSB_TIUNSGroupB2 · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT ist, INSERT into; reads/joins inserted, UNSRootB
  • INSERT dbo.TSB_TIUNSGroupB3 · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT ist, INSERT into; reads/joins inserted, UNSRootB

JobQueueStats 4 modules

insert × 4

  • INSERT dbo.QBM_PJobQueueDelete · calls QBM_PWaitForSeconds, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobHistory, INSERT JobQueueStats, UPDATE JobQueue, DELETE Jobqueue; reads/joins JobQueue, JobTreeParamColl, JobHistory; uses config Common\JobQueueStats
  • INSERT dbo.QBM_PJobQueueLoad · calls QBM_PSessionContextSet, QBM_PJobCreate_HOFireEvent_B, QBM_PQBMServerHasJobService, sys, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, INSERT JobQueueStats, UPDATE QBMServer, UPDATE jobqueue; reads/joins QBMServer, QBM_FCVStringToListSplitted, DialogDatabase, DialogScriptAssembly, QBMFileRevision…; uses config Common\Autoupdate, Common\Jobservice\LoadedJobsTimeOut, Common\JobQueueStats; uses session context XUser, GenProcID
  • INSERT dbo.QBM_PJobQueueStatsShrink · calls QBM_PSessionContextSet, QBM_PDeleteBulk, QBM_PSessionErrorAdd; writes INSERT JobQueueStats; reads/joins DialogDatabase, jobqueuestats; uses config Common\JobQueueStats\MaxAge; uses session context XUser, GenProcID
  • INSERT dbo.QBM_TIJobqueue · calls QBM_PJobQueueOverviewSetInv, QBM_PJobCreate_HOFireEvent, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT JobQueueStats, UPDATE JobQueue; reads/joins inserted, QBMJobqueueOverview, jobchain, Jobqueue, JobQueue; uses config Common\JobQueueStats

PWODecisionHistory 4 modules

insert × 4

  • INSERT dbo.QER_PITShopHelperFill_bulk · calls as, QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QER_P04F128DC257D2B3C236MAIL_, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWODecisionHistory, INSERT PWOHelperPWO, UPDATE PersonWantsOrg, UPDATE PWOHelperPWO…; reads/joins PersonWantsOrg, QERWorkingStep, PWOHelperPWO, HelperPWOCompliance, ComplianceRule…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\PersonOrderedNoDecide, QER\ITShop\PersonInsertedNoDecide…; uses session context XUser, GenProcID
  • INSERT dbo.QER_PITShopOrderHistoryInsert · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT pwodecisionHistory; uses session context XUser, GenProcID
  • INSERT dbo.QER_PITShopOrderMove_bulk · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID
  • INSERT dbo.QER_ZITShopOrderReset · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QER_PITShopHelperFill_bulk, QER_PITShopPersonHasObjFill_b, QBM_PDBQueueInsert_Bulk…; writes INSERT into, INSERT PWODecisionHistory, UPDATE personwantsorg, DELETE HelperPWOCompliance, DELETE HelperPWOPersonhasObject…; reads/joins QBMDBQueueCurrent, PersonWantsOrg, BaseTree; uses config QER\ITShop\DecisionOnInsert; uses session context GenProcID

QERBufferRecalcDecisionMaker 4 modules

insert × 1, update × 2, delete × 1

  • UPDATE dbo.ATT_ZAttHelperFill_Recalc · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QERBufferRecalcDecisionMaker; reads/joins QERBufferRecalcDecisionMaker, AttestationHelper, sys, pwodecisionrule, QERWorkingStep…; uses config QER\Attestation
  • DELETE dbo.QER_P98F5E10C6A9349A1EBFB2C2_ · calls QBM_PWaitForSeconds, QBM_PSessionErrorAdd; writes INSERT into, DELETE QERBufferRecalcDecisionMaker; reads/joins QERBufferRecalcDecisionMaker
  • INSERT dbo.QER_PITShopHelperFill_Recalc · calls QBM_PDBQueueInsert_single, QBM_PSessionErrorAdd; writes INSERT QERBufferRecalcDecisionMaker; reads/joins PWODecisionRule, QERBufferRecalcDecisionMaker
  • UPDATE dbo.QER_ZITShopHelperFill_Recalc · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QERBufferRecalcDecisionMaker; reads/joins QERBufferRecalcDecisionMaker, sys, pwodecisionrule, QERWorkingStep, dbo…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop

DPRMemberShipAction 3 modules

insert × 1, delete × 3

  • DELETE dbo.DPR_FSQTriggerRIMemberShip · writes DELETE DPRMemberShipAction; reads/joins deleted, DPRMemberShipAction, QBM_VQBMRelation, DPRNameSpaceHasDialogTable, DialogTable…
  • INSERT dbo.DPR_FSQTriggerWatchMemberShip · calls QBM_PFESimulationFill; writes INSERT DPRMemberShipAction, INSERT into, DELETE nix, DELETE DPRMemberShipAction; reads/joins DPRMemberShipAction, DialogTable, QBM_VQBMRelation, DPRNameSpaceHasDialogTable, DialogColumn…
  • DELETE dbo.DPR_FSQTriggerWatchMemberShip · calls QBM_PFESimulationFill; writes INSERT DPRMemberShipAction, INSERT into, DELETE nix, DELETE DPRMemberShipAction; reads/joins DPRMemberShipAction, DialogTable, QBM_VQBMRelation, DPRNameSpaceHasDialogTable, DialogColumn…
  • DELETE dbo.DPR_PMemberShipActionCleanUp · calls QBM_PSessionErrorAdd; writes INSERT into, DELETE DPRMemberShipAction; reads/joins DPRMemberShipAction, DialogTable, DialogColumn, QBMElementAffectedByJob

QBMDBQueuePond 3 modules

insert × 3, update × 1

  • INSERT dbo.QBM_PDBQueueInsert_Bulk · calls QBM_PSessionErrorAdd, QBM_PJournal, QBM_PSessionContextSet, QBM_PDBQueueInsert_Int; writes INSERT into, INSERT QBMDBQueuePond; reads/joins QBMDBQueueTaskMetric; uses session context TempQueue, QBMDBQueuePond, INSERTEDINTODBQUEUE
  • INSERT dbo.QBM_PDBQueuePondEnd · calls QBM_P40B0C8AE71E45BA9C883A96_, QBM_PSessionErrorAdd; writes INSERT QBMDBQueuePond, INSERT into, UPDATE QBMDBQueuePond; reads/joins QBMDBQueuePond, QBMDBQueueTaskMetric
  • UPDATE dbo.QBM_PDBQueuePondEnd · calls QBM_P40B0C8AE71E45BA9C883A96_, QBM_PSessionErrorAdd; writes INSERT QBMDBQueuePond, INSERT into, UPDATE QBMDBQueuePond; reads/joins QBMDBQueuePond, QBMDBQueueTaskMetric
  • INSERT dbo.QBM_PTempQueueEnd · calls QBM_PSessionContextSet, QBM_P1B7262FC192C886D0EB9F74_, QBM_PSessionErrorAdd; writes INSERT QBMDBQueuePond, INSERT into; reads/joins QBMDBQueueTaskMetric; uses session context QBMDBQueuePond, INSERTEDINTODBQUEUE

ADSGroupCollection 2 modules

insert × 1, update × 2, delete × 1

  • INSERT dbo.ADS_ZGroupInADSGroup · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT ADSGroupCollection, UPDATE ADSGroupCollection, DELETE ADSGroupCollection; reads/joins QBMDBQueueCurrent, ADSGroupCollection, ADSGroupInADSGroup; uses session context GenProcID
  • UPDATE dbo.ADS_ZGroupInADSGroup · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT ADSGroupCollection, UPDATE ADSGroupCollection, DELETE ADSGroupCollection; reads/joins QBMDBQueueCurrent, ADSGroupCollection, ADSGroupInADSGroup; uses session context GenProcID
  • DELETE dbo.ADS_ZGroupInADSGroup · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT ADSGroupCollection, UPDATE ADSGroupCollection, DELETE ADSGroupCollection; reads/joins QBMDBQueueCurrent, ADSGroupCollection, ADSGroupInADSGroup; uses session context GenProcID
  • UPDATE dbo.ADS_ZGroupInADSGroup_Circ · calls QBM_PSessionErrorAdd; writes UPDATE ADSGroupCollection; reads/joins ADSGroupCollection

HelperPWOPersonHasObject 2 modules

insert × 1, update × 1, delete × 2

  • INSERT dbo.QER_PITShopPersonHasObjFill_b · calls as, SAC_PITShopPersonHasObjectFill, QBM_PExecuteSQLMulti, QBM_PSessionErrorAdd; writes INSERT into, INSERT HelperPWOPersonHasObject, UPDATE HelperPWOPersonHasObject, DELETE HelperPWOPersonHasObject; reads/joins ComplianceRule, personwantsorg, BaseTree, BaseTreeAssign, QERAssign…
  • UPDATE dbo.QER_PITShopPersonHasObjFill_b · calls as, SAC_PITShopPersonHasObjectFill, QBM_PExecuteSQLMulti, QBM_PSessionErrorAdd; writes INSERT into, INSERT HelperPWOPersonHasObject, UPDATE HelperPWOPersonHasObject, DELETE HelperPWOPersonHasObject; reads/joins ComplianceRule, personwantsorg, BaseTree, BaseTreeAssign, QERAssign…
  • DELETE dbo.QER_PITShopPersonHasObjFill_b · calls as, SAC_PITShopPersonHasObjectFill, QBM_PExecuteSQLMulti, QBM_PSessionErrorAdd; writes INSERT into, INSERT HelperPWOPersonHasObject, UPDATE HelperPWOPersonHasObject, DELETE HelperPWOPersonHasObject; reads/joins ComplianceRule, personwantsorg, BaseTree, BaseTreeAssign, QERAssign…
  • DELETE dbo.QER_ZITShopOrderReset · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QER_PITShopHelperFill_bulk, QER_PITShopPersonHasObjFill_b, QBM_PDBQueueInsert_Bulk…; writes INSERT into, INSERT PWODecisionHistory, UPDATE personwantsorg, DELETE HelperPWOCompliance, DELETE HelperPWOPersonhasObject…; reads/joins QBMDBQueueCurrent, PersonWantsOrg, BaseTree; uses config QER\ITShop\DecisionOnInsert; uses session context GenProcID

LDAPGroupCollection 2 modules

insert × 1, update × 2, delete × 1

  • INSERT dbo.LDP_ZGroupInLDAPGroup · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT LDAPGroupCollection, UPDATE LDAPGroupCollection, DELETE LDAPGroupCollection; reads/joins QBMDBQueueCurrent, LDAPGroupCollection, LDAPGroupInLDAPGroup; uses session context GenProcID
  • UPDATE dbo.LDP_ZGroupInLDAPGroup · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT LDAPGroupCollection, UPDATE LDAPGroupCollection, DELETE LDAPGroupCollection; reads/joins QBMDBQueueCurrent, LDAPGroupCollection, LDAPGroupInLDAPGroup; uses session context GenProcID
  • DELETE dbo.LDP_ZGroupInLDAPGroup · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT LDAPGroupCollection, UPDATE LDAPGroupCollection, DELETE LDAPGroupCollection; reads/joins QBMDBQueueCurrent, LDAPGroupCollection, LDAPGroupInLDAPGroup; uses session context GenProcID
  • UPDATE dbo.LDP_ZGroupInLDAPGroup_Circ · calls QBM_PSessionErrorAdd; writes UPDATE LDAPGroupCollection; reads/joins LDAPGroupCollection

QBMTableRevision 2 modules

insert × 1, update × 2, delete × 1

  • UPDATE dbo.QBM_PTableRevisionFill · calls QBM_PSessionErrorAdd; writes UPDATE QBMTableRevision, DELETE when, DELETE QBMTableRevision; reads/joins QBM_VTablesForRevision, QBMTableRevision, sys; uses config Common\TableRevision
  • DELETE dbo.QBM_PTableRevisionFill · calls QBM_PSessionErrorAdd; writes UPDATE QBMTableRevision, DELETE when, DELETE QBMTableRevision; reads/joins QBM_VTablesForRevision, QBMTableRevision, sys; uses config Common\TableRevision
  • INSERT dbo.QBM_PTableRevisionSetMulti_i · writes INSERT into, INSERT machen, INSERT QBMTableRevision, UPDATE machen, UPDATE QBMTableRevision; reads/joins string_split, sys, QBMTableRevision
  • UPDATE dbo.QBM_PTableRevisionSetMulti_i · writes INSERT into, INSERT machen, INSERT QBMTableRevision, UPDATE machen, UPDATE QBMTableRevision; reads/joins string_split, sys, QBMTableRevision

UNSGroupB1Collection 2 modules

insert × 1, update × 2, delete × 1

  • INSERT dbo.TSB_ZUNSGroupB1InUNSGroupB1 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB1Collection, UPDATE UNSGroupB1Collection, DELETE UNSGroupB1Collection; reads/joins QBMDBQueueCurrent, UNSGroupB1Collection, UNSGroupB1InUNSGroupB1, UNSGroupB1; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupB1InUNSGroupB1 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB1Collection, UPDATE UNSGroupB1Collection, DELETE UNSGroupB1Collection; reads/joins QBMDBQueueCurrent, UNSGroupB1Collection, UNSGroupB1InUNSGroupB1, UNSGroupB1; uses session context GenProcID
  • DELETE dbo.TSB_ZUNSGroupB1InUNSGroupB1 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB1Collection, UPDATE UNSGroupB1Collection, DELETE UNSGroupB1Collection; reads/joins QBMDBQueueCurrent, UNSGroupB1Collection, UNSGroupB1InUNSGroupB1, UNSGroupB1; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupB1InUNSGroupB1_C · calls QBM_PSessionErrorAdd; writes UPDATE UNSGroupB1Collection; reads/joins UNSGroupB1Collection

UNSGroupB2Collection 2 modules

insert × 1, update × 2, delete × 1

  • INSERT dbo.TSB_ZUNSGroupB2InUNSGroupB2 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB2Collection, UPDATE UNSGroupB2Collection, DELETE UNSGroupB2Collection; reads/joins QBMDBQueueCurrent, UNSGroupB2Collection, UNSGroupB2InUNSGroupB2, UNSGroupB2; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupB2InUNSGroupB2 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB2Collection, UPDATE UNSGroupB2Collection, DELETE UNSGroupB2Collection; reads/joins QBMDBQueueCurrent, UNSGroupB2Collection, UNSGroupB2InUNSGroupB2, UNSGroupB2; uses session context GenProcID
  • DELETE dbo.TSB_ZUNSGroupB2InUNSGroupB2 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB2Collection, UPDATE UNSGroupB2Collection, DELETE UNSGroupB2Collection; reads/joins QBMDBQueueCurrent, UNSGroupB2Collection, UNSGroupB2InUNSGroupB2, UNSGroupB2; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupB2InUNSGroupB2_C · calls QBM_PSessionErrorAdd; writes UPDATE UNSGroupB2Collection; reads/joins UNSGroupB2Collection

UNSGroupB3Collection 2 modules

insert × 1, update × 2, delete × 1

  • INSERT dbo.TSB_ZUNSGroupB3InUNSGroupB3 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB3Collection, UPDATE UNSGroupB3Collection, DELETE UNSGroupB3Collection; reads/joins QBMDBQueueCurrent, UNSGroupB3Collection, UNSGroupB3InUNSGroupB3, UNSGroupB3; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupB3InUNSGroupB3 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB3Collection, UPDATE UNSGroupB3Collection, DELETE UNSGroupB3Collection; reads/joins QBMDBQueueCurrent, UNSGroupB3Collection, UNSGroupB3InUNSGroupB3, UNSGroupB3; uses session context GenProcID
  • DELETE dbo.TSB_ZUNSGroupB3InUNSGroupB3 · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupB3Collection, UPDATE UNSGroupB3Collection, DELETE UNSGroupB3Collection; reads/joins QBMDBQueueCurrent, UNSGroupB3Collection, UNSGroupB3InUNSGroupB3, UNSGroupB3; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupB3InUNSGroupB3_C · calls QBM_PSessionErrorAdd; writes UPDATE UNSGroupB3Collection; reads/joins UNSGroupB3Collection

UNSGroupBCollection 2 modules

insert × 1, update × 2, delete × 1

  • INSERT dbo.TSB_ZUNSGroupBInUNSGroupB · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupBCollection, UPDATE UNSGroupBCollection, DELETE UNSGroupBCollection; reads/joins QBMDBQueueCurrent, UNSGroupBCollection, UNSGroupBInUNSGroupB, UNSGroupB; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupBInUNSGroupB · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupBCollection, UPDATE UNSGroupBCollection, DELETE UNSGroupBCollection; reads/joins QBMDBQueueCurrent, UNSGroupBCollection, UNSGroupBInUNSGroupB, UNSGroupB; uses session context GenProcID
  • DELETE dbo.TSB_ZUNSGroupBInUNSGroupB · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSGroupBCollection, UPDATE UNSGroupBCollection, DELETE UNSGroupBCollection; reads/joins QBMDBQueueCurrent, UNSGroupBCollection, UNSGroupBInUNSGroupB, UNSGroupB; uses session context GenProcID
  • UPDATE dbo.TSB_ZUNSGroupBInUNSGroupB_C · calls QBM_PSessionErrorAdd; writes UPDATE UNSGroupBCollection; reads/joins UNSGroupBCollection

AttestationHistory 3 modules

insert × 3

  • INSERT dbo.ATT_PAttestationHelperFill · calls as, QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, INSERT AttestationHelper, UPDATE AttestationHelper, UPDATE AttestationCase…; reads/joins attestationCase, AttestationCase, AttestationPolicy, AttestationHelper, QERWorkingStep…; uses config QER\Attestation\PersonToAttestNoDecide; uses session context XUser, GenProcID
  • INSERT dbo.ATT_ZAttestationReset · calls QER_PGIQERWorkingMethod, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, UPDATE AttestationCase, DELETE AttestationHelper; reads/joins QBMDBQueueCurrent, AttestationCase, AttestationPolicy; uses session context GenProcID
  • INSERT dbo.ATT_TUPerson · calls QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOUpdate_L, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, UPDATE not, UPDATE AttestationCase; reads/joins inserted, deleted, BaseTree, Person, AttestationCase…; uses config QER\Attestation\AutoCloseInactivePerson

DialogMultiLanguage 3 modules

insert × 2, delete × 1

  • DELETE dbo.QBM_PMultilanguageDoubleClear · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT MDKMLGuidReplace, DELETE DialogMultiLanguage; reads/joins DialogMultiLanguage, DialogColumn, DialogTable, QBMModuleDef, QBMModuleDependCollection…
  • INSERT dbo.QBM_PMultilanguageFill · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT DialogMultiLanguage; reads/joins DialogDatabase, DialogMultiLanguage, DialogColumn, DialogTable
  • INSERT dbo.QBM_PMultilanguageFillSQL · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMTranslationAddOnSource, INSERT DialogMultiLanguage; reads/joins DialogDatabase, sys, QBMTranslationAddOnSource, DialogMultiLanguage

EsetHasEntitlement 3 modules

update × 3

  • UPDATE dbo.ADS_TUAdsGroup · calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk…; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE BaseTreeHasADSGroup, UPDATE ADSAccountInADSGroup…; reads/joins QER_VPWOProductNodesSlim, inserted, deleted, ADSGroup, ADSGroupExclusion…; uses session context Fullsync
  • UPDATE dbo.LDP_TULDAPGroup · calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE LDPMachineInLDAPGroup, UPDATE BaseTreeHasLDAPGroup, UPDATE LDAPAccountInLDAPGroup…; reads/joins QER_VPWOProductNodesSlim, inserted, deleted, LDAPGroup, LDAPGroupExclusion…; uses session context Fullsync
  • UPDATE dbo.RMS_TUESetHasEntitlement · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE ESetHasEntitlement; reads/joins deleted, inserted, ESetHasEntitlement, Eset, ESet…

for 3 modules

insert × 1, update × 1, delete × 1

BaseTreeCollectionF 2 modules

insert × 2, delete × 1

  • INSERT dbo.QER_ZBaseTreeCollectionF · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeCollectionF, DELETE BaseTreeCollectionF; reads/joins QBMDBQueueCurrent, BaseTreeCollectionF, BaseTree; uses session context GenProcID
  • DELETE dbo.QER_ZBaseTreeCollectionF · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeCollectionF, DELETE BaseTreeCollectionF; reads/joins QBMDBQueueCurrent, BaseTreeCollectionF, BaseTree; uses session context GenProcID
  • INSERT dbo.QER_TIBaseTree · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT BaseTreeCollectionF, INSERT node, INSERT BaseTreecollection; reads/joins inserted, DialogGroup, BaseTreeCollectionF, BaseTree, OrgRoot…

HelperPWOCompliance 2 modules

insert × 1, delete × 2

  • INSERT dbo.CPL_ZITShopMakeDecisionCR · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod, QBM_PSessionErrorAdd; writes INSERT into, INSERT HelperPWOCompliance, DELETE HelperPWOCompliance; reads/joins QBMDBQueueCurrent, personwantsorg, pwohelperpwo, QERWorkingStep, CPL_FTCCSPWOCheck…; uses config Common\ProcessState\UseGenProcIDFromPWO; uses session context GenProcID
  • DELETE dbo.CPL_ZITShopMakeDecisionCR · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod, QBM_PSessionErrorAdd; writes INSERT into, INSERT HelperPWOCompliance, DELETE HelperPWOCompliance; reads/joins QBMDBQueueCurrent, personwantsorg, pwohelperpwo, QERWorkingStep, CPL_FTCCSPWOCheck…; uses config Common\ProcessState\UseGenProcIDFromPWO; uses session context GenProcID
  • DELETE dbo.QER_ZITShopOrderReset · calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QER_PITShopHelperFill_bulk, QER_PITShopPersonHasObjFill_b, QBM_PDBQueueInsert_Bulk…; writes INSERT into, INSERT PWODecisionHistory, UPDATE personwantsorg, DELETE HelperPWOCompliance, DELETE HelperPWOPersonhasObject…; reads/joins QBMDBQueueCurrent, PersonWantsOrg, BaseTree; uses config QER\ITShop\DecisionOnInsert; uses session context GenProcID

jobtreeparamcoll 2 modules

insert × 1, update × 1, delete × 1

  • INSERT dbo.QBM_PJobSetRunParameter · calls QBM_PSessionErrorAdd; writes INSERT jobtreeparamcoll, UPDATE JobTreeParamColl; reads/joins jobqueue, JobTreeParamColl
  • UPDATE dbo.QBM_PJobSetRunParameter · calls QBM_PSessionErrorAdd; writes INSERT jobtreeparamcoll, UPDATE JobTreeParamColl; reads/joins jobqueue, JobTreeParamColl
  • DELETE dbo.QBM_TDJobqueue · calls QBM_PJobQueueOverviewSetInv, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE QBMElementAffectedByJob, DELETE JobtreeParamColl; reads/joins deleted, QBMJobqueueOverview, QBMElementAffectedByJob, JobtreeParamColl

QBMModuleDef 2 modules

insert × 1, update × 1, delete × 1

  • INSERT dbo.QBM_PModuleDependCollFill · calls QBM_PTransportHistoryInsert, QBM_PSessionErrorAdd; writes INSERT QBMModuleDef, INSERT QBMModuleDependCollection, UPDATE QBMModuleDef, DELETE QBMModuleDependCollection; reads/joins QBMModuleDef, QBMModuledepend, QBMModuleDependCollection, QBMModuleDepend, hierarchy; uses session context XUser
  • UPDATE dbo.QBM_PModuleDependCollFill · calls QBM_PTransportHistoryInsert, QBM_PSessionErrorAdd; writes INSERT QBMModuleDef, INSERT QBMModuleDependCollection, UPDATE QBMModuleDef, DELETE QBMModuleDependCollection; reads/joins QBMModuleDef, QBMModuledepend, QBMModuleDependCollection, QBMModuleDepend, hierarchy; uses session context XUser
  • DELETE dbo.QBM_PModuleRemove · calls QBM_PDBQueueActivityDisable, QBM_PWatchDogPrepare, QBM_PFunctionDrop, QBM_PProcedureDrop, QBM_PViewDrop…; writes INSERT into, DELETE does, DELETE module, DELETE list, DELETE them…; reads/joins QBM_FCVStringToList, QBMModuleDef, QBMModuleDepend, sys, DialogTable…

QERWorkingMethod 2 modules

insert × 1, update × 1, delete × 1

  • INSERT dbo.QER_PGIQERWorkingMethod · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT QERWorkingMethod, INSERT QERWorkingStep, INSERT into, UPDATE QERWorkingMethod; reads/joins PWODecisionMethod, PWODecisionSubMethod, QERWorkingMethod, PWODecisionStep, QERWorkingStep; uses session context QER_PGIQERWorkingMethod, GenProcID
  • UPDATE dbo.QER_PGIQERWorkingMethod · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT QERWorkingMethod, INSERT QERWorkingStep, INSERT into, UPDATE QERWorkingMethod; reads/joins PWODecisionMethod, PWODecisionSubMethod, QERWorkingMethod, PWODecisionStep, QERWorkingStep; uses session context QER_PGIQERWorkingMethod, GenProcID
  • DELETE dbo.QER_ZQERWorkingMethodCleanUp · calls QBM_PSessionErrorAdd; writes INSERT into, DELETE QERWorkingMethod; reads/joins PersonWantsOrg, QERWorkingMethod, PWOHelperPWO, QERWorkingStep, AttestationCase…

AccProductGroupCollection 1 modules

insert × 1, update × 1, delete × 1

  • INSERT dbo.QER_ZAccProductGroupCollection · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT AccProductGroupCollection, UPDATE AccProductGroupCollection, DELETE AccProductGroupCollection; reads/joins QBMDBQueueCurrent, AccProductGroupCollection, AccProductGroup; uses session context GenProcID
  • UPDATE dbo.QER_ZAccProductGroupCollection · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT AccProductGroupCollection, UPDATE AccProductGroupCollection, DELETE AccProductGroupCollection; reads/joins QBMDBQueueCurrent, AccProductGroupCollection, AccProductGroup; uses session context GenProcID
  • DELETE dbo.QER_ZAccProductGroupCollection · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT AccProductGroupCollection, UPDATE AccProductGroupCollection, DELETE AccProductGroupCollection; reads/joins QBMDBQueueCurrent, AccProductGroupCollection, AccProductGroup; uses session context GenProcID

BaseTreeOwnsObject 1 modules

insert × 1, update × 1, delete × 1

  • INSERT dbo.QER_PBasetreeOwnsObjectPost_L · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeOwnsObject, UPDATE BaseTreeOwnsObject, DELETE BaseTreeOwnsObject; reads/joins BaseTreeOwnsObject; uses session context GenProcID
  • UPDATE dbo.QER_PBasetreeOwnsObjectPost_L · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeOwnsObject, UPDATE BaseTreeOwnsObject, DELETE BaseTreeOwnsObject; reads/joins BaseTreeOwnsObject; uses session context GenProcID
  • DELETE dbo.QER_PBasetreeOwnsObjectPost_L · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeOwnsObject, UPDATE BaseTreeOwnsObject, DELETE BaseTreeOwnsObject; reads/joins BaseTreeOwnsObject; uses session context GenProcID

PersonHasObject 1 modules

insert × 1, update × 1, delete × 1

  • INSERT dbo.QER_PPersonHasObjectPostProc · calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT PersonHasObject, UPDATE PersonHasObject, DELETE PersonHasObject; reads/joins PersonHasObject, person; uses session context GenProcID
  • UPDATE dbo.QER_PPersonHasObjectPostProc · calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT PersonHasObject, UPDATE PersonHasObject, DELETE PersonHasObject; reads/joins PersonHasObject, person; uses session context GenProcID
  • DELETE dbo.QER_PPersonHasObjectPostProc · calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT PersonHasObject, UPDATE PersonHasObject, DELETE PersonHasObject; reads/joins PersonHasObject, person; uses session context GenProcID

QBMMissingDisplayRight 1 modules

insert × 1, update × 1, delete × 1

  • INSERT dbo.QBM_PMissingDisplayRightFill · calls QBM_PSessionErrorAdd, QBM_PJournal; writes INSERT into, INSERT QBMMissingDisplayRight, UPDATE QBMMissingDisplayRight, DELETE QBMMissingDisplayRight; reads/joins DialogTable, DialogColumn, QBM_VQBMRelationALL, DialogTableGroupRight, DialogColumnGroupRight…
  • UPDATE dbo.QBM_PMissingDisplayRightFill · calls QBM_PSessionErrorAdd, QBM_PJournal; writes INSERT into, INSERT QBMMissingDisplayRight, UPDATE QBMMissingDisplayRight, DELETE QBMMissingDisplayRight; reads/joins DialogTable, DialogColumn, QBM_VQBMRelationALL, DialogTableGroupRight, DialogColumnGroupRight…
  • DELETE dbo.QBM_PMissingDisplayRightFill · calls QBM_PSessionErrorAdd, QBM_PJournal; writes INSERT into, INSERT QBMMissingDisplayRight, UPDATE QBMMissingDisplayRight, DELETE QBMMissingDisplayRight; reads/joins DialogTable, DialogColumn, QBM_VQBMRelationALL, DialogTableGroupRight, DialogColumnGroupRight…

ADSAccountInADSGroup 2 modules

update × 2

  • UPDATE dbo.ADS_TUADSAccount · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE ADSAccountInADSGroup, DELETE ADSOtherSID; reads/joins inserted, deleted, ADSGroup, ADSAccount, ADSAccountInADSGroup…; uses session context Fullsync
  • UPDATE dbo.ADS_TUAdsGroup · calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk…; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE BaseTreeHasADSGroup, UPDATE ADSAccountInADSGroup…; reads/joins QER_VPWOProductNodesSlim, inserted, deleted, ADSGroup, ADSGroupExclusion…; uses session context Fullsync

ADSMachineInADSGroup 2 modules

update × 2

  • UPDATE dbo.ADS_TUAdsGroup · calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk…; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE BaseTreeHasADSGroup, UPDATE ADSAccountInADSGroup…; reads/joins QER_VPWOProductNodesSlim, inserted, deleted, ADSGroup, ADSGroupExclusion…; uses session context Fullsync
  • UPDATE dbo.ADS_TUADSMachine · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT ADSOtherSID, UPDATE not, UPDATE ADSMachineInADSGroup, DELETE ADSOtherSID; reads/joins inserted, deleted, ADSMachine, ADSMachineInADSGroup, ADSOtherSID; uses session context Fullsync

AttestationRun 2 modules

update × 1, delete × 1

  • UPDATE dbo.ATT_PAttestationCaseCreate · calls QER_PGIQERWorkingMethod, ATT_PAttestationCaseCreate_i, QBM_PSessionErrorAdd; writes INSERT into, INSERT JobQueue, INSERT QBMElementAffectedByJob, UPDATE AttestationRun; reads/joins AttestationPolicy, QBM_FTHexPattern, AttestationRun; uses session context XUser
  • DELETE dbo.ATT_ZAttestationRunDeleteOld · calls QBM_PSessionErrorAdd; writes DELETE AttestationRun; reads/joins AttestationRun, AttestationCase

DialogDeferredOperation 2 modules

update × 2

  • UPDATE dbo.QBM_PDialogProcessShrink_3 · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogProcess, UPDATE DialogDBQueue, UPDATE QBMDBQueueCurrent, UPDATE DialogDeferredOperation…; reads/joins DialogDBQueue, DialogProcessSubstitute
  • UPDATE dbo.QBM_ZDeferredOperationExecute · calls QBM_PJobCreate_HOFireEvent, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogDeferredOperation; reads/joins DialogDeferredOperation, QBM_FTParameter1AsInClause

DialogJournal 2 modules

insert × 2

  • INSERT dbo.QBM_PWriteDialogJournal · calls QBM_PSessionErrorAdd; writes INSERT DialogJournal; reads/joins sys, DialogJournal
  • INSERT dbo.QBM_ZConnectionClearUnused · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogJournal; reads/joins DialogDatabase, sys

DialogScriptAssembly 2 modules

update × 2

  • UPDATE dbo.QBM_PBufferT_ProcessTable · calls QBM_PSessionErrorAdd, QBM_PTriggersInactiveForTable, QBM_PBufferT_ProcessUpdate, QBM_PJournal, QBM_PBufferT_ProcessInsert; writes INSERT into, UPDATE DialogScriptAssembly; reads/joins QBMModuleDef, QBMModuleDependCollection, DialogTable, sys, QBMBufferTransfer…
  • UPDATE dbo.QBM_ZScriptAssemblyReset · calls QBM_PDBQueueInsert_WaitForComp, QBM_PSessionErrorAdd; writes UPDATE dialogscriptassembly

DialogState 2 modules

update × 2

  • UPDATE dbo.QBM_ZStateUTCOffset · calls QBM_PDBQueueInsert_bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogState; reads/joins QBMDBQueueCurrent, DialogState, DialogStateHasTimeZone, DialogTimeZone
  • UPDATE dbo.QBM_ZStateUTCOffset2 · calls QBM_PSessionErrorAdd; writes UPDATE DialogState; reads/joins DialogState, QBMDBQueueCurrent, DialogCountry, DialogStateHasTimeZone

DialogValidDynamicRef 2 modules

delete × 2

  • DELETE dbo.QBM_PColumnCustomRemove · calls QBM_PIndexDrop, QBM_PJournal, QBM_PWaitForSeconds, QBM_PSessionErrorAdd, QBM_PExecuteSQLWithRetry_LLP…; writes INSERT into, DELETE QBMRelation, DELETE DialogValidDynamicRef, DELETE DialogColumnGroupRight, DELETE DialogColumn…; reads/joins DialogTable, DialogColumn, DialogDatabase, INFORMATION_SCHEMA, sys…
  • DELETE dbo.QBM_PTableDrop · calls QBM_PSchemaBindDisable, QBM_PConstraintFKDrop, QBM_PSessionErrorAdd; writes INSERT into, DELETE Object, DELETE Table, DELETE QBMRelation, DELETE DialogValidDynamicRef…; reads/joins sys, QBM_VQBMRelationALL, DialogTable, QBM_VQBMRelation, QBMRelation…

DialogWatchProperty 2 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_FSQTriggerWatchTable · writes INSERT into, INSERT DialogWatchProperty, INSERT DialogWatchOperation; reads/joins QBM_FTColumnsToWatch, inserted, DialogTable, DialogColumn
  • DELETE dbo.QBM_TDDialogWatchOperation · calls QBM_PSessionErrorAdd; writes DELETE not, DELETE DialogWatchProperty; reads/joins deleted, DialogWatchProperty

in 2 modules

update × 1, delete × 1

  • DELETE dbo.QBM_PJobCreate_SQLDel · calls QBM_PJobCreate, SQL, QBM_PSessionErrorAdd; writes INSERT into, DELETE in; reads/joins DialogTable
  • UPDATE dbo.QBM_TUDialogDatabase · calls QBM_PDBQueueInsert_Single, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE not, UPDATE DialogConfigParm, UPDATE in; reads/joins inserted, deleted, DialogDatabase; uses config QBM\DBQueue\CountSlotsMax, QBM\DBQueue\KeepAlive; uses session context INSERTEDINTODBQUEUE

ITShopOrgHasPWODecisionMethod 2 modules

insert × 2

  • INSERT dbo.QER_PITShop_BoardMove · calls QER_PITShopCheckMethodBO, QER_PITShop_PRNodesMove, QER_PITShopProductNodeCheck, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT into, DELETE Basetree; reads/joins BaseTree, Basetree, ITShopOrgHasPWODecisionMethod, ITShopOrg
  • INSERT dbo.QER_PITShop_ShopMove · calls QBM_PJobCreate_HOTemplate_B, QER_PITShop_BoardMove, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT PersonInITShopOrg, INSERT DynamicGroup, INSERT into…; reads/joins Basetree, BaseTree, ITShopOrgHasPWODecisionMethod, PersonInITShopOrg, DynamicGroup…

node 2 modules

insert × 1, update × 1

  • INSERT dbo.QER_TIBaseTree · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT BaseTreeCollectionF, INSERT node, INSERT BaseTreecollection; reads/joins inserted, DialogGroup, BaseTreeCollectionF, BaseTree, OrgRoot…
  • UPDATE dbo.QER_TUBaseTree · calls QBM_PDBQueueInsert_Bulk, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE node; reads/joins inserted, deleted, BaseTree, PersonWantsOrg, DynamicGroup…; uses config QER\ITShop\OnWorkflowAssign

person 2 modules

update × 1, delete × 1

  • DELETE dbo.QER_TDPerson · calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE person, DELETE delegation; reads/joins deleted, QERUniversalSubstitute, delegation, PersonWantsOrg
  • UPDATE dbo.QER_TIPerson · calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOFireEvent_L, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT HelperHeadPerson, UPDATE Person; reads/joins inserted, QERUniversalSubstitute, Person, HelperHeadPerson; uses session context XUser

QBMBufferTransfer 2 modules

delete × 2

  • DELETE dbo.QBM_PBufferT_DeleteNonlinear · calls QBM_PNonlinear_SetFound, QBM_PSessionErrorAdd; writes INSERT into, DELETE QBMBufferTransfer; reads/joins QBMNonLinearDepend, QBMModuleDef, QBMBufferTransfer
  • DELETE dbo.QBM_PBufferT_ProcessAll_Delta · calls QBM_PBufferT_ProcAll_Delta_i, QBM_PBufferT_DeleteNonlinear, QBM_PSessionErrorAdd; writes DELETE QBMBufferTransfer; reads/joins QBMBufferTransfer

QBMGuidReplace 2 modules

insert × 1, delete × 1

QBMTranslationAddOnSource 2 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_PMultilanguageFillSQL · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMTranslationAddOnSource, INSERT DialogMultiLanguage; reads/joins DialogDatabase, sys, QBMTranslationAddOnSource, DialogMultiLanguage
  • DELETE dbo.QBM_PQBMTranslationAddOnClean · calls QBM_PSessionErrorAdd; writes DELETE QBMTranslationAddOnSource; reads/joins QBMTranslationAddOnSource, DialogMultiLanguage, QBMModuleDef, QBMModuleDependCollection

QERDynamicGroupBlackList 2 modules

update × 2

  • UPDATE dbo.QER_PDynamicGroupMakeProc_hlp · calls QER_PDynamicGroupMakeProc_Drop, QBM_PDBQueueCalculateDelta, QBM_PMNTableOriginUpdate, QER_PMNTableAddViewProperties, QBM_PMNTableInsert…; writes INSERT into, UPDATE QERDynamicGroupBlackList; reads/joins DynamicGroup, DialogTable, BaseTree, QBMDBQueueCurrent, QERDynamicGroupBlackList…
  • UPDATE dbo.QER_ZAllForPersonInBaseTree · calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOCallMethod, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QERDynamicGroupBlackList; reads/joins QBMDBQueueCurrent, PersonInBaseTree, BaseTree, DynamicGroup, QERDynamicGroupBlackList…; uses config Common\ProcessState\UseGenProcIDFromPWO

QERPolicyHasObject 2 modules

update × 1, delete × 1

  • UPDATE dbo.POL_ZQERPolicyFill · calls QBM_PJobCreate_HODelete_L, QBM_PMNTableInsertOwnPK, QBM_PSessionErrorAdd, QBM_PSessionContextSet; writes INSERT into, UPDATE QERPolicyHasObject; reads/joins sys, QERPolicyHasObject, QERPolicy; uses session context GenProcID
  • DELETE dbo.QER_PPersonDelete_GDPR · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod_L, QBM_PJobCreate_HODelete, QBM_PWaitForSeconds, QBM_PDeleteDeep…; writes INSERT into, UPDATE PersonWantsOrg, UPDATE AttestationCase, UPDATE TroubleWorkTimes, UPDATE PersonHasTSBAccountDef…; reads/joins Person, sys, person, AttestationCase, PersonWantsOrg…; uses session context GenProcID

RPSSubscription 2 modules

update × 2

  • UPDATE dbo.RPS_TIPersonHasRPSReport · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, UPDATE RPSSubscription; reads/joins inserted, RPSReport
  • UPDATE dbo.RPS_TUPersonHasRPSReport · calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE RPSSubscription; reads/joins inserted, deleted, PersonHasRPSReport

SET 2 modules

delete × 2

  • DELETE dbo.QBM_FSQFKCheckDynamic · writes INSERT object, INSERT into, UPDATE object, DELETE SET, DELETE RESTRICT; reads/joins QBM_VDialogValidDynamicRef_Exp, DialogColumn, DialogTable, deleted, inserted
  • DELETE dbo.QBM_FSQFKCheckFix · calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HODelete_B; writes INSERT object, INSERT into, UPDATE object, DELETE cascade, DELETE no…; reads/joins QBM_VQBMRelation, DialogColumn, deleted, inserted, PersonWantsOrg…

trigger 2 modules

insert × 1, update × 1

  • INSERT dbo.QBM_TIDialogTable · calls QBM_PPrePropCheckSyntax, QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QBM_PGUIDReplaceCustomizerFill, QBM_PDBQueueInsert_Single…; writes INSERT not, INSERT trigger, INSERT into; reads/joins inserted, DialogTable, dialogtable, QBM_VQBMRelationALL
  • UPDATE dbo.QER_TUHelperHeadOrg · calls QBM_PJournal, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOCallMethod, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE trigger, DELETE Delegation; reads/joins deleted, inserted, HelperHeadOrg, Basetree, Delegation…; uses config Common\ProcessState\UseGenProcIDFromPWO

ComplianceSubRuleObject 1 modules

insert × 1, delete × 1

  • INSERT dbo.CPL_ZSubRuleFillObject · calls QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PDBQueueCalculateDelta, QBM_PSessionErrorAdd; writes INSERT into, INSERT ComplianceSubRuleObject, DELETE ComplianceSubRuleObject; reads/joins ComplianceSubRule, ComplianceRule, ComplianceSubRuleObject; uses session context GenProcID
  • DELETE dbo.CPL_ZSubRuleFillObject · calls QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PDBQueueCalculateDelta, QBM_PSessionErrorAdd; writes INSERT into, INSERT ComplianceSubRuleObject, DELETE ComplianceSubRuleObject; reads/joins ComplianceSubRule, ComplianceRule, ComplianceSubRuleObject; uses session context GenProcID

ComplianceSubRulePerson 1 modules

insert × 1, delete × 1

  • INSERT dbo.CPL_PSubRuleFillPerson_i · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT ComplianceSubRulePerson, DELETE ComplianceSubRulePerson; reads/joins ComplianceRule, QER_VPersonsAreMe, QBM_FCVStringToListSQLMorphem, Person, ComplianceSubRulePerson; uses session context GenProcID
  • DELETE dbo.CPL_PSubRuleFillPerson_i · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT ComplianceSubRulePerson, DELETE ComplianceSubRulePerson; reads/joins ComplianceRule, QER_VPersonsAreMe, QBM_FCVStringToListSQLMorphem, Person, ComplianceSubRulePerson; uses session context GenProcID

DialogCalendar 1 modules

insert × 1, update × 1

  • INSERT dbo.QBM_ZCalendarFill · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT DialogCalendar, UPDATE DialogCalendar; reads/joins DialogCalendar; uses config Common\Calendar\YearsFuture, Common\Calendar\YearsPast; uses session context GenProcID
  • UPDATE dbo.QBM_ZCalendarFill · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT DialogCalendar, UPDATE DialogCalendar; reads/joins DialogCalendar; uses config Common\Calendar\YearsFuture, Common\Calendar\YearsPast; uses session context GenProcID

DialogDashBoardContent 1 modules

insert × 1, update × 1

  • INSERT dbo.QBM_ZDashBoardContentCalculate · calls QBM_PDBQueueInsert_Single, QBM_PSessionContextSet, QBM_PSessionErrorAdd, QBM_PJobCreate_SQLDel; writes INSERT DialogDashBoardContent, UPDATE dialogDashBoardContent; reads/joins DialogDashboardDef, sys; uses session context GenProcID
  • UPDATE dbo.QBM_ZDashBoardContentCalculate · calls QBM_PDBQueueInsert_Single, QBM_PSessionContextSet, QBM_PSessionErrorAdd, QBM_PJobCreate_SQLDel; writes INSERT DialogDashBoardContent, UPDATE dialogDashBoardContent; reads/joins DialogDashboardDef, sys; uses session context GenProcID

DialogGroupCollection 1 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_ZGroupCollection · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogGroupCollection, DELETE DialogGroupCollection; reads/joins DialogGroupCollection, DialogGroup, DialogGroupInGroup, dialogGroup; uses session context GenProcID
  • DELETE dbo.QBM_ZGroupCollection · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT DialogGroupCollection, DELETE DialogGroupCollection; reads/joins DialogGroupCollection, DialogGroup, DialogGroupInGroup, dialogGroup; uses session context GenProcID

DialogTableHasCustomizer 1 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_PGUIDReplaceCustomizerFill · calls QBM_PSessionErrorAdd; writes INSERT DialogTableHasCustomizer, DELETE DialogTableHasCustomizer; reads/joins DialogCustomizer, QBMClrType, DialogTable, DialogTableHasCustomizer
  • DELETE dbo.QBM_PGUIDReplaceCustomizerFill · calls QBM_PSessionErrorAdd; writes INSERT DialogTableHasCustomizer, DELETE DialogTableHasCustomizer; reads/joins DialogCustomizer, QBMClrType, DialogTable, DialogTableHasCustomizer

DynamicGroup 1 modules

insert × 1, delete × 1

  • INSERT dbo.QER_PITShop_ShopMove · calls QBM_PJobCreate_HOTemplate_B, QER_PITShop_BoardMove, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT PersonInITShopOrg, INSERT DynamicGroup, INSERT into…; reads/joins Basetree, BaseTree, ITShopOrgHasPWODecisionMethod, PersonInITShopOrg, DynamicGroup…
  • DELETE dbo.QER_PITShop_ShopMove · calls QBM_PJobCreate_HOTemplate_B, QER_PITShop_BoardMove, QBM_PSessionErrorAdd; writes INSERT BaseTree, INSERT ITShopOrgHasPWODecisionMethod, INSERT PersonInITShopOrg, INSERT DynamicGroup, INSERT into…; reads/joins Basetree, BaseTree, ITShopOrgHasPWODecisionMethod, PersonInITShopOrg, DynamicGroup…

ESetCollection 1 modules

insert × 1, delete × 1

  • INSERT dbo.RMS_ZESetCollection · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT ESetCollection, DELETE ESetCollection; reads/joins QBMDBQueueCurrent, ESetCollection, ESet, ESetHasEntitlement, BaseTreeHasESet…; uses session context GenProcID
  • DELETE dbo.RMS_ZESetCollection · calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT ESetCollection, DELETE ESetCollection; reads/joins QBMDBQueueCurrent, ESetCollection, ESet, ESetHasEntitlement, BaseTreeHasESet…; uses session context GenProcID

HelperAttestationPolicy 1 modules

insert × 1, delete × 1

  • INSERT dbo.ATT_PHelperAttestationPolicy · calls QBM_PTransactionLevelCheck, ATT_P59CCD84DFA68B81E1B20B65_, QBM_PSessionErrorAdd; writes INSERT into, INSERT HelperAttestationPolicy, DELETE HelperAttestationPolicy; reads/joins AttestationPolicy, HelperAttestationPolicy, QBM_FTHexPattern
  • DELETE dbo.ATT_PHelperAttestationPolicy · calls QBM_PTransactionLevelCheck, ATT_P59CCD84DFA68B81E1B20B65_, QBM_PSessionErrorAdd; writes INSERT into, INSERT HelperAttestationPolicy, DELETE HelperAttestationPolicy; reads/joins AttestationPolicy, HelperAttestationPolicy, QBM_FTHexPattern

machen 1 modules

insert × 1, update × 1

  • INSERT dbo.QBM_PTableRevisionSetMulti_i · writes INSERT into, INSERT machen, INSERT QBMTableRevision, UPDATE machen, UPDATE QBMTableRevision; reads/joins string_split, sys, QBMTableRevision
  • UPDATE dbo.QBM_PTableRevisionSetMulti_i · writes INSERT into, INSERT machen, INSERT QBMTableRevision, UPDATE machen, UPDATE QBMTableRevision; reads/joins string_split, sys, QBMTableRevision

OrgRootAssign 1 modules

insert × 1, delete × 1

  • INSERT dbo.QER_POrgRootAssignFill · calls QBM_PSessionErrorAdd; writes INSERT OrgRootAssign, DELETE OrgRootAssign; reads/joins OrgRoot, BaseTreeAssign, OrgRootAssign
  • DELETE dbo.QER_POrgRootAssignFill · calls QBM_PSessionErrorAdd; writes INSERT OrgRootAssign, DELETE OrgRootAssign; reads/joins OrgRoot, BaseTreeAssign, OrgRootAssign

PersonHasTSBAccountDef 1 modules

update × 1, delete × 1

  • UPDATE dbo.QER_PPersonDelete_GDPR · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod_L, QBM_PJobCreate_HODelete, QBM_PWaitForSeconds, QBM_PDeleteDeep…; writes INSERT into, UPDATE PersonWantsOrg, UPDATE AttestationCase, UPDATE TroubleWorkTimes, UPDATE PersonHasTSBAccountDef…; reads/joins Person, sys, person, AttestationCase, PersonWantsOrg…; uses session context GenProcID
  • DELETE dbo.QER_PPersonDelete_GDPR · calls QBM_PSessionContextSet, QBM_PJobCreate_HOCallMethod_L, QBM_PJobCreate_HODelete, QBM_PWaitForSeconds, QBM_PDeleteDeep…; writes INSERT into, UPDATE PersonWantsOrg, UPDATE AttestationCase, UPDATE TroubleWorkTimes, UPDATE PersonHasTSBAccountDef…; reads/joins Person, sys, person, AttestationCase, PersonWantsOrg…; uses session context GenProcID

PersonInNCHasMControl 1 modules

update × 1, delete × 1

  • UPDATE dbo.CPL_TUPersonInBaseTree · calls QBM_PSessionErrorAdd; writes UPDATE not, UPDATE PersonInNCHasMControl, DELETE PersonInNCHasMControl; reads/joins deleted, inserted, personInBaseTree, BaseTree, QER_VPersonsAreMe…; uses config QER\ComplianceCheck\DisableSelfExceptionGranting
  • DELETE dbo.CPL_TUPersonInBaseTree · calls QBM_PSessionErrorAdd; writes UPDATE not, UPDATE PersonInNCHasMControl, DELETE PersonInNCHasMControl; reads/joins deleted, inserted, personInBaseTree, BaseTree, QER_VPersonsAreMe…; uses config QER\ComplianceCheck\DisableSelfExceptionGranting

PWOHelperBoardMethod 1 modules

insert × 1, delete × 1

  • INSERT dbo.QER_PITShopCheckMethodBO · calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWOHelperBoardMethod, DELETE PWOHelperBoardMethod; reads/joins PWOHelperBoardMethod, pwodecisionmethod, PWODecisionStep, BaseTree, BaseTreeHasPWODecisionMethod…
  • DELETE dbo.QER_PITShopCheckMethodBO · calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWOHelperBoardMethod, DELETE PWOHelperBoardMethod; reads/joins PWOHelperBoardMethod, pwodecisionmethod, PWODecisionStep, BaseTree, BaseTreeHasPWODecisionMethod…

pwoHelperDecisionMaker 1 modules

insert × 1, delete × 1

  • INSERT dbo.QER_ZITShopDecisionMakerFill · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT pwoHelperDecisionMaker, DELETE pwoHelperDecisionMaker; reads/joins BaseTree, pwodecisionmethod, pwodecisionstep, PWODecisionStep, PersonInBaseTree…; uses session context GenProcID
  • DELETE dbo.QER_ZITShopDecisionMakerFill · calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT pwoHelperDecisionMaker, DELETE pwoHelperDecisionMaker; reads/joins BaseTree, pwodecisionmethod, pwodecisionstep, PWODecisionStep, PersonInBaseTree…; uses session context GenProcID

QBMDBQueueAgent 1 modules

insert × 1, update × 1

  • INSERT dbo.QBM_PDBQueueAgentInfoSet · calls QBM_PSessionErrorAdd; writes INSERT QBMDBQueueAgent, UPDATE QBMDBQueueAgent; reads/joins QBMDBQueueAgent
  • UPDATE dbo.QBM_PDBQueueAgentInfoSet · calls QBM_PSessionErrorAdd; writes INSERT QBMDBQueueAgent, UPDATE QBMDBQueueAgent; reads/joins QBMDBQueueAgent

QBMDBRightsAddOn 1 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_ZDBRoleDefFill · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMDBRightsAddOn, DELETE QBMDBRightsAddOn; reads/joins sys, DialogTable, QBMModuleDef, QBMDBRightsAddOn, dialogtable…
  • DELETE dbo.QBM_ZDBRoleDefFill · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMDBRightsAddOn, DELETE QBMDBRightsAddOn; reads/joins sys, DialogTable, QBMModuleDef, QBMDBRightsAddOn, dialogtable…

QBMDiskStorePhysical 1 modules

insert × 1, delete × 1

QBMEventHasFeature 1 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_PQBMEventClean · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMEventHasFeature, UPDATE JobEventGen, UPDATE JobAutoStart, DELETE QBMEventHasFeature…; reads/joins QBMEvent, QBMModuleDef, JobEventGen, JobAutoStart, QBMEventHasFeature
  • DELETE dbo.QBM_PQBMEventClean · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMEventHasFeature, UPDATE JobEventGen, UPDATE JobAutoStart, DELETE QBMEventHasFeature…; reads/joins QBMEvent, QBMModuleDef, JobEventGen, JobAutoStart, QBMEventHasFeature

QBMModuleDependCollection 1 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_PModuleDependCollFill · calls QBM_PTransportHistoryInsert, QBM_PSessionErrorAdd; writes INSERT QBMModuleDef, INSERT QBMModuleDependCollection, UPDATE QBMModuleDef, DELETE QBMModuleDependCollection; reads/joins QBMModuleDef, QBMModuledepend, QBMModuleDependCollection, QBMModuleDepend, hierarchy; uses session context XUser
  • DELETE dbo.QBM_PModuleDependCollFill · calls QBM_PTransportHistoryInsert, QBM_PSessionErrorAdd; writes INSERT QBMModuleDef, INSERT QBMModuleDependCollection, UPDATE QBMModuleDef, DELETE QBMModuleDependCollection; reads/joins QBMModuleDef, QBMModuledepend, QBMModuleDependCollection, QBMModuleDepend, hierarchy; uses session context XUser

QBMServerHasServerTag 1 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_PDatabasePrepare · calls QBM_PDialogDatabaseInitialInfo, QBM_PDatabasePrepareCheck1, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT QBMServerTag, INSERT QBMServerHasServerTag, INSERT QBMServer, UPDATE DialogConfigParm, UPDATE dialogdatabase…; reads/joins dialogdatabase, DialogDatabase, QBMServerTag, QBMModuleDef, QBMServerHasServerTag…; uses config 5, 20
  • DELETE dbo.QBM_PDatabasePrepare · calls QBM_PDialogDatabaseInitialInfo, QBM_PDatabasePrepareCheck1, QBM_PJournal, QBM_PSessionErrorAdd; writes INSERT QBMServerTag, INSERT QBMServerHasServerTag, INSERT QBMServer, UPDATE DialogConfigParm, UPDATE dialogdatabase…; reads/joins dialogdatabase, DialogDatabase, QBMServerTag, QBMModuleDef, QBMServerHasServerTag…; uses config 5, 20

QBMViewAddOn 1 modules

insert × 1, delete × 1

  • INSERT dbo.QBM_PViewBuildP_intern · calls QBM_PViewDrop, QBM_PViewBuild_FromAddOn, QBM_PDialogColumnDelete, QBM_PDialogColumnInsert, QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMViewAddOn, DELETE QBMViewAddOn; reads/joins information_schema, dialogtable, DialogTable, DialogColumn, QBMViewAddOn
  • DELETE dbo.QBM_PViewBuildP_intern · calls QBM_PViewDrop, QBM_PViewBuild_FromAddOn, QBM_PDialogColumnDelete, QBM_PDialogColumnInsert, QBM_PSessionErrorAdd; writes INSERT into, INSERT QBMViewAddOn, DELETE QBMViewAddOn; reads/joins information_schema, dialogtable, DialogTable, DialogColumn, QBMViewAddOn

QEREntitlementSource 1 modules

insert × 1, update × 1

  • INSERT dbo.QER_PQEREntitlementSourceDef · calls QBM_PSessionErrorAdd; writes INSERT QEREntitlementSource, UPDATE QEREntitlementSource; reads/joins DialogTable, QEREntitlementSource
  • UPDATE dbo.QER_PQEREntitlementSourceDef · calls QBM_PSessionErrorAdd; writes INSERT QEREntitlementSource, UPDATE QEREntitlementSource; reads/joins DialogTable, QEREntitlementSource

QERRiskIndex 1 modules

insert × 1, update × 1

  • INSERT dbo.QER_PQERRiskIndexDefine · calls QBM_PSessionErrorAdd; writes INSERT QERRiskIndex, UPDATE QERRiskIndex; reads/joins DialogTable, DialogColumn, QERRiskIndex
  • UPDATE dbo.QER_PQERRiskIndexDefine · calls QBM_PSessionErrorAdd; writes INSERT QERRiskIndex, UPDATE QERRiskIndex; reads/joins DialogTable, DialogColumn, QERRiskIndex

UNSAccountBInUNSGroupB 1 modules

insert × 1, update × 1

  • INSERT dbo.TSB_PMemberOfSplitToGroups · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSAccountBInUNSGroupB, UPDATE UNSAccountBInUNSGroupB; reads/joins UNSAccountB, QBM_FCVStringToList, UNSAccountBInUNSGroupB
  • UPDATE dbo.TSB_PMemberOfSplitToGroups · calls QBM_PSessionErrorAdd; writes INSERT into, INSERT UNSAccountBInUNSGroupB, UPDATE UNSAccountBInUNSGroupB; reads/joins UNSAccountB, QBM_FCVStringToList, UNSAccountBInUNSGroupB

user 1 modules

insert × 1, update × 1

  • INSERT dbo.QBM_PDynamicUserForPerson · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT user, INSERT DialogUser, INSERT useringroup, INSERT DialogUserInGroup…; reads/joins DialogGroup, DialogGroupInProductLimited, AERole, BaseTreeCollectionF, BaseTree…; uses session context XUser, GenProcID
  • UPDATE dbo.QBM_PDynamicUserForPerson · calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT user, INSERT DialogUser, INSERT useringroup, INSERT DialogUserInGroup…; reads/joins DialogGroup, DialogGroupInProductLimited, AERole, BaseTreeCollectionF, BaseTree…; uses session context XUser, GenProcID

ADSContactInADSGroup 1 modules

update × 1

  • UPDATE dbo.ADS_TUAdsGroup · calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk…; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE BaseTreeHasADSGroup, UPDATE ADSAccountInADSGroup…; reads/joins QER_VPWOProductNodesSlim, inserted, deleted, ADSGroup, ADSGroupExclusion…; uses session context Fullsync

ADSGroupExclusion 1 modules

delete × 1

  • DELETE dbo.ADS_TUAdsGroup · calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk…; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE BaseTreeHasADSGroup, UPDATE ADSAccountInADSGroup…; reads/joins QER_VPWOProductNodesSlim, inserted, deleted, ADSGroup, ADSGroupExclusion…; uses session context Fullsync

ADSGroupInADSGroup 1 modules

delete × 1

  • DELETE dbo.ADS_TUAdsGroup · calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk…; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE BaseTreeHasADSGroup, UPDATE ADSAccountInADSGroup…; reads/joins QER_VPWOProductNodesSlim, inserted, deleted, ADSGroup, ADSGroupExclusion…; uses session context Fullsync

ATTBaseObjectHasDecisionRule 1 modules

insert × 1

  • INSERT dbo.ATT_TIDialogTable · calls QBM_PSessionErrorAdd; writes INSERT not, INSERT ATTBaseObjectHasDecisionRule; reads/joins inserted, ATTBaseObjectHasDecisionRule

AttestationCaseHasMControl 1 modules

delete × 1

  • DELETE dbo.ATT_P600B8EB3A312074D1A10A4A_ · calls QBM_PSessionErrorAdd; writes INSERT into, DELETE AttestationCaseHasMControl, DELETE AttestationCase; reads/joins AttestationCase, AttestationCaseHasMControl

All DML targets

TargetModulesINSERT refsUPDATE refsDELETE refsExample modules
into1,1351,13700dbo.ADS_FTDomainTree, dbo.ADS_FTGroupCollection, dbo.ADS_FTGroupMembersValid_G_OC, dbo.ADS_FTGroupMembersValid_M, dbo.ADS_PAfterMigrationJobCreate, dbo.ADS_PAfterMigrationTasks, dbo.ADS_RAccountInADSGroup, dbo.ADS_RADSMachineInADSGroup, dbo.ADS_RBaseTreeHasObject, dbo.ADS_RBaseTreeOwnsObjectPrepair
not624221247156dbo.ADS_TATTUADSAccount, dbo.ADS_TATTUADSContainer, dbo.ADS_TATTUADSGroup, dbo.ADS_TATTUDomain, dbo.ADS_TCPLUADSContainer, dbo.ADS_TCPLUDomain, dbo.ADS_TDADSAccount, dbo.ADS_TDADSContact, dbo.ADS_TDADSContainer, dbo.ADS_TDADSDomain
DialogColumn262226dbo.QBM_PColumnAdd, dbo.QBM_PColumnChangeDataType, dbo.QBM_PColumnCheckBlobExternal, dbo.QBM_PColumnCustomRemove, dbo.QBM_PColumnDrop, dbo.QBM_PColumnRename, dbo.QBM_PColumnSchemaDataTypeCorr, dbo.QBM_PDatabasePrepareCheck1, dbo.QBM_PDatabasePrepareCheck2, dbo.QBM_PDialogColumnDelete
JobQueue193172dbo.ATT_PAttestationCaseCreate, dbo.DPR_TDDPRSystemSyncDependency, dbo.DPR_TIDPRSystemSyncDependency, dbo.DPR_TUDialogColumn, dbo.DPR_TUDialogTable, dbo.DPR_TUDPRSystemSyncDependency, dbo.QBM_PDBQCS_SlotRunner, dbo.QBM_PDialogProcessShrink_3, dbo.QBM_PJobCreate, dbo.QBM_PJobQueueDelete
dialogdatabase161160dbo.QBM_PDatabasePrepare, dbo.QBM_PDBQueueActivityDisable, dbo.QBM_PDBQueueActivityEnable, dbo.QBM_PDBQueueExternalTaskFire, dbo.QBM_PDBQueueInsert_Int, dbo.QBM_PDialogDatabaseInitialInfo, dbo.QBM_PFESimulationEnd, dbo.QBM_PFESimulationStart, dbo.QBM_PSingleUserAlive, dbo.QBM_PSingleUserBreak
DialogTable12284dbo.QBM_PColumnAdd, dbo.QBM_PColumnCustomRemove, dbo.QBM_PDatabasePrepareCheck1, dbo.QBM_PDialogTablePKNameCorrect, dbo.QBM_PModuleRemove, dbo.QBM_PQBMRelationCheck, dbo.QBM_PTableAdd, dbo.QBM_PTableCustomRemove_RU, dbo.QBM_PTableDrop, dbo.QBM_PTableStatistics
pwohelperpwo10157dbo.CPL_ZITShopMakeDecisionOC, dbo.CPL_ZITShopMakeDecisionOH, dbo.QER_PITShopHelperFill_bulk, dbo.QER_PITShopOrderMove_bulk, dbo.QER_PITShopOrderResetOneLevel, dbo.QER_RITShopCheckDecision, dbo.QER_RITShopHelperFill, dbo.QER_TUPersonWantsOrg, dbo.QER_ZITShopCheckDecision, dbo.QER_ZITShopOrderReset
ADSOtherSID9606dbo.ADS_TDADSAccount, dbo.ADS_TDAdsGroup, dbo.ADS_TDADSMachine, dbo.ADS_TIADSAccount, dbo.ADS_TIAdsGroup, dbo.ADS_TIADSMachine, dbo.ADS_TUADSAccount, dbo.ADS_TUAdsGroup, dbo.ADS_TUADSMachine
QBMRelation9282dbo.QBM_PCheckSameCase_38, dbo.QBM_PColumnCustomRemove, dbo.QBM_PQBMRelationCheck, dbo.QBM_PQBMRelationExpand_One, dbo.QBM_PQBMRelationUserChangeCorr, dbo.QBM_PRelationshipDefineManual, dbo.QBM_PTableDrop, dbo.QBM_TUAssembly_QBMRelation, dbo.QBM_ZRITriggerPrepare
DialogProcess10470dbo.QBM_PDialogProcessShrink_3, dbo.QBM_PDialogProcessShrink_fill, dbo.QBM_PJobUpdateState_Bulk, dbo.QBM_PProcessCreate, dbo.QBM_PProcessGroupCreate, dbo.QBM_PProcessGroupCreate_help, dbo.QBM_PProcessGroupDelete, dbo.QBM_ZProcessMarkDelete, dbo.QBM_ZProcessStateUpdate, dbo.QER_TIPersonWantsOrg
PersonWantsOrg9191dbo.QER_PITShopHelperFill_bulk, dbo.QER_PITShopOrderMove_bulk, dbo.QER_PPersonDelete_GDPR, dbo.QER_TDDialogProcess, dbo.QER_TIPersonWantsOrg, dbo.QER_TUPersonWantsOrg, dbo.QER_ZITShopDeleteClosed, dbo.QER_ZITShopOrderReset, dbo.QER_ZITShopRepairClosed
AttestationHelper6154dbo.ATT_PAttestationHelperFill, dbo.ATT_PAttestationResetOneLevel, dbo.ATT_TUAttestationCase, dbo.ATT_ZAttestationMakeDecisionEX, dbo.ATT_ZAttestationReminder, dbo.ATT_ZAttestationReset
PersonInBaseTree5154dbo.CPL_TDComplianceRule, dbo.CPL_TUComplianceRule, dbo.QER_PITShop_ShopMove, dbo.QER_PITShopBoardPrepareDelete, dbo.QER_PITShopOrderMove_bulk
BaseTree6324dbo.CPL_TDComplianceRule, dbo.QER_PITShop_BoardMove, dbo.QER_PITShop_ShopMove, dbo.QER_PITShopProductNodeCreate_b, dbo.QER_ZITShopCheckMethodPR, dbo.QER_ZOrgTreeLevel
QBMCustomSQL5162dbo.QBM_PCustomSQLCompile, dbo.QBM_PCustomSQLDependencyFill, dbo.QBM_PCustomSQLFill, dbo.QBM_PCustomSQLPropagate, dbo.QBM_PCustomSQLSort
AttestationCase8152dbo.ATT_P47650F5671BCBA8B679125E_, dbo.ATT_P600B8EB3A312074D1A10A4A_, dbo.ATT_PAfterMigrationTasks, dbo.ATT_PAttestationCaseCreate_i, dbo.ATT_PAttestationHelperFill, dbo.ATT_TUPerson, dbo.ATT_ZAttestationReset, dbo.QER_PPersonDelete_GDPR
DialogDBQueue7242dbo.QBM_PDBQCS_SlotFill, dbo.QBM_PDBQCS_SlotFill_Range, dbo.QBM_PDBQueueCompress, dbo.QBM_PDBQueueExternalTaskFire, dbo.QBM_PDBQueueInsert_Int, dbo.QBM_PDialogDBQueueDelete, dbo.QBM_PDialogProcessShrink_3
QBMDBQueueCurrent7341dbo.QBM_PDBQCS_CurrentMoveSlot, dbo.QBM_PDBQCS_CurrentRestore, dbo.QBM_PDBQCS_SlotFill, dbo.QBM_PDBQCS_SlotFill_Range, dbo.QBM_PDBQueueReplGenProcID, dbo.QBM_PDialogProcessShrink_3, dbo.QBM_PQBMDBQueueCurrentDelete
QBMBufferConfig4233dbo.QBM_FSQBufferConfigSaveOrigin, dbo.QBM_PBufferC_ProcessOneColumn, dbo.QBM_PBufferT_ProcessUpdate, dbo.QBM_PDatabasePrepareCheck2
dialogSemaphor6060dbo.QBM_TDDialogScriptAssembly, dbo.QBM_TIDialogScriptAssembly, dbo.QBM_TUDialogScriptAssembly, dbo.QBM_ZDialogSemaphorIncAll, dbo.QBM_ZDialogSemaphorIncGlobal, dbo.QBM_ZSoftwareRevision
JobHistory6231dbo.QBM_PDialogProcessShrink_3, dbo.QBM_PF84975544A6AEABC94405E1_a, dbo.QBM_PJobQueueDelete, dbo.QBM_PJobQueueDelete_Bulk, dbo.QBM_PProcessGroupDelete, dbo.QBM_PWorkHistoryDelete
DialogUser4231dbo.QBM_PDynamicUserForPerson, dbo.QBM_PUserDetectByGroupList, dbo.QBM_TIDialogUser, dbo.QBM_ZDynamicUserShrink
Delegation5005dbo.QER_TDPerson, dbo.QER_TUHelperHeadOrg, dbo.QER_TUHelperHeadPerson, dbo.QER_TUPersonInBaseTree, dbo.QER_ZITShopRepairClosed
DialogConfigParm5050dbo.QBM_PDatabasePrepare, dbo.QBM_PDatabasePrepareCheck2, dbo.QBM_TUDialogDatabase, dbo.QBM_ZConfigParmCheck, dbo.QBM_ZGetServerProperties
QBMElementAffectedByJob5302dbo.ATT_PAttestationCaseCreate, dbo.QBM_PDBQCS_SlotRunner, dbo.QBM_PJobCreate, dbo.QBM_PWorkJobQueueDelete, dbo.QBM_TDJobqueue
DialogUserInGroup4302dbo.QBM_PDialogUserInGroupCorrect, dbo.QBM_PDynamicUserForPerson, dbo.QBM_PUserDetectByGroupList, dbo.QBM_TUDialogUser
QBMJobqueueOverview4032dbo.QBM_PJobQueueInit_i, dbo.QBM_PJobqueueoverViewFill, dbo.QBM_PJobQueueOverviewSetInv, dbo.QBM_TDQBMServer
QBMServer4230dbo.QBM_PDatabasePrepare, dbo.QBM_PJobQueueInit_i, dbo.QBM_PJobQueueLoad, dbo.QBM_PQBMServerHasJobService
BaseTreeCollection3302dbo.QER_POrgSubTree, dbo.QER_TIBaseTree, dbo.QER_ZOrgRoot
BaseTreeHasObject3311dbo.QER_PBasetreeHasObjectPostProc, dbo.QER_PITShopProductNodeCreate_b, dbo.QER_PITShopProductNodeMove
object3221dbo.QBM_FSQFKCheckDynamic, dbo.QBM_FSQFKCheckFix, dbo.QBM_PTableDrop
QBMSplittedLookup3113dbo.QBM_FSQTriggerSplittedLookup, dbo.QBM_PSplittedElementProcess, dbo.QBM_TUDialogColumn
Accounts4004dbo.ADS_TDADSAccount, dbo.ADS_TDADSContact, dbo.LDP_TDLDAPAccount, dbo.TSB_TDUNSAccountB
DialogColumnGroupRight4004dbo.QBM_PColumnCustomRemove, dbo.QBM_PColumnDrop, dbo.QBM_PTableCustomRemove_RU, dbo.QBM_PTableDrop
dialogGroup4040dbo.QBM_TUDialogGroup, dbo.QBM_ZGroupNumber, dbo.QBM_ZGroupPattern, dbo.QBM_ZPrePropGroup
DialogProcessChain4040dbo.QBM_P0443A4E1724A1CB3D52A2C2_a, dbo.QBM_PDialogProcessShrink_3, dbo.QBM_PProcessGroupDelete, dbo.QBM_ZProcessChainStateUpdate
DialogProcessSubstitute4130dbo.QBM_PDBQueueReplGenProcID, dbo.QBM_PDialogProcessShrink_3, dbo.QBM_PProcessGroupDelete, dbo.QBM_PProcessShrink
DialogSchedule4040dbo.QBM_PScheduleCheck, dbo.QBM_TIDialogSchedule, dbo.QBM_TUDialogSchedule, dbo.QBM_TUJobAutoStart
DialogWatchOperation4130dbo.QBM_FSQTriggerWatchTable, dbo.QBM_PA164BD06A63979BC96DA633_a, dbo.QBM_PDialogProcessShrink_3, dbo.QBM_PProcessGroupDelete
ist4400dbo.TSB_TIUNSGroupB, dbo.TSB_TIUNSGroupB1, dbo.TSB_TIUNSGroupB2, dbo.TSB_TIUNSGroupB3
JobQueueStats4400dbo.QBM_PJobQueueDelete, dbo.QBM_PJobQueueLoad, dbo.QBM_PJobQueueStatsShrink, dbo.QBM_TIJobqueue
PWODecisionHistory4400dbo.QER_PITShopHelperFill_bulk, dbo.QER_PITShopOrderHistoryInsert, dbo.QER_PITShopOrderMove_bulk, dbo.QER_ZITShopOrderReset
QERBufferRecalcDecisionMaker4121dbo.ATT_ZAttHelperFill_Recalc, dbo.QER_P98F5E10C6A9349A1EBFB2C2_, dbo.QER_PITShopHelperFill_Recalc, dbo.QER_ZITShopHelperFill_Recalc
DPRMemberShipAction3103dbo.DPR_FSQTriggerRIMemberShip, dbo.DPR_FSQTriggerWatchMemberShip, dbo.DPR_PMemberShipActionCleanUp
QBMDBQueuePond3310dbo.QBM_PDBQueueInsert_Bulk, dbo.QBM_PDBQueuePondEnd, dbo.QBM_PTempQueueEnd
ADSGroupCollection2121dbo.ADS_ZGroupInADSGroup, dbo.ADS_ZGroupInADSGroup_Circ
HelperPWOPersonHasObject2112dbo.QER_PITShopPersonHasObjFill_b, dbo.QER_ZITShopOrderReset
LDAPGroupCollection2121dbo.LDP_ZGroupInLDAPGroup, dbo.LDP_ZGroupInLDAPGroup_Circ
QBMTableRevision2121dbo.QBM_PTableRevisionFill, dbo.QBM_PTableRevisionSetMulti_i
UNSGroupB1Collection2121dbo.TSB_ZUNSGroupB1InUNSGroupB1, dbo.TSB_ZUNSGroupB1InUNSGroupB1_C
UNSGroupB2Collection2121dbo.TSB_ZUNSGroupB2InUNSGroupB2, dbo.TSB_ZUNSGroupB2InUNSGroupB2_C
UNSGroupB3Collection2121dbo.TSB_ZUNSGroupB3InUNSGroupB3, dbo.TSB_ZUNSGroupB3InUNSGroupB3_C
UNSGroupBCollection2121dbo.TSB_ZUNSGroupBInUNSGroupB, dbo.TSB_ZUNSGroupBInUNSGroupB_C
AttestationHistory3300dbo.ATT_PAttestationHelperFill, dbo.ATT_TUPerson, dbo.ATT_ZAttestationReset
DialogMultiLanguage3201dbo.QBM_PMultilanguageDoubleClear, dbo.QBM_PMultilanguageFill, dbo.QBM_PMultilanguageFillSQL
EsetHasEntitlement3030dbo.ADS_TUAdsGroup, dbo.LDP_TULDAPGroup, dbo.RMS_TUESetHasEntitlement
for3111dbo.QBM_PJobCreate_HODelete, dbo.QBM_PJobCreate_HOInsert, dbo.QBM_PJobCreate_HOUpdate
BaseTreeCollectionF2201dbo.QER_TIBaseTree, dbo.QER_ZBaseTreeCollectionF
HelperPWOCompliance2102dbo.CPL_ZITShopMakeDecisionCR, dbo.QER_ZITShopOrderReset
jobtreeparamcoll2111dbo.QBM_PJobSetRunParameter, dbo.QBM_TDJobqueue
QBMModuleDef2111dbo.QBM_PModuleDependCollFill, dbo.QBM_PModuleRemove
QERWorkingMethod2111dbo.QER_PGIQERWorkingMethod, dbo.QER_ZQERWorkingMethodCleanUp
AccProductGroupCollection1111dbo.QER_ZAccProductGroupCollection
BaseTreeOwnsObject1111dbo.QER_PBasetreeOwnsObjectPost_L
PersonHasObject1111dbo.QER_PPersonHasObjectPostProc
QBMMissingDisplayRight1111dbo.QBM_PMissingDisplayRightFill
ADSAccountInADSGroup2020dbo.ADS_TUADSAccount, dbo.ADS_TUAdsGroup
ADSMachineInADSGroup2020dbo.ADS_TUAdsGroup, dbo.ADS_TUADSMachine
AttestationRun2011dbo.ATT_PAttestationCaseCreate, dbo.ATT_ZAttestationRunDeleteOld
DialogDeferredOperation2020dbo.QBM_PDialogProcessShrink_3, dbo.QBM_ZDeferredOperationExecute
DialogJournal2200dbo.QBM_PWriteDialogJournal, dbo.QBM_ZConnectionClearUnused
DialogScriptAssembly2020dbo.QBM_PBufferT_ProcessTable, dbo.QBM_ZScriptAssemblyReset
DialogState2020dbo.QBM_ZStateUTCOffset, dbo.QBM_ZStateUTCOffset2
DialogValidDynamicRef2002dbo.QBM_PColumnCustomRemove, dbo.QBM_PTableDrop
DialogWatchProperty2101dbo.QBM_FSQTriggerWatchTable, dbo.QBM_TDDialogWatchOperation
in2011dbo.QBM_PJobCreate_SQLDel, dbo.QBM_TUDialogDatabase
ITShopOrgHasPWODecisionMethod2200dbo.QER_PITShop_BoardMove, dbo.QER_PITShop_ShopMove
node2110dbo.QER_TIBaseTree, dbo.QER_TUBaseTree
person2011dbo.QER_TDPerson, dbo.QER_TIPerson
QBMBufferTransfer2002dbo.QBM_PBufferT_DeleteNonlinear, dbo.QBM_PBufferT_ProcessAll_Delta
QBMGuidReplace2101dbo.QBM_PGUIDReplaceInsertPair, dbo.QBM_ZGUIDReplaceReady
QBMTranslationAddOnSource2101dbo.QBM_PMultilanguageFillSQL, dbo.QBM_PQBMTranslationAddOnClean
QERDynamicGroupBlackList2020dbo.QER_PDynamicGroupMakeProc_hlp, dbo.QER_ZAllForPersonInBaseTree
QERPolicyHasObject2011dbo.POL_ZQERPolicyFill, dbo.QER_PPersonDelete_GDPR
RPSSubscription2020dbo.RPS_TIPersonHasRPSReport, dbo.RPS_TUPersonHasRPSReport
running2020dbo.QBM_FGIMaintenanceRunning, dbo.QBM_FGIMaintenanceRunning_M
SET2002dbo.QBM_FSQFKCheckDynamic, dbo.QBM_FSQFKCheckFix
top2011dbo.QBM_PQBMDBQueuePondDelete, dbo.QBM_ZProgressViewShrinkReset
trigger2110dbo.QBM_TIDialogTable, dbo.QER_TUHelperHeadOrg
ComplianceSubRuleObject1101dbo.CPL_ZSubRuleFillObject
ComplianceSubRulePerson1101dbo.CPL_PSubRuleFillPerson_i
DialogCalendar1110dbo.QBM_ZCalendarFill
DialogDashBoardContent1110dbo.QBM_ZDashBoardContentCalculate
DialogGroupCollection1101dbo.QBM_ZGroupCollection
DialogTableHasCustomizer1101dbo.QBM_PGUIDReplaceCustomizerFill
DynamicGroup1101dbo.QER_PITShop_ShopMove
ESetCollection1101dbo.RMS_ZESetCollection
HelperAttestationPolicy1101dbo.ATT_PHelperAttestationPolicy
machen1110dbo.QBM_PTableRevisionSetMulti_i
OrgRootAssign1101dbo.QER_POrgRootAssignFill
PersonHasTSBAccountDef1011dbo.QER_PPersonDelete_GDPR
PersonInNCHasMControl1011dbo.CPL_TUPersonInBaseTree
PWOHelperBoardMethod1101dbo.QER_PITShopCheckMethodBO
pwoHelperDecisionMaker1101dbo.QER_ZITShopDecisionMakerFill
QBMDBQueueAgent1110dbo.QBM_PDBQueueAgentInfoSet
QBMDBRightsAddOn1101dbo.QBM_ZDBRoleDefFill
QBMDiskStorePhysical1101dbo.QBM_PDiskStorePhysicalSync
QBMEventHasFeature1101dbo.QBM_PQBMEventClean
QBMModuleDependCollection1101dbo.QBM_PModuleDependCollFill
QBMServerHasServerTag1101dbo.QBM_PDatabasePrepare
QBMViewAddOn1101dbo.QBM_PViewBuildP_intern
QEREntitlementSource1110dbo.QER_PQEREntitlementSourceDef
QERRiskIndex1110dbo.QER_PQERRiskIndexDefine
UNSAccountBInUNSGroupB1110dbo.TSB_PMemberOfSplitToGroups
user1110dbo.QBM_PDynamicUserForPerson
ADSContactInADSGroup1010dbo.ADS_TUAdsGroup
ADSGroupExclusion1001dbo.ADS_TUAdsGroup
ADSGroupInADSGroup1001dbo.ADS_TUAdsGroup
ATTBaseObjectHasDecisionRule1100dbo.ATT_TIDialogTable
AttestationCaseHasMControl1001dbo.ATT_P600B8EB3A312074D1A10A4A_
AttestationObject1010dbo.ATT_ZAttestationObjectPreProp
AttestationWizardParm1010dbo.ATT_ZAttestationWzParmPreProp
BaseTreeHasADSGroup1010dbo.ADS_TUAdsGroup
BaseTreeHasLDAPGroup1010dbo.LDP_TULDAPGroup
cascade1001dbo.QBM_FSQFKCheckFix
code1001dbo.QBM_PModuleRemove
DialogAuthentifier1010dbo.QBM_ZAuthentifierInitial
dialogCountry1010dbo.QBM_ZCountryUTCOffset
DialogCustomizer1010dbo.QBM_ZPrePropCustomizer
DialogDashBoardDef1010dbo.QBM_ZPrePropDashBoardDef
DialogObject1010dbo.QBM_ZPrePropObject
DialogProcessStep1001dbo.QBM_TDDialogProcessChain
DialogReport1010dbo.QBM_ZPrePropReport
DialogSheet1010dbo.QBM_ZPrePropSheet
does1001dbo.QBM_PModuleRemove
DPRAttachedDataStore1001dbo.DPR_PAttachedDataStoreCleanUp
DPRProjectionStepQuota1001dbo.DPR_TDDPRProjectionConfigStep
DPRSchemaPropertyReference1001dbo.DPR_TDDPRSchemaProperty
DPRSystemObjectMatchSet1001dbo.DPR_TDDPRSystemObjectMatchSets
DPRSystemObjectMatchSets1001dbo.DPR_TDDPRProjectionConfigStep
error1001dbo.QBM_PTriggerWatchCreate
fertig1010dbo.ADS_ZAccountInADSGroup
Hardware1010dbo.QER_PDefaultHardwaretypeAssign
HelperHeadPerson1100dbo.QER_TIPerson
is1010dbo.QBM_PJobUpdateState_Bulk
ITShopOrg1010dbo.QER_PITShopProductNodeCreate_b
Job1010dbo.QBM_ZPrePropJob
JobAutoStart1010dbo.QBM_PQBMEventClean
JobChain1010dbo.QBM_ZPrePropJobChain
JobEventGen1010dbo.QBM_PQBMEventClean
JobPerformance1001dbo.QBM_ZJobPerformanceFill
JobRunParameter1010dbo.QBM_TUJobParameter
LDAPAccountInLDAPGroup1010dbo.LDP_TULDAPGroup
LDAPGroupExclusion1001dbo.LDP_TULDAPGroup
LDPMachineInLDAPGroup1010dbo.LDP_TULDAPGroup
list1001dbo.QBM_PModuleRemove
MDKMLGuidReplace1100dbo.QBM_PMultilanguageDoubleClear
module1001dbo.QBM_PModuleRemove
nix1001dbo.DPR_FSQTriggerWatchMemberShip
no1001dbo.QBM_FSQFKCheckFix
Operation1100dbo.QBM_TIDialogDBQueue
PersonInITShopOrg1100dbo.QER_PITShop_ShopMove
PWODecisionSubMethod1010dbo.QER_PAfterMigrationTasks
QBMCEFMessage1100dbo.QBM_FSQTriggerPartCEF
QBMDBQueueTask1001dbo.QBM_PDatabasePrepareCheck2
QBMDBQueueTaskDepend1001dbo.QBM_PDatabasePrepareCheck2
QBMEvent1001dbo.QBM_PQBMEventClean
QBMForeignKeyWrongReport1100dbo.QBM_PForeignKeyWrongReport
QBMLock1001dbo.QER_PPersonDelete_GDPR
QBMNonLinearDepend1001dbo.QBM_PModuleRemove
QBMPendingChange1001dbo.QBM_ZQBMPendingChangeShrink
QBMServerTag1100dbo.QBM_PDatabasePrepare
QBMSessionStore1001dbo.QBM_ZQBMSessionStoreShrink
QBMTransportHistory1100dbo.QBM_PTransportHistoryInsert
QBMTree1010dbo.QBM_ZPrePropTree
QBMTreeResult1010dbo.QBM_ZPrePropTreeResult
QERPickedItem1001dbo.QER_PPickedItemInsertRandom
QERWorkingStep1100dbo.QER_PGIQERWorkingMethod
RESTRICT1001dbo.QBM_FSQFKCheckDynamic
RPSReport1010dbo.RPS_ZPrePropRPSReport
ShoppingCartOrder1001dbo.QER_ZITShopDeleteClosed
statement1001dbo.QBM_PDeleteDeep_L
Table1001dbo.QBM_PTableDrop
them1001dbo.QBM_PModuleRemove
TMPExcessQuantity1010dbo.QBM_PIndexCreate
TroubleWorkTimes1010dbo.QER_PPersonDelete_GDPR
TSBAccountDef1010dbo.TSB_ZTSBAccountDefFlags
useringroup1100dbo.QBM_PDynamicUserForPerson
when1001dbo.QBM_PTableRevisionFill
whereclause1010dbo.DPR_TUDPRNameSpaceHasDialogTab