New Data_Entry_Sched Table (in FI_Data_2)

key_id

int32

Y

N

Primary key value of row on which this data collection schedule is based (ent_id if linked to an entity, grp_id if linked to a user group, possibly others in future).

key_type

int32

Y

N

Enumeration of the basis for this data collection:

0=entity

1=user group.

category

string40

Y

N

Category of this data collection group, e.g., "Yield KPIs", "Defect Data", "Datalog Group".

value_name

string40

Y

N

Specific data value or set of values to be collected within this category, e.g., "KPI 123", "Line 3 Defect Data", "Datalog Group ABC".

trigger_type

int32

N

N

Enumeration of what triggers this data collection activity:

0=shift start

1=shift end

2=hourly (future)

3=daily

4=weekly

9=SCC trigger (future).

entries_reqd

int32

N

N

Number of entries required each time this data collection activity is triggered, e.g., 8 per shift. Default = 1.

display_seq

int32

N

Y

Optional display sequence for this data entry requirement to facilitate sorting. Default = null.

last_trigger_at

tdatetime

N

Y

Datetime at which the last trigger occurred for this data entry requirement.

last_trigger_desc

string40

N

Y

Description for last trigger, e.g., "Shift 2" or "Daily", "100 items produced".

string_spare1

string40

N

Y

Spare string field copied to data_entry_log when triggered.

string_spare2

string40

N

Y

Spare string field copied to data_entry_log when triggered.

string_spare3

string40

N

Y

Spare string field copied to data_entry_log when triggered.

string_spare4

string40

N

Y

Spare string field copied to data_entry_log when triggered.

number_spare1

tfloat

N

Y

Spare numeric field copied to data_entry_log when triggered.

number_spare2

tfloat

N

Y

Spare numeric field copied to data_entry_log when triggered.

number_spare3

tfloat

N

Y

Spare numeric field copied to data_entry_log when triggered.

number_spare4

tfloat

N

Y

Spare numeric field copied to data_entry_log when triggered.

last_edit_comment

string254

N

Y

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

row_id

ID 0

N

N

Unique row identifier, for audit trail