Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Provider
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ProviderID | INTEGER | ? | MANDATORY | FK |
| LastName | CHAR(100) | MANDATORY | User entered last name of the provider. | |
| FirstName | CHAR(35) | MANDATORY | User entered first name of the provider. | |
| MiddleName | CHAR(35) | OPTIONAL | User entered middle name of provider. | |
| NameSuffix | CHARACTER(20) | OPTIONAL | User entered name suffix (e.g. Jr. , M.D. , etc.). | |
| SortName | CHAR(170) | MANDATORY | Programmatically set name for providing sorted name list. If class is person then sort name is last name, first name middle name. If class is company then the sort name is set to the entity name. | |
| SSN | CHARACTER(11) | OPTIONAL | User entered social security number of provider. | |
| FirstLanguage | CHARACTER(3) | OPTIONAL | User entered primary spoken language of the provider. | |
| SecondLanguage | CHARACTER(3) | OPTIONAL | User entered secondary spoken language of the provider. | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| ProviderType | CHARACTER(1) | MANDATORY | Defines the type of provider. Valid values are supported by the lookup type 'ProviderType'. | |
| MMUserSID | INTEGER | ? | OPTIONAL | System generated user id using the security sequence. |
| OmniDocProvider | LOGICAL | Logical_False | OPTIONAL | Deprecated. Indicates if the provider has access to OmniDoc. Possible values: True, False |
| UltiaProvider | LOGICAL | Logical_False | OPTIONAL | Indicates if the provider has access to ULTIA. Possible values: True False |
| EMRProvider | LOGICAL | Logical_False | OPTIONAL | Indicates if the provider is allowed to have work done for him in the WebMDEMR product. Value: True/False. Init = False |
| EncounterNoteProvider | LOGICAL | Logical_False | OPTIONAL | Indicates if the provider is allowed to have work done for him in the WebMDEMR Encounter Note product. Value: True/False. Init = False |
| RADProvider | LOGICAL | Logical_False | OPTIONAL | Indicates if the provider is allowed to use the Radiology Navigator product. Value: True/False. Init = False |
| EPCSProvider | LOGICAL | Logical_False | OPTIONAL | This flag indicates whether or not Provider may electronicallly issue prescriptions for controlled substances. It is updated by setting the EPCS flag in Provider maintenance for a given Provider. |
| TelehealthProvider | LOGICAL | Logical_False | OPTIONAL | Boolean to indicate whether the provider is Telehealth provider or not. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| MMUser | Provider.MMUserSID = MMUser.MMUserSID | RESTRICT if Provider exists |
| Entity | Provider.ProviderID = Entity.EntitySID | CASCADE if Provider exists |
| Child Table | Join Phrase | When deleting Provider record... |
|---|---|---|
| Patient | Patient.PrimaryCareProviderID = Provider.ProviderID | RESTRICT if Patient exists |
| LabOrderCopyToProvider | LabOrderCopyToProvider.ProviderID = Provider.ProviderID | CASCADE if LabOrderCopyToProvider exists |
| OBPregnancy | OBPregnancy.DeliveryProviderID = Provider.ProviderID | SET NULL if OBPregnancy exists |
| RxEligMedHistRequest | RxEligMedHistRequest.ProviderID = Provider.ProviderID | RESTRICT if RxEligMedHistRequest exists |
| PatientOrderSet | PatientOrderSet.ProviderID = Provider.ProviderID | RESTRICT if PatientOrderSet exists |
| Practice | Practice.GroupStaffID = Provider.ProviderID | RESTRICT if Practice exists |
| Staff | Staff.CreditedStaffID = Provider.ProviderID | RESTRICT if Staff exists |
| Staff | Staff.BillingOverrideStaffID = Provider.ProviderID | RESTRICT if Staff exists |
| InpatientVisit | InpatientVisit.ContactProviderID = Provider.ProviderID | RESTRICT if InpatientVisit exists |
| Referral | Referral.ToProviderID = Provider.ProviderID | RESTRICT if Referral exists |
| Referral | Referral.FromProviderID = Provider.ProviderID | RESTRICT if Referral exists |
| RefDoctor | RefDoctor.RefDoctorID = Provider.ProviderID | RESTRICT if RefDoctor exists |
| Staff | Staff.DefaultBillingProvider = Provider.ProviderID | NONE if Staff exists |
| Staff | Staff.DefaultSupervisor = Provider.ProviderID | RESTRICT if Staff exists |
| Staff | Staff.StaffID = Provider.ProviderID | RESTRICT if Staff exists |