znt_score
Source table from the HIS containing vitals. Every instance is generated with every validation from the nurse in charge.
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.
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).
valors field contains all available vitals in a label:value format at that time point. Examples of labels:
'CONC_STATE', 'HR_ECG', 'RR_IP', 'PA_S', 'PULSIOX', 'TEMP_AXI', 'O2_SUPPORT', 'PRESN', 'SBP', ‘TEMP_AXI’, ‘TEMP_TIM’ OR TEMP_BU’ , ‘TEMP_CT’
| item | description |
|---|---|
| mandt | |
| id_score | This is the name of the score that is calculated on vwert field, currently we are only using NEWS_2. |
| data | is the date when the score was determined in the HIS |
| hora | is the time when the score was determined in the HIS |
| patnr | patient record number |
| id | random number assigned to every patient to anonimize patnr |
| usuari | 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 score that has been determined at that moment if there's parameters enough to calculate it. |
| pop_up | is that in case that it has been registered manually |
| 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). |
| valors | field of monitor outputs: 'label': value |
| 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. |
