Data Points
Tableau Data Source Field | Folder | Description |
2 Days Ago | Custom Calc | This takes the current date and subtracts it by two days. |
Accept | Custom Calc | If the disposition contains "Accept", then display Accept. This field is not intended for client report building. |
Accept Number | Custom Calc | If the disposition contains "Accept", then the record will be included in the number of records. This field is not intended for client report building. |
Accepting Physician | Root | The first Physician to be marked as the 'accepting' physician by selecting an 'accepted' disposition for the physician communication record. |
Admitting Physician | Root | The name of the physician who agrees to admit the patient into the facility. |
Adult Vs Pediatric | Custom Calc | Determines if a patient is an adult or pediatric patient based upon the Patient Age field IF [Patient Age] = "17" THEN "Pediatric" ELSEIF [Patient Age] = "16" THEN "Pediatric" ELSEIF [Patient Age] = "15" THEN "Pediatric" ELSEIF [Patient Age] = "14" THEN "Pediatric" ELSEIF [Patient Age] = "13" THEN "Pediatric" ELSEIF [Patient Age] = "12" THEN "Pediatric" ELSEIF [Patient Age] = "11" THEN "Pediatric" ELSEIF [Patient Age] = "10" THEN "Pediatric" ELSEIF [Patient Age] = "9" THEN "Pediatric" ELSEIF [Patient Age] = "8" THEN "Pediatric" ELSEIF [Patient Age] = "7" THEN "Pediatric" ELSEIF [Patient Age] = "6" THEN "Pediatric" ELSEIF [Patient Age] = "5" THEN "Pediatric" ELSEIF [Patient Age] = "4" THEN "Pediatric" ELSEIF [Patient Age] = "3" THEN "Pediatric" ELSEIF [Patient Age] = "2" THEN "Pediatric" ELSEIF [Patient Age] = "1" THEN "Pediatric" ELSEIF [Patient Age] = "0" THEN "Pediatric" ELSEIF CONTAINS([Patient Age], "d") THEN "Pediatric" ELSEIF CONTAINS([Patient Age], "m") THEN "Pediatric" ELSE "Adult" END" |
Alerts | Root | The latest Medical Alert(s) selected in the transfer case. If there are more than one medical alerts selected, then the field will include each alert with a comma separator. |
Allergies | Root | The latest Allergies selected in the transfer case. If there is more than one allergy selected, then the field will include each allergy with a comma separator. |
Assigned Bed Number | Root | The bed assigned to the placement request created on the outcomes tab. |
Assigned To Occupied Time | Root | The duration from when a bed was assigned to a patient until the patient physically occupied the bed. The bed request must be created from the Transfer Center Case for this duration to be available. Calculation: Bed Occupied Timestamp minus Bed Assigned Timestamp |
Bed Assigned Timestamp | Root | The platform 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 Utc | Root | The UTC date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or the PatientTracking Portal® application. |
Bed Occupied Timestamp | Root | The platform date and time of day that the patient was admitted and the Pt Status column changed to Inhouse in the Capacity IQ® list view. |
Bed Occupied Timestamp Utc | Root | The UTC date and time of day that the patient was admitted and the Pt Status column changed to Inhouse in the Capacity IQ® list view. |
Bed Request Activated | Root | If the column displays a value of True, the placement request is activated, and the patient needs a bed now. |
Bed Request Status Type | Root | The type of bed requested for the patient (assigned, completed, etc.). |
Bed Request Status Type Localized | Root | The type of bed requested for the patient (assigned, completed, etc.). This field is not intended for client report building. |
Bed Request Targeted Unit | Root | The unit that includes the bed that is preferred for the patient. This is the target unit listed in the bed request detailes of the patient placement detail pane. |
Bed Requested Timestamp | Root | The platform date and time of day that a bed request was created. |
Bed Requested Timestamp Utc | Root | The UTC date and time of day that a bed request was created. |
Bed Type Value | System Calc | This field is not intended for client report building. |
Calculated Age | Custom Calc | The current year minus the year of the the patient's DOB |
Caller1 Name | Root | The latest user recorded in the Caller 1 field. |
Campus Name | Root | The name of the destination facility that accepts the transfer patient. |
Cancel Number | Custom Calc | If the disposition contains "Cancel", then the record will be included in the number of records. This field is not intended for client report building. |
Cancels | Custom Calc | A calculated field that changes a lower case 'cancel' to the standard of 'Cancel'. This field is not intended for client report building. |
Case Complete Datetime | Root | The latest platform date/time the case was completed. |
Case Complete Datetime Utc | Root | The latest UTC date/time the case was completed. |
Case Created Date | Root | The latest platform date/time the case was Created. |
Case Created Date No Time | Custom Calc | A calculated field to derive the date portion of the created date/time. This field is not intended for client report building. |
Case Created Date Utc | Root | The latest date/time the case was Created in UTC time. |
Case Created To Occupied Time | Root | The duration from when a transfer case was created until the patient physically occupied a bed. Calculation: Bed Occupied Timestamp minus Case Created Timestamp |
Case Disposition | Root | The latest disposition recorded for the Transfer IQ® Case. |
Case Disposition Reason | Root | The latest disposition reason recorded for the Transfer IQ® Case. |
Case Disposition Timestamp | Root | The platform date and time that a case disposition was recorded for the transfer case. |
Case Disposition Timestamp Utc | Root | The UTC date and time that a case disposition was recorded for the transfer case. |
Case Needs Review | Root | A flag that indicates if the 'Case Needs Review' check box is marked on the transfer case. |
Case Number | Root | The identifying number that appears below the patient's name in the case details header. |
Case Owner | Root | The user whose name appears in the case's Case Owner field. This name can be changed. |
Case Owner Username | Root | The company’s unique login identifier associated with the employee who owns the case. |
Case Transfer Reason | Root | The reason that a patient needs to be transferred from one facility to another, such as Lack of Capacity, On-Call Specialist Not Available, Family Request, Patient Needs Higher Level of Care, Psych-Involuntary, Psych-Voluntary. |
Case Type | Root | A description of the kind of transfer case. This is recorded in the 'Case Type' field in the transfer case. |
Consult Number | Custom Calc | If the disposition contains "consult", then the record will be included in the number of records. This field is not intended for client report building. |
Current Month Records | Custom Calc | The volume of transfer cases in the current month. |
Current Month Records Wallboard | Custom Calc | The volume of transfer cases in the current month. Not intended for client report building. |
Current Team | Root | The latest value set for the Case Team in the Transfer IQ® Case. |
Customer Facility Id | System Calc | If a facility is integrated with Capacity IQ®, and the destination facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility. |
Datepartition | System Calc | System calculation used internally to partition the data for efficient processing. This field is not intended for client report building. |
Decline Number | Custom Calc | If the disposition contains "decline", then the record will be included in the number of records. This field is not intended for client report building. |
Declines | Custom Calc | A calculated field that changes a lower case 'decline' to the standard of 'Decline'. This field is not intended for client report building. |
Destination Customer Facility Id | System Calc | If a facility is integrated with the Capacity IQ®, and the destination facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility. |
Destination Facility Category | Root | The facility category assigned to the destination facility of the Transfer IQ® Case. |
Destination Facility Id | System Calc | The unique GUID identifier for the facility that admits the patient. This field is not intended for client report building. |
Destination Unit | Root | The unit preferred for the patient and recorded in the Target Unit field. |
Destination Zipcode | Root | The zip code of the health care facility that actually admits the patient. |
Facility Id | System Calc | A unique GUID identifier of the facility associated with the referring facility. This is not intended for client report building. |
First Physician Contact Name | Root | The first Physician to have the Contacted button selected in Physician Communication. |
First Physician Contact Timestamp | Root | The initial local date/time the Physician have the Contacted button selected in Physician Communication. |
First Physician Contact Timestamp Utc | Root | The initial UTC date/time the Physician have the Contacted button selected in Physician Communication. |
Format Time To Accept | Custom Calc | A custom format of 'Time to Accept'. Time to accept is the number of minutes between the case created date and the disposition date time. This field is not intended for client report building. |
Help | Custom Calc | A custom field used in standard content as a placehold for the help button. This field is not intended for client report building. |
Hospital Specialty | Root | The specialty recorded under the requested services in the Transfer IQ® Case. |
Initial Case Complete Datetime | Root | The initial platform date time when a transfer case is completed. |
Initial Case Complete Datetime Utc | Root | The initial date time set in UTC when a transfer case is completed. |
Initial Team | Root | The initial value set for the Case Team in the Transfer IQ® Case. |
Instanceid | System Calc | The unique identifier associated with the instance. For Transfer IQ®, this will be the same as the Tenant ID. This field is not intended for client reporting. |
Internal Transport offered | Root | A flag value indicating if the 'Appropriate internal transport services have been offered.' checkbox has been check for the transfer case. |
Isolations | Root | The isolation selected in the isolation type field for the transfer case. |
Lastmoddate | Root | The platform date/time that the transfer case record was updated. |
Lastmoddate Utc | Root | The UTC date/time that the transfer case record was updated. |
Latest Bed Request Activated Timestamp | Root | The platform date/time that the placement request associated with the transfer case was activated. |
Latest Bed Request Activated Timestamp Utc | Root | The latest UTC date/time that the placement request associated with the transfer case was activated. |
Latest Lastmoddate Utc | System Calc | This is the most recent timestamp in UTC indicating when any data point within a record was last updated. |
Legend Shape Calc | Custom Calc | A calculated field used in standard content for shape formatting. This field is not intended for client report building. |
Less Than Today | Custom Calc | A calculated field that determines if the created date was any day prior to the current date. |
Level of Care | Root | The degree of care that the patient requires (for example, Critical, Acute, Intermediate). This is recorded in the Requested Level of Care field of the transfer case. |
Number of Records | Root | The number of transfer cases. Each row in the data set equals 1. |
Number of Records 1 | Custom Calc | IF [Number of Records] > 1 THEN [Number of Records] ELSEIF CONTAINS([Case Disposition], "Null") THEN 0 END |
Onset of Symptoms Date | Root | The platform date/time recorded for the onset of symptoms. |
Onset of Symptoms Date Utc | Root | The UTC date/time recorded for the onset of symptoms. |
Organisms | Root | The latest Organism(s) selected in the transfer case. If there are more than one Organisms selected, then the field will include each Organism with a comma separator. |
Patient Age | Root | The age of the person receiving medical treatment at the time of the visit. |
Patient Dob | Root | The date of birth of the person receiving medical treatment. |
Patient First Name | Root | The first name of the person receiving medical treatment. |
Patient Gender | Root | The gender recorded in the transfer case. |
Patient Gender Localized | System Calc | A patient gender used in our standard content for language localization. This field is not intended for client report building. |
Patient Last Name | Root | The last name of the person receiving medical treatment. |
Patient Middleinitial | Root | The middle initial of the person receiving medical treatment. |
Patient Mrn | Root | The medical record number for person receiving medical treatment. |
Patient Qualifies For Auto Acceptance | Root | A flag indicating if the 'Patient qualifies for automatic acceptance' is currently selected |
Patient Status | Root | The value selected for the Patient Code Status in the transfer case. |
Patient Suffix | Root | The suffix name of the person receiving medical treatment. |
Patient Type | Root | The patient type selected in the patient details. |
Percent Change Colors | Custom Calc | Used to define colors by looking if the percent change is less than or equal to -10% IF [Percent Change Months] <= -.1 THEN "Drop In Transfers" ELSE "Transfers" END |
Percent Change Months | Custom Calc | Finds the percentage difference from the current month and prior month (SUM([Current Month Records Wallboard])/SUM([Prior Month Records Wallboard]))-1 |
Preferred Customer Facility Id | System Calc | If a facility is integrated with the Capacity IQ®, and the preferred facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility. |
Preferred Facility | Root | The facility that is preferred for the patient recorded in the transfer case. |
Preferred Facility Id | System Calc | The ID of the facility that is preferred for the patient recorded in the transfer case. This field is not intended for client report building. |
Preferred Facility Redirect Reason | Root | This is the reason that the patient will be going to a facility other than the one they indicated as preferred |
Primary Care Physician | Root | The primary care physician recorded in the transfer case. |
Primary Diagnosis | Root | The cause of the patient's disease or injury that is believed to be the primary reason that the patient needs medical attention at the current time. |
Primary Payor | Root | The name of the health insurance carrier that takes first responsibility to pay for the patient's care. |
Primary Payor Category | Root | The grouping of health insurance carriers that the primary payor belongs to. |
Prior Month Records | Custom Calc | Finds the number of records in the data that have a Case Created Date in the previous month IF DATEPART('month',[Case Created Date]) = (DATEPART('month',TODAY())-1) THEN [Number of Records] Else 0 END |
Prior Month Records Wallboard | Custom Calc | Finds the number of records in the data that have a Case Created Date in the previous month IF DATEPART('month',[Case Created Date]) = (DATEPART('month',TODAY())-1) THEN [Number of Records] Else 0 END |
Procedure | Root | The procedure recorded in the transfer case. |
Records Filter | Custom Calc | Used to include only data where the current and prior months have at least 1 record [Current Month Records] + [Prior Month Records] >= 1 |
Referral Withdrawn | Root | A withdrawn referral is a referral that was canceled before being imported into Transfer IQ®. |
Referring Customer Facility Id | System Calc | If a facility is integrated with the Capacity IQ®, and the referring facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility. |
Referring Facility | Root | The health care facility that requests a transfer for a patient. |
Referring Facility Category | Root | The grouping of facilities that the referring facility belongs to. |
Referring Facility Id | System Calc | The unique identifier for the referring facility. This field is not intended for client report building. |
Referring Facility Notified Datetime | Root | The platform date/time the referring facility notified staff. |
Referring Facility Notified Datetime Utc | Root | The utc date/time the referring facility notified staff. |
Referring Facility Notified Staff Name | Root | The name of the staff recorded under 'referring facility notified staff' section of the transfer case. |
Referring Physician | Root | Name of the physician who requests the transfer. |
Referring Unit | Root | The unit that includes the location from which the patient was referred. |
Referring Zipcode | Root | The zip code of the health care facility that requests a transfer for a patient. |
Requested Level of Care | Root | This is the level of care that the referring facility/referring provider has requested is needed for the patient. This data point can come from Referral IQ® and/or be populated from within the Transfer IQ® application on the Patient Tab of the Patient's Case Record. Note: This may be the same or different as the Level of Care indicated at the time of bed request or the Level of Care noted at the time of the patient's admission. |
Requested To Assigned Time | Root | The duration from when a bed was requested until a bed was assigned to the patient. Calculation: Bed Assigned Timestamp minus Bed Requested Timestamp |
Requested To Occupied Time | Root | The duration from when a bed was requested for a patient in the transfer case until the patient physically occupied the bed. Calculation: Bed Occupied Timestamp minus Bed Requested Timestamp |
Return Patient To Referring Facility | Root | A flag indicating if the 'Return patient to referring facility upon completion of case' check box is currently selected. |
Secondary Diagnosis | Root | The cause of the patient's disease or injury that is believed to be the secondary reason that the patient needs medical attention at the current time. |
Secondary Payor | Root | The name of the health insurance carrier that takes second responsibility to pay for the patient's care. |
Secondary Payor Category | Root | The grouping of health insurance carriers that the secondary payor belongs to. |
Service Line | Root | The type of treatment or surgery for the patient (i.e., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line. The service line is derived from the specialty in the case, and the associated service line configured in the data dictionary. |
Service offered At Referring Facility | Root | A flag indicating if the checkbox is currently selected for "The referring facility offers this service" |
Source | Root | The application where the transfer case originated. Values: If the case was created in Transfer IQ®, source = TC If the case was created by importing a referral, source = CAP |
Tenantid | System Calc | The unique identifier associated with the tenant. This field is not intended for client reporting. |
Tertiary Payor | Root | The name of the health insurance carrier that takes third responsibility to pay for the patient's care. |
Tertiary Payor Category | Root | The grouping of health insurance carriers to which the tertiary payor belongs. |
Time To Accept | Custom Calc | The difference in time (in minutes) between the Case Created Date and the Case Disposition Timestamp DATEDIFF('minute', [Case Created Date],[Case Disposition Timestamp]) |
Time To Accept Colors | Custom Calc | Used to define the colors for the difference in time (in minutes) between the Case Created Date and the Case Disposition Timestamp IF AVG([Time To Accept]) > 15 THEN "Red" ELSEIF AVG([Time To Accept]) <= 15 THEN "Green" ELSE "No Data" END |
Transfer Id | System Calc | A unique identifier of the transfer case. This is not intended for client report building. |
Transport Arrival Datetime | Root | The platform date/time recorded for the patient arrival. |
Transport Arrival Datetime Utc | Root | The UTC date/time recorded for the patient arrival. |
Transport Directed To | Root | The value recorded for the 'Directed to field'. This is typically the place or location transport is directed to. |
Transport Dispatch Datetime | Root | The platform date/time recorded for transport dispatch. |
Transport Dispatch Datetime Utc | Root | The UTC date/time recorded for transport dispatch. |
Transport Eta | Root | The platform date/time recorded for transport ETA. |
Transport Eta Utc | Root | The UTC date/time recorded for transport ETA. |
Transport Mode | Root | The transport mode recorded for the transfer case. |
Treatments | Root | The treatments recorded for the transfer case. If multiple treatments are recorded in a given transfer case, they will be all be included as comma seperated values |
Visit Number | Root | The identifier recorded for one of the patient's hospital stays. |
Volume | Custom Calc | Each row in this data set is 1. When this field is aggregated, it can be used to show the sum, average, etc volume for a given period of time, or by other dimension fields. |
Warehouseacquisitiondate Utc | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |