dbo.PWODecisionStep
Approval steps
TableType TUsage USERDATARows 158SizeMB 0.368
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PWODecisionStep | varchar(38) | no | Single step | PKUID |
UID_AERoleFallBack | varchar(38) | yes | Fallback approver | FKUID |
UID_DialogRichMailInsert | varchar(38) | yes | Mail template request | FKUID |
UID_PWODecisionSubMethod | varchar(38) | yes | Approval workflow | FKUID |
LevelNumber | int(4) | yes | Level (0...N) | |
Ident_PWODecisionStep | nvarchar(128) | yes | Single step | |
Description | nvarchar(-1) | yes | Description | |
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 | |
SubLevelNumber | int(4) | yes | Parallel sub-steps | |
DirectSteps | nvarchar(512) | yes | Jump to selection | |
PositiveSteps | int(4) | yes | Steps when approved | |
NegativeSteps | int(4) | yes | Steps when denied | |
LevelDisplay | nvarchar(128) | yes | Approval level | |
WhereClause | nvarchar(-1) | yes | Condition | |
AutomaticReasonTrue | nvarchar(256) | yes | Approval reason | |
AutomaticReasonFalse | nvarchar(256) | yes | Reject reason | |
XObjectKey | varchar(138) | no | Object key | |
CountApprover | int(4) | yes | Number of approvers | |
EscalationSteps | int(4) | yes | Escalation stages | |
MinutesReminder | int(4) | yes | Reminder after (working hours) | |
MinutesAutomaticDecision | int(4) | yes | Timeout (working hours) | |
AutomaticDecision | nvarchar(32) | yes | Timeout behavior | limited |
UID_DialogRichMailReminder | varchar(38) | yes | Mail template reminder | FKUID |
UID_DialogRichMailGrant | varchar(38) | yes | Mail template approved | FKUID |
UID_DialogRichMailNoGrant | varchar(38) | yes | Mail template denied | FKUID |
UID_DialogRichMailEscalate | varchar(38) | yes | Mail template escalation | FKUID |
UID_DialogRichMailFromDelegat | varchar(38) | yes | Mail template rejection | FKUID |
UID_DialogRichMailToDelegat | varchar(38) | yes | Mail template delegation | FKUID |
IsAdditionalAllowed | bit(1) | yes | Additional approvers possible | |
IsInsteadOfAllowed | bit(1) | yes | Approval can be delegated | |
IsToHideInHistory | bit(1) | yes | Do not show in approval history | |
IsNoAutoDecision | bit(1) | yes | No automatic approval | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UsageArea | char(1) | yes | Usage | limited |
UID_PWODecisionRule | varchar(38) | no | Approval procedure | FKUID |
ObjectKeyOfAssignedOrg | varchar(138) | yes | Role | |
UID_PWOStateFinalSuccess | varchar(38) | yes | Processing status on success | FKUID |
UID_PWOStateFinalError | varchar(38) | yes | Processing status on error | FKUID |
IgnoreNoDecideForPerson | bit(1) | yes | Approval by affected identity | |
EscalateIfNoApprover | bit(1) | yes | Escalate when no approver found | |
ApproveReasonType | int(4) | yes | Reason type on approval | limited |
DenyReasonType | int(4) | yes | Reason type on denial | limited |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1022 | PWODecisionStep.UID_PWOStateFinalSuccess | PWOState.UID_PWOState |
| QER_RFRL1023 | PWODecisionStep.UID_PWOStateFinalError | PWOState.UID_PWOState |
| QER_RFRL1475 | PWODecisionStep.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL1647 | PWODecisionStep.UID_PWODecisionSubMethod | PWODecisionSubMethod.UID_PWODecisionSubMethod |
| QER_RFRL2013 | PWODecisionStep.UID_DialogRichMailInsert | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2014 | PWODecisionStep.UID_DialogRichMailReminder | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2015 | PWODecisionStep.UID_DialogRichMailGrant | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2016 | PWODecisionStep.UID_DialogRichMailNoGrant | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2017 | PWODecisionStep.UID_DialogRichMailEscalate | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2571 | PWODecisionStep.UID_AERoleFallBack | BaseTree.UID_Org |
| QER_RFRL4149 | PWODecisionStep.UID_DialogRichMailToDelegat | DialogRichMail.UID_DialogRichMail |
Triggers
GEN_T1AF1FD942F30912B5AF7846CE SQL_TRIGGER
GEN_T2B14B9477C202C5E94470B3C0 SQL_TRIGGER
GEN_T38AB1ECB39182A61540C3484F SQL_TRIGGER
GEN_T59B43D7BDD1F2D7FBC82716DD SQL_TRIGGER
QER_TIPWODecisionStep 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.QER_FGIPWOSubMethodHasCycle | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PGIQERWorkingMethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopCheckMethodBO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopDecisionMakerFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1602C5A0BAC27A48E95720320 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2B719FED154C6C7C9A065C1E3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T31BD601EABB9F14FD0E7A94AA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T59B43D7BDD1F2D7FBC82716DD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · UID_PWODecisionSubMethod · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · UID_PWODecisionRule · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_PWODecisionSubMethod · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_PWODecisionRule · OBJECT_OR_COLUMN |
| dbo.QER_VPWOMethodAndSteps | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| PWOState | referenced by foreign key from table | QER_RFRL1022: PWODecisionStep.UID_PWOStateFinalSuccess -> PWOState.UID_PWOState |
| PWOState | referenced by foreign key from table | QER_RFRL1023: PWODecisionStep.UID_PWOStateFinalError -> PWOState.UID_PWOState |
| PWODecisionRule | referenced by foreign key from table | QER_RFRL1475: PWODecisionStep.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| PWODecisionSubMethod | referenced by foreign key from table | QER_RFRL1647: PWODecisionStep.UID_PWODecisionSubMethod -> PWODecisionSubMethod.UID_PWODecisionSubMethod |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2013: PWODecisionStep.UID_DialogRichMailInsert -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2014: PWODecisionStep.UID_DialogRichMailReminder -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2015: PWODecisionStep.UID_DialogRichMailGrant -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2016: PWODecisionStep.UID_DialogRichMailNoGrant -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2017: PWODecisionStep.UID_DialogRichMailEscalate -> DialogRichMail.UID_DialogRichMail |
| BaseTree | referenced by foreign key from table | QER_RFRL2571: PWODecisionStep.UID_AERoleFallBack -> BaseTree.UID_Org |
| DialogRichMail | referenced by foreign key from table | QER_RFRL4149: PWODecisionStep.UID_DialogRichMailToDelegat -> DialogRichMail.UID_DialogRichMail |
| dbo.QER_FGIPWOSubMethodHasCycle | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_PGIQERWorkingMethod | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopCheckMethodBO | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZAllForPersonInBaseTree | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopDecisionMakerFill | source text reference | uses session context values, 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-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 |