Tables [dbo].[Referral_Org_Details]
Referral organization name and NPI details
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Referral_Org_Details_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Referral_Org_Details table.
Indexes NIX_Referral_Org_Details_PatientIDForeign Keys FK_Referral_Org_Details_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
DocumentID[dbo].[uniqueid]9NOT NULLDocument. Link to Document.DocumentID.
OrganizationID[dbo].[dict_id]5NOT NULLOrganization. Link to Organization.ID.
ProviderOrganizationNamevarchar(100)100NULL allowedReferral Organization Name
NPIvarchar(20)20NULL allowedReferral NPI
ReferralID[dbo].[uniqueid]9NULL allowedReferral ID
CreatedDTTMdatetime8NULL allowedCreated date time