Tables [dbo].[Referring_Provider_DE]
Referring Providers
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Referring_Provider_DE_ID: IDIndexes TWstat_Referring_Provider_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_DistributionTypeDE_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_FirstName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_IsCurrentFLAG_EntryName_ID, TWstat_Referring_Provider_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_LastName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_MiddleName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_SpecialtyDE_EntryName_IsCurrentFLAG_ID(9)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Referring_Provider_DE table.
Indexes TWstat_Referring_Provider_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_IDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Referring_Provider_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Referring_Provider_DE_EntryCode_WithIncludeColumns, NIX_Referring_Provider_DE_EntryMnemonic_WithIncludeColumns, NIX_Referring_Provider_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.
Indexes NIX_Referring_Provider_DE_EntryCode_WithIncludeColumns, NIX_Referring_Provider_DE_EntryMnemonic_WithIncludeColumns, NIX_Referring_Provider_DE_EntryName_WithIncludeColumns, TWstat_Referring_Provider_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_DistributionTypeDE_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_FirstName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_IsCurrentFLAG_EntryName_ID, TWstat_Referring_Provider_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_LastName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_MiddleName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_SpecialtyDE_EntryName_IsCurrentFLAG_ID(12)EntryName[dbo].[name]255NOT NULLEntryName (sometimes firstname + lastname). Some clients do not use the dedicated first and lastname boxes in the app and instead just write them both here. Our code falls back to entryname if first/last fields aren't used.
Indexes NIX_Referring_Provider_DE_EntryCode_WithIncludeColumns, NIX_Referring_Provider_DE_EntryMnemonic_WithIncludeColumns, NIX_Referring_Provider_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes NIX_Referring_Provider_DE_EntryCode_WithIncludeColumns, NIX_Referring_Provider_DE_EntryMnemonic_WithIncludeColumns, NIX_Referring_Provider_DE_EntryName_WithIncludeColumns, TWstat_Referring_Provider_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Referring_Provider_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Check Constraints CK_Referring_Provider_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Referring_Provider_DE_EntryCode_WithIncludeColumns, NIX_Referring_Provider_DE_EntryMnemonic_WithIncludeColumns, NIX_Referring_Provider_DE_EntryName_WithIncludeColumns, TWstat_Referring_Provider_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_DistributionTypeDE_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_FirstName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_IsCurrentFLAG_EntryName_ID, TWstat_Referring_Provider_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_LastName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_MiddleName_EntryName_IsCurrentFLAG_ID, TWstat_Referring_Provider_DE_SpecialtyDE_EntryName_IsCurrentFLAG_ID(12)Check Constraints CK_Referring_Provider_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
PhoneAreasmallint2NOT NULL(0)3 digit phone area
PhoneExchangesmallint2NOT NULL(0)3 digit phone exchange
PhoneLast4smallint2NOT NULL(0)last 4 digits of phone number
PhoneExtension[dbo].[extension]5NOT NULL('')phone extension
PhoneInternational[dbo].[int_phone]21NOT NULL('')For international phone numbers
AddressLine1varchar(255)255NULL allowed('')Providers address
AddressLine2varchar(255)255NULL allowed('')Extra address field
Cityvarchar(35)35NOT NULL('')City
Statevarchar(15)15NOT NULL('')State
ZipCodechar(10)10NOT NULL('')Zip Code
ZipCodeInternationalvarchar(14)14NOT NULL('')International Zip Code
Countryvarchar(30)30NOT NULL('')Country
Countyvarchar(35)35NOT NULL('')County
FaxAreasmallint2NOT NULL(0)3 digit Fax Area Code
FaxExchangesmallint2NOT NULL(0)3 digit Fax Exchange
FaxLast4smallint2NOT NULL(0)last 4 digits of fax number
FaxExtension[dbo].[extension]5NOT NULL('')fax extension
FaxInternational[dbo].[int_phone]21NOT NULL('')international fax number
Indexes TWstat_Referring_Provider_DE_SpecialtyDE_EntryName_IsCurrentFLAG_IDForeign Keys FK_Referring_Provider_SpecialtyDE: [dbo].[Specialty_DE].SpecialtyDESpecialtyDE[dbo].[dict_id]5NOT NULL(0)Specialty. Key to the Specialty_DE table
Indexes TWstat_Referring_Provider_DE_LastName_EntryName_IsCurrentFLAG_IDLastNamevarchar(35)35NOT NULL('')Providers last name, not required in app as it will use entryname if this isn't set
Indexes TWstat_Referring_Provider_DE_FirstName_EntryName_IsCurrentFLAG_IDFirstNamevarchar(35)35NOT NULL('')Providres first name, not required in app as it will use entryname if this isn't set.
Indexes TWstat_Referring_Provider_DE_MiddleName_EntryName_IsCurrentFLAG_IDMiddleNamevarchar(35)35NOT NULL('')Providers middle name, not required
SuffixNamevarchar(18)18NOT NULL('')name suffex, for example Sr. or Jr.
PrefixNamevarchar(18)18NOT NULL('')name prefix
AddressLine3varchar(35)35NOT NULL('')Another extra address field
LinkedProviderID[dbo].[uniqueid]9NOT NULL(0)Link to the corresponding Provider (if there is one).
Indexes TWstat_Referring_Provider_DE_DistributionTypeDE_EntryName_IsCurrentFLAG_IDDistributionTypeDE[dbo].[dict_id]5NOT NULL(0)Distribution Type for print/fax/task CC type. Link to Distribution_Type_DE.ID.
Indexes NIX_Referring_Provider_DE_NPINPIvarchar(10)10NOT NULL('')10 digit NPI number (National Provider Identifier).
EmailAddressvarchar(255)255NOT NULL('')Email Address
Check Constraints CK_Referring_Provider_DE_IsPracticeFLAG_Yes_Or_No : ([IsPracticeFLAG]='N' OR [IsPracticeFLAG]='Y')IsPracticeFLAG[dbo].[BOOL]1NOT NULL('N')Is this an entry for a practice instead of an individual provider?
Check Constraints CK_Referring_Provider_DE_IsAgencyFLAG_Yes_Or_No : ([IsAgencyFLAG]='N' OR [IsAgencyFLAG]='Y')IsAgencyFLAG[dbo].[BOOL]1NOT NULL('N')Is this an entry for an agency instead of an individual provider?
Foreign Keys FK_Referring_Provider_DE_SexDE: [dbo].[Sex_DE].SexDESexDE[dbo].[dict_id]5NOT NULL((0))Gender. Key to the Sex_DE table.
LanguageDEListvarchar(255)255NOT NULL('')Languages spoken. List of Language_DE.ID values.
Mobilevarchar(25)25NOT NULL('')mobile phone number
Foreign Keys FK_Referring_Provider_DE_LinkedUserID: [dbo].[IDX_User].LinkedUserIDLinkedUserID[dbo].[uniqueid]9NOT NULL((0))Linked User (if there is one). Key to the IDX_User Table
CredentialDEListvarchar(255)255NOT NULL('')Credentials. Comma separated list of Credential_DE.ID values.