dbo.QERPolicyHasObject
Policy violations
TableType TUsage USERDATARows 0SizeMB 0
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERPolicyHasObject | varchar(38) | no | Policy violation | PKUID |
UID_QERJustification | varchar(38) | yes | Standard reason | FKUID |
UID_QERPolicy | varchar(38) | no | Policy | FKUID |
ObjectKey | varchar(138) | no | Object key | |
IsDecisionMade | bit(1) | yes | Checked | |
IsExceptionGranted | bit(1) | yes | Exception is approved | |
DecisionDate | datetime(8) | yes | Approval date | |
DecisionReason | nvarchar(2048) | yes | Reason | |
UID_PersonDecisionMade | varchar(38) | yes | Approver | FKUID |
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 | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| POL_RFRL2552 | PolicyObjectHasMControl.UID_QERPolicyHasObject | QERPolicyHasObject.UID_QERPolicyHasObject |
| POL_RFRL2554 | QERPolicyHasObject.UID_QERJustification | QERJustification.UID_QERJustification |
| POL_RFRL4100 | QERPolicyHasObject.UID_QERPolicy | QERPolicy.UID_QERPolicy |
| POL_RFRL4199 | QERPolicyHasObject.UID_PersonDecisionMade | Person.UID_Person |
Triggers
GEN_T24570F2FCDE69C4F7E3325063 SQL_TRIGGER
GEN_T3D1A39FE940790E334D714733 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_FT40E617EA4EDFD9F440AB5C68 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.POL_ZQERPolicyFill | 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.POL_TUQERPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_V1D795F5A2435E6ABB04D9382F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA05144137CC75195EE9CC5956 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA11366321CEA75E771031299E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA2E0ED91D0879F96F3727E7D5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA2E38DDF8F9E834239740A863 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA375E88ED103649D0CA098616 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA44306C69FC8D1F9A72E6D4F5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA555064109970B76F138A0C56 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA5F314F9F8BD59444C950D626 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA61D81A646DB00B0F52281A2F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA741133B6D5F52810D6603816 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA7A600AADD9D6CE035EB157AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA856109063C249379E9E1B48E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA910E79E87F72B87B48499516 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA9C714D35E8FD0FE81CCFC7CF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAA3CAC39D6D827606AE99DEB5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAAC2B381ADAF76943849ED242 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAAEF9B9AD2514FCADC007752C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB07DE1062B976D3E354EB86D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB29F17856D3C565B3A4B4441 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB72589F6777BD4BBC80B628E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VABCBAD63B34857B419B9AC81C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAC0F569947F9FCC72E6878A59 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAD0104B79CCA87CE8FC972670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAD844D8CC3DE627E8B5475C2B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAD885B68A61142FD57051A8C6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADE134B6A1161D2EC1C20FCE5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE6F07E80140CD4B158B4EE11 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAF173197CFA8EC3694012D168 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAF84934985019225207263F4E | SQL expression dependency | OBJECT_OR_COLUMN |
| PolicyObjectHasMControl | foreign key references table | POL_RFRL2552: PolicyObjectHasMControl.UID_QERPolicyHasObject -> QERPolicyHasObject.UID_QERPolicyHasObject |
| QERJustification | referenced by foreign key from table | POL_RFRL2554: QERPolicyHasObject.UID_QERJustification -> QERJustification.UID_QERJustification |
| QERPolicy | referenced by foreign key from table | POL_RFRL4100: QERPolicyHasObject.UID_QERPolicy -> QERPolicy.UID_QERPolicy |
| Person | referenced by foreign key from table | POL_RFRL4199: QERPolicyHasObject.UID_PersonDecisionMade -> Person.UID_Person |
| dbo.POL_PQERPolicyMakeProc | source text reference | has TRY/CATCH error handling |
| dbo.POL_ZQERPolicyFill | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PPersonDelete_GDPR | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, 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 |
| dbo.POL_TUQERPolicy | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| 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-pol-customizer-pol-customizer-qerpolicyhasobject.cs | decompiled C# reference | classes QERPolicyHasObject, MP; methods MoveNext, SetStateMachine, OnSavingAsync, MakeDecision, IsValidDecisionMaker, Decision_OnSaving; references AERole, Person, PersonInAERole, QERJustification, QERPolicy, QERPolicyHasObject; markers reads entity values, references DB/Dialog objects |