Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Description |
ASSESSMENT_COMPLETED_TIMESTAMP | Assessment Completed Timestamp | Root | The latest End date and time of the assessment saved to the system in the local timezone. |
ASSESSMENT_COMPLETED_TIMESTAMP_UTC | Assessment Completed Timestamp Utc | Root | The latest End date and time of the assessment saved to the system in the UTC timezone. |
ASSESSMENT_ORDERED_TIMESTAMP | Assessment Ordered Timestamp | Root | The latest Ordered date and time of the assessment saved to the system in the local timezone. |
ASSESSMENT_ORDERED_TIMESTAMP_UTC | Assessment Ordered Timestamp Utc | Root | The latest Ordered date and time of the assessment saved to the system in the UTC timezone. |
ASSESSMENT_READY_TIMESTAMP | Assessment Ready Timestamp | Root | The latest Ready date and time of the assessment saved to the system in the local timezone. |
ASSESSMENT_READY_TIMESTAMP_UTC | Assessment Ready Timestamp Utc | Root | The latest Ready date and time of the assessment saved to the system in the UTC timezone. |
ASSESSMENT_START_TIMESTAMP | Assessment Start Timestamp | Root | The latest Start date and time of the assessment saved to the system in the local timezone. |
ASSESSMENT_START_TIMESTAMP_UTC | Assessment Start Timestamp Utc | Root | The latest Start date and time of the assessment saved to the system in the UTC timezone. |
ASSESSMENT_TYPE | Assessment Type | Root | Type of assessment that the assessment is associated with. This is a customer defined dictionary. |
BEHAVIORAL_ID | Behavioral Id | System Calc | The unique identifier for the behavioral health assessment. This field is not intended for client report building. |
CASE_CREATED_DATE | Case Created Date | Root | The date and time of day when the transfer case was initially opened and saved in the customer's timezone. |
CASE_CREATED_DATE_UTC | Case Created Date Utc | Root | The date and time of day when the transfer case was initially opened and saved in the UTC timezone. |
CASE_NUMBER | Case Number | Root | The identifying number that appears below the patient's name in the case details header. |
CASE_OWNER_USERNAME | Case Owner Username | Root | The company’s unique login identifier associated with the employee who owns the case. |
DATEPARTITION | Datepartition | System Calc | Non-Strict Dynamic Partition Column. This field is not intended for client report building. |
DESTINATION_CUSTOMER_FACILITY_ID | Destination Customer Facility Id | Root | If a facility is integrated with Capacity IQ® and has an external identifier, it will display the value set in the campus settings for the destination facility. |
DESTINATION_FACILITY | Destination Facility | Root | The name of the destination facility that accepts the transfer patient. |
DESTINATION_FACILITY_ID | Destination Facility Id | System Calc | The unique identifier for the facility that admits the patient. This field is not intended for client report building. |
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 | A flag indicating if the assessment was deleted or not. The default value will be False. |
LASTMODDATE | Lastmoddate | Root | The date of the most recent update to the assessment in the local time zone. |
LASTMODDATE_UTC | Lastmoddate Utc | Root | The date of the most recent update to the assessment in the UTC time zone. |
LATEST_LASTMODDATE_UTC | Latest Lastmoddate Utc | Root | The latest UTC date/time that the physician communication card was updated. |
ORDERED_TO_READY_TIME | Ordered To Ready Time | Root | The duration in minutes from when the assessment was Ordered to Ready. Calculation: Assessment Ready Timestamp minus Assessment Ordered Timestamp. |
PATIENT_AGE | Patient Age | Root | The age of the person receiving medical treatment at the time of the visit. |
N/A | Patient Age Current | Custom Calc | The time in years between the Patient's date of birth and today. Calculation: DATEDIFF('year', [Patient Dob], NOW()). |
N/A | Patient Age Initial | Custom Calc | The time in years between the Patient's date of birth and the case created date. Calculation: DATEDIFF('year', [Patient Dob], [Case Created Date]). |
PATIENT_DOB | Patient Dob | Root | The date of birth of the person receiving medical treatment. |
PATIENT_FIRST_NAME | Patient First Name | Root | The first name of the person receiving medical treatment. |
PATIENT_LAST_NAME | Patient Last Name | Root | The last name of the person receiving medical treatment. |
PATIENT_MRN | Patient Mrn | Root | The medical record number for a person receiving medical treatment. |
PATIENT_VISIT_NUMBER | Patient Visit Number | Root | Patient's visit number/account number. |
PRIMARY_DIAGNOSIS | Primary Diagnosis | Root | The cause of the patient's disease or injury that is believed to be the primary reason that the patient needs medical attention at the current time. |
PROVIDER | Provider | Root | The name of the physician assessing the patient. |
READY_DELAY_REASON | Ready Delay Reason | Root | The latest value marked for the Readiness Delay reason in an assessment. |
READY_TO_START_TIME | Ready To Start Time | Root | The duration in minutes from when the assessment was Ready to Start. Calculation: Assessment Start Timestamp minus Assessment Ready Timestamp. |
REFERRING_CUSTOMER_FACILITY_ID | Referring Customer Facility Id | Root | If a facility is integrated with Capacity IQ® and has an external identifier, it will display the value set in the campus settings for the referring facility. |
REFERRING_FACILITY | Referring Facility | Root | The health care facility that requests a transfer for a patient. |
REFERRING_FACILITY_ID | Referring Facility Id | System Calc | The unique identifier for the referring facility. This field is not intended for client report building. |
REFERRING_UNIT | Referring Unit | Root | The latest unit recorded under the referring facility section of the transfer case. |
SECONDARY_DIAGNOSIS | Secondary Diagnosis | Root | The cause of the patient's disease or injury that is believed to be the secondary reason that the patient needs medical attention at the current time. |
STAFF_MEMBER | Staff Member | Root | The name of the staff member assessing the patient. |
START_DELAY_REASON | Start Delay Reason | Root | The latest value marked for the Start Delay reason in an assessment. |
START_TO_COMPLETE_TIME | Start To Complete Time | Root | The duration in minutes from when the assessment was Start to End. Calculation: Assessment End Timestamp minus Assessment Start Timestamp. |
TENANTID | Tenantid | System Calc | The date of the most recent update to the assessment in the UTC time zone. This field is not intended for client report building. |
TRANSFER_ID | Transfer Id | System Calc | The unique identifier for the transfer case. This field 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. |