This article provides descriptions of CSV referral file data per each column of the CSV export. The CSV export is available to Admin level users on the Appointment and Referral tabs.
________________________________________________________________________________________
| Data Element | Field Type/Description |
| Referral ID | Alpha Numeric | Unique ID for the referral appointment (generated by Alluvium) |
| Created Date | Alpha Numeric | Date and Time referral was created (generated by Alluvium) |
| 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 Alluvium) |
| 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 Alluvium) |
| Appointment Updated Date | Alpha Numeric | Date appointment was updated (generated by Alluvium) |
| 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 Alluvium) |
| Source | Alpha | source (generated within Alluvium's API's or externally) |