Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
CASE_COMMUNICATION_ID | Case Communication ID | System Calc | The local date and time of day when the transfer case was initially opened and saved. |
CASE_CREATED_TIMESTAMP | Case Created Timestamp | Root | The local 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 staff communication history entry. This is not intended for client report building. |
COMMUNICATION_TYPE | Communication Type | Root | The type of communication update made to the staff communication. Values can include: ACCEPTED - A disposition of accepted set for the communication card. DECLINED - A disposition of declined set for the communication card. CANCELLED - A disposition of cancelled set for the communication card. CONSULTED - A disposition of consulted set for the communication card. CONFERENCED - The communication card had the conference button selected. RETURNED - The communication card had the returned call button selected. CONTACTED - The communication card had the contacted button selected. |
COMMUNICATION_TYPE_LOCALIZED | Communication Type Localized | System Calc | Tenant localized communication type value. This field is not intended for client report building. |
CONFERENCED_TIMESTAMP | Conferenced Timestamp | Root | The local time the conferenced button was selected. |
CONTACT_TIMESTAMP | Contact Timestamp | Root | The local date/time when the contacted button was selected. |
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. This field is not intended for client report building. |
DISPOSITION | Disposition | Root | The disposition selected for the staff communication (ACCEPTED, CANCELLED, CONSULTED, DECLINED). |
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 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. |
DISPOSITION_TIMESTAMP | Disposition Timestamp | Root | The local date and time of the day when the disposition is selected for the staff. |
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 communication history entry. When selecting a disposition for the staff communication card, the user may be required to record the facility associated with the disposition. |
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. |
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_LASTMODDATE_UTC | Latest Last Moddate UTC | Root | The latest UTC date time that the staff communication card was updated |
MODE_OF_CONTACT | Mode of Contact | Root | The mode of contact selected when contacted button was selected. |
POSITION_NAME | Position Name | Root | The position of the staff at the time the communication happened. |
RESPONSE_TIMESTAMP | Response Timestamp | Root | The time the call returned button was selected. |
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 | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |