Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Document_RFR_Mapper
Touchworks 25.2
[dbo].[Document_RFR_Mapper]
MS_Description
"Reason for Referral" associated with a document.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
bigint
8
NOT NULL
1 - 1
Key to the Document_RFR_Mapper table.
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID.
ProviderID
[dbo].[uniqueid]
9
NOT NULL
Provider. Link to Provider.ID.
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID.
DocumentID
[dbo].[uniqueid]
9
NOT NULL
Document. Link to Document.DocumentID.
ReasonForReferral
varchar(2000)
2000
NOT NULL
Reason for Referral text entered by the user
RecordedDTTM
datetime
8
NOT NULL
(getdate())
Date the RFR was created.