Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
CASECREATED_TO_INITIAL_CONTACT_TIME | CASECREATED_TO_INITIAL_CONTACT_TIME | Root | The duration from when the transfer center specialist created and saved the transfer case until the specialist marked the escalation as contacted. Calculation: Initial Contact Timestamp minus Case Created Timestamp |
CASE_COMMUNICATION_ID | CASE_COMMUNICATION_ID | Root | It is 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. |
CUSTOMER_FACILITY_ID | CUSTOMER_FACILITY_ID | Root | If a facility is integrated with Capacity IQ®, and the facility recorded in the facility 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. |
FACILITY_ID | FACILITY_ID | System Calc | A unique identifier of the facility associated with the communication entry. This is not intended for client report building. |
FACILITY_NAME | FACILITY_NAME | Root | The name of the facility associated with the facility communication card. |
FINAL_DISPOSITION | FINAL_DISPOSITION | Root | The outcome of the facility communication. i.e. Cancelled, Consulted, Accepted, Redirected, Declined. |
FINAL_DISPOSITION_LOCALIZED | FINAL_DISPOSITION_LOCALIZED | System Calc | The outcome of the facility communication. 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 facility communication was cancelled/declined. |
FINAL_DISPOSITION_TIMESTAMP | FINAL_DISPOSITION_TIMESTAMP | Root | The local date and time of day of the latest disposition for the facility communication. |
FINAL_DISPOSITION_TIMESTAMP_UTC | FINAL_DISPOSITION_TIMESTAMP_UTC | Root | The UTC date and time of day of the latest disposition for the facility communication. |
INITIAL_CONTACT_TIMESTAMP | INITIAL_CONTACT_TIMESTAMP | Root | The local date and time of day of the latest disposition for the facility communication. |
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 facility communication. |
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 facility communication's disposition. Calculation: Final Disposition Timestamp minus Initial Contact Timestamp (example: 55 minutes) |
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 facility until the call was returned. Calculation: Initial Response Timestamp minus Initial Contact Timestamp |
INITIAL_RESPONSE_TIMESTAMP | INITIAL_RESPONSE_TIMESTAMP | Root | The local date and time of day that the facility first returned the transfer center specialist's call. |
INITIAL_RESPONSE_TIMESTAMP_UTC | INITIAL_RESPONSE_TIMESTAMP_UTC | Root | The UTC date and time of day that the facility first returned the transfer center specialist's call. |
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 facility communication card is deleted, the record will be marked as TRUE. Otherwise, this will be false. |
IS_FIRST_CONTACT | IS_FIRST_CONTACT | Root | If the column displays a value of True, the facility was the first to be contacted for the transfer case. |
LASTMODDATE | LASTMODDATE | Root | The created local date/time that the facility communication history record was updated. |
LASTMODDATE_UTC | LASTMODDATE_UTC | Root | The created UTC date/time that the facility communication history record was updated. |
LATEST_LASTMODDATE_UTC | LATEST_LASTMODDATE_UTC | Root | The latest UTC date/time that the facility 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 facility. |
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. |