Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
CASE_NUMBER | Case Number | Root | The identifying number that appears below the patient's name in the case details header. |
CASE_OWNER | Case Owner | Root | The user who created the transfer case. |
CASE_OWNER_USERNAME | Case Owner Username | Root | The company’s unique login identifier associated with the employee who owns the case. |
N/A | Is Deleted | Root | Identifies whether or not a case has been deleted. |
N/A | Issue Description | Root | Summary of the issue. |
N/A | Issue ID | Root | The unique identifier assigned to an issue. |
N/A | Last Updated By | Root | The user who most recently updated the issue. |
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 | Resolved By | Root | The user who resolved the issue. |
N/A | Resolved Status | Root | Indicates whether or not the issue has been resolved. |
N/A | Resolved Timestamp | Root | The date and time of day the issue was resolved. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |