dbo.AttestationHistory
Approval sequences
TableType TUsage HISTORYRows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_AttestationHistory | varchar(38) | no | Approval decision | PKUID |
UID_QERJustification | varchar(38) | yes | Standard reason | FKUID |
UID_AttestationCase | varchar(38) | yes | Attestation case | FKUID |
UID_PersonHead | varchar(38) | yes | Approver | FKUID |
DisplayPersonHead | nvarchar(510) | yes | Approver | |
ReasonHead | nvarchar(-1) | yes | Reason for decision | |
DateHead | datetime(8) | yes | Approval date | |
DecisionLevel | int(4) | yes | Approval level | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
DecisionType | nvarchar(32) | yes | Type | limited |
IsDecisionBySystem | bit(1) | yes | Automatic approval | |
Ident_PWODecisionStep | nvarchar(128) | yes | Single step | |
IsToHideInHistory | bit(1) | yes | Do not show in approval history | |
UID_PersonRelated | varchar(38) | yes | Additional approver | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_PWODecisionRule | varchar(38) | yes | Approval procedure | FKUID |
RulerLevel | int(4) | yes | Type of approver | limited |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1496 | AttestationHistory.UID_AttestationCase | AttestationCase.UID_AttestationCase |
| ATT_RFRL1635 | AttestationHistory.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| ATT_RFRL2556 | AttestationHistory.UID_QERJustification | QERJustification.UID_QERJustification |
| ATT_RFRL4216 | AttestationHistory.UID_PersonRelated | Person.UID_Person |
Triggers
GEN_T1A6AC79BDF606D62F8A264E88 SQL_TRIGGER
GEN_T297F4CB11104BC95FD228C198 SQL_TRIGGER
GEN_T3F0BA28A7FAFA1583E4F62350 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_PAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T377F10C7782E804450A883790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3F0D9DEB25E1AE1067533D6A | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationCase | referenced by foreign key from table | ATT_RFRL1496: AttestationHistory.UID_AttestationCase -> AttestationCase.UID_AttestationCase |
| PWODecisionRule | referenced by foreign key from table | ATT_RFRL1635: AttestationHistory.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| QERJustification | referenced by foreign key from table | ATT_RFRL2556: AttestationHistory.UID_QERJustification -> QERJustification.UID_QERJustification |
| Person | referenced by foreign key from table | ATT_RFRL4216: AttestationHistory.UID_PersonRelated -> Person.UID_Person |
| 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_ZAttestationReset | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUPerson | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-att-customizer-att-customizer-attestationcase.cs | decompiled C# reference | classes AttestationCase, MP, DecisionHistoryArgs, _003C_003Ec__DisplayClass4_0; methods _003C_Initialize_IsNotApprovedBefore_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _Initialize_IsNotApprovedBefore, Handle_DecisionHistory; references AttestationCase, AttestationHelper, AttestationHistory, AttestationObject, AttestationPolicy, Delegation; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-att-forms-att-forms-formattestationmakedecision.cs | decompiled C# reference | classes FormAttestationMakeDecision; methods OnInit, InitializeComponent, OnFormLoad, OnFormSizeChanged, OnFormUnload, Task_ShowHistory; references AttestationCase, AttestationHelper, AttestationHistory, AttestationObject, AttestationPolicy, Delegation; markers reads entity values, references DB/Dialog objects |