dbo.DialogSchedule
Schedules
TableType TUsage CONFIGURATIONRows 62SizeMB 0.088
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogSchedule | varchar(38) | no | Schedule | PKUID |
UID_DialogTableBelongsTo | varchar(38) | yes | Table | FKUID |
Name | nvarchar(510) | no | Name | |
Enabled | bit(1) | yes | Enabled | |
StartDate | datetime(8) | yes | Start (date) | |
EndDate | datetime(8) | yes | End (date) | |
Frequency | int(4) | yes | Interval | |
FrequencyType | nvarchar(10) | yes | Frequency | limited |
StartTime | varchar(256) | yes | Start time | |
NextRun | datetime(8) | yes | Next scheduled run | |
LastRun | datetime(8) | yes | Last scheduled run | |
Description | nvarchar(2048) | 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 | |
XObjectKey | varchar(138) | no | Object key | |
FrequencySubType | nvarchar(512) | yes | on | |
UID_DialogTimeZone | varchar(38) | no | Time zone | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1401 | AttestationPolicyGroup.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
| ATT_RFRL1491 | AttestationPolicy.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
| CPL_RFRL1477 | ComplianceRule.UID_DialogScheduleFill | DialogSchedule.UID_DialogSchedule |
| CPL_RFRL1478 | ComplianceRule.UID_DialogScheduleCheck | DialogSchedule.UID_DialogSchedule |
| QBM_RFRL281 | JobAutoStart.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
| QBM_RFRL282 | DialogDashBoardDef.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
| QBM_RFRL316 | DialogSchedule.UID_DialogTimeZone | DialogTimeZone.UID_DialogTimeZone |
| QBM_RFRL370 | DialogSchedule.UID_DialogTableBelongsTo | DialogTable.UID_DialogTable |
| QER_RFRL1476 | DynamicGroup.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
Triggers
GEN_T29CA83DB296B970C8F8DAB362 SQL_TRIGGER
GEN_T31FDEB2B4FF4B55C745CFF502 SQL_TRIGGER
GEN_T53A648A1D7DE3DEE795E22D42 SQL_TRIGGER
QBM_TIDialogSchedule SQL_TRIGGER
QBM_TUDialogSchedule 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.QBM_PScheduleCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PScheduleStartJob | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T118440E480BB0D4C8AB7B594F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T163BACAD4C56A752C4FAF6CA6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T18982FEA1E48BBC7BBED1F2AE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25894CE85FB7F76D27F9EBFB0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2B04BF891DA7C6BFCE8EED64F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C70041B2DC77CE85F47E49FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T53A648A1D7DE3DEE795E22D42 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIDialogSchedule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogSchedule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUJobAutoStart | SQL expression dependency | OBJECT_OR_COLUMN |
| AttestationPolicyGroup | foreign key references table | ATT_RFRL1401: AttestationPolicyGroup.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| AttestationPolicy | foreign key references table | ATT_RFRL1491: AttestationPolicy.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| ComplianceRule | foreign key references table | CPL_RFRL1477: ComplianceRule.UID_DialogScheduleFill -> DialogSchedule.UID_DialogSchedule |
| ComplianceRule | foreign key references table | CPL_RFRL1478: ComplianceRule.UID_DialogScheduleCheck -> DialogSchedule.UID_DialogSchedule |
| JobAutoStart | foreign key references table | QBM_RFRL281: JobAutoStart.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| DialogDashBoardDef | foreign key references table | QBM_RFRL282: DialogDashBoardDef.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| DialogTimeZone | referenced by foreign key from table | QBM_RFRL316: DialogSchedule.UID_DialogTimeZone -> DialogTimeZone.UID_DialogTimeZone |
| DialogTable | referenced by foreign key from table | QBM_RFRL370: DialogSchedule.UID_DialogTableBelongsTo -> DialogTable.UID_DialogTable |
| DynamicGroup | foreign key references table | QER_RFRL1476: DynamicGroup.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| dbo.QBM_PScheduleCheck | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PScheduleStartJob | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TIDialogSchedule | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUDialogSchedule | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUJobAutoStart | source text reference | uses session context values, has TRY/CATCH error handling |
| 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-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-common-customizer-vi-common-customizer-dialogschedule.cs | decompiled C# reference | classes DialogSchedule; methods _CheckFrequency, _GetFrequencyType; references DialogSchedule; 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-cpl-forms-cpl-forms-formcompliancerulemasterdata.cs | decompiled C# reference | classes FormComplianceRuleMasterData; methods OnInit, InitializeComponent, OnFormLoad, Task_RecalculateRule, Task_RecalculatePerson, Task_RecalculateAll; references AERole, ComplianceGroup, ComplianceRule, Department, DialogRichMail, DialogSchedule; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |
| cs-designer-editors-designer-collectioneditor-dialogdashboarddefeditor.cs | decompiled C# reference | classes DialogDashBoardDefEditor; methods OnDisposeOrPrepareForCaching, InitializeComponent, ControllerDocumentChanged, ControllerDocumentSaving, Activator_Changed, _InitializeComponent; references DialogDashboardDef, DialogSchedule; markers writes entity values, references DB/Dialog objects |
| cs-designer-editors-designer-collectioneditor-dialogscheduleeditor.cs | decompiled C# reference | classes DialogScheduleEditor; methods OnDisposeOrPrepareForCaching, InitializeComponent, SaveEditorObject, ControllerDocumentSaving, ControllerDocumentChanged, ControllerDocumentSaved; references DialogDashboardDef, DialogSchedule; markers references DB/Dialog objects |
| cs-dpr-customizer-dpr-customizer-dprprojectionstartinfo.cs | decompiled C# reference | classes DPRProjectionStartInfo, _003C_003Ec__DisplayClass0_0; methods _003COnSavingAsync_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync; references DialogSchedule, DPRProjectionStartInfo, JobAutoStart; markers reads entity values, references DB/Dialog objects |
| cs-pol-forms-pol-forms-formqerpolicymasterdata.cs | decompiled C# reference | classes FormQERPolicyMasterData; methods OnInit, InitializeComponent, OnFormSizeChanged, OnFormLoad, OnFormUnload, _DisconnectUIEngineUserSettings; references AERole, DialogDashboardDef, DialogReport, DialogRichMail, DialogSchedule, DialogTable; markers reads entity values, references DB/Dialog objects |
| cs-qer-forms-qer-forms-formdynamicgroupmasterdata.cs | decompiled C# reference | classes FormDynamicGroupMasterData; methods OnInit, OnDispose, OnDesignChanged, OnResetForm, OnFormSizeChanged, OnFormLoad; references BasetreeAssign, DialogColumn, DialogSchedule, DialogTable, DynamicGroup, DynamicGroupHasImmediateColumn; markers reads entity values, references DB/Dialog objects |
| cs-vi-projector-editor-vi-projector-editor-managestartsequencesdialog.cs | decompiled C# reference | classes ManageStartSequencesDialog; methods OnTranslateDialog, OnSave, OnShown, _SetupLogic, _FilterStartInfos, _Move; references DialogSchedule, DialogTable, DPRProjectionStartInfo, DPRShell, DPRStartSequence, ESet; markers reads entity values, references DB/Dialog objects |