dbo.PWODecisionRule
Approval procedures
TableType TUsage USERDATARows 94SizeMB 0.12
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PWODecisionRule | varchar(38) | no | Approval procedure | PKUID |
UID_Task | varchar(38) | yes | DBQueue Processor task | FKUID |
MaxCountApprover | int(4) | yes | Max. approvers | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
Description | nvarchar(2048) | yes | Short description | |
SortOrder | int(4) | yes | Sort order | |
UsageArea | char(1) | no | Usage | limited |
DecisionRule | nvarchar(4) | yes | Approval procedure | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Remarks | nvarchar(-1) | yes | Description |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1635 | AttestationHistory.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| ATT_RFRL2006 | AttestationHelper.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| ATT_RFRL4366 | ATTBaseObjectHasDecisionRule.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL1060 | QERBufferRecalcDecisionMaker.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL1475 | PWODecisionStep.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL1636 | PWODecisionHistory.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL2000 | PWOHelperPWO.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL312 | QERWorkingStep.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL4363 | PWODecisionRuleRulerDetect.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL4364 | PWODecisionRule.UID_Task | QBMDBQueueTask.UID_Task |
Triggers
GEN_T2BD5E2FC7588A2C2F0D929BFF SQL_TRIGGER
GEN_T5D77945CC5EC5025499AD7B27 SQL_TRIGGER
QER_TDPWODecisionRule SQL_TRIGGER
QER_TIPWODecisionRule SQL_TRIGGER
QER_TUPWODecisionRule 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_PAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationReminder | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttHelperFill_Recalc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttHelperFillMakeProc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_P04F128DC257D2B3C236MAIL_ | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopHelperFill_bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopHelperFill_Recalc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopHelperFillAll | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderResetOneLevel | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheckDecision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopDecisionMakerFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopHelperFill_Recalc | 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.GEN_T5D77945CC5EC5025499AD7B27 | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationHistory | foreign key references table | ATT_RFRL1635: AttestationHistory.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| AttestationHelper | foreign key references table | ATT_RFRL2006: AttestationHelper.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| ATTBaseObjectHasDecisionRule | foreign key references table | ATT_RFRL4366: ATTBaseObjectHasDecisionRule.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| QERBufferRecalcDecisionMaker | foreign key references table | QER_RFRL1060: QERBufferRecalcDecisionMaker.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| PWODecisionStep | foreign key references table | QER_RFRL1475: PWODecisionStep.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| PWODecisionHistory | foreign key references table | QER_RFRL1636: PWODecisionHistory.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| PWOHelperPWO | foreign key references table | QER_RFRL2000: PWOHelperPWO.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| QERWorkingStep | foreign key references table | QER_RFRL312: QERWorkingStep.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| PWODecisionRuleRulerDetect | foreign key references table | QER_RFRL4363: PWODecisionRuleRulerDetect.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| QBMDBQueueTask | referenced by foreign key from table | QER_RFRL4364: PWODecisionRule.UID_Task -> QBMDBQueueTask.UID_Task |
| dbo.ATT_PAttestationHelperFill | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationCheckValid | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationReminder | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttHelperFill_Recalc | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ATT_ZAttHelperFillMakeProc | source text reference | has TRY/CATCH error handling |
| dbo.QER_P04F128DC257D2B3C236MAIL_ | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values |
| dbo.QER_PITShopHelperFill_bulk | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopHelperFill_Recalc | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PITShopHelperFillAll | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PITShopOrderResetOneLevel | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZITShopCheckDecision | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZITShopDecisionMakerFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZITShopHelperFill_Recalc | source text reference | inserts DBQueue tasks, 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 |
| cs-att-compositionapi-server-plugin-att-compositionapi-api-att-policy-editor.cs | decompiled C# reference | classes ATT_Policy_Editor, RequireAttestatorsModifier, IsPolicyWithRemoveProperty, PolicyExtendedDataProvider; methods Get, MoveNext, SetStateMachine, LoadAsync, ValidateAsync, _003CGetDataAsync_003Eb__0; references AttestationObject, AttestationPolicy, AttestationPolicyGroup, AttestationPolicyHasApprover, AttestationPolicyInArea, AttestationRun; markers reads entity values, references DB/Dialog objects |
| cs-att-customizer-att-customizer-attestationcase.cs | decompiled C# reference | classes AttestationCase, MP, DecisionHistoryArgs, _003C_003Ec__DisplayClass4_0; methods _003C_Initialize_IsNotApprovedBefore_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _Initialize_IsNotApprovedBefore, Handle_DecisionHistory; references AttestationCase, AttestationHelper, AttestationHistory, AttestationObject, AttestationPolicy, Delegation; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-att-forms-att-forms-formattestationqueryanswer.cs | decompiled C# reference | classes FormAttestationQueryAnswer; methods OnInit, InitializeComponent, OnFormLoad, MainActivator_OnActivating, ButtonAnswer_Click; references AttestationCase, AttestationHelper, Person, PWODecisionRule; markers references DB/Dialog objects |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-qer-customizer-qer-customizer-pwodecisionsubmethod.cs | decompiled C# reference | classes PWODecisionSubMethod, SelectableEntity, _003C_003Ec__DisplayClass3_0, _003C_003Ec__DisplayClass7_0; methods GetTablename, _003CGetValidityMessages_003Eb__0, _003CValidityCheck_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync; references Delegation, PWODecisionMethod, PWODecisionRule, PWODecisionStep, PWODecisionSubMethod; markers reads entity values, saves entities, references DB/Dialog objects |
| cs-qer-forms-qer-forms-formitshopdecideorder.cs | decompiled C# reference | classes FormITShopDecideOrder; methods OnInit, Proxy_NodeDoubleClick, OnDesignChanged, OnResetForm, _LoadComplianceExceptions, InitializeComponent; references AccProduct, ComplianceArea, ComplianceRule, Delegation, ESet, HelperPWOCompliance; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-forms-qer-forms-formitshopqueryanswer.cs | decompiled C# reference | classes FormITShopQueryAnswer; methods OnInit, InitializeComponent, OnFormLoad, MainActivator_OnActivating, ButtonAnswer_Click; references Person, PersonWantsOrg, PWODecisionRule, PWOHelperPWO; markers references DB/Dialog objects, IT Shop related markers |