dbo.AttestationPolicy
Attestation policies
TableType TUsage USERDATARows 52SizeMB 0.2
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_AttestationPolicy | varchar(38) | no | Attestation policy | PKUID |
UID_PWODecisionMethod | varchar(38) | yes | Approval policy | FKUID |
Ident_AttestationPolicy | nvarchar(128) | yes | Attestation policy | |
Description | nvarchar(-1) | yes | Description | |
UID_DialogSchedule | varchar(38) | yes | Calculation schedule | FKUID |
UID_AttestationObject | varchar(38) | yes | Attestation procedure | FKUID |
WhereClause | nvarchar(-1) | yes | Condition | |
WhereClauseAddOn | nvarchar(-1) | yes | Additional condition | |
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 | |
ReportType | nvarchar(32) | yes | Output format | limited |
IsAutoCloseOldCases | bit(1) | yes | Close obsolete tasks automatically | |
DefaultReasonAutomation | nvarchar(510) | yes | Reason for decision | |
SolutionDays | int(4) | yes | Time required [days] | |
WhereClauseMeta | nvarchar(-1) | yes | Definition (XML) | |
RiskIndex | float(8) | yes | Risk index | |
RiskIndexReduced | float(8) | yes | Risk index (reduced) | |
UID_PersonOwner | varchar(38) | yes | Owner | FKUID |
LimitOfOldCases | int(4) | yes | Obsolete tasks limit | |
IsInActive | bit(1) | yes | Disabled | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsApproveRequiresMfa | bit(1) | yes | Approval by multi-factor authentication | |
UID_AERoleOwner | varchar(38) | yes | Owner (Application Role) | FKUID |
UID_QERPickCategory | varchar(38) | yes | Selection | FKUID |
UID_DialogCulture | varchar(38) | yes | Language culture | FKUID |
IsShowElementsInvolved | bit(1) | yes | Display objects to be attested | |
IsSetApprovalStateOnApproved | bit(1) | yes | Set certification status on "Certified" | |
IsSetApprovalStateOnDenied | bit(1) | yes | Set certification status on "Denied" | |
IsSingleCaseNotification | bit(1) | yes | Always send single notifications of pending attestations | |
UID_QERTermsOfUse | varchar(38) | yes | Terms of use | FKUID |
ApproveReasonType | int(4) | yes | Reason type on approval | limited |
DenyReasonType | int(4) | yes | Reason type on denial | limited |
UID_AttestationPolicyGroup | varchar(38) | yes | Policy collection | FKUID |
IsNoRunOnEmptyResult | bit(1) | yes | No empty attestation runs |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1490 | AttestationPolicy.UID_AttestationObject | AttestationObject.UID_AttestationObject |
| ATT_RFRL1491 | AttestationPolicy.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
| ATT_RFRL1492 | AttestationPolicy.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| ATT_RFRL1497 | AttestationCase.UID_AttestationPolicy | AttestationPolicy.UID_AttestationPolicy |
| ATT_RFRL1500 | AttestationRun.UID_AttestationPolicy | AttestationPolicy.UID_AttestationPolicy |
| ATT_RFRL1520 | AttestationPolicy.UID_DialogCulture | QBMCulture.UID_DialogCulture |
| ATT_RFRL1600 | AttestationPolicy.UID_AERoleOwner | BaseTree.UID_Org |
| ATT_RFRL1624 | HelperAttestationPolicy.UID_AttestationPolicy | AttestationPolicy.UID_AttestationPolicy |
| ATT_RFRL1702 | AttestationPolicy.UID_QERTermsOfUse | QERTermsOfUse.UID_QERTermsOfUse |
| ATT_RFRL310 | AttestationPolicy.UID_QERPickCategory | QERPickCategory.UID_QERPickCategory |
| ATT_RFRL4104 | AttestationPolicyInArea.UID_AttestationPolicy | AttestationPolicy.UID_AttestationPolicy |
| ATT_RFRL4155 | AttestationPolicyHasApprover.UID_AttestationPolicy | AttestationPolicy.UID_AttestationPolicy |
| ATT_RFRL4208 | AttestationPolicyHasMControl.UID_AttestationPolicy | AttestationPolicy.UID_AttestationPolicy |
| ATT_RFRL4212 | AttestationPolicy.UID_PersonOwner | Person.UID_Person |
Triggers
ATT_TIAttestationPolicy SQL_TRIGGER
ATT_TUAttestationPolicy SQL_TRIGGER
GEN_T1724544813405378905FD5A89 SQL_TRIGGER
GEN_T29698F2AE52B0B72F31AA7452 SQL_TRIGGER
GEN_T3C4790A4702909C7764E58DD5 SQL_TRIGGER
GEN_T5B319CA8AD0EEA2FAD9DD3D68 SQL_TRIGGER
GEN_TDDYGA964EB230DF47A9D50880 SQL_TRIGGER
GEN_TIDYGCC54F915C5CBE9D05771B SQL_TRIGGER
GEN_TUDYGEE902123E8EC377488E2B 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.GEN_FT2C7A1B8F5142CADC43C12E36 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT608B5DA1F6AD03A10CD2C831 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FGIReasonTypeForAttCase | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAfterMigrationTasks | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationCaseCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationCaseDeleteOld | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PHelperAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZHelperAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZScheduleStart | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P97BEC6314D4BB90FE52DF01BE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA6BF9FD71303E4D8F82AD2566 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDBDCABA4BA9EB91B037DD3763 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2A6B61A1A68C55C23D506F43 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T163BACAD4C56A752C4FAF6CA6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C3D78466F05DE84C333B3E26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D01571F7BC5055F3A7389C93 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T239F21D783D386786BEB87121 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2630021CB14906358C7D203 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C70041B2DC77CE85F47E49FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5B319CA8AD0EEA2FAD9DD3D68 | 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_AttestationPolicy · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · Ident_AttestationPolicy · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · Description · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_AttestationPolicy · OBJECT_OR_COLUMN |
| dbo.ATT_VAttMethodForPolicy | SQL expression dependency | dbo · UID_AttestationObject · OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · UID_AttestationPolicy · OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · UID_AttestationPolicyGroup · OBJECT_OR_COLUMN |
| dbo.GEN_VA1D2C7FA260E5E16154DD6176 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA25D7F6BF7D5FDBED9317006F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA2762FFD20AA3ACC4FE56E7F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA293803C3DBC1BD856CDD922F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA32BDA1DCB812DCADC999EA4B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA37708886E5E94799AAB62D42 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA41551C6BAF738FFF56E41796 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA5CA004B104300E79A7343554 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA661CC924758A1D4472C45800 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA6E29F464D57F9113C35C7118 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA79D54C7FA1E39C832BA03761 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA7D7B6157DE10EB7E6F126D8C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA87237D1300BE930184981BB6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAA3B2403FF92C3210786A92EE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAAA6C3E5DBA851C32D14B04FD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAAFCC37D990A55B085258744B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAC4223317172A4B6986977079 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VACE2FD44B696E81F98FAC09AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADF8FCDCF9E250A22ABAE212F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE6E47918C9A698F06ADC90B3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAEE0B8BE6268490874574812F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAFF59783452135DA9FCE14B07 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationObject | referenced by foreign key from table | ATT_RFRL1490: AttestationPolicy.UID_AttestationObject -> AttestationObject.UID_AttestationObject |
| DialogSchedule | referenced by foreign key from table | ATT_RFRL1491: AttestationPolicy.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| PWODecisionMethod | referenced by foreign key from table | ATT_RFRL1492: AttestationPolicy.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| AttestationCase | foreign key references table | ATT_RFRL1497: AttestationCase.UID_AttestationPolicy -> AttestationPolicy.UID_AttestationPolicy |
| AttestationRun | foreign key references table | ATT_RFRL1500: AttestationRun.UID_AttestationPolicy -> AttestationPolicy.UID_AttestationPolicy |
| QBMCulture | referenced by foreign key from table | ATT_RFRL1520: AttestationPolicy.UID_DialogCulture -> QBMCulture.UID_DialogCulture |
| BaseTree | referenced by foreign key from table | ATT_RFRL1600: AttestationPolicy.UID_AERoleOwner -> BaseTree.UID_Org |
| HelperAttestationPolicy | foreign key references table | ATT_RFRL1624: HelperAttestationPolicy.UID_AttestationPolicy -> AttestationPolicy.UID_AttestationPolicy |
| QERTermsOfUse | referenced by foreign key from table | ATT_RFRL1702: AttestationPolicy.UID_QERTermsOfUse -> QERTermsOfUse.UID_QERTermsOfUse |
| QERPickCategory | referenced by foreign key from table | ATT_RFRL310: AttestationPolicy.UID_QERPickCategory -> QERPickCategory.UID_QERPickCategory |
| AttestationPolicyInArea | foreign key references table | ATT_RFRL4104: AttestationPolicyInArea.UID_AttestationPolicy -> AttestationPolicy.UID_AttestationPolicy |
| AttestationPolicyHasApprover | foreign key references table | ATT_RFRL4155: AttestationPolicyHasApprover.UID_AttestationPolicy -> AttestationPolicy.UID_AttestationPolicy |
| AttestationPolicyHasMControl | foreign key references table | ATT_RFRL4208: AttestationPolicyHasMControl.UID_AttestationPolicy -> AttestationPolicy.UID_AttestationPolicy |
| Person | referenced by foreign key from table | ATT_RFRL4212: AttestationPolicy.UID_PersonOwner -> Person.UID_Person |
| dbo.ATT_FGIReasonTypeForAttCase | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ATT_PAfterMigrationTasks | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.ATT_PAttestationCaseCreate | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_PAttestationCaseDeleteOld | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| 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_PHelperAttestationPolicy | source text reference | uses session context values, 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_ZAttestationReset | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZHelperAttestationPolicy | source text reference | has TRY/CATCH error handling |
| dbo.ATT_ZScheduleStart | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.ATT_TUAttestationPolicy | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-att-compositionapi-server-plugin-att-compositionapi-api-att-case-workflow.cs | decompiled C# reference | classes ATT_Case_Workflow, _003C_003Ec__DisplayClass0_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, _003CBuild_003Eb__2, _003CBuild_003Eb__3, _003CBuild_003Eb__4; references AttestationCase, AttestationPolicy, Delegation, ESet, Person; markers reads entity values, saves entities, references DB/Dialog objects, IT Shop related markers |
| 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-compositionapi-server-plugin-att-compositionapi-api-att-policy-start.cs | decompiled C# reference | classes ATT_Policy_Start, PolicyStartInput, _003C_003Ec__DisplayClass0_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, Build; references AttestationPolicy; markers references DB/Dialog objects |
| cs-att-compositionapi-server-plugin-att-compositionapi-attestation-claimdeviceownershipapi.cs | decompiled C# reference | classes ClaimDeviceOwnershipApi; methods MoveNext, SetStateMachine, Build, CreateAsync; references AttestationPolicy, DialogColumn, DialogParameter, DialogParameterSet, Hardware, Person; markers reads entity values, writes 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-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-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 |
| cs-tsb-compositionapi-tsb-compositionapi-attestation-claimownerattestation.cs | decompiled C# reference | classes ClaimOwnerAttestation; methods MoveNext, SetStateMachine, CreateAsync; references AttestationPolicy, DialogColumn, DialogParameter, DialogParameterSet, Person; markers reads entity values, writes entity values, references DB/Dialog objects |