Documentation/EHI_Export/docs/tables/users.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
| amendments.created_by | Defined in XML | R | | amendments.modified_by | Defined in XML | R | | amendments_history.created_by | Defined in XML | R | | ar_activity.post_user | Defined in XML | R | | ar_session.user_id | Defined in XML | R | | billing.user | Defined in XML | R | | care_team.created_by | Defined in XML | R | | care_team.updated_by | Defined in XML | R | | care_team_member.contact_id | Defined in XML | R | | care_team_member.created_by | Defined in XML | R | | care_team_member.updated_by | Defined in XML | R | | care_team_member.user_id | Defined in XML | R | | contact_address.created_by | Defined in XML | R | | contact_address.updated_by | Defined in XML | R | | contact_relation.created_by | Defined in XML | R | | contact_relation.updated_by | Defined in XML | R | | documents.owner | Defined in XML | R | | drug_sales.created_by | Defined in XML | R | | drug_sales.updated_by | Defined in XML | R | | ehi_export_job.user_id | FK_ehi_export_job_users | R | | employer_data.created_by | Defined in XML | R | | esign_signatures.uid | Defined in XML | R | | form_groups_encounter.provider_id | Defined in XML | R | | form_groups_encounter.supervisor_id | Defined in XML | R | | form_history_sdoh.created_by | Defined in XML | R | | form_history_sdoh.updated_by | Defined in XML | R | | form_history_sdoh_health_concerns.created_by | Defined in XML | R | | forms.provider_id | Defined in XML | R | | history_data.created_by | Defined in XML | R | | immunization_observation.imo_user | Defined in XML | R | | immunizations.administered_by_id | Defined in XML | R | | immunizations.created_by | Defined in XML | R | | immunizations.ordering_provider | Defined in XML | R | | immunizations.updated_by | Defined in XML | R | | issue_encounter.created_by | Defined in XML | R | | issue_encounter.updated_by | Defined in XML | R | | lists_medication.created_by | Defined in XML | R | | lists_medication.reporting_source_record_id | Defined in XML | R | | medex_recalls.r_provider | Defined in XML | R | | notes.owner | Defined in XML | R | | onsite_documents.user | Defined in XML | R | | form_gad7.user | Defined in XML | R | | form_painmap.user | Defined in XML | R | | form_phq9.user | Defined in XML | R | | form_sdoh.user | Defined in XML | R | | form_treatment_plan.user | Defined in XML | R | | openemr_postcalendar_events.pc_aid | Defined in XML | R | | openemr_postcalendar_events.pc_informant | Defined in XML | R | | patient_data.advance_directive_user_authenticator | Defined in XML | R | | patient_data.created_by | Defined in XML | R | | patient_data.providerID | Defined in XML | R | | patient_data.ref_providerID | Defined in XML | R | | patient_data.updated_by | Defined in XML | R | | patient_history.created_by | Defined in XML | R | | person.created_by | Defined in XML | R | | person.updated_by | Defined in XML | R | | person_patient_link.linked_by | Defined in XML | R | | person_patient_link.person_id | Defined in XML | R | | pnotes.assigned_to | Defined in XML | R | | pnotes.update_by | Defined in XML | R | | pnotes.user | Defined in XML | R | | prescriptions.created_by | Defined in XML | R | | prescriptions.provider_id | Defined in XML | R | | prescriptions.updated_by | Defined in XML | R | | pro_assessments.user_id | Defined in XML | R | | procedure_order.collector_id | Defined in XML | R | | procedure_order.provider_id | Defined in XML | R | | procedure_report.source | Defined in XML | R | | procedure_specimen.created_by | Defined in XML | R | | procedure_specimen.updated_by | Defined in XML | R | | questionnaire_response.audit_user_id | Defined in XML | R | | questionnaire_response.creator_user_id | Defined in XML | R | | shared_attributes.user_id | Defined in XML | R | | therapy_groups_counselors.user_id | Defined in XML | R | | voids.user_id | Defined in XML | R |
|
|
Unique identifier for each user in the system.
| | uuid | BINARY | 16 | √ | | NULL |
|
|
Universally unique identifier for the user.
| | username | VARCHAR | 255 | √ | | NULL |
| clinical_notes_documents.created_by | Defined in XML | R | | clinical_notes_procedure_results.created_by | Defined in XML | R | | form_CAMOS_category.user | Defined in XML | R | | form_CAMOS_item.user | Defined in XML | R | | form_group_attendance.user | Defined in XML | R | | form_history_sdoh.assessor | Defined in XML | R | | form_questionnaire_assessments.user | Defined in XML | R | | form_vitals.user | Defined in XML | R | | forms.user | Defined in XML | R | | groups.user | Defined in XML | R | | lists.user | Defined in XML | R | | form_aftercare_plan.user | Defined in XML | R | | form_ankleinjury.user | Defined in XML | R | | form_bronchitis.user | Defined in XML | R | | patient_tracker.original_user | Defined in XML | R | | patient_tracker_element.user | Defined in XML | R |
|
|
The username associated with the user’s account.
| | password | LONGTEXT | 2147483647 | √ | | NULL |
|
|
The password for the user’s account.
| | authorized | TINYINT | 3 | √ | | NULL |
|
|
Indicates whether the user is authorized (1 for authorized, 0 for unauthorized).
| | info | LONGTEXT | 2147483647 | √ | | NULL |
|
|
Additional information or notes about the user.
| | source | TINYINT | 3 | √ | | NULL |
|
|
An indicator of the source of the user (e.g., internal or external).
| | fname | VARCHAR | 255 | √ | | NULL |
|
|
First name of the user.
| | mname | VARCHAR | 255 | √ | | NULL |
|
|
Middle name of the user.
| | lname | VARCHAR | 255 | √ | | NULL |
|
|
Last name of the user.
| | suffix | VARCHAR | 255 | √ | | NULL |
|
|
Suffix for the user’s name (e.g., Jr., Sr.).
| | federaltaxid | VARCHAR | 255 | √ | | NULL |
|
|
Federal Tax ID associated with the user.
| | federaldrugid | VARCHAR | 255 | √ | | NULL |
|
|
Federal Drug ID associated with the user.
| | upin | VARCHAR | 255 | √ | | NULL |
|
|
Universal Physician Identification Number for the user.
| | facility | VARCHAR | 255 | √ | | NULL |
|
|
The facility where the user is associated.
| | facility_id | INT | 10 | | | 0 |
|
| facility.id | Defined in XML | R |
|
Unique identifier for the user’s associated facility.
| | see_auth | INT | 10 | | | 1 |
|
|
Indicates if the user has the ability to see authorizations.
| | active | BOOLEAN | 3 | | | 1 |
|
|
Indicates the user’s activity status (1 for active, 0 for inactive).
| | npi | VARCHAR | 15 | √ | | NULL |
|
|
National Provider Identifier for the user.
| | title | VARCHAR | 30 | √ | | NULL |
|
|
Title or designation of the user (e.g., MD, RN).
| | specialty | VARCHAR | 255 | √ | | NULL |
|
|
The specialty of the user (e.g., cardiology, pediatrics).
| | billname | VARCHAR | 255 | √ | | NULL |
|
|
Billing name for the user.
| | email | VARCHAR | 255 | √ | | NULL |
|
|
Email address associated with the user’s account. EMPTY for exports
| | email_direct | VARCHAR | 255 | | | '' |
|
|
Trusted Direct email address for the user.
| | google_signin_email | VARCHAR | 255 | √ | | NULL |
|
|
Email address for Google Sign-In (if applicable). EMPTY for exports
| | url | VARCHAR | 255 | √ | | NULL |
|
|
URL associated with the user’s profile.
| | assistant | VARCHAR | 255 | √ | | NULL |
|
|
Name of the user’s assistant or support staff.
| | organization | VARCHAR | 255 | √ | | NULL |
|
|
Name of the user’s organization or practice.
| | valedictory | VARCHAR | 255 | √ | | NULL |
|
|
Valedictory or honorary title of the user.
| | street | VARCHAR | 60 | √ | | NULL |
|
|
Street address for the user. EMPTY for exports
| | streetb | VARCHAR | 60 | √ | | NULL |
|
|
Secondary street address for the user. EMPTY for exports
| | city | VARCHAR | 30 | √ | | NULL |
|
|
City of residence or practice for the user. EMPTY for exports
| | state | VARCHAR | 30 | √ | | NULL |
|
|
State or province of residence or practice for the user. EMPTY for exports
| | zip | VARCHAR | 20 | √ | | NULL |
|
|
ZIP code or postal code for the user. EMPTY for exports
| | street2 | VARCHAR | 60 | √ | | NULL |
|
|
Alternative street address for the user. EMPTY for exports
| | streetb2 | VARCHAR | 60 | √ | | NULL |
|
|
Alternative street address for the user. EMPTY for exports
| | city2 | VARCHAR | 30 | √ | | NULL |
|
|
Alternative City of residence or practice for the user. EMPTY for exports
| | state2 | VARCHAR | 30 | √ | | NULL |
|
|
Alternative State or province of residence or practice for the user. EMPTY for exports
| | zip2 | VARCHAR | 20 | √ | | NULL |
|
|
Alternative ZIP code or postal code for the user. EMPTY for exports
| | phone | VARCHAR | 30 | √ | | NULL |
|
|
Phone number for the user. EMPTY for exports
| | fax | VARCHAR | 30 | √ | | NULL |
|
|
Fax number for the user. EMPTY for exports
| | phonew1 | VARCHAR | 30 | √ | | NULL |
|
|
Work phone number for the user.
| | phonew2 | VARCHAR | 30 | √ | | NULL |
|
|
Alternative Work phone number for the user.
| | phonecell | VARCHAR | 30 | √ | | NULL |
|
|
Cell phone number for the user. EMPTY for exports
| | notes | TEXT | 65535 | √ | | NULL |
|
|
Additional notes or comments about the user. EMPTY for exports
| | cal_ui | TINYINT | 3 | | | 1 |
|
|
UNUSED
| | taxonomy | VARCHAR | 30 | | | '207Q00000X' |
|
|
Taxonomy code associated with the user.
| | calendar | BOOLEAN | 3 | | | 0 |
|
|
Indicates whether the user appears in the calendar (1 for appears, 0 for doesn’t appear).
| | abook_type | VARCHAR | 31 | | | '' |
|
|
Address book type for the user.
| | default_warehouse | VARCHAR | 31 | | | '' |
|
|
Default warehouse for the user.
| | irnpool | VARCHAR | 31 | | | '' |
|
|
IRN (Insurance Referral Network) pool for the user.
| | state_license_number | VARCHAR | 25 | √ | | NULL |
|
|
State license number for the user.
| | weno_prov_id | VARCHAR | 15 | √ | | NULL |
|
|
WENO Provider ID for the user. EMPTY for exports
| | newcrop_user_role | VARCHAR | 30 | √ | | NULL |
|
|
Ensora user role for the user.EMPTY for exports
| | cpoe | BOOLEAN | 3 | √ | | NULL |
|
|
Indicates whether the user has CPOE (Computerized Physician Order Entry) capabilities.
| | physician_type | VARCHAR | 50 | √ | | NULL |
|
|
Type or designation of the physician (e.g., standard, specialist).
| | main_menu_role | VARCHAR | 50 | | | 'standard' |
|
|
Main menu role for the user. EMPTY for exports
| | patient_menu_role | VARCHAR | 50 | | | 'standard' |
|
|
Patient menu role for the user. EMPTY for exports
| | portal_user | BOOLEAN | 3 | | | 0 |
|
|
Indicates if the user is a portal user (1 for portal user, 0 for non-portal user). EMPTY for exports
| | supervisor_id | INT | 10 | | | 0 |
|
|
Unique identifier of the user’s supervisor. EMPTY for exports
| | billing_facility | TEXT | 65535 | √ | | NULL |
|
|
Billing facility information for the user.
| | billing_facility_id | INT | 10 | | | 0 |
|
| facility.id | Defined in XML | R |
|
Unique identifier for the user’s billing facility.
| | date_created | DATETIME | 19 | | | current_timestamp() |
|
| | | last_updated | DATETIME | 19 | | | current_timestamp() |
|
| | | country_code | VARCHAR | 255 | √ | | NULL |
|
|
ISO 3166-1 alpha-2 country code for address but can take entire country name for now
| | country_code2 | VARCHAR | 255 | √ | | NULL |
|
|
ISO 3166-1 alpha-2 country code for address but can take entire country name for now
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| abook_type | Performance | Asc | abook_type |
| google_signin_email | Must be unique | Asc | google_signin_email |
| uuid | Must be unique | Asc | uuid |