Difference between revisions of "Offsetable"

From SICDB Doc
Jump to navigation Jump to search
Line 1: Line 1:
An offsetable field can be filtered for a specific period of time, where 0 is the first second of ICU stay.
An offsetable field can be filtered for a specific period of time, where 0 is the first second of admission.


== Offset Types ==
== Offset Types ==

Revision as of 08:15, 18 September 2023

An offsetable field can be filtered for a specific period of time, where 0 is the first second of admission.

Offset Types

  • After Admission
  • After (>=)
  • Before (<)
  • Between (>= X and < Y)

Offset Value

The offset value can be one of the following:

  • A number (time in seconds from ICU admission)
  • A number and a time identifier, like "d" (days) or "h" (hours)
    • "3d" will be the first second of the third day
  • A field identifier, an "f" followed by field index
    • f2 will be the third field of query
    • (this is used to define a timespan after a offset, like last laboratory before first erythrozyte application)