Report Summary

Need help figuring out what this report is and what it contains? Below you will find a brief report description as well as necessary data definitions.

The Healthify De-Identified Referrals Extract enables customers of Track and Coordinate to receive automatic exports of referrals created within Healthify during the report's date range, excluding identifiable patient information. Customers may receive this file on a selected time interval (typically monthly or weekly) delivered as a zipped CSV file via either email or SFTP upload.

Each row represents a single referral that was created within Healthify, and the file will be filtered by the Network or Company, as well as the defined time interval (month, week, day, etc.) of Referral Created Date. The rows will be sorted in chronological order based on the Referral Created Time.

It is best practice to configure this report to be sent at least 2 weeks after the specified time period ends if the customer is interested in using this data to get a picture of the status of referrals, to ensure there is ample time for end users to review and process referrals after they have been created. A standard configuration is to distribute a monthly interval file on the 15th of the following month.

Data Definitions

Fields are listed in the order they appear in the De-Identified Referrals Extract.

Referral ID: The unique identifier of the referral. This is a numeric ID that is also visible in the Healthify application.

Referral UUID: The secure unique identifier of the referral. (Note: This is provided primarily for troubleshooting purposes, but serves the same purpose in data analysis as the Referral ID, to uniquely identify a referral.)

Referral Created Date: The date when the referral was created in the company or network's time zone. Formatted YYYY-MM-DD.

Referral Created Time: The complete date and time when the referral was created in the company or network's time zone. Formatted in 24-hour time.

Referring User ID: The unique identifier of the user who created the referral.

Referring User First Name: The current first name of the user who created the referral. (Note: If the user's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

Referring User Last Name: The current last name of the user who created the referral. (Note: If the user's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

Referring Team ID: The unique identifier of the team of the user who created the referral at the time of referral creation.  A team is a group of users which belongs to a company. (Note: If the referring user has changed teams after creating the referral, this value will still represent the user's team when the referral was created, not the user's current team.)

Referring Team Name: The current name of the team of the user who created the referral at the time of referral creation.  A team is a group of users which belongs to a company. (Note: If the team's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

Referring Company ID: The unique identifier of the company of the user who created the referral at the time of referral creation. (Note: If the referring user has changed companies after creating the referral, this value will still represent the user's company when the referral was created, not the user's current company.)

Referring Company Name:
The current name of the company of the user who created the referral at the time of referral creation. (Note: If the company's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

Receiving Service ID: The unique identifier of the service to which the referral was made. A "service" is a specific social service or program provided by a community organization at one or more locations. Referrals are made to a single service at a single location.

Receiving Service Name: The current name of the service to which the referral was made. A "service" is a specific social service or program provided by a community organization at one or more locations. (Note: If the service's name has changed at any point, this value will represent the current name as of the time that the report was pulled.)

Receiving Location ID: The unique identifier of the location to which the referral was made. A "location" is a specific place where a community organization provides services. Only present if the receiving organization has an address or a location.

Receiving Location Address Line 1: The first line of the location’s address to which the referral was made.

Receiving Location Address Line 2: The second line of the location’s address to which the referral was made.

Receiving Location City: The city of the location’s address to which the referral was made.

Receiving Location State: The state of the location’s address to which the referral was made.

Receiving Location Zip Code: The zip code of the location’s address to which the referral was made.

Receiving Location Phone Number: The phone number of the location to which the referral was made.

Receiving Location Phone Extension: The phone number extension of the location to which the referral was made. Only present if there is an extension.

Receiving Organization ID: The unique identifier of the organization which currently owns the service and location to which the referral was made. An "organization" is an entity which provides community or social services and may optionally own services and locations.

Receiving Organization Name: The current name of the organization which currently owns the service and location to which the referral was made. An "organization" is an entity which provides community or social services and may optionally own services and locations.

Receiving Company ID: The current Company ID of the service and location that the referral was sent to. Only present for Coordinate referrals.

Receiving Company Name: The current Company Name of the service and location that the referral was sent to. Only present for Coordinate referrals.

Client UUID: The unique identifier of the client for which the referral was made.

Client Gender: The current gender of the client for which the referral was made. (Note: Gender is not required for clients.)

Client Year of Birth: The current year of birth of the client for which the referral was made, using HIPAA de-identification standards. Clients older than age 89 are grouped into a single group with the following format: "YYYY or Before".

Client 3-Digit Zip Code: The current zip code of the client for which the referral was made, using HIPAA de-identification standards. All client zip codes in US are grouped together by the first three digits. For groupings with less than 20,000 people, the zip code is changed to "000." For groupings with 20,000 people or more, the three digits are shown. (Note: Zip code is not required for clients.)

Referral Type: Whether the referral was a Track or Coordinate referral. Track referrals represent referrals logged within the Healthify platform to services that do not participate in the specified Coordinate network. Coordinate referrals represent referrals sent to services that participate in the specified Coordinate network.

Referral Current Status Name: The status of the referral as of the time that the report was pulled. Values are "Unstarted", "In-Review", "Service In-Progress", "Service Completed", or "Canceled."

Referral Current Status Created Date: The date when the referral current status was created in the company or network's time zone. Formatted YYYY-MM-DD.

Referral Current Status Created Time: The complete date and time when the referral current status was created in the company or network's time zone. Formatted in 24-hour time.

Referral Current Cancelation Context: The reason for cancelation provided by the user. Only present if the referral current status is "Canceled."

Service Offering Name List: The service offering(s) the user selected for the referral. Values come from Healthify's Service Offerings taxonomy. Users may select zero, one, or many service offerings for a referral from a list of all service offerings associated with the receiving service. Provided as a comma-separated list sorted in alphabetical order.

For example, the service "St. Alexander's Food Pantry" may be tagged with the service offerings "Food pantries" and "Affordable food." When referring to this service, the user may select "Affordable food" for the referral to indicate the specific service offering(s) to which they are referring their client.

Service Offering Count: The number of service offerings the user selected for the referral.

Service Offering Category Name List: The social determinants of health (SDoH) domain category(ies) of the user-selected service offerings for the referral. Values come from Healthify's Service Offerings taxonomy. Provided as a comma-separated list sorted in alphabetical order.

Each service offering belongs to one category for reporting purposes. Categories which contain multiple service offerings connected to the referral will only appear once. For example, if the service offerings list shows "Affordable food" and "Food pantries", both of which are within the "Food" category, the Service Offerings Categories List will display "Food."

Service Offering Category Count: The number of social determinants of health (SDoH) domain category(ies) of the user-selected service offerings for the referral.

Client Population Name List: The population tags of the client. Population tags are customizable per Company.

Client Intervention Name List: The intervention tags of the client. Intervention tags are customizable per Company.

Questions? We're here to help. Email us at support@healthify.us or message us in the In-App chat at the bottom right corner of every screen in the Healthify platform.

Did this answer your question?