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 ID | Root | The unique identifier assigned to an issue. |
N/A | Issue Note Description | Root | Details of the Issue Note. |
N/A | Issue Note ID | Root | The unique identifier assigned to an issue note. |
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]). |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |