dbo.TSB_ZOrgHasUNSGroupB1
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:21.670 · modified 2026-04-14T23:20:47.693 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@SlotNumber | int | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| BaseTree | OBJECT_OR_COLUMN | ||
| BaseTreeCollection | OBJECT_OR_COLUMN | ||
| BaseTreeHasEset | OBJECT_OR_COLUMN | ||
| BaseTreeHasUNSGroupB1 | OBJECT_OR_COLUMN | ||
| ESetHasEntitlement | OBJECT_OR_COLUMN | ||
| OrgRootAssign | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueCalculateDelta | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueInsert_Bulk | OBJECT_OR_COLUMN | ||
| QBM_PMNTableInsert | OBJECT_OR_COLUMN | ||
| QBM_PMNTableOriginUpdate | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YDataForDelta | TYPE | ||
| QBM_YDBQueueCurrent | TYPE | ||
| QBM_YDBQueueRaw | TYPE | ||
| QBMDBQueueCurrent | OBJECT_OR_COLUMN | ||
| QER_PMNTableAddViewProperties | OBJECT_OR_COLUMN | ||
| QER_YExcludeCandidate | TYPE | ||
| UNSGroupB1 | OBJECT_OR_COLUMN | ||
| UNSGroupB1Exclusion | OBJECT_OR_COLUMN | ||
| dbo | QBM_FGIBitPatternXOrigin | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIConfigparmValue | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIModuleExists | OBJECT_OR_COLUMN |
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:47.693
inserts DBQueue tasks has TRY/CATCH error handling
Summary: calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueCalculateDelta, QBM_PMNTableOriginUpdate, QER_PMNTableAddViewProperties, QBM_PMNTableInsert…; writes INSERT into; reads/joins QBMDBQueueCurrent, BaseTreeHasUNSGroupB1, BaseTreeCollection, UNSGroupB1, BaseTreeHasEset…; uses config QER\Structures\Inherite\NoESetSplitting, QER\Structures\Inherite\GroupExclusion
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@SlotNumber | int | input |
DML targets
INSERT intoCalled routines
Read/join references
SQL dependency metadata
- BaseTree
- BaseTreeCollection
- BaseTreeHasEset
- BaseTreeHasUNSGroupB1
- ESetHasEntitlement
- OrgRootAssign
- QBM_PDBQueueCalculateDelta
- QBM_PDBQueueInsert_Bulk
- QBM_PMNTableInsert
- QBM_PMNTableOriginUpdate
- QBM_PSessionErrorAdd
- QBM_YDataForDelta
- QBM_YDBQueueCurrent
- QBM_YDBQueueRaw
- QBMDBQueueCurrent
- QER_PMNTableAddViewProperties
- QER_YExcludeCandidate
- UNSGroupB1
- UNSGroupB1Exclusion
- dbo.QBM_FGIBitPatternXOrigin
- dbo.QBM_FGIConfigparmValue
- dbo.QBM_FGIModuleExists
Config/session
Config: QER\Structures\Inherite\NoESetSplitting QER\Structures\Inherite\GroupExclusion
Session: None extracted.
DBQueue/tasks
TSB-K-BaseTreeHasObjectTemp tables / referenced variables
Temp: None extracted.
Variables: @SlotNumber @Sourcedata @CountDeltaQantity @CountDeltaOrigin @GenProcID @UID_BasetreeAssignToUse @DBQueueCurrent @QBM_BitPatternXOrigin_Inherit @QBM_BitPatternXOrigin_Inherit_inv @rowcount @SourceData @DBQueueElements_01 @ExcludeCandidate @ROWCOUNT @DeltaQuantity @DeltaDelete @DeltaInsert @DeltaOrigin @UseIsInEffect @DBQueueCurrentExtern @TargetIsView @FKTableNameElement @FKColumnNameElement
Referenced by / reverse dependencies
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
No reverse dependencies extracted.