Snowflake Field Name

Tableau Data Source Field

Folder

Description

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_CREATED_TO_INITIAL_CONTACT_TIME

Case Created To Initial Contact Time

Root

The difference in minutes between the Case Created Time and the Initial Contact Time. The Initial Contact Time is when the user first selects the Contacted icon in the Physician Communication Card.

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.

CASE_COMMUNICATION_ID

CASE_COMMUNICATION_ID

System Calc

It is the unique GUID assigned to tie up all the communication events with the employee

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.

N/A

Date Filter

Custom Calc

A date filter used by standard content. This field is not intended for client report building.

DATEPARTITION

Datepartition

System Calc

System calculation used internally to partition the data for efficient processing. This field is not intended for client report building.

FINAL_DISPOSITION

Final Disposition

Root

The disposition selected for the physician communication (ACCEPTED, ADMITTED, 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.

N/A

Help

Custom Calc

This field is not intended for client report building.

N/A

Initial Call To Initial Contact In Time Format

Custom Calc

Displays the Initial Call to Initial Contact in MM:SS format.

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.

N/A

Initial Contact To Final Disposition In Time Format

Custom Calc

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. Its in MM:SS format.

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.

N/A

Initial Contact To Initial Response In Time Format

Custom Calc

The duration in minutes from when the transfer specialist first contacted the staff until the staff first responded. Its in MM:SS format.

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.

N/A

Initial Response To Initial Disposition In Time Format

Custom Calc

The duration in minutes between initial response and initial disposition timestamp in minutes (displayed as MM:SS).

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_FIRST_CONTACT

Is First Contact

Root

If the column displays a value of True, the physician was the first to be contacted for the transfer case.

IS_DELETED

IS_DELETED

Root

If the physician communication card is deleted, all the physician communication history records will be deleted and the is_deleted flag is set to true. Default value is false.

LASTMODDATE

Lastmoddate

Root

The created local date/time that the physician communication history record was updated.

LASTMODDATE_UTC

Lastmoddate Utc

Root

The created UTC date/time that the physician 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

System Calc

A unique identifier of the latest facility associated with the communication entry. This field is not intended for client report building.

LATEST_LASTMODDATE_UTC

LATEST_LASTMODDATE_UTC

Root

The latest UTC date time that the physician communication card was updated.

N/A

Number of Records

Custom Calc

The number of records in the data set. Each row in the data set = 1.

NUMBER_OF_TIMES_CONTACTED

Number Of Times Contacted

Root

The number of times that the transfer center specialist attempted to contact the physician.

N/A

Patient Age Current

Custom Calc

This is the date difference in years between the patient's DOB and now. (at the time of report execution)

N/A

Physican Response To Final Disposition

Custom Calc

The difference in minutes between the Initial Response Time and the Final Disposition Time.

N/A

Physician Contact To Response

Custom Calc

The difference in minutes between the Initial Contact Time and the Initial Response Time.

PHYSICIAN_FIRSTNAME

Physician First Name

Root

The first name of the Physician associated with the communication card.

N/A

Physician Full Name

Custom Calc

The First and Last Name of the Physician.

PHYSICIAN_ID

Physician Id

System Calc

A unique identifier of the staff 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.

N/A

Physician name

Custom Calc

This field is not intended for client report building.

POSITION_NAME

POSITION_NAME

Root

The position of the Physician at the time the communication happened.

TENANTID

Tenantid

System Calc

The unique identifier associated with the tenant. This field is not intended for client reporting.

N/A

Time to Accept Threshold

Custom Calc

A calculated field for the standard content visualization. This field is not intended for client report building.

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.