Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
CASE_COMMUNICATION_ID | Case Communication ID | System Calc | The unique GUID assigned to tie up all the communication events with the employees the unique GUID assigned to tie up all the communication events with the employee. |
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. |
CASECREATED_TO_INITIAL_CONTACT_TIME | Case Created to Initial Contact Time | Root | The duration from when the transfer center specialist created and saved the transfer case until the specialist marked the staff as contacted. Calculation: Initial Contact Timestamp minus Case Created Timestamp |
CUSTOMER_FACILITY_ID | Customer Facility ID | Root | If a facility is integrated with the Capacity IQ, and the facility recorded in the staff 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. |
FINAL_DISPOSITION | Final Disposition | Root | The disposition selected for the staff communication (ACCEPTED, CANCELLED, CONSULTED, DECLINED) |
FINAL_DISPOSITION_LOCALIZED | Final Disposition Localized | System Calc | A field used in our standard content for language localization. This field is not intended for client report building. |
FINAL_DISPOSITION_REASON | Final Disposition Reason | Root | The reason selected when a disposition is set. When recording a cancelled or declined disposition for the communication card, the Transfer IQ® user is required to record a reason for the cancellation or declination |
FINAL_DISPOSITION_TIMESTAMP | Final Disposition Timestamp | Root | The local time a disposition was selected. |
FINAL_DISPOSITION_TIMESTAMP_UTC | Final Disposition Timestamp UTC | Root | The UTC time a disposition was selected. |
INITIAL_CONTACT_TIMESTAMP | Initial Contact Timestamp | Root | The local date and time that the Transfer IQ® user first selects the contacted button on the communication card'. |
INITIAL_CONTACT_TIMESTAMP_UTC | Initial Contact Timestamp UTC | Root | The UTC date and time that the Transfer IQ® user first selects the contacted button on the communication card'. |
INITIAL_CONTACT_TO_FINAL_DISPOSITION_TIME | Initial Contact to Final Disposition Time | Root | The duration in minutes from when the transfer specialist first contacted the staff until the specialist sets the staff's final disposition concerning the transfer case. Calculation: Final Disposition Timestamp minus Initial Contact Timestamp |
INITIAL_CONTACT_TO_INITIAL_RESPONSE_TIME | Initial Contact to Initial Response Time | Root | The duration in minutes from when the transfer specialist first contacted the staff until the staff first responded. Calculation: Initial Response Timestamp minus Initial Contact Timestamp |
INITIAL_RESPONSE_TIMESTAMP | Initial Response Time | Root | The local date and time of day that the Transfer IQ® user first selected the Call Returned button of the staff. |
INITIAL_RESPONSE_TIMESTAMP_UTC | Initial Response Time UTC | Root | The UTC date and time of day that the Transfer IQ® user first selected the Call Returned button of the staff. |
INSTANCEID | Instance ID | 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 staff communication card is deleted, all the staff communication history records will be deleted and the is_deleted flag is set to true. Default value is false. |
IS_FIRST_CONTACT | Is First Contact | Root | If the column displays a value of True, the staff was the first to be contacted for the transfer case. |
LASTMODDATE | Last Moddate | Root | The created local date/time that the staff communication history record was updated. |
LASTMODDATE_UTC | Last Moddate UTC | Root | The created UTC date/time that the staff communication history record was updated. |
LATEST_FACILITY | Latest Facility | Root | The name of the latest facility associated with the communication history entry. |
LATEST_FACILITY_ID | Latest Facility ID | System Calc | A unique identifier of the latest facility associated with the communication entry. This is not intended for client report building. |
LATEST_LASTMODDATE_UTC | Latest Last Moddate UTC | Root | The latest UTC date time that the staff communication card was updated |
NUMBER_OF_TIMES_CONTACTED | Number of Times Contacted | Root | The number of times that the transfer center specialist attempted to contact the staff. |
POSITION_NAME | Position Name | Root | The position of the staff at the time the communication happened. |
STAFF_FIRSTNAME | Staff First Name | Root | The first name of the staff associated with the communication card. |
STAFF_ID | Staff ID | System Calc | A unique identifier of the staff associated with the communication. This is not intended for client report building. |
STAFF_LASTNAME | Staff Last Name | Root | The last name of the staff associated with the communication card. |
TENANTID | Tenant ID | 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 | Warehouse Acquisition Date UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |