EPIC reporting

[robertrao]

Hi,

I want to report on the flowsheets and particularly on the placement and removal times of ventilator

How can i acheive that in EPIC??

Thanks

[BrianPratt]

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.

[robertrao]

Hi.

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..

Thanks