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 | Last Updated By | Root | The user who most recently updated the note. |
N/A | Note Created Timestamp | Root | The date and time of day the note was created. |
N/A | Note Details | Root | Description of the note. |
N/A | Note ID | Root | The unique identifier assigned to a 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]). |
N/A | Tags | Root | Labels for a note to categorize its contents. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |