dbo.PWODecisionHistory
Approval sequences
TableType TUsage HISTORYRows 2SizeMB 0.088
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PWODecisionHistory | varchar(38) | no | Approval decision | PKUID |
UID_QERJustification | varchar(38) | yes | Standard reason | FKUID |
UID_PersonWantsOrg | varchar(38) | yes | Request procedure | FKUID |
DisplayPersonHead | nvarchar(256) | yes | Approver | |
ReasonHead | nvarchar(-1) | yes | Reason for decision | |
DateHead | datetime(8) | yes | Approval date | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
DecisionLevel | int(4) | yes | Approval level | |
XTouched | nchar(2) | yes | Processing status | |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
ValidUntil | datetime(8) | yes | Valid until | |
ValidFrom | datetime(8) | yes | Valid from | |
DecisionType | nvarchar(32) | yes | Type | limited |
IsDecisionBySystem | bit(1) | yes | Automatic approval | |
UID_PersonHead | varchar(38) | yes | Approver | FKUID |
XObjectKey | varchar(138) | no | Object key | |
Ident_PWODecisionStep | nvarchar(128) | yes | Single step | |
OrderState | nvarchar(32) | yes | Request status | limited |
UID_ITShopOrgFinal | varchar(38) | yes | Resulting product | FKUID |
UID_PersonRelated | varchar(38) | yes | Additional approver | FKUID |
IsToHideInHistory | bit(1) | yes | Do not show in approval history | |
UID_ComplianceRule | varchar(38) | yes | Violated rule | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_PWODecisionRule | varchar(38) | yes | Approval procedure | FKUID |
UID_PWOState | varchar(38) | yes | Processing status | FKUID |
RulerLevel | int(4) | yes | Type of approver | limited |
ValidUntilProlongation | datetime(8) | yes | Renewed until | |
UID_ShoppingCartOrder | varchar(38) | yes | Cart | FKUID |
ValidUntilUnsubscribe | datetime(8) | yes | Unsubscribed as from | |
PWOPriority | int(4) | yes | Priority | limited |
IsFromDelegation | bit(1) | yes | Decision was delegated | |
ExceptionValidUntil | datetime(8) | yes | Exception approval valid until |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1403 | PWODecisionHistory.UID_PersonWantsOrg | PersonWantsOrg.UID_PersonWantsOrg |
| QER_RFRL1406 | PWODecisionHistory.UID_PWOState | PWOState.UID_PWOState |
| QER_RFRL1636 | PWODecisionHistory.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL2576 | PWODecisionHistory.UID_QERJustification | QERJustification.UID_QERJustification |
| QER_RFRL4159 | PWODecisionHistory.UID_ITShopOrgFinal | BaseTree.UID_Org |
| QER_RFRL4201 | PWODecisionHistory.UID_PersonRelated | Person.UID_Person |
| QER_RFRL4344 | PWODecisionHistory.UID_ComplianceRule | ComplianceRule.UID_ComplianceRule |
Triggers
GEN_T106341A935920D1948D2514AD SQL_TRIGGER
GEN_T2E410FDD0F422F68DA5855BC7 SQL_TRIGGER
GEN_T33AF8479DCCF3482B6F024C03 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.GEN_FT12C0B2408424D9890C9F1048 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOVisibleForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopHelperFill_bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderHistoryInsert | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderMove_bulk | 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_ZITShopOrderReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTF92FC20349C1D00C1D7DBCA7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOVisibleForPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T31EC3716F8EE9DF11DE8931FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T377F10C7782E804450A883790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAA94C8874CD8967DE2A9C893F | SQL expression dependency | OBJECT_OR_COLUMN |
| PersonWantsOrg | referenced by foreign key from table | QER_RFRL1403: PWODecisionHistory.UID_PersonWantsOrg -> PersonWantsOrg.UID_PersonWantsOrg |
| PWOState | referenced by foreign key from table | QER_RFRL1406: PWODecisionHistory.UID_PWOState -> PWOState.UID_PWOState |
| PWODecisionRule | referenced by foreign key from table | QER_RFRL1636: PWODecisionHistory.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| QERJustification | referenced by foreign key from table | QER_RFRL2576: PWODecisionHistory.UID_QERJustification -> QERJustification.UID_QERJustification |
| BaseTree | referenced by foreign key from table | QER_RFRL4159: PWODecisionHistory.UID_ITShopOrgFinal -> BaseTree.UID_Org |
| Person | referenced by foreign key from table | QER_RFRL4201: PWODecisionHistory.UID_PersonRelated -> Person.UID_Person |
| ComplianceRule | referenced by foreign key from table | QER_RFRL4344: PWODecisionHistory.UID_ComplianceRule -> ComplianceRule.UID_ComplianceRule |
| dbo.QER_FGIPWOVisibleForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_PITShopHelperFill_bulk | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopOrderHistoryInsert | source text reference | uses session context values, 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_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_ZITShopOrderReset | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_FTPWOVisibleForPerson_I | source text reference | uses session context values |
| cs-qer-compositionapi-qer-compositionapi-itshop-accepttermsofuse.cs | decompiled C# reference | classes AcceptTermsOfUse; methods MoveNext, SetStateMachine, AcceptAsync; references Person, PersonWantsOrg, PWODecisionHistory, QERJustification; markers reads entity values, writes entity values, saves entities, 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 |