Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
N/A | Accepting Physician | Root | The physician who was marked as Accepting in the Targeted Physician Communications section of the transfer case's Consult page. |
N/A | Active Flag | Root | Indicates if the transfer case is currently active. |
N/A | Auto Accept Flag | Root | Indicates if the patient meet the requirements for acceptance without contacting a physician. |
N/A | Bed Type | Root | Displays the type of bed that is requested for the patient. |
N/A | Case Closed Timestamp | Root | The date and time of day that the transfer case was closed. |
N/A | Case Entry Timestamp | Root | The date and time that the transfer case was initially opened. |
N/A | Case Entry to Bed Assigned Time | Root | The elapsed time from when the transfer case was initially opened until the patient was assigned a bed in the health system. Calculation: Bed_Assigned_Timestamp minus Case_Entry_Timestamp |
N/A | Case Entry to Bed Occupied Time | Root | The total elapsed time from when all transfer cases were initially opened until the patients physically began to occupy their beds. Calculation: Bed_Occupied_Timestamp minus Case_Entry_Timestamp |
N/A | Case Entry to Bed Request Time | Root | The elapsed time from when the transfer case was initially opened until a bed request was made for the patient. Calculation: Bed_Requested_Timestamp minus Case_Entry_Timestamp |
N/A | Case Entry to Case Closed Time | Root | The elapsed time from when the transfer case was initially opened until the transfer case was closed. Calculation: Case_Closed_Timestamp minus Case_Entry_Timestamp |
N/A | Case Entry to Phys. Accepting Decision Time | Root | The total elapsed time from when all transfer cases were initially opened until the patients were accepted for placement in the health system. Calculation: Phys_Accepting_Decision_Timestamp minus Case_Entry_ Timestamp |
N/A | Case Entry to Phys Latest Decline Time | Root | The elapsed time from when the transfer case was initially opened until the most recent time that the patient was declined acceptance into the health system. Calculation: Phys_Latest_Decline_Timestamp minus Case_Entry_ Timestamp. |
N/A | Case Owner | Root | The user who created the transfer case. |
N/A | Clinical Protocol | Root | The name of the standard treatment plan for the patient. |
N/A | Created Date | Root | Created Date in local time zone for when the record was entered into Facility Communication Tab on OPTC. |
N/A | Created Date UTC | Root | Created Date in UTC for when the record was entered into Facility Communication Tab on OPTC. |
N/A | Date Partition | Root | Non-Strict Dynamic Partition Column. |
N/A | Destination Facility | Root | The facility to which the transfer patient is admitted. This may or may not be the facility that was requested. |
N/A | Destination Health System | Root | The name of the group of facilities that comprise the medical enterprise to which the patient is transferred. |
N/A | Diagnosis | Root | The identity of the nature and cause of the patient's disease or injury. |
N/A | Disposition | Root | A record of the staff decision in response to a bed request for a transfer patient. |
N/A | Disposition Notify Timestamp | Root | The date and time that the patient placement specialist advised the referring facility of the patient's admit or decline decision. |
N/A | Disposition Reason | Root | The reason for the patient's disposition. |
N/A | EMC Status | Root | The Emergency Medical Condition (EMC) indicates if the patient is experiencing critical health issues requiring immediate attention. |
N/A | Emergent Flag | Root | The Emergent Flag indicates if the patient is experiencing acute and sever conditions that require immediate attention. |
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 | Informed of Recording Flag | Root | Indicates that the transfer center specialist informed the caller from the referring facility that the call was being recorded. |
N/A | Isolation Flag | Root | Indicates if the patient requires isolation. |
N/A | Isolation Type | Root | Code to indicate the type of isolation that applies to the patient, such as Airborne, Droplet, Contact. |
N/A | Last Mod Date | Root | The date of the most recent update to the transfer case in local time zone. |
N/A | Last Mod Date UTC | Root | The date of the most recent update to the transfer case in UTC. |
N/A | Latest Declining Physician | Root | The name of the latest physician to decline admission to the patient. |
N/A | Level of Care | Root | The degree of care that the patient requires (for example, Critical, Acute, Intermediate). |
N/A | MI Alert Flag | Root | Indicates that the patient experienced a myocardial infarction (heart attack). |
N/A | Open Flag | Root | Indicates if the transfer case is open (either active or inactive). |
N/A | Patient Age | Root | The patient's age 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 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 Middle Initial | Root | The middle initial of the person receiving medical treatment. |
N/A | Patient MRN | Root | The medical record number for the person receiving medical treatment. |
N/A | Patient Type | Root | Name of the category for the patient, such as Adult or Infant. |
N/A | Patient Visit Number | Root | The visit number for the person receiving medical treatment. |
N/A | Phys. Accepting Decision Timestamp | Root | The date and time of day that a physician accepted the transfer patient for admission to the health facility. |
N/A | Phys. Accepting Decision to Bed Occupied Time | Root | The number of minutes from when the transfer case was accepted for placement in the health system until the patient occupied a bed. Calculation: Bed_Occupy_Timestamp minus Phys_Accepting_Decision_ Timestamp |
N/A | Phys Latest Decline Timestamp | Root | The date and time of day for the latest time that a physician declined the patient acceptance by the requested facility. |
N/A | Primary Payor | Root | The insurance carrier having primary financial responsibility for the patient’s charges. |
N/A | Redirect Reason | Root | The reason that the patient was not placed in the requested facility. |
N/A | Referring Facility | Root | The health care facility that requests a transfer for a patient. |
N/A | Referring Health System | Root | The name of the group of facilities that comprise the medical enterprise requesting a transfer for a patient. |
N/A | Referring Physician | Root | Name of the physician who requests the transfer. |
N/A | Referring Unit | Root | The name of the unit in the referring facility from which the patient is referred. |
N/A | Requested Facility | Root | The name of the facility to which it is preferred that the patient be admitted. |
N/A | Secondary Payor | Root | The insurance carrier having responsibility for the patient’s charges after the primary payor. |
N/A | Source | Root | The application where the transfer case originated. |
N/A | Stroke Flag | Root | An indicator that the patient has experienced a stroke. |
N/A | Tenant ID | Root | Tenant GUID - Non-Strict Dynamic Partition Column. |
N/A | Tertiary Payor | Root | The insurance carrier having responsibility for the patient’s charges after the primary and secondary payors. |
N/A | Transfer Case | Root | The number assigned to the transfer case when it is first saved. |
N/A | 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. |
N/A | Transport Arrival Timestamp | Root | The date and time of day that the transport service arrived at the destination facility with the patient. |
N/A | Transport Dispatch Timestamp | Root | The date and time of day that the transport service was sent to pick up the patient from the referring facility. |
N/A | Transport Mode | Root | The identifier for the transport service that brings the patient to the requested facility. |
N/A | Trauma Flag | Root | Indicates that the transfer is requested because the patient has experienced a trauma. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |