dbo.PWODecisionRuleRulerDetect
Queries for approver selection
TableType TUsage USERDATARows 161SizeMB 1.048
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PWODecisionRuleRulerDetect | varchar(38) | no | Query for approver selection | PKUID |
UID_PWODecisionRule | varchar(38) | no | Approval procedure | FKUID |
SQLQuery | nvarchar(-1) | yes | Query | |
SQLQueryObjectsToRecalc | nvarchar(-1) | yes | Recalculation query | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XObjectKey | varchar(138) | no | Object key | |
XTouched | nchar(2) | yes | Processing status | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Ident_RulerDetect | nvarchar(128) | yes | Approver selection |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL4363 | PWODecisionRuleRulerDetect.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
Triggers
ATT_TDPWODecisionRuleRulerDete SQL_TRIGGER
ATT_TIPWODecisionRuleRulerDete SQL_TRIGGER
ATT_TUPWODecisionRuleRulerDete SQL_TRIGGER
GEN_T28E8D0DD9140592832A345A8D SQL_TRIGGER
GEN_T35B531B88B6F30138DEE29381 SQL_TRIGGER
QER_TDPWODecisionRuleRulerDete SQL_TRIGGER
QER_TIPWODecisionRuleRulerDete SQL_TRIGGER
QER_TUPWODecisionRuleRulerDete SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.ATT_ZAttHelperFillMakeProc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPWODecisionRuleMakeProc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPWOHelperFillMakeProc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPWODecisionRuleRulerDete | SQL expression dependency | OBJECT_OR_COLUMN |
| PWODecisionRule | referenced by foreign key from table | QER_RFRL4363: PWODecisionRuleRulerDetect.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| dbo.ATT_ZAttHelperFillMakeProc | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPWODecisionRuleMakeProc | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPWOHelperFillMakeProc | source text reference | has TRY/CATCH error handling |
| dbo.QER_TUPWODecisionRuleRulerDete | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |