Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Referral_Org_Details
Touchworks 25.2
[dbo].[Referral_Org_Details]
MS_Description
Referral organization name and NPI details
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to the Referral_Org_Details table.
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID.
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID.
DocumentID
[dbo].[uniqueid]
9
NOT NULL
Document. Link to Document.DocumentID.
OrganizationID
[dbo].[dict_id]
5
NOT NULL
Organization. Link to Organization.ID.
ProviderOrganizationName
varchar(100)
100
NULL allowed
Referral Organization Name
NPI
varchar(20)
20
NULL allowed
Referral NPI
ReferralID
[dbo].[uniqueid]
9
NULL allowed
Referral ID
CreatedDTTM
datetime
8
NULL allowed
Created date time