Tables [dbo].[Document_RFR_Mapper]
"Reason for Referral" associated with a document.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Document_RFR_Mapper_ID: IDIDbigint8NOT NULL1 - 1Key to the Document_RFR_Mapper table.
Indexes NIX_Document_RFR_Mapper_PatientIDForeign Keys FK_Document_RFR_Mapper_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
ProviderID[dbo].[uniqueid]9NOT NULLProvider. Link to Provider.ID.
EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
DocumentID[dbo].[uniqueid]9NOT NULLDocument. Link to Document.DocumentID.
ReasonForReferralvarchar(2000)2000NOT NULLReason for Referral text entered by the user
RecordedDTTMdatetime8NOT NULL(getdate())Date the RFR was created.