notes - theonesp/p_zero-code GitHub Wiki

Reference document to build a dic_items table. dic_items table is a dictionary to read chart_events table.

How a row of r_monitor table is generated:

Whenever any of the clinical records that are used to calculate the NEWS_2 are introduced, the system creates an register with all the variables that are in the system at that moment and tries to calculate the NEWS_2 score, but not always all the data have been completed, for example consciousness may be missing and thus only registers with all parameters contain the actual NEWS_2 score.

  • id_score: This is the name of the score that is calculated on vwert field, currently we are only doing it with the NEWS_2.

  • date/time: is the time when the score was determined in SAP.

  • patnr: medical history number.

  • id: random number assigned to every patient to anonimize patnr

  • user: Is the user who has triggered the NEWS_2 calculation by entering one of the variables. If the user is WSBETTERCARE it means that it has been using a data capture equipment, either an ICU monitor or a mobile device.

  • vpid: If all the required clinical records are present, the parameter NEWS_2 is calculated as a clinical record. In the vpid field is the ID of the created clinical record, which is linked to the VPID of the clinical records table.

  • vwert: is the value of the news_2 that has been determined at that moment if there's parameters enough to calculate it.

  • pop_up, send_medxat_med, send_medxat_enf, send_email: once the news_2 has been determined, different actions that we have parameterized are made, in these fields we indicate the actions that have been carried out, pop-up is that in case that it has been registered manually, a pop-up warning has been shown at the bottom of the screen; envio_medxat_med, that a medxat has been sent to the doctor's pager; envio_medxat_enf, that a medxat has been sent to the nurse's pager; envio_email, that an email has been sent (this option is not currently used).

  • conc_state', 'hr_ecg', 'rr_ip', 'pa_s', 'pulsiox', 'temp_axi', 'o2_support', 'presn', 'sbp'

-TEMP_AXI, TEMP_TIM (tympanic) or TEMP_BU (buccal) or TEMP_CT (cutaneous)...

  • aillat: mark that warns that a single clinic record already has a value too deviated to activate the rapid response equipment. for example a heart rate with a value of 150.
item_id label variable source comments
1 Presión Arterial