job_sched_exec
- Last UpdatedNov 13, 2024
- 2 minute read
The job_sched_exec table defines the characteristics of a job schedule executor, which is an extended set of parameters that may be defined for any physical entity that is capable of having jobs scheduled to it.
A single job schedule executor may be defined for each entity.
The oper_type field allows a job being imported from ERP to be scheduled to a lower-level entity than the ERP system "knows about", provided the ERP system also provides an operation type, and this is enough to direct the job to one or another of the target entity’s children.
The queue_time is the amount of time to be allowed for in the schedule for the job to "sit on the floor" in front of the workstation, prior to it being run. This can be used as a buffer against schedule fluctuations, but in the absence of any other time standards it may be applied as the processing time for an arbitrary amount of product, such as might occur with a third-party, off-site operation. (It is the same as folder27’s queue_time field except it is expressed purely in hours.)
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
Y |
N |
Linked to one entity only |
|
oper_type |
string80 |
N |
Y |
Defines operation type for ERP I/F |
|
queue_time |
float |
N |
Y |
Required queue time in hours |
|
sort_order |
string1700 |
N |
Y |
Default sort order for this entity’s jobs |
|
filtr |
string1700 |
N |
Y |
Default filter for this entity’s jobs |
|
spare1 |
string1000 |
N |
Y |
Use defined by language term 5205 |
|
spare2 |
string1000 |
N |
Y |
Use defined by language term 5206 |
|
spare3 |
string1000 |
N |
Y |
Use defined by language term 5207 |
|
spare4 |
string1000 |
N |
Y |
Use defined by language term 5208 |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
FK from ent_id to ent. (Cascade delete)