Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
N/A | Case Created To Initial Contact | Custom Calc | DATEDIFF('second',[Case Entry Timestamp],[Paged Timestamp])/60 |
N/A | Created Date | Root | Created Date in local time zone for when the record was entered. |
N/A | Createddate (copy) | Custom Calc | DATE([Createddate]) |
N/A | 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',[Createddate (copy)],TODAY()) = 0 ELSEIF [Date type] = 'Yesterday' THEN DATEDIFF('day',[Createddate (copy)],TODAY()) = 1 ELSEIF [Date type]='Week' THEN DATEDIFF('day',[Createddate (copy)],TODAY()) >= 1 AND DATEDIFF('day',[Createddate (copy)],TODAY()) <= 7 ELSEIF [Date type]= 'Month' THEN DATEDIFF('month',[Createddate (copy)],TODAY()) = 1 ELSEIF [Date type] = "Custom Date" THEN [Createddate (copy)] >= [Custom Start Date] and [Createddate (copy)] <= [Custom End Date] END |
N/A | Date Selector Range | Custom Calc | IF [Date Range] ='Today' THEN DATEDIFF('day',[Createddate (copy)],TODAY()) = 0 ELSEIF [Date Range] = 'Yesterday' THEN DATEDIFF('day',[Createddate (copy)],TODAY()) = 1 ELSEIF [Date Range] ='Last 7 Days' THEN DATEDIFF('day',[Createddate (copy)],TODAY()) >= 1 AND DATEDIFF('day',[Createddate (copy)],TODAY()) <= 7 ELSEIF [Date Range] = 'Last Month' THEN DATEDIFF('month',[Createddate (copy)],TODAY()) = 1 ELSEIF [Date Range] = "Custom Date" THEN [Createddate (copy)] >= [Custom Start Date] and [Createddate (copy)] <= [Custom End Date] END |
N/A | Decision Timestamp | Root | The date and time that a physician made a decision on admitting the transfer patient to the facility. |
N/A | Last Mod Date | Root | Last Mod Date in local time zone for when the record was modified. |
N/A | Last Mod Date UTC | Root | Last Mod Date in UTC for when the record was modified. |
N/A | Help | Custom Calc | "Help" |
N/A | Initial Call To Initial Contact In Time Format | Custom Calc | IIF(int(AVG([Case Created To Initial Contact]*60)) % 60 == 60,0,AVG([Case Created To Initial Contact]*60) % 60)// seconds + INT(AVG([Case Created To Initial Contact]*60)/60) * 100 //minutes |
N/A | Initial Contact To Final Disposition In Time Format | Custom Calc | IIF(int(AVG([Paged To Decision Time]*60)) % 60 == 60,0,AVG([Paged To Decision Time]*60) % 60)// seconds + INT(AVG([Paged To Decision Time]*60)/60) * 100 //minutes |
N/A | Initial Contact To Initial Response In Time Format | Custom Calc | IIF(int(AVG([Paged To Return Call Time]*60)) % 60 == 60,0,AVG([Paged To Return Call Time]*60) % 60)// seconds + INT(AVG([Paged To Return Call Time]*60)/60) * 100 //minutes |
N/A | Initial Response to final dispo | Custom Calc | DATEDIFF('second',[Return Call Timestamp],[Decision Timestamp])/60 |
N/A | Initial Response To Final Disposition In Time Format | Custom Calc | IIF(int(AVG([Initial Response to final dispo]*60)) % 60 == 60,0,AVG([Initial Response to final dispo]*60) % 60)// seconds + INT(AVG([Initial Response to final dispo]*60)/60) * 100 //minutes |
N/A | LOD Number of Records | Custom Calc | {FIXED : SUM([Number of Records])} |
N/A | Paged Timestamp | Root | The date and time of day that a patient placement specialist attempted to contact the consulting physician/other consultant to see if the physician would admit the transfer patient. |
N/A | Paged To Decision Time | Root | The time from when the consulting physician/other consultant was paged until the decisions was made to accept or reject the patient's admission into the health system. Calculation: Decision Timestamp minus Paged Timestamp |
N/A | Paged To Return Call Time | Root | The time from when the consulting physician/other consultant was paged until the physician returned the call. Calculation: Return Call Timestamp minus Paged Timestamp |
N/A | Physician | Root | The name of the physician in Last Name, First Name Middle Initial format. |
N/A | Physician Type | Root | The role of the physician in relation to the transfer case, such as Accepting, Consulting, Declining, Other. |
N/A | Repaged Flag | Root | An indicator that the transfer center specialist paged the consulting physician/other consultant for the second time to admit the transfer patient admission to the facility. |
N/A | Repaged Timestamp | Root | The date and time of day for the second time that a patient placement specialist in the transfer center attempted to contact the consulting physician/other consultant to see if the physician would admit the transfer patient. |
N/A | Return Call Timestamp | Root | The date and time that the consulting physician/other consultant calls back the transfer center in response to a page. |
N/A | Target Physician ID | Root | The unique numerical identifier for the physician the patient placement specialist is contacting. |
N/A | Transfer Case | Root | The unique identifying number for the transfer case. |
N/A | Time To Accept Colors | Custom Calc | IF AVG([Paged To Return Call Time]) < 120 THEN "Green" ELSE "Red" END |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |