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) |