Tables [dbo].[Provider]
Provider. Changes to the provider account can be made in TWAdmin->TWUserAdmin, via SSMT, or via a FileProvider interface. A "Provider" only account will just have a record in the dbo.Person and dbo.Provider table. If it's a "user/provider" account then it will also have a record in the dbo.IDX_User table.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Provider_ID: IDIndexes nix_Provider_EntryMnemonic_ID, xAK1Provider, NIX_Provider_ResourceDEIDSecurityCodeDE, TWstat_Provider_AlternateLicense_ID, TWstat_Provider_BillingProviderID_ID, TWstat_Provider_ClinicalMsgFLAG_ID, TWstat_Provider_CMEPilotNumber_ID, TWstat_Provider_CompleteDictationTaskFLAG_ID, TWstat_Provider_DEANumber_ID, TWstat_Provider_DifficultyFactor_ID, TWstat_Provider_DisableSendChargeFLAG_ID, TWstat_Provider_DistributionTypeDE_ID, TWstat_Provider_ExpirationDT_ID, TWstat_Provider_IsBillingProviderFLAG_ID, TWstat_Provider_IsInactiveFLAG_ID, TWstat_Provider_IsPCPFLAG_ID, TWstat_Provider_LastEditedDTTM_ID, TWstat_Provider_MedEducNumber_ID, TWstat_Provider_OrderingAuthorityDE_ID, TWstat_Provider_OutboundDictateID_ID, TWstat_Provider_PaIEnrollmentStatus_ID, TWstat_Provider_PrimaryContactPersonID_ID, TWstat_Provider_PrimaryOfficeDE_ID, TWstat_Provider_PrimaryServiceDE_ID, TWstat_Provider_ProviderKeyEXT_ID, TWstat_Provider_ProviderTypeDE_ID, TWstat_Provider_RecordingFormatDE_ID, TWstat_Provider_ResourceID_ID, TWstat_Provider_RXAuthorityDE_ID, TWstat_Provider_RxSupervisionRequired_ID, TWstat_Provider_SCHED_C_I_IND_ID, TWstat_Provider_SCHED_C_II_IND_ID, TWstat_Provider_SCHED_C_III_IND_ID, TWstat_Provider_SCHED_C_IV_IND_ID, TWstat_Provider_SCHED_C_V_IND_ID, TWstat_Provider_SecuritycodeDE_ID, TWstat_Provider_Specialty2DE_ID, TWstat_Provider_SpecialtyDE_ID, TWstat_Provider_V4OrderingAuthority_ID(39)Foreign Keys FK_Provider_ID_Person_ID: [dbo].[Person].IDID[dbo].[uniqueid]9NOT NULLProvider Identifier. Link to Person.ID.
Indexes xAK1Provider, TWstat_Provider_ProviderTypeDE_ID(2)Foreign Keys FK_Provider_ProviderTypeDE_Provider_Type_DE_ID: [dbo].[Provider_Type_DE].ProviderTypeDEProviderTypeDE[dbo].[dict_id]5NOT NULLType. Link to Provider_Type_DE.ID
Indexes TWstat_Provider_PrimaryContactPersonID_IDPrimaryContactPersonID[dbo].[uniqueid]9NOT NULLNot used.
Indexes NIX_Provider_IsInactiveFLAG_IsBillingProviderFLAG_WithIncludeColumns, NIX_Provider_ResourceDEIDSecurityCodeDE(2)Foreign Keys FK_Provider_ResourceDE_Resource_DE_ID: [dbo].[Resource_DE].ResourceDEResourceDE[dbo].[dict_id]5NOT NULLScheduling Resource. Link to dbo.Resource_De.id (for linking to a schedule)
Indexes TWstat_Provider_PrimaryServiceDE_IDForeign Keys FK_Provider_PrimaryServiceDE_Service_DE_ID: [dbo].[Service_DE].PrimaryServiceDEPrimaryServiceDE[dbo].[dict_id]5NOT NULLProimary Service. Link to Service_DE.ID.
Indexes TWstat_Provider_PrimaryOfficeDE_IDForeign Keys FK_Provider_PrimaryOfficeDE_Location_DE_ID: [dbo].[Location_DE].PrimaryOfficeDEPrimaryOfficeDE[dbo].[dict_id]5NOT NULLPrimary scheduling location. Link to Location_DE.ID.
Indexes xAK1Provider, NIX_Provider_ResourceDEIDSecurityCodeDE, NIX_Provider_SpecialtyDE, TWstat_Provider_SpecialtyDE_ID(4)Foreign Keys FK_Provider_SpecialtyDE_Specialty_DE_ID: [dbo].[Specialty_DE].SpecialtyDESpecialtyDE[dbo].[dict_id]5NOT NULLSpecialty. Link to Specialty_DE.ID.
UPINNumbervarchar(20)20NOT NULLUPIN number
Indexes TWstat_Provider_IsPCPFLAG_IDCheck Constraints CK_Provider_IsPCPFLAG_Yes_Or_No : ([IsPCPFLAG]='N' OR [IsPCPFLAG]='Y')IsPCPFLAG[dbo].[BOOL]1NOT NULLPrimary Care Provider? Y/N
Indexes XAK2ProviderEntryCodechar(16)16NOT NULLentry code
Indexes nix_Provider_EntryMnemonic_IDEntryMnemonicchar(10)10NOT NULL(' ')mnemonic
Indexes TWstat_Provider_ProviderKeyEXT_IDProviderKeyEXTvarchar(15)15NOT NULL(' ')Not used.
Indexes TWstat_Provider_ExpirationDT_IDExpirationDTdatetime8NULL allowedDEA expiration date. This was migrated over to the dbo.Prescriber_License table so accomadate different dates for different orgs. We still set it here in some circumstances though. It ends up being the last value you set it to. If a clinic is single org then the ETL will just utilize this value. If they are multi-org then they will use a different set of scripts to pull from dbo.Prescriber_License.
Indexes NIX_Provider_IsInactiveFLAG_IsBillingProviderFLAG_WithIncludeColumns, NIX_Provider_ResourceDEIDSecurityCodeDE, TWstat_Provider_IsInactiveFLAG_ID(3)Check Constraints CK_Provider_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLInActive? Y/N
Indexes TWstat_Provider_OrderingAuthorityDE_IDOrderingAuthorityDE[dbo].[dict_id]5NULL allowedOrdering Authority. Link to dbo.Ordering_Authority_De.id
Indexes TWstat_Provider_DEANumber_IDDEANumbervarchar(30)30NOT NULL(' ')Providers DEA number
Indexes TWstat_Provider_DisableSendChargeFLAG_IDCheck Constraints CK_Provider_DisableSendChargeFLAG_Yes_Or_No : ([DisableSendChargeFLAG]='N' OR [DisableSendChargeFLAG]='Y')DisableSendChargeFLAG[dbo].[BOOL]1NOT NULL('N')Y/N Controls the "Submit Enc Form Task" which can be created automatically if charges haven't been submited for an appt encounter.
Indexes TWstat_Provider_CompleteDictationTaskFLAG_IDCheck Constraints CK_Provider_CompleteDictationTaskFLAG_Yes_Or_No : ([CompleteDictationTaskFLAG]='N' OR [CompleteDictationTaskFLAG]='Y')CompleteDictationTaskFLAG[dbo].[BOOL]1NOT NULL('N')Y/N Receive a task if you create a marker in a note and haven't submitted a dictation against it yet.
Indexes TWstat_Provider_BillingProviderID_IDBillingProviderIDvarchar(32)32NOT NULL('')Used to hold the billing provider ID of the provider in the PM system
Indexes TWstat_Provider_ResourceID_IDResourceIDvarchar(32)32NOT NULL('')No Longer Used
Indexes NIX_Provider_IsInactiveFLAG_IsBillingProviderFLAG_WithIncludeColumns, TWstat_Provider_IsBillingProviderFLAG_ID(2)Check Constraints CK_Provider_IsBillingProviderFLAG_Yes_Or_No : ([IsBillingProviderFLAG]='N' OR [IsBillingProviderFLAG]='Y')IsBillingProviderFLAG[dbo].[BOOL]1NOT NULL('N')Billing Provider? Y/N
Indexes TWstat_Provider_RXAuthorityDE_IDRXAuthorityDE[dbo].[dict_id]5NULL allowedPrescribing Authority Level. Link to dbo.Rx_Authority_De.id
Indexes TWstat_Provider_V4OrderingAuthority_IDV4OrderingAuthorityint4NULL allowed(1)0 (low) to 10 (high) rating to control what kind of orders a provider can order.
Indexes NIX_Provider_IsInactiveFLAG_IsBillingProviderFLAG_WithIncludeColumns, NIX_Provider_ResourceDEIDSecurityCodeDE, TWstat_Provider_SecuritycodeDE_ID(3)SecuritycodeDE[dbo].[dict_id]5NOT NULL(0)Link to dbo.Security_Code_DE.ID. If the provider's schedule is secure, then this is the security code you would need to assign to users who need access to his/her schedule.
Indexes nix_Provider_OutboundDictateID, TWstat_Provider_OutboundDictateID_ID(2)OutboundDictateIDvarchar(12)12NULL allowedA unique ID given to providers who dictate. It provides a way for external transcription/dictation systems to map to.
Indexes TWstat_Provider_CMEPilotNumber_IDCMEPilotNumbervarchar(10)10NULL allowedNot used.
Indexes TWstat_Provider_SCHED_C_I_IND_IDCheck Constraints CK_Provider_SCHED_C_I_IND_Yes_Or_No : ([SCHED_C_I_IND]='N' OR [SCHED_C_I_IND]='Y')SCHED_C_I_INDchar(1)1NOT NULL('N')Can the provider prescribe schedule I meds
Indexes TWstat_Provider_SCHED_C_II_IND_IDCheck Constraints CK_Provider_SCHED_C_II_IND_Yes_Or_No : ([SCHED_C_II_IND]='N' OR [SCHED_C_II_IND]='Y')SCHED_C_II_INDchar(1)1NOT NULL('N')Can the provider prescribe schedule II  meds
Indexes TWstat_Provider_SCHED_C_III_IND_IDCheck Constraints CK_Provider_SCHED_C_III_IND_Yes_Or_No : ([SCHED_C_III_IND]='N' OR [SCHED_C_III_IND]='Y')SCHED_C_III_INDchar(1)1NOT NULL('N')Can the provider prescribe schedule III meds
Indexes TWstat_Provider_SCHED_C_IV_IND_IDCheck Constraints CK_Provider_SCHED_C_IV_IND_Yes_Or_No : ([SCHED_C_IV_IND]='N' OR [SCHED_C_IV_IND]='Y')SCHED_C_IV_INDchar(1)1NOT NULL('N')Can the provider prescribe schedule IV meds
Indexes TWstat_Provider_SCHED_C_V_IND_IDCheck Constraints CK_Provider_SCHED_C_V_IND_Yes_Or_No : ([SCHED_C_V_IND]='N' OR [SCHED_C_V_IND]='Y')SCHED_C_V_INDchar(1)1NOT NULL('N')Can the provider prescribe schedule V meds
Indexes TWstat_Provider_ClinicalMsgFLAG_IDCheck Constraints CK_Provider_ClinicalMsgFLAG_Yes_Or_No : ([ClinicalMsgFLAG]='N' OR [ClinicalMsgFLAG]='Y')ClinicalMsgFLAG[dbo].[BOOL]1NOT NULL('Y')Y/N
Indexes TWstat_Provider_RxSupervisionRequired_IDCheck Constraints CK_Provider_RxSupervisionRequired_Yes_Or_No : ([RxSupervisionRequired]='N' OR [RxSupervisionRequired]='Y')RxSupervisionRequired[dbo].[BOOL]1NOT NULL('N')Prescibing Supervision required? Y/N
Indexes TWstat_Provider_DifficultyFactor_IDDifficultyFactornumeric(2,1)5NULL allowed(1.0)0-10 rating for prescribers speech rating. Higher the rating the more difficult it is to hear the provider and the more pay transcriptionists get for this provider.
Indexes TWstat_Provider_AlternateLicense_IDAlternateLicensevarchar(30)30NULL allowedAlternate License
Indexes Portal_Provider, TWstat_Provider_LastEditedDTTM_ID(2)LastEditedDTTMdatetime8NULL allowed(getdate())date and time the provider account was last edited.
Indexes TWstat_Provider_RecordingFormatDE_IDForeign Keys FK_Provider_RecordingFormatDE: [dbo].[Recording_Format_DE].RecordingFormatDERecordingFormatDE[dbo].[dict_id]5NOT NULL(0)Recording Format. Link to Recording_Format_DE.ID
Indexes TWstat_Provider_MedEducNumber_IDMedEducNumbervarchar(11)11NULL allowedMedical Education Number, Not used
Indexes TWstat_Provider_Specialty2DE_IDSpecialty2DE[dbo].[dict_id]5NULL allowedSecondary Specialty. Link to Specialty_DE.ID.
Indexes TWstat_Provider_PaIEnrollmentStatus_IDPaIEnrollmentStatuschar(1)1NOT NULL(' ')(Planned Administrators Incorporated) status
Indexes TWstat_Provider_PaIPreferredCommMethodPaIPreferredCommMethodchar(1)1NOT NULL(' ')Default communication method for PAI
Indexes TWstat_Provider_DistributionTypeDE_IDDistributionTypeDE[dbo].[dict_id]5NOT NULL(0)Link to dbo.distribution_type_de.id for Default CC Method
Indexes XAK2Provider, TWstat_Provider_OrgID(2)Foreign Keys FK_Provider_OrgID_Organization_ID: [dbo].[Organization].OrgIDOrgID[dbo].[dict_id]5NOT NULL(0)Organization. Link to Organization.ID
NPIchar(20)20NOT NULL('')Providers NPI number
Check Constraints CK_Provider_CCResultsWhenVerifiedBySomeoneElseFLAG_Yes_Or_No : ([CCResultsWhenVerifiedBySomeoneElseFLAG]='N' OR [CCResultsWhenVerifiedBySomeoneElseFLAG]='Y')CCResultsWhenVerifiedBySomeoneElseFLAG[dbo].[BOOL]1NOT NULL('N')Y/N (Do you want to be CC'd when other providers verify results that belong to you)
IsGenericProviderFlagchar(1)1NOT NULL('N')Is this a generic Provider (Y/N)?