Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
CASE_COMMUNICATION_ID | CASE_COMMUNICATION_ID | System Calc | 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. |
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 staff as contacted. Calculation: Initial Contact Timestamp minus Case Created Timestamp |
CUSTOMER_FACILITY_ID | CUSTOMER_FACILITY_ID | Root | System calculation used internally to partition the data for efficient processing. |
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_TIMESTAMP | 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_TIMESTAMP_UTC | Root | The UTC date and time of day that the Transfer IQ® user first selected the Call Returned button of the staff. |
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 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 | LASTMODDATE | Root | The created local date/time that the staff communication history record was updated. |
LASTMODDATE_UTC | LASTMODDATE_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 | Root | A unique identifier of the latest facility associated with the communication entry. This is not intended for client report building. |
LATEST_LASTMODDATE_UTC | LATEST_LASTMODDATE_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_FIRSTNAME | 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_LASTNAME | Root | The last name of the staff associated with the communication card |
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. |