New Sample_Freq Table (in FI_Data_2)

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 (language term 195)

1 (default) = calendar time (language term 6964)

2 = run time (language term 5839)

3 = production (language term 89)

4 = main item produced changes (language term 7342, job_bom.current_subst for bom_pos = 0)

5 = item consumed at any BOM position changes (language term 7343)

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

7 = the lot number of an item consumed at any BOM position changes (language term 7345)

8 = a job starts (language term 7579)

9 = utilization changes from runtime to downtime (language term 7347)

10 = utilization changes from runtime to idle time (language term 7348)

11 = utilization changes from downtime to runtime (language term 7349)

12 = utilization changes from downtime to idle time (language term 7350)

13 = utilization changes from idle time to runtime (language term 7351)

14 = utilization changes from idle time to downtime (language term 7352)

15 = inventory is received (language term 7353)

16 = a new specification value is downloaded for the job running on a job position (language term 7354)

17 = a step with action_type 6 starts (language term 7355)

18 = a step with action_type 6 finishes (language term 7356)

19 = manual (language term 3461)

20 = a job ends (language term 3908)

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

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).

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).

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 ????

spare2

string80

N

Y

Use defined by language term ????

spare3

string80

N

Y

Use defined by language term ????

spare4

string80

N

Y

Use defined by language term ????

last_edit_comment

string254

N

Y

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 0

Y

N

Unique identifier