r_monitor_parsed - theonesp/p_zero-code GitHub Wiki

r_monitor_parsed

Purpose: r_monitor_parsed creates a view which is a derived version of r_monitor where every vital sign within the column value is now an unique column.
Links to: r_monitor

Important considerations

  • Only the following vitals were found on r_monitor, therefore these are the only vitals being parsed: ESTADO_CONCIENC_,FC_EKG,FC_OSC,FR_IP,FREC_RESP,O_DIS_,PA_S,PRESN_SIS,PULSIOX,PULSO,TEMP_AXI

Table columns

Name Datatype Null Option Comment Is Key Stored Transformed Created
mandt INTEGER
id_score VARCHAR
data DATE
hora VARCHAR
patnr INTEGER
id INTEGER
usuari VARCHAR
vpid INTEGER
vwert INTEGER
pop_up VARCHAR
envio_medxat_med VARCHAR
envio_medxat_enf VARCHAR
envio_email VARCHAR
conc_state INTEGER
hr_ecg INTEGER
hr_osc INTEGER
rr_ip INTEGER
rr INTEGER
o2_sup INTEGER
pa_s INTEGER
presn INTEGER
pulsiox INTEGER
pulse INTEGER
temp_axi NUMERIC(4,1)
aillat VARCHAR
⚠️ **GitHub.com Fallback** ⚠️