dbo.ComplianceArea
Compliance frameworks
TableType TUsage USERDATARows 1SizeMB 0.04
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ComplianceArea | varchar(38) | no | Compliance framework | PKUID |
Ident_ComplianceArea | nvarchar(128) | yes | Compliance framework | |
Description | nvarchar(1024) | yes | Description | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
UID_OrgResponsible | varchar(38) | yes | Manager/ supervisor | FKUID |
XObjectKey | varchar(138) | no | Object key | |
UID_ComplianceAreaParent | varchar(38) | yes | Parent framework | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL4103 | AttestationPolicyInArea.UID_ComplianceArea | ComplianceArea.UID_ComplianceArea |
| CAP_RFRL1365 | ComplianceArea.UID_OrgResponsible | BaseTree.UID_Org |
| CPL_RFRL1360 | ComplianceRuleInArea.UID_ComplianceArea | ComplianceArea.UID_ComplianceArea |
| POL_RFRL4106 | QERPolicyInArea.UID_ComplianceArea | ComplianceArea.UID_ComplianceArea |
Triggers
GEN_T1AE0ECC295A04B8E5C5755F60 SQL_TRIGGER
GEN_T2F5F4F72FE64A1D311E750EE5 SQL_TRIGGER
GEN_T308F8A70AF285FDDFFCA571F9 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_T1AE0ECC295A04B8E5C5755F60 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2F5F4F72FE64A1D311E750EE5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T308F8A70AF285FDDFFCA571F9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_V151F26102FE56BACA2DC542DA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA1D2C7FA260E5E16154DD6176 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA23A3658D1BD06E8FA265F5D1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA661CC924758A1D4472C45800 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA6F1C1F9B5A37B3500E0E2BA6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA792E31854390DE4C49CD173A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAA96E976C3DD08405CB1052F2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE6E47918C9A698F06ADC90B3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAF7A642B92055F69CBEC4A06A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationPolicyInArea | foreign key references table | ATT_RFRL4103: AttestationPolicyInArea.UID_ComplianceArea -> ComplianceArea.UID_ComplianceArea |
| BaseTree | referenced by foreign key from table | CAP_RFRL1365: ComplianceArea.UID_OrgResponsible -> BaseTree.UID_Org |
| ComplianceRuleInArea | foreign key references table | CPL_RFRL1360: ComplianceRuleInArea.UID_ComplianceArea -> ComplianceArea.UID_ComplianceArea |
| QERPolicyInArea | foreign key references table | POL_RFRL4106: QERPolicyInArea.UID_ComplianceArea -> ComplianceArea.UID_ComplianceArea |
| 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-cpl-customizer-cpl-customizer-compliancerule.cs | decompiled C# reference | classes ComplianceRule; methods MoveNext, SetStateMachine, OnSavingAsync, OnWorkingCopySaving, OnRelationObjectSaving, OnWorkingCopySaved; references AERole, ComplianceArea, ComplianceRule, ComplianceRuleHasMControl, ComplianceRuleInArea, ComplianceSubRule; markers reads entity values, 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-qer-forms-qer-forms-formitshopdecideorder.cs | decompiled C# reference | classes FormITShopDecideOrder; methods OnInit, Proxy_NodeDoubleClick, OnDesignChanged, OnResetForm, _LoadComplianceExceptions, InitializeComponent; references AccProduct, ComplianceArea, ComplianceRule, Delegation, ESet, HelperPWOCompliance; markers reads entity values, references DB/Dialog objects, IT Shop related markers |