bug-fix: missing semi-colons in sql query
bug-fix: cenozo language table integration
style: remove doubly declared var
bug-fix: cenozo language table integration
bug-fix: cenozo language integration

- use lib::create to get language record
- minor simplification of sql call
bug-fix: default javascript function param

- older versions of FF cannot process default
  js parameter values in the calling window
bug-fix: default javascript function param

- older versions of FF cannot process default
  js parameter values in the calling window
bug-fix: remove infinite recursion

- remove unnecessary method get_word and thereby also remove infinite recursion
bug-fix: cenozo language integration

- fixing how dictionaries get parsed and imported into cedar
  by incorporating new language table codes
implement dictionary deletion

- allow dictionaries to be deleted if their words are not
  used in any test transcriptions/adjudications
bug-fix: enforce users to have language(s)
revert commit

- reverting last commit: a user with no language restriction
  means they can accept participants with any language preference
perf: speed up report generation

- construct better queries using temp tables outside
  of loop structures
bug-fix: add date restriction to query

- the temp table for assignment completes needs to
  included the date restriction
perf: speeding up productivity report

- try pre-building the test type dependent adjudication comparison
  query as an associative array of test id => string where
  the string can be used in sprintf calls with the progenitor and
  adjudicate test entry id's
bug-fix: use create_timestamp

- use the create_timestamp instead of the start_datetime
  as the point at which the assignment is started
bug-fix: perf improv, change count to sum, start

- perf improvement by switching to get_one() calls
- bug fixes: use activity record datetime when first
  assignment created as an operation, change count
  to sum function for in progress assignment count
bug-fix: final bug fixes
add a TODO that will address one more bug
bug-fix: link cohort id to started counts

- link the assignment and participant tables to the
  activity table to find started assignments by cohort