dbo.PWODecisionMethod
Approval policies
TableType TUsage USERDATARows 58SizeMB 0.144
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PWODecisionMethod | varchar(38) | no | Approval policy | PKUID |
UID_SubMethodOrderProduct | varchar(38) | yes | Approval workflow | FKUID |
Ident_PWODecisionMethod | nvarchar(128) | yes | Approval policy | |
Description | nvarchar(-1) | yes | Description | |
Priority | int(4) | yes | Priority | |
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 | |
UID_SubMethodOrderUnsubscribe | varchar(38) | yes | Cancellation workflow | FKUID |
UID_SubMethodOrderProlongate | varchar(38) | yes | Renewal workflow | FKUID |
UID_DialogRichMailExpiration | varchar(38) | yes | Mail template expired | FKUID |
UID_DialogRichMailAbort | varchar(38) | yes | Mail template aborted | FKUID |
UID_DialogRichMailGrant | varchar(38) | yes | Mail template approved | FKUID |
UID_DialogRichMailNoGrant | varchar(38) | yes | Mail template denied | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UsageArea | char(1) | yes | Usage | limited |
UID_OrgType | varchar(38) | yes | Role type | FKUID |
UID_DialogRichMailUnsubscribe | varchar(38) | yes | Mail template canceled | FKUID |
UID_DialogRichMailProlongate | varchar(38) | yes | Mail template renewed | FKUID |
IsHideFromSelection | bit(1) | yes | Do not show |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1492 | AttestationPolicy.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| ATT_RFRL4300 | AttestationObjectHasPWODM.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| QER_RFRL1630 | BaseTree.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| QER_RFRL1631 | AccProduct.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| QER_RFRL1632 | AccProductGroup.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| QER_RFRL1648 | PWODecisionMethod.UID_SubMethodOrderProduct | PWODecisionSubMethod.UID_PWODecisionSubMethod |
| QER_RFRL2009 | PWODecisionMethod.UID_DialogRichMailExpiration | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2010 | PWODecisionMethod.UID_DialogRichMailAbort | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2011 | PWODecisionMethod.UID_DialogRichMailGrant | DialogRichMail.UID_DialogRichMail |
| QER_RFRL2012 | PWODecisionMethod.UID_DialogRichMailNoGrant | DialogRichMail.UID_DialogRichMail |
| QER_RFRL330 | PWODecisionMethod.UID_DialogRichMailProlongate | DialogRichMail.UID_DialogRichMail |
| QER_RFRL331 | PWODecisionMethod.UID_DialogRichMailUnsubscribe | DialogRichMail.UID_DialogRichMail |
| QER_RFRL972 | PWODecisionMethod.UID_OrgType | OrgType.UID_OrgType |
| QER_RFRL975 | BaseTreeHasPWODecisionMethod.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
Triggers
ATT_TUPWODecisionMethod SQL_TRIGGER
GEN_T1073BDDF17C32D33DC765F12C SQL_TRIGGER
GEN_T2E4614E26421A6D83F97455BE SQL_TRIGGER
GEN_T54A16FAA66A23E4595298A764 SQL_TRIGGER
QER_TDPWODecisionmethod SQL_TRIGGER
QER_TIPWODecisionmethod SQL_TRIGGER
QER_TUPWODecisionMethod 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_FGIPWOSubmethodByMethod | 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_ZITShopDecisionMakerFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUPWODecisionMethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T54A16FAA66A23E4595298A764 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDPWODecisionmethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPWODecisionmethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPWODecisionMethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPWODecisionSubmethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · UID_PWODecisionMethod · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · UID_SubMethodOrderProduct · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_PWODecisionMethod · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_SubMethodOrderProduct · OBJECT_OR_COLUMN |
| dbo.QER_VPWOMethodAndSteps | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWOSubMethod | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VPWOSubMethod | SQL expression dependency | dbo · UID_PWODecisionMethod · OBJECT_OR_COLUMN |
| dbo.QER_VPWOSubMethod | SQL expression dependency | dbo · UID_SubMethodOrderProduct · OBJECT_OR_COLUMN |
| dbo.QER_VPWOSubMethod | SQL expression dependency | dbo · UID_SubMethodOrderUnsubscribe · OBJECT_OR_COLUMN |
| dbo.QER_VPWOSubMethod | SQL expression dependency | dbo · UID_SubMethodOrderProlongate · OBJECT_OR_COLUMN |
| AttestationPolicy | foreign key references table | ATT_RFRL1492: AttestationPolicy.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| AttestationObjectHasPWODM | foreign key references table | ATT_RFRL4300: AttestationObjectHasPWODM.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| BaseTree | foreign key references table | QER_RFRL1630: BaseTree.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| AccProduct | foreign key references table | QER_RFRL1631: AccProduct.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| AccProductGroup | foreign key references table | QER_RFRL1632: AccProductGroup.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| PWODecisionSubMethod | referenced by foreign key from table | QER_RFRL1648: PWODecisionMethod.UID_SubMethodOrderProduct -> PWODecisionSubMethod.UID_PWODecisionSubMethod |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2009: PWODecisionMethod.UID_DialogRichMailExpiration -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2010: PWODecisionMethod.UID_DialogRichMailAbort -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2011: PWODecisionMethod.UID_DialogRichMailGrant -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL2012: PWODecisionMethod.UID_DialogRichMailNoGrant -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL330: PWODecisionMethod.UID_DialogRichMailProlongate -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL331: PWODecisionMethod.UID_DialogRichMailUnsubscribe -> DialogRichMail.UID_DialogRichMail |
| OrgType | referenced by foreign key from table | QER_RFRL972: PWODecisionMethod.UID_OrgType -> OrgType.UID_OrgType |
| BaseTreeHasPWODecisionMethod | foreign key references table | QER_RFRL975: BaseTreeHasPWODecisionMethod.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| dbo.QER_FGIPWOSubmethodByMethod | 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_ZITShopDecisionMakerFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAttestationPolicy | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUPWODecisionMethod | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TDPWODecisionmethod | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPWODecisionmethod | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPWODecisionMethod | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPWODecisionSubmethod | source text reference | inserts DBQueue tasks, 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-att-customizer-att-customizer-attestationpolicy.cs | decompiled C# reference | classes AttestationPolicy, ReportEngine, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass18_0; methods _003CCreateAttestation_003Eb__0, _003CPrepareAttestations_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__2, _003C_GetGrantedCases_003Eb__0, _003C_CreateAttestations_003Eb__0; references AttestationCase, AttestationHelper, AttestationObject, AttestationObjectHasPWODM, AttestationPolicy, AttestationPolicyGroup; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-att-forms-att-forms-formattestationpolicymasterdata.cs | decompiled C# reference | classes FormAttestationPolicyMasterData; methods OnInit, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormUnload, Task_DeletePolicy; references AERole, AttestationObject, AttestationObjectHasPWODM, AttestationPolicy, AttestationPolicyGroup, DialogSchedule; 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-pwodecisionmethod.cs | decompiled C# reference | classes PWODecisionMethod, _003C_003Ec__DisplayClass3_0; methods _003C_Check_PWODecisionSubMethod_003Eb__0, MoveNext, SetStateMachine, GetValidityMessages, GetMessages, _Check_PWODecisionSubMethod; references DialogRichMail, OrgType, PWODecisionMethod, PWODecisionSubMethod; markers reads entity values, references DB/Dialog objects |
| 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 |