Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
NA | 7 Days Ago | Root | The date 7 days in the past |
Actual Start Difference | Actual Start Difference | Root | The difference in time between the Scheduled and Actual start timestamps. If the case did not have a delay this field will be NULL |
Actual_Appointment_Duration | Actual_Appointment_Duration | Root | The length of time the patient was in the OR |
Actual_Appointment_End_Timestamp | Actual_Appointment_End_Timestamp | Root | The time that the patient left the OR |
Actual_Appointment_End_Timestamp_UTC | Actual_Appointment_End_Timestamp_UTC | Root | The time that the patient left the OR in UTC |
Actual_Appointment_Start_Timestamp | Actual_Appointment_Start_Timestamp | Root | The time that the patient entered the OR |
Actual_Appointment_Start_Timestamp_UTC | Actual_Appointment_Start_Timestamp_UTC | Root | The time that the patient entered the OR in UTC |
Actual_Patient_Arrival_Timestamp | Actual_Patient_Arrival_Timestamp | Root | The time that the patient arrived at registration |
Actual_Patient_Arrival_Timestamp_UTC | Actual_Patient_Arrival_Timestamp_UTC | Root | The time that the patient arrived at registration in UTC |
Actual_Procedure_Enterprise | Actual_Procedure_Enterprise | Root | The parent organization of the actual procedure location |
Actual_Procedure_Enterprise_ID | Actual_Procedure_Enterprise_ID | Root | The ID of the parent organization of the actual procedure location |
Actual_Procedure_Facility | Actual_Procedure_Facility | Root | The campus/facility of the actual procedure location |
Actual_Procedure_Facility_ID | Actual_Procedure_Facility_ID | Root | The ID of the campus/facility of the actual procedure location |
Actual_Procedure_Location | Actual_Procedure_Location | Root | The specific Operating Room that the procedure occured in |
Actual_Procedure_Location_ID | Actual_Procedure_Location_ID | Root | The ID of the specific Operating Room that the procedure occured in |
Actual_Unit | Actual_Unit | Root | The unit name for the location of the appointment |
Actual_Unit_ID | Actual_Unit_ID | Root | The ID of the unit for the location of the appointment |
Appointment Description | Appointment Description | Root | The description of the appointment |
Appointment_ID | Appointment_ID | Root | The unique identifying ID of the appointment |
Appointment_Status | Appointment_Status | Root | The manner in which the procedure was scheduled. Can be 'Scheduled' or 'Add On' |
Appointment_Status_Localized | Appointment_Status_Localized | Root | The manner in which the procedure was scheduled. Can be 'Scheduled' or 'Add On' |
Appointment_Visit_type | Appointment_Visit_type | Root | The defined type of the visit. Can be inpatient, outpatient, bedside |
Cancellation_Timestamp | Cancellation_Timestamp | Root | The time the appointment was cancelled |
Cancellation_Timestamp_UTC | Cancellation_Timestamp_UTC | Root | The time the appointment was cancelled in UTC |
Completion_Timestamp | Completion_Timestamp | Root | The time the appointment was completed |
Completion_Timestamp_UTC | Completion_Timestamp_UTC | Root | The time the appointment was completed in UTC |
NA | Constant | Root | A field that uses the same value for all records to be used in Level of Detail calculations |
CreatedDate | CreatedDate | Root | The date and time the appointment was created |
CreatedDate_UTC | CreatedDate_UTC | Root | The date and time the appointment was created in UTC |
Customer Facility ID | Customer Facility ID | Root | A unique identifier for a given campus that is defined in the Capacity IQ® campus settings |
NA | Date Filter Range | Root | A field used in standard content to determine if we include certain records based on the date/time |
InstanceID | InstanceID | Root | A system calculation used for data partitioning. It is not intended for client reporting |
Is_AddOn | Is_AddOn | Root | Denotes if the case was an add-on case or was scheduled prior to the day of the appointment |
Is_First_Case | Is_First_Case | Root | Denotes if the case is the first appointment in the scheduled OR for the day |
Is_Same_Day_Cancellation | Is_Same_Day_Cancellation | Root | Denotes if the case was cancelled on the day it was scheduled to occur |
LastModDate | LastModDate | Root | System calculation that displays the most recent update to the application database |
LastModDate_UTC | LastModDate_UTC | Root | System calculation that displays the most recent update to the application database in UTC |
NA | Late vs On Time | Root | Used to determine if a case started on time or was late after accounting for the On Time Grace Period parameter |
Ongoing_Timestamp | Ongoing_Timestamp | Root | The latest time that a procedure appointment's status transitioned to Ongoing |
Ongoing_Timestamp_UTC | Ongoing_Timestamp_UTC | Root | The latest time that a procedure appointment's status transitioned to Ongoing in UTC |
Patient_DOB | Patient_DOB | Root | The patient's date of birth |
Patient_First_Name | Patient_First_Name | Root | The patient's first name |
Patient_Gender | Patient_Gender | Root | The patient's gender |
Patient_ID | Patient_ID | Root | The unqiue identifier for a patient |
Patient_Last_Name | Patient_Last_Name | Root | The patient's last name |
Patient_MRN | Patient_MRN | Root | The medical record number for the patient |
Patient_Visit_ID | Patient_Visit_ID | Root | The unique identifier for the patient's visit |
Patient_Visit_Number | Patient_Visit_Number | Root | The visit number for the patient |
Patient_Visit_Type | Patient_Visit_Type | Root | The defined type of the visit for the patient. Can be inpatient, outpatient, bedside |
Scheduled_Department | Scheduled_Department | Root | The relevant department responsible for the appointment (Cardiology, Gastro, etc) |
Scheduled_Department_ID | Scheduled_Department_ID | Root | The ID of the department responsible for the appointment |
Scheduled_Duration | Scheduled_Duration | Root | The length of time the appointment is scheduled to take |
Scheduled_Procedure_Enterprise | Scheduled_Procedure_Enterprise | Root | The parent organization of the scheduled procedure location |
Scheduled_Procedure_Enterprise_ID | Scheduled_Procedure_Enterprise_ID | Root | The ID of the parent organization of the scheduled procedure location |
Scheduled_Procedure_Facility | Scheduled_Procedure_Facility | Root | The campus/facility of the scheduled procedure location |
Scheduled_Procedure_Facility_ID | Scheduled_Procedure_Facility_ID | Root | The ID of the campus/facility of the scheduled procedure location |
Scheduled_Procedure_Location | Scheduled_Procedure_Location | Root | The specific Operating Room that the procedure is scheduled to occur in |
Scheduled_Procedure_Location_ID | Scheduled_Procedure_Location_ID | Root | The ID of the specific Operating Room that the procedure is scheduled to occur in |
Scheduled_Timestamp | Scheduled_Timestamp | Root | The date and time the appointment is scheduled to begin |
Scheduled_Timestamp_UTC | Scheduled_Timestamp_UTC | Root | The date and time the appointment is scheduled to begin in UTC |
Scheduled_Unit | Scheduled_Unit | Root | The relevant unit responsible for the appointment (Cardiology, Gastro, etc) |
Scheduled_Unit_ID | Scheduled_Unit_ID | Root | The ID of the unit responsible for the appointment |
TenantID | TenantID | Root | System calculation used in data partitioning that is not meant for client reporting |
NA | Today | Root | The current date |
WarehouseAcquisitionDate_UTC | WarehouseAcquisitionDate_UTC | Root | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format |