Snowflake Field Name

Tableau Data Source Field

Folder

Description

N/A

Percent Change Colors

Custom Calc

Used to define colors by looking if the percent change is less than or equal to -10%

IF [Percent Change Months] <= -.1 THEN "Drop in Transfers" ELSE "Transfers" END

N/A

Percent Change Months

Custom Calc

Finds the percentage difference from the current month and prior month

(SUM([Current Month Records Wallboard])/SUM([Prior Month Records Wallboard]))-1

N/A

Accept

Custom Calc

If the disposition contains "Accept", then display Accept. This field is not intended for client report building.

N/A

Accept Number

Custom Calc

If the disposition contains "Accept", then the record will be included in the number of records. This field is not intended for client report building.

N/A

Accepted Percent

Custom Calc

The sum of Accept Number / the sum of Completed Cases. This field is not intended for client report building.

ACCEPTING_PHYSICIAN

ACCEPTING_PHYSICIAN

Root

The first Physician to be marked as the 'accepting' physician by selecting an 'accepted' disposition for the physician communication record.

ADMITTING_PHYSICIAN

Admitting Physician

Root

The name of the physician who agrees to admit the patient into the facility.

N/A

Adult Vs Pediatric

Custom Calc

Determines if a patient is an adult or pediatric patient based upon the Patient Age field

IF [Patient Age] = "17" THEN "Pediatric" ELSEIF [Patient Age] = "16" THEN "Pediatric" ELSEIF [Patient Age] = "15" THEN "Pediatric" ELSEIF [Patient Age] = "14" THEN "Pediatric" ELSEIF [Patient Age] = "13" THEN "Pediatric" ELSEIF [Patient Age] = "12" THEN "Pediatric" ELSEIF [Patient Age] = "11" THEN "Pediatric" ELSEIF [Patient Age] = "10" THEN "Pediatric" ELSEIF [Patient Age] = "9" THEN "Pediatric" ELSEIF [Patient Age] = "8" THEN "Pediatric" ELSEIF [Patient Age] = "7" THEN "Pediatric" ELSEIF [Patient Age] = "6" THEN "Pediatric" ELSEIF [Patient Age] = "5" THEN "Pediatric" ELSEIF [Patient Age] = "4" THEN "Pediatric" ELSEIF [Patient Age] = "3" THEN "Pediatric" ELSEIF [Patient Age] = "2" THEN "Pediatric" ELSEIF [Patient Age] = "1" THEN "Pediatric" ELSEIF [Patient Age] = "0" THEN "Pediatric" ELSEIF CONTAINS([Patient Age], "d") THEN "Pediatric" ELSEIF CONTAINS([Patient Age], "m") THEN "Pediatric" ELSE "Adult" END

ALERTS

ALERTS

Root

The latest Medical Alert(s) selected in the transfer case. If there are more than one medical alerts selected, then the field will include each alert with a comma separator.

ALLERGIES

ALLERGIES

Root

The latest Allergies selected in the transfer case. If there are more than one allergies selected, then the field will include each allergy with a comma separator.

ASSIGNED_BED_NUMBER

Assigned Bed Number

Root

The bed assigned to the placement request created on the outcomes tab.

ASSIGNED_TO_OCCUPIED_TIME

Assigned to Occupied Time

Root

The duration from when a bed was assigned to a patient until the patient physically occupied the bed. The bed request must be created from the Transfer Case for this duration to be available. Calculation: Bed Occupied Timestamp minus Bed Assigned Timestamp

BED_ASSIGNED_TIMESTAMP

Bed Assigned Timestamp

Root

The platform date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit or PatientTracking Portal applications.

BED_ASSIGNED_TIMESTAMP_UTC

BED_ASSIGNED_TIMESTAMP_UTC

Root

The UTC date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit or PatientTracking Portal applications.

BED_OCCUPIED_TIMESTAMP

Bed Occupied Timestamp

Root

The platform date and time of day that the patient was admitted and the Pt Status column changed to Inhouse in the Capacity Management® suite list view.

BED_OCCUPIED_TIMESTAMP_UTC

BED_OCCUPIED_TIMESTAMP_UTC

Root

The UTC date and time of day that the patient was admitted and the Pt Status column changed to Inhouse in the Capacity Management® suite list view.

BED_REQUEST_ACTIVATED

Bed Request Activated

Root

If the column displays a value of True, the placement request is activated, and the patient needs a bed now.

BED_REQUEST_TARGETED_UNIT

Bed Request Targeted Unit

Root

The unit that includes the bed that is preferred for the patient. This is the target unit listed in the bed request details of the patient placement detail pane.

BED_REQUESTED_TIMESTAMP

Bed Requested Timestamp

Root

The platform date and time of day that a bed request was created.

BED_REQUESTED_TIMESTAMP_UTC

BED_REQUESTED_TIMESTAMP_UTC

Root

The UTC date and time of day that a bed request was created.

BED_TYPE_VALUE

Bed Type Value

System Calc

This field is not intended for client report building.

BED_REQUEST_STATUS_TYPE

BED_REQUEST_STATUS_TYPE

Root

The type of bed requested for the patient (assigned, completed, etc.).

BED_REQUEST_STATUS_TYPE_LOCALIZED

BED_REQUEST_STATUS_TYPE_LOCALIZED

Root

The type of bed requested for the patient (assigned, completed, etc.). This field is not intended for client report building.

N/A

Calculated Age

Custom Calc

The current year minus the year of the patient's DOB

CALLER1_NAME

Caller 1 Name

Root

The latest user recorded in the Caller 1 field.

CAMPUS_NAME

Campus Name

Root

The name of the destination facility that accepts the transfer patient.

N/A

Campus Names Calc

Custom Calc

Allows users to expand or collapse the view IF [expand or collapse] = "Collapse" THEN IF [Top N campus set] THEN [Campus Name] ELSE "Others" END ELSE [Campus Name] END. This field is not intended for client report building

N/A

Cancel Number

Custom Calc

If the disposition contains "Cancel", then the record will be included in the number of records. This field is not intended for client report building.

N/A

Cancel Percent

Custom Calc

The sum of Cancel Number / the sum of Completed Cases. This field is not intended for client report building.

N/A

Cancel Threshold

Custom Calc

A calculated field that determines if standard content should display red or green for a section of content. This field is not intended for client report building.

N/A

Cancels

Custom Calc

A calculated field that changes a lower case 'cancel' to the standard of 'Cancel'. This field is not intended for client report building.

CASE_COMPLETE_DATETIME

Case Complete Datetime

Root

The latest platform date/time the case was completed.

CASE_COMPLETE_DATETIME_UTC

Case Complete Datetime UTC

Root

The latest UTC date/time the case was completed.

CASE_CREATED_DATE

Case Created Date

Root

The latest platform date/time the case was Created.

N/A

Case Created Date (no time)

Custom Calc

A calculated field to derive the date portion of the created date/time. This field is not intended for client report building.

CASE_CREATED_DATE_UTC

CASE_CREATED_DATE_UTC

Root

The latest date/time the case was Created in UTC time.

CASE_CREATED_TO_OCCUPIED_TIME

Case Created to Occupied Time

Root

The duration from when a transfer case was created until the patient physically occupied a bed. Calculation: Bed Occupied Timestamp minus Case Created Timestamp

CASE_DISPOSITION

Case Disposition

Root

The latest disposition recorded for the Transfer Case.

CASE_DISPOSITION_REASON

Case Disposition Reason

Root

The latest disposition reason recorded for the Transfer Case.

CASE_DISPOSITION_TIMESTAMP

Case Disposition Timestamp

Root

The platform date and time that a case disposition was recorded for the transfer case.

CASE_DISPOSITION_TIMESTAMP_UTC

CASE_DISPOSITION_TIMESTAMP_UTC

Root

The UTC date and time that a case disposition was recorded for the transfer case.

CASE_NEEDS_REVIEW

Case Needs Review

Root

A flag that indicates if the the 'Case Needs Review' checkbox is marked on the transfer case.

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_TRANSFER_REASON

Case Transfer Reason

Root

The reason that a patient needs to be transferred from one facility to another, such as Lack of Capacity, On-Call Specialist Not Available, Family Request, Patient Needs Higher Level of Care, Psych-Involuntary, Psych-Voluntary.

CASE_TYPE

Case Type

Root

A description of the kind of transfer case. This is recorded in the 'Case Type' field in the transfer case.

N/A

Consult Number

Custom Calc

If the disposition contains "consult", then the record will be included in the number of records. This field is not intended for client report building.

N/A

Consult Percent

Custom Calc

The sum of Consult Number / the sum of Completed Cases. This field is not intended for client report building.

N/A

Contribution Margin

Custom Calc

A calculated field that takes the volume and multiplies by 'margin param' to calculate a 'per case' dollar value.

N/A

Current Month Records

Custom Calc

The volume of transfer cases in the current month.

N/A

Current Month Records Wallboard

Custom Calc

The volume of transfer cases in the current month. Not intended for client report building.

CURRENT_TEAM

Current Team

Root

The latest value set for the Case Team in the Transfer IQ® Case.

CUSTOMER_FACILITY_ID

CUSTOMER_FACILITY_ID

System Calc

If a facility is integrated with Capacity IQ®, and the destination facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.

N/A

Date Filter

Custom Calc

A calculated field used in standard content for including/excluding records. This field is not intended for client report building.

N/A

Date Filter Range

Custom Calc

A calculated field used in standard content for including/excluding records. 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.

N/A

Decline Number

Custom Calc

If the disposition contains "decline", then the record will be included in the number of records. This field is not intended for client report building.

N/A

Decline Percent

Custom Calc

The sum of Decline Number / the sum of Completed Cases. This field is not intended for client report building.

N/A

Decline Threshold

Custom Calc

A calculated field that determines if standard content should display red or green for a section of content. This field is not intended for client report building.

N/A

Declines

Custom Calc

A calculated field that changes a lower case 'decline' to the standard of 'Decline'. This field is not intended for client report building.

DESTINATION_CUSTOMER_FACILITY_ID

DESTINATION_CUSTOMER_FACILITY_ID

System Calc

If a facility is integrated with Capacity IQ®, and the destination facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.

DESTINATION_FACILITY_CATEGORY

Destination Facility Category

Root

The facility category assigned to the destination facility of the Transfer Case.

DESTINATION_FACILITY_ID

Destination Facility Id

System Calc

The unique GUID identifier for the facility that admits the patient. This field is not intended for client report building.

DESTINATION_UNIT

Destination Unit

Root

The unit preferred for the patient and recorded in the Target Unit field.

DESTINATION_ZIPCODE

Destination ZIP Code

Root

The zip code of the health care facility that actually admits the patient.

N/A

Facility Names Calc

Custom Calc

A calculated field used in standard content for collapsing/expanding rows. This field is not intended for client report building.

FACILITY_ID

FACILITY_ID

System Calc

A unique GUID identifier of the facility associated with the referring facility. This is not intended for client report building.

FIRST_PHYSICIAN_CONTACT_NAME

First Physician Contact Name

Root

The first Physician to have the Contacted button selected in Physician Communication.

FIRST_PHYSICIAN_CONTACT_TIMESTAMP

First Physician Contact Timestamp

Root

The initial local date/time the Physician have the Contacted button selected in Physician Communication.

FIRST_PHYSICIAN_CONTACT_TIMESTAMP_UTC

First Physician Contact Timestamp UTC

Root

The initial UTC date/time the Physician have the Contacted button selected in Physician Communication.

N/A

Format Time to Accept

Custom Calc

A custom format of 'Time to Accept'. Time to accept is the number of minutes between the case created date and the disposition date time. This field is not intended for client report building.

N/A

Help

Custom Calc

A custom field used in standard content as a placeholder for the help button. This field is not intended for client report building.

HOSPITAL_SPECIALTY

Hospital Specialty

Root

The specialty recorded under the requested services in the Transfer Case.

INITIAL_CASE_COMPLETE_DATETIME

Initial Case Complete Datetime

Root

The initial platform date time when a transfer case is completed.

INITIAL_CASE_COMPLETE_DATETIME_UTC

Initial Case Complete Datetime UTC

Root

The initial date time set in UTC when a transfer case is completed.

INITIAL_TEAM

Initial Team

Root

The initial value set for the Case Team in the Transfer Case.

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.

INTERNAL_TRANSPORT_OFFERED

Internal Transport Offered

Root

A flag value indicating if the 'Appropriate internal transport services have been offered.' checkbox has been check for the transfer case.

ISOLATIONS

ISOLATIONS

Root

The isolation selected in the isolation type field for the transfer case.

LASTMODDATE

Last Mod Date

Root

The platform date/time that the transfer case record was updated.

LASTMODDATE_UTC

Last Mod Date UTC

Root

The UTC date/time that the transfer case record was updated.

LATEST_BED_REQUEST_ACTIVATED_TIMESTAMP

LATEST_BED_REQUEST_ACTIVATED_TIMESTAMP

Root

The platform date/time that the placement request associated with the transfer case was activated.

LATEST_BED_REQUEST_ACTIVATED_TIMESTAMP_UTC

LATEST_BED_REQUEST_ACTIVATED_TIMESTAMP_UTC

Root

The latest UTC date/time that the placement request associated with the transfer case was activated.

N/A

Legend Shape Calc

Custom Calc

A calculated field used in standard content for shape formatting. This field is not intended for client report building.

N/A

Less than Today

Custom Calc

A calculated field that determines if the created date was any day prior to the current date.

LEVEL_OF_CARE

Level of Care

Root

The degree of care that the patient requires (for example, Critical, Acute, Intermediate). This is recorded in the Requested Level of Care field of the transfer case.

N/A

LOD Completed Dispositions

Custom Calc

A calculated field that gives the sum number of records at the disposition level. This field is not intended for client report building.

N/A

LOD Number of Records

Custom Calc

The sum number of records at the data source level. This field is not intended for client report building.

N/A

Number of Records

Root

The number of transfer cases. Each row in the data set equals 1.

N/A

Number of Records 0

Custom Calc

IF [Number of Records] > 0 THEN [Number of Records] ELSEIF CONTAINS([Case Disposition], "Null") THEN 0 END

ONSET_OF_SYMPTOMS_DATE

Onset of Symptoms Date

Root

The platform date/time recorded for the onset of symptoms.

ONSET_OF_SYMPTOMS_DATE_UTC

Onset of Symptoms Date UTC

Root

The UTC date/time recorded for the onset of symptoms.

ORGANISMS

ORGANISMS

Root

The latest Organism(s) selected in the transfer case. If there are more than one Organisms selected, then the field will include each Organism with a comma separator.

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_GENDER

Patient Gender

Root

The gender recorded in the transfer case.

PATIENT_GENDER_LOCALIZED

PATIENT_GENDER_LOCALIZED

System Calc

A patient gender used in our standard content for language localization. This field is not intended for client report building.

PATIENT_LAST_NAME

Patient Last Name

Root

The last name of the person receiving medical treatment.

PATIENT_MIDDLEINITIAL

Patient Middle Initial

Root

The middle initial of the person receiving medical treatment.

PATIENT_MRN

Patient MRN

Root

The medical record number for person receiving medical treatment.

PATIENT_QUALIFIES_FOR_AUTO_ACCEPTANCE

Patient Qualifies For Auto Acceptance

Root

A flag indicating if the 'Patient qualifies for automatic acceptance' is currently selected

PATIENT_STATUS

PATIENT_STATUS

Root

The value selected for the Patient Code Status in the transfer case.

PATIENT_SUFFIX

Patient Suffix

Root

The suffix name of the person receiving medical treatment.

PATIENT_TYPE

Patient Type

Root

The patient type selected in the patient details.

PREFERRED_CUSTOMER_FACILITY_ID

PREFERRED_CUSTOMER_FACILITY_ID

System Calc

If a facility is integrated with Capacity IQ®, and the preferred facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.

PREFERRED_FACILITY

Preferred Facility

Root

The facility that is preferred for the patient recorded in the transfer case.

PREFERRED_FACILITY_ID

PREFERRED_FACILITY_ID

System Calc

The ID of the facility that is preferred for the patient recorded in the transfer case. This field is not intended for client report building.

PREFERRED_FACILITY_REDIRECT_REASON

PREFERRED_FACILITY_REDIRECT_REASON

Root

This is the reason that the patient will be going to a facility other than the one they indicated as preferred.

PRIMARY_CARE_PHYSICIAN

Primary Care Physician

Root

The primary care physician recorded in the transfer case.

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.

PRIMARY_PAYOR

Primary Payor

Root

The name of the health insurance carrier that takes first responsibility to pay for the patient's care.

PRIMARY_PAYOR_CATEGORY

Primary Payor Category

Root

The grouping of health insurance carriers that the primary payor belongs to.

N/A

Prior Month Records

Custom Calc

Finds the number of records in the data that have a Case Created Date in the previous month.

IF DATEPART('month',[Case Created Date]) = (DATEPART('month',TODAY())-1) THEN [Number of Records] Else 0 END

N/A

Prior Month Records Wallboard

Custom Calc

Finds the number of records in the data that have a Case Created Date in the previous month.

IF DATEPART('month',[Case Created Date]) = (DATEPART('month',TODAY())-1) THEN [Number of Records] Else 0 END

PROCEDURE

Procedure

Root

The procedure recorded in the transfer case.

N/A

Records Filter

Custom Calc

Used to include only data where the current and prior months have at least 1 record[Current Month Records] + [Prior Month Records] >= 1

REFERRAL_WITHDRAWN

Referral Withdrawn

Root

A withdrawn referral is a referral that was canceled before being imported into Transfer IQ®.

REFERRING_CUSTOMER_FACILITY_ID

REFERRING_CUSTOMER_FACILITY_ID

System Calc

If a facility is integrated with the Capacity IQ®, and the referring facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.

REFERRING_FACILITY

Referring Facility

Root

The health care facility that requests a transfer for a patient.

REFERRING_FACILITY_CATEGORY

Referring Facility Category

Root

The grouping of facilities that the referring facility belongs to.

REFERRING_FACILITY_ID

Referring Facility Id

Root

The unique identifier for the referring facility. This field is not intended for client report building.

REFERRING_FACILITY_NOTIFIED_DATETIME

Referring Facility Notified Datetime

Root

The platform date/time the referring facility notified staff.

REFERRING_FACILITY_NOTIFIED_DATETIME_UTC

Referring Facility Notified Datetime UTC

Root

The utc date/time the referring facility notified staff.

REFERRING_FACILITY_NOTIFIED_STAFF_NAME

Referring Facility Notified Staff Name

Root

The name of the staff recorded under 'referring facility notied staff' section of the transfer case.

REFERRING_PHYSICIAN

Referring Physician

Root

Name of the physician who requests the transfer.

REFERRING_UNIT

Referring Unit

Root

The unit that includes the location from which the patient was referred.

REFERRING_ZIPCODE

Referring Zip Code

Root

The zip code of the health care facility that requests a transfer for a patient.

REQUESTED_LEVEL_OF_CARE

REQUESTED_LEVEL_OF_CARE

Root

This is the level of care that the referring facility/referring provider has requested is needed for the patient. This data point can come from Referral IQ® and/or be populated from within the Transfer IQ® application on the Patient Tab of the Patient's Case Record. Note: This may be the same or different as the Level of Care indicated at the time of bed request or the Level of Care noted at the time of the patient's admission.

REQUESTED_TO_ASSIGNED_TIME

Requested to Assigned Time

Root

The duration from when a bed was requested until a bed was assigned to the patient. Calculation: Bed Assigned Timestamp minus Bed Requested Timestamp

REQUESTED_TO_OCCUPIED_TIME

Requested to Occupied Time

Root

The duration from when a bed was requested for a patient until the patient physically occupied the bed. Calculation: Bed Occupied Timestamp minus Bed Requested Timestamp

RETURN_PATIENT_TO_REFERRING_FACILITY

Return Patient To Referring Facility

Root

A flag indicating if the 'Return patient to referring facility upon completion of case' checkbox is currently selected.

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.

SECONDARY_PAYOR

Secondary Payor

Root

The name of the health insurance carrier that takes second responsibility to pay for the patient's care.

SECONDARY_PAYOR_CATEGORY

Secondary Payor Category

Root

The grouping of health insurance carriers that the secondary payor belongs to.

SERVICE_LINE

Service Line

Root

The type of treatment or surgery for the patient (i.e., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line. The service line is derived from the specialty in the case, and the associated service line configured in the data dictionary.

SERVICE_OFFERED_AT_REFERRING_FACILITY

Service Offered At Referring Facility

Root

A flag indicating if the checkbox is currently selected for "The referring facility offers this service"

SOURCE

Source

Root

The application where the transfer case originated. Values: If the case was created in Transfer IQ®, source = TC

If the case was created by importing a referral, source = CAP

TENANTID

Tenantid

System Calc

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

TERTIARY_PAYOR

Tertiary Payor

Root

The name of the health insurance carrier that takes third responsibility to pay for the patient's care.

TERTIARY_PAYOR_CATEGORY

Tertiary Payor Category

Root

The grouping of health insurance carriers to which the tertiary payor belongs.

N/A

Time to Accept

Custom Calc

The difference in time (in minutes) between the Case Created Date and the Case Disposition Timestamp

DATEDIFF('minute', [Case Created Date],[Case Disposition Timestamp])

N/A

Time To Accept Colors

Custom Calc

Used to define the colors for the difference in time (in minutes) between the Case Created Date and the Case Disposition Timestamp

IF AVG([Time to Accept]) > 15 THEN "Red"

ELSEIF AVG([Time to Accept]) <= 15 THEN "Green"

ELSE "no data" END

TRANSFER_ID

Transfer Id

System Calc

A unique identifier of the transfer center case. This is not intended for client report building.

TRANSPORT_ARRIVAL_DATETIME

Transport Arrival Datetime

Root

The platform date/time recorded for the patient arrival.

TRANSPORT_ARRIVAL_DATETIME_UTC

Transport Arrival Datetime UTC

Root

The UTC date/time recorded for the patient arrival.

TRANSPORT_DIRECTED_TO

Transport Directed To

Root

The value recorded for the 'Directed to field'. This is typically the place or location transport is directed to.

TRANSPORT_DISPATCH_DATETIME

Transport Dispatch Datetime

Root

The platform date/time recorded for transport dispatch.

TRANSPORT_DISPATCH_DATETIME_UTC

Transport Dispatch Datetime UTC

Root

The UTC date/time recorded for transport dispatch.

TRANSPORT_ETA

Transport ETA

Root

The platform date/time recorded for transport ETA.

TRANSPORT_ETA_UTC

Transport ETA UTC

Root

The UTC date/time recorded for transport ETA.

TRANSPORT_MODE

Transport Mode

Root

The transport mode recorded for the transfer case.

TREATMENTS

TREATMENTS

Root

The treatments recorded for the transfer case. If multiple treatments are recorded in a given transfer case, they will be all be included as comma seperated values

VISIT_NUMBER

Visit Number

Root

The identifier recorded for one of the patient's hospital stays.

N/A

Volume

Custom Calc

Each row in this data set is 1. When this field is aggregated, it can be used to show the sum, average, etc volume for a given period of time, or by other dimension fields.

WAREHOUSEACQUISITIONDATE_UTC

WAREHOUSEACQUISITIONDATE_UTC

System Calc

The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.