The PHYSICIANINFO table stores information related to configured physician user accounts. The PHYSICIANINFO table is located in DBSpace8.
Column Name | Data Type | Description |
---|---|---|
usernum | bigint |
The internal unique identifier of the user account; a foreign key to the USERACCOUNT table. |
fullphysname | char(50) | The physician’s full name. |
physnumber | char(20) | The configured physician number. |
upinn | char(20) | Not implemented. |
statelicnumber | char(20) |
The number of the state license associated with the physician. |
address1 | char(80) |
Physician’s address. |
address2 | char(80) | Physician’s address. |
char(80) | Physician’s email address. | |
faxnum | char(30) | Physician’s fax number. |
signphysname | char(50) | The physician’s name as displayed on signature deficiencies. |
flags | bigint |
Flags related to physician settings; 1 = Secondary Signer. |
defdisplaysec | bigint |
The number of seconds a deficiency is displayed in slideshow (auto play) mode. |
physspecialty | char(50) | Physician specialty information from an external system. |
onhold | bigint |
Flag to determine if the physician is on hold; 1 = On Hold. |
lastpolltime | datetime |
Used for external integrations to store the last time the physician’s deficiencies were polled. |
mtprovmnemonic | char(15) | The Meditech provider mnemonic for the physician. |
provspecialtynum | bigint |
The internal unique identifier used to associate the physician with a specialty; a foreign key to the PROVIDERSPECIALTY table. |
lastname | char(50) |
The physician’s last name. |
firstname | char(50) | The physician’s first name. |
middlename | char(50) | The physician’s middle name. |
nameprefix | char(10) | The prefix of the physician’s name. |
namesuffix | char(50) | The suffix of the physician’s name. |
physdegree | char(50) | The physician’s academic degree. |
The indexes for the COMPLETEDCHTDFCY table are located in DBSpace8.
Index Name | Included columns |
---|---|
physicianinfo1 | usernum |