dbo.QERWorkingMethod
Instances of approval workflows with which approvals were started and have not yet been completed.
TableType TUsage WORKRows 2SizeMB 0.032
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERWorkingMethod | varchar(38) | no | Running instance of approval workflow | PKUID |
Ident_PWODecisionSubMethod | nvarchar(128) | yes | Name | |
XObjectKey | varchar(138) | no | Object key | |
DaysToAbort | int(4) | yes | System abort (days) | |
RevisionNumber | int(4) | yes | Revision counter | |
UID_PWODecisionSubMethod | varchar(38) | yes | Approval workflow | FKUID |
LayoutInformation | nvarchar(-1) | yes | Layout information |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL300 | AttestationCase.UID_QERWorkingMethod | QERWorkingMethod.UID_QERWorkingMethod |
| QER_RFRL300 | QERWorkingMethod.UID_PWODecisionSubMethod | PWODecisionSubMethod.UID_PWODecisionSubMethod |
| QER_RFRL301 | QERWorkingStep.UID_QERWorkingMethod | QERWorkingMethod.UID_QERWorkingMethod |
| QER_RFRL302 | PersonWantsOrg.UID_QERWorkingMethod | QERWorkingMethod.UID_QERWorkingMethod |
Triggers
GEN_T2E51A2BDB186E9FC1F4DCE476 SQL_TRIGGER
QER_TUQERWorkingMethod 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_ZAttestationCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PGIQERWorkingMethod | 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_ZQERWorkingMethodCleanUp | 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.ATT_TUPWODecisionSubmethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPWODecisionMethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPWODecisionSubmethod | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationCase | foreign key references table | ATT_RFRL300: AttestationCase.UID_QERWorkingMethod -> QERWorkingMethod.UID_QERWorkingMethod |
| PWODecisionSubMethod | referenced by foreign key from table | QER_RFRL300: QERWorkingMethod.UID_PWODecisionSubMethod -> PWODecisionSubMethod.UID_PWODecisionSubMethod |
| QERWorkingStep | foreign key references table | QER_RFRL301: QERWorkingStep.UID_QERWorkingMethod -> QERWorkingMethod.UID_QERWorkingMethod |
| PersonWantsOrg | foreign key references table | QER_RFRL302: PersonWantsOrg.UID_QERWorkingMethod -> QERWorkingMethod.UID_QERWorkingMethod |
| dbo.ATT_ZAttestationCheck | 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.QER_PGIQERWorkingMethod | source text reference | 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_ZQERWorkingMethodCleanUp | source text reference | 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.ATT_TUPWODecisionSubmethod | 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 |