dbo.MitigatingControl
Mitigating controls
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_MitigatingControl | varchar(38) | no | Mitigating control | PKUID |
Ident_MitigatingControl | nvarchar(128) | yes | Measures | |
Description | nvarchar(-1) | yes | Description | |
SignificancyReduction | float(8) | yes | Significance reduction | |
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 | |
XObjectKey | varchar(138) | no | Object key | |
UID_FunctionalArea | varchar(38) | yes | Functional area | FKUID |
UID_Department | varchar(38) | yes | Department | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL2552 | AttestationCaseHasMControl.UID_MitigatingControl | MitigatingControl.UID_MitigatingControl |
| ATT_RFRL4209 | AttestationPolicyHasMControl.UID_MitigatingControl | MitigatingControl.UID_MitigatingControl |
| CAP_RFRL1773 | MitigatingControl.UID_Department | BaseTree.UID_Org |
| CAP_RFRL1774 | MitigatingControl.UID_FunctionalArea | FunctionalArea.UID_FunctionalArea |
| CPL_RFRL2551 | ComplianceRuleHasMControl.UID_MitigatingControl | MitigatingControl.UID_MitigatingControl |
| CPL_RFRL2555 | PersonInNCHasMControl.UID_MitigatingControl | MitigatingControl.UID_MitigatingControl |
| POL_RFRL2551 | PolicyObjectHasMControl.UID_MitigatingControl | MitigatingControl.UID_MitigatingControl |
| POL_RFRL4094 | QERPolicyHasMControl.UID_MitigatingControl | MitigatingControl.UID_MitigatingControl |
Triggers
GEN_T119DBEE5CF2E6C8247EB0EE27 SQL_TRIGGER
GEN_T2BD3F5650BA01BD7A8A951792 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_P567FC5B2B8728602D8794705A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P577DFA6CFBEFA124671727F36 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P886EBDC846EA30F027AA1D382 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P97BEC6314D4BB90FE52DF01BE | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationCaseHasMControl | foreign key references table | ATT_RFRL2552: AttestationCaseHasMControl.UID_MitigatingControl -> MitigatingControl.UID_MitigatingControl |
| AttestationPolicyHasMControl | foreign key references table | ATT_RFRL4209: AttestationPolicyHasMControl.UID_MitigatingControl -> MitigatingControl.UID_MitigatingControl |
| BaseTree | referenced by foreign key from table | CAP_RFRL1773: MitigatingControl.UID_Department -> BaseTree.UID_Org |
| FunctionalArea | referenced by foreign key from table | CAP_RFRL1774: MitigatingControl.UID_FunctionalArea -> FunctionalArea.UID_FunctionalArea |
| ComplianceRuleHasMControl | foreign key references table | CPL_RFRL2551: ComplianceRuleHasMControl.UID_MitigatingControl -> MitigatingControl.UID_MitigatingControl |
| PersonInNCHasMControl | foreign key references table | CPL_RFRL2555: PersonInNCHasMControl.UID_MitigatingControl -> MitigatingControl.UID_MitigatingControl |
| PolicyObjectHasMControl | foreign key references table | POL_RFRL2551: PolicyObjectHasMControl.UID_MitigatingControl -> MitigatingControl.UID_MitigatingControl |
| QERPolicyHasMControl | foreign key references table | POL_RFRL4094: QERPolicyHasMControl.UID_MitigatingControl -> MitigatingControl.UID_MitigatingControl |
| 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 |