Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
CASE_COMMUNICATION_ID | Case Communication ID | System Calc | This is the unique identifier assigned to tie up all the communication events with the employee. |
CASE_CREATED_TIMESTAMP | Case Created Timestamp | Root | The 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 physician communication history entry. This is not intended for client report building. |
COMMUNICATION_TYPE | Communication Type | Root | The type of communication update made to the physician 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. DELETED - A physician communication card is deleted. ADMITTED - A disposition of admitted 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. |
CONFERENCED_TIMESTAMP | Conferenced Timestamp | Root | The 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 Capacity IQ®, and the facility recorded in the physician communication history entry has an external identifier, it will display the value set in the campus settings for that facility. |
DATEPARTITION | Date Partition | System Calc | System calculation used internally to partition the data for efficient processing. |
DISPOSITION | Disposition | Root | The disposition selected for the physician communication (ACCEPTED, ADMITTED, 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 time a disposition was selected. |
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 physician 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 physician communication card is deleted, all the physician communication history records will be updated to true. Otherwise, this will be false. |
LASTMODDATE | Last Mod Date | Root | The created local date/time that the physician communication history record was updated. |
LASTMODDATE_UTC | Last Mod Date UTC | Root | The created UTC date/time that the physician communication history record was updated. |
LATEST_LASTMODDATE_UTC | Latest Last Mod Date UTC | Root | The latest UTC date/time that the physician communication card was updated. |
MODE_OF_CONTACT | Mode of Contact | Root | The mode of contact selected when contacted button was selected. |
PHYSICIAN_FIRSTNAME | Physician First Name | Root | The first name of the physician associated with the communication card. |
PHYSICIAN_ID | Physician ID | System Calc | A unique identifier of the physician associated with the communication. This is not intended for client report building. |
PHYSICIAN_LASTNAME | Physician Last Name | Root | The last name of the physician associated with the communication card. |
POSITION_NAME | POSITION NAME | Root | This is the position of the person that was contacted. |
RESPONSE_TIMESTAMP | Response Timestamp | Root | The time the call returned button was selected. |
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. |