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