dbo.QERWorkingStep
Running instances of approval steps
TableType TUsage WORKRows 9SizeMB 0.128
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERWorkingStep | varchar(38) | no | Running instance of approval step | PKUID |
LevelNumber | int(4) | yes | Level (0...N) | |
Ident_PWODecisionStep | nvarchar(128) | yes | Single step | |
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 |
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 | |
IgnoreNoDecideForPerson | bit(1) | yes | Approval by affected identity | |
IsNoAutoDecision | bit(1) | yes | No automatic approval | |
ObjectKeyOfAssignedOrg | varchar(138) | yes | Role | |
UID_QERWorkingMethod | varchar(38) | no | Running instance of approval workflow | FKUID |
UID_PWODecisionRule | varchar(38) | no | Approval procedure | FKUID |
UID_AERoleFallBack | varchar(38) | yes | Fallback approver | FKUID |
UID_DialogRichMailInsert | varchar(38) | yes | Mail template request | FKUID |
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 |
UID_PWOStateFinalSuccess | varchar(38) | yes | Processing status on success | FKUID |
UID_PWOStateFinalError | varchar(38) | yes | Processing status on error | FKUID |
UID_PWODecisionStep | varchar(38) | yes | Single step | FKUID |
EscalateIfNoApprover | bit(1) | yes | Escalate when no approver found | |
ApproveReasonType | int(4) | yes | Reason type on approval | |
DenyReasonType | int(4) | yes | Reason type on denial |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL301 | AttestationHelper.UID_QERWorkingStep | QERWorkingStep.UID_QERWorkingStep |
| QER_RFRL301 | QERWorkingStep.UID_QERWorkingMethod | QERWorkingMethod.UID_QERWorkingMethod |
| QER_RFRL303 | QERWorkingStep.UID_PWOStateFinalError | PWOState.UID_PWOState |
| QER_RFRL304 | QERWorkingStep.UID_PWOStateFinalSuccess | PWOState.UID_PWOState |
| QER_RFRL305 | QERWorkingStep.UID_DialogRichMailToDelegat | DialogRichMail.UID_DialogRichMail |
| QER_RFRL306 | QERWorkingStep.UID_DialogRichMailFromDelegat | DialogRichMail.UID_DialogRichMail |
| QER_RFRL307 | QERWorkingStep.UID_DialogRichMailReminder | DialogRichMail.UID_DialogRichMail |
| QER_RFRL308 | QERWorkingStep.UID_DialogRichMailEscalate | DialogRichMail.UID_DialogRichMail |
| QER_RFRL309 | QERWorkingStep.UID_DialogRichMailInsert | DialogRichMail.UID_DialogRichMail |
| QER_RFRL310 | QERWorkingStep.UID_DialogRichMailNoGrant | DialogRichMail.UID_DialogRichMail |
| QER_RFRL311 | QERWorkingStep.UID_DialogRichMailGrant | DialogRichMail.UID_DialogRichMail |
| QER_RFRL312 | QERWorkingStep.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| QER_RFRL313 | QERWorkingStep.UID_AERoleFallBack | BaseTree.UID_Org |
| QER_RFRL321 | PWOHelperPWO.UID_QERWorkingStep | QERWorkingStep.UID_QERWorkingStep |
Triggers
GEN_T1602C5A0BAC27A48E95720320 SQL_TRIGGER
GEN_T2B719FED154C6C7C9A065C1E3 SQL_TRIGGER
GEN_T35C133F0DA24469EA0881F50B SQL_TRIGGER
QER_TUQERWorkingStep 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.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · CountApprover · OBJECT_OR_COLUMN |
| dbo.GEN_FT032C01FB0E597D2C49C9AA2B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT1093A1F0406D5754E767A32A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT34816235C513399D9EC4B5F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT474E0610FF6A5DEAACC51165 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4F8BB10C39B7D5A024EDA2F1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT5722C3D575F878FB30B0EE5B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT61E9B94DD675AEA640904E7A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT689C0C5D42573B4E1448C6FB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6A2C0DF51691F8246FF36409 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6BE605DBC013D4424FB2A91A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT7D2F97BFC21ABB2179BCC834 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT875A2A9B553B575E8AD6791C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT94D9103F05436CEA1C011366 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT97DC0B0241148F62753FCDF5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTBB042D9B3231E5643CB9EF48 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTBD06BC392C446FFD04D09C27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC981DF5F2F0406E0D7320D5B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE61C28094906F2921112552C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTF87E7DEA381CD3F5FFD8544F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.QER_FTPWODecisionPossible | SQL expression dependency | dbo · CountApprover · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · CountApprover · OBJECT_OR_COLUMN |
| dbo.ATT_FGIReasonTypeForAttCase | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWODecisionPossible | SQL expression dependency | dbo · CountApprover · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOStateFinalError | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOStateFinalError | SQL expression dependency | dbo · LevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOStateFinalError | SQL expression dependency | dbo · SubLevelNumber · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOStateFinalError | SQL expression dependency | dbo · UID_QERWorkingMethod · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOStateFinalError | SQL expression dependency | dbo · UID_PWOStateFinalError · OBJECT_OR_COLUMN |
| dbo.QER_FGIReasonTypeForPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationMakeDecisionCD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationMakeDecisionEX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationMakeDecisionWC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationReminder | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttHelperFill_Recalc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZITShopMakeDecisionCR | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_P04F128DC257D2B3C236MAIL_ | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PGIQERWorkingMethod | 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_PRulerDetect_OX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PRulerDetect_PX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAllForPersonInBaseTree | 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_ZITShopMakeDecisionWC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZQERWorkingMethodCleanUp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTAttNextDecisionMaker | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT5C31CBA75ED12BD77F42A910 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6B98DA23F38CBB384A685EC8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT7415D684E2A17F2FE3F75C98 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT87DD7CCCB1A93594B7DE8E69 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTDB92B44B6D3F9012EB5B6BC0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPwoNextDecisionMaker | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T38AB1ECB39182A61540C3484F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERWorkingStep | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VITShopDecisionPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWODecisionStep | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationHelper | foreign key references table | ATT_RFRL301: AttestationHelper.UID_QERWorkingStep -> QERWorkingStep.UID_QERWorkingStep |
| QERWorkingMethod | referenced by foreign key from table | QER_RFRL301: QERWorkingStep.UID_QERWorkingMethod -> QERWorkingMethod.UID_QERWorkingMethod |
| PWOState | referenced by foreign key from table | QER_RFRL303: QERWorkingStep.UID_PWOStateFinalError -> PWOState.UID_PWOState |
| PWOState | referenced by foreign key from table | QER_RFRL304: QERWorkingStep.UID_PWOStateFinalSuccess -> PWOState.UID_PWOState |
| DialogRichMail | referenced by foreign key from table | QER_RFRL305: QERWorkingStep.UID_DialogRichMailToDelegat -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL306: QERWorkingStep.UID_DialogRichMailFromDelegat -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL307: QERWorkingStep.UID_DialogRichMailReminder -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL308: QERWorkingStep.UID_DialogRichMailEscalate -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL309: QERWorkingStep.UID_DialogRichMailInsert -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL310: QERWorkingStep.UID_DialogRichMailNoGrant -> DialogRichMail.UID_DialogRichMail |
| DialogRichMail | referenced by foreign key from table | QER_RFRL311: QERWorkingStep.UID_DialogRichMailGrant -> DialogRichMail.UID_DialogRichMail |
| PWODecisionRule | referenced by foreign key from table | QER_RFRL312: QERWorkingStep.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| BaseTree | referenced by foreign key from table | QER_RFRL313: QERWorkingStep.UID_AERoleFallBack -> BaseTree.UID_Org |
| PWOHelperPWO | foreign key references table | QER_RFRL321: PWOHelperPWO.UID_QERWorkingStep -> QERWorkingStep.UID_QERWorkingStep |
| dbo.ATT_FTATTDecisionPossible | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWODecisionPossible | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FGIATTDecisionPossible | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ATT_FGIReasonTypeForAttCase | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIPWODecisionPossible | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIPWOStateFinalError | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIReasonTypeForPWO | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ATT_PAttestationHelperFill | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationCheckValid | 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.ATT_ZAttestationMakeDecisionCD | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationMakeDecisionEX | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationMakeDecisionWC | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationReminder | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttHelperFill_Recalc | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| 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.QER_P04F128DC257D2B3C236MAIL_ | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values |
| dbo.QER_PGIQERWorkingMethod | source text reference | uses session context values, has TRY/CATCH error handling |
| 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_PRulerDetect_OX | source text reference | has TRY/CATCH error handling |
| dbo.QER_PRulerDetect_PX | 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_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_ZITShopMakeDecisionWC | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZQERWorkingMethodCleanUp | source text reference | has TRY/CATCH error handling |
| dbo.ATT_FTAttNextDecisionMaker | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPwoNextDecisionMaker | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TUQERWorkingStep | source text reference | uses session context values, has TRY/CATCH error handling |