data_entry_log
- Last UpdatedNov 20, 2024
- 2 minute read
This table allows for the driving of and compliance to data collection schedules to be monitored. Database or other triggers insert rows into this table with default data when a trigger is detected. The values can then be updated and the entries_made field compared to the entries_reqd to detect non-compliance.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
key_id |
int32 |
N |
N |
Primary key for the data_entry_sched row to which this data entry trigger applies |
|
key_type |
int32 |
N |
N |
Enumeration of the basis for the data_entry_sched row to which this data entry trigger applies; same as data_entry_sched.key_type. |
|
category |
string40 |
N |
N |
Category of the data_entry_sched row to which this data entry trigger applies |
|
value_name |
string40 |
N |
N |
Data value of the data_entry_sched row to which this data entry trigger applies |
|
trigger_at_utc |
tdatetime |
N |
N |
When this specific data collection activity was triggered in UTC |
|
trigger_at_local |
tdatetime |
N |
N |
When this specific data collection activity was triggered in local time |
|
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 |
|
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 |
notes |
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 |
|
row_id |
ID 1 |
Y |
N |
Unique row identifier, for audit trail |