| observationguid | varchar | Unique identifier for the referral, shared with the parent observation in CareRecord_Observation. Part of the composite primary key. | {N4O5P6Q7-R8S9-0123-TUVW-234567890123} | 38 | False |
| patientguid | varchar | References the referred patient in Admin_Patient. | {F6A7B8C9-D0E1-2345-FABC-456789012345} | 38 | False |
| organisationguid | varchar | References the referring practice in Admin_Organisation. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| referraltargetorganisationguid | varchar | References the organisation to which the patient is referred. | {Q7R8S9T0-U1V2-3456-WXYZ-567890123456} | 38 | False |
| referralurgency | varchar | Urgency level of the referral (e.g., Routine, Soon, Urgent, 2 Week Wait). | Routine | 50 | True |
| referralservicetype | varchar | The type of service the patient is being referred to (e.g., Cardiology, Physiotherapy). | Inbound | 100 | True |
| referralmode | varchar | The mode of the referral (e.g., Written, Electronic, Telephone). | Written | 100 | True |
| referralreceiveddate | | The date the referral was received by the target organisation. Currently unavailable. | | | True |
| referralreceivedtime | | The time the referral was received by the target organisation. Currently unavailable. | | | True |
| referralenddate | | The date the referral episode closed. Currently unavailable. | | | True |
| referralsourceid | | Identifier for the source of the referral. Currently unavailable. | | | True |
| referralsourceorganisationguid | | References the organisation from which the referral originated. Currently unavailable. | | | True |
| referralubrn | char | Unique Booking Reference Number assigned to the referral. | 123456978965 | 12 | True |
| referralreasoncodeid | | References the clinical code describing the reason for the referral. Currently unavailable. | | | True |
| referringcareprofessionalstaffgroupcodeid | | References the staff group code of the referring care professional. Currently unavailable. | | | True |
| referralepisoderttmeasurementtypeid | | The RTT (Referral to Treatment) measurement type identifier. Currently unavailable. | | | True |
| referralepisodeclosuredate | | The date the RTT episode was closed. Currently unavailable. | | | True |
| referralepisodedischargeletterissueddate | | The date the discharge letter was issued. Currently unavailable. | | | True |
| referralclosurereasoncodeid | | References the clinical code for the reason the referral was closed. Currently unavailable. | | | True |
| transportrequired | varchar | Indicates whether patient transport is required. | Transport Required | 20 | False |