dbo.PWOHelperPWO
Auxiliary table for assigning approvers to a specific request.
TableType TUsage MATERIALRows 0SizeMB 0.12
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PWOHelperPWO | varchar(38) | no | Unique ID | PKUID |
UID_PersonHead | varchar(38) | yes | Approver | FKUID |
UID_PersonWantsOrg | varchar(38) | no | Request procedure | FKUID |
LevelNumber | int(4) | no | Level | |
SubLevelNumber | int(4) | no | Parallel sub-steps | |
Decision | nchar(2) | yes | Approval decision | |
ReasonHead | nvarchar(-1) | yes | Reason for decision | |
UID_ComplianceRule | varchar(38) | yes | Rule | FKUID |
NextReminder | datetime(8) | yes | Reminder | |
NextAutomaticDecision | datetime(8) | yes | Automatic approval | |
UID_PersonNonCompliant | varchar(38) | yes | Identity | FKUID |
XObjectKey | varchar(138) | no | Object key | |
UID_PersonAdditional | varchar(38) | yes | Additional approver | FKUID |
UID_PersonInsteadOf | varchar(38) | yes | Delegate | FKUID |
IsFromDelegation | bit(1) | yes | Delegated approval | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_PWODecisionRule | varchar(38) | yes | Approval procedure | FKUID |
UID_PWORulerOrigin | varchar(38) | yes | Request procedure | FKUID |
RulerLevel | int(4) | yes | Type of approver | limited |
UID_QERWorkingStep | varchar(38) | yes | Running instance of approval step | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2000 | PWOHelperPWO.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL2002 | PWOHelperPWO.UID_ComplianceRule | ComplianceRule.UID_ComplianceRule |
| QER_RFRL2004 | PWOHelperPWO.UID_PWORulerOrigin | PersonWantsOrg.UID_PersonWantsOrg |
| QER_RFRL321 | PWOHelperPWO.UID_QERWorkingStep | QERWorkingStep.UID_QERWorkingStep |
| QER_RFRL4145 | PWOHelperPWO.UID_PersonAdditional | Person.UID_Person |
Triggers
GEN_T1FC7AFB917D10028E5A1D8BA2 SQL_TRIGGER
GEN_T277FDE9B5432FCFB87463A97B SQL_TRIGGER
GEN_T34F6CE6FB4D01293A3AD1F3C5 SQL_TRIGGER
QER_TDPWOHelperPWO SQL_TRIGGER
QER_TUPWOHelperPWO 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_FTPWODecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · UID_PWOHelperPWO · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · UID_PersonWantsOrg · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · LevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · SubLevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · Decision · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · UID_PersonAdditional · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · RulerLevel · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · UID_PersonWantsOrg · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · LevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · SubLevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · Decision · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · RulerLevel · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOVisibleForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIReasonTypeForPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZITShopMakeDecisionCR | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZITShopMakeDecisionOC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZITShopMakeDecisionOH | 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_PITShopHelperFillAll | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderMove_bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderResetOneLevel | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_RITShopCheckDecision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_RITShopHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheckDecision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopHelperFill_Recalc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopMakeDecisionCD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopMakeDecisionEX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopMakeDecisionRI | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopMakeDecisionSB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopMakeDecisionWC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopOrderReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZQERWorkingMethodCleanUp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOVisibleForPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1555D0903AA51FFEA947C0D73 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2948D4DD82032AEE0AA8EBBDB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T377F10C7782E804450A883790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T37BE0C7D00AE22EA6A5AE39F5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPersonWantsOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPWOHelperPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_IS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · UID_PWOHelperPWO · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · UID_PersonWantsOrg · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · LevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · SubLevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · Decision · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · UID_PWODecisionRule · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · RulerLevel · OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson_ISP | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.QER_VITShopInterventionPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWODecisionStep | SQL expression dependency | OBJECT_OR_COLUMN |
| PWODecisionRule | referenced by foreign key from table | QER_RFRL2000: PWOHelperPWO.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| ComplianceRule | referenced by foreign key from table | QER_RFRL2002: PWOHelperPWO.UID_ComplianceRule -> ComplianceRule.UID_ComplianceRule |
| PersonWantsOrg | referenced by foreign key from table | QER_RFRL2004: PWOHelperPWO.UID_PWORulerOrigin -> PersonWantsOrg.UID_PersonWantsOrg |
| QERWorkingStep | referenced by foreign key from table | QER_RFRL321: PWOHelperPWO.UID_QERWorkingStep -> QERWorkingStep.UID_QERWorkingStep |
| Person | referenced by foreign key from table | QER_RFRL4145: PWOHelperPWO.UID_PersonAdditional -> Person.UID_Person |
| dbo.QER_FTPWODecisionPossible | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIPWODecisionPossible | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIPWOVisibleForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIReasonTypeForPWO | source text reference | SQL_SCALAR_FUNCTION |
| dbo.CPL_ZITShopMakeDecisionCR | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.CPL_ZITShopMakeDecisionOC | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.CPL_ZITShopMakeDecisionOH | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, 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_PITShopHelperFillAll | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PITShopOrderMove_bulk | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopOrderResetOneLevel | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_RITShopCheckDecision | source text reference | has TRY/CATCH error handling |
| dbo.QER_RITShopHelperFill | source text reference | 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_ZITShopCheck | source text reference | inserts DBQueue tasks, 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_ZITShopHelperFill_Recalc | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZITShopMakeDecisionCD | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopMakeDecisionEX | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.QER_ZITShopMakeDecisionRI | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopMakeDecisionSB | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopMakeDecisionWC | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopOrderReset | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZQERWorkingMethodCleanUp | source text reference | has TRY/CATCH error handling |
| dbo.QER_FTPWOVisibleForPerson_I | source text reference | uses session context values |
| dbo.QER_TDQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPerson | 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.QER_TUPersonWantsOrg | 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.QER_TUPWOHelperPWO | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| 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-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 |