08-15-2013 12:37 PM
IP_FLWSHT_REC is the main table to link encounters to flowsheets. If you are starting at the patient encounter level, PAT_ENC.INPATIENT_DATA_ID (or PAT_ENC_HSP.INPATIENT_DATA_ID) links to IP_FLWSHT_REC.INPATIENT_DATA_ID. IP_FLWSHT_MEAS has the measurements that were entered into the flowsheet and is linked to IP_FLWSHT_REC by FSD_ID. To get the flowsheet template you link IP_FLWSHT_MEAS.FLT_ID to IP_FLT_DATA.TEMPLATE_ID and to get the measurement name link IP_FLWSHT_MEAS.FLO_MEAS_ID to IP_FLO_GP_DATA.FLO_MEAS_ID.
You will need to know the flowsheet template your organization is using for ventilator measurements if you want to limit your results to that specific flowsheet.
08-15-2013 01:02 PM
Thanks for the reply.
I was using IP_LDA_NOADDSINGLE dataset(after filtering for AIRWAYS) which has the placement and removal times for LINES , DRAINS and AIRWAYS.
This dataset has pat_id encounter_id fsd_id and flomeas_id along with the placement and removal times
But there are repeats with the encounter_id with different placement and removals
I am confused on which one to pick from this list..