New Data_Entry_Log Table (in FI_Large)

key_id

int32

N

N

Identify data_entry_sched row to which this data entry trigger applies.

key_type

int32

N

N

Identify data_entry_sched row to which this data entry trigger applies.

category

string40

N

N

Identify data_entry_sched row to which this data entry trigger applies.

value_name

string40

N

N

Identify data_entry_sched row to which this data entry trigger applies.

trigger_at

tdatetime

N

N

When was this specific data collection activity triggered.

entries_reqd

int32

N

N

Number of entries required for this data collection activity – copied from data_entry_sched for performance and convenience instead of doing an SQL join.

entries_made

int32

N

N

Number of entries already made for this data collection activity – updated as data is captured.

display_seq

int32

N

Y

Optional display sequence for this data entry requirement to facilitate sorting -copied from data_entry_sched for performance and convenience instead of doing an SQL join. Default = null.

trigger_desc

string40

N

Y

Description for this trigger, e.g., "Shift 2" or "10AM" – copied from data_entry_sched when triggered.

string_spare1

string40

N

Y

Spare string field defaulting to data_entry_sched value when triggered.

string_spare2

string40

N

Y

Spare string field defaulting to data_entry_sched value when triggered.

string_spare3

string40

N

Y

Spare string field defaulting to data_entry_sched value when triggered.

string_spare4

string40

N

Y

Spare string field defaulting to data_entry_sched value when triggered.

number_spare1

tfloat

N

Y

Spare numeric field defaulting to data_entry_sched value when triggered.

number_spare2

tfloat

N

Y

Spare numeric field defaulting to data_entry_sched value when triggered.

number_spare3

tfloat

N

Y

Spare numeric field defaulting to data_entry_sched value when triggered.

number_spare4

tfloat

N

Y

Spare numeric field defaulting to data_entry_sched value 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

Y

N

Unique row identifier, for audit trail