Source: projects/identity-management/oim-kb-update/sandbox-db/2026-04-27-itshopinfo-sc-shopping-center-db-evidence.md

> Source: projects/identity-management/oim-kb-update/sandbox-db/2026-04-27-itshopinfo-sc-shopping-center-db-evidence.md

Sandbox DB Evidence — ITShopInfo SC (Shopping Center) + categories (2026-04-27)

Method

• Sandbox DB: OneIM on im.sandbox.local
• Tooling: scripts/sandbox/Invoke-SandboxSql.ps1 (SELECT-only)

Evidence

1) Live IT Shop subtree contains no ITShopInfo = 'SC' nodes

Query (counts by ITShopInfo)

SELECT ITShopInfo, COUNT(*) AS Cnt
FROM dbo.BaseTree
WHERE UID_OrgRoot = 'QER-V-ITShopOrg'
GROUP BY ITShopInfo
ORDER BY Cnt DESC;

Result (sandbox snapshot 2026-04-27)

There are no rows with ITShopInfo = 'SC' in the live QER-V-ITShopOrg subtree.

2) Shipped procedures treat ITShopInfo = 'SC' as “shopping center”

Even though this sandbox does not currently contain SC nodes, the shipped QER procedures/triggers include SC:

• dbo.QER_PITShop_ShopMove: validates the target node is a “shopping center” by requiring ITShopInfo = 'SC' and raises #LDS#The given target node is not a shopping center. if it is not.
• dbo.QER_ZITShopCheckStructure: enqueues QER-K-ShoppingRackMethod work for the “SC → SH → BO” pattern (o.ITShopInfo='SC', its child s.ITShopInfo='SH', its grandchild b.ITShopInfo='BO').
• dbo.QER_ZITShopDecisionMakerFill: uses SC nodes when deriving decision-makers (joins via UID_OrgProfitCenter / UID_OrgDepartment).

These snippets were captured from sys.sql_modules (live DB) in the same sandbox.

3) Product nodes can exist without service categories (AccProductGroup)

In this sandbox, service categories are not required for an ITShopInfo='PR' product-node to exist.

Query (count PR nodes without category)

SELECT
  SUM(CASE WHEN p.UID_AccProductGroup IS NULL THEN 1 ELSE 0 END) AS ProductNodesWithoutCategory,
  COUNT(*) AS TotalProductNodes
FROM dbo.BaseTree pr
LEFT JOIN dbo.AccProduct p ON p.UID_AccProduct = pr.UID_AccProduct
WHERE pr.UID_OrgRoot = 'QER-V-ITShopOrg'
  AND pr.ITShopInfo = 'PR';

Result