Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (39)![Foreign Keys FK_Provider_ID_Person_ID: [dbo].[Person].ID Foreign Keys FK_Provider_ID_Person_ID: [dbo].[Person].ID](../../../../Images/fk.png) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider Identifier. Link to Person.ID. |
(2)![Foreign Keys FK_Provider_ProviderTypeDE_Provider_Type_DE_ID: [dbo].[Provider_Type_DE].ProviderTypeDE Foreign Keys FK_Provider_ProviderTypeDE_Provider_Type_DE_ID: [dbo].[Provider_Type_DE].ProviderTypeDE](../../../../Images/fk.png) | ProviderTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Type. Link to Provider_Type_DE.ID |
 | PrimaryContactPersonID | [dbo].[uniqueid] | 9 | NOT NULL | | Not used. |
(2)![Foreign Keys FK_Provider_ResourceDE_Resource_DE_ID: [dbo].[Resource_DE].ResourceDE Foreign Keys FK_Provider_ResourceDE_Resource_DE_ID: [dbo].[Resource_DE].ResourceDE](../../../../Images/fk.png) | ResourceDE | [dbo].[dict_id] | 5 | NOT NULL | | Scheduling Resource. Link to dbo.Resource_De.id (for linking to a schedule) |
 ![Foreign Keys FK_Provider_PrimaryServiceDE_Service_DE_ID: [dbo].[Service_DE].PrimaryServiceDE Foreign Keys FK_Provider_PrimaryServiceDE_Service_DE_ID: [dbo].[Service_DE].PrimaryServiceDE](../../../../Images/fk.png) | PrimaryServiceDE | [dbo].[dict_id] | 5 | NOT NULL | | Proimary Service. Link to Service_DE.ID. |
 ![Foreign Keys FK_Provider_PrimaryOfficeDE_Location_DE_ID: [dbo].[Location_DE].PrimaryOfficeDE Foreign Keys FK_Provider_PrimaryOfficeDE_Location_DE_ID: [dbo].[Location_DE].PrimaryOfficeDE](../../../../Images/fk.png) | PrimaryOfficeDE | [dbo].[dict_id] | 5 | NOT NULL | | Primary scheduling location. Link to Location_DE.ID. |
(4)![Foreign Keys FK_Provider_SpecialtyDE_Specialty_DE_ID: [dbo].[Specialty_DE].SpecialtyDE Foreign Keys FK_Provider_SpecialtyDE_Specialty_DE_ID: [dbo].[Specialty_DE].SpecialtyDE](../../../../Images/fk.png) | SpecialtyDE | [dbo].[dict_id] | 5 | NOT NULL | | Specialty. Link to Specialty_DE.ID. |
| UPINNumber | varchar(20) | 20 | NOT NULL | | UPIN number |
 ![Check Constraints CK_Provider_IsPCPFLAG_Yes_Or_No : ([IsPCPFLAG]='N' OR [IsPCPFLAG]='Y') Check Constraints CK_Provider_IsPCPFLAG_Yes_Or_No : ([IsPCPFLAG]='N' OR [IsPCPFLAG]='Y')](../../../../Images/c-constraint.png) | IsPCPFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Primary Care Provider? Y/N |
 | EntryCode | char(16) | 16 | NOT NULL | | entry code |
 | EntryMnemonic | char(10) | 10 | NOT NULL | (' ') | mnemonic |
 | ProviderKeyEXT | varchar(15) | 15 | NOT NULL | (' ') | Not used. |
 | ExpirationDT | datetime | 8 | NULL allowed | | DEA 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. |
(3)![Check Constraints CK_Provider_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Provider_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | InActive? Y/N |
 | OrderingAuthorityDE | [dbo].[dict_id] | 5 | NULL allowed | | Ordering Authority. Link to dbo.Ordering_Authority_De.id |
 | DEANumber | varchar(30) | 30 | NOT NULL | (' ') | Providers DEA number |
 ![Check Constraints CK_Provider_DisableSendChargeFLAG_Yes_Or_No : ([DisableSendChargeFLAG]='N' OR [DisableSendChargeFLAG]='Y') Check Constraints CK_Provider_DisableSendChargeFLAG_Yes_Or_No : ([DisableSendChargeFLAG]='N' OR [DisableSendChargeFLAG]='Y')](../../../../Images/c-constraint.png) | DisableSendChargeFLAG | [dbo].[BOOL] | 1 | NOT 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. |
 ![Check Constraints CK_Provider_CompleteDictationTaskFLAG_Yes_Or_No : ([CompleteDictationTaskFLAG]='N' OR [CompleteDictationTaskFLAG]='Y') Check Constraints CK_Provider_CompleteDictationTaskFLAG_Yes_Or_No : ([CompleteDictationTaskFLAG]='N' OR [CompleteDictationTaskFLAG]='Y')](../../../../Images/c-constraint.png) | CompleteDictationTaskFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Y/N Receive a task if you create a marker in a note and haven't submitted a dictation against it yet. |
 | BillingProviderID | varchar(32) | 32 | NOT NULL | ('') | Used to hold the billing provider ID of the provider in the PM system |
 | ResourceID | varchar(32) | 32 | NOT NULL | ('') | No Longer Used |
(2)![Check Constraints CK_Provider_IsBillingProviderFLAG_Yes_Or_No : ([IsBillingProviderFLAG]='N' OR [IsBillingProviderFLAG]='Y') Check Constraints CK_Provider_IsBillingProviderFLAG_Yes_Or_No : ([IsBillingProviderFLAG]='N' OR [IsBillingProviderFLAG]='Y')](../../../../Images/c-constraint.png) | IsBillingProviderFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Billing Provider? Y/N |
 | RXAuthorityDE | [dbo].[dict_id] | 5 | NULL allowed | | Prescribing Authority Level. Link to dbo.Rx_Authority_De.id |
 | V4OrderingAuthority | int | 4 | NULL allowed | (1) | 0 (low) to 10 (high) rating to control what kind of orders a provider can order. |
(3) | SecuritycodeDE | [dbo].[dict_id] | 5 | NOT 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. |
(2) | OutboundDictateID | varchar(12) | 12 | NULL allowed | | A unique ID given to providers who dictate. It provides a way for external transcription/dictation systems to map to. |
 | CMEPilotNumber | varchar(10) | 10 | NULL allowed | | Not used. |
 ![Check Constraints CK_Provider_SCHED_C_I_IND_Yes_Or_No : ([SCHED_C_I_IND]='N' OR [SCHED_C_I_IND]='Y') Check Constraints CK_Provider_SCHED_C_I_IND_Yes_Or_No : ([SCHED_C_I_IND]='N' OR [SCHED_C_I_IND]='Y')](../../../../Images/c-constraint.png) | SCHED_C_I_IND | char(1) | 1 | NOT NULL | ('N') | Can the provider prescribe schedule I meds |
 ![Check Constraints CK_Provider_SCHED_C_II_IND_Yes_Or_No : ([SCHED_C_II_IND]='N' OR [SCHED_C_II_IND]='Y') Check Constraints CK_Provider_SCHED_C_II_IND_Yes_Or_No : ([SCHED_C_II_IND]='N' OR [SCHED_C_II_IND]='Y')](../../../../Images/c-constraint.png) | SCHED_C_II_IND | char(1) | 1 | NOT NULL | ('N') | Can the provider prescribe schedule II meds |
 ![Check Constraints CK_Provider_SCHED_C_III_IND_Yes_Or_No : ([SCHED_C_III_IND]='N' OR [SCHED_C_III_IND]='Y') Check Constraints CK_Provider_SCHED_C_III_IND_Yes_Or_No : ([SCHED_C_III_IND]='N' OR [SCHED_C_III_IND]='Y')](../../../../Images/c-constraint.png) | SCHED_C_III_IND | char(1) | 1 | NOT NULL | ('N') | Can the provider prescribe schedule III meds |
 ![Check Constraints CK_Provider_SCHED_C_IV_IND_Yes_Or_No : ([SCHED_C_IV_IND]='N' OR [SCHED_C_IV_IND]='Y') Check Constraints CK_Provider_SCHED_C_IV_IND_Yes_Or_No : ([SCHED_C_IV_IND]='N' OR [SCHED_C_IV_IND]='Y')](../../../../Images/c-constraint.png) | SCHED_C_IV_IND | char(1) | 1 | NOT NULL | ('N') | Can the provider prescribe schedule IV meds |
 ![Check Constraints CK_Provider_SCHED_C_V_IND_Yes_Or_No : ([SCHED_C_V_IND]='N' OR [SCHED_C_V_IND]='Y') Check Constraints CK_Provider_SCHED_C_V_IND_Yes_Or_No : ([SCHED_C_V_IND]='N' OR [SCHED_C_V_IND]='Y')](../../../../Images/c-constraint.png) | SCHED_C_V_IND | char(1) | 1 | NOT NULL | ('N') | Can the provider prescribe schedule V meds |
 ![Check Constraints CK_Provider_ClinicalMsgFLAG_Yes_Or_No : ([ClinicalMsgFLAG]='N' OR [ClinicalMsgFLAG]='Y') Check Constraints CK_Provider_ClinicalMsgFLAG_Yes_Or_No : ([ClinicalMsgFLAG]='N' OR [ClinicalMsgFLAG]='Y')](../../../../Images/c-constraint.png) | ClinicalMsgFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('Y') | Y/N |
 ![Check Constraints CK_Provider_RxSupervisionRequired_Yes_Or_No : ([RxSupervisionRequired]='N' OR [RxSupervisionRequired]='Y') Check Constraints CK_Provider_RxSupervisionRequired_Yes_Or_No : ([RxSupervisionRequired]='N' OR [RxSupervisionRequired]='Y')](../../../../Images/c-constraint.png) | RxSupervisionRequired | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Prescibing Supervision required? Y/N |
 | DifficultyFactor | numeric(2,1) | 5 | NULL 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. |
 | AlternateLicense | varchar(30) | 30 | NULL allowed | | Alternate License |
(2) | LastEditedDTTM | datetime | 8 | NULL allowed | (getdate()) | date and time the provider account was last edited. |
 ![Foreign Keys FK_Provider_RecordingFormatDE: [dbo].[Recording_Format_DE].RecordingFormatDE Foreign Keys FK_Provider_RecordingFormatDE: [dbo].[Recording_Format_DE].RecordingFormatDE](../../../../Images/fk.png) | RecordingFormatDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Recording Format. Link to Recording_Format_DE.ID |
 | MedEducNumber | varchar(11) | 11 | NULL allowed | | Medical Education Number, Not used |
 | Specialty2DE | [dbo].[dict_id] | 5 | NULL allowed | | Secondary Specialty. Link to Specialty_DE.ID. |
 | PaIEnrollmentStatus | char(1) | 1 | NOT NULL | (' ') | (Planned Administrators Incorporated) status |
 | PaIPreferredCommMethod | char(1) | 1 | NOT NULL | (' ') | Default communication method for PAI |
 | DistributionTypeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Link to dbo.distribution_type_de.id for Default CC Method |
(2)![Foreign Keys FK_Provider_OrgID_Organization_ID: [dbo].[Organization].OrgID Foreign Keys FK_Provider_OrgID_Organization_ID: [dbo].[Organization].OrgID](../../../../Images/fk.png) | OrgID | [dbo].[dict_id] | 5 | NOT NULL | (0) | Organization. Link to Organization.ID |
| NPI | char(20) | 20 | NOT NULL | ('') | Providers NPI number |
![Check Constraints CK_Provider_CCResultsWhenVerifiedBySomeoneElseFLAG_Yes_Or_No : ([CCResultsWhenVerifiedBySomeoneElseFLAG]='N' OR [CCResultsWhenVerifiedBySomeoneElseFLAG]='Y') Check Constraints CK_Provider_CCResultsWhenVerifiedBySomeoneElseFLAG_Yes_Or_No : ([CCResultsWhenVerifiedBySomeoneElseFLAG]='N' OR [CCResultsWhenVerifiedBySomeoneElseFLAG]='Y')](../../../../Images/c-constraint.png) | CCResultsWhenVerifiedBySomeoneElseFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Y/N (Do you want to be CC'd when other providers verify results that belong to you) |
| IsGenericProviderFlag | char(1) | 1 | NOT NULL | ('N') | Is this a generic Provider (Y/N)? |