New QM_Context_Link Table (in FI_Data)

context_ id

int32

N

N

Reference to qm_context.context_id

freq_id

int32

N

N

Identify the sample plan frequency

bom_pos

int32

N

Y

Identify the BOM position if freq_type is 4 through 7, to allow next two fields to be tracked for each position

last_used_lot_no

string40

N

Y

Used when freq type is 6 or 7; the last lot number (not sublot number) produced or consumed for this BOM position.

last_used_item_id

string40

N

Y

Used when freq type is 4 or 5; the last item produced or consumed for this BOM position.

last_production_count

tfloat

N

Y

Used when freq_type = 3 and interval_unit = 5; the production amount as of the last sample, or null if there was no production at all so far for the entity (if context is entity only) or job

production_count

tfloat

N

Y

Used when freq_type = 3 and interval_unit = 5; the most recent production amount for the entity or job (needed because production is reported incrementally)

last_utilization
_sampled_at

tdatetime

N

Y

Used when freq_type = 2; when the last sample was generated, or null if there was no sample yet for this context. If null, runtime is accumulated for the entity from the beginning (if context is entity only) or from the start of the job.

job_count

int32

N

Y

Used when freq_type = 3 and interval_unit = 7; number of distinct jobs started since the last sample

lot count

int32

N

Y

Used when freq_type = 3 and interval_unit = 6; number of distinct lots for which production was reported since the last sample

segment response count

int32

N

Y

Used when freq_type = 3 and interval_unit = 8; number of distinct segment responses for which production was reported since the last sample

cur_sample_id

int32

N

Y

ID of the last sample record readied for this context

spare1

string1000

N

Y

Use defined by language term ????

spare2

string1000

N

Y

Use defined by language term ????

spare3

string1000

N

Y

Use defined by language term ????

spare4

string1000

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

row_id

ID 0

Y

N

Unique row identifier