Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| Physician_Id | int | 4 | null |
|
|
|||||
| Insert_Date | datetime | 16,3 | null |
|
|
|||||
| Insert_User | varchar | 50 | null |
|
|
|||||
| Last_Update_Date | datetime | 16,3 | null |
|
|
|||||
| Last_Update_User | varchar | 50 | null |
|
|
|||||
| Delete_Ind | bit | 1 | √ | null |
|
|
||||
| Population_Information_Id | int | 4 | null |
|
|
|||||
| Source_System_Id | int | 4 | √ | null |
|
|
||||
| LastName | varchar | 50 | null |
|
|
|||||
| FirstName | varchar | 50 | √ | null |
|
|
||||
| MiddleInitial | varchar | 1 | √ | null |
|
|
||||
| Specialty | varchar | 50 | √ | null |
|
|
||||
| Title | varchar | 25 | √ | null |
|
|
||||
| UPIN | varchar | 25 | √ | null |
|
|
||||
| LicenseNumber | varchar | 25 | √ | null |
|
|
||||
| Company | varchar | 50 | √ | null |
|
|
||||
| IsInactive | bit | 1 | null |
|
|
|||||
| NPI | char | 10 | √ | null |
|
|
||||
| EIN | char | 10 | √ | null |
|
|
||||
| SSN | varchar | 11 | null |
|
|
|||||
| HoldBills | bit | 1 | null |
|
|
|||||
| CreatedDate | datetime | 16,3 | null |
|
|
|||||
| NPIVerified | bit | 1 | null |
|
|
|||||
| MasterPhysician_ID | int | 4 | √ | null |
|
|
||||
| DoNotFax | bit | 1 | null |
|
|
|||||
| DoNotCall | bit | 1 | null |
|
|
Relationships
Close relationships within degrees of separation
