HCHB_PHYSICIANS

14863 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ph_id int 4 null
ph_lastname varchar 50 null
ph_firstname varchar 50 √ null
ph_mi char 1 √ null
ph_notifyphone bit 1 null
ph_notifyfax bit 1 null
ph_pager varchar 20 √ null
ph_email varchar 50 √ null
ph_notifyemail bit 1 null
ph_notifyweb bit 1 null
ph_pcmid int 4 null
ph_title varchar 50 √ null
ph_degree varchar 25 √ null
ph_statelicense varchar 50 √ null
ph_licenseexpiration datetime 16,3 √ null
ph_licenseverification datetime 16,3 √ null
ph_medicaidnumber varchar 25 √ null
ph_UPIN varchar 50 √ null
ph_spid int 4 null
ph_pgid int 4 √ null
ph_active char 1 null
ph_irid int 4 √ null
ph_taxonomycode varchar 50 √ null
ph_SSN varchar 11 √ null
ph_EIN varchar 11 √ null
ph_insertdate datetime 16,3 null
ph_lastupdate datetime 16,3 null
ph_receiveemails char 1 √ null
ph_lastemailed datetime 16,3 √ null
ph_npi varchar 50 √ null
ph_wkrid int 4 √ null
ph_AllowPhysicianGroupToSignOrders char 1 null
ph_PECOSLastVerifiedDate datetime 16,3 √ null
ph_PECOSEnrollmentStatus int 4 √ null
ph_PECOSLastname varchar 50 √ null
ph_PECOSFirstName varchar 50 √ null
ph_ProviderLinkUser bit 1 null
ph_ProviderLinkLastLoginDate datetime 16,3 √ null
ph_override char 1 null
ph_AllowClinicalStaffReceiveNotifications bit 1 null
ph_RequirePasswordToSign bit 1 null
AVA_insert_date datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_HCHB_PHYSICIANS Primary key Asc ph_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors