dbo.AttestationHelper
Auxiliary table for assigning attestors to specific attestation cases.
TableType TUsage MATERIALRows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_AttestationHelper | varchar(38) | no | Unique ID | PKUID |
UID_PersonHead | varchar(38) | yes | Approver | FKUID |
UID_AttestationCase | varchar(38) | no | Attestation case | FKUID |
LevelNumber | int(4) | no | Level | |
SubLevelNumber | int(4) | no | Parallel sub-steps | |
Decision | nchar(2) | yes | Approval decision | |
ReasonHead | nvarchar(-1) | yes | Reason for decision | |
XObjectKey | varchar(138) | no | Object key | |
NextReminder | datetime(8) | yes | Reminder | |
NextAutomaticDecision | datetime(8) | yes | Automatic approval | |
UID_PersonAdditional | varchar(38) | yes | Additional approver | FKUID |
UID_PersonInsteadOf | varchar(38) | yes | Delegate | FKUID |
IsFromDelegation | bit(1) | yes | Delegated approval | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_PWODecisionRule | varchar(38) | yes | Approval procedure | FKUID |
RulerLevel | int(4) | yes | Type of approver | limited |
UID_QERWorkingStep | varchar(38) | yes | Running instance of approval step | FKUID |
UID_PWORulerOrigin | varchar(38) | yes | Request procedure | FKUID |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL2005 | AttestationHelper.UID_AttestationCase | AttestationCase.UID_AttestationCase |
| ATT_RFRL2006 | AttestationHelper.UID_PWODecisionRule | PWODecisionRule.UID_PWODecisionRule |
| ATT_RFRL301 | AttestationHelper.UID_QERWorkingStep | QERWorkingStep.UID_QERWorkingStep |
| ATT_RFRL302 | AttestationHelper.UID_PWORulerOrigin | PersonWantsOrg.UID_PersonWantsOrg |
| ATT_RFRL4147 | AttestationHelper.UID_PersonAdditional | Person.UID_Person |
Triggers
ATT_TDAttestationHelper SQL_TRIGGER
GEN_T108BA2E4DE93DD613CD49280F SQL_TRIGGER
GEN_T2F9A7508BEBBF23909C15EDD0 SQL_TRIGGER
GEN_T39BF003F3057A9D564EF2B84F 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_AttestationCase · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · LevelNumber · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · SubLevelNumber · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · Decision · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · RulerLevel · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · UID_AttestationCase · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · LevelNumber · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · SubLevelNumber · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · Decision · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · RulerLevel · OBJECT_OR_COLUMN |
| dbo.ATT_FGIATTDecisionPossible | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.ATT_FGIReasonTypeForAttCase | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationResetOneLevel | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationCheck | 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_ZAttestationReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttHelperFill_Recalc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6B98DA23F38CBB384A685EC8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TDQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TIQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationCase | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_TUATTComplianceRule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1555D0903AA51FFEA947C0D73 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2948D4DD82032AEE0AA8EBBDB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T377F10C7782E804450A883790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.POL_TIATTPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.POL_TUATTPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.POL_TUATTQERPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_AttestationHelper · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_AttestationCase · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · LevelNumber · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · SubLevelNumber · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · Decision · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_PWODecisionRule · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · RulerLevel · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_QERWorkingStep · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATTVCasesOpenByPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3F0D9DEB25E1AE1067533D6A | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationCase | referenced by foreign key from table | ATT_RFRL2005: AttestationHelper.UID_AttestationCase -> AttestationCase.UID_AttestationCase |
| PWODecisionRule | referenced by foreign key from table | ATT_RFRL2006: AttestationHelper.UID_PWODecisionRule -> PWODecisionRule.UID_PWODecisionRule |
| QERWorkingStep | referenced by foreign key from table | ATT_RFRL301: AttestationHelper.UID_QERWorkingStep -> QERWorkingStep.UID_QERWorkingStep |
| PersonWantsOrg | referenced by foreign key from table | ATT_RFRL302: AttestationHelper.UID_PWORulerOrigin -> PersonWantsOrg.UID_PersonWantsOrg |
| Person | referenced by foreign key from table | ATT_RFRL4147: AttestationHelper.UID_PersonAdditional -> Person.UID_Person |
| dbo.ATT_FTATTDecisionPossible | 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.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_PAttestationResetOneLevel | source text reference | has TRY/CATCH error handling |
| dbo.ATT_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| 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.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_ZAttestationReset | source text reference | inserts DBQueue tasks, 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.QER_ZQERWorkingMethodCleanUp | source text reference | has TRY/CATCH error handling |
| dbo.ATT_TDQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TIQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAttestationCase | 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 |
| dbo.ATT_TUQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.CPL_TUATTComplianceRule | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.POL_TIATTPersonInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.POL_TUATTPersonInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.POL_TUATTQERPolicy | source text reference | 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-customizer-att-customizer-attestationpolicy.cs | decompiled C# reference | classes AttestationPolicy, ReportEngine, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass18_0; methods _003CCreateAttestation_003Eb__0, _003CPrepareAttestations_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__2, _003C_GetGrantedCases_003Eb__0, _003C_CreateAttestations_003Eb__0; references AttestationCase, AttestationHelper, AttestationObject, AttestationObjectHasPWODM, AttestationPolicy, AttestationPolicyGroup; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-att-customizer-att-customizer-attestationpolicygroup.cs | decompiled C# reference | classes AttestationPolicyGroup, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass3_0, _003C_003Ec__DisplayClass8_0; methods _003CCheckAssignedPolicies_003Eb__0, _003CExistsChunksUnderConstruction_003Eb__0, _003C_CreateAttestations_003Eb__0, _003C_CreateAttestationRun_003Eb__0, MoveNext, SetStateMachine; references AttestationHelper, AttestationPolicy, AttestationPolicyGroup, AttestationRun, Method_Attestation, QERPickCategory; markers reads entity values, references DB/Dialog objects, Job/process 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 |
| cs-att-forms-att-forms-formattestationqueryanswer.cs | decompiled C# reference | classes FormAttestationQueryAnswer; methods OnInit, InitializeComponent, OnFormLoad, MainActivator_OnActivating, ButtonAnswer_Click; references AttestationCase, AttestationHelper, Person, PWODecisionRule; markers references DB/Dialog objects |