Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
CASE_CREATED_TIMESTAMP | CASE_CREATED_TIMESTAMP | Root | The local date and time of day when the transfer case was initially opened and saved. |
CASE_CREATED_TIMESTAMP_UTC | CASE_CREATED_TIMESTAMP_UTC | Root | The UTC date and time of day when the transfer case was initially opened and saved. |
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. |
COMMUNICATION_ID | COMMUNICATION_ID | System Calc | A unique identifier of each escalation communication history entry. This is not intended for client report building. |
COMMUNICATION_TYPE | COMMUNICATION_TYPE | Root | The type of communication update made to the escalation communication. Values can include: CANCELLED -A disposition of cancelled is set for the communication card. CONTACTED - The user has clicked the phone icon to indicate they attempted contact. RESOLVED - A disposition of resolved is set for the communication card. RETURNED - The communication card had the returned call button selected. UNRESOLVED - A disposition of unresolved is set for the communication card. |
CONTACT_TIMESTAMP | CONTACT_TIMESTAMP | Root | The local date/time that the contacted button was selected. |
CONTACT_TIMESTAMP_UTC | CONTACT_TIMESTAMP_UTC | Root | The UTC date/time that the contacted button was selected. |
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. |
DISPOSITION | DISPOSITION | Root | The disposition selected for the escalation communication (CANCELLED, RESOLVED, UNRESOLVED). A given communication card may have multiple entries with different dispositions in this detailed table. |
DISPOSITION_LOCALIZED | DISPOSITION_LOCALIZED | System Calc | A field used in our standard content for language localization. This field is not intended for client report building. |
DISPOSITION_REASON | DISPOSITION_REASON | Root | The disposition reason specified when the escalation was cancelled. |
DISPOSITION_TIMESTAMP | DISPOSITION_TIMESTAMP | Root | The local time a disposition was selected. |
DISPOSITION_TIMESTAMP_UTC | DISPOSITION_TIMESTAMP_UTC | Root | The UTC time a disposition was selected. |
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. |
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. |
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. |
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 | Root | The latest UTC date/time that the escalation communication card was updated. This field is not intended for client report building. |
MODE_OF_CONTACT | MODE_OF_CONTACT | Root | The mode of contact selected when contacted button was selected. |
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 |
RESPONSE_TIMESTAMP | RESPONSE_TIMESTAMP | Root | The local time the call returned button was selected. |
RESPONSE_TIMESTAMP_UTC | RESPONSE_TIMESTAMP_UTC | Root | The UTC time the call returned button was selected. |
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. |