dbo.JobParameter
Parameter templates
TableType TUsage CONFIGURATIONRows 1384SizeMB 1.144
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_JobParameter | varchar(38) | no | Parameter template | PKUID |
UID_JobTask | varchar(38) | no | Process task | FKUID |
Name | nvarchar(510) | no | Name | |
ValueTemplateDefault | nvarchar(2046) | yes | Value template | |
Type | nvarchar(64) | yes | Type | limited |
IsOptional | bit(1) | yes | Optional | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
IsCrypted | bit(1) | yes | Encrypted | |
IsHidden | bit(1) | yes | Hidden | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
Description | nvarchar(510) | yes | Description | |
ValueTemplateExample | nvarchar(-1) | yes | Value template (example) | |
IsPartialCrypted | bit(1) | yes | Contains encrypted components | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsCompressed | bit(1) | yes | Compressed |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL137 | JobParameter.UID_JobTask | JobTask.UID_JobTask |
| QBM_RFRL63 | JobRunParameter.UID_JobParameter | JobParameter.UID_JobParameter |
Triggers
GEN_T2FB431061F02843602ED1F7B3 SQL_TRIGGER
QBM_TUJobParameter 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_FTJobCreateDBParameter | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · UID_JobTask · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · Name · OBJECT_OR_COLUMN |
| dbo.QBM_FCVJobParamOptions | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FCVListToJobParameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUJobParameter | SQL expression dependency | OBJECT_OR_COLUMN |
| JobTask | referenced by foreign key from table | QBM_RFRL137: JobParameter.UID_JobTask -> JobTask.UID_JobTask |
| JobRunParameter | foreign key references table | QBM_RFRL63: JobRunParameter.UID_JobParameter -> JobParameter.UID_JobParameter |
| dbo.QBM_FTJobCreateDBParameter | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QBM_FCVJobParamOptions | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FCVListToJobParameter | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_TUJobParameter | source text reference | uses session context values, has TRY/CATCH error handling |
| cs-ads-forms-ads-forms-formadsaccountmasterdata.cs | decompiled C# reference | classes FormADSAccountMasterData; methods OnInit, _ActivateForm, _AdaptTasks, FormTask_MoveToDomain, FormTask_MoveContainer, FormTask_Unlock; references ADSAccount, ADSAccountInADSGroup, ADSContainer, ADSDomain, ADSGroup, Delegation; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-jobqueueinfo-vi-tools-jobqueueinfo-dcjobchains.cs | decompiled C# reference | classes DCJobChains; methods ToolTipError_Popup, RefreshData, OnHandleDestroyed, _LoadFormSettings, _SaveFormSettings, _ClearTree; references ESet, JobChain, JobParameter, JobQueue, JobTreeParamColl; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-db-compile-vi-db-compile-dialogjobgenassemblybuilder.cs | decompiled C# reference | classes DialogJobGenAssemblyBuilder, _ValueReplacer, _003C_003Ec__DisplayClass21_0, _003C_003Ec__DisplayClass23_0; methods Replace, _ReplaceMatch, _003C_GenerateEventsAsync_003Eb__0, _003C_GenerateJobAsync_003Eb__0, MoveNext, SetStateMachine; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-db-compile-vi-db-compile-sourcegenerators-jobssourcegenerator.cs | decompiled C# reference | classes JobsSourceGenerator, JobsAssemblyGenerator, _PreloadTable, _ValueReplacer; methods _003C_ReplaceMatchAsync_003Eb__0, MoveNext, SetStateMachine, _CreateRegPattern, _CreateRegVersion, ReplaceAsync; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |