Created Variables

Created_Variables_Table is a table in Centralized_data_front_end.mdb which is populated by the query Created_Variables in the same .mdb when the button "calc created variables" on the front screen of the app is pressed. It is used by the statistician for reporting and data extracts.

List of values

• Age in years - see details in Date of Birth
• Length of Stay in days - see details in LOS
• Transfer Delay in days
• APACHE - see details in APACHE Scoring table
  • Total APACHE SCORE
  • Mean Blood Pressure
  • Glasgow Coma Scale - (Glasgow Coma Scale)
  • Acute Physiological points
  • Age points
  • Chronic Health points

Testing...

Julie/Trish, let's track testing information for created_variables here... Template:Discussion

Transfer Delay

• As per Julie: Transfer delay should not occur to those who move to another ICU. Transfer_Delay must be blanks instead of large negative values – see Created_variable table below.
  • Tina: Is that a part of the definition of Transfer Delay? I had never heard of it and it’s not in Transfer_Delay . So generally, is it the following?

Transfer delay = 
iif(location = <an ICU>, 
iif(discharge_to <> <other ICU>, 
dischargedttm – transferdttm, 
0), 
dischargedttm – transferdttm,)

• Julie: Transfer delay is derived from transfer ready date_time and discharge date_time. For CC, only transfer to HSC IICU requires transfer ready date_time (or delays) , other ICUs (MICU,SICU,CCU) don’t require it Transfer_Ready_date_and_time

Background

The system replaces Created Variables in TMSX or Med TMS that were created by TMSX and MedTMS.