CSV Referral File Data Elements and Descriptions – Blockit Now, Inc.

This article provides descriptions of CSV referral file data per each column of the CSV export.

Data Element	Field Type/Description
Referral ID	Alpha Numeric \| Unique ID for the referral appointment (generated by blockit)
Created Date	Alpha Numeric \| Date and Time referral was created (generated by blockit)
Created By User	Alpha Numeric \| Created by user email address
Created By	Alpha \| Name of user
Type	Alpha \| Type of referral (eg. Referral, Sent to Unlisted Provider)
Patient MRN	Alpha Numeric \| Unique identifier for patient
Patient First Name	Alpha \| Patient First Name
Patient Middle Name	Alpha \| Patient Middle Name
Patient Last Name	Alpha \| Patient Last Name
Patient Address	Alpha Numeric \| Patient Address Line 1
Patient Address 2	Alpha Numeric \| Patient Address Line 2
Patient City	Alpha \| Patient City
Patient State	Alpha \| Patient State
Patient Postal Code	Numeric \| Patient Zip Code
Patient Gender	Alpha \| Patient Gender
Patient DOB	Numeric \| Patient Date of Birth
Patient Phone	Numeric \| Patient Phone Number
Patient Email	Alpha Numeric \| Patient Email Address
Patient Insurance Carrier	Alpha Numeric \| Patient Insurance Carrier
Patient Insurance Plan	Alpha Numeric \| Patient Insurance Plan
Patient Insurance Group ID	Alpha Numeric \| Patient Insurance Group ID
Patient Insurance Plan ID	Alpha Numeric \| Patient Plan ID
Referral Specialty	Alpha \| Referral Provider Specialty
Referral Procedure	Alpha \| Referral Provider Procedure
Referral Diagnosis	Alpha \| Referral Provider Diagnosis
Referral Cancelled by User	Alpha Numeric \| User email address for cancellation
Referral Cancelled At	Alpha Numeric \| Date and Time referral was cancelled (generated by blockit)
Referral Cancel Reason	Alpha Numeric \| Reason Referral was cancelled
Sending Organization	Alpha \| Sending organization
Sending Provider	Alpha \| Sending provider name
Sending Provider NPI	Numeric \| Sending provider NPI number
Sending Location	Alpha \| Sending provider location
Receiving Organization	Alpha \| Sending provider organization
Receiving Profile	Alpha Numeric \| Receiving profile name
Receiving Profile NPI	Numeric \| Receiving profile NPI number
Receiving Profile Location	Alpha \| Receiving profile location
Appointment Created Date	Alpha Numeric \| Date appointment was created (generated by blockit)
Appointment Updated Date	Alpha Numeric \| Date appointment was updated (generated by blockit)
Appointment Date	Numeric \| Date appointment is set
Appointment Time Stamp	Alpha Numeric \| Date and time that appointment is set
Appointment Status	Alpha \| Status of appointment
Notes	Alpha Numeric \| Any referral notes
Results	Alpha Numeric \| Any referral results
Questionnaire Answers *If applicable	Alpha Numeric \| Answers to questionnaire(s)
Workflow Queue Tasks *If applicable	Alpha \| Workflow queue name and status of the task (e.g Scheduling Queue: finished)
Encounter ID *If applicable	Alpha Numeric \| Specific identifier
External ID *If applicable	Alpha \| Numeric \| Referral specific identifier
External Source *If applicable	Alpha \| Source of referral
External Specialty *If applicable	Alpha \| Provider Specialty
Preferred Provider *If applicable	Alpha \| Referred provider name
Preferred Provider Group *If applicable	Alpha \| Referred provider group
Preferred Provider NPI *If applicable	Numeric \| NPI number of preferred provider
Provider Mnemonic *If applicable	Alpha \| Unique mnemonic of provider
Searched at	Alpha Numeric \| When referral was searched (generated by blockit)
Source	Alpha \| source (generated within blockit's API's or externally)

We are happy to help! For additional support, please contact support@blockitnow.com

Related articles