dbo.QERJustification
Standard reasons
TableType TUsage USERDATARows 21SizeMB 0.032
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERJustification | varchar(38) | no | Standard reason | PKUID |
Ident_QERJustification | nvarchar(256) | yes | Standard reason | |
Description | nvarchar(2048) | yes | Description | |
RequiresText | bit(1) | yes | Additional text required | |
XDateInserted | datetime(8) | yes | Created on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XDateUpdated | datetime(8) | yes | Modified on | |
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 |
IsDecisionBySystem | bit(1) | yes | Automatic decision | |
JustificationType | int(4) | yes | Usage type | bitmask |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL2555 | AttestationCase.UID_QERJustification | QERJustification.UID_QERJustification |
| ATT_RFRL2556 | AttestationHistory.UID_QERJustification | QERJustification.UID_QERJustification |
| CPL_RFRL2556 | PersonInBaseTree.UID_QERJustification | QERJustification.UID_QERJustification |
| POL_RFRL2554 | QERPolicyHasObject.UID_QERJustification | QERJustification.UID_QERJustification |
| QER_RFRL1140 | PersonWantsOrg.UID_QERJustificationOrder | QERJustification.UID_QERJustification |
| QER_RFRL1141 | ShoppingCartItem.UID_QERJustificationOrder | QERJustification.UID_QERJustification |
| QER_RFRL2575 | PersonWantsOrg.UID_QERJustification | QERJustification.UID_QERJustification |
| QER_RFRL2576 | PWODecisionHistory.UID_QERJustification | QERJustification.UID_QERJustification |
Triggers
GEN_T279FEADA5FB8D0E4DB68B8116 SQL_TRIGGER
GEN_T510A25F7B96929CB32011D39F 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_T510A25F7B96929CB32011D39F | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationCase | foreign key references table | ATT_RFRL2555: AttestationCase.UID_QERJustification -> QERJustification.UID_QERJustification |
| AttestationHistory | foreign key references table | ATT_RFRL2556: AttestationHistory.UID_QERJustification -> QERJustification.UID_QERJustification |
| PersonInBaseTree | foreign key references table | CPL_RFRL2556: PersonInBaseTree.UID_QERJustification -> QERJustification.UID_QERJustification |
| QERPolicyHasObject | foreign key references table | POL_RFRL2554: QERPolicyHasObject.UID_QERJustification -> QERJustification.UID_QERJustification |
| PersonWantsOrg | foreign key references table | QER_RFRL1140: PersonWantsOrg.UID_QERJustificationOrder -> QERJustification.UID_QERJustification |
| ShoppingCartItem | foreign key references table | QER_RFRL1141: ShoppingCartItem.UID_QERJustificationOrder -> QERJustification.UID_QERJustification |
| PersonWantsOrg | foreign key references table | QER_RFRL2575: PersonWantsOrg.UID_QERJustification -> QERJustification.UID_QERJustification |
| PWODecisionHistory | foreign key references table | QER_RFRL2576: PWODecisionHistory.UID_QERJustification -> QERJustification.UID_QERJustification |
| 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-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-cpl-customizer-cpl-customizer-personinnoncompliance.cs | decompiled C# reference | classes PersonInNonCompliance, MP; methods MoveNext, SetStateMachine, OnSavingAsync, _CheckExceptionGranted, GetIsExceptionAllowed, MakeDecision; references ComplianceRule, NonCompliance, Person, PersonInNonCompliance, QERJustification; 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 |
| cs-qer-compositionapi-qer-compositionapi-autoremoval-pwoautoremove.cs | decompiled C# reference | classes PwoAutoRemove; methods MoveNext, SetStateMachine, RunAsync; references Person, PersonWantsOrg, QERJustification; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-compositionapi-qer-compositionapi-history-unsubscribepwoaction.cs | decompiled C# reference | classes UnsubscribePwoAction; methods MoveNext, SetStateMachine, ExecuteAsync, ToSerializableActionAsync, FromAssignmentKeyAsync, FromUidPwoAsync; references Delegation, Person, PersonWantsOrg, QERJustification; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-compositionapi-qer-compositionapi-itshop-accepttermsofuse.cs | decompiled C# reference | classes AcceptTermsOfUse; methods MoveNext, SetStateMachine, AcceptAsync; references Person, PersonWantsOrg, PWODecisionHistory, QERJustification; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| 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 |