Patient Placement - Data

Snowflake Field Name

Tableau Data Source Field

Folder

Definition

N/A

Admit Source

Root

In the Capacity IQ® solution, the means by which the patient was admitted (for example, through the Emergency Room or through consultant referral).

N/A

Admit Type

Root

In the Capacity IQ® PreAdmit application, the purpose for the patient's admission such as, for surgery, for an emergency, or for testing.

N/A

Admitting Physician

Root

The physician who ordered the patient to be admitted to the health system. The name is in Last Name, First Name format.

N/A

Assign Timer

Root

The number of minutes elapsed from when the patient's placement request was activated until the patient was assigned to a bed or the placement is completed (whichever comes first).

N/A

Assigned Building

Root

The physical structure within a facility where medical care is provided and which includes the assigned bed.

N/A

Assigned By User

Root

The name of the user who allocated a bed to the patient. The name appears in Last Name, First Name format.

N/A

Assigned Campus

Root

The name of a collection of buildings in the enterprise that includes the assigned bed.

N/A

Assigned Discipline

Root

The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn that include the assigned bed.

N/A

Assigned Enterprise

Root

The name of a collection of campuses that includes the assigned bed.

N/A

Assigned Facility

Root

The entity that provides medical care to patients which includes the assigned bed.

N/A

Assigned Floor

Root

Identifies the floor containing one or multiple units in the building which includes the assigned bed.

N/A

Assigned Location

Root

The identifier for the bed that is assigned to the patient. Assigned beds are allocated to patients before they occupy them.

N/A

Assigned Room

Root

The identifier for the room which includes the assigned bed.

N/A

Assigned Unit

Root

A group of locations and rooms that are all on one floor of a building and that include the assigned bed.

N/A

Assigned Unit Category

Root

The category to which the assigned unit belongs.

N/A

Attending Physician

Root

The name of the physician who is responsible for the patient's care in the hospital. The name is in Last Name, First Name format

BED_ASSIGNED_TIMESTAMP

Bed Assigned Timestamp

Root

The date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or the Patient Tracking Portal application.

BED_ASSIGNED_TIMESTAMP_ENTERPRISE

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 the Patient Tracking Portal application. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

BED_CLEAN_TIMESTAMP

Bed Clean Timestamp

Root

The date and time that a bed was marked clean.

BED_CLEAN_TIMESTAMP_ENTERPRISE

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

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

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.

BEDREQUEST_CANCELLED_TIMESTAMP

Bed Request Cancelled Timestamp Enterprise

Root

The enterprise date and time that the placement request was cancelled. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

BEDREQUEST_CANCELLED_TIMESTAMP_ENTERPRISE

Bed Request Cancelled Timestamp

Root

The date and time that the placement request was cancelled.

BEDREQUEST_CANCELLED_TIMESTAMP_UTC

Bed Request Cancelled Timestamp UTC

Root

The date and time in UTC that the placement request was cancelled.

BEDREQUEST_TIMESTAMP

Bed Request Timestamp

Root

The date and time the placement request was created.

N/A

Bedrequest Timestamp (copy)

Custom Calc

DATE([Bedrequest Timestamp])

BEDREQUEST_TIMESTAMP_ENTERPRISE

Bed Request Timestamp 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.

N/A

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

N/A

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

N/A

Completed Placements

Custom Calc

IF [Placement Status]="Completed" THEN 1 ELSE 0 END

CREATEDDATE_ENTERPRISE

Created Date Enterprise

Root

Created Date in enterprise time for when the record was entered. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

CREATEDDATE_UTC

Created Date UTC

Root

Created Date in UTC for when the record was entered.

N/A

Date Partition

Root

Non-Strict Dynamic Partition Column.

N/A

Date Selector

Custom Calc

IF [Date Type]='Today' THEN DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) = 0 ELSEIF [Date Type] = 'Yesterday' THEN DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) = 1 ELSEIF [Date Type]='Week' THEN DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) >= 1 AND DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) <= 7 ELSEIF [Date Type]= 'Month' THEN DATEDIFF('month',[Bedrequest Timestamp (copy)],TODAY()) = 1 ELSEIF [Date Type] = ""Custom Date"" THEN [Bedrequest Timestamp (copy)] >= [Universal Start] and [Bedrequest Timestamp (copy)] <= [Universal End] END

N/A

Date Selector (Range)

Custom Calc

IF [Date Range]='Today' THEN DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) = 0 ELSEIF [Date Range] = 'Yesterday' THEN DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) = 1 ELSEIF [Date Range]='Last 7 Days' THEN DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) >= 1 AND DATEDIFF('day',[Bedrequest Timestamp (copy)],TODAY()) <= 7 ELSEIF [Date Range]= 'Last Month' THEN DATEDIFF('month',[Bedrequest Timestamp (copy)],TODAY()) = 1 ELSEIF [Date Range] = "Custom Date" THEN [Bedrequest Timestamp (copy)] >= [Universal Start] and [Bedrequest Timestamp (copy)] <= [Universal End] END

N/A

ED Bed Request To Bed Occupy Time

Custom Calc

IF [Origin Unit Category]="ED" THEN [Bedrequested To Bedoccupied Time] END

N/A

ED Request To Occupied Threshold

Custom Calc

IF [ED Request To Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [ED Request To Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [ED Request To Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END

N/A

ED Request To Occupied Threshold Text

Custom Calc

IF [ED Request To Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [ED Request To Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [ED Request To Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END

N/A

ED Request To Occupied Value

Custom Calc

(AVG([ED Bed Request To Bed Occupy Time])-120)

N/A

ED Request To Occupied Variance

Custom Calc

(AVG([ED Bed Request To Bed Occupy Time]-120))/120

N/A

Help

Custom Calc

"Help".

N/A

Hospital Service

Root

The type of treatment or surgery for the patient (i.e., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line.

N/A

Is Activated

Root

If the column displays a value of True, the placement request is activated, and the patient needs a bed now.

N/A

Is Conflicting

Root

If the column displays a value of True, the placement conflicted with another placement. If the column displays a value of False, the placement did not conflict with another placement.

N/A

Is Ever Admitted

Root

Indicates that the patient was or was not admitted.

N/A

Isolation Flag

Root

If the column displays a value of True, the placement has an Isolation Type selected

LASTMODDATE

Lastmoddate

Root

The date of the most recent update to the patient record in local time zone.

LASTMODDATE_ENTERPRISE

Lastmoddate Enterprise

Root

The date of the most recent update to the patient record in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

LASTMODDATE_UTC

Lastmoddate UTC

Root

The date of the most recent update to the patient record in UTC time zone.

LATEST_LASTMODDATE_ENTERPRISE

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.

N/A

LOD Completed Placements

Custom Calc

{EXCLUDE [Origin Unit] : SUM([Number of Records])}

N/A

LOD Number of Records

Custom Calc

{FIXED : SUM([Number of Records])}

N/A

Occupied Building

Root

The physical structure within a facility where medical care is provided and which includes the occupied bed.

N/A

Occupied Campus

Root

The name of a collection of buildings in the enterprise that includes the occupied bed.

N/A

Occupied Discipline

Root

The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn that include the occupied bed.

N/A

Occupied Enterprise

Root

The name of a collection of campuses that includes the occupied bed.

N/A

Occupied Facility

Root

The entity that provides medical care to patients which includes the occupied bed.

N/A

Occupied Floor

Root

Identifies the floor containing one or multiple units in the building which includes the occupied bed.

N/A

Occupied Location

Root

The identifier for the bed that the patient occupies.

N/A

Occupied Room

Root

The identifier for the room which includes the occupied bed.

N/A

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.

N/A

Occupied Unit

Root

The unit that includes the location which the patient physically occupied when the placement was completed.

N/A

Occupied Unit Category

Root

The category to which the occupied unit belongs.

N/A

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.

N/A

Origin Campus Exclude

Custom Calc

[Origin Campus]

N/A

Origin Discipline

Root

The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn that includes the bed where the patient was located before being moved.

N/A

Origin Enterprise

Root

The name of a collection of campuses that includes the bed where the patient was located before being moved.

N/A

Origin Facility

Root

The entity that provides medical care to patients which includes the bed where the patient was located before being moved.

N/A

Origin Unit

Root

The unit that includes the bed where the patient was located before being moved.

N/A

Origin Unit Category

Root

The category to which the origin unit belongs.

N/A

Parameter Less Than Today

Custom Calc

[Universal End]<=[Today]

N/A

Patient Age

Root

The age of the person receiving medical treatment at the time of the visit.

N/A

Patient Age Current

Custom Calc

The time in years between the Patient's date of birth and today. Calculation: DATEDIFF('year', [Patient Dob], NOW()).

N/A

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

N/A

Patient Category

Root

Name of the category for the patient, such as Adult or Infant.

N/A

Patient Diagnosis

Root

The identity of the nature and cause of the patient's disease or injury.

N/A

Patient DOB

Root

The date of birth of the person receiving medical treatment.

N/A

Patient First Name

Root

The first name of the person receiving medical treatment.

N/A

Patient Gender

Root

The gender of the person receiving medical treatment.

N/A

Patient Last Name

Root

The last name of the person receiving medical treatment.

N/A

Patient MRN

Root

The medical record number for person receiving medical treatment.

N/A

Patient Visit Number

Root

The patient's visit number.

N/A

Placement Activated By User

Root

The user who activated the placement request. ActivatedByUserID in the Capacity IQ® Placement table

N/A

Placement ID

Root

The identifier for a home location (bed) that is assigned to a patient in a health system.

N/A

Placement Request By User

Root

The user who originally placed/created the placement request. RequesterID from the Capacity IQ® Placement table.

N/A

Placement Status

Root

The status of the placement such as, Requested, Assigned, Completed, cancelled, or Unknown.

N/A

Placement Type

Root

This field indicates if the placement was made as a PreAdmit, In House Transfer, or Unknown.

N/A

Request To Assign

Root

Difference from assign timestamp and request timestamp

N/A

Request to Assigned Threshold

Custom Calc

IF [Request to Assigned Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Request to Assigned Variance] > 0 THEN "Approaching Threshold" ELSEif [Request to Assigned Value] <= 0 THEN "Within Threshold" ELSE """ END

N/A

Request to Assigned Value

Custom Calc

(AVG([Bedrequested To Bedassigned Time])-15)

N/A

Request to Assigned Variance

Custom Calc

(AVG([Bedrequested To Bedassigned Time]-15))/15

N/A

Request to Occupied Threshold

Custom Calc

IF [Request to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Request to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Request to Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END

N/A

Request to Occupied Threshold Text

Custom Calc

IF [Request to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Request to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Request to Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END

N/A

Request to Occupied Value

Custom Calc

(AVG([Bedrequested To Bedoccupied Time])-120)

N/A

Request to Occupied Variance

Custom Calc

(AVG([Bedrequested To Bedoccupied Time]-120))/120

N/A

Requested Level Of Care

Root

The degree of care that is requested for the patient.

N/A

RTM Before Assigned Count

Custom Calc

IF DATEDIFF('minute', [Rtm Timestamp],[Bed Assigned Timestamp])>0 THEN 1 ELSE 0 END

N/A

RTM By User

Root

The name of the user, in first name last name format, who set the placement to Ready to Move (RTM).

N/A

RTM Compliance %

Custom Calc

sum( IF [Placement Status]="Completed" THEN[RTM before assigned count] END)/SUM([Completed Placements])

N/A

RTM Compliance Threshold

Custom Calc

IF [RTM Compliance %]>= .95 THEN "good" ELSE "bad" END

N/A

RTM Timer

Root

The duration from when a patient’s placement request was activated until the patient was marked RTM or completed (whichever comes first).

RTM_TIMESTAMP

RTM Timestamp

Root

The date and time that the patient was marked Ready to Move (RTM).

RTM_TIMESTAMP_ENTERPRISE

RTM Timestamp Enterprise

Root

The enterprise date and time that the patient was marked Ready to Move (RTM). The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

N/A

RTM to Assigned Time Threshold

Custom Calc

IF [RTM to Assigned Variance] > 0.1 THEN "Outside Threshold" ELSEIF [RTM to Assigned Variance] > 0 THEN "Approaching Threshold" ELSEIF [RTM to Assigned Variance] <=0 THEN "Within Threshold" ELSE """ END

N/A

RTM to Assigned Time Threshold Text

Custom Calc

IF [RTM to Assigned Variance] > 0.1 THEN "Outside Threshold" ELSEIF [RTM to Assigned Variance] > 0 THEN "Approaching Threshold" ELSEIF [RTM to Assigned Variance] <=0 THEN "Within Threshold" ELSE """ END

N/A

RTM to Assigned Value

Custom Calc

(AVG([Rtm To Bedassigned Time]-15))

N/A

RTM to Assigned Variance

Custom Calc

(AVG([Rtm To Bedassigned Time]-15))/15

N/A

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

N/A

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

N/A

RTM to Occupied Threshold

Custom Calc

IF [RTM to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [RTM to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [RTM to Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END

N/A

RTM to Occupied Threshold Text

Custom Calc

IF [RTM to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [RTM to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [RTM to Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END

N/A

RTM to Occupied Value

Custom Calc

(AVG([Rtm To Bedoccupied Time])-30)

N/A

RTM to Occupied Variance

Custom Calc

(AVG([Rtm To Bedoccupied Time]-30))/30

N/A

Target Campus

Root

The name of a collection of buildings in the enterprise that includes the bed that is preferred for the patient.

N/A

Target Campus Exclude

Custom Calc

[Target Campus]

N/A

Target Discipline

Root

The name of a group of specialty-related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, that includes the bed that is preferred for the patient.

N/A

Target Enterprise

Root

The name of a collection of campuses that includes the bed that is preferred for the patient.

N/A

Target Unit

Root

The unit that includes the bed that is preferred for the patient.

N/A

Target Unit Category

Root

The category to which the target unit belongs.

N/A

Tenant ID

Root

Tenant GUID - Non-Strict Dynamic Partition Column.

N/A

Today

Custom Calc

TODAY()

N/A

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

N/A

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

N/A

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

N/A

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

N/A

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

Unit Targeted Timestamp

Root

The first date and time that the Targeted Unit was selected for the patient.

UNIT_TARGETED_TIMESTAMP_ENTERPRISE

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.

WAREHOUSEACQUISITIONDATE_UTC

WAREHOUSEACQUISITIONDATE_UTC

System Calc

The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.