Data Points
Tableau Data Source Field | Folder | Description |
Adjustable ED Request to Occupied Colors | Custom Calc | IF [Adjustable ED Request to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable ED Request to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable ED Request to Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END |
Adjustable ED Request to Occupied Variance | Custom Calc | (AVG([ED Bed Request To Bed Occupy Time]-[ED Request to Occupied Time]))/[ED Request to Occupied Time] |
Adjustable Request to Occupied Colors | Custom Calc | IF [Adjustable Request to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable Request to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable Request to Occupied Variance] <= 0 THEN "Within Threshold" ELSE "" END |
Adjustable Request to Occupied Variance | Custom Calc | (AVG([Bedrequested To Bedoccupied Time]-[Request to Occupied Time]))/[Request to Occupied Time] |
Adjustable RTM Compliance | Custom Calc | IF [RTM Compliance %]>= [RTM Compliance] THEN "Green" ELSE "Red" END |
Adjustable RTM to Assigned Time Colors | Custom Calc | IF [Adjustable RTM to Assigned Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable RTM to Assigned Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable RTM to Assigned Variance] <=0 THEN "Within Threshold" ELSE "" END |
Adjustable RTM to Assigned Variance | Custom Calc | (AVG([Rtm To Bedassigned Time]-[RTM to Assigned Time]))/[RTM to Assigned Time] |
Adjustable RTM to Occupied Colors | Custom Calc | IF [Adjustable RTM to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable RTM to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable RTM to Occupied Variance] <= 0 THEN "Within Threshold" ELSE "" END |
Adjustable RTM to Occupied Variance | Custom Calc | (AVG([Rtm To Bedoccupied Time]-[RTM to Occupied Time]))/[RTM to Occupied Time] |
Admitting Patient Physician Type Code | System Calc | This field is not intended for customer report building. |
Attending Patient Physician Type Code | System Calc | This field is not intended for customer report building. |
Bed Assigned Timestamp | Root | The date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or Patient Tracking Portal application. |
Bed Assigned Timestamp Enterprise | Root | The enterprise date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or Patient Tracking Portal application. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Bed Clean Timestamp | Root | The date and time that a bed was marked clean. |
Bed Clean Timestamp Enterprise | Root | The enterprise date and time that a bed was marked clean. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Bed Occupied Timestamp | Root | The date and time that the patient began to physically occupy the bed when the placement was completed. |
Bed Occupied Timestamp Enterprise | Root | The enterprise date and time that the patient began to physically occupy the bed when the placement was completed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Bed Request Cancelled Timestamp Enterprise | Root | The date and time that the placement request was cancelled in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Bed Request Timestamp | Root | The date and time the placement request was created. |
Bed Request Timestamp Enterprise | Root | The date and time the placement request was created in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Bed Requested to Bed Assigned Time | Root | The duration from when the patient's bed was requested until the bed was assigned to the patient. Calculation: Bed Assigned Timestamp minus Bed Requested Timestamp |
Bed Requested to Bed Occupied Time | Root | The duration from when the patient's bed was requested until the patient began to physically occupy the bed. Calculation: Bed Occupied Timestamp minus Bed Requested Timestamp |
Completed Placements | Custom Calc | IF [Placement Status]="Completed" THEN 1 ELSE 0 END |
Created Date Enterprise | Root | The enterprise date and time the placement request was created. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Is Activated | Root | If the column displays a value of True, the placement request is activated, and the patient needs a bed now. |
Lastmoddate | Root | The date of the most recent update to the patient record in local time zone. |
Lastmoddate Enterprise | Root | The date of the most recent updated to the patient record in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Lastmoddate UTC | Root | The date of the most recent updated to the patient record in UTC. |
Latest Lastmoddate Enterprise | Root | The date of the latest patient record in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Occupied Timer | Root | The time from when the patient is RTM, a bed is assigned, and a clean bed is available to the time the patient physically occupies the bed. |
Origin Campus | Root | The name of a collection of buildings in the enterprise that includes the bed where the patient was located before being moved. |
Origin Unit | Root | The unit that includes the bed where the patient was located before being moved. |
Origin Unit Category | Root | The category to which the origin unit belongs. |
Patient Age Current | Custom Calc | The time in years between the Patient's date of birth and today. Calculation: DATEDIFF('year', [Patient Dob], NOW()). |
Patient Age Initial | Custom Calc | The time in years between the Patient's date of birth and the case created date. Calculation: DATEDIFF('year', [Patient Dob], [Case Created Date]). |
Placement ID | Root | The identified for a home location (bed) that is assigned to a patient in a health system. |
Placement Status | Root | The status of the placement such as, Requested, Assigned, Completed, Cancelled, or Unknown. |
RTM Before Assigned Count | Custom Calc | IF DATEDIFF('minute', [Rtm Timestamp],[Bed Assigned Timestamp])>0 THEN 1 ELSE 0 END |
RTM Compliance % | Custom Calc | sum( IF [Placement Status]="Completed" THEN[RTM before assigned count] END)/SUM([Completed Placements]) |
RTM Timestamp | Root | The date and time that the patient was marked Ready to Move (RTM). |
RTM Timestamp Enterprise | Root | The date and time that the patient was marked Ready to Move (RTM) in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
RTM to Bed Assigned Time | Root | The duration from when the patient was marked Ready to Move (RTM) until a bed was allocated to the patient. Calculation: Bed Assigned Timestamp minus RTM Timestamp |
RTM to Bed Occupied Time | Root | The duration from when the patient was marked Ready to Move (RTM) until the patient began to physically occupy the bed. Calculation: Bed Occupied Timestamp minus RTM Timestamp |
Tenant ID | Root | Tenant GUID - Non-Strict Dynamic Partition Column. |
Time Format ED Request to Occupied | Custom Calc | IIF(int(AVG([ED Bed Request To Bed Occupy Time]*60)) % 60 == 60,0,AVG([ED Bed Request To Bed Occupy Time]*60) % 60)// seconds + INT(AVG([ED Bed Request To Bed Occupy Time]*60)/60) * 100 //minutes |
Time Format Request to Assigned | Custom Calc | IIF(int(AVG([Bedrequested To Bedassigned Time]*60)) % 60 == 60,0,AVG([Bedrequested To Bedassigned Time]*60) % 60)// seconds + INT(AVG([Bedrequested To Bedassigned Time]*60)/60) * 100 //minutes |
Time Format Requested to Occupied | Custom Calc | IIF(int(AVG([Bedrequested To Bedoccupied Time]*60)) % 60 == 60,0,AVG([Bedrequested To Bedoccupied Time]*60) % 60)// seconds + INT(AVG([Bedrequested To Bedoccupied Time]*60)/60) * 100 //minutes |
Time Format RTM to Assigned | Custom Calc | IIF(int(AVG([Rtm To Bedassigned Time]*60)) % 60 == 60,0,AVG([Rtm To Bedassigned Time]*60) % 60)// seconds + INT(AVG([Rtm To Bedassigned Time]*60)/60) * 100 //minutes |
Time Format RTM to Occupied | Custom Calc | IIF(int(AVG([Rtm To Bedoccupied Time]*60)) % 60 == 60,0,AVG([Rtm To Bedoccupied Time]*60) % 60)// seconds + INT(AVG([Rtm To Bedoccupied Time]*60)/60) * 100 //minutes |
Unit Targeted Timestamp Enterprise | Root | The first date and time that the Targeted Unit was selected for the patient in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |