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 whose name appears in the case's Case Owner field. This name can be changed. |
CASE_OWNER_USERNAME | Case Owner Username | Root | The company’s unique login identifier associated with the employee who owns the case. |
CUSTOMER_FACILITY_ID | CUSTOMER_FACILITY_ID | Root | If a facility is integrated with Capacity IQ®, and the facility recorded in the escalation communication history entry has an external identifier, it will display the value set in the campus settings for that facility. |
DATEPARTITION | DATEPARTITION | System Calc | System calculation used internally to partition the data for efficient processing. This field is not intended for client report building. |
ESCALATED_TO_PHYSICIAN_ID | ESCALATED_TO_PHYSICIAN_ID | System Calc | The unique identifier of the physician that was specified as the escalation contact in the escalation details. This field is not intended for client report building. |
ESCALATED_TO_PHYSICIAN_NAME | ESCALATED_TO_PHYSICIAN_NAME | Root | The full name (in the format of FN MI LN ) of the physician that was specified as the escalation contact in the escalation details. |
ESCALATED_TO_STAFF_ID | ESCALATED_TO_STAFF_ID | System Calc | The unique identifier of the staff that was specified as the escalation contact in the escalation details. This field is not intended for client report building. |
ESCALATED_TO_STAFF_NAME | ESCALATED_TO_STAFF_NAME | Root | The full name (in the format of FN MI LN ) of the staff that was specified as the escalation contact in the escalation details. |
ESCALATION_ID | ESCALATION_ID | System Calc | The unique identifier for a case that has been escalated. This field is not intended for client report building. |
ESCALATION_ROLE | ESCALATION_ROLE | Root | The role of the person the case was escalated to. |
FACILITY_ID | FACILITY_ID | System Calc | A unique identifier of the facility associated with the communication history entry. When creating the escalation, the user may specify what facility the escalation is related to. This field is not intended for client report building. |
FACILITY_NAME | FACILITY_NAME | Root | The name of the facility associated with the communication history entry. When creating the escalation, the user may specify what facility the escalation is related to. |
FINAL_DISPOSITION | FINAL_DISPOSITION | Root | The outcome of the escalation. i.e. Cancelled, Resolved, Unresolved. |
FINAL_DISPOSITION_LOCALIZED | FINAL_DISPOSITION_LOCALIZED | System Calc | The outcome of the escalation. This field is for language localization only and is not intended for client report building. |
FINAL_DISPOSITION_REASON | FINAL_DISPOSITION_REASON | Root | The reason that the final disposition for the escalation was cancelled. |
FINAL_DISPOSITION_TIMESTAMP | FINAL_DISPOSITION_TIMESTAMP | Root | The local date and time of day of the latest disposition for the escalation. |
FINAL_DISPOSITION_TIMESTAMP_UTC | FINAL_DISPOSITION_TIMESTAMP_UTC | Root | The UTC date and time of day of the latest disposition for the escalation. |
INITIAL_CONTACT_TIMESTAMP | INITIAL_CONTACT_TIMESTAMP | Root | The local date and time of day the transfer center specialist first selected the Contacted icon in the Escalation. |
INITIAL_CONTACT_TIMESTAMP_UTC | INITIAL_CONTACT_TIMESTAMP_UTC | Root | The UTC date and time of day the transfer center specialist first selected the Contacted icon in the Escalation. |
INITIAL_CONTACT_TO_FINAL_DISPOSITION_TIME | INITIAL_CONTACT_TO_FINAL_DISPOSITION_TIME | Root | The duration from when the transfer specialist first selected the contacted button until the specialist sets the escalation's disposition. Calculation: Final Disposition Timestamp minus Initial Contact Timestamp. |
INITIAL_CONTACT_TO_INITIAL_RESPONSE_TIME | INITIAL_CONTACT_TO_INITIAL_RESPONSE_TIME | Root | The duration from when the transfer specialist selected the contacted button until the specialist selects the Call Returned button. Calculation: Initial Response Timestamp minus Initial Contact Timestamp. |
INITIAL_RESPONSE_TIMESTAMP | INITIAL_RESPONSE_TIMESTAMP | Root | The local date and time of day that the Transfer IQ® user first selected the Call Returned button of the escalation. |
INITIAL_RESPONSE_TIMESTAMP_UTC | INITIAL_RESPONSE_TIMESTAMP_UTC | Root | The UTC date and time of day that the Transfer IQ® user first selected the Call Returned button of the escalation. |
INSTANCEID | INSTANCEID | System Calc | The unique identifier associated with the instance. For Transfer IQ®, this will be the same as the Tenant ID. This field is not intended for client reporting. |
IS_DELETED | IS_DELETED | Root | If the escalation communication card is deleted, all the escalation communication history records will be updated to true. Otherwise, this will be false. |
IS_FIRST_CONTACT | IS_FIRST_CONTACT | Root | If the column displays a value of True, the physician was the first to be contacted for the transfer case. |
LASTMODDATE | LASTMODDATE | Root | The created local date/time that the escalation communication history record was updated. |
LASTMODDATE_UTC | LASTMODDATE_UTC | Root | The created UTC date/time that the escalation communication history record was updated. |
LATEST_LASTMODDATE_UTC | LATEST_LASTMODDATE_UTC | System Calc | The latest UTC date/time that the escalation communication card was updated. This field is not intended for client report building. |
NUMBER_OF_TIMES_CONTACTED | NUMBER_OF_TIMES_CONTACTED | Root | The number of times that the transfer center specialist attempted to contact the escalation role. |
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]). |
PHYSICIAN_ID | PHYSICIAN_ID | System Calc | The unique identifier of the physician that the escalation is regarding. This field is not intended for client report building. |
PHYSICIAN_NAME | PHYSICIAN_NAME | Root | Full name (in the format of FN MI LN ) of the physician that the escalation is regarding |
STAFF_ID | STAFF_ID | System Calc | The unique identifier of the staff that the escalation is regarding |
STAFF_NAME | STAFF_NAME | Root | Full name (in the format of FN MI LN ) of the staff that the escalation is regarding |
TENANTID | TENANTID | System Calc | The unique identifier associated with the tenant. This field is not intended for client reporting. |
TRANSFER_ID | TRANSFER_ID | System Calc | A unique identifier of the transfer center case. This is not intended for client report building. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |