dbo.AttestationObject
Attestation procedures
TableType TUsage USERDATARows 36SizeMB 0.112
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_AttestationObject | varchar(38) | no | Attestation procedure | PKUID |
Ident_AttestationObject | nvarchar(128) | yes | Attestation procedure | |
ObjectKeyReport | varchar(138) | yes | Report | |
Description | nvarchar(1024) | yes | Description | |
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 | |
StructureDisplayPattern1 | nvarchar(2048) | yes | Grouping column 1 (template) | |
StructureDisplayPattern2 | nvarchar(2048) | yes | Grouping column 2 (template) | |
StructureDisplayPattern3 | nvarchar(2048) | yes | Grouping column 3 (template) | |
PropertyInfoPattern1 | nvarchar(2048) | yes | Property 1 (template) | |
PropertyInfoPattern2 | nvarchar(2048) | yes | Property 2 (template) | |
PropertyInfoPattern3 | nvarchar(2048) | yes | Property 3 (template) | |
PropertyInfoPattern4 | nvarchar(2048) | yes | Property 4 (template) | |
PropertyInfo1 | nvarchar(512) | yes | Property 1 | |
PropertyInfo2 | nvarchar(512) | yes | Property 2 | |
PropertyInfo3 | nvarchar(512) | yes | Property 3 | |
PropertyInfo4 | nvarchar(512) | yes | Property 4 | |
UID_AttestationType | varchar(38) | yes | Attestation type | FKUID |
StructureDisplay1 | nvarchar(512) | yes | Grouping column 1 | |
StructureDisplay2 | nvarchar(512) | yes | Grouping column 2 | |
StructureDisplay3 | nvarchar(512) | yes | Grouping column 3 | |
PreProcessorCondition | nvarchar(2048) | yes | Preprocessor condition | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_DialogTable | varchar(38) | yes | Table | FKUID |
RiskIndexTemplate | nvarchar(2048) | yes | Risk index template | |
ObjectKey1 | nvarchar(2048) | yes | Related object 1 (template) | |
ObjectKey2 | nvarchar(2048) | yes | Related object 2 (template) | |
ObjectKey3 | nvarchar(2048) | yes | Related object 3 (template) | |
UiText | nvarchar(-1) | yes | Text template | |
UiTextGrouped1 | nvarchar(-1) | yes | Grouping column 1 (text template) | |
UiTextGrouped2 | nvarchar(-1) | yes | Grouping column 2 (text template) | |
UiTextGrouped3 | nvarchar(-1) | yes | Grouping column 3 (text template) | |
ObjectReportMode | int(4) | yes | Snapshot content | bitmask |
UiChallengeText | nvarchar(-1) | yes | Text template (Challenge) |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1490 | AttestationPolicy.UID_AttestationObject | AttestationObject.UID_AttestationObject |
| ATT_RFRL4102 | AttestationObject.UID_AttestationType | AttestationType.UID_AttestationType |
| ATT_RFRL4291 | AttestationWizardParm.UID_AttestationObject | AttestationObject.UID_AttestationObject |
| ATT_RFRL4299 | AttestationObjectHasPWODM.UID_AttestationObject | AttestationObject.UID_AttestationObject |
| ATT_RFRL4368 | AttestationObject.UID_DialogTable | DialogTable.UID_DialogTable |
Triggers
ATT_TDAttestationObject SQL_TRIGGER
ATT_TIAttestationObject SQL_TRIGGER
ATT_TUAttestationObject SQL_TRIGGER
GEN_T2FCCAAA13D2C20CBEA232312E SQL_TRIGGER
GEN_T343B1E4ACF10DAA05A5E683FF SQL_TRIGGER
GEN_T511BF46F4409CBC1070EF7365 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_ZAttestationObjectPreProp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationWzParmPreProp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TIAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUDialogTable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C3D78466F05DE84C333B3E26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2630021CB14906358C7D203 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T511BF46F4409CBC1070EF7365 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · UID_AttestationObject · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForObject | SQL expression dependency | dbo · UID_DialogTable · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_AttestationObject · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_DialogTable · OBJECT_OR_COLUMN |
| dbo.GEN_VA293803C3DBC1BD856CDD922F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA5CA004B104300E79A7343554 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA7D7B6157DE10EB7E6F126D8C | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationPolicy | foreign key references table | ATT_RFRL1490: AttestationPolicy.UID_AttestationObject -> AttestationObject.UID_AttestationObject |
| AttestationType | referenced by foreign key from table | ATT_RFRL4102: AttestationObject.UID_AttestationType -> AttestationType.UID_AttestationType |
| AttestationWizardParm | foreign key references table | ATT_RFRL4291: AttestationWizardParm.UID_AttestationObject -> AttestationObject.UID_AttestationObject |
| AttestationObjectHasPWODM | foreign key references table | ATT_RFRL4299: AttestationObjectHasPWODM.UID_AttestationObject -> AttestationObject.UID_AttestationObject |
| DialogTable | referenced by foreign key from table | ATT_RFRL4368: AttestationObject.UID_DialogTable -> DialogTable.UID_DialogTable |
| dbo.ATT_ZAttestationObjectPreProp | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationWzParmPreProp | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TIAttestationPolicy | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAttestationObject | source text reference | inserts DBQueue tasks, uses session context values, 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_TUDialogTable | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-att-compositionapi-server-plugin-att-compositionapi-api-att-policy-editor.cs | decompiled C# reference | classes ATT_Policy_Editor, RequireAttestatorsModifier, IsPolicyWithRemoveProperty, PolicyExtendedDataProvider; methods Get, MoveNext, SetStateMachine, LoadAsync, ValidateAsync, _003CGetDataAsync_003Eb__0; references AttestationObject, AttestationPolicy, AttestationPolicyGroup, AttestationPolicyHasApprover, AttestationPolicyInArea, AttestationRun; markers reads entity values, references DB/Dialog objects |
| 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-forms-att-forms-formattestationadhoc.cs | decompiled C# reference | classes FormAttestationAdhoc; methods OnInit, InitializeComponent, OnFormLoad, OnFormSizeChanged, MainActivator_OnActivating, _AdaptButtonState; references AttestationObject, AttestationPolicy, AttestationPolicyGroup, DialogTable, QERPickCategory, QERPickedItem; markers reads entity values, references DB/Dialog objects |
| 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-formattestationpolicymasterdata.cs | decompiled C# reference | classes FormAttestationPolicyMasterData; methods OnInit, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormUnload, Task_DeletePolicy; references AERole, AttestationObject, AttestationObjectHasPWODM, AttestationPolicy, AttestationPolicyGroup, DialogSchedule; markers references DB/Dialog objects |
| cs-pol-customizer-pol-customizer-qerpolicy.cs | decompiled C# reference | classes QERPolicy, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass5_0; methods _003CCreateAttestations_003Eb__0, _003CCreateAttestations_003Eb__2, _003C_Check_UID_DialogTable_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync; references AERole, AttestationObject, AttestationPolicy, ComplianceArea, DialogTable, MitigatingControl; markers reads entity values, references DB/Dialog objects |