sample_freq

freq_name

string40

N

N

Name of sample plan frequency for display

freq_desc

string80

N

Y

Description of sample plan frequency

freq_type

int32

N

N

0 = shift

1 (default) = calendar time

2 = run time

3 = production

4 = main item produced changes (job_bom.current_subst for bom_pos = 0)

5 = item consumed at any BOM position changes

6 = the lot number of the main item produced changes (job_bom.def_lot_no for bom_pos = 0)

7 = the lot number of an item consumed at any BOM position changes

8 = a job starts

9 = utilization changes from runtime to downtime

10 = utilization changes from runtime to idle time

11 = utilization changes from downtime to runtime

12 = utilization changes from downtime to idle time

13 = utilization changes from idle time to runtime

14 = utilization changes from idle time to downtime

15 = inventory is received

16 = a new specification value is downloaded for the job running on a job position

17 = a step with action_type 6 starts

18 = a step with action_type 6 finishes

19 = manual

20 = a job ends

interval

tfloat

N

Y

If freq_type = 0, 1, or 2, the amount of time between samples (integers only).

If freq_type = 3, the amount of production between samples. In either case, the meaning of "amount" is specified in the interval_unit field.

interval_unit

int32

N

Y

0 = seconds

1= minutes

2 = hours

3 = days

4 = weeks

5 = units of product

6 = number of lots

7 = number of jobs

8 = number of segment responses

0 – 4 are used when freq_type = 0, 1, or 2; 5 – 8 when freq_type = 3

prod_reset_option

int32

N

Y

Used only if freq_type = 3. What causes the count of production between samples to be reset.

0 = nothing (no reset ever)

1 = job changes on job_exec (disallowed if interval_unit = 7)

2 = main item produced changes

3 = shift changes on entity

4 = entity utilization changes from runtime or downtime to idle time

start_delay

int32

N

Y

Used only if freq_type = 1, where it means the number of seconds to delay the creation of the first calendar sample when the QM spec first becomes active.

offset_start

int32

N

Y

Used only if freq_type = 0, where it means the offset from the start of the shift, or if freq_type = 1 (if interval_unit = 2,3, or 4, and if 4, that interval is 1), where it means the time between midnight (if interval_unit = 2) or midnight Sunday (if interval_unit = 3 or 4). If freq_type = 1 and offset_start = null then samples are not timed relative to midnight or midnight Sunday.

offset_start_unit

int32

N

Y

1= minutes

2 = hours

offset_end

int32

N

Y

Used only if freq_type = 0, where it means the offset from the end of the shift, or if freq_type = 1, 2, or 3, where it means the amount of time into the future to predict samples. In the latter case null means up to the end of the current shift (even if 0 (no shift) when freq_type = 1).

offset_end_unit

int32

N

Y

1= minutes

2 = hours

samples_per_shift

int32

N

Y

Used only if freq_type = 0. Number of times to ready an event between the offsets from the ends of a shift.

multiplier

int32

N

N

Sample size multiplier. Minimum value = 1 (also the default).

Note: This field is currently not used.

enabled

logical

N

N

Is this sample plan frequency to be used at runtime? Default = 1 (true)

expiry_time

int32

N

Y

The amount of time to wait for a sample to be pulled before changing its status to MISSED. Null = no expiration

expiry_unit

int32

N

Y

The units of expiry_time:

1= minutes

2 = hours

3 = days

warning_time

int32

N

Y

The amount of time to wait for a sample to be pulled before changing its status to READY WARNING; default = 5. Null = no warning

warning_unit

int32

N

N

The units of warning_time:

1= minutes (default)

2 = hours

3 = days

spare1

string80

N

Y

Use defined by language term 6997

spare2

string80

N

Y

Use defined by language term 6998

spare3

string80

N

Y

Use defined by language term 6999

spare4

string80

N

Y

Use defined by language term 7000

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

freq_id

ID 1

Y

N

Unique identifier