OIM Wiki Object Documentation Sweep - DBQueue Table Metadata Batch

Scope

This heartbeat run started the table-aware documentation work requested for the automation. The batch focused on DBQueue working tables that were already next candidates from the prior procedure runs:

DialogDBQueue
QBMDBQueueCurrent
QBMDBQueueTaskMetric
QBMDBQueuePond

Evidence Used

Live read-only sandbox query through scripts/sandbox/Invoke-SandboxSql.ps1 -Database OIM -Json
DialogTable rows for display names, usage type, primary key names, row counts, table type, and custom remarks
DialogColumn rows for captions, commentary, data type, PK/UID/FK flags, and column descriptions
sys.triggers for trigger presence
sys.indexes, sys.index_columns, and sys.columns for index coverage
Existing generated source pages and source-index evidence for procedure/table relations

No DML was executed.

Verified Tables Documented

`DialogDBQueue`

DialogTable:
DisplayName: DBQueue
UsageType: WORK
PKName1: UID_DialogDBQueue
CountRows: 0 at query time
DialogColumn descriptions:
UID_DialogDBQueue: DBQueue entry identifier; PK and UID
UID_Task: DBQueue Processor task; UID and foreign key
Object: Object from DBQueue
SubObject: child object / sort criterion for objects to be processed
PathLength: calculated weighting used to determine jobs to process
Generation: reset count
XTouched: processing status
Trigger metadata:
enabled trigger QBM_TIDialogDBQueue
Index metadata:
PK on UID_DialogDBQueue
QBM_XC5DialogDBQueue, QBM_XC7DialogDBQueue, and QBM_XC8DialogDBQueue
Verified relations:
QBM_PDBQueueInsert_Int inserts into DialogDBQueue
QBM_FTDBQCSOverviewLoad reads DialogDBQueue
QBM_PDBQueueInsert_WaitForComp reaches it through the insert wrapper chain

`QBMDBQueueCurrent`

DialogTable:
DisplayName: DBQueue (current)
UsageType: WORK
PKName1: UID_DialogDBQueue
CountRows: 0 at query time
DialogColumn descriptions:
UID_Task: DBQueue Processor task
UID_Parameter: first task parameter
UID_SubParameter: second task parameter
SlotNumber: executing slot number
StartedAt: start time of task processing
Generation: reset count
GenProcID: process ID
Index metadata:
PK on UID_DialogDBQueue
QBM_XC1QBMDBQueueCurrent, QBM_XC2QBMDBQueueCurrent, and QBM_XC3QBMDBQueueCurrent
Verified relations:
QBM_PDBQCS_CurrentRestore reads/restores current entries
QBM_PDBQCS_SlotRunner reads current slot entries

`QBMDBQueueTaskMetric`

DialogTable:
DisplayName: Database Agent Service snapshot
CustomRemarks: Snapshot of the task processing of the Database Agent Service.
UsageType: WORK
PKName1: UID_Task
CountRows: 337 at query time
DialogColumn descriptions:
ProcedureName: procedure that executes the task
CountInDBQueue: number of entries in DialogDBQueue per request
CountProcessing: number in execution status PROCESSING
CurrentBulk: current number of jobs processed in one slot
IsBulkEnabled: whether the procedure is suitable for bulk processing
MaxInstanceEffective: maximum slots that can be filled with this job in parallel
PathLength: calculated processing weighting
SlotInformation: assigned slot details
UID_TaskAutomatedFollower, UID_TaskAutomatedPredecessor, UID_TaskParent: task relationship columns
Index metadata:
clustered PK on UID_Task
Verified relations:
QBM_PDBQueueInsert_Bulk validates tasks against this table
QBM_PDBQueueInsert_Int reads task metadata from it
QBM_FTDBQCSOverviewLoad reads MaxInstanceEffective

`QBMDBQueuePond`

DialogTable:
DisplayName: DBQueue (buffer)
CustomRemarks: Buffer the DBQueue Processor tasks of synchronizations before takeover in DBQueue.
UsageType: WORK
CountRows: 0 at query time
DialogColumn descriptions:
UID_Task: DBQueue Processor task
Object: first parameter
SubObject: second parameter
GenProcID: process ID
PondGroup: group
InsertDate: creation date
Index metadata:
QBM_XCQBMDBQueuePond on InsertDate, UID_Task, PondGroup
Verified relations:
QBM_PDBQueueInsert_Bulk writes here when session context QBMDBQueuePond is set
the same source path sets INSERTEDINTODBQUEUE=1

Wiki Usability Changes

Added the four DBQueue working tables to generated table profiles.
Added a verified DialogTable/DialogColumn metadata section to each of those table pages.
Added column-description tables, index lists, trigger lists, and verified table relation bullets.
Table cards now mark pages that include Dialog metadata.
Table count increased from 18 to 22.

Gaps / Next Batch Candidates

Add a full table coverage dashboard for all DialogTable rows, not just the current curated table list.
Continue with DialogDatabase, QBMDBQueueTask, JobQueue, and QBMDBQueueSlot/slot-related tables if present.
Add automated evidence export for table metadata so future runs do not require manual transcription into generator notes.