dbo.QERPickCategory
Selections
TableType TUsage USERDATARows 2SizeMB 0.024
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERPickCategory | varchar(38) | no | Selection | PKUID |
IsManual | bit(1) | yes | Manual selected | |
DisplayName | nvarchar(512) | yes | Display name | |
RemoveAfterAttestationRun | bit(1) | yes | Remove elements after attestation run | |
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 |
UID_DialogTable | varchar(38) | yes | Table | FKUID |
IsRandomSample | bit(1) | yes | Random sample | |
RandomSampleWhereClause | nvarchar(-1) | yes | Selection condition | |
RandomSamplePickRate | float(8) | yes | Sample size | |
CreateRandomSampleForEachRun | bit(1) | yes | New random sample for each run |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1400 | AttestationPolicyGroup.UID_QERPickCategory | QERPickCategory.UID_QERPickCategory |
| ATT_RFRL310 | AttestationPolicy.UID_QERPickCategory | QERPickCategory.UID_QERPickCategory |
| QER_RFRL1330 | QERPickCategory.UID_DialogTable | DialogTable.UID_DialogTable |
| QER_RFRL1331 | QERPickedItem.UID_QERPickCategory | QERPickCategory.UID_QERPickCategory |
Triggers
GEN_T206A64212E3EAD0957A0E4D39 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 |
|---|---|---|
| AttestationPolicyGroup | foreign key references table | ATT_RFRL1400: AttestationPolicyGroup.UID_QERPickCategory -> QERPickCategory.UID_QERPickCategory |
| AttestationPolicy | foreign key references table | ATT_RFRL310: AttestationPolicy.UID_QERPickCategory -> QERPickCategory.UID_QERPickCategory |
| DialogTable | referenced by foreign key from table | QER_RFRL1330: QERPickCategory.UID_DialogTable -> DialogTable.UID_DialogTable |
| QERPickedItem | foreign key references table | QER_RFRL1331: QERPickedItem.UID_QERPickCategory -> QERPickCategory.UID_QERPickCategory |
| 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-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-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-qer-customizer-qer-customizer-qerpickcategory.cs | decompiled C# reference | classes QERPickCategory; methods MoveNext, SetStateMachine, _IsAssigned, FillRandomSampleAsync; references AttestationRun, DialogTable, QERPickCategory; markers reads entity values, references DB/Dialog objects |