dbo.PWOState
Processing statuses
TableType TUsage USERDATARows 1SizeMB 0.024
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PWOState | varchar(38) | no | Processing status | PKUID |
Ident_PWOState | nvarchar(128) | no | Processing status | |
Description | nvarchar(-1) | yes | Description | |
IsSuccess | bit(1) | yes | Success | |
IsFinal | bit(1) | yes | Closed | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
OrderNumber | int(4) | yes | Sort order | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1022 | PWODecisionStep.UID_PWOStateFinalSuccess | PWOState.UID_PWOState |
| QER_RFRL1023 | PWODecisionStep.UID_PWOStateFinalError | PWOState.UID_PWOState |
| QER_RFRL1024 | PersonWantsOrg.UID_PWOState | PWOState.UID_PWOState |
| QER_RFRL1406 | PWODecisionHistory.UID_PWOState | PWOState.UID_PWOState |
| QER_RFRL303 | QERWorkingStep.UID_PWOStateFinalError | PWOState.UID_PWOState |
| QER_RFRL304 | QERWorkingStep.UID_PWOStateFinalSuccess | PWOState.UID_PWOState |
Triggers
GEN_T2811EB02B2E5DD244AB97D7A2 SQL_TRIGGER
GEN_T4AA6CD8F964E38272A933F89D SQL_TRIGGER
GEN_T57EF79A1ACD4E2A635F444A69 SQL_TRIGGER
GEN_T623E448C1E71E729BA059D8B8 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.QERVPersonHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · UID_PWOState · OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · Ident_PWOState · OBJECT_OR_COLUMN |
| PWODecisionStep | foreign key references table | QER_RFRL1022: PWODecisionStep.UID_PWOStateFinalSuccess -> PWOState.UID_PWOState |
| PWODecisionStep | foreign key references table | QER_RFRL1023: PWODecisionStep.UID_PWOStateFinalError -> PWOState.UID_PWOState |
| PersonWantsOrg | foreign key references table | QER_RFRL1024: PersonWantsOrg.UID_PWOState -> PWOState.UID_PWOState |
| PWODecisionHistory | foreign key references table | QER_RFRL1406: PWODecisionHistory.UID_PWOState -> PWOState.UID_PWOState |
| QERWorkingStep | foreign key references table | QER_RFRL303: QERWorkingStep.UID_PWOStateFinalError -> PWOState.UID_PWOState |
| QERWorkingStep | foreign key references table | QER_RFRL304: QERWorkingStep.UID_PWOStateFinalSuccess -> PWOState.UID_PWOState |
| cs-qer-customizer-qer-customizer-delegation.cs | decompiled C# reference | classes Delegation; methods MoveNext, SetStateMachine, OnSavingAsync, GetParentInformed, _CheckDelegation, _CheckPwO; references DelegableItem, Delegation, Person, PersonWantsOrg, PWOState; 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 |