Skip to content

Mapping rules

Mapping rules transform a single value into a single value.

arithmetic

  • HighInt — Maps a floating point value to an integer by rounding the value up.

array

  • At — Returns the element of an ARRAY at the given 0-based index as a scalar.
  • InsertAt — Inserts a scalar value at the given 0-based index of an ARRAY, returning a new ARRAY.
  • Remove — Drops every element of an ARRAY equal to the given scalar value.
  • RemoveAt — Removes the element at the given 0-based index from an ARRAY.
  • ReplaceAt — Replaces the element at the given 0-based index of an ARRAY with a new value.

assertion

  • Assert — Fails the record unless the input matches a value or one entry of an array of values.
  • AssertNot — Fails the record when the input matches a value or one entry of an array of values.
  • AssertVocabDomain — Fails the record unless the input concept id belongs to a named OMOP vocabulary domain.

cdm-helpers

  • GetCDMTableId — Looks up a value in a CDM table by key and replaces the input with the matching value.
  • SaveToVirtualField — Stores a single source value into a named virtual field on a CDM table.

date

  • DayFromDate — Returns the day of the month from a date input.
  • HourFromDate — Returns the hour of the day from a date input.
  • MinuteFromDate — Returns the minute of the hour from a date input.
  • MonthFromDate — Returns the month of the year from a date input.
  • SecondFromDate — Returns the second of the minute from a date input.
  • YearFromDate — Returns the year from a date input.

logical

  • Not — Reverses the value of a boolean.

mapping-table

  • CSVMap — Maps the input string to a value looked up in an external CSV file by source-column key.
  • Map — Maps the input using a static key/value table embedded in the rule's parameters.
  • ValueMap — Resolves a vocabulary value code to its standard concept ids using the OMOP CDM vocabulary tables.

string

  • InsertStringAt — Inserts a static string at a given position in a string input.
  • PostPad — Pads a string at the end with a given character until it reaches the requested size.
  • PrePad — Pads a string at the beginning with a given character until it reaches the requested size.
  • Regex — Selects from the input the substring matching a regular expression.
  • Split — Splits a STRING into an ARRAY of pieces on a delimiter.
  • SubString — Returns a substring of the input string.
  • Trim — Removes whitespace from both ends of a string.
  • Truncate — Truncates a string to at most the given number of characters.

type-conversion

  • AsDate — Transforms any type of input into a date.
  • AsFloat — Transforms any type of input into a floating point value.
  • AsInt — Transforms any type of input into an integer.
  • AsString — Transforms any type of input into a string.

vocabulary

  • UsagiMap — Maps the input to a concept id using a Usagi map file.
  • VocabMap — Maps a vocabulary code to a standard concept id using the OMOP CDM vocabulary.
  • VocabSourceId — Maps a vocabulary code to a source concept id using the OMOP CDM vocabulary.